Hi,
I have an Access application (client) connected with another Access database (server). I would like to make a new version with the same client but with a Postgresql database as server.
My client application has forms with checkboxes objects. The controlsource of the checkboxes are boolean. Access sends (-1) for "true" and (0) for "false".
Unfortunately, Postgresql stores booleans as (1) for "true" and (0) for "false". So, marking the checkbox (v) on the forms raises a Posgresql error.
Unmarking makes no problem, off course.
I gess my problem would be solved if I could make Access to send (1) instead of (-1) when marking the checkbox (v).
Any idea would be welcome. Thanks.
I have an Access application (client) connected with another Access database (server). I would like to make a new version with the same client but with a Postgresql database as server.
My client application has forms with checkboxes objects. The controlsource of the checkboxes are boolean. Access sends (-1) for "true" and (0) for "false".
Unfortunately, Postgresql stores booleans as (1) for "true" and (0) for "false". So, marking the checkbox (v) on the forms raises a Posgresql error.
Unmarking makes no problem, off course.
I gess my problem would be solved if I could make Access to send (1) instead of (-1) when marking the checkbox (v).
Any idea would be welcome. Thanks.
