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.
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]
