🚀 go-pugleaf

Garth Wells wrote:
> 
> I think you are thinking of the ORDER BY (which acts on a field, not an
> index) clause that is optional on the SQL Select Statement.  The
> documentation says you can use the USE..ORDER BY with SQL tables.  I can
> easily use SELECT tablename ORDER BY fieldname, but I am trying to find a
> work around for changing existing code.

Suggestion: Don't use pure SQL for everything. Instead, use a
combination of the SQL and the database classes. For example, you can
create a QUERY and use that. This has the rowset class (automatically)
attached to it, and you can use any index tag you want from there:

qMyQuery = new Query()
qMyQuery.sql = "select * from mytable"
qMyQuery.active = true
qMyQuery.rowset.indexName = "myindextag"

Hope that helps.

Ken