Oracle primary key not getting picked up as "KEYCOLUMN" in VB 6 using ADO 2.5
- From: "Sean" <seanmNOSPAM@xxxxxxx>
- Date: Thu, 16 Nov 2006 14:50:09 -0700
Hello all,
I'm trying to get ADO to recognize my primary key "ID" on an Oracle 9i
table. This is important for ADO to be able to locate the record for
updating. Currently, when I check the "KEYCOLUMN" property of the "ID"
field, it's coming back "FALSE" which is incorrect. The primary key is
defined on the table OK, so I'm not sure how to get ADO to recognize my "ID"
field.
I've tried the following
rs.CursorLocation = adUseServer
rs.ActiveConnection = cn
rs.Properties("Unique Rows").Value = True '<--------ERROR HERE
rs.CursorLocation = adUseClient
I get the error "Provider does not support the property". This happens for
both Oracle for ODBC and MS ODBC for Oracle drivers. How can I get ADO to
recognize my primary key for updates? Thanks,
Sean
.
- Prev by Date: RE: Sporadic access violation in _ConnectionPtr.Release()
- Next by Date: Re: URGENT !!! Operation must use an updateable quary
- Previous by thread: Re: Optimize DataTable Select Method
- Next by thread: CursorLocation for Execute Method
- Index(es):
Relevant Pages
|
|
