Re: [sqlite] Error in Aducom components

[Ahmet Aksoy]

Hi Bert,
Maybe converting null values to zero in integer columns will solve the 
problem.
I will check it as soon as possible.
Also, I will try to send a more detailed question about the subject to 
the Aducom forum.
Thanks.
Ahmet Aksoy

Bert Verhees wrote:
Op zondag 9 januari 2005 11:46, schreef Ahmet Aksoy:
 

Hi Bert,
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
   

The disadvantage of working typeless in Aducom is that you do not use the 
typechecking in Aducom. Using internal typechecking can be used in a 
application, f.e. you can let your code react on the value of data, a stupid 
example:

var
        housenumber : string;
begin
        try
                //field housenumber is integer field, and maybe sometimes NULL
                housenumber := fieldbyname('housenumber').tostring;
        except
                housenumber := 'not specified';
        end;
end;
In this case maybe you would get an exception because the field(handling code) 
"housenumber" is asked to convert an integer to a string, and if it is not 
possible, then it is probably NULL. You would, in this case use, the internal 
type-checking of Aducom, to change your program-flow

There is a forum on the Aducom website where you can Aducom specific 
questions. F.e. a good question in this case would be, how to handle 
NULL-values in Integer-fileds with Typeless=false;
It would be very handy if you would do that, because, I did not find that 
question, and the forum would become more valuable.

Bert
 

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