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

January 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
Rank: Cadet 2nd Year

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=1963
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 = P1212A1
Enter key:
Icon: A Post    Thread    Idea    Important!    Cool    Sad    No    Yes    Includes a Link...   
Thread #14860 Counter
1963
Since 6/1/2012
-
   Contact Us!
 
PrestwoodBoards.com was developed and is maintainted by me. Do you have a question or suggestion? Do you see a problem? Contact me now. My goal is to build an ad-free and spam-free source of I.T. information with many contributers (ok to promote your website/company in your bio). Yes, my company Prestwood IT Solutions is mentioned in my bio which shows with every post, but you can contribute and promote your pet project too!

2,362 People Online Now!!  
Sign In to see who's online now!  Not a member? Join now. It's free!
Show more stats...


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