Subject RE: [ib-support] RequestLive on IBX
Author Don Schoeman
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.


-----Original Message-----
From: Svein Erling Tysvar
Sent: Friday, March 23, 2001 12:15 PM
Subject: RE: [ib-support] RequestLive on IBX

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.


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.

To unsubscribe from this group, send an email to:

Your use of Yahoo! Groups is subject to