dbBindParameter

Syntax

INT = dbBindParameter(hstmt as INT,param as INT,variable as ANYTYPE,opt cbSize as INT)

Description

Binds a variable to be used as a parameter in a prepared SQL statement.

Parameters

hstmt - A statement handle returned by dbPrepareSQL.

param - The ones based parameter number to bind.

variable - The variable to bind as a parameter.

cbSize - For string and character types.

Return value

TRUE if variable bound successfully, FALSE otherwise.

Remarks

For string types cbSize must be set to the maximum string length a column can hold. A parameter is denoted by a ? in the SQL statement. There must be exactly one bound variable for each parameter.

Example usage

hstmt = dbPrepareSQL(pdb,"INSERT INTO Addresses (FirstName,LastName,Address) VALUES(?,?,?)")
IF hstmt
    dbBindParameter(hstmt,1,first,255)
    dbBindParameter(hstmt,2,last,255)
    dbBindParameter(hstmt,3,street,255)
    'after the variables are bound you can insert as many records as needed with one statement
    first = "Lisa"
    last = "Jones"
    street = "123 Niagara"
    dbExecute(hstmt)
    '
    first = "Tammy"
    last = "Miller"
    street = "123 Blah Blah"
    dbExecute(hstmt)
    '
    dbFreeSQL(hstmt)
ENDIF