Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Writing a Report Exception (in case table empty)
Message
 
 
À
10/03/2010 14:47:00
Information générale
Forum:
Visual FoxPro
Catégorie:
Gestionnaire de rapports & Rapports
Divers
Thread ID:
01453531
Message ID:
01453800
Vues:
42
Sorry, I didn't pay attention. The 'Return' is a bad name for the cursor. Try to use

crsResults instead for the cursor's name. Always try to avoid VFP words for your table names or field names or variables, etc.

>>>>You needed
>>>>
>>>>
>>>>select Books.*,Acc.prin,Acc.status;
>>>>     From;
>>>>         Acc;
>>>>        inner join mainbase!books ;
>>>>on acc.ID=books.Id;
>>>>where acc.status= m.status ;
>>>>into cursor return nofilter
>>>>
>>>m.status?
>>>what is M?
>>
>>m. is used to distinguish memory variables (m stands for memory) from the fields. It's not really needed, but in some cases when you have a field in a table named the same as a variable, you need to use m. to tell the program you meant memory variable and not a field (fields always have precedence).
>
>cursor return? that isnt a cursor name...is it?
If it's not broken, fix it until it is.


My Blog
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform