>> sql timestamp

[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

 

[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 <--

 

[Jonathan]

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

 

[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 <--

 

[Jonathan]

thanks for these links.
Jonathan

hi Jonathan,

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 <--
.