Thank you, I did as Villas said and is working fine but I do not understand the DAL for checking reserved SQL keywords.
If put the following connection string : db = DAL('firebird:// SYSDBA:master...@localhost/c:\programas\ctodb.fdb', check_reserved=['firebird']) I get the same error as if I didn't put it. What should happens when in the connection string appears check_reserved=['firebird'] ???? Regars On 5 mar, 05:08, Thadeus Burgess <thade...@thadeusb.com> wrote: > Also I added support so the DAL can check reserved SQL keywords. > > http://web2py.com/book/default/section/6/2 > > -Thadeus > > > > On Thu, Mar 4, 2010 at 7:35 PM, villas <villa...@gmail.com> wrote: > > 'Password' is a reserved word and causes a problem in Firebird. Try > > this: > > > auth=Auth(globals(),db) > > auth.settings.password_field='password2' # Insert this line here. > > auth.define_tables(migrate=False) > > > You can then work with a 'password2' field instead :-) > > > Regards, > > --David > > > -- > > You received this message because you are subscribed to the Google Groups > > "web2py-users" group. > > To post to this group, send email to web...@googlegroups.com. > > To unsubscribe from this group, send email to > > web2py+unsubscr...@googlegroups.com. > > For more options, visit this group > > athttp://groups.google.com/group/web2py?hl=en. -- You received this message because you are subscribed to the Google Groups "web2py-users" group. To post to this group, send email to web...@googlegroups.com. To unsubscribe from this group, send email to web2py+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/web2py?hl=en.