🚀 go-pugleaf

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.

BTW, my data tables reside in MS SQL Server 6.5.


Thanks

Ken Mayer <kmayer@corp.borland.com> wrote in article
<3497111B.235C@corp.borland.com>...
> Garth Wells wrote:
> > 
> > The documentation says you can specify the Order Tag on a SQL Table,
but I
> > get the TAG NOT FOUND error every time I try.  I do not think you
should be
> > able to do this and that the documentation is wrong.  Can you confirm
or
> > deny me assertion?
> 
> Don't use the word TAG. Try:
> 
> select * from mytable order tagname
> 
> where "mytable" is the name of the table, and "tagname" is the name of
> the index tag.
> 
> In addition, if you are using the database classes, you don't have to do
> this. You can, instead, select the indexName property for the rowset ...
> 
> Ken
>