General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Help with SQL Update for Date and DateTime Formats
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
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