BOOLEAN Values

[Aggie85]

Howdy!

I have a dataset with a BOOLEAN field called Enabled. There are 5 records in the table with Enabled = True

If I query the table with:

SELECT <Fields>
FROM <Table>
WHERE Enabled = 1

It returns 0 records.

If I query the table with:

SELECT <Fields>
FROM <Table>
WHERE Enabled = '1'

all 5 Enabled records are returned.

I read that SQLLITE stores BOOLEANS as an integer with values of 0/1. Why doesn't the first WHERE clause work?

How does VirtualQuery/SQLLITE combo map BOOLEAN fields?

Thanks,

Aggie85

[MaximG]

Thank you for the information. We investigated the described behavior using the data contained in the sent TestData.vtd file. Unfortunately, we didn't manage to reproduce the problem in our test environment. Please compose and send us via the e-support form ( https://www.devart.com the "Support"\"Request Support" menu) a small complete sample in which the problem occurs.

[Aggie85]

Good day Maxim,

The problem occurs on a Source DataSet that is of a TkbmMemTable. I will have to try it with a TVirtualTable and see if it works both ways.

Unfortunately, I use TkbmMemTable and I can't change that in my product.

Thanks,

Aggie85

[MaximG]

Unfortunately, we could not reproduce the described problem when using TkbmMemTable in our environment. For further investigation, please compose a small complete sample, during execution of which the problem occurs. This project should include TkbmMemTable usage. You can send this sample using the e-support form(https://www.devart.com - the "Support"\"Request Support" menu)

[Aggie85]

I will put together a C++ example showing the problem and upload it to y'all.

All the best,

Aggie85

[MaximG]

We will be waiting for your sample to continue the investigation