"RB Smissaert" <[EMAIL PROTECTED]> writes:
> How would I run these 4 commands via a .bat file or via whatever means:
>
> cd c:\test\ReadCodes
> c:\test\Program\sqlite3 c:\test\ReadCodes\ReadCode.db"
> .output testfile.txt
> select * from readcode where read_code glob 'G2*';
I haven't been
On 10/31/06, Bryan Oakley <[EMAIL PROTECTED]> wrote:
Given that, is there a reliable, portable way to copy a memory db to
disk, when that db makes use of the FTS1 module?
I've been pondering this, and nothing good came of it :-).
My best suggestion would be to modify your copy system to first
Hi,
We are newbie to SQLite and we would like to lock a table through a select +
update.
Something like that:
BEGIN TRANSACTION
currentValue = select currentValue from sequence_transactions;
update sequence_transactions set currentValue = currentValue + 1;
COMMIT;
END TRANSACTION
Kees,
How would I run these 4 commands via a .bat file or via whatever means:
cd c:\test\ReadCodes
c:\test\Program\sqlite3 c:\test\ReadCodes\ReadCode.db"
.output testfile.txt
select * from readcode where read_code glob 'G2*';
It must be simple, but I can't see it.
RBS
-Original
hello,
two questions..
1. comparing select one or two columns from one row
from a bigger table ( 20,000 - 30,000 rows, 20 columns
).
with
select the same column from one row from a smaller
table (20,000 - 30,000 rows, 2 columns). does it make
much different on performance? if yes, what
On 11/16/06, RB Smissaert <[EMAIL PROTECTED]> wrote:
My text file is only an intermediate and I can make the way I want.
I need to move data from Interbase to SQLite. Fastest method sofar is:
IB > ADO recordset
ADO recordset > text file
Import text file with SQLite .import command
Problem with
Hi Kees,
Not sure what I did wrong, but I got it working now.
Just wondering now if I actually need the VB wrapper. Looks all can be done
with command-line work.
RBS
-Original Message-
From: Kees Nuyt [mailto:[EMAIL PROTECTED]
Sent: 16 November 2006 21:36
To: sqlite-users@sqlite.org
Hi RBS,
On Thu, 16 Nov 2006 19:56:36 -, you wrote:
>How do I do this:
>From the command prompt issue a simple select query to a specified database
>and direct the output to a file.
>I can see there is the .output FILENAME option, but nothing seems to happen.
>.output stdout works fine with
Funny thing!
My project is written in PHP! I've just modified pdo_sqlite to get
access to the set_authorizer-call!
My first solution was much more simple!
But hey, you are right!
Regards,
Mario
2006/11/14, [EMAIL PROTECTED] <[EMAIL PROTECTED]>:
"Mario Wolff" <[EMAIL PROTECTED]> wrote:
> Hello
How do I do this:
>From the command prompt issue a simple select query to a specified database
and direct the output to a file.
I can see there is the .output FILENAME option, but nothing seems to happen.
.output stdout works fine with output to the screen.
Must be overlooking something simple
Hi,
We are newbie to SQLite and we would like to lock a table through a select +
update.
Something like that:
BEGIN TRANSACTION
currentValue = select currentValue from sequence_transactions;
update sequence_transactions set currentValue =
Aah, I see "Shell" means something different to you than to me. I'm sorry, I
was thinking SQLite shell. I can't help with any specific VB examples.
-Clark
- Original Message
From: RB Smissaert <[EMAIL PROTECTED]>
To: sqlite-users@sqlite.org
Sent: Wednesday, November 15, 2006 5:11:38
There is nothing in the book about compiling either sqlite or PHP.
It's more of a reference for someone who wants to know how SQLite
is build and how one should use it. The compiling stuff you are going
to have to find it on the web as the stuff in the book is pretty close to
the sqlite wiki.
On
Michael Young uttered:
I've had PHP5 for two months now and have not been able to compile it
successfully on my Mac so that SQLite 3.x files can be accessed. I had hoped
to find help in compiling in Mike Owens' book.
Does the book offer any details on compiling that might make the purchase
Vis Naicker uttered:
[EMAIL PROTECTED] uttered:
the blob database... within 1.5sec or less from the CD. ... LED on the
CD rom blinking only occasionally, not
constantly like when I copy a file.
[If the LED only lights when data is being transferred, then what
you're
seeing is the
To my knowledge SQLite can only store text using UTF-8 or UTF-16
encoding.
I guess in some circumstances the latin1 representation
would be more compact than UTF-8, but if that's an issue for
you then you would probably want to apply some kind of external
compression algorithm to your strings
Yup i updated too. I had only sqlite-2 python bindings installed (debian)
On 11/16/06, Linker M Lin <[EMAIL PROTECTED]> wrote:
And mine is:
>>> import sqlite
>>> sqlite.version
'1.1.8'
>>>
Hi,
is it possible to specify the character set for a table ? I would like
my data to be in latin1 instead of utf-8.
Thanks !
Ce message est prot?g? par les r?gles relatives au secret des correspondances.
Il est donc ?tabli ? destination exclusive de son destinataire. Celui-ci peut
donc
On 11/15/06, John Stanton <[EMAIL PROTECTED]> wrote:
Vivien Malerba wrote:
> On 11/13/06, Shivshankar Subramani - TLS , Chennai <[EMAIL PROTECTED]>
> wrote:
>
>> Hi all,
>>
>> > SQLite version 2.8 and earlier could not (easily) store binary
>> > data - data with embedded \000 characters. Thus
[EMAIL PROTECTED] wrote:
In the FAQ's on the web site it indicated that when the primary key is
autoincrement, the data type is a signed 64 bit number. Has this been your
experience?
never noticed... not in Python with the sqlite modules I have... and
no difference whether I use the
20 matches
Mail list logo