Re: oracle outer join

From: Val Mazur (group51a_at_hotmail.com)
Date: 08/04/04 

Date: Tue, 3 Aug 2004 23:32:30 -0400

Hi,

It could be a limitation of the provider, but I do not think so. What type
of the cursor do you get after you opened it? Check LockType, CursorType and
CursorLocation properties of the recordset after it was opened (not before). 

-- 
Val Mazur
Microsoft MVP
"terry" <terry@discussions.microsoft.com> wrote in message 
news:3D24383D-D1F3-434C-9F09-C82B362F669C@microsoft.com...
> Hi alls:
>    I use ADO and set the provider is 'OraOLEDB.Oracle.1';
>   when I use outer join to get ado recordset object, The recordset can't 
> editable,
>   Is there any way to set the recordset editable?
>

Relevant Pages

  • Re: vb6 ado & VISTA 64bit = no work
    ... seek and index under recordset. ... Most likely the provider, cursor, etc. combination you are using doesn't ... a headache to support different os with this application. ...
    (microsoft.public.vb.database.ado)
  • Re: recordcount property not correct....
    ... RecordCount returns -1 in a case if provider is no capable to return actual ... count for the specified type of cursor. ... even when there are records in the recordset. ... > Dim IssueRS As ADODB.Recordset ...
    (microsoft.public.vb.database.ado)
  • oracle outer join
    ... I use ADO and set the provider is 'OraOLEDB.Oracle.1'; ... when I use outer join to get ado recordset object, The recordset can't editable, ...
    (microsoft.public.data.ado)
  • Re: Gebundene Controls aus ADO-Recordset aktualisieren
    ... Engpass ist vor allem das LAN und der Server selbst. ... ob man mit einem SQL-Server oder der Jet-Engine ... Cursor und statischen Recordsets, egal welches Datenbanksystem ... dass eine Bewegung im Recordset eben auch ...
    (microsoft.public.de.vb.datenbank)
  • Re: Gebundene Controls aus ADO-Recordset aktualisieren
    ... Wozu ein serverseitiger Cursor? ... Ich kann also z.B. bei adOpenKeyset im Programmcode ... CursorLocation adUseServer bei Access sinnlos, ... wenn Du in Deinem Recordset zu einem anderen ...
    (microsoft.public.de.vb.datenbank)