General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Pass the date delimited with a single quote, SQL doesn't recognize curly braces as a date delimiter. Also, you should use dtos() since this is a universally accepted date format without worrying about how the date format or regional settings in VFP and SQL...
lcCmd="update batch_log set process_date = '" + dtos(date()-1) + "' where batch_id=1"
BOb
>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
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only