Share this page

# lrd_stmt

Example: lrd_stmt | Statement 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

Tips to improve your search results... VuGen Function Reference Version 25.1-25.3 Function Reference 25.1-25.3 All View Local Help Center View Online Help Center Version: