Re: [U2] Unidata error for the ages, so to speak.
Ed Clark <[email protected]>
| Newsgroups | gmane.comp.db.u2.general |
|---|---|
| Message-ID | <[email protected]> |
iirc, you can't use the <> extraction syntax in unidata itypes. Instead of @RECORD<15> you need to use something like EXTRACT(@RECORD,15). Or use an attribute name like you did. Cool error message though. It's a palindrome. On Dec 5, 2013, at 4:44 PM, Doug Averch <[email protected]> wrote: > I was playing with EVAL trying to see why it would work in Universe > and not in Unidata. I typed in this sentence in Unidata 7.3.6: > > list CRM.CUSTOMERS WITH EVAL "UPCASE(@RECORD<15>)" LIKE "BILL..." > > UPCASE(@RECORD<15>) > -----------------^ > Virtual Attribute Error: qz1zq syntax error > > So what is qz1zq syntax error? Who would of thought this would help a > seasoned professional like myself figure our my syntax error. I guess > I really don't understand this database after many many years... > > The correct syntax was : > list CRM.CUSTOMERS WITH EVAL "UPCASE(CONTACT.NAME)" LIKE 'BILL...' > > Regards, > Doug > www.u2logic.com > "Web applications with real error messages" > _______________________________________________ > U2-Users mailing list > [email protected] > http://listserver.u2ug.org/mailman/listinfo/u2-users _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users