April 10, 2002 at 9:20 am
I have a Visual Basic client which feeds into an SQL Server 7. The data is date specific and we have issues with users changing their system date by using it as a calendar. Is there a way of calling the SQL Servers date/time and using this instead of the clients system date ?
April 10, 2002 at 10:02 am
When inserting data into the table put GetDate() for the field you need, create a triger on the insert/update for this field.
April 10, 2002 at 6:07 pm
Or if the field must have an entry, make GetDate() the default of the field.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
April 11, 2002 at 2:44 am
Cheers guys, I didn't make myself all that clear but the client had to look up a value from the server table depending on the date. If the date was set way in the future no value would be found. I ended up calling a small stored procedure to call the server date. Thanks for your help though I was amazed how quickly someone replied, I'm new to SQL so I'm sure there'll be more
Cheers
James
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply