Hi Chaim,

Check message #1229686


>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