Steve,
No idea on the UPDATE, but the / goes in front of the PRE not behind it. It should be </pre> to terminate the code fragment.
>Can anyone tell me if it is possible to do a nested UPDATE (SQL) in Fox 5? The syntax that I am using is as follows:
>
>UPDATE vueOrdLines ;
>SET iQty = ;
> (SELECT MAX(iQty) from vueOrdLines)
>WHERE ...
>
>The error that I get is "function name is missing )". The help file just says column_name = expression1, it doesn't say what the expression can be, and the example is really simple. Is it possible to do this or am I just wasting my time?
>
>Thanks in advance for assistance.
