Variables get corrupted with read from text file
Posted: Wed Oct 27, 2010 4:54 am
Hi
I have a quite large project with tens or hundreds of variables defined. When creating the database,
I use 'Read from text file' to read a SQL script into a variable and do some replacements there
before serving it to MS SQL plugin.
Now when one of the SQL script files has grown over 1.6Mb and I read the file (using #READALL) into
a variable, few of my previously defined variables get corrupted. Is there a memory leak or what
could be causing this behaviour ? Or isn't that command meant to be used with such a big files ...
I solved the problem temporarily by splitting the file into a smaller pieces, but this problem will
come back some day and it might not be noticed until some weird problems when our customer
is installing our product.
We are using version 9 R2 sp2 and the problems has occurred on various platforms.
Paavo Nieminen
I have a quite large project with tens or hundreds of variables defined. When creating the database,
I use 'Read from text file' to read a SQL script into a variable and do some replacements there
before serving it to MS SQL plugin.
Now when one of the SQL script files has grown over 1.6Mb and I read the file (using #READALL) into
a variable, few of my previously defined variables get corrupted. Is there a memory leak or what
could be causing this behaviour ? Or isn't that command meant to be used with such a big files ...
I solved the problem temporarily by splitting the file into a smaller pieces, but this problem will
come back some day and it might not be noticed until some weird problems when our customer
is installing our product.
We are using version 9 R2 sp2 and the problems has occurred on various platforms.
Paavo Nieminen