John Pickering
Toronto

> -----Original Message-----
> From:	Gassett, Chris [SMTP:gassett@aavid.com]
> Sent:	Tuesday, July 13, 1999 4:01 PM
> To:	'Powerhouse List'
> Subject:	CONTENTS
> 
> 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.
= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
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.