CONTENTS

Gassett, Chris gassett@aavid.com
Tue, 13 Jul 1999 16:00:52 -0400


The table (CD_DRAW_XREF) that I am accessing has a field called 'CONTENT'.
The problem lies when I try to make a simple define, from within Quiz, using
that field.  There is a reserved word 'CONTENT' in Powerhouse that is used
to pull out what is in a string.  If anyone has any ideas or suggestions of
how to keep the field the same if the record exists and update the field if
a record does not exist I would appreciate it.  We are using Powerhouse Ver.
7.23.  Chris


ACCESS PARTMASTER  &

  LINK PARTNO, ENTITY_CODE  &
    TO PARTNO, ENTITY_CODE OF CD_DRAW_XREF OPTIONAL

DEFINE NEWDATE_ADDED CHAR*30 =  &
  "ADDED TO TABLE ON " + ASCII(SYSDATE)  &
  IF NOT RECORD CD_DRAW_XREF EXISTS  &
  ELSE CONTENTS OF CD_DRAW_XREF
                ^^
*E* Expected:  (
                     ^^^^^^^^^^^^
*E* Expected:  .  OF  )
                     ^^^^^^^^^^^^
*E* Expected:  [  ^  *  /  +  -  IF  <eol>
= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
Subscribe: "subscribe powerh-l" in message body to majordomo@lists.swau.edu
Unsubscribe: "unsubscribe powerh-l" in message to majordomo@lists.swau.edu
powerh-l@lists.swau.edu is gatewayed one-way to bit.listserv.powerh-l
This list is closed, thus to post to the list, you must be a subscriber.