Strange behaviour with boolean fields

yapt · Post by **yapt** » 07.03.2009, 16:58

Hello,

I have a table:

CREATE TABLE [DbLibros] (
[NLibro] INTEGER  UNIQUE NOT NULL,
[SLibro] VARCHAR(80)  NOT NULL,
[SClave] VARCHAR(80)  NULL,
[SNombre] VARCHAR(50)  NULL,
[NTiempoSaltos] INTEGER DEFAULT '''''''0''''''' NULL,
[BDefecto] BOOLEAN  NULL
)

The strange behaviour below is the same with SqlAdministrator and with my app running standalone or inside Delphi IDE.

When I try to edit/post table updating BDefecto field (boolean) all seems ok, but when I restart SqlAdministrator or my delphi app (or refresh data), then all my changes on this boolean field seems to return to the original values. The first row (BDefecto field) is checked and the other rows are not.

Sometimes I got some rows (BDefecto field) with the value I want but the first row is always checked.

I am a bit lost and cannot continue.

Are there any thing to be aware with boolean fields ?

Greetings.