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