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
- :
- Re: TEXT REPLACEMENT TAB -sql script
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
Mar 27, 2011
04:13 AM
TEXT REPLACEMENT TAB -sql script
I have Sql script that makes an update in a table
Hard code it is working fine .
But i want that in the dialog the values that the user enters
in the text boxes - will be the values to be updated in the table.
My SQL script is :
update [ServerName].[dbo].[TableParameters]
SET [Param_Value] = '[Port_Value]'
where [Param_Id] = 'xx'
IN THE TEXT REPLACEMENT TAB - i put in
FIND WHAT :[Port_Value]
REPLACE WITH: NAME_OF_PUBLIC_PROPERTY_OF_TEXT_BOX (all in upper case)
After the installation completes -The script update the table
with the [Port_Value]
AND DOES NOT REPLACE IT with the actual property value that the user entered. WHY ??? please help!
ALSO-HOW TO GET PROPERTIES VALUES??
I changed the ENABLE_USER_CONTROL VALUE TO 1 in the registry thinking it will help but not..
The NAME_OF_PUBLIC_PROPERTY_OF_TEXT_BOX is in the SecureCustomPropertzies property.
I am running as admin .
Thanks
MiCHAL
Hard code it is working fine .
But i want that in the dialog the values that the user enters
in the text boxes - will be the values to be updated in the table.
My SQL script is :
update [ServerName].[dbo].[TableParameters]
SET [Param_Value] = '[Port_Value]'
where [Param_Id] = 'xx'
IN THE TEXT REPLACEMENT TAB - i put in
FIND WHAT :[Port_Value]
REPLACE WITH: NAME_OF_PUBLIC_PROPERTY_OF_TEXT_BOX (all in upper case)
After the installation completes -The script update the table
with the [Port_Value]
AND DOES NOT REPLACE IT with the actual property value that the user entered. WHY ??? please help!
ALSO-HOW TO GET PROPERTIES VALUES??
I changed the ENABLE_USER_CONTROL VALUE TO 1 in the registry thinking it will help but not..
The NAME_OF_PUBLIC_PROPERTY_OF_TEXT_BOX is in the SecureCustomPropertzies property.
I am running as admin .
Thanks
MiCHAL
(1) Reply
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
Mar 29, 2011
03:18 PM
The Find What and Replace With settings of the SQL Text Replacement functionality are replaced by the value of the property if a substring of the form [propertyname] is encountered. So you need to specify the following values in your case:
FIND WHAT :[\[]Port_Value[\]]
REPLACE WITH: [NAME_OF_PUBLIC_PROPERTY_OF_TEXT_BOX]
FIND WHAT :[\[]Port_Value[\]]
REPLACE WITH: [NAME_OF_PUBLIC_PROPERTY_OF_TEXT_BOX]
![](/skins/images/A5EADE085F77DE82FB3B14D6B307AE6A/responsive_peak/images/icon_anonymous_message.png)