SQL Text Replacement is limited to 100 characters?
Hello, I'm using InstallShield 2008 and an Installscript project. I want to do a text replacement for an existing SQL script file at runtime. Therefore I use Server Configuration\SQL Scripts\Text Replacement. For exampel, the placeholder $$$CONNECTION$$$ shall be replaced by a SQL connection string. The replacement is working but only the first 100 characters of my connection string are used for doing the replacement. Is this an InstallShield bug?? Does anyone know a solution or a workarround? It could also be possible that an error occours during execution of the updated SQL skript, but I don't think though.
I had a quick test that replaced a string in a SQL script with another string exceeding 100 characters using the Text Replacement functionality in an IS 2008 InstallScript project. However, the string was correctly replaced as expected. Would it possible for you to email me a sample project that reproduces the behavior at hidenoriy@macrovision.com so that I can look into it?
