Updating a subform entry with an integer field fails
VFront is a dynamic front-end for MySQL, PostgreSQL and SQLite DBs.
Status: Beta
Brought to you by:
marciuz
Menu
▾
▴
#23 Updating a subform entry with an integer field fails
When the subform contains an integer, vfront uses quoted values in the WHERE condition, but postgresql do not allow quoting of non-string items.
postgresql log:
2014-12-29 15:24:07 CET ERROR: invalid input syntax for integer: "" at character 257
2014-12-29 15:24:07 CET STATEMENT: UPDATE contracts SET company=1 WHERE 1=1 AND id=14 AND owner=6 AND startdate='2013-10-02' AND enddate='2013-11-30' AND position=2 AND contracttype=3 AND salarybasegross=2800.00 AND salaryvargross=0.00 AND salarycurrency=1 AND (company IS NULL OR company='')
The 'company' column of the contracts table is of type INTEGER, hence vfront should not try to match an "OR company=''" condition on it.
Seen on vfront v0.96c (ie latest stable).
note: this happens when trying to modify the integer field (modifying another field works fine). Also, the same problem appears with columns of type 'DATE' (ie. vfront tries to match an empty value using '', while this is illegal on postgresql).