🚀 go-pugleaf

Bowen Moursund wrote in message <6cadqn$o452@forums.borland.com>...
>>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
>

Tks for Help
Raul