thanks villas, after modified the dal parameter DAL(..., ignore_field_case
= True, entity_quoting = False, ...), theres a lot of thing deal with
auth_user in firebird:
e.g.
1. deal with auth_user password field (already posted above)
auth.settings.password_field = 'password2'
auth.define_tables(u
Hi Stifan
Earlier this year web2py started to quote all SQL entities and this caused
a problem for Firebird because this DB creates entities in uppercase by
default.
Anyhow, it may help if you change your DAL declaration to use switches:
ignore_field_case,
entity_quoting
DAL('firebird://SYS
the reserve keyword in firebird works but when use it with another table
relation (reference type) it returns an error
*step to reproduce an error*
*#create database firebird on ubuntu terminal*
isql-fb -user SYSDBA -password password
CREATE DATABASE '/testdb.fdb' user 'SYSDBA' password 'passwor
On Mar 4, 10:08 pm, Thadeus Burgess wrote:
> Also I added support so the DAL can check reserved SQL keywords.
>
> http://web2py.com/book/default/section/6/2
This is ok - but for dynamic sites (e.g. analysis, prototyping) this
seems incomplete...
In general, it would seem, when DAL tries to upda
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 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 s
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
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 wrote:
> 'Password' is a reserved word and causes a problem in Firebird. Try
> this:
>
> auth=Auth(globals(),db)
> auth.settings.passw
'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
8 matches
Mail list logo