>Marc,
>
>I wonder if the SQL engine is getting an untrapped divide by zero? What if you used a UDF instead of the iif()?
Or a division by .null. or something. No record has V_Weight= 0, I even tried without the iif() and it did not work. The UDF will have to wait until tomorrow.
BTW I tried with isNull() but it did not give any result either.
Thanks.
Marc
>
>>Thanks David. I did do that, but to no avail. The strange thing is not so much that the sql give an error, but the VFP goes south. Must have done something really naughty :)
If things have the tendency to go your way, do not worry. It won't last. Jules Renard.