I would like to use a TimeStamp col 1

[GerryGoldberg]

I would like to use a TimeStamp column in an SQL-7 database and be able to read it's value with an access program. I have defined the table in SQL and, once connected to A97, this field appears as 'binary' of length 8. How can I convert this field to a value that I can manipulate?
Thank,

Gerry Goldberg

 

[tlbroadbent]

Timestamp columns are not for manipulation. They are not really timestamps as we normally think of timestamps. That is the column doesn't contain the date and time of last update although it is updated every time the row is updated. SQL does use timestamp columns to identify updated rows. You may want to use another type column if you need to manipulate or view the data. Terry

http://members.home.net/tlbroadbent/index.htm

 

[GerryGoldberg]

I don't need to manipulate the timestamp values but simply use them in a selection process to update some other tables. It seems that I can extract new or modified data records from my SQL tables by structuring a query that compares each record's timestamp value against a base timestamp value (e.g. date of last update) that is contained in another table. Thanks for your help.

 

[tlbroadbent]

I suggest adding a true datetime column and updating it every time the record is updated. This can easily be accomplished with a trigger. Terry

http://members.home.net/tlbroadbent/index.htm