Unless you specify Field(...., requires=IS_INT_IN_RANGE(-1e100,1e100))
it defaults to IS_INT_IN_RANGE(-1e12, +1e12). Yes it is an odd choice. On Monday, 3 September 2018 07:53:29 UTC-7, [email protected] wrote: > > Hello, > > I am using the database administration tool to import a small portion of > data to one of the tables in my db (standard sqlite). The code to create > the table: > db.define_table('dict_prod_match', > Field('prod_tes_id','integer'), #this field is causing > troubles > Field('prod_ros_id','integer') > ) > Even though, the first field is 13 digits long so should be valid for > integer => ( > IS_INT_IN_RANGE(-1e100, 1e100) > ) > , I have problems with uploading the data (and receive None instead of > value). When I tried to insert one record manually I received an error > notification to Enter an integer between -2.14748e+09 and 2.14748e+09. > > Could you please help me with resolving the issue? Thank you very much in > advance! > Best Regards, > -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
