Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQLEXEC, datetime()
Message
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
SQLEXEC, datetime()
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows Server 2012
Network:
Windows 2008 Server
Database:
MS SQL Server
Application:
Web
Miscellaneous
Thread ID:
01580683
Message ID:
01580683
Views:
74
How can I insert current datetime in my sql table via VFP ?

year, month, day, h, m,s

Please help me insert date in line below:

cSQL = "UPDATE reembolso set reg_correios= ?m.reg_correios, env_ect = 1 where code = ?m.code, datetime = "

asa=SQLEXEC(lnHandle,cSQL )

I am not sure if I have to convert it.

Moises
Next
Reply
Map
View

Click here to load this message in the networking platform