>I am working in VFP5 and have found that I can load a grid much quicker with a view. My problem is that the table is poorly designed and has too many fields. In VFP6 there is a command SYS(3055) which is supposed to allow for more complex SQL statements. I have found nothing referring to the issue in VFP5.
>
>What have the pros done?
There's no SYS() workaround within VFP5 AFAIK - SYS(3055) was added to allow you to grow the WHERE/FOR clause complexity; it won't help with the selection of fields necessarily.
>Is it possible to create views from views? Silly, I know...
>
Yep, but be very careful in doing this, since changes to a table will affect any views that reference it, and views of views that reference the table, etc. You can also get yourself into problems with nested view parameters this way if you aren't careful. i would strongly advise giving up on the native View Designer and using Erik Moore's eView, which is considerably more capable than the native view designer, especially with complex views.
>Does anyone have any other ideas?