🚀 go-pugleaf

Garth

I think you should re-visit the VDB 7 doc. It says USE...ORDER TAG, not
ORDER BY TAG. The same as VDB 5.5. Try just ORDER.
-- 
Joe  < jyuzamas@wrdiss1.robins.af.mil or jyuzamas@sprynet.com >

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
> > 
>