Subject | [IBO] Assigning SQLWhere error |
---|---|
Author | Paul Hope |
Post date | 2004-04-21T16:51:25Z |
Hi
Version 4.3Aa
I have a TIB_Query with sql text 'update DO_HEADER d set
d.STATUS=bin_or(d.STATUS,4096)'
I do a MyQuery.SQLWhere.Assign(MySQLWhereStrings) and I get
where d.company='A'
and d.order_number<=:MAXDOC
and d.order_number>=:MINDOC
and BIN_AND(D.STATUS,4096) = 0
update DO_HEADER d set d.STATUS=bin_or(d.STATUS,4096)
:-(
Didn't this - or something like it come up a long time ago?
I've had a look at the source but its too complicated for my old brain.
Regards
Paul
[Non-text portions of this message have been removed]
Version 4.3Aa
I have a TIB_Query with sql text 'update DO_HEADER d set
d.STATUS=bin_or(d.STATUS,4096)'
I do a MyQuery.SQLWhere.Assign(MySQLWhereStrings) and I get
where d.company='A'
and d.order_number<=:MAXDOC
and d.order_number>=:MINDOC
and BIN_AND(D.STATUS,4096) = 0
update DO_HEADER d set d.STATUS=bin_or(d.STATUS,4096)
:-(
Didn't this - or something like it come up a long time ago?
I've had a look at the source but its too complicated for my old brain.
Regards
Paul
[Non-text portions of this message have been removed]