SQLNextColumn - cSQLStatement

Can be used to call SQLColumnValue in column order

Type: Function
Return Data Type: String

Syntax

Function SQLNextColumn Returns String

Call Example

Get SQLNextColumn to StringVariable

Description

Can be used to call SQLColumnValue in column order.

Instead of

Get SQLColumnValue of hStmt 1 to sColumnValue1
Get SQLColumnValue of hStmt 2 to sColumnValue2

The following can be used:

Get SQLNextColumn of hStmt to sColumnValue1
Get SQLNextColumn of hStmt to sColumnValue2

Return Value

The next column's value