Re: Access 97 and pgsqlodbc version 7.03.0100 - Mailing list pgsql-odbc

From Ben Trewern
Subject Re: Access 97 and pgsqlodbc version 7.03.0100
Date
Msg-id BAY8-F94cm9t0CI76rO00005212@hotmail.com
Whole thread Raw
In response to Access 97 and pgsqlodbc version 7.03.0100  ("Ben Trewern" <ben_trewern@hotmail.com>)
List pgsql-odbc
Yes there is a unique index on the master table's primary key, and there is
also an index on the detail table's foreign key.

Regards,

Ben

>From: Hiroshi Inoue <Inoue@tpf.co.jp>
>To: Ben Trewern <ben_trewern@hotmail.com>
>CC: pgsql-odbc@postgresql.org
>Subject: Re: [ODBC] Access 97 and pgsqlodbc version 7.03.0100
>Date: Wed, 21 May 2003 10:58:26 +0900
>
>Ben Trewern wrote:
> >
> > This seems to have fixed the GPF problem but now if I look at a Master -
> > Detail form I get #Deleted in some of the fields in the detail subform:
> >
> > Field1            Field2      Descripton1           Field4      Field5
> >
>----------------------------------------------------------------------------------
> >     10          1/1/03    Description OK      1000.00      1.148
> > #Deleted #Deleted    Description OK      #Deleted     #Deleted
> > #Deleted #Deleted    Description OK      #Deleted     #Deleted
> >
> > I'm not sure if the above will look OK on your e-mail client but it is
>meant
> > to show the first line OK but the following lines have #Deleted
>everywhere
> > except the Description1 field which is a memo.
>
>Do you create an unique index on the table or specify a
>really unique identifier for the table ?
>
>regards,
>Hiroshi Inoue
>    http://www.geocities.jp/inocchichichi/psqlodbc/
>
>---------------------------(end of broadcast)---------------------------
>TIP 5: Have you checked our extensive FAQ?
>
>http://www.postgresql.org/docs/faqs/FAQ.html

_________________________________________________________________
Find a cheaper internet access deal - choose one to suit you.
http://www.msn.co.uk/internetaccess


pgsql-odbc by date:

Previous
From: "Ben Trewern"
Date:
Subject: Re: Access 97 and pgsqlodbc version 7.03.0100
Next
From: Hiroshi Inoue
Date:
Subject: Re: Access 97 and pgsqlodbc version 7.03.0100