f2s_esql_escape_string¶

Applies to: Oracle, MS SQL, MySql/MariaDB, PostgreSQL Drivers

Syntax

f2s_esql_escape_string {string} to {variable}

Parameter	Description
string	The string to be escaped
variable	Variable to hold the newly escaped string

Description

This command is used to properly escape strings before they are used in embedded SQL statements. This can be extremely important when you do not have full control of the strings being passed to the SQL statement as this will ensure that the strings are properly quoted.

Example

     String sEscaped
     String sVal
     Move "They said to me, 'hello'." to sVal
     f2s_esql_escape_string sVal to sEscaped
     // Escaped String value: *They said to me, \'hello\'.*

Related Commands

f2s_esql_create_stmt

Replaces: SQL_ESCAPE_STRING