ORDER BY

[TomBarrand]

I am currently using the following SQL statement to populate a drop doewn box. I need 'GBP', 'USD' to be at the top of the list then the remainding options to appear in ascending order. How do I do this

Select Curr_ISO_Code
FROM Currency
WHERE Curr_Status = 'A'

Thanks

 

[repete]

I do this type of thing in FoxPro, and the syntax is similar to that shown below.

Basically, gather your data as per the sql statement that you showed, but exclude the 2 items you want at the top of the list.

Then create a second cursor (or array), and add the 2 items you want specifically at the top, then add the other itesm into that cursor (or array).

I then copy the results back to the originally named cursor.

Hope this helps.


Select Curr_ISO_Code
FROM Currency
WHERE Curr_Status = 'A' and not inlist(curr_iso_code,'GBP','USD')
order by curr_iso_code
into array a_temp

create cursor curtemp (curr_iso_code c(10))
append blank
replace curr_iso_code 'GBP
append blank
replace curr_iso_code 'USD'
append from array a_temp
dimension a_temp(reccount(),1)
copy to array a_temp


Pete Bloomfield
Down Under