>>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).
If it's not broken, fix it until it is.
My Blog