Re: [sqlite] SQLite and MinGWSys

I have downloaded the latest version of SQLite as well as the make file in the ticket #931 However, after typing 'make' I get a message that saying ' No rule to make target 'src/sqlite.h.in', how do I solve this problem? TIA Gerry Snyder wrote: >

Re: [sqlite] Python sqlite binding: commit inside select loop

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Jim Wilcoxson wrote: > I did some checking on the pysqlite mailing list. Apparently the > change to reset all cursors before commit is recent, and the reason is > that pysqlite or sqlite itself would return bogus rows. It is pysqlite returning the

Re: [sqlite] Python sqlite binding: commit inside select loop

I did some checking on the pysqlite mailing list. Apparently the change to reset all cursors before commit is recent, and the reason is that pysqlite or sqlite itself would return bogus rows. There is an example here: http://article.gmane.org/gmane.comp.python.db.pysqlite.user/2217 Returning

Re: [sqlite] Python sqlite binding: commit inside select loop

Thanks for the comments and explanations everyone - much appreciated. It seems there are a few alternatives I can check out. Jim On 6/30/09, Roger Binns wrote: > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > Jim Wilcoxson wrote: >> I guess I am a bit confused. Igor

Re: [sqlite] Remove email ID from this list

On Tue, 30 Jun 2009, Rajesh Nair wrote: > How to remove my mail id from this discussion form. If you are asking how to unsubscribe from the list, look at the bottom of any message posted here and follow the URL to the mail list web site. You can unsubscribe yourself from that page. --

[sqlite] Remove email ID from this list

HI, How to remove my mail id from this discussion form. -- Regards Rajesh Nair ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLite and MinGWSys

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 ArbolOne wrote: > I would like to compile SQLite in a WinXP machine, how can I do this > using MinGW? SQLite compiles just fine with MinGW. If you need a DLL then just whatever is on the SQLite download page. If you need a library then just

Re: [sqlite] SQLite and MinGWSys

ArbolOne wrote: > I would like to compile SQLite in a WinXP machine, how can I do this > using MinGW? > Have you looked at the Notes on Compiling SQLite section of http://www.sqlite.org/cvstrac/wiki ? A lot of info there. HTH, Gerry

[sqlite] SQLite and MinGWSys

