dbGetTime

Syntax

dbGetTime(hstmt as INT,column as INT,time as DBTIME)

Description

Gets a DBTIME type directly from a column after a dbGet, dbGetNext or dbGetPrev operation.

Parameters

hstmt - Statement handle returned by dbExecSQL or dbPrepareSQL.

column - Ones based column number to retrieve from.

time - A variable of type DBTIME

Return value

TRUE if data was successfully retrieved and stored in the variable. FALSE on error or empty result set.

Remarks

dbGetTime is an alternative to binding a DBTIME variable and is not supported by all database drivers.  Certain drivers will not allow directly retrieving data from a column if it is already bound to a variable. The Access driver supports both binding and direct retrieval. Binding variables will always result in faster retrieval of data.

See Also: dbGetDate, dbGetTimeStamp, dbGetData

Example usage

DEF tmAdded as DBTIME
DEF first,last as STRING
DEF Address_ID as INT
...
hstmt = dbExecSQL(pdb,"SELECT * FROM Addresses")
IF hStmt
    'bind the columns in the table to appropriate variables
    'column numbers start at 1 starting from the left.
   
    WHILE dbGet(hstmt)
        dbGetData(hstmt,1,Address_ID)
        dbGetData(hstmt,2,first)
        dbGetData(hstmt,3,last)
        dbGetTime(hstmt,8,tmAdded)
        PRINT "ID:",Address_ID
        PRINT "Name:",first,last
        PRINT "Time added:",USING("## ## ##",tmAdded.hour,tmAdded.minute,tmAdded.second)
    ENDWHILE
ENDIF