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".