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.