TIBQuery has no RequestLive property
Dale Francis
I am just getting started with IBX and I have a very basic question.
The TQuery component in Delphi 5 offers a RequestLive property so that you
can return a "live" query result for data control editing in an edit window.
I noticed, however, that the TIBQuery component - the Interbase
counterpart - has no RequestLive property.
How then do you return a live query result for editing?
Does this have something to do with the TIBUpdateSQL component? Here's what
I tried:
I associated a TIBUpdateSQL component with my TIBQuery component. I
right-clicked on the new TIBQuery component, chose "UpdateSQL Editor..."
from the pop-up, selected 3 key fields, and generated the SQL for the
UpdateSQL, InsertSQL, and DeleteSQL properties of the TIBUpdateSQL
component. At runtime, this allowed my cursor to enter an edit control but
not to change the data.
I guess my real question is this: How do I present a simple window with
data aware edit controls for editing? (... using the TIBQuery component and
not relying on the BDE.)
Thanks.
- Dale F.
Jeff Overcash (TeamB)
Dale Francis wrote:
>
> Hello, newsgroup.
>
> I am just getting started with IBX and I have a very basic question.
>
> The TQuery component in Delphi 5 offers a RequestLive property so that you
> can return a "live" query result for data control editing in an edit window.
>
> I noticed, however, that the TIBQuery component - the Interbase
> counterpart - has no RequestLive property.
>
IBQuery is a read only component.
> How then do you return a live query result for editing?
>
You attach a TIBUpdateSQL component to it. fill out the 4 SQL statements. It
is now a live query.
> Does this have something to do with the TIBUpdateSQL component? Here's what
> I tried:
>
> I associated a TIBUpdateSQL component with my TIBQuery component. I
> right-clicked on the new TIBQuery component, chose "UpdateSQL Editor..."
There is not a popup menu items like that for IBQuery, only for IBUpdateSQL.
> from the pop-up, selected 3 key fields, and generated the SQL for the
> UpdateSQL, InsertSQL, and DeleteSQL properties of the TIBUpdateSQL
> component. At runtime, this allowed my cursor to enter an edit control but
> not to change the data.
>
Is your Datasource set for AutoEdit? This should be all you have to do. you
might want to double check that the IBQuery's UpdateObject points to your
IBUpdateSQL object.
> I guess my real question is this: How do I present a simple window with
> data aware edit controls for editing? (... using the TIBQuery component and
> not relying on the BDE.)
>
Personally I use IBDataset for editable queries. Everything is self contained.
> Thanks.
>
> - Dale F.
--
Jeff Overcash (TeamB)
(Please do not email me directly unless asked. Thank You)
The fool escaped from paradise will look over his shoulder and cry
Sit and chew on daffodils and struggle to answer why?
As you grow up and leave the playground
Where you kissed your Prince and found your frog
Remember the jester that showed you tears, the script for tears. (Fish)
Dale Francis
Is there an example somewhere of a very simple application that uses IBX
controls? I've never seen one and I suspect that this would be very
helpful.
- DmF.
"Jeff Overcash (TeamB)" <over...@onramp.net> wrote in message
news:39D9FBA9...@onramp.net...
Jeff Overcash (TeamB)
To commit a transaction you call Commit or CommitRetaining from the
IBTransaction of that Dataset.
Dale Francis wrote:
>
> I think my problem is in figuring out how to commit the transaction.
>
> Is there an example somewhere of a very simple application that uses IBX
> controls? I've never seen one and I suspect that this would be very
> helpful.
>
> - DmF.
>
--
John Huntjens
>can return a "live" query result for data control editing in an edit
window.
>
>I noticed, however, that the TIBQuery component - the Interbase
>counterpart - has no RequestLive property.
Do not use a TQuery, its a decendant from TIBCustomDataset,.
TIBCustomDataset has already Update, Delete and Insert query propertys, so
using TIBQuery + TUpdateSQL is a waste of resources.
Use TIBDataset instead.
John