PC SOFT

ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Home | Sign in | English EN
  • 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
LooperDeleteSelect (Function)
In french: ZoneRépétéeSupprimeSelect
Deletes the selected rows from a Looper control.
New in version 28
Android This function is now available for Android applications.
Java This function is now available for Java applications.
Example
// Deletes all selected rows
IF YesNo("Do you really want to delete the selected customers?") THEN
LooperDeleteSelect(LOOP_Customer_Display)
END
Syntax
LooperDeleteSelect(<Looper control>)
<Looper control>: Control name
Name of the Looper control to be used.
If this parameter is equal to an empty string (""), the deletion will be performed in the current Looper control.
Remarks

Use conditions

LooperDeleteSelect 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

LooperDeleteSelect 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 (HSetIntegrity), HErrorIntegrity must be called after LooperDeleteSelect 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 HDescribeTrigger.

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, LooperDeleteSelect deletes the specified row and unlocks the data file.
Business / UI classification: UI Code
Component: wd280obj.dll
Minimum version required
  • Version 23
This page is also available for…
Comments
Click [Add] to post a comment