<Looper>.DeleteSelect (Function)

ONLINE HELP
WINDEV, WEBDEV AND WINDEV MOBILE

Version:

Home | Sign in | English

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

WEBDEV

WINDEV Mobile

Others

See also

<Looper>.DeleteSelect (Function)

In french: <Zone répétée>.SupprimeSelect

Deletes the selected rows from a Looper control.

Versions 26 and later

This function is now available in browser code.

New in version 26

This function is now available in browser code.

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: wd270obj.dll