Hello, I recently ran into this problem as well - field names with uppercase characters were ignored in SQLFORM inserts/updates. Luckily, I found that the behavior is fixed in the latest 1.93.2 release of web2py. Try upgrading and see if that solves the problem.
Kevin On Mar 7, 4: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.
