select to array won't keep the order

[kenndot]

I'm setting the order of a table

set order to code

then doublechecking to make sure it really is ordered the way I want (and it is)

then

select * from table into array myarray

and the order isn't kept... why?

If this is in the FAQ's I apologize but I didn't see it...

 

[AllanB1]

Kenndot:

select * from table into array myarray ORDER BY CODE

Al

 

[sarklow]

I think because SELECT does not recognise VFP tags.

Try SELECT INTO ORDER BY ....

If you want to generalise then

lcTag = TAG (table)

SELECT .. INTO ... ORDER BY &lcTag

 

[kenndot]

didn't realize i could use the order by clause in a select to array, thank you!

 

[Mike Gagnon]

kenndot

You could also sort your array using ASORT().

Mike Gagnon

If you want to get the best response to a question, please check out FAQ184-2483 first.