L
Les Juby
I need to extract records from a database subject to conditions and
only thereafter give the users the choice of which fields to sort the
results on.
In this situation I can't write back to a temporary file and then
select all from that file on the different sort orderings.
I figured that the only way out would be to write to an array from the
first recordset set creation. Then write the report to the screen
from the array and users can choose different sort orders and it would
extract again and report from that same array.
( 1 )
Only problem is that I havn't the faintest idea of how to create and
write to the array. Or how to query it. Is it similar to the first
database report.?
Would anyone perhaps know of a simple tutorial resource that
demonstrates this method.?
( 2 )
Or do I need to think right outside the box and take the first report
in a more efficient way. Problem is that I need to take only one
record whenever the value changes in a particular field. Could my SQL
statement use ordering on one field to take the recordset but order on
another field for the output. I wouldn't have tought so.
thanks
.les.
only thereafter give the users the choice of which fields to sort the
results on.
In this situation I can't write back to a temporary file and then
select all from that file on the different sort orderings.
I figured that the only way out would be to write to an array from the
first recordset set creation. Then write the report to the screen
from the array and users can choose different sort orders and it would
extract again and report from that same array.
( 1 )
Only problem is that I havn't the faintest idea of how to create and
write to the array. Or how to query it. Is it similar to the first
database report.?
Would anyone perhaps know of a simple tutorial resource that
demonstrates this method.?
( 2 )
Or do I need to think right outside the box and take the first report
in a more efficient way. Problem is that I need to take only one
record whenever the value changes in a particular field. Could my SQL
statement use ordering on one field to take the recordset but order on
another field for the output. I wouldn't have tought so.
thanks
.les.