lrd_stmt

Example: lrd_stmtStatement Handling Functions

Sets an SQL statement to be processed.

LRDRET lrd_stmt( LRD_CURSOR *mptCursor, char *mpcText, long mliTextLen, LRDOS_INT4 mjOpt1, LRDOS_INT4 mjOpt2, int miDBErrorSeverity );


mptCursor A pointer to an LRD_CURSOR structure.
mpcText A pointer to SQL statement text.
mliTextLen The length of the text, or -1 to take the full length of a null terminated string.
mjOpt1 A database-dependent statement option, Option 1
mjOpt2 A database-dependent statement option, Option 2
miDBErrorSeverity The Error Severity Levels of a failure in a database routine.

The lrd_stmt function associates a character string (usually an SQL statement) with a cursor.

Note that when working with ODBC, you can specify direct execution by setting mjOpt1 to 1.

The lrd_exec function resets the contents of the SQL statement set by lrd_stmt; you must provide a new SQL statement after every lrd_exec function call.

For more details refer to the Function Header File lrd.h in the include directory.

Return Values

See LRD Return Values.

Parameterization

The following argument can be parameterized using standard parameterization: mpcValStr