Table of Contents
VSqlStatement Class
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 VDatabase.CreateSqlStatement() method to create object of this class. In the “Valentina for Xojo” ADK this method is named VDatabase.Prepare()
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
This section lists methods, which you can use to dictate bind values one by one, and they will be stored inside of an internal array of values in this SqlStatement object. These methods are type-oriented (int, float, double, etc).
- VSqlStatement.Bind_array() [new in v8.0]
Multi-Row Bind Methods
These methods get already constructed 'Array of Values' or 'Array of Arrays of Values'.