I would like to compile SQLite in a WinXP machine, how can I do this using MinGW? TIA -- ArbolOne.org specializes in Custom Web Site Design, Web Site Re Design, Web Site Template Modifications, Web Site Maintenance, Integration of Payment Gateways (API's), Database Applications, Custom

Re: [sqlite] Python sqlite binding: commit inside select loop

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Jim Wilcoxson wrote: > I guess I am a bit confused. Igor says it's not possible, but Roger > says my example works. For the exact code you were running the error message came from pysqlite and not from SQLite. Other posters are not aware of the

Re: [sqlite] Python sqlite binding: commit inside select loop

I guess I am a bit confused. Igor says it's not possible, but Roger says my example works. One other point of confusion is that sometimes an interface layer will grab all or a bunch of the rows after a select, even though it may hand them to upper layers one row at a time. For example, with

Re: [sqlite] Python sqlite binding: commit inside select loop

thank you very much Richard! very interesting to get some info about these rather internal issues. This gives us a good background to review some potential dangerous loops. Your hint with the temp table is extremely useful. Best wishes Marcus Grimm > > On Jun 30, 2009, at 2:34 PM, Marcus Grimm

Re: [sqlite] Python sqlite binding: commit inside select loop

> Marcus Grimm wrote: >> what is possible I guess would be to start a transaction >> inside the loop, do something, and commit and procced >> with stepping > > No, this is not possible either. By starting the select, you also start > an implicit transaction. SQLite

[sqlite] NFS again

Hi, I read on the wen that version 3.3 was planned to offer alternative locking to help with broken NFS implementations. I run sqlite 3.6.10-1ubuntu0.2 and it still hangs on connecting to the db file on NFS. Is this feature already implemented and how do I use it? Thanks, -- Bernd

Re: [sqlite] Python sqlite binding: commit inside select loop

On Jun 30, 2009, at 2:34 PM, Marcus Grimm wrote: > > I'm not sure what will happend if you for example > delete a table row that would be the next row that > sqlite3_step would see, but doing so to me sounds > a bad approach anyhow. The official policy is that if you modify a table (via INSERT,

Re: [sqlite] Python sqlite binding: commit inside select loop

Marcus Grimm wrote: > what is possible I guess would be to start a transaction > inside the loop, do something, and commit and procced > with stepping No, this is not possible either. By starting the select, you also start an implicit transaction. SQLite doesn't support

Re: [sqlite] Python sqlite binding: commit inside select loop

> Marcus Grimm wrote: >> I'm a bit confused about Igors replies because >> you can very well do a select, step throu the >> results and even delete or update the table row that you >> are currently inspecting and procceed with stepping. > > ... but you cannot COMMIT your

Re: [sqlite] Python sqlite binding: commit inside select loop

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Jim Wilcoxson wrote: > With the Python bindings, an error occurs > because a commit resets all pending select statements. Note that there are some constraints about how SQLite works detailed by Igor, but in this particular case you are being stymied

Re: [sqlite] Python sqlite binding: commit inside select loop

Marcus Grimm wrote: > I'm a bit confused about Igors replies because > you can very well do a select, step throu the > results and even delete or update the table row that you > are currently inspecting and procceed with stepping. ... but you cannot COMMIT your changes

Re: [sqlite] Python sqlite binding: commit inside select loop

I'm a bit confused about Igors replies because you can very well do a select, step throu the results and even delete or update the table row that you are currently inspecting and procceed with stepping. As long as you use the same database connection for this. I'm not sure what will happend if

Re: [sqlite] Python sqlite binding: commit inside select loop

Jim Wilcoxson wrote: > I'm using the Python sqlite3 (pysqlite) bindings. I'd like to be able > to do a select, and while fetching those rows and inserting new ones, > periodically do a commit. You can't do this with SQLite. Commit fails if there are outstanding statements. >

[sqlite] Python sqlite binding: commit inside select loop

I'm using the Python sqlite3 (pysqlite) bindings. I'd like to be able to do a select, and while fetching those rows and inserting new ones, periodically do a commit. With the Python bindings, an error occurs because a commit resets all pending select statements. Here is an example showing the

Re: [sqlite] Reading year from YYYY-MM-DD column?

Gilles Ganault wrote: > I read http://www.sqlite.org/lang_datefunc.html, but I still don't > know how to extract the year from a table where a column has dates > formatted as -MM-DD. select strftime('%Y', myDateColumn) from myTable; > Currently, I use this, but I'm sure there's a better way:

Re: [sqlite] Reading year from YYYY-MM-DD column?

On Tue, Jun 30, 2009 at 7:50 AM, Gilles Ganault wrote: > Hello > >        I read http://www.sqlite.org/lang_datefunc.html, but I still don't > know how to extract the year from a table where a column has dates > formatted as -MM-DD. > > Currently, I use this, but I'm

[sqlite] Reading year from YYYY-MM-DD column?

Hello I read http://www.sqlite.org/lang_datefunc.html, but I still don't know how to extract the year from a table where a column has dates formatted as -MM-DD. Currently, I use this, but I'm sure there's a better way: == //Find all invoices sent in 2009 SELECT * FROM

Re: [sqlite] concurrency differences between in-memory and on disk?

pierr wrote: > So, for "A single connection shared by multiple threads" case, is the > statement "there's a > many-readers-single-writer lock at the database level" still ture? Well, the lock is still there, but since there are no other connections, there's noone to be locked out by it. The

Re: [sqlite] first few characters of varchar() corrupted when SELECTing from a C++ program?

(embarrassed) printf("testValue=(%s)\n", testValue); From: John Machin To: General Discussion of SQLite Database Sent: Tuesday, 30 June, 2009 4:51:09 PM Subject: Re: [sqlite] first few characters of varchar()

Re: [sqlite] first few characters of varchar() corrupted when SELECTing from a C++ program?

On 30/06/2009 2:56 PM, freshie2004-sql...@yahoo.com.au wrote: > printf("testValue=(%s)\n"); I've always been afraid to use those new-fangled mind-reading C compilers lest they were easily shocked ;-) ___ sqlite-users mailing list

Re: [sqlite] ATTACH Database

What is D2.Table? Also what is the _fileName referred to in the code? And finally ... what platform? Mono or Windows? I'm just wondering about the use of slashes instead of backslashes in the attach filename. Oh, and http://sqlite.phxsoftware.com is more suited for handling .Net-related