Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Olaf Doschke
  Where is Olaf Doschke?
 Hamburg
 Germany
 Olaf Doschke
 To: Tyrone Matthews
  Where is Tyrone Matthews?
 Bristol
 United Kingdom
 Tyrone Matthews
 Tags
Subject: RE: ordering grid by field
Thread ID: 189121 Message ID: 189349 # Views: 1 # Ratings: 0
Version: Visual FoxPro 7 Category: Grids
Date: Thursday, August 14, 2008 2:22:10 PM         
   


> In my form i have a grid that i needed ordering so heres the code but it does not seem to work anyone know what i am doing wrong, or if i need to do it another way.
>
> 'SELECT ProSaveRP
> 'SET ORDER TO Points desc
>
> cheers
>
> Ty

The question is, what does not work?
Don't you get the desired order?

You may have wrong expectations of what SET ORDER does.

SET ORDER TO does not compare to SQLs ORDER BY clause like SET FILTER TO does compare to SQLs WHERE clause.
SET ORDER TO does work on index tag names, not on field names.

So you should look at what actually is the expression of the Points index tag and if that is what you want to order by.

Bye, Olaf.

ENTIRE THREAD

ordering grid by field Posted by Tyrone Matthews @ 8/13/2008 1:08:53 PM
RE: ordering grid by field Posted by Jun Tangunan @ 8/13/2008 1:20:21 PM
RE: ordering grid by field Posted by tushar @ 8/13/2008 1:52:20 PM
RE: ordering grid by field Posted by Stefan Wuebbe @ 8/13/2008 1:59:13 PM
RE: ordering grid by field Posted by Jun Tangunan @ 8/13/2008 2:14:59 PM
RE: ordering grid by field Posted by Tom Saddul @ 8/13/2008 1:21:53 PM
RE: ordering grid by field Posted by Stefan Wuebbe @ 8/13/2008 2:10:07 PM
RE: ordering grid by field Posted by Tom Saddul @ 8/13/2008 2:21:42 PM
RE: ordering grid by field Posted by Mike Yearwood @ 8/13/2008 3:55:54 PM
RE: ordering grid by field Posted by Tom Saddul @ 8/14/2008 1:55:13 PM
RE: ordering grid by field Posted by Mike Yearwood @ 8/14/2008 7:30:26 PM
RE: ordering grid by field Posted by Tom Saddul @ 9/2/2008 11:41:02 AM
RE: ordering grid by field Posted by Mike Yearwood @ 9/2/2008 4:12:52 PM
RE: ordering grid by field Posted by Tom Saddul @ 9/3/2008 12:46:13 PM
RE: ordering grid by field Posted by Mike Yearwood @ 9/3/2008 3:45:18 PM
RE: ordering grid by field Posted by Marcia Akins @ 8/13/2008 6:22:41 PM
RE: ordering grid by field Posted by Tyrone Matthews @ 9/1/2008 12:02:55 PM
RE: ordering grid by field Posted by Marcia Akins @ 9/2/2008 12:54:59 PM
RE: ordering grid by field Posted by Olaf Doschke @ 8/14/2008 2:22:10 PM
RE: ordering grid by field Posted by Tyrone Matthews @ 8/15/2008 3:48:26 PM
RE: ordering grid by field Posted by Jun Tangunan @ 8/16/2008 12:37:31 AM
RE: ordering grid by field Posted by Olaf Doschke @ 8/16/2008 5:04:52 PM
RE: ordering grid by field Posted by Tyrone Matthews @ 8/20/2008 11:13:27 AM
RE: ordering grid by field Posted by Olaf Doschke @ 8/20/2008 1:02:53 PM
RE: ordering grid by field Posted by Anders Altberg @ 8/16/2008 9:46:42 PM