From VFP Help for SELECT.
INTO Destination
Specifies where to store the query results. If you include the INTO clause and the TO clause in the same query, the TO clause is ignored. If you don't include the INTO clause, query results are displayed in a Browse window. You can also use TO to direct query results to the printer or a file.
>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.
Dennis Lindeman