VSqlStatement Class

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.

• VSqlStatement.Database
• VSqlStatement.Query

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.Init()
• VSqlStatement.AddBindRow()

• VSqlStatement.Bind_null()
• VSqlStatement.Bind_bool()
• VSqlStatement.Bind_uint8()
• VSqlStatement.Bind_uint16()
• VSqlStatement.Bind_int16()
• VSqlStatement.Bind_uint32()
• VSqlStatement.Bind_int32()
• VSqlStatement.Bind_uint64()
• VSqlStatement.Bind_int64()
• VSqlStatement.Bind_float()
• VSqlStatement.Bind_double()
• VSqlStatement.Bind_string()
• VSqlStatement.Bind_binary()
• VSqlStatement.Bind_array() [new in v8.0]

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

• VSqlStatement.Bind(const ArrayOfValues_Ptr inBindings)
• VSqlStatement.Bind(const ArrayOfValueArrays_Ptr inBindings)

• VSqlStatement.SqlSelect()
• VSqlStatement.SqlExecute()
• VSqlStatement.SqlQuery()