Contents
Display Legacy Contents

 Print
    Kill Table  
Deletes one or more records from the specified Database Table, allowing you to choose between Synchronized or Not Synchronized records.

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.

     
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

Example 2
Marked as All
Table Products
 
Where FIELD(Products,Name) LIKE "%Cola"

Result:

Code Name Stock
3 Pork Chops 300

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

See also
Samples

 
 
Updated: 3/21/2018 5:46 PM