Hi. VFP7 user. I am trying to use a sql statement for several similar situations. My problem is the syntax for lcFilter in the sql statement.

My code reads as follows:

USE myDBF
myRecno = recno()
lcFilter = "recno('myDBF') = myRecno"  && myRecno is only variable
SELE * FROM myDBF WHERE lcFilter

Thanks, Randy

ps: this is an over-simplified example to make my point