Re: [sqlite] de...@ukr.net

select from (select ... ) must have alias. It should be select from (select ... ) a On Tue, May 20, 2014 at 9:38 AM, YAN HONG YE yanhong...@mpsa.com wrote: Hi, Sorry, I use mysql, not in sqlite, in mysql ,I run this command, the console show this error: do you know why? Thank you very

Re: [sqlite] Web application with SQLite

fossil is a webserver by itself with sqlite as the database engine. AFAIK, there's no scripting language used on the server. All written in C. On Mon, Dec 30, 2013 at 1:02 AM, Tim Johnson t...@akwebsoft.com wrote: * Stephan Beal sgb...@googlemail.com [131229 07:48]: On Sun, Dec 29, 2013 at

Re: [sqlite] SQL:2003 -- Window Functions

On Thu, Sep 20, 2012 at 12:58 AM, Igor Tandetnik itandet...@mvps.orgwrote: On 9/19/2012 12:51 PM, joe.fis...@tanguaylab.com wrote: Too bad SQLite doesn't yet support SQL Window Functions. Are there any SQLite Extension Libraries that support SQL:2003 type Window Functions? I specifically

Re: [sqlite] SQLITE in a Win7 Service Application

On Wed, Aug 15, 2012 at 11:19 PM, markus ruettimann markus.ruettim...@trapezegroup.com wrote: Hi, We are facing problems when the sqlite database () is used within an application that runs as a Win7 service under the local system account. The application is written in Java and we use the

Re: [sqlite] An interesting (strange) issue with selects

Could it be that the .ext is used by the OS or other apps with some caching scheme? Try different extension... ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] I consider this a bug. Anyone else?

On Tuesday, June 26, 2012, Andrew Rondeau wrote: Because my time is valuable; and my peers' time is valuable as well. For example, if I make a Mac application, I can target the SQLites shipped with Mac. Problem solved, my valuable time can go to something else. Since I don't want any

Re: [sqlite] insert if record not exists without primary key

Hi, I guess, if you could sort your input data by col1 and col2; going thru the list and insert only when col1 and col2 are different from previous row, should speed up the loading too. Regards, Radzi. -Original Message- From: sqlite-users-boun...@sqlite.org

Re: [sqlite] Problem with FTS4 - Floating point error.

On 25-Oct-2011, at 2:53 PM, Dan Kennedy wrote: This was fixed and then I forgot to follow up here. I should have. Sorry about that. It's fixed here: http://www.sqlite.org/src/ci/3126754c72?sbs=0 Either updating to the latest trunk or just applying the linked patch to fts3.c should fix

Re: [sqlite] Problem with FTS4 - Floating point error.

On 18-Oct-2011, at 6:52 PM, Dan Kennedy wrote: On 10/18/2011 05:02 PM, Mohd Radzi Ibrahim wrote: Hi, This is my table schema: CREATE VIRTUAL TABLE LocationFTS using FTS4 ( name text, address text, email text, remark text, telno text, contact text

[sqlite] Problem with FTS4 - Floating point error.

Hi, This is my table schema: CREATE VIRTUAL TABLE LocationFTS using FTS4 ( name text, address text, email text, remark text, telno text, contact text, isDeleted text ); This select statement gives floating point error in both

Re: [sqlite] No error on selecting non-grouped column

On 15-Sep-2011, at 2:55 AM, Magnus Thor Torfason wrote: I then ran a query grouping employees by job: select ename, job from emp group by job; ENAME, JOB == FORD, ANALYST MILLER, CLERK CLARK, MANAGER KING, PRESIDENT TURNER, SALESMAN Now, I get a list of the

[sqlite] FTS4 reserved characters

Hi, I was searching for any reference to reserved characters used in FTS4, but failed to find any. I have problem with query with - ftstable match 'width 5 ' But it's ok with - ftstable match 'width 5' to fix this, I replaces every double-qoute in query with empty space. My question, is

Re: [sqlite] Import data in SQLite from excel using C# code

Hi, Try use www.libxl.com that has C/C++/C#/Delphi interface to read excel files. The rest are just normal sqlite commands. On 28-Mar-2011, at 9:17 AM, Deepti Marathe wrote: Hi, I am new to SQLite and am using it for the first time. I need to create an application using C# that will

Re: [sqlite] Creation and modification timestamps with insert or replace possible?

On 10-Mar-2011, at 6:52 AM, Jay A. Kreibich wrote: On Wed, Mar 09, 2011 at 11:37:46PM +0100, Armin Kunaschik scratched on the wall: On Wed, Mar 9, 2011 at 11:28 PM, Igor Tandetnik itandet...@mvps.org wrote: INSERT OR REPLACE is indistinguishable from a DELETE followed by INSERT. Is it

Re: [sqlite] Fwd: Re: Bug: Umlaut in database filename

On 21-Dec-2010, at 5:02 AM, Richard Hipp wrote: (2) Create your own custom mini-SQL-server using SQLite and your own protocol for your applications to talk to that min-server over the network. The key here is to define your own app-specific protocol for communication between client and

Re: [sqlite] Bundling sqlite database together with exe file.

don't want anybody to copy the database, except together with the exe. Monday, October 25, 2010, 1:17:13 AM, you wrote: KN On Sun, 24 Oct 2010 20:57:15 +0800, Mohd Radzi Ibrahim KN mra...@pc.jaring.my wrote: Hi, I am planning to deploy my sqlite database together with the exe file

[sqlite] Bundling sqlite database together with exe file.

Hi, I am planning to deploy my sqlite database together with the exe file. Is there a way to open the sqlite database with a file handle and starting offset of the file, as read-only? Thank you for any suggestion. regards, Radzi. ___ sqlite-users

Re: [sqlite] Substring (LIKE %key%) searches, would FTS3 with suffix-tree tokenizer be the fast way?

Have you not consider loading the whole rows into memory array and use simple string search or regexp? I'm sure 10,000 records could be search a blink. best regards, Radzi. On 6-Aug-2010, at 3:42 AM, Sam Roberts wrote: I'd appreciate any suggestions on good ways to do this, I'm neither an SQL

Re: [sqlite] EXTERNAL: setup sqlite in vc++

Hi, You could also use another open source layer for SQLite3, wxSQLite3 project on sourceforge. It's uses wxWidgets cross-platform C++ toolkit. best regards, Radzi. On 7-Jul-2010, at 6:09 AM, smengl90 wrote: I found out that including the header file alone is not enough. I need to link

Re: [sqlite] Local data structures vs sqlite

I think worth should be more accurate. - Original Message - From: Jean-Christophe Deschamps j...@q-e-d.org To: General Discussion of SQLite Database sqlite-users@sqlite.org Sent: Friday, November 06, 2009 9:47 AM Subject: Re: [sqlite] Local data structures vs sqlite You read 'worse'

Re: [sqlite] Is this legal SQL?

You should use sprintf(buf, CREATE TABLE %s(x double, y double), tableName); then use prepare and execute using from that string. - Original Message - From: Mike McGonagle mjm...@gmail.com To: General Discussion of SQLite Database sqlite-users@sqlite.org Sent: Tuesday, January 13,

Re: [sqlite] Adding data with periods

The syntax is wrong. INSERT INTO TEST_TABLE(CONTENTS) VALUES (Hello. World!); is the correct one. -radzi- - Original Message - From: aditya siram aditya.si...@gmail.com To: sqlite-users@sqlite.org Sent: Monday, December 15, 2008 1:04 PM Subject: [sqlite] Adding data with periods Hi

Re: [sqlite] Adding data with periods

It seems to works either way. I'm just wondering is there any hidden reason that single quote is preferred? Portability? Or is double-qoute has some kind of special meaning that we should use it for that special purpose? -radzi- - Original Message - From: P Kishor

Re: [sqlite] please help with NULL and NOTHING?

You should handle this in your client program. Even in MS SQL or Oracle, it will not return any resultset. If you were to use left join, you may get it as NULL for any missing links. rgd, Radzi. - Original Message - From: aivars [EMAIL PROTECTED] To: sqlite-users@sqlite.org Sent:

Re: [sqlite] Innovative examples / user stories

Hi, I used SQLite to move data-cube from server to client. The server hosts data in MS SQL databases. There is a server-app that run query based on some input send by client program. The server then run MSSQL query and generate a SQLite db consisting of some tables (fact, dimensions, etc), zip

Re: [sqlite] Help for sqlite syntax

Could you just use ORDER BY 1 ? best regards -- radzi -- - Original Message - From: li yuqian [EMAIL PROTECTED] To: sqlite-users@sqlite.org Cc: Dimitar Penev [EMAIL PROTECTED]; Mark [EMAIL PROTECTED] Sent: Tuesday, February 12, 2008 1:56 PM Subject: [sqlite] Help for sqlite syntax Hi

Re: [sqlite] Version 3.5.5 Released

Hi, The Precompiled Binary for Windows : the command-line sqlite-3_5_5.zip still contain the 3.5.4 version regards, Radzi. - Original Message - From: [EMAIL PROTECTED] To: sqlite-users@sqlite.org Sent: Friday, February 01, 2008 1:33 AM Subject: [sqlite] Version 3.5.5 Released

[sqlite] How do I add primary key on existing table?

Hi, I was trying to add a primary key to existing table but could not. alter table custsales add constraint pk_custsales primary key (id, type) Is this supported? Is there a different syntax to do this? best regards, Radzi.

Re: [sqlite] How do I add primary key on existing table?

On 21-Jan-2008, at 3:12 PM, Dan wrote: On Jan 21, 2008, at 1:24 PM, Mohd Radzi Ibrahim wrote: Hi, I was trying to add a primary key to existing table but could not. alter table custsales add constraint pk_custsales primary key (id, type) Is this supported? Is there a different syntax

Re: [sqlite] Re: Re: How do I do this

This is my 2 cents. Maybe there's better way to do this: select id, amount, (select amount from tablename where id=t.id and sno t.sno limit 1) as oldAmount from tablename t br Radzi. On 14-Jan-2008, at 8:14 PM, Vishal Mailinglist wrote: Hi sno | id | amount 1|

Re: [sqlite] disable transaction support

On the contrary, sqlite work much-much faster when insert/update is done within BEGIN and COMMIT; regards, Radzi. On 26-Dec-2007, at 12:14 PM, Rasanth Akali Kandoth wrote: Hi All, I have an application which inserts large number of rows into a table, where transaction support is not

Re: [sqlite] disable transaction support

has to write into the journal files as well. i want to avoid this too. Thanks, Rasanth On Dec 26, 2007 11:34 AM, Mohd Radzi Ibrahim [EMAIL PROTECTED] wrote: On the contrary, sqlite work much-much faster when insert/update is done within BEGIN and COMMIT; regards, Radzi. On 26-Dec-2007

[sqlite] Compile error sqlite 3.4.2

I'm using Visual Studio 2005 with wxSQLite3 wrapper. I have this error at this line : SQLITE_PRIVATE const unsigned char sqlite3UpperToLower[]; the error says: .\..\wxsqlite3\sqlite3\src\sqlite3.c(6187) : error C2133: 'sqlite3UpperToLower' : unknown size any suggestion on how to

Re: [sqlite] Saving an in-memory database to file

How about dumping and import into new db? - Original Message - From: Colin Manning [EMAIL PROTECTED] To: sqlite-users@sqlite.org Sent: Wednesday, July 25, 2007 7:05 AM Subject: [sqlite] Saving an in-memory database to file Hi If I create an in-memory database (by opening with

Re: [sqlite] storing floating point values in field

I've run SQLite3 inWindows, it's store up it surely did not truncate the decimal point - up to 15 significant digits... regards, Radzi. - Original Message - From: folabi [EMAIL PROTECTED] To: sqlite-users@sqlite.org Sent: Tuesday, July 10, 2007 3:20 AM Subject: [sqlite] storing

Re: [sqlite] Multiple connections to the same database and CREATE TABLE command

Is C1 in transaction? If it is, commit will enable C2 'see' the new table. regards, Radzi. - Original Message - From: Vivien Malerba [EMAIL PROTECTED] To: sqlite-users@sqlite.org Sent: Friday, May 11, 2007 4:19 PM Subject: [sqlite] Multiple connections to the same database and CREATE

Re: [sqlite] create table error

Could it be that the data where *sql is pointing to is being re-used somewhere? --radzi. - Original Message - From: [EMAIL PROTECTED] To: sqlite-users@sqlite.org Sent: Thursday, May 10, 2007 3:54 PM Subject: [sqlite] create table error the following is my test code. just create

Re: [sqlite] how to add a new column quickly

How about this? update tablename set newcolname=(case rowid when 1 then 1 else 2 end); best regards, Radzi - Original Message - From: Tomash Brechko [EMAIL PROTECTED] To: sqlite-users@sqlite.org Sent: Saturday, May 05, 2007 8:09 PM Subject: Re: [sqlite] how to add a new column

Re: [sqlite] DB design questions

My 2 cents: create table Objects(id integer primary key, name text); create table Attributes(id integer primary key, name text); create table ObjectAttributes(objectID integer, attributeID integer, order integer, type integer, value text, version text); - Original Message - From:

Re: [sqlite] trim available ??

Hi, I'm running 3.3.15. No problem at all. Maybe your version does not have this implemented yet... best regards, Radzi. - Original Message - From: Stef Mientki [EMAIL PROTECTED] To: sqlite-users@sqlite.org Sent: Monday, April 16, 2007 10:14 PM Subject: [sqlite] trim available ??

Re: [sqlite] Data structure

Hi, If you are using C++, then try hash_map. I've used this on strings with more that 50,000 records - in memory. Very fast. Much easier to program than BerkeleyDB. - Original Message - From: Lloyd [EMAIL PROTECTED] To: sqlite-users@sqlite.org Sent: Wednesday, April 11, 2007 11:20

Re: [sqlite] RE: Maintaining Master-Child relationships

Use sqlite3_last_insert_rowid - Original Message - From: Arora, Ajay [EMAIL PROTECTED] To: sqlite-users@sqlite.org Sent: Thursday, March 29, 2007 12:19 AM Subject: [sqlite] RE: Maintaining Master-Child relationships Can anyone please look into my query, I've tables Master ( id

Re: [sqlite] CREATE INDEX performance

- Original Message - From: John Stanton [EMAIL PROTECTED] To: sqlite-users@sqlite.org Sent: Wednesday, March 28, 2007 7:42 AM Subject: Re: [sqlite] CREATE INDEX performance I retract the overflow page theory on your compelling evidence and now understand better what it is doing

[sqlite] Linking error with sqlite3SrcListAddAlias...

Hi, I'm using MS VS 2005 (SQLite 3.3.9) and having problem re-building the component. I've just included all the source code inside my project and compile. With version 3.3.8 it works fine, but with current (3.3.9) it's giving me missing sqlite3SrcListAddAlias. Any files should be included

Re: [sqlite] How do I speed up CREATE INDEX ?

] To: sqlite-users@sqlite.org Sent: Sunday, December 03, 2006 8:21 PM Subject: Re: [sqlite] How do I speed up CREATE INDEX ? Mohd Radzi Ibrahim [EMAIL PROTECTED] wrote: Hi, I was loading a file to sqlite (3.3.8), and it took 4 mins to load 6 million rows (with no index). But then when I run CREATE

[sqlite] How do I speed up CREATE INDEX ?

Hi, I was loading a file to sqlite (3.3.8), and it took 4 mins to load 6 million rows (with no index). But then when I run CREATE INDEX it took me 40 mins to do that. What could I do to speed up the indexing process ? Thanks. Radzi.

Re: [sqlite] How do I speed up CREATE INDEX ?

- Original Message - From: Jay Sprenkle [EMAIL PROTECTED] To: sqlite-users@sqlite.org Sent: Sunday, December 03, 2006 9:12 AM Subject: Re: [sqlite] How do I speed up CREATE INDEX ? On 12/2/06, Mohd Radzi Ibrahim [EMAIL PROTECTED] wrote: Hi, I was loading a file to sqlite (3.3.8

Re: [sqlite] How do I speed up CREATE INDEX ?

- Original Message - From: P Kishor [EMAIL PROTECTED] To: sqlite-users@sqlite.org Sent: Sunday, December 03, 2006 10:42 AM Subject: Re: [sqlite] How do I speed up CREATE INDEX ? On 12/2/06, Mohd Radzi Ibrahim [EMAIL PROTECTED] wrote: - Original Message - Because I'm

Re: [sqlite] How do i do this UPDATE in SQLite?

Thanks, that works. The syntax i used is allowed in MS SQL. best regards, Radzi. - Original Message - From: Kees Nuyt [EMAIL PROTECTED] To: sqlite-users@sqlite.org Sent: Monday, October 16, 2006 1:54 PM Subject: Re: [sqlite] How do i do this UPDATE in SQLite? On Mon, 16 Oct 2006

[sqlite] How do i do this UPDATE in SQLite?

update i set val=qty*q.price from salesrecord i inner join historicalprice q on i.itemid=q.itemid thanks. Radzi.

[sqlite] Terminating long query in C ?

Hi, How do I cancel a long running query? In OLEDB I can call pICommand-Cancel() from a different thread to kill the running query. How can I do the same in SQLite? thanks. Radzi.

Re: [sqlite] Re: Terminating long query in C ?

Thank you guys for the suggestion. That's what I really need. Which one is better, the sqlite3_interrupt() or sqlite3_progress_handler()? My gut feeling is that sqlite3_interrupt() should be better since it does not interfere with the running of the query until it is signaled. Besides, the