I removed the having summa != 0 clause but the problem persists.
>Hi Andrus,
>
>"having summa != 0" is an extraction filter try changing to <> 0 or remove it completely and see what happens.
>
>>Neil,
>>
>>SQL SELECT clause dont use filters.
>>It simply runs the error at run time.
>>
>>>Hi,
>>>VFP9 Beta has a problem with filters, they are being ignored, Garrett has reported this to MS.
>>>
>>>We have a similar problem with our app in DE of form using !alias.fieldname causes error, whereas =!alias.fieldname works.
>>>I am having trouble creating repo code to send to MS, rather than sending the whole app. You may have found it, log it as a bug, and see what they say.
Andrus