MAKEMSI quickly and reliably creates MSI files in a non-programmatic way\Source CodeCommandsTable

---

The "Table" Command

This command sets the default table for some commands and is required by others. The command may be nested if required.

This command takes these parameters:

• Table Name (positional)
  This is the name of a table (see list of standard Windows Installer tables) previously defined using the TableDefinition and related commands. MSI Table and Column names are all case sensitive.

• Create (optional)
  Do you wish to automatically create the table if it does not already exist (pass "N" or "Y")?

  The default for this parameter can be set via the DEFAULT_TABLE_CREATE macro. This is initially "Y".

EXAMPLE

This example shows the definitions for the standard "Binary" and "File" tables:

<$TableDefinition "CustomTable4Testing">
   <$Column "Field1"       TYPE="s72" KEY="Y">
   <$Column "Field2"       TYPE="s72">
   <$Column "Field3"       TYPE="S72">
   <$Column "Field4"       TYPE="S72">
<$/TableDefinition>
<$Table "CustomTable4Testing">
   ;--- Create the table ----------------------------------------------------
   <$TableCreate>

   ;--- Insert some fields --------------------------------------------------
   <$Row Field1="1.1" Field2="1.2" Field3="1.3" Field4="1.4">
   <$Row Field1="2.1" Field2="2.2" Field3="2.3" Field4="2.4">
   <$Row Field1="3.1" Field2="3.2" Field3="3.3" Field4="3.4">
   <$Row Field1="4.1" Field2="4.2" Field3="4.3" Field4="4.4">
   <$Row Field1="5.1" Field2="5.2" Field3="5.3" Field4="5.4">
   <$Row Field1="6.1" Field2="6.2" Field3="6.3" Field4="6.4">
   <$Row Field1="7.1" Field2="7.2" Field3="7.3" Field4="7.4">
   <$Row Field1="8.1" Field2="8.2" Field3="8.3" Field4="8.4">
   <$Row Field1="9.1" Field2="9.2" Field3="9.3" Field4="9.4">
   <$Row Field1="10.1" Field2="9.2">   ;;WORKS as F3 & F4 allow NULLS

   ;--- Update some rows ("WHERE" clause used, expect 2 matches) ------------
   <$Row @Where="Field4='5.4' or Field4='6.4'" @OK="=2" Field2="bbbb" Field3="cccc">
<$/Table>


;--- Delete all rows in the "Error" table -----------------------------------
<$Table "Error">
   <$RowsDeleteAll>
<$/Table>


;--- Change the "Attributes" column on some rows in the "Control" table -----
<$Table "Control">
   ;--- The bit map should be "Fixed" size (make sure "fixed" bit set) ------
   <$Row @Where="`Control` = 'BannerBitmap'" Attributes=^{*} or &H00100000^ @SelfRef=^{*}^ @OK=^? > 0^>
<$/Table>


;--- Remove the "LicenseAgreementDlg" Dialog (from flow of events) ----------
<$Table "ControlEvent">
   ;--- Take care of the "Next" button from the "WelcomeDlg" ----------------
   #(
       <$Row @OK=^? = 1^
           @Where="`Dialog_` = 'WelcomeDlg' and `Control_` = 'Next' and `Event`='NewDialog' and `Argument` = 'LicenseAgreementDlg' and `Condition` = '1'"
           Argument="UserRegistrationDlg"    ;;Skip licence and go straight here!
       >
   #)

   ;--- Take care of the "Back" button from the "UserRegistrationDlg" -------
   #(
       <$Row @OK=^? = 1^
           @Where="`Dialog_` = 'UserRegistrationDlg' and `Control_` = 'Back' and `Event`='NewDialog' and `Argument` = 'LicenseAgreementDlg' and `Condition` = '1'"
           Argument="WelcomeDlg"    ;;Skip licence and go straight here!
       >
   #)
<$/Table>

This shows a stream being added, this could be used to "hide" a userid and password:

<$Table "_Streams" CREATE="N">
   <$Row Name="StreamKey" Data="c:\tmp\SomeFile.CON">
<$/Table>

Please email me any feedback, additional information or corrections. See this page online (look for updates) MAKEMSI© is (C)opyright Dennis Bareis 2003-2008 (All rights reserved). Saturday December 27 2008 at 3:15pm Visit MAKEMSI's Home Page