Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
How to use the server date?
Message
Information générale
Forum:
ASP.NET
Catégorie:
The Mere Mortals .NET Framework
Divers
Thread ID:
00819947
Message ID:
00820340
Vues:
17
Just code it into your SQL statement that you're sending to the server?
Update wws_lineitems SET LastUpdate = GetDate(), Sku = ?
etc.

Obviously if you're using CommandBuilder to let it automatically generate your update statement that won't work, but maybe you can do string replace on the generated command to insert that portion into the SQL statement?

+++ Rick ---

>We have a field in all tables called dLastChange which store the DateTime of the last change to the record. Currently I use this code:
>
>
>dataRow["dLastChange"] = DateTime.Now;
>
>
>How can I use the server clock instead of the client clock? How do I use the "getdate()" function of the SQL Server when I save a record with MM.NET?
+++ Rick ---

West Wind Technologies
Maui, Hawaii

west-wind.com/
West Wind Message Board
Rick's Web Log
Markdown Monster
---
Making waves on the Web

Where do you want to surf today?
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform