Connection.Exec (gb.db2)

Function Exec ( Request As String, ... ) As Result

Executes an arbitrary SQL request, and returns a read-only Result containing the result of the request.

  • Request is any SQL request.

  • Arguments are quoted as needed by the SQL syntax, and substituted inside the Request string

The last feature allows you to write requests that are independant of the underlying database type.

Only SELECT queries return a Result object. You don't have access to the number of modified rows at the moment.

Example

TheResult = DB.Exec("SELECT * FROM UserTable WHERE Login = &1 AND Password = &2", TheLogin, ThePassword)

See also