On 21 May 2012 08:01, François Delpierre <[email protected]>wrote:
> I must ensure there is always at least one row in a table. (My application
> parameter table)
> How can I prohibit delete of the last row of a table ?
> As it looks the ondelete is executed AFTER deletion...
>
Not tested but what about something like (pseudocode):
if count(query) > 1:
deleteable = True
else:
deletable = False
grid = SQLGRID(query, deletable = deletable)
Regards
Johann
--
Because experiencing your loyal love is better than life itself,
my lips will praise you. (Psalm 63:3)