>> sql timestamp

J

Jonathan

Hi, using Access 2003 and SQL 2005.

The sql table has a timestamp field. Before running an update I want to
check that the record timestamp has not changed. What is the best way to do
this?

If I store the timestamp in Access, what data type do I use?

Any ideas or suggestions appreciated :)

Many thanks,
Jonathan
 
S

Stefan Hoffmann

hi Jonathan,

please, don't use any kind of markup in the subject.
The sql table has a timestamp field. Before running an update I want to
check that the record timestamp has not changed. What is the best way to do
this?
Normally Access does this kind of check automatically.
If I store the timestamp in Access, what data type do I use?
What do you mean?

btw, do you use an .adp or .mdb?


mfG
--> stefan <--
 
J

Jonathan

Stefan Hoffmann said:
hi Jonathan,

please, don't use any kind of markup in the subject.

Normally Access does this kind of check automatically.

What do you mean?

btw, do you use an .adp or .mdb?


mfG
--> stefan <--
.

Hi Stefan. Using a .mdb and I have not used linked tables/views. Instead
have an unbound form. I set an adodb recordset to recordset returned from a
stored procedure to populate fields.

Jonathan
 
S

Stefan Hoffmann

hi Jonathan,
Hi Stefan. Using a .mdb and I have not used linked tables/views. Instead
have an unbound form. I set an adodb recordset to recordset returned from a
stored procedure to populate fields.
Ah, I see. The TIMESTAMP or better ROWVERSION is in fact a
(VAR)BINARY(8). You may store it using BLOB chunking:

http://support.microsoft.com/kb/103257

or better in your case as string:

http://support.microsoft.com/kb/170380


Another solution maybe the use of CHECKSUM(*):

http://msdn.microsoft.com/en-us/library/ms189788.aspx


mfG
--> stefan <--
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top