by Anyone can help I just thought Michael had the best chance by known people
in high places :)
I have a rather large database that i have to display in a grid the user
had to be able to sort it about 5 different ways..
When using a Dynaset:
Everytime i changed the order by saying select * from mytable order by
cur_order then the refresh the data control and the grid it would
pause for a long time (13 seconds or so) then display correctly.
I switched to Table type and just change the index value of
the recordset and it is instantanious...
Now i am trying to set a filter on the table and I find out you cant do that
if the recordset is of type table?
Is there any way to filter records from table type recordset??
Thanks in advance.