Re: [sqlite] equivalent of linked tables in sqlite ?

2005-12-13 Thread Arjen Markus
gl demoor wrote: > > I did some preliminary and extensive reseach (cough google cough :) on > delphi and pocketpc > > unless I'm missing something, delphi is not use for pocketpc programming > > google results were of the following nature: > >I'm pretty sure no one supports *Delphi* for *Pocket

Re: [sqlite] Re: update table based on results from a query involving a join?

2005-12-13 Thread Joe Wilson
Yes, that did the trick. Thanks. --- Igor Tandetnik <[EMAIL PROTECTED]> wrote: > UPDATE accomodation > SET country = ( > SELECT c.country > FROM country c > WHERE c.country_id = accomodation.country_id > ); > > Igor Tandetnik > > __ Do

Re: [sqlite] Usability problem with quoted names

2005-12-13 Thread Teg
Hello Alexander, Why not use "?" then fill it in the the actual value later? Quoting and having to actually look at values to make sure they were legal gave me no end of problems now I: CMutexAutolock Locker(DbLock); CDBAutoCloseCloser(); CDBAutoCommit Commit(); hr =

Re: [sqlite] equivalent of linked tables in sqlite ?

2005-12-13 Thread gl demoor
I did some preliminary and extensive reseach (cough google cough :) on delphi and pocketpc unless I'm missing something, delphi is not use for pocketpc programming google results were of the following nature: >I'm pretty sure no one supports *Delphi* for *Pocket PC*, so you will need >to switch

[sqlite] Usability problem with quoted names

2005-12-13 Thread Alexander Kozlovsky
Hi! If I use "some double-quoted stuff" in my query, this one can have two absolutely different meanings. Usually it is column name, but if I wrote this string with error, it silently converts into string literal. I think, this silent behaviour is not very good. If it happens inside deeply

[sqlite] A patch concerning case-insensitive compare of utf-8 strings

2005-12-13 Thread stanley_87
Hello, I was working on a patch that fixes the incorrect case-insensitive comparison of utf-8 strings on LIKE statement. I think that it is working ok now, and I wonder where and in what format should I send the patch for review and potential inclusion. Thanks Stanislav

Re: [sqlite] Final Year Project/Dissertation help required!!!!

2005-12-13 Thread Gerry Snyder
Robert L Cochran wrote: It's better to learn something new than to sit in a lawn chair swatting flies! This thread has been interesting to follow, since one of my main uses for computers is finding projects to work on in a futile but enjoyable attempt to keep my brain from ossifying.

Re: [sqlite] Final Year Project/Dissertation help required!!!!

2005-12-13 Thread m christensen
I hope I was clear in my post. 'I' didn't see your post as asking US to do YOUR homework. What you are doing is needs analysis and by definition requires 'help' or input from others. This is not doing YOUR work for you. On the other hand needs analysis is much more complex than just asking

RE: [sqlite] Final Year Project/Dissertation help required!!!!

2005-12-13 Thread john.newby
No, It's OK, I value every piece of feedback, whether it be good or bad, that way I can learn from my mistakes and try and do better in the future. Keep all your feedback coming, you are all being a great help. I thank you all for your time and patience. John. -Original Message- From:

Re: [sqlite] Final Year Project/Dissertation help required!!!!

2005-12-13 Thread juan perez
ok, ok, I stand corrected. I was a little harsh. But you first need to look at current offerings out there like sqlite3explorer, sqlitespy, to name a few. Here's my $0.02: 10 things I would like in a Sqlite GUI: 1. Cross platform (C/C++ based, not Delphi) 2. Open source 3. 100% sqlite3

RE: [sqlite] Final Year Project/Dissertation help required!!!!

2005-12-13 Thread Fred Williams
In that case, from a users standpoint, SQLite basically looks no different or has any unique requirements outside the realm of any SQL based relational database. The only exception to this generalization is the SQLite environment is more simplistic than most Client Server / Enterprise level

Re: [sqlite] Final Year Project/Dissertation help required!!!!

2005-12-13 Thread John Stanton
Give him a break! He is working smart, not hard. "Who cares whether the cat is black or white when you want to catch mice" - Deng Xiaoping. m christensen wrote: I wouldn't be THIS hard on him, BUT... juan perez wrote: So in a nutshell you are asking the community to do your homework.

Re: [sqlite] Can't commit transaction - SQL statements in progress

2005-12-13 Thread John Stanton
You have pointers to the compiled SQL statements. You should be able to track when the destination of those pointers changes. I haven't had the need to do it, but it is where I would go if careful examination of the code did not reveal the error. JS Eric Scouten wrote: If it were easy to

Re: [sqlite] Final Year Project/Dissertation help required!!

2005-12-13 Thread Ran
Dear John, Unlike some other readers here, I appreciate very much your question. I find it very good that students choose to work with open source in their final projects. Many successful open source projects started this way. So I call this healthy cooperation and not "asking the community to do

Re: [sqlite] Insert performance metrics

2005-12-13 Thread drh
Aaron Burghardt <[EMAIL PROTECTED]> wrote: > Hi, > > OK, I am impressed that you can insert 2000 records/second on indexed > columns. I have an application that inserts CSV data into an SQLite > database, and inserting 15 million records is taking about 2 hours > with no indices (this is

Re: [sqlite] Final Year Project/Dissertation help required!!!!

2005-12-13 Thread John Newby
P.S. I can't start to build it until I have done the analysis of what I am trying to build, that is why I am asking what people would like out of a GUI. John. On 13/12/05, juan perez <[EMAIL PROTECTED]> wrote: > > So in a nutshell you are asking the community to do your homework. What > a

Re: [sqlite] Final Year Project/Dissertation help required!!!!

2005-12-13 Thread Noel Frankinet
John Newby wrote: No, I'm not asking the community to do my homework for me, I need to do a user analysis phase for my dissertation, and as I don't know anyone who uses SQLite this is the only place I can get my questions answered. Many thanks. John. On 13/12/05, juan perez <[EMAIL

Re: [sqlite] Final Year Project/Dissertation help required!!!!

2005-12-13 Thread John Newby
No, I'm not asking the community to do my homework for me, I need to do a user analysis phase for my dissertation, and as I don't know anyone who uses SQLite this is the only place I can get my questions answered. Many thanks. John. On 13/12/05, juan perez <[EMAIL PROTECTED]> wrote: > > So in a

RE: [sqlite] Trying to compile under VC.NET

2005-12-13 Thread Mike Marshall
Just switch off the Using Precompiled Headers directive in the project you are compiling Project -> Properties -> C/C++ -> Precompiled Headers And everything will be AOK Mike M -Original Message- From: Henning Folger [mailto:[EMAIL PROTECTED] Sent: 13 December 2005 08:08 To:

Re: [sqlite] Trying to compile under VC.NET

2005-12-13 Thread Noel Frankinet
Henning Folger wrote: Hello, I am happy to find sqlite. This backend fully matches my need regarding to a projekt of mine. But i have to make some changes to fit into my project. So i tried to recompile the sources under VC.NET. On the web page i found a howto to do it, but i have no luck

[sqlite] Trying to compile under VC.NET

2005-12-13 Thread Henning Folger
Hello, I am happy to find sqlite. This backend fully matches my need regarding to a projekt of mine. But i have to make some changes to fit into my project. So i tried to recompile the sources under VC.NET. On the web page i found a howto to do it, but i have no luck with it. I always get the