>Hi
>
>I am developing a data object which I am using to perform data operations on a SQL Database. I am working on a new method of the object which is intended to be a SQL Update command, and I am passing three parameters
>
>1) SQL Table to be Updated
>2) Primary Key (Identiying Row of Table)
>3) A 2 dimensional array of Fields and Values to update.
>
>dime arr(2,2)
>arr(1,1)="name"
>arr(1,2)="John Smith"
>arr(2,1)="date_entered"
>arr(2,2)=date()
>
>I am having problems knowing how to construct the UPDATE SQL command, to handle DATE and DATETIME types.
>
>eg.
>lcCmd="update batch_log set process_date = {" + dtoc(date()-1) + "} where batch_id=1"
>
>then passing this command to SQLEXEC(nHandle,lcCmd) always fails!
>
>Can anyone help with how I pre-prepare date and date time types in the string passed to SQLEXEC?
>
>Many thanks
>Wayne Trueman
luDateOrDateTime = {^2002/1/1 12:58}
lcCmd="update batch_log set process_date = ?luDateOrDateTime"+;
" where batch_id=1"
Cetin