General information
Category:
Coding, syntax & commands
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.
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only