Re: Access 97 and pgsqlodbc version 7.03.0100

The Master table Primary key is varchar(10) but the detail table has a
varchar(50) as the joined field.  I'll try changing it now.

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

_________________________________________________________________
Get Hotmail on your mobile phone http://www.msn.co.uk/msnmobile