I have dozens of tables in an existing MSSQL database all with autonumber ID primary keys, but none that are named 'id'. They are instead named PropertyID, ClientID, etc. The official documentation seems to suggest renaming each of these fields to 'id'. However, that would require breaking hundreds of existing queries in other applications that use this database. Surely there must be some way to specify a name for an existing autonumber field to be used instead of 'id'.
I'd really like to try web2py because it seems well thought-out, but if this is not possible it is a deal-breaker for me and I'll have to go back to Django (at least for this project...and any other future project that must support legacy databases). Thanks, -Mike
