Kill Table
Kalipso - Form - Actions - Actions Description - Group Database - Kill Table
Deletes one or more records from the specified Database Table, allowing you to choose between Synchronized or Not Synchronized records.
Action available for the following operating systems:
Parameters
Marked as
All - Where will be applied to all of the records of the Table.
Synchronized - Where will be applied only to the records who are already synchronized with the server.
Not Synchronized - Where will be applied only to the records who haven't been synchronized with the server.
Table - Offline Database Table.
Where <Kalipso Filter> or <string> - Condition to specify which records should be deleted. Check Expressions chapter for more information about Kalipso Filter and String expressions.
Usage
Consider the following database table:
Products | |||
Code | Name | Stock | Status |
1 | Coca Cola | 100 | Synchronized |
2 | Pepsi Cola | 200 | Not Synchronized |
3 | Pork Chops | 300 | Not Synchronized |
Example 1
Marked as | All |
Table | Products |
Where | FIELD(Products,Name) LIKE "%Cola" |
Result:
Code | Name | Stock |
3 | Pork Chops | 300 |
Example 2
Marked as | Synchronized |
Table | Products |
Where | FIELD(Products,Name) LIKE "%Cola" |
Result:
Code | Name | Stock |
2 | Pepsi Cola | 200 |
3 | Pork Chops | 300 |
This function only works with offline database tables.
When you specify more than one condition in Where parameter, the operator used between the conditions is "AND" or "OR".
Last updated