https://answers.axonivy.com/questions/650/is-it-possible-to-apply-field-order-of-a-persistent-data-class-to-database-table<p>I've noticed that if I use the persistence API to create a database table the order of the table columns is not the same as in the persistence data-class. Is it possible to keep the field order in a data-class to a database table?</p>enFri, 06 Jun 2014 08:48:31 -0400https://answers.axonivy.com/questions/650/is-it-possible-to-apply-field-order-of-a-persistent-data-class-to-database-table/752<p>Another solution is to create your database in SQL first and then create your persistence data clases accordingly to the SQL-Database. So it is possible to apply a certain order.</p>Nikel WeisFri, 06 Jun 2014 08:48:31 -0400https://answers.axonivy.com/questions/650/is-it-possible-to-apply-field-order-of-a-persistent-data-class-to-database-table/752https://answers.axonivy.com/questions/650/is-it-possible-to-apply-field-order-of-a-persistent-data-class-to-database-table/731<p>The only solution I can think of is if you sort your data-class alphabetically and you add the ORDER BY attribute to your database query.</p>Daniel OechslinMon, 02 Jun 2014 12:47:57 -0400https://answers.axonivy.com/questions/650/is-it-possible-to-apply-field-order-of-a-persistent-data-class-to-database-table/731