Re: [U2] Unidata error for the ages, so to speak.

[Ed Clark]

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  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
> U2-Users@listserver.u2ug.org
> http://listserver.u2ug.org/mailman/listinfo/u2-users

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] Unidata error for the ages, so to speak.

[Wjhonson]

Quizzle Zik
It's a palindrome by the way
Sounds like you've hit such a strange error, that the systems programmer said 
"I'll name this one later..."



-Original Message-
From: Allen Elwood RR 
To: U2 Users List 
Sent: Thu, Dec 5, 2013 1:52 pm
Subject: Re: [U2] Unidata error for the ages, so to speak.


sounds like an error in the error message

error squared?  lol...

On 12/5/2013 1:44 PM, Doug Averch 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
> U2-Users@listserver.u2ug.org
> http://listserver.u2ug.org/mailman/listinfo/u2-users
>

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

 
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] Unidata error for the ages, so to speak.

[Allen Elwood RR]

sounds like an error in the error message

error squared?  lol...

On 12/5/2013 1:44 PM, Doug Averch 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
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users



___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

[U2] Unidata error for the ages, so to speak.

[Doug Averch]

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
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

[U2] Running Account wide I-DESC

[George Gallen]

Not sure if this helps anyone...

There is an I DESC that we usually put in the DICT of most files.
Usually, when you go to use it, it hadn't been entered, while not difficult to 
enter - just a pain.

I tried to put the IDESC in VOC, but I wasn't able to compile it
I was able to put it in the VOC of VOC - which compiled - but wasn't usable 
globally.

SoIn order to get an IDESC to be used globally (at least globally within 
that account).

You must...


1.   Enter the IDESC into the VOC of VOC

2.   Compile the IDESC

3.   COPY from the VOC VOC to VOC

Now it's usable on any file without having to add it

Funny, if you want to add a D type DICT , you only need to put it in VOC,
But , with I DESC, the problem is compiling it - you can only compile in the 
VOC of VOC
   Then you have to copy it into VOC for it to be usable.

Like I said...If it helps...great,   If not - move on.

George

George Gallen
Senior Programmer/Analyst
Accounting/Data Division, EDI Administrator
ggal...@wyanokegroup.com
ph:856.848.9005 Ext 220
The Wyanoke Group
http://www.wyanokegroup.com

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users