- Angela Chen
- PowerBuilder
- Monday, 1 July 2019 10:38 PM UTC
We are having an issue on returning identity column using PB2017 R3 build 1858 connecting to MSSqlServer DB via ODBC
We have a table with insert trigger that insert into another table and we want the return identity value to be the id from the first table. Instead of @@Identity , we would like to use Scope_Identity() , but PB returns null with scope_identity()
A simple test is an insert into a table and a select @@identity(), scope_identity() in DB painter
the select returns the id from the table inside the trigger and a null
the same select returns valid ids in SqlServer management studio
What is the suggested setting in PBODB170.ini for GetIdentity?
Find Questions by Tag
Helpful?
If a reply or comment is helpful for you, please don’t hesitate to click the Helpful button. This action is further confirmation of their invaluable contribution to the Appeon Community.