Skip to content

piBindFile - cSQLConnection

The default file to bind statement results to.

Type: Property
Access: Read/Write
Data Type: Integer
Parameters: None

Syntax

Property Integer piBindFile
Access Type Syntax
Read Access: Get piBindFile to IntegerVariable
Write Access: Set piBindFile to IntegerVariable/Value

Description

The piBindFile property stores the default file buffer to use for statements created in this connection. It should be set to a file number. If the connection is created by sending the message SQLFileConnect, the property will automatically be set.

When statement objects are created, the value of this property will automatically be passed to that statement object's piBindFile property.

Sample

The code sample uses two different ways to set the piBindFile property to the Customer file number. One is by using a "normal" connect and explicitly setting the property. The other is by using SQLFileConnect implicitly setting this property.

Handle hoSQLMngr
Handle hdbc

Object oSQLHandler Is A cSQLHandleManager
    Move Self To hoSQLMngr
End_Object

Send SQLSetConnect Of hoSQLMngr "MSSQLDRV" "SERVER=(local)"
Get SQLConnect Of hoSQLMngr "" "" To hdbc
Set piBindFile Of hdbc To Customer.File_number
Get SQLFileConnect Of hoSQLMngr Customer.File_number To hdbc