Got it working. Thanks for the help.
On Jul 12, 6:28 pm, mdipierro <[email protected]> wrote: > No need. You should be able to just do > > db.define_table('property',Field('PropertyID','id'),....) > > i.e. add an extra field of type 'id' with the proper name. Let us know > if this works. > > Massimo > > On 12 Lug, 13:32, Michael Wolfe <[email protected]> > wrote: > > > > > 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
