Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Select statements and date fields
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 6
OS:
Windows XP SP2
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01229678
Message ID:
01229682
Views:
8
>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
Previous
Reply
Map
View

Click here to load this message in the networking platform