cquerystring='' >cquerystring='select * from mycursor where .t.'&&get all lines >cdated=transform(thisform.txtdate())&&it's OK >cdone='ttod(mycursor.createtime)'&&&&&&&&&&Here the problem >cdt='>' >cquerystring=cquerystring+' and '+cdone+cdt+cdated >messagebox(cquerystring)&&show the query syntax for debug >&cquerystringyou can use parameters...
cquerystring='select * from mycursor where .t.'&&get all lines dated=thisform.txtdate() && This is date variable cdone='mycursor.createtime'&&&&&&&&&&Here the problem cdt='>' cquerystring=cquerystring+' and '+cdone+cdt+"m.dated" messagebox(cquerystring)&&show the query syntax for debug &cquerystringMartinaJ