[sqlite] built-in functrion suggestion: size of blob

I look into the build in function of SQLite and saw there is a function to know the length of a string (in a record). Great! But to my disbelief there is (apparently) no way to get the size of a blob (other than loading it :-() And no, length() doesn't work on Blob. I think it would be a

[sqlite] Multithreading ( C#) question

I have read that SQLite doesn't suport well multithreading... I have the following problem and wonder if anyone could provide me some guidance. I have a GUI application using SQLite to store its data. I have a 'Search' panel. Performing a search (scan of the database) in the background. And

[sqlite] about text search

let's say I have a table like that CREATE TABLE Infos { id INTEGER, text TEXT } and I want to search a with the word... 'apple', 'cinamon', 'cake' I could write SELECT FROM infos WHERE text LIKE '*apple*' AND text LIKE '*cinamon*' AND text LIKE '*cake*' Now, isn't there a way to

Re: [sqlite] about text search

thanks all! - Original Message - From: Puneet Kishor [EMAIL PROTECTED] To: sqlite-users@sqlite.org Sent: Sunday, June 26, 2005 9:21 AM Subject: Re: [sqlite] about text search On Jun 25, 2005, at 6:05 PM, Lloyd Dupont wrote: let's say I have a table like that CREATE TABLE Infos

[sqlite] question about BLOB

in the application I'm writting I would make intensive use of BLOB in fact I have a very simple DB tables. However most of them have a BLOB column where I would put application defined data. The data could easily be over 50K (in fact it would be an in memory .tgz archive with user text and

[sqlite] SQL question

I have 2 related table: CREATE TABLE Ingredients( ID INTEGER PRIMARY KEY, name TEXT, description BLOB, property_ID INTEGER ); CREATE TABLE Properties( ID INTEGER PRIMARY KEY, price double ); When I create a new Ingredient I would like to create a new property for this

Re: [sqlite] SQL question

BTW, one more question / precision. in INSERT INTO Properties() I didn't pass the value for ID. because basically I want an auto-incremented value which I don't have to worry about. maybe that's not the way to use such value ?! - Original Message - From: Lloyd Dupont [EMAIL

Re: [sqlite] SQL question

thanks Martin it worked! although I replaced your (SELECT MAX(ID) FROM Properties) by ROWID. is it sound? like that: CREATE TRIGGER create_ingredient_property AFTER INSERT ON Ingredients BEGIN INSERT INTO Properties (price) VALUES (NULL); UPDATE Ingredients SET property_ID = ROWID

Re: [sqlite] SQL question

Thanks for that! last_insert_rowid() function: anyway, I hadn't tested the code. I mean the CREATE TRIGGER succeed. But I didn't check if the trigger itself works well. Now I did and have a problem... It don't work! I get: SQLite Error 1 - no such column: OLD.ID this is my setting: CREATE

Re: [sqlite] SQL question

Sorry, stupit mistak, I have to use NEW and not OLD in case of an INSERT trigger! Thanks all it works like a breeze! - Original Message - From: Lloyd Dupont [EMAIL PROTECTED] To: sqlite-users@sqlite.org Sent: Thursday, June 09, 2005 12:26 AM Subject: Re: [sqlite] SQL question Thanks

[sqlite] beginner's question

a question about sqlite3.exe reading some documentation aboit it I see you could have memory database. how do I create them? or attach them?