Re: [sqlite] Mixing SQlite DLL versions

On Wed, Feb 18, 2009 at 05:33:50PM -0500, Igor Tandetnik scratched on the wall: > jose isaias cabrera > wrote: > > Greetings and salutations. > > > > Can one SQLite db be UPDATEd and used by folks using different DLL > > versions? > > All 3.* versions use the same file

Re: [sqlite] Database path in widows

Jibin Scaria wrote: > I am facing problem with spaces in the database path, able to open database > but queries are returning "no such table: table name". > > > If your table names contain embedded spaces you must quote the name in your SQL queries select * from "table name"; HTH Dennis

[sqlite] Locking design

Hi there, I've been thinking about locking a lot lately and I'm having some trouble... I'd like to show my 'locking design' based on what I know of sqlite3 to see if I understand every possible aspects of locking. For the following, let's use a single database file, shared through the network

Re: [sqlite] Mixing SQlite DLL versions

jose isaias cabrera wrote: > Greetings and salutations. > > Can one SQLite db be UPDATEd and used by folks using different DLL > versions? All 3.* versions use the same file format, and can happily coexist. Igor Tandetnik

[sqlite] Mixing SQlite DLL versions

Greetings and salutations. Can one SQLite db be UPDATEd and used by folks using different DLL versions? Long story, but here is the short story... Our department here uses a tool that I created for PM'ing. The D SQLite wrapper that the program uses works fine with v3.6.11. The program is

[sqlite] How do I avoid getting “ database is locked ” when using sqlite3 via PDO?

when using sqlite, it waits 0 seconds when another transaction is active. anyone have a sample code to avoid to get "database is locked" when PHP + PDO + sqlite3? The expected database function is this: (1)transaction A is active. (2)transaction B attempts to get lock (3)but A is active, so

[sqlite] test1

test1 -- Power up the Internet with Yahoo! Toolbar. http://pr.mail.yahoo.co.jp/toolbar/ ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] number of columns in a table

Hi, see http://www.sqlite.org/capi3ref.html#sqlite3_column_count. Do this: sqlite3_stmt *pStmnt; sqlite3_prepare(YourDbHandle, "select * from YourTable limit 1", -1, , 0); int NumberOfColumns = sqlite3_column_count(pStmnt); sqlite3_finalize(pStmnt) Martin baxy77bax wrote: > hi, > > my

Re: [sqlite] number of columns in a table

hi, my question is how to get the number of columns in an existing table. example if i can retrieve the number of rows with SELECT count(*) FROM table , is there also some simple query to do the same thing for counting the number of columns == Hello, "r" You can use sql to query

[sqlite] number of columns in a table

hi, my question is how to get the number of columns in an existing table. example if i can retrieve the number of rows with SELECT count(*) FROM table , is there also some simple query to do the same thing for counting the number of columns thnx r -- View this message in context:

Re: [sqlite] SQLite version 3.6.11

On Feb 18, 2009, at 5:04 AM, Marco Bambini wrote: > What about backup of encrypted databases? The backup API works with SEE-encrypted databases and with CEROD databases. D. Richard Hipp d...@hwaci.com ___ sqlite-users mailing list

[sqlite] MacOSX version 3.6.11 vs 3.6.6.2

Hi, Waooo I observed my db running from 11 min to 5 min that's really great, many thanks, Cheers, Sylvain ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLite.Exception: not authorized (to load a shared librarywith SQLite Java Wrapper/JDBC Driver)

Bejay Bamboo wrote: > > Hello, > i'm trying to load new SQL functions from a shared library with the > help of the SQLite Java > Wrapper/JDBC Driver (http://www.ch-werner.de/javasqlite). I'm trying > > java -cp :. -Djava.library.path=/tmp/javasqlite-20090213/.libs > SQLite.Shell db "select >

[sqlite] multi-threading multi-db problem

Hello! I use the latest (3.6.11) version of the SQLite dll in a WinXP Application. The main task of this application is to store values from a sensor-hardware in multiple databases. Each DB contains a subset from the Values. I tested serveral design options. One is to read all values from the

Re: [sqlite] AUTOINCREMENT documentation.

> > Not exactly, > in monotonically increasing sequence next element is always smaller than > current. > I mean larger :-) Sorry, KoD ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] AUTOINCREMENT documentation.

Troeger, Thomas (ext) wrote: > Hello, > > Sorry if this has been asked before, I couldn't find any reference to it > in the list archives. I've found a small bug in the documentation, I > wanted to mention it since I think it should be changed accordingly. > > In

[sqlite] SQLite.Exception: not authorized (to load a shared library with SQLite Java Wrapper/JDBC Driver)

Hello, i'm trying to load new SQL functions from a shared library with the help of the SQLite Java Wrapper/JDBC Driver (http://www.ch-werner.de/javasqlite). I'm trying java -cp :. -Djava.library.path=/tmp/javasqlite-20090213/.libs SQLite.Shell db "select

[sqlite] AUTOINCREMENT documentation.

Hello, Sorry if this has been asked before, I couldn't find any reference to it in the list archives. I've found a small bug in the documentation, I wanted to mention it since I think it should be changed accordingly. In http://www.sqlite.org/autoinc.html the documentation says: """ The normal

Re: [sqlite] SQLite version 3.6.11

What about backup of encrypted databases? -- Marco Bambini http://www.sqlabs.com http://www.creolabs.com/payshield/ On Feb 18, 2009, at 1:28 AM, D. Richard Hipp wrote: > SQLite version 3.6.11 is now available from the SQLite website: > > http://www.sqlite.org/ > > Version 3.6.11 adds

Re: [sqlite] Little SQL help please..

Ok, thats good to know! thx Igor! Dan Kennedy-4 wrote: > > > On Feb 18, 2009, at 1:27 AM, johnny depp (really!) wrote: > >> >> I didn't run it yet, the idea of using min(col1) = max(col1) was all I >> needed. >> I assumed it was incorrect because I thought >> referring to an ungrouped

[sqlite] Ann: APSW 3.6.11-r1 released

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 APSW 3.6.11-r1 is now available. The home page is at http://code.google.com/p/apsw/ which includes full documentation, source and binary distributions for Windows (Python 2.3 onwards including 3.0). APSW is a wrapper around SQLite that provides all