RowsDelete

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

RowsDelete

The "RowsDelete" Command

This command is used to delete one or more rows. To delete all rows in a table it is easiest to use the "RowsDeleteAll" command.

The command must be used within a "Table" block.

This command takes these parameters:

SQL WHERE clause (optional)
This indicates which rows you wish to delete. You supply an SQL where clause (without the "WHERE" keyword").
If you are unsure how as to how to code this command you can use the "MsiDiff.VBS" command to create them for you! Simply create a backup of your database and delete the rows with "ORCA". It is then a simple matter of using the "Compare -> MAKEMSI Format" shortcut to compare the "before" and "after" databases and generate the appropriate commands for you to paste in.

EXAMPLE

<$Table "SomeTable">
   <$RowsDelete Where=^Field1='10.1'^>
<$/Table>

Please email me any feedback, additional information or corrections.
See this page online (look for updates)