For a long time now we’ve abandon recnum in favour of using record ids. However, our development and testing is still done using the embedded database.

I would like to see an option, perhaps under the Database tab in the Configure Studio dialog, so that when a table is edited and saved its FD had File_Number and not Recnum.

Doing so would help us enforce our expected coding standards and not have to wait until the application is running against a SQL database.

Code:
#REPLACE FILE3002 NUMBERS
#REPLACE NUMBERS.Recnum |FN3002,0
#REPLACE NUMBERS.Key |FN3002,1
#REPLACE NUMBERS.Phone_Number |FS3002,2
#REPLACE NUMBERS.Description |FS3002,3
Would always be:

Code:
#REPLACE FILE3002 NUMBERS
#REPLACE NUMBERS.File_Number |CI3002
#REPLACE NUMBERS.Key |FN3002,1
#REPLACE NUMBERS.Phone_Number |FS3002,2
#REPLACE NUMBERS.Description |FS3002,3