Re: basic questions with odbc and visual basic. - Mailing list pgsql-odbc

From Gary Doades
Subject Re: basic questions with odbc and visual basic.
Date
Msg-id 4158710E.9625.3E33A685@localhost
Whole thread Raw
In response to Re: basic questions with odbc and visual basic.  ("Merlin Moncure" <merlin.moncure@rcsonline.com>)
List pgsql-odbc
> In this case the recordset is read only then?  I need to find some way
> to allow the data aware components to work.  I did some more research
> and found there supposedly is an 'update criteria' property to fix the
> update problem
> http://support.microsoft.com/default.aspx?scid=kb;EN-US;190727 but that
> doesn't work.  Can it really be there is no way to edit data in data
> aware controls in access/vb?
>
> Merlin
>

I gave up trying to use data-aware controls in VB a very long time ago
(about 3 weeks after trying to get them to work AFAIR). I have used MS
SQLServer and Sybase SQL Anywhere with VB 6.

If you use readonly recordsets to fetch data and simple update/insert
commands to change data, the whole thing is much easier and more
efficient in the long run.

You probably can get it to work eventually. I did for small utilities and
such, but would not consider it for anything serious.

Cheers,
Gary.


pgsql-odbc by date:

Previous
From: "Greg Campbell"
Date:
Subject: Re: basic questions with odbc and visual basic.
Next
From: "Merlin Moncure"
Date:
Subject: Re: basic questions with odbc and visual basic.