[sqlite] Fwd: begging for SQLite support

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] Fw: Fw: A question on sqlite processing

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

Re: [sqlite] Is it bug? or need to enable any pragma for not null and unique while creating table

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

Re: [sqlite] Fw: Fw: A question on sqlite processing

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

[sqlite] Performing Backups with TCL

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

Re: [sqlite] Performing Backups with TCL

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"

Re: [sqlite] Performing Backups with TCL

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

[sqlite] How to sort within a text field

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

Re: [sqlite] Performing Backups with TCL

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

Re: [sqlite] How to sort within a text field

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');

Re: [sqlite] Performing Backups with TCL

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

Re: [sqlite] How to sort within a text field

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

Re: [sqlite] How to sort within a text field

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

Re: [sqlite] search

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

[sqlite] [FTS] Executing Sql statements inside a custom tokenizer

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

Re: [sqlite] [FTS] Executing Sql statements inside a custom tokenizer

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

Re: [sqlite] [FTS] Executing Sql statements inside a custom tokenizer

> 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

[sqlite] libtclsqlite3 package

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

Re: [sqlite] libtclsqlite3 package

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.

Re: [sqlite] libtclsqlite3 package

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

Re: [sqlite] libtclsqlite3 package

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

Re: [sqlite] libtclsqlite3 package

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 >

[sqlite] Performing Backup via TCL, receiving error

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

Re: [sqlite] How to sort within a text field

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:

Re: [sqlite] How to sort within a text field

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,

Re: [sqlite] Performing Backup via TCL, receiving error

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