Cursor contains wrong data !!!

[mensud]

Hi,

I have next query:
select account,slip,name,qty,qty2,amount,entry;
from qapordtx where qapordtx.slip=thisform.lslip;
into cursor tmpcur

The field slip in table qapordtx is numeric (10).
Property lslip is also numeric.
After my query is executed in program, instead of only
one record I get all records from table qapordtx.
When I execute this query in command window (lslip is real number) my cursor contains only one record and it is correct.
I tried all solution for two days, and now I don't have any more ideas what is wrong.

By the way, when I trace this code in debugger, after this query is executed, I can see a small window in upper left corner with message: "Filter is cleared". What does that mean.

Thanks for your willing to help me.

Mensud

 

[jimstarr]

What is "thisform.lslip"? Maybe you mean thisform.lslip.value.

Jim

 

[rgbean]

Mensud,
Where are you doing this Query? e.g. Form Init(), In a form Command button Click method?

Is thisform.lslip a user defined form property?

Rick

 

[mensud]

Well, this query is performed in my own method.
Thisform.lslip is form property. Also, method that contains above query is on the same form.
I pass to this form one parameter, and thisform.lslip property contains value of this parameter.

 

[jimstarr]

The first thing I would do is display the value of thisform.lslip right before the query to verify that it's correct.

Jim