Results 1 to 3 of 3

Thread: OO4O with VB

  1. #1
    Join Date
    Apr 2003
    Posts
    1

    Unanswered: OO4O with VB

    Hi,

    May I ask a question ...

    Befor I use ADODB connect to Oracle that set DataGrid way is
    -------------------------------------------------------------------------
    Set cn_t = New ADODB.Connection
    cn_t.ConnectionString ="Provider=OraOLEDB.Oracle.1;
    Password=shopfloor;User ID=shopfloor;Data Source=" &
    DB & ";Persist Security Info=True"
    cn_t.Open

    Set rs_t = New ADODB.Recordset
    rs_t.CursorType = adOpenKeyset
    rs_t.LockType = adLockOptimistic
    rs_t.Open "select * from abo_sp_test where datet is not null order by

    Set DataGrid1.DataSource = rs_t ' <--------- before set



    But now if I use OO4O how to set Datagrid connect to Oracle ?
    ------------------------------------------------------------------------------
    Set OraSession = CreateObject("OracleInProcServer.XOraSession")
    Set OraDatabase = OraSession.OpenDatabase
    ("erp", "ifsapp/aboerpifs", 0&)
    Set OraDynaset = OraDatabase.CreateDynaset("select * from
    abo_sp_define", 0&)
    Set OraFields = OraDynaset.Fields

    OraDynaset.MoveFirst

    Set DataGrid1.DataSource = ???? '<------------ how to set ??

    Please some Ace friends help me!

    Thanks

    Cacey

  2. #2
    Join Date
    Dec 2005
    Posts
    1

    Exclamation Datagrid connect on OO4O

    I've got the same problem.. anyone pls help!!!

  3. #3
    Join Date
    May 2004
    Location
    Dominican Republic
    Posts
    721
    Have you both tried Set DataGrid1.DataSource = OraDatabase.CreateDynaset("select * from
    abo_sp_define", 0&) ???

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •