>Hi!
>
>How can I use the value of date field inside of a string whose content is a selec statement? Something like this.
>
>cdate=dtoc(table2.date)
>cSelect="selec * from table where table.date<="+cdate
>&cSelect
>
>TIA
Hi Roman,
Try
cSelect="Select * from table where table.date<=table2.date"
EXECSCRIPT(cSelect)
_______________________________________________________________
Testing displays the presence, not the absence of bugs.
If a software application has to be designed, it has to be designed correctly!
_______________________________________________________________
Vladimir Zografski
Systems Analyst