Subject [IBO] Assigning SQLWhere error
Author Paul Hope
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]