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".
|
Updated: 3/21/2018 5:46 PM
| 
