Insert in view and refresh record with IDENT_CURRENT

Discussion of open issues, suggestions and bugs regarding SDAC (SQL Server Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
dupe
Posts: 20
Joined: Wed 15 Jun 2016 13:37

Insert in view and refresh record with IDENT_CURRENT

Post by dupe » Mon 21 Nov 2016 14:30

Hello,

we have a question about views with multiple joins.
On this view is an INSERT-UPDATE-TRIGGER.
So if we write an INSERT statement and query afterwards the identity value we would like to use the new IDENT_CURRENT feature.
But in IDENT_CURRENT we need to specify a table name.
At the moment SDAC will specify this parameter with the name of the view.
But we want to specify our own table name for IDENT_CURRENT.
We didn’t find anything with SDAC to specify a table for this function.
Did we overlook something?
If not we would like to ask if there’s a chance that you implement this function in a future version?

Best regards

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

Re: Insert in view and refresh record with IDENT_CURRENT

Post by azyk » Thu 24 Nov 2016 09:32

You can leave a suggestion to implement this functionality on our User Voice forum ( https://devart.uservoice.com/forums/104 ... components ). If the suggestion gets enough votes, we will consider the possibility to implement it.

Post Reply