From: | "Ben Trewern" <ben_trewern(at)hotmail(dot)com> |
---|---|
To: | Inoue(at)tpf(dot)co(dot)jp |
Cc: | pgsql-odbc(at)postgresql(dot)org |
Subject: | Re: Access 97 and pgsqlodbc version 7.03.0100 |
Date: | 2003-05-21 09:08:15 |
Message-ID: | BAY8-F86bhsKd6QR7j10002a7e5@hotmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-odbc |
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(at)tpf(dot)co(dot)jp>
>To: Ben Trewern <ben_trewern(at)hotmail(dot)com>
>CC: pgsql-odbc(at)postgresql(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Ben Trewern | 2003-05-21 09:33:06 | Re: Access 97 and pgsqlodbc version 7.03.0100 |
Previous Message | Hiroshi Inoue | 2003-05-21 01:58:26 | Re: Access 97 and pgsqlodbc version 7.03.0100 |