OraFAQ Forum: SQL & PL/SQL » oracle+vb+oo4o ------------------plz help me to initiaate--------------

Home » SQL & PL/SQL » SQL & PL/SQL » oracle+vb+oo4o ------------------plz help me to initiaate--------------

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

oracle+vb+oo4o ------------------plz help me to initiaate-------------- [message #1998]

Sat, 15 June 2002 07:00

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.

Report message to a moderator

Re: oracle+vb+oo4o ------------------plz help me to initiaate-------------- [message #2001 is a reply to message #1998]

Sat, 15 June 2002 12:34

Mahesh Rajendran
Messages: 10708
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;

Report message to a moderator

Re: oracle+vb+oo4o ------------------plz help me to initiate-------------- [message #2005 is a reply to message #2001]

Sat, 15 June 2002 22:31

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

Report message to a moderator

Re: oracle+vb+oo4o ------------------plz help me to initiate-------------- [message #2009 is a reply to message #2001]

Sun, 16 June 2002 08:41

Mahesh Rajendran
Messages: 10708
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

Report message to a moderator

Previous Topic:	Temporary Table
Next Topic:	Query

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Jul 06 04:53:58 CDT 2025