My database generates UUIDs on its own when a record is inserted. Scriptcase does not like this at all and will not allow me to even build an application without a primary key selected, but if I select a primary key then I cannot insert the record because it is now a required field. I have tried changing the insert value of the field to ‘calculated by database’, ‘auto increment (auto)’, I even changed it to the time of insertion and manually set the field on the before insert event. It seems that script case if looking for manual input by a user.
I have multiple locations running on scriptcase systems, this is always an issue with them and before we spent enough time clicking around it would finally except a UUID as a primary key without even selecting a primary key in the application. I cannot figure out any method to the madness it always just works after building and closing and changing options enough times. Our issue is this is now causing issues on old projects that need minor changes and we do not have the time to go and fix all of these applications unless we know where an option is or the correct steps and procedure to use UUIDs as my records primary key. This is a major issue one to cause our new projects to steer away from a scriptcase solution. This is wasting lots of time on an issue that I’m surprised is even an issue, does nobody generate their own ids?