I think it depends on the DB. If you always make your fields lower case in web2py, there is a much better chance they will always work consistently across all DBs. Perhaps not so much a convention, but more 'good practice'.
On Mar 7, 9:15 am, StUStD <[email protected]> wrote: > I found out, the problem is not in the numeric part of the names, > rather, names containing uppercase letters cause the problem. Again, > is it convention that database field names should be lowercase? > > On Mar 7, 9:46 am, StUStD <[email protected]> wrote: > > > I experience inserting and updating problems (only explicit SQL > > statements in de dbadmin work, forms don't) with fieldnames like B1x, > > B1y, B2x, B2y, etc, only to find out that fieldnames with numbers > > don't work... Is this default behaviour, convention, or caused by a > > bug? Thanks. > >
