Home » SQL & PL/SQL » SQL & PL/SQL » oracle+vb+oo4o ------------------plz help me to initiaate--------------
oracle+vb+oo4o ------------------plz help me to initiaate-------------- [message #1998] Sat, 15 June 2002 07:00 Go to next message
Suresh
Messages: 189
Registered: December 1998
Senior Member
plz anyone help me to initiate
i am working in or8i+vb6 with oo4o.
this is my requirment
for example
how do i populate a combo with the supplier name
and display the remaing details of the selected supplier in text boxes.

plz help me. i am new to vb.
Re: oracle+vb+oo4o ------------------plz help me to initiaate-------------- [message #2001 is a reply to message #1998] Sat, 15 June 2002 12:34 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
hope You can write the code in the when-list-changed trigger.
for ex: :text:=:List;
Re: oracle+vb+oo4o ------------------plz help me to initiate-------------- [message #2005 is a reply to message #2001] Sat, 15 June 2002 22:31 Go to previous messageGo to next message
Suresh
Messages: 189
Registered: December 1998
Senior Member
Please correct me
to display the fields that of the selected item
of a combo in vb from oracle with oo4o.
this is what i have done.

i declared 2 oradynaset obj as ,ordy1,ordyn2 in general_declaration
and used ordun1 to populate the combo cmb1 with supplier_name.it's populating.


xsql = "select..........supplier_nane = " & cmb1.Text
Set ordy2 = OraDatabase.CreateDynaset(xsql, 0&)
txt_code.Text = ordy2.Fields("supplier_code").Value

when i place this is cmb1's changed event i couldn't find any changes.
but when i place this in a click event of a button it gives
"object required" error message to the line
Set ordy2 = OraDatabase.CreateDynaset(xsql, 0&)

what should i do ? where i am making the mistake
thanks to mahesh.

suresh
Re: oracle+vb+oo4o ------------------plz help me to initiate-------------- [message #2009 is a reply to message #2001] Sun, 16 June 2002 08:41 Go to previous message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
hi,
im sorry to say that,
i have no idea by the coding level.
"objects required" arises mostly because of mismatch with the configurations.
check the following clientside installations with server side installation.

oracle installer
oracle named pipes adapter
oracle objects from OLE
oracle tcp/ip adapter
oracle trace collection services
oracle workgroup server relaease notes
required support files
sql*net client
Previous Topic: Temporary Table
Next Topic: Query
Goto Forum:
  


Current Time: Thu Mar 28 10:51:59 CDT 2024