AnsweredAssumed Answered

SQL Select Kills FM when I have another window open

Question asked by MichaelWiseman on Dec 9, 2015
Latest reply on Dec 9, 2015 by Mike Duncan

This problem seems to occur inconsistently.

 

 

I have an import layout for temporary data.

 

 

I have a replace statement that contains an SQL to select a value for each record in my temporary table. When the temporary table is the only thing open, then it works fine but when I have another window open with the same database in it, the statement freezes.

 

I get the "records left to replace" box and it often makes no progress. When I run the SQL without the replace, FM freezes.

The first time I tested it while writing this question, it failed, but the second time, it worked.

 

The fields I am working with are not calculations.

 

What can I do to ensure that this never happens?

 

 

Other things I have considered

Automatically closing all windows before running this part of the script.

A tangled mess of new windows, finds, and export/import from text files.

Outcomes