Received: from fep10-svc.tin.it (mta10-acc.tin.it [212.216.176.41]) by hub.org (8.9.3/8.9.1) with ESMTP id XAA54252 for ; Sun, 25 Apr 1999 23:01:37 -0400 (EDT) (envelope-from sbragion@email.com) Received: from Server.InfoTecna.com ([212.216.17.163]) by fep10-svc.tin.it (InterMail v4.0 201-221-105) with ESMTP id <19990426030126.GYAQ29314.fep10-svc@Server.InfoTecna.com>; Mon, 26 Apr 1999 05:01:26 +0200 Received: from tm3 (Tm3.InfoTecna.com [192.168.1.3]) by Server.InfoTecna.com (8.8.5/8.8.5) with SMTP id KAA00370; Sat, 24 Apr 1999 10:50:46 +0200 Message-Id: <3.0.6.32.19990424105044.035c8ec0@MBox.InfoTecna.com> X-Sender: denis@MBox.InfoTecna.com X-Mailer: QUALCOMM Windows Eudora Light Version 3.0.6 (32) Date: Sat, 24 Apr 1999 10:50:44 +0200 To: JT Kirkpatrick , "'pgsql-interfaces@hub.org'" From: Denis Sbragion Subject: Re: [INTERFACES] win98 odbc problem? Cc: Delain Huggins In-Reply-To: <01BE8D9F.28F1BC00.jt-kirkpatrick@mpsllc.com> Mime-Version: 1.0 Content-Type: text/plain; charset="us-ascii" 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