Re: [sqlite] Determine if UPDATE has worked.

Pavel Ivanov wrote: >Did you look into this: http://www.sqlite.org/c3ref/changes.html ? > >Pavel > >On Tue, Jul 21, 2009 at 7:57 PM, Steve Martin wrote: > > >>Hi List, >> >>I am new to sqlite and having trouble determining if an update has worked. >> >>I am using the C/C++ API. >> >>For an updat

Re: [sqlite] Determine if UPDATE has worked.

Did you look into this: http://www.sqlite.org/c3ref/changes.html ? Pavel On Tue, Jul 21, 2009 at 7:57 PM, Steve Martin wrote: > Hi List, > > I am new to sqlite and having trouble determining if an update has worked. > > I am using the C/C++ API. > > For an update, when sqlite3_step is executed it

[sqlite] Determine if UPDATE has worked.

Hi List, I am new to sqlite and having trouble determining if an update has worked. I am using the C/C++ API. For an update, when sqlite3_step is executed it returns SQLITE_DONE when a record is updated or if a record does not exist. I have not found an answer by reading and searching the docu

Re: [sqlite] Memory leak on inserting from sqlite c/c++ interfaces

> If I remove or comment out the > three lines with //* in the code above, I get no memory leaks. So basically you're saying that if you don't insert any data into your database and thus effectively don't do with your database anything and thus SQLite don't have to cache anything from database the

[sqlite] Memory leak on inserting from sqlite c/c++ interfaces

Hello, I'm a bit new to sqlite, I wonder if someone can advise me here. I'm using the Sqlite C/C++ interfaces, and I'm trying to do some very basic things. Currently I'm just creating a database with 1 table, and this table has 1 column of type blob. I then read some data out of a file and inser

Re: [sqlite] Indexes on the table

On 21 Jul 2009, at 11:12pm, Joanne Pham wrote: > CREATE TABLE myTable( > startTime INTEGER ... > appId INTEGER > myId INTEGER ... > trafficType INTEGER > .. > ) > StartTime can be from 1...59 > appId can be from 1...256 > myId can be from 1...5000 > trafficType can be from 1..

[sqlite] Indexes on the table

Hi All, I need to create the indexes on the tables and these indexes have 4 columns. Let say the table definition as below: CREATE TABLE myTable(     startTime INTEGER ...     appId INTEGER     myId INTEGER ...     trafficType INTEGER .. ) StartTime can be from 1...59 appId can be from 1...256

Re: [sqlite] Run genfkey on temp db from app

On Tue, 21 Jul 2009 08:57:25 -0500, "Jay A. Kreibich" wrote: >On Mon, Jul 20, 2009 at 10:57:33PM +0200, Kees Nuyt scratched on the wall: >> Think Lite. > > I'm trying. That's why I didn't suggest just rolling it into > the main code. By having it as a module you can load it (or not) and > us

Re: [sqlite] Multiple connections to :memory: database

Shaun Seckman (Firaxis) wrote: > Is it possible to have multiple connections to a purely in-memory > database No. Igor Tandetnik ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Multiple connections to :memory: database

Is it possible to have multiple connections to a purely in-memory database and if so how can one go by doing that? Would it be safe if the connections were on separate threads? -Shaun ___ sqlite-users mailing list sqlite-users@sqlite.org http:

Re: [sqlite] Subqueries

Ah it worked actually when i typed it and not pasted. Hubboo wrote: > > AH maybe its something to do with portable firefox > > Igor Tandetnik wrote: >> >> Hubboo wrote: >>> Thanks for your reply igor but i get this error >>> >>> Likely SQL syntax error: select * from Academic >>> ?where AcNum

Re: [sqlite] Subqueries

