Refresh Query in TMSQuery on BCB6

Discussion of open issues, suggestions and bugs regarding SDAC (SQL Server Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply

Refresh Query in TMSQuery on BCB6

Post by Joël AMAUDRUZ » Wed 29 Mar 2006 20:23


on BCB6.

I use "SCOPE_IDENTITY" in my Insert statement and it work correctly. When i refresh a new record (after post) the (:ID field used in Refresh Statement is null)

My check was :

-) After post : Check "ID" : OK.
-) After refresh : Check "ID" KO + Fields are empty.

Thanks in advance.

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

Post by Jackson » Thu 30 Mar 2006 11:54

We couldn't reproduce the problem.
Is it really necessary to specify INSERT statement? SDAC will automatically
generate INSERT, UPDATE, DELETE and REFRESH statements.
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 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

Post Reply