Information générale
Catégorie:
Codage, syntaxe et commandes
This is absolutely not the case. I use WHERE clauses in subqueries all the time. I'm betting the use of number,date and type as field names and as the ORDER BY criterion is what's is causing the trouble. These are all reserved words in VFP.
>Okay, being stupid, appears that a where clause is invalid in a subquery.
>
>
>
>>In VFP 5.0 I seem to be having a problem with a subquery. I can run the subquery stand alone and it works fine. Please someone tell me what I'm not seeing.
>>
>>****
>>
>>SELECT uniqueid,number,date,type,sn,payee1,document from incoming ;
>> where BETWEEN(date,Thisform.sdate.value,thisform.edate.value) ;
>> and number NOT IN (Select number from receipts ;
>> where BETWEEN(letterdate,Thisform.sdate.value,thisform.edate.value) ;
>> and lettertype = [I]) ;
>> order by number ;
>> into cursor curLetter NOFILTER NOCONSOLE
>>
>>*****
>>
>>Ideas?
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement