Re: Help on ODBC in VB to Oracle
Date: Thu, 17 Jun 1999 22:42:37 -0600
Message-ID: <W6ka3.25$Y25.293_at_news.megsinet.net>
There are several reasons that the recordset could be read only. The most common is that the Oracle table does not have a primary key (a field that is unique, and not null). There are other reasons, such as (if I remember correctly) certain join conditions that will also cause this.
Rick
<slinzer_at_mail.reltek.com> wrote in message
news:7k6j6q$39u$1_at_nnrp1.deja.com...
> I am having some trouble accessing an Oracle database via ODBC. I can
> get an Oracle connection/database object, but when I open a recordset
> from either the tabledef or a CreateQueryDef, the recordset always
> comes up Updatable = False. Note the Database object and the query
> object are Updatable = True!!
> Any help would be appreciated!!
>
>
> Sent via Deja.com http://www.deja.com/
> Share what you know. Learn what you don't.
Received on Fri Jun 18 1999 - 06:42:37 CEST