PREP_Q

Syntax

Example

Description/Remarks

PREP_Q "string"

svar1 = PREP_Q "PAD 3' WIDE"

 

returns the string "PAD 3'' WIDE"

PREP_Q returns a string with single quotes prepared for a SQL Statement. To prepare the string, every single quote must be replaced by two single quotes.

Note: PREP_Q should only be used with DB_SET_VALUE commands that are made to DDATA and VSTDS.   Do not use in a traceability column or when setting values that will be put into template cells.  If used in these other cases, extra single quote characters will appear.  The PREP_Q command should not be used with the DB_????_SQL commands for the same reason.