<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<DOCUMENT Type="Advanced Installer" CreateVersion="11.8" version="14.4.2" Modules="enterprise" RootPath="." Language="en" Id="{CDF358CE-CC59-4504-B5E8-DCC1B90C2B19}">
  <COMPONENT cid="caphyon.advinst.msicomp.ProjectOptionsComponent">
    <ROW Name="HiddenItems" Value="SccmComponent;ActSyncAppComponent;AppXAppDetailsComponent;AppXCapabilitiesComponent;AppXDependenciesComponent;AppXProductDetailsComponent;AppXVisualAssetsComponent;AppXAppDeclarationsComponent;AppXUriRulesComponent"/>
  </COMPONENT>
  <COMPONENT cid="caphyon.advinst.msicomp.MsiPropsComponent">
    <ROW Property="AI_BITMAP_DISPLAY_MODE" Value="0"/>
    <ROW Property="AI_FINDEXE_TITLE" Value="Select the installation package for [|ProductName]" ValueLocId="AI.Property.FindExeTitle"/>
    <ROW Property="ALLUSERS" Value="1"/>
    <ROW Property="ARPCOMMENTS" Value="This installer database contains the logic and data required to install [|ProductName]." ValueLocId="*"/>
    <ROW Property="ARPNOREPAIR" MultiBuildValue="DefaultBuild:1"/>
    <ROW Property="DATABASE_COMBOBOX_RESULTS" Value="Select database" Type="4"/>
    <ROW Property="DATABASE_SIZE_QUERY" Value="Your Value"/>
    <ROW Property="Manufacturer" Value="Caphyon"/>
    <ROW Property="ProductCode" Value="1033:{72840113-318F-4F0D-A68C-15D15E73C842} " Type="16"/>
    <ROW Property="ProductLanguage" Value="1033"/>
    <ROW Property="ProductName" Value="Sample Project"/>
    <ROW Property="ProductVersion" Value="1.0.0" Type="32"/>
    <ROW Property="RESULT" Value="nmn" Type="4"/>
    <ROW Property="SQL_AUTHENTIFICATION_METHOD" Value="SQL Authentification" Type="4"/>
    <ROW Property="SQL_SERVER_NAME_FIELD" Value="servername\instance" Type="4"/>
    <ROW Property="SecureCustomProperties" Value="OLDPRODUCTS;AI_NEWERPRODUCTFOUND;AI_SETUPEXEPATH;SETUPEXEDIR"/>
    <ROW Property="TestDBConnectionFailed" Value="TestDBConnectionFailed" Type="2"/>
    <ROW Property="UpgradeCode" Value="{947E4E37-85E8-4861-AFB1-4295AC125344}"/>
    <ROW Property="WindowsType9X" MultiBuildValue="DefaultBuild:Windows 9x/ME" ValueLocId="-"/>
    <ROW Property="WindowsType9XDisplay" MultiBuildValue="DefaultBuild:Windows 9x/ME" ValueLocId="-"/>
    <ROW Property="WindowsTypeNT40" MultiBuildValue="DefaultBuild:Windows NT 4.0" ValueLocId="-"/>
    <ROW Property="WindowsTypeNT40Display" MultiBuildValue="DefaultBuild:Windows NT 4.0" ValueLocId="-"/>
    <ROW Property="WindowsTypeNT50" MultiBuildValue="DefaultBuild:Windows 2000" ValueLocId="-"/>
    <ROW Property="WindowsTypeNT50Display" MultiBuildValue="DefaultBuild:Windows 2000" ValueLocId="-"/>
    <ROW Property="WindowsTypeNT5X" MultiBuildValue="DefaultBuild:Windows XP/2003 RTM, Windows XP/2003 SP1, Windows XP SP2 x86" ValueLocId="-"/>
    <ROW Property="WindowsTypeNT5XDisplay" MultiBuildValue="DefaultBuild:Windows XP/2003 RTM, Windows XP/2003 SP1, Windows XP SP2 x86" ValueLocId="-"/>
    <ROW Property="YourProperty" Value="Your Value"/>
  </COMPONENT>
  <COMPONENT cid="caphyon.advinst.msicomp.MsiDirsComponent">
    <ROW Directory="APPDIR" Directory_Parent="TARGETDIR" DefaultDir="APPDIR:." IsPseudoRoot="1"/>
    <ROW Directory="TARGETDIR" DefaultDir="SourceDir"/>
  </COMPONENT>
  <COMPONENT cid="caphyon.advinst.msicomp.MsiCompsComponent">
    <ROW Component="AI_ExePath" ComponentId="{721027B7-8E99-478D-914F-EF8CE8BAA158}" Directory_="APPDIR" Attributes="4" KeyPath="AI_ExePath"/>
    <ROW Component="ProductInformation" ComponentId="{7172335C-1F18-4E4B-89A7-91367D7BE025}" Directory_="APPDIR" Attributes="4" KeyPath="Version"/>
  </COMPONENT>
  <COMPONENT cid="caphyon.advinst.msicomp.MsiFeatsComponent">
    <ROW Feature="MainFeature" Title="MainFeature" Description="Description" Display="1" Level="1" Directory_="APPDIR" Attributes="0" Components="AI_ExePath ProductInformation"/>
    <ATTRIBUTE name="CurrentFeature" value="MainFeature"/>
  </COMPONENT>
  <COMPONENT cid="caphyon.advinst.msicomp.BuildComponent">
    <ROW BuildKey="DefaultBuild" BuildName="DefaultBuild" BuildOrder="1" BuildType="1" Languages="en" InstallationType="4" CabsLocation="1" PackageType="1" FilesInsideExe="true" ExtractionFolder="[AppDataFolder][|Manufacturer]\[|ProductName] [|ProductVersion]\install" ExtUI="true" UseLargeSchema="true"/>
  </COMPONENT>
  <COMPONENT cid="caphyon.advinst.msicomp.DictionaryComponent">
    <ROW Path="&lt;AI_DICTS&gt;ui.ail"/>
    <ROW Path="&lt;AI_DICTS&gt;ui_en.ail"/>
  </COMPONENT>
  <COMPONENT cid="caphyon.advinst.msicomp.FragmentComponent">
    <ROW Fragment="CommonUI.aip" Path="&lt;AI_FRAGS&gt;CommonUI.aip"/>
    <ROW Fragment="FolderDlg.aip" Path="&lt;AI_THEMES&gt;classic\fragments\FolderDlg.aip"/>
    <ROW Fragment="MaintenanceTypeDlg.aip" Path="&lt;AI_THEMES&gt;classic\fragments\MaintenanceTypeDlg.aip"/>
    <ROW Fragment="MaintenanceWelcomeDlg.aip" Path="&lt;AI_THEMES&gt;classic\fragments\MaintenanceWelcomeDlg.aip"/>
    <ROW Fragment="SequenceDialogs.aip" Path="&lt;AI_THEMES&gt;classic\fragments\SequenceDialogs.aip"/>
    <ROW Fragment="Sequences.aip" Path="&lt;AI_FRAGS&gt;Sequences.aip"/>
    <ROW Fragment="StaticUIStrings.aip" Path="&lt;AI_FRAGS&gt;StaticUIStrings.aip"/>
    <ROW Fragment="UI.aip" Path="&lt;AI_THEMES&gt;classic\fragments\UI.aip"/>
    <ROW Fragment="Validation.aip" Path="&lt;AI_FRAGS&gt;Validation.aip"/>
    <ROW Fragment="VerifyRemoveDlg.aip" Path="&lt;AI_THEMES&gt;classic\fragments\VerifyRemoveDlg.aip"/>
    <ROW Fragment="VerifyRepairDlg.aip" Path="&lt;AI_THEMES&gt;classic\fragments\VerifyRepairDlg.aip"/>
    <ROW Fragment="WelcomeDlg.aip" Path="&lt;AI_THEMES&gt;classic\fragments\WelcomeDlg.aip"/>
  </COMPONENT>
  <COMPONENT cid="caphyon.advinst.msicomp.MsiActionTextComponent">
    <ROW Action="AI_DeleteLzma" Description="Deleting files extracted from archive" DescriptionLocId="ActionText.Description.AI_DeleteLzma" TemplateLocId="-"/>
    <ROW Action="AI_DeleteRLzma" Description="Deleting files extracted from archive" DescriptionLocId="ActionText.Description.AI_DeleteLzma" TemplateLocId="-"/>
    <ROW Action="AI_ExtractFiles" Description="Extracting files from archive" DescriptionLocId="ActionText.Description.AI_ExtractLzma" TemplateLocId="-"/>
    <ROW Action="AI_ExtractLzma" Description="Extracting files from archive" DescriptionLocId="ActionText.Description.AI_ExtractLzma" TemplateLocId="-"/>
    <ROW Action="AI_SqlConfig" Description="Executing install SQL scripts" DescriptionLocId="ActionText.Description.AI_SqlConfig" Template="Connection: [1]  Script: [2]" TemplateLocId="ActionText.Template.AI_SqlConfig"/>
    <ROW Action="AI_SqlInstall" Description="Generating actions to configure databases for install SQL script execution" DescriptionLocId="ActionText.Description.AI_SqlInstall"/>
    <ROW Action="AI_SqlMaint" Description="Executing maintenance SQL scripts" DescriptionLocId="ActionText.Description.AI_SqlMaint" Template="Connection: [1]  Script: [2]" TemplateLocId="ActionText.Template.AI_SqlMaint"/>
    <ROW Action="AI_SqlRemove" Description="Executing uninstall SQL scripts" DescriptionLocId="ActionText.Description.AI_SqlRemove" Template="Connection: [1]  Script: [2]" TemplateLocId="ActionText.Template.AI_SqlRemove"/>
    <ROW Action="AI_SqlRollback" Description="Executing rollback SQL scripts" DescriptionLocId="ActionText.Description.AI_SqlRollback" Template="Connection: [1]  Script: [2]" TemplateLocId="ActionText.Template.AI_SqlRollback"/>
    <ROW Action="AI_SqlUninstall" Description="Generating actions to configure databases for uninstall SQL script execution" DescriptionLocId="ActionText.Description.AI_SqlUninstall"/>
  </COMPONENT>
  <COMPONENT cid="caphyon.advinst.msicomp.MsiAppSearchComponent">
    <ROW Property="AI_SETUPEXEPATH" Signature_="AI_EXE_PATH_CU" Builds="DefaultBuild"/>
    <ROW Property="AI_SETUPEXEPATH" Signature_="AI_EXE_PATH_LM" Builds="DefaultBuild"/>
  </COMPONENT>
  <COMPONENT cid="caphyon.advinst.msicomp.MsiBinaryComponent">
    <ROW Name="Prereq.dll" SourcePath="&lt;AI_CUSTACTS&gt;Prereq.dll"/>
    <ROW Name="aicustact.dll" SourcePath="&lt;AI_CUSTACTS&gt;aicustact.dll"/>
    <ROW Name="lzmaextractor.dll" SourcePath="&lt;AI_CUSTACTS&gt;lzmaextractor.dll"/>
    <ROW Name="sql.dll" SourcePath="&lt;AI_CUSTACTS&gt;sql.dll"/>
  </COMPONENT>
  <COMPONENT cid="caphyon.advinst.msicomp.MsiComboBoxComponent">
    <ROW Property="DATABASE_COMBOBOX_RESULTS" Order="1" Value="LIMSplusV5DB" Text="LIMSplusV5DB"/>
    <ROW Property="SQL_SERVER_NAME_FIELD" Order="1" Value="servername\instance" Text="servername\instance"/>
  </COMPONENT>
  <COMPONENT cid="caphyon.advinst.msicomp.MsiControlComponent">
    <ROW Dialog_="FolderDlg" Control="Edit_1" Type="Edit" X="20" Y="167" Width="122" Height="18" Attributes="3" Property="DATABASE_SIZE_QUERY" Text="{260}" Order="1400"/>
    <ROW Dialog_="FolderDlg" Control="Text_1" Type="Text" X="20" Y="157" Width="251" Height="11" Attributes="65539" Property="TEXT_1_PROP" Text="data value:" Order="1500"/>
    <ROW Dialog_="FolderDlg" Control="TotalSpaceText" Type="Text" X="185" Y="188" Width="120" Height="11" Attributes="589827" Property="PrimaryVolumeSpaceRequired" Text="[PrimaryVolumeSpaceRequired]" Order="1600" TextLocId="Azure.Control.Text.FolderDlg#TotalSpaceText"/>
    <ROW Dialog_="FolderDlg" Control="AvailableSpaceText" Type="Text" X="185" Y="200" Width="120" Height="11" Attributes="589827" Property="PrimaryVolumeSpaceAvailable" Text="[PrimaryVolumeSpaceAvailable]" Order="1700" TextLocId="Azure.Control.Text.FolderDlg#AvailableSpaceText"/>
    <ROW Dialog_="FolderDlg" Control="RemainingSpaceText" Type="Text" X="185" Y="211" Width="120" Height="11" Attributes="589827" Property="PrimaryVolumeSpaceRemaining" Text="[PrimaryVolumeSpaceRemaining]" Order="1800" TextLocId="Azure.Control.Text.FolderDlg#RemainingSpaceText"/>
    <ROW Dialog_="FolderDlg" Control="RemainingSpaceLabel" Type="Text" X="20" Y="211" Width="160" Height="11" Attributes="196611" Property="REMAINING_SPACE_LABEL_PROP" Text="Remaining free space on drive: " Order="1900" TextLocId="Azure.Control.Text.FolderDlg#RemainingSpaceLabel"/>
    <ROW Dialog_="FolderDlg" Control="AvailableSpaceLabel" Type="Text" X="20" Y="200" Width="160" Height="11" Attributes="196611" Property="AVAILABLE_SPACE_LABEL_PROP" Text="Space available on drive: " Order="2000" TextLocId="Azure.Control.Text.FolderDlg#AvailableSpaceLabel"/>
    <ROW Dialog_="FolderDlg" Control="TotalSpaceLabel" Type="Text" X="20" Y="188" Width="160" Height="11" Attributes="196611" Property="TOTAL_SPACE_LABEL_PROP" Text="Total space required on drive:" Order="2100" TextLocId="Azure.Control.Text.FolderDlg#TotalSpaceLabel"/>
    <ROW Dialog_="SQLDialog" Control="Next" Type="PushButton" X="236" Y="243" Width="56" Height="17" Attributes="3" Text="[ButtonText_Next]" Order="100" TextLocId="-" Options="1"/>
    <ROW Dialog_="SQLDialog" Control="Cancel" Type="PushButton" X="304" Y="243" Width="56" Height="17" Attributes="3" Text="[ButtonText_Cancel]" Order="200" TextLocId="-" Options="1"/>
    <ROW Dialog_="SQLDialog" Control="Back" Type="PushButton" X="180" Y="243" Width="56" Height="17" Attributes="3" Text="[ButtonText_Back]" Order="300" TextLocId="-" Options="1"/>
    <ROW Dialog_="SQLDialog" Control="BannerBitmap" Type="Bitmap" X="0" Y="0" Width="370" Height="44" Attributes="1048577" Text="[BannerBitmap]" Order="400"/>
    <ROW Dialog_="SQLDialog" Control="BannerLine" Type="Line" X="0" Y="44" Width="372" Height="0" Attributes="1" Order="500"/>
    <ROW Dialog_="SQLDialog" Control="BottomLine" Type="Line" X="5" Y="234" Width="368" Height="0" Attributes="1" Order="600"/>
    <ROW Dialog_="SQLDialog" Control="Description" Type="Text" X="25" Y="23" Width="280" Height="15" Attributes="196611" Text="New Dialog Description..." Order="700"/>
    <ROW Dialog_="SQLDialog" Control="Logo" Type="Text" X="4" Y="228" Width="70" Height="12" Attributes="1" Text="Advanced Installer" Order="800"/>
    <ROW Dialog_="SQLDialog" Control="Title" Type="Text" X="15" Y="6" Width="200" Height="15" Attributes="196611" Text="New Dialog" TextStyle="[DlgTitleFont]" Order="900"/>
    <ROW Dialog_="SQLDialog" Control="Text_1" Type="Text" X="15" Y="51" Width="75" Height="11" Attributes="65539" Property="SQLServerName" Text="SQL Server Name:" Order="1000"/>
    <ROW Dialog_="SQLDialog" Control="Text_2" Type="Text" X="11" Y="75" Width="143" Height="11" Attributes="65539" Property="TEXT_2_PROP" Text="SQL Administration Credentials:" Order="1100"/>
    <ROW Dialog_="SQLDialog" Control="RadioButtonGroup_1" Type="RadioButtonGroup" X="11" Y="86" Width="349" Height="26" Attributes="3" Property="SQL_AUTHENTIFICATION_METHOD" Text="RadioButtonGroup" Order="1200"/>
    <ROW Dialog_="SQLDialog" Control="Text_3" Type="Text" X="26" Y="126" Width="75" Height="11" Attributes="65539" Property="UserName" Text="User Name:" Order="1300"/>
    <ROW Dialog_="SQLDialog" Control="Edit_2" Type="Edit" X="119" Y="126" Width="146" Height="18" Attributes="3" Property="USER_SQL" Text="{260}" Order="1400"/>
    <ROW Dialog_="SQLDialog" Control="Text_4" Type="Text" X="26" Y="152" Width="75" Height="11" Attributes="65539" Property="TEXT_4_PROP" Text="Password:" Order="1500"/>
    <ROW Dialog_="SQLDialog" Control="Edit_3" Type="Edit" X="119" Y="152" Width="146" Height="18" Attributes="3" Property="PASS_SQL" Text="{260}" Order="1600"/>
    <ROW Dialog_="SQLDialog" Control="Text_5" Type="Text" X="15" Y="182" Width="75" Height="11" Attributes="65539" Property="TEXT_5_PROP" Text="Database Name*:" Order="1700"/>
    <ROW Dialog_="SQLDialog" Control="ComboBox_1" Type="ComboBox" X="119" Y="182" Width="146" Height="16" Attributes="3" Property="DATABASE_COMBOBOX_RESULTS" Text="{260}" Order="1800"/>
    <ROW Dialog_="SQLDialog" Control="BrowseDatabase" Type="PushButton" X="297" Y="182" Width="68" Height="17" Attributes="3" Text="Browse Database" Order="1900"/>
    <ROW Dialog_="SQLDialog" Control="BrowseServer" Type="PushButton" X="297" Y="51" Width="68" Height="17" Attributes="3" Text="Browse Servers" Order="2000"/>
    <ROW Dialog_="SQLDialog" Control="ComboBox_2" Type="ComboBox" X="90" Y="51" Width="174" Height="16" Attributes="3" Property="SQL_SERVER_NAME_FIELD" Text="{260}" Order="2100"/>
    <ROW Dialog_="SQLDialog" Control="TestConnectionSQL" Type="PushButton" X="15" Y="251" Width="68" Height="17" Attributes="3" Text="TestConnection" Order="2200"/>
    <ROW Dialog_="SQLDialog" Control="Hyperlink_1" Type="Hyperlink" X="15" Y="210" Width="75" Height="11" Attributes="65539" Property="HYPERLINK_1_PROP" Text="&lt;a href=&quot;&quot;&gt;Test Connection&lt;/a&gt;" Order="2300"/>
    <ROW Dialog_="SQLDialog" Control="Text_6" Type="Text" X="180" Y="210" Width="146" Height="18" Attributes="3" Property="TEXT_6_PROP" Text="Connection failed." Order="2400"/>
    <ROW Dialog_="SQLDialog" Control="Text_7" Type="Text" X="119" Y="210" Width="96" Height="11" Attributes="3" Property="TEXT_7_PROP" Text="Connection successfull." Order="2500"/>
    <ROW Dialog_="VerifyReadyDlg" Control="Edit_1" Type="Edit" X="31" Y="122" Width="171" Height="18" Attributes="3" Property="LOG_FOLDER" Text="{260}" Order="1100"/>
    <ROW Dialog_="VerifyReadyDlg" Control="Browse" Type="PushButton" X="214" Y="122" Width="90" Height="18" Attributes="3" Text="[ButtonText_Browse]" Help="|" Order="1200" HelpLocId="Control.Help.FolderDlg#Browse"/>
  </COMPONENT>
  <COMPONENT cid="caphyon.advinst.msicomp.MsiControlConditionComponent">
    <ROW Dialog_="SQLDialog" Control_="Edit_2" Action="Enable" Condition="NOT (SQL_AUTHENTIFICATION_METHOD = &quot;Windows Authentification&quot;)"/>
    <ROW Dialog_="SQLDialog" Control_="Edit_2" Action="Disable" Condition="SQL_AUTHENTIFICATION_METHOD = &quot;Windows Authentification&quot; AND 1"/>
    <ROW Dialog_="SQLDialog" Control_="Edit_3" Action="Disable" Condition="SQL_AUTHENTIFICATION_METHOD = &quot;Windows Authentification&quot; AND 1"/>
    <ROW Dialog_="SQLDialog" Control_="Edit_3" Action="Enable" Condition="NOT (SQL_AUTHENTIFICATION_METHOD = &quot;Windows Authentification&quot;)"/>
    <ROW Dialog_="SQLDialog" Control_="Next" Action="Enable" Condition="SQL_SERVER_NAME_FIELD AND DATABASE_COMBOBOX_RESULTS AND ( SQL_AUTHENTIFICATION_METHOD =  &quot;Windows Authentification&quot; OR ( SQL_AUTHENTIFICATION_METHOD = &quot;SQL Authentification&quot; AND USER_SQL AND PASS_SQL ) )"/>
    <ROW Dialog_="SQLDialog" Control_="Next" Action="Disable" Condition="NOT SQL_SERVER_NAME_FIELD OR NOT DATABASE_COMBOBOX_RESULTS OR ( SQL_AUTHENTIFICATION_METHOD = &quot;SQL Authentification&quot; AND ( NOT PASS_SQL OR NOT USER_SQL )  )"/>
    <ROW Dialog_="SQLDialog" Control_="Text_7" Action="Show" Condition="TestConnectionResult = &quot;Successfully&quot;"/>
    <ROW Dialog_="SQLDialog" Control_="Text_7" Action="Hide" Condition="NOT TestConnectionResult = &quot;Successfully&quot;"/>
    <ROW Dialog_="SQLDialog" Control_="Hyperlink_1" Action="Enable" Condition="( SQL_AUTHENTIFICATION_METHOD = &quot;SQL Authentification&quot; AND  PASS_SQL AND USER_SQL) OR SQL_AUTHENTIFICATION_METHOD = &quot;Windows Authentification&quot;"/>
    <ROW Dialog_="SQLDialog" Control_="Hyperlink_1" Action="Disable" Condition="SQL_AUTHENTIFICATION_METHOD = &quot;SQL Authentification&quot; AND ( NOT PASS_SQL OR NOT USER_SQL ) "/>
    <ROW Dialog_="SQLDialog" Control_="Text_6" Action="Show" Condition="TestConnectionResult = &quot;Failed&quot;"/>
    <ROW Dialog_="SQLDialog" Control_="Text_6" Action="Hide" Condition="NOT TestConnectionResult = &quot;Failed&quot;"/>
  </COMPONENT>
  <COMPONENT cid="caphyon.advinst.msicomp.MsiControlEventComponent">
    <ROW Dialog_="WelcomeDlg" Control_="Next" Event="NewDialog" Argument="SQLDialog" Condition="AI_INSTALL" Ordering="1"/>
    <ROW Dialog_="FolderDlg" Control_="Next" Event="NewDialog" Argument="VerifyReadyDlg" Condition="AI_INSTALL AND ( PrimaryVolumeSpaceRemaining &gt; DATABASE_SIZE_QUERY )" Ordering="201"/>
    <ROW Dialog_="FolderDlg" Control_="Back" Event="NewDialog" Argument="SQLDialog" Condition="AI_INSTALL" Ordering="1"/>
    <ROW Dialog_="VerifyReadyDlg" Control_="Install" Event="EndDialog" Argument="Return" Condition="AI_INSTALL" Ordering="197"/>
    <ROW Dialog_="VerifyReadyDlg" Control_="Back" Event="NewDialog" Argument="FolderDlg" Condition="AI_INSTALL" Ordering="201"/>
    <ROW Dialog_="MaintenanceWelcomeDlg" Control_="Next" Event="NewDialog" Argument="MaintenanceTypeDlg" Condition="AI_MAINT" Ordering="99"/>
    <ROW Dialog_="CustomizeDlg" Control_="Next" Event="NewDialog" Argument="VerifyReadyDlg" Condition="AI_MAINT" Ordering="101"/>
    <ROW Dialog_="CustomizeDlg" Control_="Back" Event="NewDialog" Argument="MaintenanceTypeDlg" Condition="AI_MAINT" Ordering="1"/>
    <ROW Dialog_="VerifyReadyDlg" Control_="Install" Event="EndDialog" Argument="Return" Condition="AI_MAINT" Ordering="198"/>
    <ROW Dialog_="VerifyReadyDlg" Control_="Back" Event="NewDialog" Argument="CustomizeDlg" Condition="AI_MAINT" Ordering="202"/>
    <ROW Dialog_="MaintenanceTypeDlg" Control_="ChangeButton" Event="NewDialog" Argument="CustomizeDlg" Condition="AI_MAINT" Ordering="501"/>
    <ROW Dialog_="MaintenanceTypeDlg" Control_="Back" Event="NewDialog" Argument="MaintenanceWelcomeDlg" Condition="AI_MAINT" Ordering="1"/>
    <ROW Dialog_="MaintenanceTypeDlg" Control_="RemoveButton" Event="NewDialog" Argument="VerifyRemoveDlg" Condition="AI_MAINT AND InstallMode=&quot;Remove&quot;" Ordering="601"/>
    <ROW Dialog_="VerifyRemoveDlg" Control_="Back" Event="NewDialog" Argument="MaintenanceTypeDlg" Condition="AI_MAINT AND InstallMode=&quot;Remove&quot;" Ordering="1"/>
    <ROW Dialog_="MaintenanceTypeDlg" Control_="RepairButton" Event="NewDialog" Argument="VerifyRepairDlg" Condition="AI_MAINT AND InstallMode=&quot;Repair&quot;" Ordering="601"/>
    <ROW Dialog_="VerifyRepairDlg" Control_="Back" Event="NewDialog" Argument="MaintenanceTypeDlg" Condition="AI_MAINT AND InstallMode=&quot;Repair&quot;" Ordering="1"/>
    <ROW Dialog_="VerifyRepairDlg" Control_="Repair" Event="EndDialog" Argument="Return" Condition="AI_MAINT AND InstallMode=&quot;Repair&quot;" Ordering="399" Options="1"/>
    <ROW Dialog_="VerifyRemoveDlg" Control_="Remove" Event="EndDialog" Argument="Return" Condition="AI_MAINT AND InstallMode=&quot;Remove&quot;" Ordering="299" Options="1"/>
    <ROW Dialog_="PatchWelcomeDlg" Control_="Next" Event="NewDialog" Argument="VerifyReadyDlg" Condition="AI_PATCH" Ordering="201"/>
    <ROW Dialog_="ResumeDlg" Control_="Install" Event="EndDialog" Argument="Return" Condition="AI_RESUME" Ordering="299"/>
    <ROW Dialog_="SQLDialog" Control_="Cancel" Event="SpawnDialog" Argument="CancelDlg" Condition="1" Ordering="100"/>
    <ROW Dialog_="SQLDialog" Control_="Next" Event="NewDialog" Argument="FolderDlg" Condition="AI_INSTALL AND ( NOT (SQL_SERVER_NAME_FIELD = &quot;servername\instance&quot;) )" Ordering="1"/>
    <ROW Dialog_="SQLDialog" Control_="Back" Event="NewDialog" Argument="WelcomeDlg" Condition="AI_INSTALL" Ordering="1"/>
    <ROW Dialog_="SQLDialog" Control_="BrowseDatabase" Event="DoAction" Argument="ShowDatabases" Condition="1" Ordering="6"/>
    <ROW Dialog_="SQLDialog" Control_="BrowseDatabase" Event="DoAction" Argument="AI_DATA_SETTER" Condition="1" Ordering="5"/>
    <ROW Dialog_="SQLDialog" Control_="BrowseDatabase" Event="[AiRefreshDlg]" Argument="1" Condition="AI_INSTALL" Ordering="7"/>
    <ROW Dialog_="SQLDialog" Control_="BrowseDatabase" Event="[SqlTrustedConnection]" Argument="1" Condition="SQL_AUTHENTIFICATION_METHOD = &quot;Windows Authentification&quot;" Ordering="4"/>
    <ROW Dialog_="SQLDialog" Control_="BrowseDatabase" Event="[SqlTrustedConnection]" Argument="{}" Condition="SQL_AUTHENTIFICATION_METHOD = &quot;SQL Authentification&quot; " Ordering="3"/>
    <ROW Dialog_="VerifyReadyDlg" Control_="Install" Event="EndDialog" Argument="Return" Condition="AI_PATCH" Ordering="199"/>
    <ROW Dialog_="VerifyReadyDlg" Control_="Back" Event="NewDialog" Argument="PatchWelcomeDlg" Condition="AI_PATCH" Ordering="203"/>
    <ROW Dialog_="SQLDialog" Control_="BrowseServer" Event="DoAction" Argument="BrowseSqlServers" Condition="AI_INSTALL" Ordering="1"/>
    <ROW Dialog_="SQLDialog" Control_="BrowseServer" Event="DoAction" Argument="AI_DATA_SETTER_1" Condition="AI_INSTALL" Ordering="0"/>
    <ROW Dialog_="SQLDialog" Control_="BrowseServer" Event="[AiRefreshDlg]" Argument="1" Condition="AI_INSTALL" Ordering="2"/>
    <ROW Dialog_="SQLDialog" Control_="TestConnectionSQL" Event="[SqlConnectionString]" Argument="Driver=SQL Server;Server=[SQL_SERVER_NAME_FIELD];Uid=[USERNAME_SQL_AUTHENTIFICATION_METHOD];Pwd=[PASSWORD_SQL_AUTHENTIFICATION_METHOD];" Condition="SQL_AUTHENTIFICATION_METHOD = &quot;SQL Authentification&quot;" Ordering="0"/>
    <ROW Dialog_="SQLDialog" Control_="TestConnectionSQL" Event="DoAction" Argument="TestODBCConnection" Condition="AI_INSTALL" Ordering="3"/>
    <ROW Dialog_="SQLDialog" Control_="TestConnectionSQL" Event="[RESULT]" Argument="&quot;Is working&quot;" Condition="SqlConnectionOK = &quot;1&quot;" Ordering="4"/>
    <ROW Dialog_="SQLDialog" Control_="TestConnectionSQL" Event="[RESULT]" Argument="&quot;Is not Working&quot;" Condition="SqlConnectionOK = &quot;0&quot;" Ordering="5"/>
    <ROW Dialog_="SQLDialog" Control_="TestConnectionSQL" Event="[SqlConnectionString]" Argument="Driver=SQL Server;Server=[SQL_SERVER_NAME_FIELD];Uid=[LogonUser];Trusted_Connection=yes;" Condition="SQL_AUTHENTIFICATION_METHOD = &quot;Windows Authentification&quot;" Ordering="2"/>
    <ROW Dialog_="SQLDialog" Control_="Hyperlink_1" Event="[SqlConnectionString]" Argument="Driver=SQL Server;Server=[SQL_SERVER_NAME_FIELD];Uid=[USER_SQL];Pwd=[PASS_SQL];" Condition="SQL_AUTHENTIFICATION_METHOD = &quot;SQL Authentification&quot;" Ordering="0"/>
    <ROW Dialog_="SQLDialog" Control_="Hyperlink_1" Event="[SqlConnectionString]" Argument="Driver=SQL Server;Server=[SQL_SERVER_NAME_FIELD];Uid=[LogonUser];Trusted_Connection=yes;" Condition="SQL_AUTHENTIFICATION_METHOD = &quot;Windows Authentification&quot;" Ordering="1"/>
    <ROW Dialog_="SQLDialog" Control_="Hyperlink_1" Event="DoAction" Argument="TestODBCConnection" Condition="AI_INSTALL" Ordering="2"/>
    <ROW Dialog_="SQLDialog" Control_="Hyperlink_1" Event="[TestConnectionResult]" Argument="Successfully" Condition="SqlConnectionOK = &quot;1&quot;" Ordering="3"/>
    <ROW Dialog_="SQLDialog" Control_="Hyperlink_1" Event="[TestConnectionResult]" Argument="Failed" Condition="SqlConnectionOK = &quot;0&quot;" Ordering="4"/>
    <ROW Dialog_="SQLDialog" Control_="Next" Event="DoAction" Argument="MessageBox" Condition="AI_INSTALL AND ( SQL_SERVER_NAME_FIELD = &quot;servername\instance&quot; )" Ordering="3"/>
    <ROW Dialog_="SQLDialog" Control_="Next" Event="DoAction" Argument="AI_DATA_SETTER_3" Condition="AI_INSTALL AND ( SQL_SERVER_NAME_FIELD = &quot;servername\instance&quot; )" Ordering="2"/>
    <ROW Dialog_="SQLDialog" Control_="Next" Event="[USER_SQL]" Argument="{}" Condition="SQL_AUTHENTICATION_METHOD = &quot;Windows&quot;" Ordering="4"/>
    <ROW Dialog_="SQLDialog" Control_="Next" Event="[SqlTrustedConnection]" Argument="{}" Condition="SQL_AUTHENTICATION_METHOD = &quot;SQL&quot;" Ordering="5"/>
    <ROW Dialog_="SQLDialog" Control_="Next" Event="[SqlTrustedConnection]" Argument="1" Condition="SQL_AUTHENTICATION_METHOD = &quot;Windows&quot;" Ordering="6"/>
    <ROW Dialog_="FolderDlg" Control_="Next" Event="SetTargetPath" Argument="APPDIR" Condition="1" Ordering="200" MsiKey="FolderDlg#Next#SetTargetPath#APPDIR#1"/>
    <ROW Dialog_="SQLDialog" Control_="Next" Event="DoAction" Argument="SqlQueryActionDatabaseSize" Condition="AI_INSTALL" Ordering="8"/>
    <ROW Dialog_="SQLDialog" Control_="Next" Event="DoAction" Argument="AI_DATA_SETTER_4" Condition="AI_INSTALL" Ordering="7"/>
    <ROW Dialog_="FolderDlg" Control_="Next" Event="DoAction" Argument="MessageBoxSpaceNotEnough" Condition="AI_INSTALL AND ( PrimaryVolumeSpaceRemaining &lt; DATABASE_SIZE_QUERY )" Ordering="203"/>
    <ROW Dialog_="FolderDlg" Control_="Next" Event="DoAction" Argument="AI_DATA_SETTER_5" Condition="AI_INSTALL AND ( PrimaryVolumeSpaceRemaining &lt; DATABASE_SIZE_QUERY )" Ordering="202"/>
    <ROW Dialog_="VerifyReadyDlg" Control_="Browse" Event="SpawnDialog" Argument="BrowseDlg" Condition="1" Ordering="200"/>
    <ROW Dialog_="VerifyReadyDlg" Control_="Browse" Event="[_BrowseProperty]" Argument="LOG_FOLDER" Condition="1" Ordering="100"/>
  </COMPONENT>
  <COMPONENT cid="caphyon.advinst.msicomp.MsiCustActComponent">
    <ROW Action="AI_BACKUP_AI_SETUPEXEPATH" Type="51" Source="AI_SETUPEXEPATH_ORIGINAL" Target="[AI_SETUPEXEPATH]"/>
    <ROW Action="AI_DATA_SETTER" Type="51" Source="CustomActionData" Target="DatabaseBrowse"/>
    <ROW Action="AI_DATA_SETTER_1" Type="51" Source="CustomActionData" Target="ServerBrowse"/>
    <ROW Action="AI_DATA_SETTER_2" Type="51" Source="AI_ExtractFiles" Target="[AI_SETUPEXEPATH]"/>
    <ROW Action="AI_DATA_SETTER_3" Type="51" Source="CustomActionData" Target="servername\\instance is not a valid |Warning |MB_OK,MB_ICONINFORMATION,MB_DEFBUTTON1|BTN_PRESSED|[CLIENTPROCESSID]"/>
    <ROW Action="AI_DATA_SETTER_4" Type="51" Source="CustomActionData" Target="SqlQueryDatabaseSize"/>
    <ROW Action="AI_DATA_SETTER_5" Type="51" Source="CustomActionData" Target="There is not enough space to perform the database backup operation |Warning |MB_OK,MB_ICONINFORMATION,MB_DEFBUTTON1|BTN_PRESSED|[CLIENTPROCESSID]"/>
    <ROW Action="AI_DATA_SETTER_6" Type="51" Source="CustomActionData" Target="[~]"/>
    <ROW Action="AI_DATA_SETTER_7" Type="51" Source="CustomActionData" Target="[~]"/>
    <ROW Action="AI_DOWNGRADE" Type="19" Target="4010"/>
    <ROW Action="AI_DeleteCadLzma" Type="51" Source="AI_DeleteLzma" Target="[AI_SETUPEXEPATH]"/>
    <ROW Action="AI_DeleteLzma" Type="1025" Source="lzmaextractor.dll" Target="DeleteLZMAFiles"/>
    <ROW Action="AI_DeleteRCadLzma" Type="51" Source="AI_DeleteRLzma" Target="[AI_SETUPEXEPATH]"/>
    <ROW Action="AI_DeleteRLzma" Type="1281" Source="lzmaextractor.dll" Target="DeleteLZMAFiles"/>
    <ROW Action="AI_DpiContentScale" Type="1" Source="aicustact.dll" Target="DpiContentScale"/>
    <ROW Action="AI_EnableDebugLog" Type="321" Source="aicustact.dll" Target="EnableDebugLog"/>
    <ROW Action="AI_EstimateExtractFiles" Type="1" Source="Prereq.dll" Target="EstimateExtractFiles"/>
    <ROW Action="AI_ExtractCadLzma" Type="51" Source="AI_ExtractLzma" Target="[AI_SETUPEXEPATH]"/>
    <ROW Action="AI_ExtractFiles" Type="1025" Source="Prereq.dll" Target="ExtractSourceFiles" AdditionalSeq="AI_DATA_SETTER_2"/>
    <ROW Action="AI_ExtractLzma" Type="1025" Source="lzmaextractor.dll" Target="ExtractLZMAFiles"/>
    <ROW Action="AI_FindExeLzma" Type="1" Source="lzmaextractor.dll" Target="FindEXE"/>
    <ROW Action="AI_InstallModeCheck" Type="1" Source="aicustact.dll" Target="UpdateInstallMode" WithoutSeq="true"/>
    <ROW Action="AI_PREPARE_UPGRADE" Type="65" Source="aicustact.dll" Target="PrepareUpgrade"/>
    <ROW Action="AI_RESTORE_AI_SETUPEXEPATH" Type="51" Source="AI_SETUPEXEPATH" Target="[AI_SETUPEXEPATH_ORIGINAL]"/>
    <ROW Action="AI_RESTORE_LOCATION" Type="65" Source="aicustact.dll" Target="RestoreLocation"/>
    <ROW Action="AI_ResolveKnownFolders" Type="1" Source="aicustact.dll" Target="AI_ResolveKnownFolders"/>
    <ROW Action="AI_SHOW_LOG" Type="65" Source="aicustact.dll" Target="LaunchLogFile" WithoutSeq="true"/>
    <ROW Action="AI_STORE_LOCATION" Type="51" Source="ARPINSTALLLOCATION" Target="[APPDIR]"/>
    <ROW Action="AI_SqlConfig" Type="9217" Source="sql.dll" Target="OnSqlConfig" WithoutSeq="true"/>
    <ROW Action="AI_SqlInstall" Type="1" Source="sql.dll" Target="OnSqlInstall" AdditionalSeq="AI_DATA_SETTER_6"/>
    <ROW Action="AI_SqlMaint" Type="9217" Source="sql.dll" Target="OnSqlMaint" WithoutSeq="true"/>
    <ROW Action="AI_SqlRemove" Type="9217" Source="sql.dll" Target="OnSqlRemove" WithoutSeq="true"/>
    <ROW Action="AI_SqlRollback" Type="9473" Source="sql.dll" Target="OnSqlRollback" WithoutSeq="true"/>
    <ROW Action="AI_SqlUninstall" Type="1" Source="sql.dll" Target="OnSqlUninstall" AdditionalSeq="AI_DATA_SETTER_7"/>
    <ROW Action="BrowseSqlServers" Type="1" Source="sql.dll" Target="BrowseSqlServers" WithoutSeq="true" AdditionalSeq="AI_DATA_SETTER_1"/>
    <ROW Action="MessageBox" Type="1" Source="aicustact.dll" Target="MsgBox" WithoutSeq="true" Options="1" AdditionalSeq="AI_DATA_SETTER_3"/>
    <ROW Action="MessageBoxSpaceNotEnough" Type="1" Source="aicustact.dll" Target="MsgBox" WithoutSeq="true" Options="1" AdditionalSeq="AI_DATA_SETTER_5"/>
    <ROW Action="SET_APPDIR" Type="307" Source="APPDIR" Target="[ProgramFilesFolder][Manufacturer]\[ProductName]"/>
    <ROW Action="SET_SHORTCUTDIR" Type="307" Source="SHORTCUTDIR" Target="[ProgramMenuFolder][ProductName]"/>
    <ROW Action="SET_TARGETDIR_TO_APPDIR" Type="51" Source="TARGETDIR" Target="[APPDIR]"/>
    <ROW Action="SetPropertyToPerformDiskInfoCheck" Type="51" Source="AiEarlyValidate" Target="1"/>
    <ROW Action="ShowDatabases" Type="1" Source="sql.dll" Target="ShowDatabases" WithoutSeq="true" AdditionalSeq="AI_DATA_SETTER"/>
    <ROW Action="SqlQueryActionDatabaseSize" Type="257" Source="sql.dll" Target="OnSqlFetch" WithoutSeq="true" AdditionalSeq="AI_DATA_SETTER_4"/>
    <ROW Action="TestODBCConnection" Type="1" Source="sql.dll" Target="TestSqlConnection" WithoutSeq="true" Options="1"/>
  </COMPONENT>
  <COMPONENT cid="caphyon.advinst.msicomp.MsiDialogComponent">
    <ROW Dialog="SQLDialog" HCentering="50" VCentering="50" Width="370" Height="270" Attributes="3" Title="[ProductName] [Setup]" Control_Default="Next" Control_Cancel="Cancel"/>
  </COMPONENT>
  <COMPONENT cid="caphyon.advinst.msicomp.MsiInstExSeqComponent">
    <ROW Action="AI_DOWNGRADE" Condition="AI_NEWERPRODUCTFOUND AND (UILevel &lt;&gt; 5)" Sequence="210"/>
    <ROW Action="AI_RESTORE_LOCATION" Condition="APPDIR=&quot;&quot;" Sequence="749"/>
    <ROW Action="AI_STORE_LOCATION" Condition="(Not Installed) OR REINSTALL" Sequence="1501"/>
    <ROW Action="AI_PREPARE_UPGRADE" Condition="AI_UPGRADE=&quot;No&quot; AND (Not Installed)" Sequence="1399"/>
    <ROW Action="AI_ResolveKnownFolders" Sequence="52"/>
    <ROW Action="AI_SqlInstall" Condition="(VersionNT &gt;= 500) AND (REMOVE &lt;&gt; &quot;ALL&quot;)" Sequence="5499"/>
    <ROW Action="AI_SqlUninstall" Condition="(VersionNT &gt;= 500) AND (REMOVE=&quot;ALL&quot;)" Sequence="1649"/>
    <ROW Action="AI_EnableDebugLog" Sequence="51"/>
    <ROW Action="AI_DATA_SETTER_6" Condition="(VersionNT &gt;= 500) AND (REMOVE &lt;&gt; &quot;ALL&quot;)" Sequence="5498"/>
    <ROW Action="AI_DATA_SETTER_7" Condition="(VersionNT &gt;= 500) AND (REMOVE=&quot;ALL&quot;)" Sequence="1648"/>
    <ROW Action="AI_BACKUP_AI_SETUPEXEPATH" Sequence="99" Builds="DefaultBuild"/>
    <ROW Action="AI_RESTORE_AI_SETUPEXEPATH" Condition="AI_SETUPEXEPATH_ORIGINAL" Sequence="101" Builds="DefaultBuild"/>
    <ROW Action="AI_DeleteCadLzma" Condition="SETUPEXEDIR=&quot;&quot; AND Installed AND (REMOVE&lt;&gt;&quot;ALL&quot;) AND (AI_INSTALL_MODE&lt;&gt;&quot;Remove&quot;) AND (NOT PATCH)" Sequence="199" Builds="DefaultBuild"/>
    <ROW Action="AI_DeleteRCadLzma" Condition="SETUPEXEDIR=&quot;&quot; AND Installed AND (REMOVE&lt;&gt;&quot;ALL&quot;) AND (AI_INSTALL_MODE&lt;&gt;&quot;Remove&quot;) AND (NOT PATCH)" Sequence="198" Builds="DefaultBuild"/>
    <ROW Action="AI_ExtractCadLzma" Condition="SETUPEXEDIR=&quot;&quot; AND Installed AND (REMOVE&lt;&gt;&quot;ALL&quot;) AND (AI_INSTALL_MODE&lt;&gt;&quot;Remove&quot;) AND (NOT PATCH)" Sequence="197" Builds="DefaultBuild"/>
    <ROW Action="AI_FindExeLzma" Condition="SETUPEXEDIR=&quot;&quot; AND Installed AND (REMOVE&lt;&gt;&quot;ALL&quot;) AND (AI_INSTALL_MODE&lt;&gt;&quot;Remove&quot;) AND (NOT PATCH)" Sequence="196" Builds="DefaultBuild"/>
    <ROW Action="AI_ExtractLzma" Condition="SETUPEXEDIR=&quot;&quot; AND Installed AND (REMOVE&lt;&gt;&quot;ALL&quot;) AND (AI_INSTALL_MODE&lt;&gt;&quot;Remove&quot;) AND (NOT PATCH)" Sequence="1549" Builds="DefaultBuild"/>
    <ROW Action="AI_DeleteRLzma" Condition="SETUPEXEDIR=&quot;&quot; AND Installed AND (REMOVE&lt;&gt;&quot;ALL&quot;) AND (AI_INSTALL_MODE&lt;&gt;&quot;Remove&quot;) AND (NOT PATCH)" Sequence="1548" Builds="DefaultBuild"/>
    <ROW Action="AI_DeleteLzma" Condition="SETUPEXEDIR=&quot;&quot; AND Installed AND (REMOVE&lt;&gt;&quot;ALL&quot;) AND (AI_INSTALL_MODE&lt;&gt;&quot;Remove&quot;) AND (NOT PATCH)" Sequence="6599" Builds="DefaultBuild"/>
    <ROW Action="AI_ExtractFiles" Sequence="3998" Builds="DefaultBuild"/>
    <ROW Action="AI_DATA_SETTER_2" Sequence="3997"/>
    <ROW Action="AI_EstimateExtractFiles" Sequence="3999" Builds="DefaultBuild"/>
  </COMPONENT>
  <COMPONENT cid="caphyon.advinst.msicomp.MsiInstallUISequenceComponent">
    <ROW Action="AI_RESTORE_LOCATION" Condition="APPDIR=&quot;&quot;" Sequence="749"/>
    <ROW Action="AI_ResolveKnownFolders" Sequence="53"/>
    <ROW Action="AI_DpiContentScale" Sequence="52"/>
    <ROW Action="AI_BACKUP_AI_SETUPEXEPATH" Sequence="99"/>
    <ROW Action="AI_RESTORE_AI_SETUPEXEPATH" Condition="AI_SETUPEXEPATH_ORIGINAL" Sequence="101"/>
    <ROW Action="SetPropertyToPerformDiskInfoCheck" Condition="( NOT Installed )" Sequence="201"/>
    <ROW Action="AI_EnableDebugLog" Sequence="51"/>
  </COMPONENT>
  <COMPONENT cid="caphyon.advinst.msicomp.MsiLaunchConditionsComponent">
    <ROW Condition="(VersionNT &lt;&gt; 400)" Description="[ProductName] cannot be installed on the following Windows versions: [WindowsTypeNT40Display]" DescriptionLocId="AI.LaunchCondition.NoNT40" IsPredefined="true" Builds="DefaultBuild"/>
    <ROW Condition="(VersionNT &lt;&gt; 500)" Description="[ProductName] cannot be installed on [WindowsTypeNT50Display]." DescriptionLocId="AI.LaunchCondition.NoNT50" IsPredefined="true" Builds="DefaultBuild"/>
    <ROW Condition="(VersionNT64 OR ((VersionNT &lt;&gt; 501) OR (ServicePackLevel = 3))) AND ((VersionNT &lt;&gt; 502) OR (ServicePackLevel = 2))" Description="[ProductName] cannot be installed on [WindowsTypeNT5XDisplay]." DescriptionLocId="AI.LaunchCondition.NoNT5X" IsPredefined="true" Builds="DefaultBuild"/>
    <ROW Condition="SETUPEXEDIR OR (REMOVE=&quot;ALL&quot;)" Description="This package can only be run from a bootstrapper." DescriptionLocId="AI.LaunchCondition.RequireBootstrapper" IsPredefined="true" Builds="DefaultBuild"/>
    <ROW Condition="VersionNT" Description="[ProductName] cannot be installed on [WindowsType9XDisplay]." DescriptionLocId="AI.LaunchCondition.No9X" IsPredefined="true" Builds="DefaultBuild"/>
  </COMPONENT>
  <COMPONENT cid="caphyon.advinst.msicomp.MsiRadioButtonComponent">
    <ROW Property="SQL_AUTHENTIFICATION_METHOD" Order="1" Value="Windows Authentification" X="21" Y="8" Width="122" Height="10" Text="Windows Authentification"/>
    <ROW Property="SQL_AUTHENTIFICATION_METHOD" Order="2" Value="SQL Authentification" X="214" Y="8" Width="121" Height="10" Text="SQL Authentification"/>
  </COMPONENT>
  <COMPONENT cid="caphyon.advinst.msicomp.MsiRegLocatorComponent">
    <ROW Signature_="AI_EXE_PATH_CU" Root="1" Key="Software\Caphyon\Advanced Installer\LZMA\[ProductCode]\[ProductVersion]" Name="AI_ExePath" Type="2"/>
    <ROW Signature_="AI_EXE_PATH_LM" Root="2" Key="Software\Caphyon\Advanced Installer\LZMA\[ProductCode]\[ProductVersion]" Name="AI_ExePath" Type="2"/>
  </COMPONENT>
  <COMPONENT cid="caphyon.advinst.msicomp.MsiRegsComponent">
    <ROW Registry="AI_ExePath" Root="-1" Key="Software\Caphyon\Advanced Installer\LZMA\[ProductCode]\[ProductVersion]" Name="AI_ExePath" Value="[AI_SETUPEXEPATH]" Component_="AI_ExePath"/>
    <ROW Registry="Path" Root="-1" Key="Software\[Manufacturer]\[ProductName]" Name="Path" Value="[APPDIR]" Component_="ProductInformation"/>
    <ROW Registry="Version" Root="-1" Key="Software\[Manufacturer]\[ProductName]" Name="Version" Value="[ProductVersion]" Component_="ProductInformation"/>
  </COMPONENT>
  <COMPONENT cid="caphyon.advinst.msicomp.MsiTextStyleComponent">
    <ROW TextStyle="TestDBConnectionFailed" FaceName="Verdana" Size="10" Color="255" StyleBits="3"/>
  </COMPONENT>
  <COMPONENT cid="caphyon.advinst.msicomp.MsiThemeComponent">
    <ATTRIBUTE name="UsedTheme" value="classic"/>
  </COMPONENT>
  <COMPONENT cid="caphyon.advinst.msicomp.MsiUpgradeComponent">
    <ROW UpgradeCode="[|UpgradeCode]" VersionMin="0.0.1" VersionMax="[|ProductVersion]" Attributes="257" ActionProperty="OLDPRODUCTS"/>
    <ROW UpgradeCode="[|UpgradeCode]" VersionMin="[|ProductVersion]" Attributes="2" ActionProperty="AI_NEWERPRODUCTFOUND"/>
  </COMPONENT>
  <COMPONENT cid="caphyon.advinst.msicomp.SqlBrowseComponent">
    <ROW BrowseName="DatabaseBrowse" Flags="8" TimeOut="10" ListBoxProp="YourProperty" ComboBoxProp="DATABASE_COMBOBOX_RESULTS" ServerName="[SQL_SERVER_NAME_FIELD]" UserName="[USER_SQL]" Password="[PASS_SQL]"/>
    <ROW BrowseName="ServerBrowse" Flags="101482" TimeOut="60" ComboBoxProp="SQL_SERVER_NAME_FIELD"/>
  </COMPONENT>
  <COMPONENT cid="caphyon.advinst.msicomp.SqlConnectionComponent">
    <ROW ConnectionName="PredefinedConnection" Condition="1" Dbms="0" OdbcResource="SQL Server" Server="[SQL_SERVER_NAME_FIELD]" Port="1433" Database="[DATABASE_COMBOBOX_RESULTS]" Username="[USER_SQL]" PassProperty="PASS_SQL" Flags="6" Order="0" LoginTimeout="20"/>
  </COMPONENT>
  <COMPONENT cid="caphyon.advinst.msicomp.SqlReplaceComponent">
    <ROW ScriptName="SqlQueryDatabaseSize" Token="Selected_database" Replacement="[DATABASE_COMBOBOX_RESULTS]" Flags="0"/>
  </COMPONENT>
  <COMPONENT cid="caphyon.advinst.msicomp.SqlScriptComponent">
    <ROW ScriptName="SqlQueryDatabaseSize" ConnectionName="PredefinedConnection" Condition="1" Separator="GO" ScriptInline="IF NOT EXISTS (SELECT * FROM information_schema.tables WHERE table_name=&apos;tbl_Config&apos; and table_schema=&apos;dbo&apos;)&#13;&#10;BEGIN&#13;&#10;CREATE TABLE [tbl_Config](&#13;&#10;&#9;[Variable] [nvarchar](50) NOT NULL,&#13;&#10;&#9;[Value] [nvarchar](MAX) NULL,&#13;&#10;&#9;[Description] [nvarchar](150) NULL,&#13;&#10;&#9;[Created] [smalldatetime] NULL DEFAULT (getdate()),&#13;&#10;&#9;[SoftwareGroup] [varchar](50) NULL&#13;&#10;) ON [PRIMARY]&#13;&#10;IF (@@error=0) print &apos;Add new table: tbl_Config&apos;&#13;&#10;else print &apos;Add new table: tbl_Config -&gt; fail&apos;&#13;&#10;END&#13;&#10;ELSE &#13;&#10;BEGIN &#13;&#10;   IF NOT EXISTS (SELECT * FROM information_schema.columns WHERE table_name=&apos;tbl_Config&apos; and column_name=&apos;Variable&apos; and table_schema=&apos;dbo&apos;) &#9;&#13;&#10;   BEGIN &#13;&#10;&#9;&#9;ALTER TABLE tbl_Config ADD [Variable] [nvarchar](50) NOT NULL&#13;&#10;&#9;&#9;if (@@error = 0) print &apos;Table: tbl_Config. Add new column: Variable&apos;&#13;&#10;&#9;&#9;else print &apos;Table: tbl_Config. Add new column: Variable -&gt; fail&apos;&#13;&#10;   END&#13;&#10;   ELSE&#13;&#10;   BEGIN&#13;&#10;&#9;&#9;UPDATE tbl_Config SET Variable = NEWID() WHERE Variable Is NULL&#13;&#10;&#9;&#9;IF ((SELECT character_maximum_length FROM information_schema.columns WHERE table_name = &apos;tbl_Config&apos; and column_name = &apos;Variable&apos;) &lt;&gt; 50)&#13;&#10;&#9;&#9;BEGIN&#13;&#10;&#9;&#9;&#9;ALTER TABLE tbl_Config ALTER COLUMN [Variable] [nvarchar](50) NOT NULL&#13;&#10;&#9;&#9;&#9;if (@@error = 0) print &apos;Table: tbl_Config. Modify column: Variable&apos;&#13;&#10;&#9;&#9;&#9;else print &apos;Table: tbl_Config. Modify column: Variable -&gt; fail&apos;&#13;&#10;&#9;&#9;END&#13;&#10;   END&#13;&#10;   IF NOT EXISTS (SELECT * FROM information_schema.columns WHERE table_name=&apos;tbl_Config&apos; and column_name=&apos;Value&apos; and table_schema=&apos;dbo&apos;) &#9;&#13;&#10;   BEGIN &#13;&#10;&#9;&#9;ALTER TABLE tbl_Config ADD [Value] NVARCHAR(MAX)&#13;&#10;&#9;&#9;if (@@error = 0) print &apos;Table: tbl_Config. Add new column: Value&apos;&#13;&#10;&#9;&#9;else print &apos;Table: tbl_Config. Add new column: Value -&gt; fail&apos;&#13;&#10;   END&#13;&#10;   ELSE&#13;&#10;   BEGIN&#13;&#10;        IF ((SELECT character_maximum_length FROM information_schema.columns WHERE table_name = &apos;tbl_Config&apos; and column_name = &apos;Value&apos;) = 50)&#13;&#10;&#9;&#9;BEGIN&#13;&#10;&#9;&#9;&#9;ALTER TABLE [tbl_Config] ALTER COLUMN [Value] NVARCHAR(MAX)&#13;&#10;&#9;&#9;&#9;if (@@error = 0) print &apos;Table: tbl_Config. Modify column: Value(max)&apos;&#13;&#10;&#9;&#9;&#9;else print &apos;Table: tbl_Config. Modify column: Value(max) -&gt; fail&apos;&#13;&#10;&#9;&#9;END&#13;&#10;&#9;&#9;&#13;&#10;&#13;&#10;   END&#13;&#10;   IF NOT EXISTS (SELECT * FROM information_schema.columns WHERE table_name=&apos;tbl_Config&apos; and column_name=&apos;Description&apos; and table_schema=&apos;dbo&apos;) &#9;&#13;&#10;   BEGIN &#13;&#10;&#9;&#9;ALTER TABLE tbl_Config ADD [Description] [nvarchar](150) NULL&#13;&#10;&#9;&#9;if (@@error = 0) print &apos;Table: tbl_Config. Add new column: Description&apos;&#13;&#10;&#9;&#9;else print &apos;Table: tbl_Config. Add new column: Description -&gt; fail&apos;&#13;&#10;   END&#13;&#10;   IF NOT EXISTS (SELECT * FROM information_schema.columns WHERE table_name=&apos;tbl_Config&apos; and column_name=&apos;Created&apos; and table_schema=&apos;dbo&apos;) &#9;&#13;&#10;   BEGIN &#13;&#10;&#9;&#9;ALTER TABLE tbl_Config ADD [Created] [smalldatetime] NULL&#13;&#10;&#9;&#9;if (@@error = 0) print &apos;Table: tbl_Config. Add new column: Created&apos;&#13;&#10;&#9;&#9;else print &apos;Table: tbl_Config. Add new column: Created -&gt; fail&apos;&#13;&#10;   END&#13;&#10;   IF NOT EXISTS (SELECT * FROM information_schema.columns WHERE table_name=&apos;tbl_Config&apos; and column_name=&apos;SoftwareGroup&apos; and table_schema=&apos;dbo&apos;) &#9;&#13;&#10;   BEGIN &#13;&#10;&#9;&#9;ALTER TABLE tbl_Config ADD [SoftwareGroup] [varchar](50) NULL&#13;&#10;&#9;&#9;if (@@error = 0) print &apos;Table: tbl_Config. Add new column: SoftwareGroup&apos;&#13;&#10;&#9;&#9;else print &apos;Table: tbl_Config. Add new column: SoftwareGroup -&gt; fail&apos;&#13;&#10;   END&#13;&#10;   ELSE &#13;&#10;   BEGIN&#13;&#10;     IF ((SELECT character_maximum_length FROM information_schema.columns WHERE table_name = &apos;tbl_Config&apos; and column_name = &apos;SoftwareGroup&apos;) &lt;&gt; 50)&#13;&#10;&#9;   BEGIN&#13;&#10;&#9;&#9;   ALTER TABLE tbl_Config ALTER COLUMN&#9;[SoftwareGroup] [varchar](50) NULL&#13;&#10;&#9;&#9;   if (@@error = 0) print &apos;Table: tbl_Config. Modify column: SoftwareGroup&apos;&#13;&#10;&#9;&#9;   else print &apos;Table: tbl_Config. Modify column: SoftwareGroup -&gt; fail&apos;&#13;&#10;&#9;   END&#13;&#10;   END&#13;&#10;END &#13;&#10;GO&#13;&#10;&#13;&#10;IF NOT EXISTS(SELECT * FROM [tbl_Config] WHERE [Variable] = &apos;Val1&apos;)&#13;&#10;INSERT [tbl_Config] ([Variable], [Value], [Description], [Created], [SoftwareGroup]) VALUES (N&apos;Val1&apos;, N&apos;\\localhost\&apos;, N&apos;\\IP_ADRESS\&apos;, GETDATE(), N&apos;ALL&apos;)&#13;&#10;GO&#13;&#10;&#13;&#10;SELECT [Description] FROM [tbl_Config] WHERE  [Description] = &apos;\\IP_ADRESS\&apos; -- OK&#13;&#10;--SELECT [tbl_Config].[Value] FROM [tbl_Config] WHERE [tbl_Config].[Variable] = &apos;Val1&apos; -- FAILED&#13;&#10;&#13;&#10;GO&#13;&#10;" Flags="400" Order="0" DataBinding="DATABASE_SIZE_QUERY"/>
    <ATTRIBUTE name="ImpersonateUser" value="true"/>
  </COMPONENT>
</DOCUMENT>
