This website uses cookies. By clicking Accept, you consent to the use of cookies. Click Here to learn more about how we use cookies.
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
- Revenera Community
- :
- InstallShield
- :
- InstallShield Forum
- :
- SQL Text Replacement is limited to 100 characters?
Subscribe
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
Nov 13, 2007
06:37 AM
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.
Thanx for help!
Thanx for help!
(1) Reply
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
Nov 13, 2007
07:45 PM
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?
Thank you.
Thank you.
![](/skins/images/A5EADE085F77DE82FB3B14D6B307AE6A/responsive_peak/images/icon_anonymous_message.png)