[sqlite] Question on missing Entry Point for Sqlite 3

Unhandled Exception: System.EntryPointNotFoundException: sqlite3_column_origin_name I am getting this issue on a mono based application that utilizes the sphinx .net 2.0 ado.net adaptor for sqlite. I have installed the latest sqlite on my Ubuntu Linux 8.10 but I get this issue. My guess is

Re: [sqlite] drop table question ?

On 4/02/2009 12:37 AM, Brad Stiles wrote: >>> For my own edification, why the "order by 1" clause? >> To sort them in ascending order of table name, which might make >> old-fashioned capers like visual scrutiny a little easier. > > OK then, why would one not use the column name? Maybe because

Re: [sqlite] Techniques to delay writes to SQLite

On Feb 3, 2009, at 3:12 PM, Brandon, Nicholas (UK) wrote: > I'm open to other techniques particularly if they would be simpler to > implement and manage! Using a queue of DML statements sound very reasonable :) Nanoki [1] uses that technique when indexing text documents with fts3: (1) A

Re: [sqlite] Is opened transaction?

> http://www.sqlite.org/c3ref/get_autocommit.html Thanks, I missed this function for their little tricky name. Would be gread if exist one new function for getting names from savepoint transaction stack too. It would be great for nested transaction debugging. (Just idea.) -- Lukas Gebauer.

Re: [sqlite] left join does not return data if right side table is empty

On Feb 3, 2009, at 12:16 PM, Nathan Biggs wrote: > I have a question about version 3.6.10. > > I downloaded the amalgamation source code and built a static > library. I > have included the static library in my Windows console application. I > have noticed something very strange though. to

Re: [sqlite] Is opened transaction?

On Feb 3, 2009, at 11:37 AM, Alexey Pechnikov wrote: > Hello! > > В сообщении от Tuesday 03 February 2009 16:22:59 D. > Richard Hipp написал(а): >>> How can I detect opened transaction on my database connection from >>> the code? When I start transaction/checkpoint, then I am missing >>>

[sqlite] left join does not return data if right side table is empty

I have a question about version 3.6.10. I downloaded the amalgamation source code and built a static library. I have included the static library in my Windows console application. I have noticed something very strange though. to execute my statement I use the prepare and then step not

Re: [sqlite] Techniques to delay writes to SQLite

While I'm not sure how long your long running select would take, it seems like SQLite (at least version 3) already works the way you are describing. As soon as you issue a select against a database file a shared lock is obtained. On commit that shared lock is released. While you have a shared

Re: [sqlite] Is opened transaction?

Hello! В сообщении от Tuesday 03 February 2009 16:22:59 D. Richard Hipp написал(а): > > How can I detect opened transaction on my database connection from > > the code? When I start transaction/checkpoint, then I am missing some > > API or SQL command like 'IsTransactionOpen'. > >

Re: [sqlite] Resolving some compiler warnings when closing db

Ah, good thinking. The Apple-supplied sqlite3.h in Mac OS X (/usr/include/sqlite3.h) doesn't actually declare it (wtf?) -- although I do have it in /usr/local/include/sqlite3.h), and I'm statically linking against my own build. Which I guess is why it builds just fine. Getting the search paths to

Re: [sqlite] Resolving some compiler warnings when closing db

2009/2/3 Billy Gray : > Hi all, > . . . > #import > ... > - (void) closeDb { >// first loop thru any existing statements and kill'em >sqlite3_stmt *pStmt; >while( (pStmt = sqlite3_next_stmt(db, 0)) != 0 ){ >sqlite3_finalize(pStmt); >} > >int result =

[sqlite] Resolving some compiler warnings when closing db

Hi all, Forgive me if this has been discussed here already, I tried searching for the answer and came up empty. I'm trying to work out a couple of compiler warnings I get when I close my sqlite3 connection as described in the manual. I know I could just silence them, but I'm a bit of a stickler

Re: [sqlite] drop table question ?

On Tue, Feb 3, 2009 at 10:36 AM, Brad Stiles wrote: >>> >> For my own edification, why the "order by 1" clause? >>> > >>> > To sort them in ascending order of table name, which might make >>> > old-fashioned capers like visual scrutiny a little easier. >>> >>> OK then,

Re: [sqlite] drop table question ?

>> >> For my own edification, why the "order by 1" clause? >> > >> > To sort them in ascending order of table name, which might make >> > old-fashioned capers like visual scrutiny a little easier. >> >> OK then, why would one not use the column name? > > It does. No, I meant why not use the

Re: [sqlite] drop table question ?

On Tue, Feb 3, 2009 at 10:28 AM, Jay A. Kreibich wrote: > On Tue, Feb 03, 2009 at 08:37:10AM -0500, Brad Stiles scratched on the wall: >> >> For my own edification, why the "order by 1" clause? >> > >> > To sort them in ascending order of table name, which might make >> >

Re: [sqlite] drop table question ?

On Tue, Feb 03, 2009 at 08:37:10AM -0500, Brad Stiles scratched on the wall: > >> For my own edification, why the "order by 1" clause? > > > > To sort them in ascending order of table name, which might make > > old-fashioned capers like visual scrutiny a little easier. > > OK then, why would one

Re: [sqlite] drop table question ?

Sorry for the redundant reply. It looks like it was already answered. RW Ron Wilson, S/W Systems Engineer III, Tyco Electronics, 434.455.6453 -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Wilson, Ron P Sent: Tuesday,

