>> sql timestamp

  • Thread starter Thread starter Jonathan
  • Start date Start date
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
 
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?
Click to expand...
Normally Access does this kind of check automatically.
If I store the timestamp in Access, what data type do I use?
Click to expand...
What do you mean?

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


mfG
--> stefan <--
 
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 <--
.
Click to expand...

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
 
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.
Click to expand...
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 <--
 
Back
Top