Thread: RE: [INTERFACES] win98 odbc problem?

RE: [INTERFACES] win98 odbc problem?

From
JT Kirkpatrick
Date:
Ah hah, that is the problem.  Thanks very much!

jt
-----Original Message-----
From:    Denis Sbragion [SMTP:sbragion@email.com]
Sent:    Saturday, April 24, 1999 4:51 AM
To:    JT Kirkpatrick; 'pgsql-interfaces@hub.org'
Cc:    Delain Huggins
Subject:    Re: [INTERFACES] win98 odbc problem?

Hello,

At 15.37 23/04/99 -0400, you wrote:
>I have two databases, oidetail and dispnotes:
>Create table oidetail (
>    Autoinv int4 not null,
>    Partnum char(6) not null check (partnum<>' '),
...
>    Oldrtrn bool default 1,
>    Oldrtrndt date
>    Constraint ssmsoidetail foreign key (autoinv) references ssms);

it looks like this table doesn't have a primary key. Access, and VB and any
other Microsoft program that uses the MS Jet DB Engine, doesn't let you add
records on a table that doesn't have at least one unique index on it.

Bye!
--Sbragion DenisInfoTecnaTel, Fax: +39 039 2324054URL: http://infotecna.home.dhs.org