Switch to: V11V10V9V8V7V6V5

VSqlStatement Class

In “Valentina for Xojo” ADK 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 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

Multi-Row Bind Methods

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

SQL Methods