>Hi
>I create dynamic Sql select.
>One option of query is specific date> mycursor.createtime(datetime field).
>The date work fine in by transform but how can I do it on the cursor field?
>Eample:
>

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
>&cquerystring

you 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
&cquerystring

MartinaJ