ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Help / WLanguage / WLanguage functions / Controls, pages and windows / Looper functions
  • Use conditions
  • Deletion in a Looper control based on a data file
  • Referential integrity and Looper control based on a data file
  • Deletion in a Looper control based on a data file and Trigger
  • Handling errors
  • Locking the linked data file
WINDEV
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadIOS WidgetApple WatchMac CatalystUniversal Windows 10 App
Others
Stored procedures
<Looper>.DeleteSelect (Function)
In french: <Zone répétée>.SupprimeSelect
Deletes the selected rows from a Looper control.
Example
// Deletes all selected rows
IF YesNo("Do you really want to delete the selected customers?") THEN
LOOP_Display_Customer.DeleteSelect()
END
Syntax
<Looper control>.DeleteSelect()
<Looper control>: Control name
Name of the Looper control to be used.
Remarks

Use conditions

<Looper>.DeleteSelect can be used on:
  • a Looper control based on a data file,
  • a Looper control populated programmatically.

Deletion in a Looper control based on a data file

<Looper>.DeleteSelect deletes the corresponding records from the data file associated with the control. If items are linked to other data files, no modification is automatically performed on these linked data files.

Referential integrity and Looper control based on a data file

If the management of referential integrity is enabled (<Connection variable>.SetIntegrity), HErrorIntegrity must be called after <Looper>.DeleteSelect to check the integrity. If an integrity error is detected, the row is not deleted and it remains visible in the control.

Deletion in a Looper control based on a data file and Trigger

A trigger can be activated when deleting a record from a Looper control based on a data file. For more details, see the documentation about <Source>.DescribeTrigger.

Handling errors

The ErrorOccurred variable is set to True if the deletion fails. To get the details of the error, use ErrorInfo.

Locking the linked data file

If the data file is locked in the current process, <Looper>.DeleteSelect deletes the specified row and unlocks the data file.
Component: wd290obj.dll
Minimum version required
  • Version 23
This page is also available for…
Comments
Click [Add] to post a comment

Last update: 06/22/2023

Send a report | Local help