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:
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>