Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to use the server date?
Message
General information
Forum:
ASP.NET
Category:
The Mere Mortals .NET Framework
Miscellaneous
Thread ID:
00819947
Message ID:
00820340
Views:
16
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?
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform