Subject | RE: [IBO] Update SQL question |
---|---|
Author | Alan McDonald |
Post date | 2003-03-27T02:55:46Z |
Helen,
statement and IBO is kindly building me an update statement which includes
linktojobsched = :linktojobsched
fine.
Now I want to edit this update statement in the UpdateSQL window to include
the same parameter a second time so it says
update table set
, linktojobsched = :linktojobsched
, anotherfield = :linktojobsched
where etc...
Unfortunately, the first field gets updated correctly but the second gets a
null. I was just hoping that the second would get the same parameter
assignment, but it doesn't. I suspect the engine in this really since the
statement is passed with parameter markers and then the parameters are
passed and the first match is successful - the second match is not found or
assigned.
where (what event) might be a place to assign a linktojobsched2 parameter
value?
Alan
>It isn't clear from your statement where you are getting your parameterI'm using TIB_Query. I'm selecting the field linktojobsched in the select
>values from.
statement and IBO is kindly building me an update statement which includes
linktojobsched = :linktojobsched
fine.
Now I want to edit this update statement in the UpdateSQL window to include
the same parameter a second time so it says
update table set
, linktojobsched = :linktojobsched
, anotherfield = :linktojobsched
where etc...
Unfortunately, the first field gets updated correctly but the second gets a
null. I was just hoping that the second would get the same parameter
assignment, but it doesn't. I suspect the engine in this really since the
statement is passed with parameter markers and then the parameters are
passed and the first match is successful - the second match is not found or
assigned.
where (what event) might be a place to assign a linktojobsched2 parameter
value?
Alan