I am currently migrating a MS Access front end to Libreoffice Base. The Back End is a MS Access database. The Front End application communicates with the back end using ODBC and this driver with microsoft access database engine. My development system is Windows XP with Libreoffice 4.2.1.1 The error is reproduced as follows: 1-I try to insert a record using a procedure that contains statements Access2Base. This procedure gives an error message in the update statement, but the record is inserted correctly in the database (Back End). 2- Now I realize the same procedure but using the API libreoffice and working properly. There is no warning. Apparently it's an erroneous warning Access2Base.
Created attachment 96859 [details] The attached database MS Access (. Accbd) is found, the code Front End, Front End application and a file to be read is located. The attached database MS Access (. Accbd) is found, the code Front End, Front End application and a file to be read is located.
El mismo procedimiento utilizado por Acces2Base, el error que aparece cuando se utiliza ODBC con MS Access, no aparece en HSQLDB.
The same procedure used by Acces2Base, the error that appears when using ODBC with MS Access, does not appear in HSQLDB.
Duplicate of bug 77012 *** This bug has been marked as a duplicate of bug 77012 ***