Refine a search - Valentina

 

Compatibilities: Required Xtras: Valentina

This item has not yet been rated

How can I refine a recordset (cursor) with lingo?

You can refine a cursor by evaluating the records with lingo and using the command DropCursor to take out invalid records. This will leave you with a recordset that only contains the records you want. A short example is shown below. vRS.firstRecord() repeat with x = 1 to vRS.getRecordCount() if vRS.getField(vField) = vCondition then vRS.DropRecord() else vRS.NextRecord() end if end repeat