Re: [sqlite] query 31 days

to do some other solution it would be nicer ;-). Thanks for your time, kind regards, Tom, -- Jakub Adamek Programmer Telematix Software, a.s. Karoliny Svetle 12, Praha 1 http://www.dynavix.com Tel: +420 608 247197 Office: +420 224233470

Re: [sqlite] Index with two columns

Richard, thank you very much. Jakub D. Richard Hipp wrote: On Fri, 2005-06-03 at 13:20 +0200, Jakub Adamek wrote: Hello, please, is there any way to make SQLite use an index on two columns when I want to select all rows which have some combination of the two columns? SELECT * FROM

Re: [sqlite] updating records problem

I believe you are wrong. The rowid is the primary key in the SQLite B-tree representation. It is always unique and allows you not to use your own primary key. But if you have a column of type INTEGER PRIMARY KEY, the values in this column become rowid. Otherwise a new autoincremented column is

Re: [sqlite] database table is locked

Hello, I had a similar experience, but there was too much code to create a simple bug report. Surprisingly, the error disappeared if I first made a "SELECT FROM table" before the "INSERT INTO table" on the same table. Also the error description "database TABLE is locked" is sometimes wrong

Re: [sqlite] Sub-Select

Michael, it is because SQLite 3.1.3 changed (or has errors in, it is a matter of opinion) the column naming. Try >> SELECT max(Sendung) >> FROM >> (SELECT S.Sendung AS Sendung >> FROM Auftrag AS A, >> Sendung AS S >> WHERE(A.PosyDat = 1 AND A.PosyDat = S.PosyDat) AND >>

Re: [sqlite] ticket 1147

For me it is not important to know from which table the column comes, but it is a must to have unique column names - because I address all columns by their names. I could also use the column order but this would lead to worse readability and maintainability. Therefore my wrapper protests when

[sqlite] Version 3.1.3 is a headache

Hi, I really love SQLite, but upgrading to 3.1.3 was not a good idea. I have already posted 3 tickets with rather serious problems with column names. The last one is really annoying and I can't believe the auto-tests could have missed it ... create table a (id, x); create table b (id, y);

Re: [sqlite] String Concatenation

are not always the same lenght, i.e., a particular owner may have 1, 10, or 1972 word long sequences. With cursors, I don't think this would be difficult, but I can't figure out how to do this within SQLite. Any help? --Keith -- Jakub Adamek Programmer Telematix Software, a.s. Karoliny Svetle 12

Re: [sqlite] Row count in database

Richard, and how about doing both? Using BEGIN ... COMMIT and at the same time turning off syncing? Jakub D. Richard Hipp wrote: Christopher Petrilli wrote: Has anyone had any experience in storing a million or more rows in a SQLite3 database? I've got a database that I've been building, which

Re: [sqlite] coding style

Hi all, I have a nasty problem with VIEWs and column names. I create a VIEW by joining two tables. If I use this view to create the table 'problem', the column name "t1.a" appears instead of the expected (and needed) "a". Is it a bug? Do you have an idea how to use the view so as it works?

Re: [sqlite] Version 3.0.8

enhancments. If you are not having problems with version 3.0.7 there is little reason to upgrade. -- Jakub Adamek Programmer Telematix Software, a.s. Karoliny Svetle 12, Praha 1 http://www.telematix.cz Tel: +420 608 247197 Office: +420 224233470

Re: [sqlite] eVC++ 3.0 port

millions of warnings because program is attempting to downgrade from int64 to int without typcasting, and even with typcasting that is a dangerous thing to do. If it doesn't need a 64-bit integer when why use it in the first place??? Mel Stober -- Jakub Adamek Programmer Telematix Software, a.s

Re: [sqlite] Version 3.0.7

Thank you, I am looking forward to it. The Sqlite-Wince is really useful, I only copy it to my directory and compile on Win32, WinCE, Linux and QNX. Jakub Nuno Lucas wrote: Jakub Adamek, dando pulos de alegria, escreveu : That's GREAT ! Nuno, are you going to merge Sqlite-Wince STABLE ? I'll

[sqlite] SQLite 3 release

Hello, Dr. Hipp, please, what is the time estimate for releasing the version 3? I believe that it's not only me looking forward to it! It is too lovely, the version 3, how long should I live with version 2? :-)) Jakub

Re: [sqlite] Is version 3 seriously broken?

Nuno, hurrah, it works on first tests. I will run more later. Clever idea! I am now looking much forward to the release ... Thanks for your work. Jakub Nuno Lucas wrote: Jakub Adamek, dando pulos de alegria, escreveu : > Nuno, I am much surprised that version 3.0.5 helped you. It didn't h

Re: [sqlite] Is version 3 seriously broken?

in the stack, for example?). Anyway, with the 3.0.5 port, I could now insert 5 rows without problems. Maybe you could check if my merge is different from yours and if it works now. Regards, ~Nuno Lucas Jakub Adamek, dando pulos de alegria, escreveu : Nuno, I have changed back to SQLite 2

