New to SQLite and wondering what the correct syntax is to create a table.
I have seen this syntax and that is what I use now and it works fine:
create table ReadCode
(SUBJECT_TYPE varchar(5)
READ_CODE varchar(5)
TERM30 varchar(30)
TERM60 varchar(60));
But it looks now that one doesn't have to specify the field size as SQLite
will automatically adjust to the data size.
So can I leave the (5) etc. off? I am coding in VB.
Also, how would I translate these data types of Interbase to SQLite data
types:
BLOB
DATE
DOUBLE
LONG
SHORT
TEXT
VARYING
I take it that it will be like this:
BLOB > BLOB
DATE > TEXT
DOUBLE > REAL
LONG > INTEGER
SHORT > REAL
TEXT > TEXT
VARYING > TEXT
RBS
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
