It will give you an error it you have a table/field name that is a reserved keyword in "firebird"
On Mar 5, 4:10 am, salbefe <[email protected]> wrote: > 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 <[email protected]> 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 <[email protected]> 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 [email protected]. > > > To unsubscribe from this group, send email to > > > [email protected]. > > > 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 [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/web2py?hl=en.
