Insert in view and refresh record with IDENT_CURRENT
Posted: 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
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