Re: [sqlite] query 31 days

Maybe I should maintain a separate table with the monthoverview, but if it is possible 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

[sqlite] Index with two columns

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? My table is: CREATE TABLE PointFeature ( DSetId INTEGER, SectId INTEGER, PntItemId INTEGER); CREATE INDEX xxx ON PointFeature (DSetId, SectI

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 becau

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 i

Re: [sqlite] Version 3.1.3 is a headache

result from a lot of SQL DB systems. How am I supposed to use such column names? The same way every other programmer does, by using alias on the fields that you are interested in, and leaving the others out of it. -- Jakub Adamek Programmer Telematix Software, a.s. Karoliny Svetle 12, Praha 1 htt

[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

ode, but can't think of a way. The sequences 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 A

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 g

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? Than

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

so getting 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 Telemati

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 ?

Re: [sqlite] Version 3.0.7

That's GREAT ! Nuno, are you going to merge Sqlite-Wince STABLE ? Thanks a lot, Jakub -- Jakub Adamek Programmer Telematix Software, a.s. Karoliny Svetle 12, Praha 1 http://www.telematix.cz Tel: +420 608 247197 Office: +420 224233470

[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

Re: [sqlite] Is version 3 seriously broken?

reating rowsets 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 b

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 http://www.mail-archive.com/[E

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&

[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&forum_id=35230 It happens in balance_nonroot but in the declare variable section! If I change the variables in balance_nonroot to "stati

Re: [sqlite] QNX and PPC

Thank you for the explanation. And this file is always created even if I do not use TEMP tables? Because I am not using them. Jakub D. Richard Hipp wrote: Jakub Adamek wrote: I only wonder, what is the file SQLite creates in /tmp? My program calls "CREATE TABLE", "INSERT" an

Re: [sqlite] SQLite 3 for Pocket PC

Thank you, the port was very useful for me. For those interested, I am sending the diff results. Jakub Nuno Lucas wrote: Jakub Adamek, dando pulos de alegria, escreveu : Somebody mentioned here he/she has SQLite 3 working on Pocket PC. Could you please send the sources or diffs? The 3.0.3

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

x86-ld: warning: powerpc:common architecture of input file '.libs/attach.o' is incompatible with i386 output' thus I had to change the "libtool" script, replacing "gcc" with "qcc -V gcc_ntoppc". Which does not seem an elegant solution. Jakub Christ

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 SQLit

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, doe

[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 data

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 on

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 l