Hello.
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.
Refresh Query in TMSQuery on BCB6
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
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