Very good!
Tnx
>>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