Information générale
Catégorie:
Codage, syntaxe et commandes
James
Since your second query destination is nothing that's why you get that browse window, try to give a destination like into Cursor or into array
HTH
>Hey everyone,
>I am trying to execute the following code but having some problems when it is executed:
>
>SELECT a.prempl;
>From a_prehtx a ;
>where a.txqtr = '3' ;
> and (a.qtax = 0 AND a.qbase = 0 AND a.qwage = 0) into cursor curEmpCheck
>
>SCAN
> SELECT b.prempl ;
> From a_prehtx b ;
> Where b.prempl = curEmpCheck.prempl ;
> and b.txqtr = '2'
>
>
>What is happening is the Scan is bringing up a single column table for every record in the first table. To be a little more specific, when the code is run, it gets to through the first query fine. When it hits the scan, foxpro will bring up the single column prempl table (as if I had tried to browse that table), then I have to close the open table by clicking on the X. It repeats this procedure for every record in the first table. Is there a command to close this table for me or from keeping this table from popping up? Any help would be appreciated. Thanks.
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