Help with a field name that conflicts with a function name

[Knox, Dave (Dallas CSC Citrix)]

Reference your item as %REV

The "%" will differentiate it from the Cognos "reserved word".

> ----------
> From: 	Kim Williams[SMTP:KWilliams@corp.ultratech.com]
> Sent: 	Friday, March 10, 2000 3:18 PM
> To: 	Powerh-l@lists.swau.edu
> Subject: 	Help with a field name that conflicts with a function name
> 
> I am using Quiz 8.19c4 on MPE version 5.5.
> 
> I have a database with a field named REV.  This conflicts with a function
> name in Quiz.  How can I convince Quiz to let me put this on the right
> side of a select or define statement?
> 
> (I don't want to rename the field in my dictionary.)
> 
> Thanks for any help.
> 
> Q U I Z   (PowerHouse  8.19.C4)
> Copyright 1999 COGNOS INCORPORATED
> Ultratech Stepper
> 
> > ACCESS IM
> > DEFINE X CHAR*2 = REV
>                        ^
> *E* Expected:  (
>                        ^
> *E* Expected:  (  CENTRE  CENTER  REVERSE  DOWNSHIFT  GETSYSTEMVAL
> LINKVALUE
>       LEFT  LJ  PACK  ATTRIBUTE  SUBSTITUTE  RIGHT  RJ  SPREAD  TRUNCATE
>       UPSHIFT  ZEROFILL  DECRYPT  ENCRYPT  SOUNDEX  ASCII  CONTENTS
> <string>
>       MISSING  NULL  CHARACTERS  LOGONID  PORTID  SYSNAME  SIGNONUSER
>       SIGNONGROUP  SIGNONACCOUNT  <qualifier>  <item>
> > 
> 
> > ACCESS IM
> > REPORT REV
> > GO
> 
> 
>   REV LVL
> 
>     00
>     01
>     --
>     01
>     01
>     --
> 
> 
> Kim Williams
> Business Applications Manager
> phone: (408) 325-6484
> kwilliams@corp.ultratech.com
> Ultratech Stepper
>  
> !
> !
>                                 
>  
> 
> = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
> =
> Subscribe: "subscribe powerh-l" in message body to
> majordomo@lists.swau.edu
> Unsubscribe: "unsubscribe powerh-l" in message to majordomo@lists.swau.edu
> This list is closed, thus to post to the list, you must be a subscriber.
> 
= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
Subscribe: "subscribe powerh-l" in message body to majordomo@lists.swau.edu
Unsubscribe: "unsubscribe powerh-l" in message to majordomo@lists.swau.edu
This list is closed, thus to post to the list, you must be a subscriber.