Re: [sqlite] table schmea - easy way?

2004-01-12 Thread Will Leshner
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]

[sqlite] table schmea - easy way?

2004-01-12 Thread David Swigger
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

Fwd: RE: [sqlite] RE: SQLite in OpenOffice?

2004-01-12 Thread Raymond Irving
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

Re: [sqlite] UTF8 question

2004-01-12 Thread William M. Droste
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

RE: [sqlite] RE: SQLite in OpenOffice?

2004-01-12 Thread Tim Anderson
> -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

[sqlite] RE: SQLite in OpenOffice?

2004-01-12 Thread Pierre-Yves Delens
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 __