Page 1 has list of groups. When selecting a specific group, it opens up modal page to show group members in Page 2 (page item P2_GROUP which contains group name), where I have IG based on sql query that has rowid (no PK in table) and contains cStatus field, where the values are A(ctive) or I(nactive). Row selector can select all records when checked.
In IG Attributes, Edit is not enabled.
Button "Toggle Status" correctly toggles status, using update statement.
Button "Delete Inactive Members" (DELETE_MEMBERs), when clicked, should execute process "Delete Inactive Members", which has server-side condition "When Button Pressed"=DELETE_MEMBERS, Execution Scope: For created and modified rows. PL/SQL code:
Delete from Table1
where cStatus='I'
and cGroup=:P2_GROUP
In my group, there are 2 members. One has cStatus=I. I select all rows, click on "Delete Inactive Members". 1 of the records is Nothing happens.
I then enable Edit, and uncheck "Add Row" and "Update Row", but leave "Delete Row" Checked. Allowed Row Operations Column=Rowid. It didn't make a difference if Allowed Row Operations Column was not set.
I get error message:
Interactive Grid 'Edit List Members - IG' doesn't have a primary key column defined which is required for editing or in a master detail relationship.
What should be done in order to delete records using a delete statement?
VFP George
Just a thought. Are you submitting the page item that your SQL depends on?
George ...