I.T. Discussion Community!
-Collapse +Expand
Paradox
Search Paradox Group:

Advanced
-Collapse +Expand Paradox To/From
To/FromCODEGuides
-Collapse +Expand Paradox Store
PRESTWOODSTORE

Prestwood eMagazine

May Edition
Subscribe now! It's Free!
Enter your email:

   ► MB LobbyCorel Paradox / ObjectPAL Coding BoardParadox Forms Topic   Print This     

SORTING QUERY OUTPUT

SORTING QUERY OUTPUT in Paradox Forms topic (part of our Corel Paradox / ObjectPAL Coding group).

Quick Search: SORTING   SORTING QUERY   SORTING QUERY OUTPUT  
Most Recent Post
Greg MacKenzie
SEATTLE WA USA

I have created a query form. I want to sort the output by a specific  field, in this case the status date. I believe i would use AnswerSortOrder in my coding to acomplish this but I am not certain. I looked in my Object Pal reference guide for a sample of this coding and tried to adapt it but am unable to get the query to sort: The coding is as follows:

method pushButton(var eventInfo Event)
 var
  sUNIT   String
  qryFLEET  Query
  tvAnswer  TableView
  FLEETFIELDS Array[STATUS DATE] STRING

 endVar
    qryFLEET.getAnswerSortOrder(FLEETFIELDS)

 sUNIT = Enter_UNIT.value

 qryFLEET = Query
 
   ANSWER: :PRIV:answer.db

   FLEET.UTILIZATION.db | MODEL  | UNIT       | SERIAL NUMBER  | STATUS |LOCATION/CUSTOMER | STATUS DATE |   LTD HOURS |
          | Check  | ..~sUNIT.. | Check     | CHECK  | CHECK     |  CHECK   |   CHECK  |


 
          
 EndQuery
 setAnswerSortOrder(FLEETFIELDS)
 executeQBE(qryFLEET)
 tvAnswer.open(":priv:answer.db")
 
endmethod

The error message is: Constant expected

any help would be appreciated.

 Posted 7 years ago (Thread Starter)
Comment Quote
About Greg MacKenzie -Collapse +Expand
Visit Profile
Approved member.
Member subscribes to this thread with a verified email.

Post ID #14860, No Replies Be the first!
Thread Started 6/1/2012 3:58:48 PM
View Counter=2047
Location=SEATTLE WA USA  
Joined=19 years ago   MB Posts=17  

Revive Thread!

Add a comment to revive this old thread and make this archived thread more useful.

Write a Comment...
Full Editor
...
Sign in...

If you are a member, Sign In. Or, you can Create a Free account now.


Anonymous Post (text-only, no HTML):

Enter your name and security key.

Your Name:
Security key = P1246A1
Enter key:
Icon: A Post    Thread    Idea    Important!    Cool    Sad    No    Yes    Includes a Link...   
Thread #14860 Counter
2047
Since 6/1/2012
Follow PrestwoodBoards on: 


©1995-2019 PrestwoodBoards  [Security & Privacy]
Professional IT Services: Coding | Websites | Computer Tech