Help with a field name that conflicts with a function name

[Pilgrim, Mary]

This is reported as problem 259846 in 819.  REV became a reserved word.  The
workaround is to specify %REV instead of REV in all of your programs.

-----Original Message-----
From: Kim Williams [mailto:KWilliams@corp.ultratech.com]
Sent: Friday, March 10, 2000 4:19 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.