Received: from out2.ibm.net (out2.ibm.net [165.87.194.229]) by hub.org (8.9.1/8.9.1) with ESMTP id WAA08332 for ; Mon, 9 Nov 1998 22:08:27 -0500 (EST) (envelope-from llestat@ibm.net) Received: from linux-serv (llestat@slip-129-37-193-127.fl.us.ibm.net [129.37.193.127]) by out2.ibm.net (8.9.1/8.6.9) with SMTP id DAA84194 for ; Tue, 10 Nov 1998 03:08:26 GMT From: Richard Reyes Reply-To: llestat@ibm.net To: PostgreSQL Interfaces Subject: VisData & ODBC Date: Mon, 9 Nov 1998 21:58:10 -0500 X-Mailer: KMail [version 0.6.5] Content-Type: text/plain MIME-Version: 1.0 Message-Id: <98110922031600.00372@linux-serv> Content-Transfer-Encoding: 8bit Thanks all Byron, Sbragion Denis,the unique indexes was the key to making it work since I've been creating most off the apps with pgaccess I didn't know I could define the primary key in the create table screen by typing primary key after the field type. After doing a simple vacuum all the changes where recognized by VisData and the ODBC driver (set the driver to recognize unique indexes). Thanks Again, Richard Reyes Who said Linux has no Tech support ??