forms and native SQL
Oliver Peters <[email protected]> Thu, 11 Nov 2010 23:52:44 +0100
| Newsgroups | gmane.comp.openoffice.dba.user |
|---|---|
| Message-ID | <1289515964.1905.17.camel@oliver-desktop> |
Hello, I'm working with sqlite 3.7.3 as an external db via ODBC (http://www.ch-werner.de/sqliteodbc/) under WinXP. My frontend is OOo Base (330 RC4). For inserting and updating tables I use forms. If I choose SQL as a datasource for the form and don't allow OOo to check the SQL (because I use sqlite specific constructs) I can't insert or update anymore. The same with "ordinary" queries. I feel(!) that this is a wanted behaviour that is reproducable with other dbs (PostgreSQL, MySQL,...) but I can't explain why this should be necessary. Any hints/coaching are/is appreciated. Oliver