VDatabase_Table method to affect with SQL

[william humphrey]

Please help me figure out how to return a setRef using table methods.

I can do this:



 *put* VDatabase_Table( dbRef, "table_name") into tblRef


And the tblRef returned does everything fine, first record, next last even
go to specific record.


But in order to soret that result the following command is used:


VTable_Sort(tblRef, setRef, fldRef)


This hints at a "setRef" which I would really like. Some way to modify the
tblRef so that it isn't all the fields in the table but instead limited by a
SQL "WHERE"


I know how to do this using the Cursor method but I've already built a lot
of stuff with the table method assuming I would some day figure out how to
sort the tblRef and how to affect it with SQL but I still can't figure it
out.


Can someone please offer an example of simple RunRev valentina commands and
SQL that do that to the VDatabase_Table( dbRef, "table_name") ?