Keeping a Temp Table Active

Discussion of open issues, suggestions and bugs regarding SDAC (SQL Server Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
Andrew Love
Posts: 1
Joined: Wed 11 Jan 2017 22:37

Keeping a Temp Table Active

Post by Andrew Love » Wed 11 Jan 2017 22:45

I was previously using TADO Objects.

The application was setup with a temp table #LoggedInUser

When the connection was established I'd create the temp table, load it into a TADOTAble component, modify the value to be the User ID for the user that was logged in.

That way stored procedures, triggers everything could record audit records for the the user based on the logged in user.

This method doesn't seem to be working with SDAC. Either the dataset is open as read only, or the temp table is no longer present by the time changes are made.

Any ideas on how to accomplish this with out completely redesigning all triggers, stored procedure and edits in my application?

azyk
Devart Team
Posts: 1119
Joined: Fri 11 Apr 2014 11:47
Location: Alpha Centauri A

Re: Keeping a Temp Table Active

Post by azyk » Thu 12 Jan 2017 12:22

Please let us know whether the problem is reproduced in our SDACDemo project. The SDACDemo project is located in "Demos\SDACDemo\" related to the SDAC demos installation directory. If this problem is not reproduced in our demo, try to compose a small test project to demonstrate the problem and send it to us using the contact form on our website: http://www.devart.com/company/contactform.html . Please also include scripts for creating test tables in the project.

Post Reply