%TextIn meta-SQL element

Syntax

%TextIn(BindVariable)

Description

%TextIn construct, when used with a bind variable, allows the insertion and updating of a text string into a LongChar field (column).

This construct is mandatory for any LongChar field insertion or update to be compatible on all database platforms on which it is supported.

Parameters

Parameter	Description
BindVariable	Specify a bind variable.

Example

In the following example, :1 is a bind variable in PeopleCode:

&String1 = "This is a test."

SqlExec("INSERT INTO PS_TABLE1 (STMTID, SQLSTMT) VALUES (1, %TextIn(:1))",⇒
 &String1)