Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: insufficient key column information

Re: insufficient key column information

From: tojo <Tojo_at_hotmail.com>
Date: Fri, 28 Feb 2003 09:35:48 +0100
Message-ID: <MPG.18c93dd39a1687d99896f8@news.t-online.de>


In article <1f1d904a.0302271141.31a8f896_at_posting.google.com>, bangorme_at_hotmail.com says...
> My project originally had a VB frontend and a MSAccess backend. Now
> I'd like to migrate it over to a Oracle backend and use the ADO code
> from the original frontend. I've had lots of problems, but the latest
> has got me stumped. When I try to update using an altered recordset,
> I get an "insufficient key column information for updating or
> refreshing" error. I haven't changed anything, so I'm not sure what
> key is being talked about.
>
> Any ideas would be appreciated.
>

If you are joining 2 or more tables in your recordset, you need to be sure that all primary keys and foreign keys from all tables are available. Otherwise you'll get that pesky error and you can't update the recordset.

Received on Fri Feb 28 2003 - 02:35:48 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US