Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Changing date fields
Message
De
28/11/2005 16:26:33
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Titre:
Changing date fields
Versions des environnements
Visual FoxPro:
VFP 8 SP1
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
MS SQL Server
Divers
Thread ID:
01072614
Message ID:
01072614
Vues:
51
Hi, i just need to know what's the best way to change a date field on sql server even any other db.
vardate=date(2005,1,10)
i use something like sql="update dates set dat1={"+dtoc(vardate)+"} where code=1" but some databases like db2 this changes to: sql="update dates set dat1='"+dtoc(vardate)+"' where code=1" the { changes to ' there is a generic way to do this?
t.i.a.
John Harold Belalcázar Lozano
Associate Director Of Development
http://www.belvicto.co/
jhbelalc@gmail.com
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform