>Hi. I have a complex parameterized view based on a Select ... Union Select ...
>
>When I try to modify it I get an error ssying the SQL is too complex. I have a Pentium II 450 with 128 MB RAM and only Foxpro running. (VFP 6.0 with SPC 3). What am I supposed to do?????
>
You might want to try Erik Moore's eView, which can be downloaded from the Files Section here on UT. It doesn't integrate directly with SDT AFAIK.
SDT isn't the reason that the modification generates an error in VFP; it's a limitation of the built-in View Designer, which is invoked from SDT. The amount of memory and speed of the processor have no effect here.
If the problem is the complexity of the WHERE clause, you might benefit from setting the value of SYS(3055) higher than the default set by VFP; see the VFP docs for details on SYS(3055), which controls the degree of complexity (I think it indirectly reflexts the size of the generated p-code for the clause, but I'm not certain of this relationship.) If VFP is generating an error 1308 or 1812, then SYS(3055) may be able to help.
>TIA
>
>Sandi.