Subject RE: [ib-support] RequestLive on IBX
Author Don Schoeman
Thanks for the information,

I've never used the FOR UPDATE statement before but I quickly tried it out
like this:

SELECT * FROM company
FOR UPDATE OF company_no

I'm not sure if this is correct since the query does execute but an empty
result set is returned without any fields.

The IB help on FOR UPDATE is a bit vague.


-----Original Message-----
From: Svein Erling Tysvar
Sent: Friday, March 23, 2001 10:37 AM
Subject: Re: [ib-support] RequestLive on IBX

Yes, IBO components have a RequestLive property. But even though I believe
IBO to be far better than IBX, I doubt RequestLive is a reason to change -
adding FOR UPDATE at the end of your SQL statement ought to make your query
live (provided it isn't a joined query).


At 09:55 23.03.2001 +0200, you wrote:
>This question is more related to the Delphi IBX component set than to
>The TQuery Delphi component contains a property called RequestLive which
>returns an updateable query result set from the database. This is very
>when using Database aware components in Delphi since the data can be edited
>and updated automatically and saves us from having to update all the
>controls manually. A similar result can be achieved by using the TIBTable
>IBX component but obviously this is only acceptable on small tables.
>Is there any other way I can achieve this? Does IBO support this
>Best Regards,
>Don Schoeman

To unsubscribe from this group, send an email to:

Your use of Yahoo! Groups is subject to