🚀 go-pugleaf

The solution is:

Use :BDEAliasName:dbo.TableName Order Tag NDXName

The NDX name is case-sensitive.

***

Garth Wells <gwells@physix.com> wrote in article
<01bd0a81$ba0ee840$74ffc2d0@wells>...
> 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
> > 
>