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
--
Met vriendelijke groet
Bert Verhees
ROSA Software
