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?