Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Populate a Timestamp Field
Message
De
09/11/2008 16:19:19
Dragan Nedeljkovich (En ligne)
Now officially retired
Zrenjanin, Serbia
 
 
À
04/11/2008 18:27:05
Steven Dyke
Safran Seats USA
Texas, États-Unis
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 SP1
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
Visual FoxPro
Divers
Thread ID:
01359653
Message ID:
01360797
Vues:
25
>My SPT will be
>
>updateString = "Update myTable Set datstmp = current_timestamp"
>
>This is an AS400(dbu2) file with a field set to type Z. What I am afraid of is the updating through scan will try to fire quicker than once a second.

http://www.ispirer.com/doc/sqlways38/Output/SQLWays-1-106.html - says that the function is OK to use once per statement, i.e. if you update multiple records you will get the same time. Don't know whether there's anything that would give you a guaranteed-to-differ if you insert multiple records.

p.s. re your tagline - you're welcome and, no, he may not, at least not me.

back to same old

the first online autobiography, unfinished by design
What, me reckless? I'm full of recks!
Balkans, eh? Count them.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform