Re: Delete prior to an insert as a safeguard

2008-05-30 Thread CFDEV
since an update is not allowed, yes, then for interity, I would do the DEL then INSERT On Fri, May 30, 2008 at 12:50 PM, Cameron Johnson <[EMAIL PROTECTED]> wrote: > Hello. > > I'm looking for some best practice advice with this one. > > In our membership database, we have a table where we assign

Delete prior to an insert as a safeguard

2008-05-30 Thread Cameron Johnson
Hello. I'm looking for some best practice advice with this one. In our membership database, we have a table where we assign membership to a community/group. A user can join or leave these groups on the web (simple checkbox form), or staff can add or remove group membership through the desktop