4D v16.3
DELETE FROM LIST
- 4D Language Reference
-
- Hierarchical Lists
-
- Managing Hierarchical Lists
- APPEND TO LIST
- CLEAR LIST
- Copy list
- Count list items
- DELETE FROM LIST
- Find in list
- GET LIST ITEM
- Get list item font
- GET LIST ITEM ICON
- GET LIST ITEM PARAMETER
- GET LIST ITEM PARAMETER ARRAYS
- GET LIST ITEM PROPERTIES
- GET LIST PROPERTIES
- INSERT IN LIST
- Is a list
- List item parent
- List item position
- LIST OF CHOICE LISTS
- Load list
- New list
- SAVE LIST
- SELECT LIST ITEMS BY POSITION
- SELECT LIST ITEMS BY REFERENCE
- Selected list items
- SET LIST ITEM
- SET LIST ITEM FONT
- SET LIST ITEM ICON
- SET LIST ITEM PARAMETER
- SET LIST ITEM PROPERTIES
- SET LIST PROPERTIES
- SORT LIST
- _o_REDRAW LIST
DELETE FROM LIST
| DELETE FROM LIST ( {* ;} list ; itemRef | * {; *} ) | ||||||||
| Parameter | Type | Description | ||||||
| * | Operator |
|
If specified, list is an object name (string) If omitted, list is a list reference number | |||||
| list | ListRef, String |
|
List reference number (if * omitted), or Name of list type object (if * passed) | |||||
| itemRef | * | Longint, Operator |
|
Item reference number, or 0 for the last item added to the list or * for the currently selected list item | |||||
| * |
|
If specified, erases sublists (if any) from memory If omitted, sublists (if any) are not erased | ||||||
The DELETE FROM LIST command deletes the item designated by the itemRef parameter of the list whose reference number or object name is passed in list.
If you pass the first optional * parameter, you indicate that the list parameter is an object name (string) corresponding to a representation of the list in the form. If you do not pass this parameter, you indicate that the list parameter is a hierarchical list reference (ListRef). If you only use a single representation of the list or work with structural items (the second * is omitted), you can use either syntax. Conversely, if you use several representations of the same list and work with the current item (the second * is passed), the syntax based on the object name is required since each representation can have its own current item.
If you pass * in itemRef, you delete the currently selected item in the list. You can also pass 0 in this parameter in order to request the deletion of the last item added to the list.
Otherwise, you specify the item reference number of the item you want to delete. If there is no item with the item reference number you passed, the command does nothing.
If you work with item reference numbers, build a list in which the items have unique reference numbers, otherwise you will not be able to distinguish the items. For more information, see the description of the APPEND TO LIST command.
No matter which item you delete, you should specify the optional * parameter to let 4D automatically delete the sublist attached to the item, if any. If you do not specify the * parameter, it is a good idea to have previously obtained the list reference number of the sublist (if any) attached to the item, so that you can delete it, if necessary, using the CLEAR LIST command.
The following code deletes the currently selected item of the list hList. If the item has an attached sublist, the sublist (as well as any sub-sublist) is deleted:
DELETE FROM LIST(hList;*;*)
Product: 4D
Theme: Hierarchical Lists
Number:
624
Modified: 4D v11 SQL
4D Language Reference ( 4D v16)
4D Language Reference ( 4D v16.1)
4D Language Reference ( 4D v16.2)
4D Language Reference ( 4D v16.3)
