السلام عليكم ورحمة الله وبركاته
اسعد الله صباح المبرمجين المدبدعين
عندي سؤال بسيط بارك الله فيكم
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