Also, do the values go into one field, or several fields?
Some database engines have types that allow you to store several values
in a single field, like the MySQL SET type:
http://dev.mysql.com/doc/refman/5.1/en/set.html
Also, is the TCheckList box populated at designtime or at runtime?
It could be possible to have the Items populated from the field
definition (see the bottom of the MySQL SET Type definition in the link
above).
Or you could populate the Items from all the boolean field names in the
table, or from similar/other criteria.
The advantage of this is that you can change the table definition
without having to recode the app (within certain constraints of course).
On 4/14/2011 4:50 PM, Kyle Cordes wrote:
On Thu, Apr 14, 2011 at 3:54 PM, SoftTech<mi...@softtechks.com> wrote:
Greetings,
I need to store the checked values for a TCheckListBox into a database field
and retrieve it.
Anyone have tips on how to do it?
How you store it depends partly on how you want to be able to query
it. For example, you may want to have a table contain a row for each
entry in the checklistbox (with a column indicating checked or not),
rather than stuffing all of the values in to one field.
__________________________________________________
Delphi-Talk mailing list -> Delphi-Talk@elists.org
http://lists.elists.org/cgi-bin/mailman/listinfo/delphi-talk
