>>>>>>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"?
>>
>>In another - higher level form. All subsequent forms use the default data environment.
>>
>>
>>Menu option "Jobs" opens Jobs form (modal)
>> "Files" button on jobs form opens source file(s) form (modal)
>> "Run" button on jobs form runs the jobs using the "Source files"
>>
>>
>>If I define the files that make up a job, then close the Jobs form, I can go back in and run the job with no problem. If I try to run a job immediately after defining it's source files, I get the error.
>>
>>Thanks
>
>Hmm... Could it happen that you applied some filter to the 'srcfiles' in the modal form?
Yep, that was it!
The SET FILTER TO that I added after SELECT SRCFILES worked, but I guess the proper place for that is in the UnLoad ( or Destroy ) event of the offending form, right?
Thanks to all