Page 1 of 1
Problem With Primary Key In Views at SDAC 3.5 or SQL server 2005
Posted: Wed 02 Aug 2006 06:11
by Mahyar
In Sql server 2000 sdac identify primary key of the base table in view and after insert to View return ID value with @Scope_Identity syntax.
In Sql server 2005 it is't work.
what can i do???
Posted: Wed 02 Aug 2006 08:07
by Jackson
We couldn't reproduce the problem.
Please send us (sdac*crlab*com) 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