Jigesh wrote:
I am using TMSTable and have set CheckRowVersion=True in the table.option
When I edit the same record from two different computers, I am not getting any post error message as that the record is already modified. Maybe I missed some settings on the table. Can you please direct me as to what I am doing wrong.
Thanks
CheckRowVersion=True
CheckRowVersion=True
Jigesh wrote:
I have set the value of TCustomDADataSet.Options.StrictUpdate property to true. But still it does not work. I was able to achive my goal by changing the cursortype to ctDynamic. But but setting to ctDynamic, it only works when I connect to SQL7, if I try to connect to SQL2000 it get an EDAError saying the cursor type changed for statement. I need to make my application to work with SQL2000.
SQL2000 is going to be my backend server.
Thanks in advance
We couldn't reproduce the problem.
Please send us a complete small test project to reproduce the problem; it is desirable to use Northwind or Master schema objects, otherwise include definition of your own database objects; don't use third party components
Also supply us following information
- Exact version of Delphi or C++ Builder
- Exact version of SDAC. You can see it in About sheet of TMSConnection Editor
- Exact version of Microsoft SQL Server and OLE DB provider that you use. You can see it in Info sheet of TMSConnection Editor
Please send us a complete small test project to reproduce the problem; it is desirable to use Northwind or Master schema objects, otherwise include definition of your own database objects; don't use third party components
Also supply us following information
- Exact version of Delphi or C++ Builder
- Exact version of SDAC. You can see it in About sheet of TMSConnection Editor
- Exact version of Microsoft SQL Server and OLE DB provider that you use. You can see it in Info sheet of TMSConnection Editor