Switch to: V9V8V7V6V5

VSqlStatement Class

in Xojo this class has name VPreparedStatement

Description

NEW in 7.0

This class provides methods to set binding values (if needed) and perform query multiple times most efficiently.

You should use CreateSqlStatement() method of VDatabase class to create object of this class.

After you have it, you should:

1) setup bound values if your SQL query contains bind-placeholders 2) call one of the methods of this class to execute a query.

Properties

Methods

Bind Methods

Multi-Row Bind Methods

These methods get already constructed 'Array of Values' or 'Array of Arrays of Values'.

SQL Methods