Switch to: V9V8V7V6V5

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. It is more effective because a SQL query is parsed only once.

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

After you have VSqlStatement object, 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