Convert the Autonumber to Long/Interger and vice versa when app is running in cloud

Hi , 1. Is there any way to set the AutoNumber attribute to integer/long from Application running in cloud and vice versa.   2. Is there any way to perform SQL insert, update delete queries in cloud from application /
1 answers

Hi Kiran,


In my opinion the best way to do this is to create a new attribute for the integer/long and create a conversion  that sets for every entity the integer value based on the autonumber value, if that conversion is finished you can remove the autonumber attribute, this means that you need to redeploy twice but I think this is the safest option for staying within the Mendix Technology.

Yes, you can execute SQL and OQL with marketplace modules that you can download, however this is bearing a risk and this goes for a big part outside of the standard Mendix Technology so you should be really sure what you are doing to not mess up with your database.


Hope this helps 

Good luck