Prestwood IT: getAnswerFieldOrder

getAnswerFieldOrder

getAnswerFieldOrder

Post ID #16747, 2 replies 6/18/2017 4:31:55 PM

Jay.M

Sussex, -- UNK

Trying to reorder an answer query so I came across getAnswerFieldOrder & setAnswerFieldOrder.. my problem is.. when I run this code:

method pushButton(var eventInfo Event)

var
qVar Query
arFields Array[] String
endVar

   qVar.readFromFile( "myquery.qbe" )
   qVar.getAnswerFieldOrder( arFields )
   arFields.view()
      if arFields.size() > 0 then     ; swap the first and third fields
                                      ; in the answer table.
         arFields.exchange(1,3)
         qVar.setAnswerFieldOrder( arFields )
         qVar.executeQBE()
      endif

endMethod

the arFields array is always empty.. the documentation is a bit foggy....

getAnswerFieldOrder retrieves an array of the fields in the answer table for the current query, when a custom field order is specified.... Anyone know how to achieve that custom field order.. I have gone to the query itself and reordered the fields before running.. the query does not save the reorder.. who can fill in the blanks on this one.. ???..

FIGURED IT OUT.. sorry for the bother.. if I had looked just a bit closer I would not have had to bother anyone on this one.. good old query menu... lets you custom order the query before running it..

Posted 9 years ago (Thread Starter)

Comment

Quote

About Jay.M

Visit Profile

Approved member.

Member subscribes to this thread with a verified email.

Post ID #16747, 2 reply

Thread Started 6/18/2017 4:31:55 PM

View Counter=1683

Last Reply Posted 6/19/2017 9:01:53 AM)

Location=Sussex, -- UNK

Joined=16 years ago MB Posts=37 KB Comments=1

RE: getAnswerFieldOrder

6/19/2017 5:07:36 AM

Moderator

Steven.G

Myrtle Beach, SC USA

it was good to bother for that, cuz I've never used it.. I was gonna suggest changing the field order in the qbe file itself.. it's just a text file.. and see if it knew they'd been changed..

Steven Green
Senior Software Engineer
Paradox Support Specialist DOS/WIN

Prestwood IT Solutions
8421 Auburn Blvd, Suite 256, Citrus Heights, CA 95610
Office: 916-726-5675 | Fax: 916-726-5676 | http://www.prestwood.com

Posted 9 years ago

Comment

Quote

About Steven.G

Visit Profile

Approved member.

Member subscribes to this thread with a verified email.

Old Account!

If this is your account, sign in to activate web presence data (sign in quarterly to keep active). Alternatively, you can subscribe to our monthly eMag with a valid email address.

Web Presence Hidden.

Once above is taken care of, full Profile content will display including back links, about me, my message, custom Profile html, social networking links, message board signature, company profile, etc.

Post ID #16748 (Level 2) and Parent is 16747

Reply Posted 6/19/2017 5:07:36 AM

Location=Myrtle Beach, SC USA

Joined=10 years ago MB Posts=463