Jan, Have you checked your MANY setting?
Dawn Hast "jan johansen" <[EMAIL PROTECTED]> wrote on 03/31/2008 12:22:52 PM: > 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
