Hello,
We are running the Rollbase 3.0.4 Private cloud installation
Directly connected to Openedge database and using external objects created from the database.
Another Rollbase question - our Openedge application uses the progress _seq - sequence values. In our application we would usually retrieve the next sequence value on a new record and update.
What is the best way in Rollbase to utilise progress sequence values.
Ideally we want to be able to query the current value and then also assign the next value on create.
Is this functionality supported? we have tried to use rollbase triggers with no luck.
Any documentation or suggestions are very appreciated.
Regards
Jim
There is a AutoNumber field type in rollbase which can be of use here. As of 3.0.5, autonumber is supported on external objects as well, but only if the jdbc metadata isautoincrement returns true for the sequence column (May be some one from OE can comment on this).
But, the catch is that it is highly encouraged to not set the value of sequence column manually and let the database handle it (most of the db's such as mySQL, SQL Server take care of setting the column value even when its not in the query).
I am not sure how you can achieve this behavior in 3.0.4.
There is a AutoNumber field type in rollbase which can be of use here. As of 3.0.5, autonumber is supported on external objects as well, but only if the jdbc metadata isautoincrement returns true for the sequence column (May be some one from OE can comment on this).
But, the catch is that it is highly encouraged to not set the value of sequence column manually and let the database handle it (most of the db's such as mySQL, SQL Server take care of setting the column value even when its not in the query).
I am not sure how you can achieve this behavior in 3.0.4.