Dupe Query Overwrite 
Author Message
 Dupe Query Overwrite
FYI this is different from the "Dupe Query" thread.

I solved the problem of previous query windows hosing the current query.
Formerly, my query statements would be added to the previous query window
- same query.  Now just after the query, I loop through each open window,
and test if it is a "Query" window.  If so, I close it.  So the next query
starts with a clean slate - no other query windows are on present.



Fri, 05 Jul 1996 05:41:37 GMT
 Dupe Query Overwrite

Quote:

> FYI this is different from the "Dupe Query" thread.

> I solved the problem of previous query windows hosing the current query.
> Formerly, my query statements would be added to the previous query window
> - same query.  Now just after the query, I loop through each open window,
> and test if it is a "Query" window.  If so, I close it.  So the next query
> starts with a clean slate - no other query windows are on present.

I was informed of a way to make this go as quickly as possible.

Do an 'Altspace|Desktop|SurfaceQuery', and then close query windows in a
'while' loop whose condition checks to see if the current window is a
query window.

Thanks AlexV!



Tue, 09 Jul 1996 07:32:06 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. SQL Query to insert w/out dupes

2. import file, query dupes, display results

3. Windows 2000 and SQL Server 7.0 Text overwrite in Query Analyzer

4. SQL Insert Query To Overwrite Duplicates

5. Overwrite & Delete Queries

6. Dupe values vs. nulls in join results

7. need SP to insert new key to one table and dupes to another

8. Removing Dupes

9. Dupes

10. dupe checking

11. Faster insert with ignore dupe key

12. Remove all dupes but ...


 
Powered by phpBB® Forum Software