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.

-Don


-----Original Message-----
From: Svein Erling Tysvar
[mailto:svein.erling.tysvaer@...]
Sent: Friday, March 23, 2001 10:37 AM
To: ib-support@yahoogroups.com
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).

Set

At 09:55 23.03.2001 +0200, you wrote:

>This question is more related to the Delphi IBX component set than to
>Interbase:
>
>The TQuery Delphi component contains a property called RequestLive which
>returns an updateable query result set from the database. This is very

handy

>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
>functionality?
>
>Best Regards,
>Don Schoeman

To unsubscribe from this group, send an email to:
ib-support-unsubscribe@egroups.com



Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/