Luuk wrote, On 11/09/2011 05:29 AM:
On 08-11-2011 14:04, Arbol One wrote:
Any one knows where I can get the documentation in
http://www.sqlite.org/download.html, but in PDF format?
The main problem with this is that PDF is so much baes on a page layout,
and HTML is not
I tried to 'convert
name with prepare?
Michael D. Black
Senior Scientist
Advanced Analytics Directorate
Advanced GEOINT Solutions Operating Unit
Northrop Grumman Information Systems
From: sqlite-users-boun...@sqlite.org [sqlite-users-boun...@sqlite.org] on
behalf of Konrad
Bertus --
The only way to reference a Variable Table Name would
be to create a Dynamic SQL Statement at runtime, prep
the Dynamic Statement then exec.
This would be true for all implementations of SQL that
I am aware of ...
-- kjh
Stander, Bertus (Pretoria) wrote, On 11/01/2011 05:25 AM:
Goo
All --
This page has a lot of info about
Decimal Number support, including
a set of libraries:
http://speleotrove.com/decimal/
-- kjh
Black, Michael (IS) wrote, On 03/27/2011 06:29 AM:
> Base 10 multiplication is needed. Although money is the main reason for
> doing BCD due to cumulative er
LacaK wrote, On 03/22/2011 08:53 AM:
>>> / Problem will be solved if SQLite will store such values as text ... so
Laco --
Problem will be solved when you teach SQLite to store such values as text.
This library might help your project:
http://speleotrove.com/decimal/
-- kjh
_
Art Age Software wrote:
> With Roger's help I have gotten to the bottom of this issue, and I
> wanted to post the resolution to the list in case anyone else bumps
> into it.
>
> There is a bug in PHP versions prior to PHP 5.3 that makes it
> impossible to reliably create/store BLOB columns. My co
Roger Binns wrote:
> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
>
> On 09/13/2010 04:06 PM, BareFeetWare wrote:
>> All this talk of replacing multiple commas with pipes, then replacing pipes
>> and so on, though clever and helpful is problematic, cumbersome and even
>> comical for a matur
BareFeetWare wrote:
> All this talk of replacing multiple commas with pipes, then replacing pipes
> and so on, though clever and helpful is problematic, cumbersome and even
> comical for a mature product like SQLite.
>
> On 13/09/2010, at 9:53 PM, Simon Slavin wrote:
>
>> This is true. You a
Rich Shepard wrote:
On Mon, 13 Sep 2010, Mithun Nair wrote:
When i try importing it into a SQLite table, i get some errors like
"expected 2 columns of data but found 1". Later i found that importing a
comma separated file into SQlite wont work because a comma is considered
as a delimiter by t
Jim --
I agree with your sentiments.
But as Dr. Kirkby is alleged to have once said ...
Jim Showalter wrote:
> I really really hate top-posting.
>
> - Original Message -
> From: "Dr. David Kirkby"
> To: "General Discussion of SQLite Database"
> Sent: Saturday, August 08, 2009 11:28
forums/t/1642.aspx
>
> - Original Message - From: "Konrad J Hambrick"
> To: "General Discussion of SQLite Database"
> Sent: Sunday, August 02, 2009 12:19 PM
> Subject: Re: [sqlite] ANN: SQLite 3.6.16.C#
>
>
>>
>> Noah --
>>
>> This i
Noah --
This is a wonderful accomplishment !
However, I have a question ...
Doesn't C# support native function calls ?
If so, other than scratching an itch, what does a native port to C# do ?
Thanks.
-- kjh
Noah Hart wrote:
> Richard sent me a gentle reminder that read in part:
>
> ===
There are Free and Commercial ODBC Drivers for Text / CSV files out there.
-- kjh
On 07/08/2009 07:06 AM, P Kishor wrote:
> On Wed, Jul 8, 2009 at 2:00 PM, _h_ wrote:
>> Hi Kishor,
>> Thank your pointing out perl db module.
>> Is the same things are avaiable as C/C++ apis.
>
> I have no idea.
ase alleviate fragmentation?
>
> - Jeff
>
> -Original Message-
> From: sqlite-users-boun...@sqlite.org
> [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Konrad J Hambrick
> Sent: Tuesday, June 16, 2009 1:43 PM
> To: General Discussion of SQLite Database
>
gt; [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Matthew L. Creech
> Sent: 16. júní 2009 15:51
> To: kon...@payplus.com; General Discussion of SQLite Database
> Subject: Re: [sqlite] Database inserts gradually slowing down
>
> On Tue, Jun 16, 2009 at 11:31 AM, Konrad J Hambrick wro
Hmmm ...
Is there a way to replace step 5 (delete everything from the table)
with a System-Level rm / unlink and a sqlite CREATE TABLE ?
-- kjh
On 06/16/2009 10:06 AM, Jim Wilcoxson wrote:
> You are doing transactions here, which is a very different thing from
> normal disk I/O. Your CPU is i
On 11/05/2008 03:35 AM, Roger Binns wrote:
> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
>
> Michael Muratet wrote:
>>> I guess I'm not making my myself clear. I only have one installed
>>> version.
>
> That is not true. If it was true then you wouldn't have ended up with
> 3.3.6 being re
On 10/08/2008 05:50 PM, James Pringle wrote:
> Hi-
>
> I am new to sqlite, and am having a puzzling problem. I have read
> that adding an INDEX to a sqlite table can never make a SELECT
> statement slower. However, in my case, it seems to be making the
> select statement an order of magnitude
On 01/29/2008 11:16 PM, Bharath Booshan L wrote:
How can I instruct GLOB function to perform case-insensitive search similar
to LIKE. Can I?
Bharath --
A lot depends on the character set you choose to use.
If you use US ASCII, there is a collation (COLLATE NOCASE)
that could handle this fo
On 01/26/2008 02:40 AM, Bharath Booshan L wrote:
>
Hello list,
I have to perform a search something similar to this
ID FilePath
1 /Volumes/Backup/MyMovies/MyMovie.mp4
2 /Volumes/Backup/MyMovies/Hello.mp4
3 /Volumes/Tiger/MyMovie.mov
Search for file name MyMovi
Bob --
Oops. I have had my head down in my tty
porting a linux app to MinGW / MSYS and
missed your post yesterday.
Dang ! I would have saved myself an hour
or so this morning ;-)
-- kjh
On 12/01/2007 08:46 AM, Bob Rossi wrote:
On Sat, Dec 01, 2007 at 08:25:22AM -0600, Konrad J Hambrick
All --
Attached is a patch for the sqlite3 version 3.5.3
install target in Makefile.in ...
The 'make install' target works much better now in
the MinGW environment ;-)
Thanks for sqlite3 !
It is an awesome program.
-- kjh
*** makefile~01.in Fri Nov 23 10:05:48 2007
--- Makefile.in Sat De
hmmm ...
Maybe try
hash -r
(man bash)
HTH
-- kjh
On 11/23/2007 04:47 PM, Jonathan Otsuka wrote:
On Nov 23, 2007, at 4:31 PM, Xabriel J Collazo Mojica wrote:
Guys:
Thank you all for your quick replies!
As P Kishor suggested, I restarted the mac and guess what? It now reports
the cor
23 matches
Mail list logo