Take into account that the Firebird DAL adapter has a 64kb limit for
inserting blobs.
On Friday, April 27, 2018 at 4:27:48 AM UTC-6, Константин Комков wrote:
>
> Hello! I'm trying add data in my table.
> tables.py
> db_xml.define_table('xml_files',
> Field('F'),
> Field('I'),
> Fiel
db stats for 2.16.11
SELECT `labour`.`lab_description`, `labour`.`lab_id` FROM `labour` WHERE
((`labour`.`lab_id` IS NOT NULL) AND (`labour`.`lab_term_date` IS NULL)) ORDER
BY `labour`.`lab_description`, `labour`.`lab_id`;
1.11ms
---
db stats for 2.9.11
SET FOREIGN_KEY
Can you use db._timings to grab the generated SQL, both under 2.9.11 and
2.16.11, to see what the differences are?
Anthony
On Saturday, May 12, 2018 at 11:20:50 AM UTC-4, 98uj...@gmail.com wrote:
>
> After update from web2py 2.9.11 (mysql 5.6.37) to web2py 2.16.11 (mysql
> 5.6.40) the SQLFORM.
After update from web2py 2.9.11 (mysql 5.6.37) to web2py 2.16.11 (mysql
5.6.40) the SQLFORM.smartgrid shows zero results and at the top right
displays a message: Query Not Supported: (1066, "Not unique table/alias:
'labprice'").
This same code works in 2.9.11:
db.labprice._common_filter = l
Minimal example using web2py DAL as a script. I'm not using firebird but
your example with the string shows that the storage in a blob is working in
firebird (Note that a python string is saved as binary data in a blob). In
a webapp, move code to model file and to a controller, or use a form to
5 matches
Mail list logo