Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Writing a Report Exception (in case table empty)
Message
 
 
To
10/03/2010 14:47:00
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Miscellaneous
Thread ID:
01453531
Message ID:
01453800
Views:
41
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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform