SQLOpen - cSQLConnection

Open a statement handle

Type: Function
Return Data Type: Handle

Syntax

Function SQLOpen Returns Handle

Call Example

Get SQLOpen to HandleVariable

Description

This function will open a statement handle in the connection. It will create a DataFlex statement handle object and call the Connectivity Kit's open function. If the statement handle could be opened, the Connectivity Kit's handle information is stored.

The function returns the object handle to the DataFlex statement object cSQLStatement.

Use SQLOpen and SQLClose to allocate and de-allocate statement handles. You need to close a statement handle whenever the statement changes.

Sample

Handle hoSQLManager hoConnection hoStatement

Object oSQLHandler is a cSQLHandleManager
    Move Self to hoSQLManager
End_Object

Get SQLFileConnect of hoSQLManager (RefTable(Customer)) to hoConnection
Get SQLOpen of hoConnection to hoStatement

Return Value

Handle of statement (a cSQLStatement object). Returns zero (0) if the open fails.