Method sqlX

Use

sqlX is a method of the class SapDB_Session.

With this method you execute an SQL statement with parameters without first having to create an object of the class SapDB_Prepared.

Features

sqlX (cmd, parms = [])

cmd

SQL statement; can contain the following placeholders:

? | :<varname>

parms

Parameter list from which the system replaces the placeholders for parameters

Result:

?     Successful execution: see Possible SQL Results

?     Error: exception of the class SQLError

Example

?     You execute a SELECT statement that contains a parameter:

cursor = session.sqlX ('SELECT firstname, name, cno FROM hotel.customer WHERE cno>?',[3000])

The variable cursor contains an object of the class SapDB_ResultSet. You can use this object to access the data records of the result set.

?     You execute a DELETE statement that contains a parameter:

rowsDeleted = session.sqlX ('DELETE FROM hotel.person WHERE name = ?',['NY'])

The variable rowsDeleted contains the number of lines deleted by the DELETE statement.