ServerErrorSQLPos Method

Applies To

Description

When an error occurs during parsing of a SQL statement, this method returns the position within the SQL statement where the error occurred.

Usage

int ServerErrorSQLPos(void) const;

Remarks

Whenever the server detects an error while parsing an SQL statement, for instance during ODatabase::ExecuteSQL or ODynaset::Open, the position within the SQL string where the error occurred is remembered and can be obtained using this method. The position is 0-based; the first character in the SQL statement is character 0. If no error has occurred, or no SQL statements have been parsed by this database or since the last call to ServerErrorReset, then -1 is returned.

Return Value

Returns the character position of the SQL parse error (0 based) or -1 if there was no error.

Example

An example of a SQL parse error:

// open an ODatabase object

ODatabase odb("ExampleDB", "scott", "tiger");

// execute a bad SQL statement

odb.ExecuteSQL("xxzzz");

int sqlpos = odb.ServerErrorSQLPos();

// sqlpos will be 0

// execute another bad SQL statement

odb.ExecuteSQL("drop zzz");

// the zzz doesn't make sense

sqlpos = odb.ServerErrorSQLPos();

// sqlpos will be 5