Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
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
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement