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