1. René Ullrich
  2. PowerBuilder
  3. Wednesday, 17 October 2018

Hello,

 

Oracle 12 supports identity columns with new GENERATED AS IDENTITY clause.

I've tried to get it work with PowerBuilder Datawindows (using ORA driver). I specified the identity columns in the datawindow update properties dialog. But I can't get it to work. PowerBuilder doesn't gets the generated value from oracle.

 

Does Powerbuilder supports identity columns with Oracle?

 

Chris Pollach Accepted Answer Pending Moderation
1
Votes
Undo

Hi René;

  Since this is new to Oracle vs being a long time feature of ASE and SS, I suspect that the ORA driver needs to be "tweaked". Normally in ASE or SS when the DWO recognizes an Identity Column (aka Auto Increment) it issues a "ReSelectRow" command behind the scenes to get the new auto assigned value by the DBMS.

  The bad news is that we probably need to open a Support Ticket for this new O12c feature to be supported. The good news is that your App's can use the ReSelectRow() command today (as a workaround) as that command has been a feature in PB for decades.

HTH

Regards ... Chris

Comment
Hi Chris,



I have not tried it but I guess ReSelectRow would not work. PB can't create the where clause to find the row because it doesn't know the values of the primary key column.
  1. René Ullrich
  2. Wednesday, 17 October 2018
Correct .. so set the Update properties to Identity = None. Then use the ReSelectRow.approach
  1. Chris Pollach
  2. Wednesday, 17 October 2018
There are no comments made yet.
  1. Wednesday, 17 October 2018
  2. PowerBuilder
  3. # 1
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to this question.