On 01/04/2012 06:55 AM, Tilsley, Jerry M. wrote:
All,
I am attempting to generate a backup script written in TCL that will backup all
the databases in a given directory. These databases were all created with
SQLite version 3.6.4. I have the tea package for version 3.7.9 which is what I
am u
On 03/01/12 17:15, guiz wrote:
Hi all, if I have a table like
CREATE TABLE [a] (
[ID] INTEGER NOT NULL,
[prdtype] VARCHAR(35) NOT NULL
)
and data already inserted as
insert into a (ID, prdtype) values (1, '15');
insert into a (ID, prdtype) values (2, '15|10|27|3');
insert into a (ID, prdtype
Simon and Kit-18, thank you, I guess I'll restructure my schema.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
--
View this message in context:
http://old.nabble.com/How-to-sort-
All,
I am attempting to generate a backup script written in TCL that will backup all
the databases in a given directory. These databases were all created with
SQLite version 3.6.4. I have the tea package for version 3.7.9 which is what I
am using to execute the backup command. When the scrip
That worked! I appreciate the help.
Sent from my Verizon Wireless Device
Stephan Beal wrote:
On Tue, Jan 3, 2012 at 9:41 PM, Tilsley, Jerry M.
wrote:
> /usr/bin/ld: cannot find -ltcl8.4.12
> collect2: ld returned 1 exit status
> make: *** [libsqlite3.7.9.so] Error 1
>
> I do have the correct ve
On Tue, Jan 3, 2012 at 9:41 PM, Tilsley, Jerry M.
wrote:
> /usr/bin/ld: cannot find -ltcl8.4.12
> collect2: ld returned 1 exit status
> make: *** [libsqlite3.7.9.so] Error 1
>
> I do have the correct version:
>
> tcl>echo $tcl_patchLevel
> 8.4.12
>
The version might be right, but -ltcl8.4.12 expe
I have downloaded the correct package and am trying to get this to compile, but
running into a problem when running the command "make":
configure: creating ./config.status
config.status: creating Makefile
config.status: WARNING: 'Makefile.in' seems to ignore the --datarootdir setting
config.stat
On Tue, Jan 3, 2012 at 3:18 PM, Tilsley, Jerry M.
wrote:
> All,
>
> I need to get the update libtclsqlite3 package. How can I compile this or
> download this?
>
http://www.sqlite.org/download.html
Get the amalgamation tarball that include the TEA-compatible makefile.
>
> Thanks,
>
> Jerry Ti
All,
I need to get the update libtclsqlite3 package. How can I compile this or
download this?
Thanks,
Jerry Tilsley, Sr Systems Analyst
St. Claire Regional Medical Center
Morehead, Ky
P: 606-783-6563
Disclaimer
This email is confidential and intended sole
> Two FTS tables? One with the Porter stemmer, for search, one without, to
> build the auxiliary tables?
Yeah, that is the last option, if nothing else works. For a small set
of documents the extra processing time might be ok but for a larger
set of documents building the FTS tables twice might b
On Jan 3, 2012, at 8:30 PM, Abhinav Upadhyay wrote:
> What other options do I have ?
Two FTS tables? One with the Porter stemmer, for search, one without, to build
the auxiliary tables?
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sq
Hi,
I would like to build up a table of all the unique words occurring in
my corpus (for spelling suggestion feature). Presently I am using the
Porter stemming tokenizer and I would not like to stop using the
stemmer at any cost. Although if I was not using the Porter stemmer
then I could easily o
BTW, in my eyes, sqlite has the full potential to become most used DB
engine for hierarchical data too (besides relational), once someone
clever hacker manage to port something like Pathfinder [1,2,3] (which
is, let say, optimizing XQuery/SQL compiler) to generate VDBE bytecode
(like the build-
On 3 Jan 2012, at 5:50pm, Kit wrote:
> 2012/1/3 Simon Slavin :
>> SELECT id,group_concat(type) FROM (SELECT ID, prdtype FROM prds ORDER BY id,
>> prdtype);
>> Simon.
>
> SELECT id,group_concat(prdtype) FROM (SELECT ID, prdtype FROM prds
> ORDER BY id, prdtype) GROUP BY id;
Thanks. I forgot th
2012/1/3 Simon Slavin :
> SELECT id,group_concat(type) FROM (SELECT ID, prdtype FROM prds ORDER BY id,
> prdtype);
> Simon.
SELECT id,group_concat(prdtype) FROM (SELECT ID, prdtype FROM prds
ORDER BY id, prdtype) GROUP BY id;
--
Kit
___
sqlite-users ma
Running SQLite version 3.6.4. This is to work, just not sure why it quit
working now.
Jerry Tilsley, Sr Systems Analyst
St. Claire Regional Medical Center
Morehead, Ky
P: 606-783-6563
-Original Message-
From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org]
On
On 3 Jan 2012, at 5:15pm, guiz wrote:
> Hi all, if I have a table like
> CREATE TABLE [a] (
> [ID] INTEGER NOT NULL,
> [prdtype] VARCHAR(35) NOT NULL
> )
>
> and data already inserted as
>
> insert into a (ID, prdtype) values (1, '15');
> insert into a (ID, prdtype) values (2, '15|10|27|3');
On Tue, Jan 3, 2012 at 12:07 PM, Tilsley, Jerry M.
wrote:
> Can you share your syntax you use? What I am using keeps kicking out the
> error "Error: bad option 'backup': must be..."
>
http://www.sqlite.org/src/artifact/b4966934b2d?ln=65
I'm guessing you are using a really old version of SQLite
Hi all, if I have a table like
CREATE TABLE [a] (
[ID] INTEGER NOT NULL,
[prdtype] VARCHAR(35) NOT NULL
)
and data already inserted as
insert into a (ID, prdtype) values (1, '15');
insert into a (ID, prdtype) values (2, '15|10|27|3');
insert into a (ID, prdtype) values (3, '8|6|22');
and I'd
Can you share your syntax you use? What I am using keeps kicking out the error
"Error: bad option 'backup': must be..."
Jerry Tilsley, Sr Systems Analyst
St. Claire Regional Medical Center
Morehead, Ky
-Original Message-
From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...
On Tue, Jan 3, 2012 at 11:43 AM, Tilsley, Jerry M.
wrote:
> All,
>
> Working on a TCL script that will perform backups of my SQLite databases.
> This is to work, but now it says that the backup option is invalid. Is
> this option no longer supported?
>
The "backup" method for TCL database objec
All,
Working on a TCL script that will perform backups of my SQLite databases. This
is to work, but now it says that the backup option is invalid. Is this option
no longer supported?
Thanks,
Jerry Tilsley, Sr Systems Analyst
St. Claire Regional Medical Center
Morehead, Ky
_
Why don't you try the split yourself and see if it solves the problem and then
let us all know?
It sure sounds like file size could be the cause.
Michael D. Black
Senior Scientist
Advanced Analytics Directorate
Advanced GEOINT Solutions Operating Unit
Northrop Grumman Information Systems
On Tue, Jan 03, 2012 at 11:57:46AM +0530, Durga D scratched on the wall:
> Kreibich,
>
> You understood the problem perfectly. Thank you.
>
> *>>I would just suggest using a single composite path value, >>rather
> than trying to break the path value down into >>individual components
> and st
Is that to say that the 'split on the source file' that is yet to be made is
the reason
for the branching described below (see highlighted below) - can you, please,
explain further, I am still lost? That question still remains a question,
please help . . .
And now, another . . if you don't mi
Would i get your help? Thanks very much!
发自我的 iPad
以下是转发的邮件：
> 发件人: Richard Hipp
> 日期: 2012年1月2日格林尼治标准时间+0800下午10时35分39秒
> 收件人: Olli Zhong
> 主题: 回复： begging for SQLite support
>
> We will be glad to help you on the SQLite mailing list:
> sqlite-users@sqlite.org
>
> 2012/1/2 Olli Zhong
>
26 matches
Mail list logo
