Page 1 of 1
SET fields
Posted: Mon 08 Sep 2014 09:05
by cyrilo
I know about Delphi restrictions with SET fields
How can I better replace SET fields in DB? To transform one SET field into few BOOLEAN fields?
Re: SET fields
Posted: Mon 08 Sep 2014 13:47
by ViktorV
Please describe the problem in more details.
Re: SET fields
Posted: Tue 09 Sep 2014 09:35
by cyrilo
I have SET field:
Code: Select all
CREATE TABLE set_test(myset SET('red','blue','green'));
The problem solution is replacing one SET field to few BOOLEAN fields
Code: Select all
CREATE TABLE set_test(red BOOLEAN, blue BOOLEAN, green BOOLEAN);
Is it best way to workaround?
Re: SET fields
Posted: Thu 11 Sep 2014 09:09
by ViktorV
We don't say that we don't recommend to use SET fields anywhere.
We say that Delphi does not support the SET field type, and this type is mapped to TStringField, and you can work with SET fields as with strings.
There are various solutions - all depends on your project, architecture, aims and requirements.