boolean fields

[avert]

Hi--

I'm new to Oracle but know the BDE / Paradox.

I've got a pile of boolean fields in my paradox / BDE / Delphi app.

They are all connected at design time to piles of tCheckBox, etc.

How can I change this to run with DOA / Oracle?

Thank you very much
Kelly

 

[Marco Kalter]

Oracle does not have a Boolean SQL datatype (it is a PL/SQL datatype though). In Oracle you can use a varchar2(1) not null, use 'T' for True and 'F' for False, and apply a check contraint that enforces these 2 values.

The TStringField class has an AsBoolean property that corresponds to these 2 possible values, and you can use a TDBCheckBox as well.

------------------
Marco Kalter
Allround Automations

 

[avert]

Thanks!

Kelly