On Mon, 12 Apr 2004 13:30:15 +0000 (UTC), Mark Lawes wrote:

> I am having a look at IB Objects via the demo download, mostly for
> interest sake. I am hoping someone can explain why the following
> behaviour occurs. Apologies in advance if this is a stupid question.
> I am using a DSQL component to run a singleton query which will return
> the key of a row if a given field matches my input parameter. All the
> prerequisites like connecting to the database have been performed.
> The sql for the DSQL component looks like this:-
> SELECT OBJID FROM TABLE_ACCOUNTS WHERE ACCOUNT_NAME = :NEWNAME

The DSQL component isn't intented for SELECTs - use it for
UPDATE/INSERT/DELETE, even though it works fine when exactly one row is
returned.
Use a cursor component for SELECT.


--
Aage J.