Switch to: V12V11V10V9V8V7V6V5

VSqlStatement Class

in Xojo this class has name VPreparedStatement


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.



Bind Methods

Multi-Row Bind Methods

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

SQL Methods