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

Click here to load this message in the networking platform