Title: Referencing columns in query
I HAVE A query where I compare columns as part of the query. See below.
This worked before but not now.

Is there something I need to do differently? Thanks.

Mark Weiss





[Query]
[197]
 SELECT W1.WIPartNumber,I2.iDescr,W1.WIOnHand,W1.WIMin,W1.WIOurOnOrder,W1.WIMax,I2.iVenderNumber,V3.vendorname,W1.WILocation FROM common.WorkingInventory W1,common.Inventory I2,common.Vendor V3 WHERE

(
W1.WIOnHand<W1.WIMin     

(THIS above WORKED ON T3 AND T4 BUT NOT ON T5.IS THIS A DRIVER PROBLEM?

PRIMEBASE LATEST VERSION  OSX WITANGO 5.5 RUNNING OS PANTHER SERVER



 AND W1.WIPrincNumber=? AND I2.iactiveInactive=? AND W1.WIOnHand>0) AND ((I2.iItem=W1.WIPartNumber) AND (V3.vendornumber=I2.iVenderNumber)) ORDER BY V3.vendorname ASC

[BoundVals]
[197]
 [v1='522222'; v2='A']
________________________________________________________________________
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf

Reply via email to