dbBindDateParam

Syntax

INT = dbBindDateParam(hstmt as INT,param as INT,dt as DBDATE)

Description

Binds a DBDATE 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.

dt - A UDT of type DBDATE

Return value

TRUE if variable bound successfully, FALSE otherwise.

Remarks

A parameter is denoted by a ? in the SQL statement. There must be exactly one bound variable for each parameter.

Example usage

DEF bd as DBDATE
hstmt = dbPrepareSQL(pdb,"INSERT INTO Addresses (FirstName,LastName,Address,Birthday) VALUES(?,?,?,?)")
IF hstmt
    dbBindParameter(hstmt,1,first,255)
    dbBindParameter(hstmt,2,last,255)
    dbBindParameter(hstmt,3,street,255)
    dbBindDateParam(hstmt,4,bd)
    'after the variables are bound you can insert as many records as needed with one statement
    first = "Lisa"
    last = "Jones"
    street = "123 Niagara"
    bd.day = 1:bd.month = 7:bd.year = 1959
    dbExecute(hstmt)
    '
    first = "Tammy"
    last = "Miller"
    street = "123 Blah Blah"
    bd.day = 25:bd.month = 12:bd.year = 1962
    dbExecute(hstmt)
    '
    dbFreeSQL(hstmt)
ENDIF