>>>Ok... I'm stumped ( and more than a little frustrated !! )
>>>
>>>This code:
>>>
>>>
>>> SELECT * FROM SRCFILES WHERE JOBNO = cJobNo INTO CURSOR MySrcFiles
>>> nTotSrcFiles = _TALLY
>>>
>>> SELECT SRCFILES
>>> SCAN
>>> .
>>> .
>>> .
>>> ENDSCAN
>>>
>>>
>>>dies at the
SCAN command with error #1734: Property CJOBNO is not found...
>>>
>>>Two questions:
>>>
>>>Why does it think that cJobNo is a property since this
variable is used in the previous command successfully?
>>>Why is it looking for cJobNo at all in the beginning of a SCAN loop?
>>>
>>>The form in question uses the default data environment and the file SRCFILES has no filter set or anything. The form has no property named cJobNo either...
>>
>>Don't know exactly what's going on, but you might try adding NOFILTER after the cursor in your SQL. Sometimes strange things occur on filtered tables...
>
>Thanks Bruce,
>
>I gave it a shot... same behaviour...
>
>There is a form I open ( and then close ) prior to opening the form with the error. This first form has a property called cJobNo. I changed the name of that property to xcJobNo and now the error says "Property xcJobNo is not found" !!!
>
>The first form is modal and it's closed prior to opening the 'error' form. Why would VFP hang on to that property and try to use it here?
>
>TIA
Where do you create/open "SRCFILES"?
Edward Pikman
Independent Consultant