Re: [sqlite] Re: Re: Re: How do I know what DBs I have attached?

Sorry, not all connections. Just attached dbs. I am still new and learning about dbs, so... - Original Message - From: "Igor Tandetnik" <[EMAIL PROTECTED]> To: "SQLite" Sent: Sunday, March 11, 2007 12:35 AM Subject: [sqlite] Re: Re: Re: How do I know

Re: [sqlite] Re: How do I know what DBs I have attached?

Wow! Tough guy. :-o - Original Message - From: "John Stanton" <[EMAIL PROTECTED]> To: Sent: Sunday, March 11, 2007 1:00 PM Subject: Re: [sqlite] Re: How do I know what DBs I have attached? Sqlite is a library used to realize an embedded RDBMS. Nowhere

Re: [sqlite] Re: Meta Information: How to retrieve the column names of a table ?

Igor Tandetnik schrieb: Marten Feldtmann wrote: How can I get all the names of a table without doing a query against the table ? PRAGMA table_info(table-name); Thats it ! Thanks ! What's sqlite3_column_meta_data? It doesn't seem to be mentioned in

Re: [sqlite] sin and similar functions

Hi Dear Friens I have found this advice in mailing list history: I think you can compile the functions into a loadable library (follow the instructions on creating a sqlite loadable extension), and then load them in the console app. In linux: gcc myLoadableLibs.c -shared -o myLoadableLibs.so

Re: [sqlite] Re: How do I know what DBs I have attached?

Sqlite is a library used to realize an embedded RDBMS. Nowhere does it claim to be a nanny. jose isaias cabrera wrote: "Igor Tandetnik" wrote, jose isaias cabrera <[EMAIL PROTECTED]> wrote: What I would like to know is, how do I know if I have a db attached already? Realize that a set

Re: [sqlite] Compiling the linux package on windows using LCC ?

There is a source distribution which has been configured for Windows on the Sqlite website. Try starting with that. If you use the regular source distribution you need to have an environment where you can run the configure shell script to customize the distribution to your OS. Gussimulator

[sqlite] Re: Meta Information: How to retrieve the column names of a table ?

Marten Feldtmann wrote: How can I get all the names of a table without doing a query against the table ? PRAGMA table_info(table-name); I need all the names of columns within tables/views, the column index within the raw table. What's "column index" and "raw

Re: [sqlite] import operation - primary key need to be automatically generated by SQLite (not from csv file)

Martin Jenkins wrote: RohitPatel wrote: /* SQLite 3.3.8 (Windows) used */ /* table t1 */ /* only two columns are given because other columns are irrelevant here */ create table t1 (id INTEGER PRIMARY KEY, name TEXT); /* few sample records from csv file data.csv */ 1,'name_text_1'

[sqlite] Meta Information: How to retrieve the column names of a table ?

How can I get all the names of a table without doing a query against the table ? I need all the names of columns within tables/views, the column index within the raw table. With that information I may use sqlite3_column_meta_data to get additional information about the coumns ... Marten

RE: [sqlite] Re: What is wrong with this UPDATE?

Yes, thanks, that works indeed. RBS -Original Message- From: Igor Tandetnik [mailto:[EMAIL PROTECTED] Sent: 11 March 2007 02:55 To: SQLite Subject: [sqlite] Re: What is wrong with this UPDATE? RB Smissaert <[EMAIL PROTECTED]> wrote: > UPDATE > A3SQLADC_J > SET > ADDED_DATE = '' WHERE