Re: [SQL] problem with update data sets from front ends 8.4, Ubuntu 10.04

2011-06-01 Thread Dean le Roux
I installed the recommended JDBC driver. Set it up to connect using Open office. Still need to test to see how the queries build now, but problem is that the access to the database is dramatically slower than using the sdbc. Is this to be expected. thanks. On 05/24/2011 07:58 AM, Dean le

Re: [SQL] problem with update data sets from front ends 8.4, Ubuntu 10.04

2011-05-23 Thread Dean le Roux
TER JOIN "public"."HOMADDRESS" AS "HOMADDRESS" LEFT OUTER JOIN "public"."HOMNLPOST" AS "HOMNLPOST" ON "HOMADDRESS"."ADDREF" = "HOMNLPOST"."ADDREF" ON "HOMINVOLV"."INVREF"

[SQL] problem with update data sets from front ends 8.4, Ubuntu 10.04

2011-05-23 Thread Dean le Roux
postgres 8.3 to 8.4 Open office base 3.2 Ubuntu 9.04 to 10.04 (new install) I recently upgraded from Ubuntu 9.04 to Ubuntu 10.04. Security and other updates have been effected. I used webmin to restore the databases. Since migrating to Linux around 2006 we were successful in converting our mdb