Home » SQL & PL/SQL » SQL & PL/SQL » what is wrong with this - urgent plzzzzzzzzzzzzzzzzzzzzzzzzzz
what is wrong with this - urgent plzzzzzzzzzzzzzzzzzzzzzzzzzz [message #1950] Wed, 12 June 2002 10:12 Go to next message
Suresh
Messages: 189
Registered: December 1998
Senior Member
i have populted the combo cmb_category.
i have declared oradynaset1 too.

Dim xsql As String
Dim xcat As String
xcat = cmb_category.Text
xsql = "select category_code from part_category where category_desc ='" & xcat & "'"
Set oradynaset1 = OraDatabase.CreateDynaset(xsql, 0&)
txt_code.Text = oradynaset1.Fields("category_code").Value

this is giving a error

object required ?
thanks
suresh
Re: what is wrong with this - urgent plzzzzzzzzzzzzzzzzzzzzzzzzzz [message #1961 is a reply to message #1950] Thu, 13 June 2002 04:43 Go to previous message
Gus
Messages: 18
Registered: December 2000
Junior Member
which line gives err ?
Previous Topic: difference between application trigger and database trigger
Next Topic: Need help converting column datatype and maintaining data
Goto Forum:
  


Current Time: Mon May 20 15:27:07 CDT 2024