Hello group,

This is the first time we have run a certain process since upgrading to V8.
I'm getting the following error 
LIKE clause only accepts constant with TEXT or NOTE (2442)
I believe it is happening on the following line
COMPUTE vTotalInvoice AS SUM WorkOrderCharge FROM InvoiceDetail WHERE +
   InvoiceID = .vInvoiceID AND WorkOrderEventID LIKE '1012%'

WorkOrderEventID is Type INTEGER but this process has worked in the past.

I'm going to the clause to an IN to see if it works any better.

Jan

Reply via email to