sort recordset after query.open?

[Tracey]

Hi

using interbase, on a cgi/isapi application, is there anyway to sort a recordset after running the IBQuery Select statement? (D6)

i have a query which unions two queries, and instead of getting:
answers from 1st part sorted by x
then
answers from 2nd query sorted by x

i would like:
answer1 of query1 x=2
answer1 of query2 x=2
then
answer2 of query1 x=3
answer2 of query2 x=3

 

[Tracey]

and at this point i will answer my own question (seeing as no-one else will)

I used a ClientDataSet

elementary once you figure it out...