>>>>>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?
Edward Pikman
Independent Consultant