VDatabase_Table method to affect with SQL

[william humphrey]

As a note for anyone who reads this later. I discovered that it is very easy
to convert "table method" to "cursor method". Just a simple search and
replace on "Vtable" replacing it with "VCursor" almost does everything.

So I still want to understand how to at least "sort" records in the table
method but I realize it is probably impossible to use SQL with table method
(so I'm using Cursor method for that).

On 9/11/08, william humphrey <shoreagent at gmail.com> wrote:
>
> 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") ?
>



-- 
http://www.bluewatermaritime.com