To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=112790 Issue #|112790 Summary|SQLite via ODBC: Not editable Component|Database access Version|OOO320m18 Platform|PC URL| OS/Version|All Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|none Assigned to|dbaneedsconfirm Reported by|mechtilde
------- Additional comments from [email protected] Tue Jun 29 14:29:57 +0000 2010 ------- <copied from IRC> problem <Oliver1804> It is impossible to delete or edit records from OpenOffice Base connected <Oliver1804> as a frontend to sqlite via ODBC-Driver. <Oliver1804> The circumstances are described in the following paragraph <reproduction>. <Oliver1804> environment <Oliver1804> OS : Win XP <Oliver1804> Database : sqlite 3.6.23.1 (http://www.sqlite.org/) <Oliver1804> ODBC-Driver: sqliteodbc 0.86 (http://www.ch-werner.de/sqliteodbc/) <Oliver1804> Frontend : OpenOffice Base 3.2.1 <Oliver1804> reproduction <Oliver1804> ------------ <Oliver1804> step 01: create DB and tables with sqlite <Oliver1804> ------- <Oliver1804> a) produce file script.sql with the following script <Oliver1804> CREATE TABLE doesntwork( <Oliver1804> id INTEGER PRIMARY KEY AUTOINCREMENT, <Oliver1804> someint INTEGER NOT NULL, <Oliver1804> UNIQUE(someint) <Oliver1804> ); <Oliver1804> INSERT INTO doesntwork(someint) VALUES(2); <Oliver1804> b) create database test.db3 with tables <Oliver1804> sqlite3 test.db3 < script.sql <Oliver1804> ready! (in the directory from where you call sqlite3 you'll <Oliver1804> now find test.db3) <Oliver1804> step02: create a DSN for the ODBC-Driver <Oliver1804> ------ <Oliver1804> step03: try to delete/edit the record from OpenOffice in the section tables <Oliver1804> ------ <Oliver1804> -> doesn't work as indicated by the tablename <Oliver1804> magic: <Oliver1804> ----- <Oliver1804> If I do <Oliver1804> INSERT INTO doesntwork(someint) VALUES(1); <Oliver1804> instead of <Oliver1804> INSERT INTO doesntwork(someint) VALUES(2); <Oliver1804> I can delete or edit the record --------------------------------------------------------------------- Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
