|
Syntax
INT = dbBindTimeStampParam(hstmt as INT,param as INT,ts as DBTIMESTAMP)
Description
Binds a DBTIMESTAMP 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.
ts - A UDT of type DBTIMESTAMP
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 ts as DBTIMESTAMP
hstmt = dbPrepareSQL(pdb,"INSERT INTO Addresses (FirstName,LastName,Address,dtAdded) VALUES(?,?,?,?)")
IF hstmt
dbBindParameter(hstmt,1,first,255)
dbBindParameter(hstmt,2,last,255)
dbBindParameter(hstmt,3,street,255)
dbBindTimeStampParam(hstmt,4,ts)
'after the variables are bound you can insert as many records as needed with one statement
first = "Lisa"
last = "Jones"
street = "123 Niagara"
ts.day=23:ts.month=9:ts.year=2004:ts.hour = 12:ts.minute = 0:ts.second = 0
dbExecute(hstmt)
'
first = "Tammy"
last = "Miller"
street = "123 Blah Blah"
ts.day=23:ts.month=9:ts.year=2004:ts.hour = 12:ts.minute = 0:ts.second = 0
dbExecute(hstmt)
'
dbFreeSQL(hstmt)
ENDIF
|