Thread: replacing multi-table-queries-bound-forms by view-bound forms

I try to connect my msaccess application to Postgresql.
I have a lot of query-bound forms, which also do some updating and
insert,
which I tried to transfer to view-bound forms.
As far as I understand access transfers an transaction to Postgres but
in the update case
never gets a positive reply and makes a rollback.
I defined my view update with rules and pgpsql-functions which is ok
with psql.
What is the best way to change my query-bound-forms  to use them with
psql

KBR Immobilien GmbH wrote:
>
> I try to connect my msaccess application to Postgresql.
> I have a lot of query-bound forms,

I would suggest you would design the forms into Visual Basic
and use ODBC connection to PostgreSQL.

--
Keith Gray

Technical Development Manager
Heart Consulting Services P/L
mailto:keith@heart.com.au

I've had problems with views using linked tables with there being no primary
key.
To solve this I just created a table with a primary key and then created the
view by createing a select rule on it.
Hope this helps,
- Stuart

> -----Original Message-----
> From: KBR Immobilien GmbH [mailto:Hannover@kbr-immobilien.de]
> Sent: 15 March 2002 10:27
> To: pgsql-odbc@postgresql.org
> Subject: replacing multi-table-queries-bound-forms by view-bound forms
>
>
> I try to connect my msaccess application to Postgresql.
> I have a lot of query-bound forms, which also do some updating and
> insert,
> which I tried to transfer to view-bound forms.
> As far as I understand access transfers an transaction to Postgres but
> in the update case
> never gets a positive reply and makes a rollback.
> I defined my view update with rules and pgpsql-functions which is ok
> with psql.
> What is the best way to change my query-bound-forms  to use them with
> psql
>
>