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
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
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
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
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
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
>>
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
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
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);
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
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
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
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
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
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 ?
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
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
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
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
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
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&
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
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
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
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
Somebody mentioned here he/she has SQLite 3 working on Pocket PC. Could
you please send the sources or diffs?
Thanks,
Jakub
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
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
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
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
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
, 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
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
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
34 matches
Mail list logo