Received: from mail.tol.it (mail.tin.it [194.243.154.49]) by hub.org
	(8.8.8/8.7.5) with ESMTP id FAA05671 for
	<pgsql-interfaces@postgreSQL.org>;
	Mon, 27 Apr 1998 05:49:17 -0400 (EDT)
Received: from Server.InfoTecna.com (Monza4-28.tin.it [195.31.128.27])
	by mail.tol.it (8.8.4/8.8.4) with ESMTP
	id LAA02839; Mon, 27 Apr 1998 11:47:22 +0200 (MET DST)
Received: from tm3.InfoTecna.com (Tm1.InfoTecna.com [192.168.1.1])
	by Server.InfoTecna.com (8.8.5/8.8.5) with SMTP id LAA02964;
	Mon, 27 Apr 1998 11:47:18 +0200
Message-Id: <3.0.5.32.19980427114718.007f5dd0@MBox.InfoTecna.com>
X-Sender: denis@MBox.InfoTecna.com
X-Mailer: QUALCOMM Windows Eudora Light Version 3.0.5 (32)
Date: Mon, 27 Apr 1998 11:47:18 +0200
To: Stephen Davies <scldad@sdc.com.au>
From: Sbragion Denis <infotecn@tin.it>
Subject: Re: [INTERFACES] Odbc and Visual Basic 
Cc: pgsql-interfaces@postgreSQL.org
In-Reply-To: <199804270841.SAA18020@mustang.sdc.com.au>
References: <Your message of "Mon, 27 Apr 1998 10:26:27 +0200."
	<3.0.5.32.19980427102627.008acaa0@MBox.InfoTecna.com>
Mime-Version: 1.0
Content-Type: text/plain; charset="us-ascii"

Hello,

At 18.11 27/04/98 +0930, you wrote:
>I don't quite follow this.
>
>I have VB5 apps which update PostgreSQL tables which do not have unique 
>indexes. The same apps work under VB4 as well and with both the old and new 
>ODBC drivers.
>
>I have never tried the Access route (and never will) but understood that the 
>unique index problem was an Access thing rather than VB.

I'm pretty sure about this. It's in the VB 5 help (I'll search it again in
the help and I'll quote it out in my next message). At least if you wan't
to use datacontrols and recordset to do updates. Of course you can always
perform the same updates using passthrough queries, and this, of course,
works. 
	You can do some test for example using VisData. It uses datacontrols to
perform operations and it needs unique indexes on the tables to allow updates.
Well, if I'm wrong, please explain me how to do it. I'm really interested.

Hope it helps.

Bye !

	Dr. Sbragion Denis
	InfoTecna
	Tel, Fax: +39 39 2324054
	URL: http://space.tin.it/internet/dsbragio