Delete last row on editable grid

[lewis200]

I have a master form and a detail editable grid.
I can delete any record using the Delete button on the row.
But when there is only one row displaying on the grid, deleting it does nothing, except hang the app.

Is there an SQL parameter somewhere I need to change. I tried turning off the delete button off using the sc_btn_display macro and the disabled macro. But it doesn’t seem to help.

Lewis

[gbillot3]

@lewis200

I have a master form and a detail editable grid.
I can delete any record using the Delete button on the row.
But when there is only one row displaying on the grid, deleting it does nothing, except hang the app.

Is there an SQL parameter somewhere I need to change. I tried turning off the delete button off using the sc_btn_display macro and the disabled macro. But it doesn’t seem to help.

Hi Lewis,
Are you using primary key or a unique index on the detail table?

[lewis200]

I am using the delete button on the tool bar. I don’t know which key is being used.

What is best method?