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