The Forums on slxdeveloper.com are now retired. The forum archive will remain available for the time being. Thank you for your participation on slxdeveloper.com!
|
|
Retreiving Of Records from database
Posted: 16 Apr 07 9:37 AM
|
Dear all,
how to retrieve data from database and capture it in front end using VB script. This is the code i have written but i am getting error pls help me (I am trying to capture accountname from account table in to new text box)
1 sub Retrivedata(Sender)
2 Dim objRS
3 Dim objSLXDB
4 objSLXDB = new SLX_DB
5 Set objRS = objSLXDB.GetNewRecordset
6 objRS.Open "Select Account from sysdba.ACCOUNT where USERFIELD= 'XYZ' ",objSLXDB.Connection 'DNL
7 textbox.Text = objRS.Recordset(0).value
8 objRS.Close
9 End Sub
I am getting error in line number 5 "objSLXDB,object required"
pls help me
thanks in advance
with regards
vamsi
|
|
|
|
Re: Retreiving Of Records from database
Posted: 16 Apr 07 12:35 PM
|
fiogf49gjkf0d This one is very obvious. You are missing the Set statement on line 4. The error comes on line 5 as you are trying to use it.
Should be:
Set objSLXDB = new SLX_DB
|
|
|
|
Re: Retreiving Of Records from database
Posted: 21 Apr 07 6:20 AM
|
fiogf49gjkf0d You must include the SLX_Database_Support Script in your Form Script. Other than that i dont see any other issue. The fact that the class SLX_DB is defined in the above mentioned Global Script you would need to include it. |
|
|
|