I've seen a couple of suggested methods to do this in a Cloud friendly way but I'm having difficulty making them work in our 9.01 Test environment (which is on prem so I can see what's going on)
Method 1: Enter AUTONUMBER(STEP(1)) in default value of SQL Columns. This gets the error message STEP is not a valid function. This syntax is accepted as a default value in IDO Properties but is treated as a literal by the form (as is AUTONUMBER() and a few other variants on a theme) and gets rejected on save because it isn't numeric
Method 2: Use the AUTONUMBER 'generator' in Application Schema Columns Metadata (then run trigger management for the table). This just results in null being passed (and rejected) even though the trigger code looks like it's trying to handle it.
Can anyone suggest what I'm doing wrong?
Thanks
