Too late. I guess I updated my reply a second ago after I checked Ed Rauh's FAQ. I remember we communicated regarding it...
Using ISNULL in SQL Server can get you confused about its syntax in VFP :)
>>It's a wrong approach. See my original reply for correct answer.
>>
>>You can use TYPE("myObject.myObject") = 'O' and insull(myObjec.myObject,'')<>'' && I forgot how do you check for NULL in VFP.
>>
>>If you don't have your property defined VARTYPE will give you an error. That's why PEMSTATUS() function was introduced.
>>
>>>Thanks, that works great. Don't know why my brain is having a hard time with vartype these days. :)
>>>>
>>>>IF VARTYPE("myobject.myproperty") = "O"
>>>>
>>>>
>>>>>
>>>>>I need to check a object that started out as "empty" object for a specific property. Is there a way to do this without getting an error?
>>>>>
>>>>>TIA,
>>>>>Beth
>
>
>Just ISNULL() nothing else :-)
>
>IF ISNULL(some value)
> ...
>ENDIF
>
If it's not broken, fix it until it is.
My Blog