David Swigger wrote:
Anyone know a more direct way?
You could also try using pragma table_info(tablename).
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Hello all,
Lets say I have created a table like this:
CREATE TABLE mytable(
id INTEGER PRIMARY KEY
first text,
second text,
third text)
How do I go about retrieving the specifics on that table
at a later date?
I know I can do:
PRAGMA empty_result_callbacks=ON
PRAGMA show_datatypes = ON
Th
Note: forwarded message attached.
--- Begin Message ---
--- Tim Anderson <[EMAIL PROTECTED]> wrote:
> It's worth noting that Sqlite is not the equivalent
> of Microsoft Access.
> If anything, Sqlite is the equivalent of JET, the
> Access database
> engine. In order to offer a meaningful alternati
SQLite will store anything UTF-8 or ANSI as long as its null terminated
and escaped for '. The only place where encoding makes a difference is
in functions like length.
Will
Steven Van Ingelgem wrote:
If I have a table like:
CREATE TABLE routing (
FIELD1 VARCHAR(40)
);
what if I get a stri
> -Original Message-
> From: Pierre-Yves Delens [mailto:[EMAIL PROTECTED]
> Sent: 12 January 2004 08:15
> To: 'Jonas Forsman / Axier.SE'
> Cc: [EMAIL PROTECTED]
> Subject: [sqlite] RE: SQLite in OpenOffice?
>
> With SqLite Odbc Driver : OK
It's worth noting that Sqlite is not the equival
With SqLite Odbc Driver : OK
___
P-Y Delens, Manager
LIENTERFACES - PY Delens, sprl
Avenue Dolez, 243 - 1180 Bruxelles
phone : 32 2 375 55 62
fax : 32 2 374 75 74
mail : [EMAIL PROTECTED]
web : www.lienterfaces.be
__
6 matches
Mail list logo