Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Changing date fields
Message
From
28/11/2005 16:26:33
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Client/server
Title:
Changing date fields
Environment versions
Visual FoxPro:
VFP 8 SP1
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
MS SQL Server
Miscellaneous
Thread ID:
01072614
Message ID:
01072614
Views:
52
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
Next
Reply
Map
View

Click here to load this message in the networking platform