I'm not sure I see what the problem is...

I wouldn't expect CUR1 to be 'available' until the result set is to be written. Don't you really want aTable.cField in the field list?



>Hi Al,
>
>today I run into a new problem with SELECT SQL. it happens with VFP 7.0 and VFP 8.0.
>
>Example
>

>SELECT;
> ISBLANK(Cur1.cField);
> FROM aTable AS Cur1
>

>this produces error 'Object Cur1 not found'
>
>If I do
>

>SELECT;
> ISBLANK(aTable.cField);
> FROM aTable
>

>all is fine.
>
>The problem occurs with ISBLANK(), EMPTY for example is fine.
>
>Is this a known problem?
>
>Agnes