Em Qui, 2005-11-10 às 14:39 -0600, Matt Henley escreveu:
> Luiz,
>
> Thanks for the quick response. I have installed it and it seems to be
> okay. I tried to open a database file generated with SQLite Database
> Browser (I think.. it may be SQLiteSpy.. I put them into the same
> directory..) its called World.db3 and its openable by both of the
> above programs. When i try to make the database active in lazarus, I
> get the following error:
>
> Field Type "TEXT" not recognised. Does this mean that it calls
> character data something else?
Sqlite is typeless: ignores the type of the field (you can add any name
to a field or none).
In the recent versions of TSqliteDataset, if a field type is not one of
the used internally (VARCHAR-> String, INTEGER -> Integer, etc ) it will
not be loaded (your case). Before it was loaded as a String field. It
was done to avoid inconsistencies/ambiquosity. For example, if you have
a table with type NUM and you load in fpc/TSqliteDataset, you'd expect
to be treated as a Integer or Float field. Other example: you have a
field TEXT and expect to be treated as a Memo field.
I'm finishing an app that converts a table created elsewhere to use the
syntax used by TSqliteDataset. I'll post when it's done.
The other solution, if you are creating table outside the class (using
CreateTable function), is to name a field using the names recognised by
TSqliteDataset: VARCHAR->StringField, the others are straight forward
(MEMO ->MemoField, AUTOINC->AutoIncField etc)
FYI: The tables created with the fpc class can be manipulated by other
programs without problems. Only ensure that you dont insert incompatible
data,e.g. Characters in Integer fields.
Luiz
_________________________________________________________________
To unsubscribe: mail [EMAIL PROTECTED] with
"unsubscribe" as the Subject
archives at http://www.lazarus.freepascal.org/mailarchives
