Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Sqlexec from vfp fails
Message
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Syntaxe SQL
Divers
Thread ID:
01636625
Message ID:
01636641
Vues:
57
You should use parameters as Mike Y said, but if you want to pass dates as strings you need to use ttoc({your date/time}, 3), in your case:
dt1	= TTOC(DATE(2016,4,1), 3)
dt2	= TTOC(GOMONTH(DATE(2016,4,1),1)-1,3)
"The five senses obstruct or deform the apprehension of reality."
Jorge L. Borges?

"Premature optimization is the root of all evil in programming."
Donald Knuth, repeating C. A. R. Hoare

"To die for a religion is easier than to live it absolutely"
Jorge L. Borges
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform