I have tried running the query using my application (via IBX) and IBConsole
and I still get an empty result set. I am now busy looking at the IBObjects
web page and so far it seems promising. IBO is very expensive due to our bad
currency rate (Rand) but it might be worth it converting to IBO.

-Don




-----Original Message-----
From: Svein Erling Tysvar
[mailto:svein.erling.tysvaer@...]
Sent: Friday, March 23, 2001 12:15 PM
To: ib-support@yahoogroups.com
Subject: RE: [ib-support] RequestLive on IBX


Don,
you use FOR UPDATE correctly. The OF part is optional and there's nothing
more to it (so there's not much to explain). If company exists in your
database it should get back all the records of your that table.

Set

At 10:58 23.03.2001 +0200, you wrote:

>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

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/