>Can you attach a grid to an array? All the documentation I have indicates you attach it to tables. We have a screen with about 323 fields which needs to refresh ever 20 seconds for monitoring purposes. It was converted from 2.6 to VFP6. On some machines it runs fine, but on others it is so slow as to be unacceptable. I have been thinking a grid would display faster than having to refresh all those fields, but the original code ran from arrays. Any suggestions would be appreciated.
James already answered your direct question, but I would like to offer a couple of thoughts on using a view.
The speed of a view depends largely on the indexes in the source table, and the construction of the SQL code that drives the view. We're talking orders of magnitude of difference here.
Regards,
Jason
Jason Tryon
Senior Systems Analyst / Technical Lead
eBusiness / iPage