AH maybe its something to do with portable firefox Igor Tandetnik wrote: > > Hubboo wrote: >> Thanks for your reply igor but i get this error >> >> Likely SQL syntax error: select * from Academic >> ?where AcNum = ( >> select AcNum from Interest >> where AcNum not in (select AcNum from Author)

Re: [sqlite] Subqueries

Hubboo wrote: > Thanks for your reply igor but i get this error > > Likely SQL syntax error: select * from Academic > ?where AcNum = ( > select AcNum from Interest > where AcNum not in (select AcNum from Author) > group by AcNum > order by count(*) desc limit 1 > ); [ near "AcNum": syntax error ]

Re: [sqlite] How do bitwise operators work? - Example of schema and request

Le Hyaric Bruno wrote: > My wish is to be able to select an item like that : > > $SELECT id FROM item WHERE bits & 1<<'X'; > (where X is a random value from 0 to 20...) If you go custom function route for this, you may benefit from incremental blob API - see http://sqlite.org/c3ref/blob_ope

Re: [sqlite] Subqueries

I recommend starting with a smaller query and adding to it. For example, can you do a select count from the table? Then can you do a select * from the table? Then can you do a select * with an order by? And so forth, building up the query one piece at a time until it does what you want. I'm no

Re: [sqlite] Subqueries

Thanks for your reply igor but i get this error Likely SQL syntax error: select * from Academic 
where AcNum = ( 
 select AcNum from Interest 
 where AcNum not in (select AcNum from Author) 
 group by AcNum 
 order by count(*) desc limit 1 
 ); [ near "AcNum": syntax error ] Except

Re: [sqlite] Subqueries

Nah still get this error Likely SQL syntax error: select ac.AcNum, count(au.acNum) as auNum, count(int.acNum) as intNum 
 from academic ac 
LEFT OUTER JOIN author au on ac.AcNum = au.AcNum 
 LEFT OUTER JOIN interest int on int.AcNum = ac.AcNum 
 group by ac.AcNum 
having count(au.acNum) = 0 and

Re: [sqlite] Subqueries

Hubboo wrote: > Q. Among the academics who have no papers, who has the greatest > number of interests.. > > Database looks like > > Department(DeptNum, Descrip, Instname, DeptName, State, Postcode) > Academic(AcNum, DeptNum, FamName, GiveName, Initials, Title) > Paper(PaNum, Title) > Author(PaNum,

Re: [sqlite] Subqueries

Sorry, mis-looked: "as int.AcNumCount" should be "as AcNumCount". Don't see other syntax errors. Pavel On Tue, Jul 21, 2009 at 10:21 AM, Hubboo wrote: > > Thanks. Returns an error > > Likely SQL syntax error: select ac.AcNum, count(au.acNum) as auNum, > count(int.acNum) as intNum > from academic

Re: [sqlite] Subqueries

Thanks. Returns an error Likely SQL syntax error: select ac.AcNum, count(au.acNum) as auNum, count(int.acNum) as intNum 
 from academic ac 
LEFT OUTER JOIN author au on ac.AcNum = au.AcNum 
LEFT OUTER JOIN interest int on int.AcNum = ac.AcNum 
 group by ac.AcNum 
 having count(au.acNum) = 0 an

Re: [sqlite] Subqueries

Then I guess your initial query was almost correct. Try to change it like this: select ac.AcNum, count(au.acNum) as auNum, count(int.acNum) as intNum from academic ac LEFT OUTER JOIN author au on ac.AcNum = au.AcNum LEFT OUTER JOIN interest int on int.AcNum = ac.AcNum group by ac.AcNum having coun

Re: [sqlite] Run genfkey on temp db from app

On Mon, Jul 20, 2009 at 10:57:33PM +0200, Kees Nuyt scratched on the wall: > On Mon, 20 Jul 2009 08:34:52 -0500, "Jay A. Kreibich" > wrote: > > >On Mon, Jul 20, 2009 at 12:41:59PM +0200, Jan scratched on the wall: > >> thank you roger. > >> > >> Seems it's not an easy task. Guess I should go thr

[sqlite] SQLite Books

My copy of "The SQL Guide to SQLite" arrived yesterday and I spent some of the evening with it. Because I've read Rick's "Introduction to SQL, 4th Ed." and Mike Owens' "The Definitive Guide to SQLite" I'll be presumptuous enough to think someone here would appreciate my thoughts on the new book.

Re: [sqlite] Subqueries

Thanks for replying OK we have several tables for our assignment and for this particular question we are asked Q. Among the academics who have no papers, who has the greatest number of interests.. I used the * just return all attributes to start with. When I use SELECT * , count( Au.AcNu

Re: [sqlite] Subqueries

Although your query doesn't make sense without any explanation of what did you mean and how it is supposed too work I can provide you a couple of observations: 1) Do you realize that select * doesn't make any sense in this query? The only meaningful field will be ac.AcNum, all others will be essen

[sqlite] Subqueries

Hi, I am doing an assignment using SQLite and was wondering if someone could tell me why this doesn't work and maybe offer some help please? select *, count(distinct au.acNum) as auNum, count(int.acNum) as intNum from academic ac LEFT OUTER JOIN author au on ac.AcNum = au.AcNum LEFT OUTER JOIN i

Re: [sqlite] FW: Use of attach database

On Jul 21, 2009, at 1:11 AM, Sharma, Gaurav wrote: > Hi All, > > Can anybody look in to my query below and suggest me something > helpful! http://www.sqlite.org/cvstrac/chngview?cn=6908 > > With Best Regards > Gaurav Sharma > > -Original Message- > From: sqlite-users-boun...@sqlite.or

Re: [sqlite] How do bitwise operators work? - Example of schema and request

>Can you provide examples of your schema, data, and the types of queries > you want to run? This would make it easier to offer suggestions. > > Rich Of course Richard, In my test I was simply doind something like that : $sqlite3.exe test.db $CREATE TABLE item(id INTEGER PRIMARY KEY AUTOINCREM

[sqlite] Error #3115: SQL Error

Hi! I have tried to create a database and reteived data from it in SQLite for Adobe AIR application using Flex Builder3 .But I am unable to run the code.The code for this is as follows: http://www.adobe.com/2006/mxml"; creationComplete="in