[sqlite] What query should I use?

Hi, I have a table with a following data: IdText1 Text2 Text3 Text4 --- 11001 11 test03 test13 21002 11 test01 test11 31003 12 test04 test12 41004 12 test02 test34 51004 12 test06

RE: [sqlite] Re: Why it does not work properly?

Thank you very much Igor!!, Your advices were very helpful. Do you know some good literature to learn/improve SQL knowledge ?? Best reg. Wojciech W. -Original Message- From: Igor Tandetnik [mailto:[EMAIL PROTECTED] Sent: Monday, March 05, 2007 2:21 PM To: SQLite Subject: [sqlite] Re:

[sqlite] What query?

Hi, I have a table with a following data: IdNo1 No2 11001 11 21002 11 31003 12 41004 12 51004 12 61005 12 71006 13 81007 13 91008 14 ... ... Now, I would like to select only the rows when No2 change. So the

[sqlite] Problem with (??) INNER JOIN

Hi sqlite-users, I have a following problem. In my database there are 3 table: CREATE TABLE [Samochody] ( [IDsam] integer, [Samochod] varchar (50), PRIMARY KEY ([IDsam]) ); CREATE TABLE [Modele] ( [IDmod] integer, [IDsam] integer, [Model] varchar

RE: [sqlite] Probably not simple question

Hallo, Thanks a lot, finally everything works well. Indeed, I have to learn much about SQL database usage, so sorry for that question. Regards WojciechW -Original Message- From: Wilson Yeung [mailto:[EMAIL PROTECTED] Sent: Thursday, December 08, 2005 7:38 PM To: sqlite-users@sqlite.org

Re: [sqlite] Probably not simple question

I have follow your advice and had a look at CppSQLite. setBinary and getBinary functions work only on unsigned char, and size of intDouble is (on my PC) 8 bytes, so much more than unsigned char (1 byte). The question is how to correctly store such structure in db, and how to restore it later?

[sqlite] A newbie question

Hi all, so I have a (not) simple question. Is it possible to insert into blob field content of the file? How to = manage it in C++? Regards WojciechW