🚀 go-pugleaf

>field NAME ( like in common Dbase  Locate for "Joe" $ NAME)?
>        Other way could be to pass the expression direcletly to
>rowset.applyLocate(<EXP>), but I cannot find the correct SQL expression and
>Vdb 7 doesn't allow the old Dbase Language.

The SQL technique would be to use LIKE, e.g.:

 rowset.applyLocate = "NAME like '%Joe%'"

Unfortunately, the VdB data access objects do not currently support LIKE
anywhere but the WHERE clause of a SELECT statement. I think you will have
to code a loop, e.g.:

 rowset.first()
 do while not "Joe" $ rowset.fields["NAME"].value and ;
               not rowset.endOfSet
    rowset.next()
 enddo
__
Bowen Moursund (TeamB)
bowen.NOSPAM@nerds.com
http://www.mindspring.com/~bowenm/datatech.htm