Hi Fabio,

we have run into numerous issues where the SQL we generate works in MSSql, but does not work in VFP. Getting the two to work as much as possible alike is of tremendous importance in getting VFP acceptance in the marketplace, as it makes upsizing to MSSql a relatively easy task.

Hank

>To VFPT,
>
>i have noticed that much prominence comes given to the enhance supporting of the subquery.
>
>I understand that the demand for the mass in this,
>but rewrite of VFP Query Engine is much onerous,
>and therefore will reduce the resources available
>in order to fixing the much bugs on the events of the objects.
>
>Complex queries without data statistics and relational invariants optimization, they involve:
>
>- or a remarkable slowing down of the SELECT, and then the developer split it in two step query or more;
>- or an increase of the number of indices with a remarkable slowing down of the UPDATE/INSERT.
>
>I hope to mistake to me.
>
>Fabio