Problem With Primary Key In Views at SDAC 3.5 or SQL server 2005

Mahyar · Post by **Mahyar** » Wed 02 Aug 2006 06:11

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???

Jackson · Post by **Jackson** » Wed 02 Aug 2006 08:07

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