Hi Team,
We are using Powerserver CloudPro Edition. 
We have a datawindow where a column is an Identity column and has a Primary constraint. We are updating the Identity value in UpdateEnd event of the Datawindow. Before that, we are trying to fetch the SQLSyntax from SQLPreview event. If SQLSyntax has 'INSERT' word, then we are updating the Identity value. However, code in SQLPreview event is not getting executed. Thus, UpdateEnd is failing.
Please help!
You shouldn't have to use the UpdateEnd event to get the value of the identity column.
It should contain the correct value following a successful dw.Update().
Depending on your DBMS and on how the identity property has been implemented, you may have to edit your pbodb.ini file, but for the most common supported database vendors, this should work out of the box if you specify the identity column in the DataWindow's Update Properties:
