Received: from brianp.demon.co.uk (IDENT:brian@brianp.demon.co.uk [158.152.38.192]) by hub.org (8.9.3/8.9.3) with ESMTP id MAA45989 for ; Thu, 10 Feb 2000 12:24:37 -0500 (EST) (envelope-from brian@brianp.demon.co.uk) Received: from localhost (localhost [[UNIX: localhost]]) by brianp.demon.co.uk (8.9.3/8.8.7) id RAA01071 for pgsql-interfaces@postgresql.org; Thu, 10 Feb 2000 17:24:34 GMT From: Brian Piatkus To: pgsql-interfaces@postgresql.org Subject: ODBC Declare/fetch & VB Date: Thu, 10 Feb 2000 17:18:27 +0000 X-Mailer: KMail [version 1.0.28] Content-Type: text/plain MIME-Version: 1.0 Message-Id: <00021017243400.01062@brianp> Content-Transfer-Encoding: 8bit Hi 1) Latest version of the insight driver (I think ... 007) 2) seems to work fine for MSquery & Access as far as my brief testing goes 3 I have a VB front end which runs a simple query on a pg view. This is OK with the declare/fetch option switched off but when it is switched on, the recordset returned seems to consist of many replicates of the same row, albeit with the correct number of rows returned. (some rows are missing). Any ideas ? Thanks