How to use timestamp fields?

Discussion of open issues, suggestions and bugs regarding SDAC (SQL Server Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
ccmcbride
Posts: 101
Joined: Tue 01 May 2007 16:36

How to use timestamp fields?

Post by ccmcbride » Thu 24 May 2007 21:50

Delphi 7, sDac Demo 4.00.0.7

I have added a timestamp field to all of my tables.
I don't have autorefresh on, but I am calling 'RefreshQuick'.
Issue : If I include the timestamp field in my table field list, then adding a record results in 'cannot assign value to timestamp'. If I don't include it in my field list, then I get 'timestamp field required'. So, how are they to be properly used? I'm dead in the water until I can figure this one out.

Jackson
Posts: 512
Joined: Thu 26 Jan 2006 10:06

Post by Jackson » Fri 25 May 2007 07:11

We couldn't reproduce the problem.
Please send us (evgeniym*crlab*com) a complete small test project to reproduce the problem;
include definition of your own database objects; don't use third party components.

Also supply us the following information:
- Exact version of Delphi or C++Builder.
- Exact version of Microsoft SQL Server and OLE DB provider you use. You can see it the Info sheet of TMSConnection Editor.

ccmcbride
Posts: 101
Joined: Tue 01 May 2007 16:36

Post by ccmcbride » Fri 25 May 2007 17:59

My bad.
I am copying duplicate fields from master to detail, so it was trying to write to it.

Post Reply