Is there a way to make Pervasive SQL talk to an MS SqlServer? I have data on both types of servers. When one is updated I need to trigger an update on the other database.
There is a command: SELECT @@IDentity
Put this in the same AdoQuery component with the insert command. Call Open instead of ExecSql to retreive the data. It will return the Identity field for the record just added. i.e.
In the AdoQuery.Sql property enter
INSERT INTO TestTable (field1...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.