please help to populate [message #1897] |
Sun, 09 June 2002 07:25 |
Suresh
Messages: 189 Registered: December 1998
|
Senior Member |
|
|
please anyone help to sort out this prob
i want to populate a combo box in vb from ora.8i.
i am using oo4o.
but it populate only one record.
what is wrong ?
Set orasession = CreateObject("oracleinprocserver.xorasession")
connect = "user" + "/" + "password"
database = "database_instant"
Set OraDatabase = orasession.OpenDatabase(database, connect, ho&)
Set oradynaset = OraDatabase.CreateDynaset(sqlstatement, 0&)
oradynaset.MoveFirst
Do
combo_name.AddItem oradynaset.Fields("field_name").Value
oradynaset.MoveNext
Loop While oradynaset.EOF
thankig you
suresh
|
|
|
Re: please help to populate [message #2448 is a reply to message #1897] |
Tue, 16 July 2002 17:44 |
seng
Messages: 191 Registered: February 2002
|
Senior Member |
|
|
Just concern only, i think that you need to make sure below code is correct to additem into combobox. It might be overlapping in combobox.. Other part is correct ..
************ combo_name.AddItem oradynaset.Fields "field_name").Value
oradynaset.MoveNext
Hope this is helping
|
|
|