Welcome to dbForumz.com!
FAQFAQ      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

Using workspace in ADO

 
   Database Forums (Home) -> Oracle RSS
Next:  Forms List of Properties by for element  
Author Message
Enver




Joined: Aug 03, 2005
Posts: 3



(Msg. 1) Posted: Wed Aug 03, 2005 7:57 am
Post subject: Using workspace in ADO

I want to convert following DAO code into ADO.

Code:
Dim oRS1 As Recordset
    Dim oRS2 As Recordset
    Dim oWRK As Workspace

    Dim i As Long

    i = 0

    Set oWRK = CreateWorkspace("", "", "", dbUseODBC)

    Set oDB = oWRK.OpenDatabase("vgtp", dbDriverComplete, False, "ODBC;DSN=VGTP;UID=ACCFE;DBQ=VGTP; PWD=ACCFE_X")

    Set oRS1 = oDB.OpenRecordset("SELECT * FROM TESTRC")

    Do While Not oRS1.EOF

        Set oRS2 = oDB.OpenRecordset("SELECT * FROM TESTRC WHERE VELD01 = '" & oRS1(1) & "'", dbOpenDynaset)


Can someone please help me with this. I don't know how to use workspace in ADO.

Enver

 >> Stay informed about: Using workspace in ADO 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
Oracle view question - Hi, The source table has a column which is varchar2(100). If I create a view new_view on the column as select substr(column_name, 1, 20) new_col from table, then "desc new_view" command shows size of new_col as 60 i.e. 3 times the intended siz...

Trigger Problem updating same table - I have a trigger which I want to update certain colums of the row being updated based on data entered into the first column. The table is being updated from an external datasource using HS. Here is my trigger: CREATE OR REPLACE TRIGGER..

Why is 9i pausing? - Hi all, I'm experiencing an intermittent performance problem reading and writing a 9i database from Sqlplus. I'm running Sqlplus on my laptop and the DB is on a Sun box in the same office. It seems that if my connection to the DB is inactive for a perio...

Q:Converting Forms to J2EE - Hi' Have anyone tried to use any of the conversion utilities on the market? - would you like to share your experiences? Rgds, Henrik

how: 3 blocks (1:many:many) using only 1 database source - Hi everyone! I'm working on this Forms program with the following properties: + it has 3 blocks, all using the same database table with this relationship: 1 block - 2 block : 1 is to many 2 block to 3 block : many is to many. What is the..
   Database Forums (Home) -> Oracle All times are: Pacific Time (US & Canada) (change)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]