Thank you for your answer.
I found a solution for my problem: setting TypeLess property to true.
Also, I think I found the reason of my problem. My original database was in MsAcces, and I converted it to sqLite using sqlite3Browser of Mike Cariotoglou.
Some columns which are of integer type, contain nulls after conversion. That might be the main problem. I'll try to contact Mike for this situation. I'm sure he can find a solution.
See you,
Ahmet Aksoy
Bert Verhees wrote:
Op zondag 9 januari 2005 01:29, schreef Ahmet Aksoy:
Hi,
I'm trying to open a query using Aducom components, but I get an error
message saying:
'' is not a valid integer value.
I can open and use the database with sqlite3.exe. Also
Sqlite3Explorer.exe can open the database and all the tables inside it.
So, there are no problems in the database.
Have you encountered such a situation?
What can I do?
Ahmet Aksoy
I use the Aducom components a lot, I remember there are two ways to solve this problem, one is, give a default value to a integer field, so there always is in integer in it, the other way is surrounding that specified action in a exception clause
