Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
SQLEXEC, datetime()
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Windows Server 2012
Network:
Windows 2008 Server
Database:
MS SQL Server
Application:
Web
Divers
Thread ID:
01580683
Message ID:
01580709
Vues:
26
>How can I insert current datetime in my sql table via VFP ?

If you want the current datetime, use the built-in GetDate() tsql function.

Update mytable set mydatetimefield = getdate()

see http://technet.microsoft.com/en-us/library/ms188383.aspx

>
>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
____________________________________

Don't Tread on Me

Overthrow the federal government NOW!
____________________________________
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform