Re: [U2] Unidata error for the ages, so to speak.
Bill Haskett <[email protected]>
| Newsgroups | gmane.comp.db.u2.general |
|---|---|
| Message-ID | <[email protected]> |
Doug: This is a UniData anomaly. You can't reference fields like "@RECORD<3>", you have to refer to them like "EXTRACT(@RECORD,3,0,0)". HTH, Bill Untitled Page ------------------------------------------------------------------------ ----- Original Message ----- *From:* [email protected] *To:* U2 Users List <[email protected]> *Date:* 12/5/2013 1:44 PM *Subject:* [U2] Unidata error for the ages, so to speak. > 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