>>In a code I have used
>>
>>
>>sele acno,balance from deposit where date>=lndate and date<=lndate1 and balance<lnAmount into cursor ty
>>brow
>>close all
>>
>>
>>I want to select accoutNumber, Date and Balance from a table where Balance is less than lnBalance
>>
>>But failed to do so.
>>
>>Pl. help
>
>What exactly is not working? Try to add NOFILTER at the end of the statement.
With NOFILTER and without NOFILTER the result must equal.
_______________________________________________________________
Testing displays the presence, not the absence of bugs.
If a software application has to be designed, it has to be designed correctly!
_______________________________________________________________
Vladimir Zografski
Systems Analyst