Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
From $ to object
Message
 
 
À
19/07/2002 16:18:50
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00680631
Message ID:
00680657
Vues:
19
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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform