SQLite Field Schema

Databases
1

In Xojo the SQLite Fieldschema returns:

ColumnName
FieldType
IsPrimary
NotNull
Length (Appears to be empty even when I know a value exists)
cid

So, length appears to be a problem. What about the following or do I obtain the through another method:

DefaultValue
AutoIncrement

2

SQLite columns do not have length values.

You might also try doing a SELECT * FROM sqlite_master to get additional details about the DB schema.

3

[quote=81347:@Paul Lefebvre]SQLite columns do not have length values.

You might also try doing a SELECT * FROM sqlite_master to get additional details about the DB schema.[/quote]

Ok, I will try that. Why aren’t DefaultValue and AutoIncrement returned? I have had a look in sqlite_master and they are not in there. The only indication of them is in the create statement for each table which is stored in sqlite_master but I don’t want to be parsing that to find out what should be in the table schema

4

Found it:

PRAGMA table_info(table_name);

5

Yep, that was what I was just typing!