In my experience you have to create a custom control. If you are doing
this under MFC, subclass listbox or grid. IIRC there might be a table
class that is a good starter. I did something similar in a recent app
(BackupBuddy 2) using wxWidgets. Another alternative we are looking at
At 05:33 AM 12/23/2004, you wrote:
Inserting binary data without encoding it should *not* corrupt the
database. It might make it difficult to get your data back, but
other records in the database should be uneffected and the kinds
of errors you were seeing from PRAGMA INTEGRITY_CHECK should not
At 03:43 PM 12/22/2004, you wrote:
See section 6.0 in http://www.sqlite.org/lockingv3.html.
That article is on SQLite version 3, but the methods for
corrupting a database apply equally well to version 2.
Thanks. Unfortunately, none of these seem terribly likely. The user
reported that nothing
if upgrading
from the 2.8 series to the 3.0 series is just a drop in or if my code will
need to change. Can anyone tell me if the API has changed in a notable
way? Also, is my performance going to improve with the 3.0.8 over
2.8.13? If not, what about 2.8.15?
thanks!
Michael Hunley
Managing Partner
At 05:41 AM 3/4/2004 -0600, TBrowder wrote:
Adding a blob capability (i.e., allowing a byte string as data which
is defined by length rather than null termination)
I have a C++ interface class that gives you blobs in the current SQLite
(2.8.8-2.8.11+) without breaking the optimization
At 10:32 AM 2/27/2004 +0100, Eric Morand wrote:
This was a mistake by me ! Here is the order actually returned by SQLite :
Celine
Céline
Eric
Marc
Zoe
céline
eric
Éric
éric
Do someone know how to have the ORDER BY statement return values ordered
with anything else that memcmp() order ? This
At 11:36 AM 1/31/2004 -0600, Kurt Welgehausen wrote:
You'll have to encrypt each column independently. If you use
the same key and initialization vector, you should be able to
search, but of course, only for exact matches. Also, the size
of each field will probably grow to the next multiple of
mp JOIN t1 USING id JOIN t2 USING id WHERE
t2.time=temp.time;
I am hoping for some syntax that is the valid SQL/SQLite equivalent of:
SELECT t1.name,t2.deleted FROM t1 join t2 USING id WHERE t2.time=MAX(t2.time)
thanks for any help.
Michael Hunley
Senior Engineer
PocketPur
it wraps or something)?
thanks.
Michael Hunley
Senior Engineer
PocketPurchase, Inc.
At 11:12 AM 1/14/2004 -0500, D. Richard Hipp wrote:
SELECT count(*) FROM table WHERE col1>'abc' AND col1<'xyz';
In the original query, the result was indeed a count(*) so no
access to the data we required there. But access to the data
was required in order to evaluate the WHERE clause. So it
At 10:37 AM 1/14/2004 -0500, D. Richard Hipp wrote:
In some cases you can avoid the O(logN) lookup of the
main table entry and just use the index. For example:
SELECT count(*) FROM table WHERE col1>'abc' AND col1<'xyz';
Wasn't that the original question, Ken? Except it was a count(*) on a
At 07:17 PM 1/13/2004 -0500, D. Richard Hipp wrote:
Actually, SQLite implements JOIN USING by translating the
USING clausing into some extra WHERE clause terms. It does
the same with NATURAL JOIN and JOIN ON. So while those
constructs might be helpful to the human reader, they don't
really make
At 05:16 PM 1/13/2004 -0600, Williams, Ken wrote:
SELECT count(*) FROM propositions p, output o
WHERE p.verb_id=o.verb_id
AND p.tag=o.tag
AND (p.stop!=o.stop OR p.start!=o.start);
I don't think this will be much help and is very implementation specific, I
expect, but
Your first two
At 05:20 PM 12/11/2003 -0500, [EMAIL PROTECTED] wrote:
Try this alternate syntax:
SELECT U.b,
I.c
FROM User U,
UserInfo I
WHERE U.a = I.a;
Thanks. I can work around it easily, but there are advantages to the AS
that might also be broken that could not be easily re-worked,
works just fine.
According to the docs on the website, this should be supported. If you
have lots of fields to extract from multiple tables, this can get painful
depending on the length of the table names you use.
I have submitted a bug report.
Michael Hu
lks about AUTOINCREMENT.
If I'm missing something or wrong about any part, please let me know.
thanks. HTH.
Michael Hunley
Senior Engineer
PocketPurchase, Inc.
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
At 12:49 PM 11/21/2003 -0600, Scott Lamb wrote:
Many people (myself included) prefer it the way this list does it. I'm on
a lot of lists which are sorted into subfolders. If you send a message to
the list, I might or might not see it. If you "reply all" to a message of
mine (or to a "reply all"
At 02:04 PM 11/21/2003 +0200, you wrote:
Your question fails into same category as "Can I SELECT ... FROM * ; ?"
It is not that easy to explain why, but you should never ask such questions.
Umm...That sounds a little harsh and totalitarianist. Did you actually
mean that people shouldn't ask
At 05:35 PM 11/21/2003 +0100, you wrote:
Will you stop sending your emails twice, this one, I also got twice
I am only getting them once. Are others getting them twice? Bert, are you
sure it is not something going on in your email server? Or perhaps a
double email address mapping in the list?
19 matches
Mail list logo
