I juggled the sequence around.. I try to use it 3 times.. no matter what the
sequence, I only get one use out of it..
I imagine that the parameter value is set only once in IBO..
Is here any way to set the other ones?
Alan

-----Original Message-----
From: Alan McDonald [mailto:alan@...]
Sent: Thursday, 27 March 2003 12:11 PM
To: IBObjects@yahoogroups.com
Subject: [IBO] Update SQL question


sorry - too fast on the keyboard...

I have an update statement which is trying to do the following

UPDATE TBLBSLIST SET
BSREQIND = :BSREQIND, /*PK*/
LINKTOPROJ = (SELECT LINKTOPROJ FROM TBLJOBSCHEDULE WHERE
TBLJOBSCHEDULE.JOBIND=:LINKTOJOBSCHED),
LINKTOWO = (SELECT LINKTOBSAWWO FROM TBLJOBSCHEDULE WHERE
TBLJOBSCHEDULE.JOBIND=:LINKTOJOBSCHED),
BSNO = :BSNO,
LINKTOSLAB = :LINKTOSLAB,
etc

the result is that the first LINTOPROJ value is set correctly, but it apears
as though the second use of the parameter :LINKTOJOBSCHED is NULL.
Is this supposed to happen, i.e. a parameter is cleared to null after it's
first use?
Is this IBO or the engine?

Alan




___________________________________________________________________________
IB Objects - direct, complete, custom connectivity to Firebird or InterBase
without the need for BDE, ODBC or any other layer.
___________________________________________________________________________
http://www.ibobjects.com - your IBO community resource for Tech Info papers,
keyword-searchable FAQ, community code contributions and more !

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