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