Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Looking for PROPERTY instead of Field ???
Message
De
22/03/1999 18:54:36
 
 
À
22/03/1999 18:43:08
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00200717
Message ID:
00200748
Vues:
8
>>>>>>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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform