Re: [sqlite] Using Eclipse on Windows XP

Hi, what you need are first Eclipse, the C Development Tools (CDT) and a compiler for Example the MinGW Here are the links for the tools I used for my project. http://getamosaic.sourceforge.net/links.php regards, Tobias Alex Krzos schrieb: > Is there an easy way to develop on sqlite using ecli

Re: [sqlite] Delete Trigger on INSERT OR REPLACE?

Hi Jay, thank you for your quick answer. I will now probably code the insert or replace by myself using the delete. To solve this is in my application not a big issue, but I like referential integrity. /Tobias Jay A. Kreibich schrieb: > That's the documented behavior: > http://www.sqlite.org

Re: [sqlite] Delete Trigger on INSERT OR REPLACE?

Hello Martin, wow 7 Minutes to scan the manual. Yes I know RTFM :o The update trigger is not issued if this test is correct here: sqlite> create trigger fku before update on ch for each row begin delete from blobdata where chId=old.id; end; sqlite> select fname from ch limit 1; 100_5763.JPG.JPG

Re: [sqlite] Inserting an image file?

Hello, I have an open source application using that. You can look at the complete source here: http://getamosaic.svn.sourceforge.net/viewvc/getamosaic/trunk/GetAMosaic/dbAccess.c?revision=28&view=markup Method name: dbAddCharacteristicWData regards, Tobias aditya siram schrieb: > How do I inse

[sqlite] Delete Trigger on INSERT OR REPLACE?

Hello, i have a question. In my application I issue an insert or replace operation. It seems that the delete trigger is not executed here. Is there a special replace trigger? Thanks for your help. regards, Tobias Here my Session: sqlite> select * from ch; 1|100_4664.JPG|103|94|98|64 2|100_4665.

Re: [sqlite] sqlite3_get_table question

Hi, thanks Dan. This was certainly the problem, since there are a lot of zeros in the data. In the meahnwhile I tried out something different. I heard from the incremental blob API. And it worked!!! Here is how I solved it: if(sqlite3_prepare_v2(db, cmd, strlen(cmd), &pStmt, 0) != SQLITE_OK) {

Re: [sqlite] sqlite3_get_table question

> Date: Mon, 29 Dec 2008 11:20:58 +0700 > From: Dan > Subject: Re: [sqlite] sqlite3_get_table question > To: General Discussion of SQLite Database > Message-ID: <65fa0cc6-4248-4675-8100-f069423e0...@gmail.com > Why (ncol+2)? I make the following select statement: SELECT fname, dsize, data,

[sqlite] sqlite3_get_table question

Hi, I retrieve data (1 row only) via the handy getTable function. Inside this row is one blob object with pixeldata. The size is: 256*256 Pixels with 3 bytes each -> 256*256*3 = 196608 Bytes select length(data) from ch; gives me exactly this number. No I try this: typedef struct { uns