Re: [sqlite] Opening SQLite database file on Mac OS X AppleShare volume

"-DSQLITE_ENABLE_LOCKING_STYLE=1" I personally found that this is not as simple as just turning on this compiler flag. When I turned on this flag (set it to 1) I could then not get the latest version of SQLite to compile, and my queries here as to why it wouldn't compile went unanswered. On Tue,

Re: [sqlite] Virtual table sample code

In sqlite source code. src/test_schema.c On Tue, Jun 24, 2008 at 4:57 PM, <[EMAIL PROTECTED]> wrote: > Is there any example source code available that demonstrates a working > virtual table implementation? > > Thanks > Dan Winslow, GamePlan > 402-991-5875 x219 > [EMAIL PROTECTED] > > Third Nerd

Re: [sqlite] Accessing to database informations

thanks ! that was exactly what I was searching ! Dennis Cote wrote: > > > You can get the names of tables and indexes by querying the > sqlite_master table. > >select * from sqlite_master where type = 'table'; > > You can get detailed information about the columns in a table using the

Re: [sqlite] Accessing to database informations

dan.winslow wrote: > > Column names and types can be found with the following calls : > > sqlite3_column_name(ppStmt,x); > sqlite3_column_decltype(ppStmt,x); > sqlite3_column_type(ppStmt,x); > > Where ppStmt is the structure you get back from the prepare/step > functions.

Re: [sqlite] Accessing to database informations

c.panel wrote: > > I'm a new user of SQLite, (and SQL too). I'm trying to find how can I access > to tables names, column names and types, from a database, using C API. I > found this from a result set but what about resident tables ?. Perhaps must > I use a SELECT statement for this ? But If I

Re: [sqlite] Accessing to database informations

My apologies for the bad editing, fixed copy below : Column names and types can be found with the following calls : sqlite3_column_name(ppStmt,x); sqlite3_column_decltype(ppStmt,x); sqlite3_column_type(ppStmt,x); Where ppStmt is the structure you get back from the

Re: [sqlite] Accessing to database informations

Column names and types can be found with the following calls : sqlite3_column_name(ppStmt,x); sqlite3_column_decltype(ppStmt,x); sqlite3_column_type(ppStmt,x); Where ppStmt is the structure you get back from the prepare/step functions. Listing the tble names I am not sure

[sqlite] Virtual table sample code

Is there any example source code available that demonstrates a working virtual table implementation? Thanks Dan Winslow, GamePlan 402-991-5875 x219 [EMAIL PROTECTED] Third Nerd from the left,Technology Defenestration Office ___ sqlite-users mailing

[sqlite] Accessing to database informations

Hello, I'm a new user of SQLite, (and SQL too). I'm trying to find how can I access to tables names, column names and types, from a database, using C API. I found this from a result set but what about resident tables ?. Perhaps must I use a SELECT statement for this ? But If I do, does SQLLite

Re: [sqlite] Fatal error: Call to undefined function sqlite_open()

- "Philipp Morath" <[EMAIL PROTECTED]> wrote: > Thanks you Gopal. > Nothing about sqlite in my error.log. Hum? > How do I get the required library? Hi Philipp: Is it a stock version of PHP (installed from package), or is it compiled from source? If its the former, what does the following

[sqlite] Using SQLite in embedded environment

Hi, I am considering to use SQLite in my current embedded application project. It's a ARM9/Linux. Do you experts think it is a good idea？ And, is there any tips or considerations in this combination? Thank you. ___ sqlite-users mailing list

Re: [sqlite] Erratum

On Jun 24, 2008, at 1:55 PM, Richard Klein wrote: > On the page describing the various sqlite3_bind_xxx_yyy() functions: > > http://www.sqlite.org/c3ref/bind_blob.html > > 3rd paragraph: > > "The index for named parameters can be looked up using the > sqlite3_bind_parameter_name() API if

Re: [sqlite] Ambigous column

Simon Davies schrieb: > Christophe, > > iso is a column in the subquery and in countries. > > so: > > select distinct * from (select * from Cities where name like > 'dusseldorf%' union select * from Staedte where name like > 'düsseldorf%') as sub, countries where sub.iso=countries.iso; > Yes,

Re: [sqlite] Ambigous column

Christophe, iso is a column in the subquery and in countries. so: select distinct * from (select * from Cities where name like 'dusseldorf%' union select * from Staedte where name like 'düsseldorf%') as sub, countries where sub.iso=countries.iso; Regards, Simon 2008/6/24 Christophe Leske

[sqlite] Ambigous column

I think that the column "ISO" is pretty clear here? select distinct * from (select * from Cities where name like 'düsseldorf %' union select * from Staedte where name like 'düsseldorf%'),Countries where ISO=countries.iso order by class; SQL error: ambiguous column name: ISO I mean the ISO from

[sqlite] Erratum

On the page describing the various sqlite3_bind_xxx_yyy() functions: http://www.sqlite.org/c3ref/bind_blob.html 3rd paragraph: "The index for named parameters can be looked up using the sqlite3_bind_parameter_name() API if desired." should be: "... sqlite3_bind_parameter_index() ..."

Re: [sqlite] Fatal error: Call to undefined function sqlite_open()

Thanks you Gopal. Nothing about sqlite in my error.log. Hum? How do I get the required library? On Tue, Jun 24, 2008 at 4:32 AM, Gopal Venkatesan <[EMAIL PROTECTED]> wrote: > - "Philipp Morath" <[EMAIL PROTECTED]> wrote: > >> Hello all, >> >> I made a terrible mistake. I change my running