SET fields

[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?

[ViktorV]

Please describe the problem in more details.

[cyrilo]

I have SET field:

Code: Select all

CREATE TABLE set_test(myset SET('red','blue','green'));

Using SET is not recommended with Delphi by DevArt Team
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?

[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.