On 11 mei 2009, at 06:59, James McKenzie wrote:
Johan Henselmans wrote:
So, this mailinglist does exist...
I just found out that 3.1 is officially announced. I just want to
remark that I am still waiting until an OS X version pops up that
will work again with database forms. It has been since some time that
an old database bug popped up again:
see
http://www.openoffice.org/issues/show_bug.cgi?id=84506
which basically is (I think) a quoting error which revolves around
queries:
SELECT * FROM "public"."contacten" WHERE (
"public.contacten"."achternaam" LIKE '%ensel%' )
This type of query that fails with the following error:
SQL-status: 42P01 ERROR: missing FROM-clause entry for table
"public.contacten"
The query is generated by a filter in a form navigation element in a
form, so there is no way to work around this.
This is a real showstopper for me. Can anybody confirm that somebody
is working on this?
(Oh, and the same database file works in the latest NeoOffice
version)
What database type is this? I'm looking at the syntax and this is not
ANSI SQL compliant as the WHERE table and FROM table names do not
match.
The Where table is public (schema) contacten (table), just as the From
table. Problem is that those do not match as a query because of the
quoting in the SQL.
This is automatically generated once you create a From or a Query and
start filtering the results.
In the meanwhile I have found a workaround by unsetting the use of the
schema name in SELECT instructions in the preferences of the advanced
properties of the database connection.
James McKenzie
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
Regards,
Johan Henselmans
http://www.netsense.nl
Tel: +31-20-6267538
Fax: +31-20-6279159
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