Re: [sqlite] drop table question ?

You will have to do this with code. select name from sqlite_master where name like 'x%'; that will give you a list of all tables that start with x; you can then delete all tables with names in the result set. RW Ron Wilson, S/W Systems Engineer III, Tyco Electronics, 434.455.6453

[sqlite] Techniques to delay writes to SQLite

I would like some advice on how best to implement delays in writing to a SQLite file (in my case using PHP) to maximise concurrent access. The web application I'm developing mainly issues quick reads and writes on a local SQLite file using PHP 5. This works satisfactorily. However in the future

Re: [sqlite] Column-constraint UNIQUE with ODBC and MS Access

On Tue, Feb 3, 2009 at 2:24 PM, D. Richard Hipp wrote: > > On Feb 3, 2009, at 8:18 AM, Efthimios Toulas wrote: > >> Hi, >> >> I encountered a problem with the UNIQUE column-constraint in my setup. >> Searching the web and the archives I couldn't find any discussion on >> this

Re: [sqlite] drop table question ?

On Tue, Feb 3, 2009 at 8:37 AM, Brad Stiles wrote: >>> For my own edification, why the "order by 1" clause? from the docs... http://www.sqlite.org/lang_select.html Each term of an ORDER BY expression is processed as follows: If the ORDER BY expression is a constant

Re: [sqlite] Warning message in amalgamation

On Feb 1, 2009, at 7:34 AM, Maurí cio wrote: > Hi, > > When building sqlite 3.6.10 amalgamation, I get > a warning message saying: > > attention : ignoring return value of ‘write’, declared with > attribute warn_unused_result > > /* On OS X on an msdos filesystem, the inode number is

Re: [sqlite] drop table question ?

>> For my own edification, why the "order by 1" clause? > > To sort them in ascending order of table name, which might make > old-fashioned capers like visual scrutiny a little easier. OK then, why would one not use the column name? /bs ___

Re: [sqlite] Column-constraint UNIQUE with ODBC and MS Access

On Feb 3, 2009, at 8:18 AM, Efthimios Toulas wrote: > Hi, > > I encountered a problem with the UNIQUE column-constraint in my setup. > Searching the web and the archives I couldn't find any discussion on > this topic. > > When trying to access the SQLite database via ODBC from MS Access >

Re: [sqlite] Is opened transaction?

On Feb 3, 2009, at 8:14 AM, Lukas Gebauer wrote: > > Hello! > > How can I detect opened transaction on my database connection from > the code? When I start transaction/checkpoint, then I am missing some > API or SQL command like 'IsTransactionOpen'. > >

[sqlite] Column-constraint UNIQUE with ODBC and MS Access

Hi, I encountered a problem with the UNIQUE column-constraint in my setup. Searching the web and the archives I couldn't find any discussion on this topic. When trying to access the SQLite database via ODBC from MS Access (linked tables) everything works fine except for the tables containing a

[sqlite] Is opened transaction?

Hello! How can I detect opened transaction on my database connection from the code? When I start transaction/checkpoint, then I am missing some API or SQL command like 'IsTransactionOpen'. Thank you for your help! -- Lukas Gebauer. E-mail: gebau...@mlp.cz http://synapse.ararat.cz/ -

Re: [sqlite] drop table question ?

> sqlite> select 'drop table ' || name || ';' from sqlite_master where > type = 'table' and name glob 'X[0-9][0-9][0-9][0-9]' order by 1; For my own edification, why the "order by 1" clause? /bs ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] SQLite compile errors with gcc

Thank you! Roger Binns wrote: > > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > xianzhang wrote: >> sqlite/sqlite3.c:18848:3: #error SQLite will not work correctly with the >> -ffast-math option of GCC > [...] >> Any ideas how I can fix this? Thanks! > > Exactly as it says. Don't

Re: [sqlite] Warning message in amalgamation

Roger Binns wrote: > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > Michael Comperchio wrote: > >> in io.h write returns an int - number of bytes written. Declare an int >> and catch the return value. :) >> > > And then the compiler will complain that the variable assigned the value

Re: [sqlite] drop table question ?

On 3/02/2009 8:07 PM, baxy77bax wrote: > hi > > simple question : How to drop all tables in my database that start , for > example, with X? > > table 1 is X1998 > table 2 is X8676 > table 3 is X2912 > ... > Catch the output of this: sqlite> select 'drop table ' || name || ';' from

Re: [sqlite] drop table question ?

i was thinking the same thing but then it hit me that maybe there is already an existing solution. :) thanx RB Smissaert wrote: > > Run a loop in the code of your application and drop the tables. I don't > think SQLite can do something like this. > > RBS > >> >> hi >> >> simple question :

Re: [sqlite] drop table question ?

Run a loop in the code of your application and drop the tables. I don't think SQLite can do something like this. RBS > > hi > > simple question : How to drop all tables in my database that start , for > example, with X? > > table 1 is X1998 > table 2 is X8676 > table 3 is X2912 > ... > > thanx >

[sqlite] drop table question ?

hi simple question : How to drop all tables in my database that start , for example, with X? table 1 is X1998 table 2 is X8676 table 3 is X2912 ... thanx -- View this message in context: http://www.nabble.com/drop-table-question---tp21806118p21806118.html Sent from the SQLite mailing list