Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
From $ to object
Message
 
 
To
19/07/2002 16:18:50
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00680631
Message ID:
00680657
Views:
20
This message has been marked as a message which has helped to the initial question of the thread.
>Sometimes, I have some code such as this:
>
>
>lcWhere=This.cWhere
>ldDate=This.dDate
>SELECT AddDate,COUNT(*) AS Nombre FROM Thread;
> WHERE &gcForumList &lcWhere AND AddDate>=ldDate &lcFilter;
> ORDER BY 1 GROUP BY 1 INTO CURSOR Temp2
>
>
>For the case of This.cWhere and This.dDate, is there a way to include them as is in the SELECT command?

Not for this.cWhere You can not have macro with . inside In case of this.dDate you don't have to use additional variable, you can put AddDate>=this.date in the SQL
If it's not broken, fix it until it is.


My Blog
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform