General information
Category:
Coding, syntax & commands
Environment versions
Network:
Windows 2008 Server
>I have a problem with a grid on a form. I set a filter on a file to exclude "closed" reservations from the
>display. I then allow entry of a unit number, find the first record for the unit number and refresh the display
>of the grid.
>
>When it initially pulls up the grid and enter a unit. It comes up quickly. But, every time I call the grid form up
>after this, it displays the info, you enter the unit, and it takes a very long time to go to that record and redisplay.
>
>I can exit the program, re=enter and the first time is very fast. Subsequent times are very slow. I am doing this on
>a 3 computer pier to pier network. Its always fast on the one acting as the "server".
>
>I removed the filter and it ran fast in all instances. Can setting a filter on a file (15000 records and I only 300 meet the
>filter requirements) make it take, literally, minutes to pull up the data?
>
>Any help would be greatly appreciated.
>
>Brad
you have 2 ways:
1) add an index and use SET KEY
2) build an cursor with the filtered rows only
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only