1.

In UFT, how to get data from database?

Answer»

Follow the given below code to get data from database −

Set db = createobject (“ADODB.Connection”)db.Open “Provider = Microsoft.Jet.OLEDB.4.0;Data Source=G:\guru99\vb6\admission_project.mdb;Persist Security Info = False”Set rst = createobject (“ADODB.Recordset”)rst.Open “select*from Course”, db, 3id = rst. RecordCountFor i = 0 to id-1   Print rst.field (0) & rst.fields (1) & rst.fields (2) & rst.fields (3)   rst.MovenextNext


Discussion

No Comment Found