Re: [sqlite] Is version 3 seriously broken?

Nuno, I have changed back to SQLite 2 and have my code ready to switch to version 3 again if the bug is repaired. The thing happens when first calling balance_nonroot, which is in your case always on the 113th row, in my case on the 33th row and in the mail message

Re: [sqlite] Is version 3 seriously broken?

I didn't mention that I applied the diffs from SQLite-WinCE to version 3.0.5 with the same results. Jakub Jakub Adamek wrote: Hello, the version 3 is most probably broken. I traced down the crash problem in Windows CE, see http://sourceforge.net/mailarchive/forum.php?thread_id=5438459_id=35230

[sqlite] Is version 3 seriously broken?

Hello, the version 3 is most probably broken. I traced down the crash problem in Windows CE, see http://sourceforge.net/mailarchive/forum.php?thread_id=5438459_id=35230 It happens in balance_nonroot but in the declare variable section! If I change the variables in balance_nonroot to "static",

Re: [sqlite] QNX and PPC

creates in /tmp? My program calls "CREATE TABLE", "INSERT" and "SELECT". Why does SQLite need some temporary file? Jakub Jakub Adamek wrote: Still not running on Power PC QNX. I tried to comment out locking in os.c and the test program works fine. So the problem is real

[sqlite] SQLite 3 for Pocket PC

Somebody mentioned here he/she has SQLite 3 working on Pocket PC. Could you please send the sources or diffs? Thanks, Jakub

Re: [sqlite] QNX and PPC

Still not running on Power PC QNX. I tried to comment out locking in os.c and the test program works fine. So the problem is really hidden in the findLockInfo() & co. functions. Does somebody have some experience? Thanks, Jakub Jakub Adamek wrote: Thank you for your help. I am trying to c

Re: [sqlite] QNX and PPC

No, I meant Power PC. We use SQLite in our Pocket PC car navigation system with big success also. Jakub Mateusz Łoskot wrote: On 8/9/2004 9:45 AM, Jakub Adamek wrote: thank you for your notes. Could you please tell me more about "That's the case"? Is it possible to use SQL

Re: [sqlite] QNX and PPC

Hi Armin, thank you for your notes. Could you please tell me more about "That's the case"? Is it possible to use SQLite on PPC or not possible? Did you hear about a big-endian port of SQLite? Thanks, Jakub Armin Steinhoff wrote: [EMAIL PROTECTED] schrieb am 06.08.04 19:40:55: Hello everybody,

[sqlite] QNX and PPC

Hello everybody, does someone have any experience with building for the QNX operating system? And for the Power PC processor? QNX 6.2.1 is a real-time Linux but it behaves strangely sometimes. It has not gcc but a qcc compiler. Our testing program runs correctly on the x86 PC. It creates a

Re: [sqlite] A proposal for SQLite version 3.0

, you would be in the opposite situation, the SQLite database would be about half the size of the MS Access one, since MS Access seems to save all strings as UTF-16. Simon B. On Wed, 2004-04-07 at 10:50, Jakub Adamek wrote: Hello, I am using SQLite in a car navigation system which should work

Re: [sqlite] A proposal for SQLite version 3.0

roughly about 3x bigger files than MS Access. How would this change in 3.0? Thanks for your excellent work, Jakub Adamek D. Richard Hipp wrote: A design proposal for SQLite version 3.0 can be found at: http://www.sqlite.org/prop2.html Feedback from the user community is strongly encouraged

Re: [sqlite] Database Full!

Hello, it seems to me the solution would be: Create a special small file just to protect some disc space. If you lack on disc space, delete the protecting file (and hope nobody will steal the disc space inbetween) and delete some records. Than again create the protecting file. Obviously, in a