RE: [INTERFACES] win98 odbc problem?

Ah hah, that is the problem. Thanks very much!

jt
-----Original Message-----
From: Denis Sbragion [SMTP:sbragion(at)email(dot)com]
Sent: Saturday, April 24, 1999 4:51 AM
To: JT Kirkpatrick; 'pgsql-interfaces(at)hub(dot)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 Denis
InfoTecna
Tel, Fax: +39 039 2324054
URL: http://infotecna.home.dhs.org