Have you confirmed that the pBuffer that would read out is byte for byte
the same as the bmBytes that you used to insert in to the database? If
they are the same, then sqlite did its job (or rather you called it
correctly...), and the trouble is somewhere else.
David
On Fri, 2008-08-29 at 14:13 -
Hi,
Since I updated to SQLite 3.6.1 I have a memory leak when my application
exits. If I compile using SQLite 3.5.8 I don't have the memory leak.
VS 2005 dump:
Detected memory leaks!
Dumping objects ->
c:\dev\mescruiser\lib\sqlite\sqlite3.c(11938) : {4754} normal block at
0x01BFC460, 48 bytes long
And what is the type of bmpFile? I guess what I'm getting at here is
that your real issue is more the problem of "How do I serialize a
HBITMAP structure to an array of bytes and restore it." more than "how
do I save it to the database". I think if you can take the database
out of the picture for
Yes I am able to do that. I fill out the BITMAPFILEHEADER and
BITMAPINFOHEADER information for the image, and then I do this:
bmpFile.Write(&bitmapfileheader, sizeof(BITMAPFILEHEADER));
bmpFile.Write(&bitmapinfoheader, sizeof(BITMAPINFOHEADER));
bmpFile.Write(pbyBitmap, size); //pbyBitmap is th
Are you able to load and save the bitmap to a file?
On Fri, Aug 29, 2008 at 2:13 PM, Jared Miller <[EMAIL PROTECTED]> wrote:
> Hello,
>
> I am having trouble figuring out how to successfully write an image to the
> SQLite database as a Blob, using C++.
>
> I have an HBITMAP that I would like to b
Hello,
I am having trouble figuring out how to successfully write an image to the
SQLite database as a Blob, using C++.
I have an HBITMAP that I would like to be able to store to and retrieve from
the DB. If I understand what I have read correctly, I am supposed to write out
the actual byte da
mySQL differs from MS SQL in it random function handling:
SELECT i, RAND() AS R1, RAND() AS R2 FROM z where RAND() < .4;
iR1R2
1 0.531666 0.692986
3 0.743755 0.906643
4 0.789811 0.04321
6 0.977431 0.576784
8 0.284047 0.336876
Different values for R1 and R2 (each call
In Section 7.0, Transaction Control At The SQL Level, at
http://www.sqlite.org/lockingv3.html, it says:
"If the SQL COMMIT command turns autocommit on and the autocommit logic then
tries to commit change but fails because some other process is holding a SHARED
lock, then autocommit is turned b
I agree with you here. It is a temporary table that should "FIX" the
values.
Interestingly
select name, RNDValue
from (
select 'name', random() as RNDValue
)
where RNDValue > 0;
only calls random once and works as expected.
0|Trace|0|0|0|explain select name, RNDValuefrom (select 'name
Noah Hart <[EMAIL PROTECTED]> wrote:
> I would expect that multiple calls to random always return different
> values, even if in the same line.
>
> The fact that we are aliasing random by a column name makes no
> difference to me.
What about this:
select name, RNDValue
from (
select name, ran
Richard, Before you "fix" it, I'm not convinced it is broken.
>From MS SQL server
create table _names (N varchar(5));
insert into _names values('a');
insert into _names values('b');
insert into _names values('c');
insert into _names values('d');
insert into _names values('e');
select N, RAND()
On Thu, Aug 28, 2008 at 8:15 PM, Andreas Ntaflos
<[EMAIL PROTECTED]> wrote:
> Notice the snippet bit: it takes the virtual table name (fts_paper in the case
> of your examples) instead of the column name as an argument, which I find
> curious. Your query would fail with the following error message:
Hello!
В сообщении от Friday 29 August 2008 02:29:37 D. Richard Hipp написал(а):
> Run this command:
>
> sqlite3 old.db .dump | sqlite3 new.db
This command lost information about page size ans some other.
Best regards, Alexey.
___
sqlite-users mai
Package: sqlite3
Version: 3.5.9-3
Severity: normal
Sending to Debian Bug Tracking System and the sqlite-users list.
On the sqlite-users mailing list, bakers wrote:
> Igor Tandetnik wrote:
> > Scott Baker <[EMAIL PROTECTED]> wrote:
> >> Did I do something wrong?
> >>
> >> SQLite version 3.5.9
> >>
forcemerge 488864 497047
thanks
I suck. I should have looked at the existing bugs.
It is a problem. It has already been fixed.
See: http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=488864
Perhaps fedora has an updated package too?
I wrote:
> On the sqlite-users mailing list, bakers wrote:
> >
Is there a feature (like explain) which returns the sequence of
virtual machine instructions that ParseSchema creates?
-Mrinal
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
> Any advice will be greatly appreciated. If there is any FM I
> should R kindly point me to it :)
>
FTS information is difficult to find. Try
http://www.sqlite.org/cvstrac/wiki?p=FtsOne I can't remember how I came
across this link because I can never find it on the SQLite website.
Ignore
That's what I do.
I was looking for a kind of pre-built solution that could have better
performance in loading a table than to do a INSERT for each line inside
a transaction.
But thanks
Filipe Madureira
Alexandre Courbot wrote:
>> I am interested in this issue also.
>> I didn't understand t
> I am interested in this issue also.
> I didn't understand the first part of your answer. "sqlite3 databasefile
> < infile" ??
>
> The ".import FILE TABLE" works, but it is from CLI. How can I do it in
> my C++ application using the sqlite3?
An equivalent would be to read the file line by line an
Hi,
I am interested in this issue also.
I didn't understand the first part of your answer. "sqlite3 databasefile
< infile" ??
The ".import FILE TABLE" works, but it is from CLI. How can I do it in
my C++ application using the sqlite3?
Thanks
Filipe Madureira
Alexandre Courbot wrote:
>> I
20 matches
Mail list logo