Glad it helped Jan, especially as I don't think much of what I say here is ever very helpful; still glad to be here and be a part, though.
Anyway, your comment about LIKE and its success with DATE, TIME, DATETIME comparisons makes me think that there is probably an internal CAST of the actual value, based on the current FORMAT settings for these 3 types. That's just a (semi-educated) guess, as I've not looked at any low-level source in some time and I've never seen any of RB's codebase. Again, glad it worked because you've made my day. Thank You, Steve in Memphis From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of jan johansen Sent: Monday, March 31, 2008 11:47 AM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: LIKE Steve, That worked! I do know that as R:Base matures there are some items that get 'tightened up'. This may have been one of them. The help file states 'True if a column value equals the text string. With LIKE, a string can also be a DATE,TIME, or DATETIME value. The text string can contain R:BASE wildcard characters.' So it seems funny (at least to me) that DATES would work in a LIKE but an INTEGER would not. It does clearly state TEXT though. Thanks for the clue. Jan -----Original Message----- From: "Wills, Steve" <[EMAIL PROTECTED]> To: [email protected] (RBASE-L Mailing List) Date: Mon, 31 Mar 2008 11:38:40 -0500 Subject: [RBASE-L] - RE: LIKE Jan, could you try: WHERE InvoiceID = .vInvoiceID AND (CTXT(WorkOrderEventID)) LIKE '1012%' I think that would work. To be honest, I can't imagine that your previous statement worked, given the type mismatch, even in older versions of RB. Anyway, hope this helps. My $0.02, Steve in Memphis From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of jan johansen Sent: Monday, March 31, 2008 11:23 AM To: RBASE-L Mailing List Subject: [RBASE-L] - LIKE 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
