>lc_sealnumber = ALLTRIM(thisform.lc_sealnumber) > >lc_sqlstring = "SELECT * FROM view_depositactivity WHERE postingdate BETWEEN ?ld_startdate AND ?ld_enddate " >lc_sqlstring = lc_sqlstring + " AND sealnumber LIKE '%' + ?lc_sealnumber +'%'" >= sqlprepare(gnconnhandle, lc_sqlstring, "curactivity") >IF oApp.gf_sqlexec(gnconnhandle) > > SELECT curactivity > GO TOP > BROWSE > >ENDIF > > >To be more precise and to avoid errors I recommend to make sure that the variable is declared private and not local:
PRIVATE pc_sealnumber pc_sealnumber = ALLTRIM(thisform.lc_sealnumber) lc_sqlstring = "SELECT * FROM view_depositactivity WHERE postingdate BETWEEN ?ld_startdate AND ?ld_enddate " lc_sqlstring = lc_sqlstring + " AND sealnumber LIKE '%' + ?pc_sealnumber +'%'"