How to retreive rows from db?

[Bahman Parizadeh]

Hi,

I'm having trouble understanding how i can retrieve a set of rows from one table in the db using the framework?  i have a drop down in an asp application that i want to populate with all the names in a user table. How would i go about doing this.  Any syntax would help

thanks,

Bo

[Richard Banks]

Hi Parizad,
It's a fairly simple process.

You need to create a retrieve criteria, execute it and then access the data contained in the resulting cursor.

Here's an example...

    Dim rc As CRetrieveCriteria
    Dim emp As New CEmployee
    Dim cursor As CCursor

    emp = New CEmployee
    rc = New CRetrieveCriteria
    rc.ReturnFullObjects = True
    cursor = rc.perform(emp)
    If cursor.hasElements Then
      cursor.loadObject(emp)
      Debug.WriteLine(emp.Name)
    End If

You can access the recordset directly in the cursor objects resultset.