Hello,
2012/12/18 Miles Liu :
> sqlite-shell-win32-x86-3071500
> when download it , anti-virus said found a Malware.
False positive. VirusTotal report here:
https://www.virustotal.com/file/85fa29a391d7ab8af4736dfd36222a651a9b3af56c5f81bb58c9b106eaa63533/analysis/1355816443/
sqlite-shell-win32-x86-3071500.zip
(266.33 KiB)
when download it , anti-virus said found a Malware.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Tom B. wrote:
So, do you mean something like:
select group_concat(RefDes) as Clump
from MyTable
group by cast ((substr(RefDes, 2, 99) - 1) / 50 as integer)
Yes, something like that is just what I needed. Thanks!
(The designators are not always in such a monotonic sequence, nor is
their
So, do you mean something like:
select group_concat(RefDes) as Clump
from MyTable
group by cast ((substr(RefDes, 2, 99) - 1) / 50 as integer)
which seems to work.
Tom
Tom Brodhurst-Hill
BareFeetWare
--
iPhone/iPad/iPod and Mac software development, specialising in databases
On 17 Dec 2012, at 8:35pm, "Marc L. Allen" wrote:
> Another item.. when having Journal Mode = PERSIST, DBA (in the example below)
> was not being physically updated. DBB was.
I can think of a reason you might not be able to see an update until you have
executed
I've got a table which can be described as holding one "RefDes" per
row. (They are reference designators in a electronic PCB schematic or
its bill-of-materials.) There are thousands of them, and each one is
very short, inducing the convention of clumping them together for
display in a
Thank you Valentin, Alexey and Sandro. FTS3 and FTS4 are very good that i
have never heard about them. We all have to read
http://www.sqlite.org/fts3.html at least one time.
Alexey,Sandro i'm glad to hear you that 100-160GBs are tested. Thank you
very much.
I will share my experiences while
I'm having some unexpected results using PRAGMA journal_mode = PERSIST;
My general flow runs something like:
open(DBA)
PRAGMA journal_mode = PERSIST;
ATTACH DBB
SQL ...
close()
If the DBA.journal file exists, it's deleted before the attach (though I
haven't identified exactly where. I can if
Igor
>I'm not sure I completely understand
I'm not surprised re-reading my requirement. It isn't clear at all.
I'll have a play with what you've given me first.
Thank you very much...not only for the solution but also for your
explanation which I really appreciate.
Dean
On 17 December 2012 00:39,
On Sun, Dec 16, 2012 at 10:02:41PM +0200, ?a?lar Orhan wrote:
> Hello again,
> Thank you Simon.
> The page http://www.sqlite.org/limits.html has my answer partly. In MS IIS
> what gbytes bigger size of .sqlite file should significant to work on it
> properly?
> I mean, is there a 10-12 GB sqlite
10 matches
Mail list logo