Subject Re: [firebird-support] Re: Update Table
Author Milan Babuskov
Martijn Tonies wrote:
>>record_id <- pk of original table with 600 fields
>>name <- name of checkbox
>>value <- is it checked or not?
>>
>>The table would have 600 rows per single row in original table.
>
>
> No, actually, the table could ONLY have rows for the "checked"
> items.
>
> If there's no row, it's unchecked.

Not a bad idea. Then, the field "value" wouldn't be needed at all.

OTOH, he could make the list dynamic, so users can add their own
checkboxes if they need to.

--
Milan Babuskov
http://fbexport.sourceforge.net
http://www.flamerobin.org