[sqlite] Select statement with ORDER BY specified by column value

: SELECT prop_value FROM Table1 WHERE obj_id=10 AND prop_key='key1' AND (prop_tag='ios' OR prop_tag='*') ORDER BY (prop_tag='ios') LIMIT 1; I would like to prioritise results based on the fact that the prop_tag column is 'ios'. Thanks. -- Marco Bambini https://www.sqlabs.com

[sqlite] Bug in sqlite: "View with UNION ALL and limit in subquery" (v 3.28.0)

following output: 1 1 2 * What did go wrong: The second query yields to the output: 1 It seems that the limit clause in the compound select when used inside a view is used for the overall result set and not for the subquery. In the hope that this might help others. Thank you very much for your har

[sqlite] A parser for sqlite databases to implement full ALTER TABLE support

More info at: https://github.com/marcobambini/sqlite-createtable-parser -- Marco Bambini http://www.sqlabs.com http://twitter.com/sqlabs ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman

Re: [sqlite] what is server-process-edition?

So it has nothing to do with which table/row the transaction is modifying? In your example connection 2 always returns with an error on COMMIT? Seems like the improvement is only on when the error occurs and not on concurrency or am I missing something? -- Marco Bambini http://www.sqlabs.com

Re: [sqlite] what is server-process-edition?

Is there a better formal description about the "transactions may not overlap" sentence? Is there any example about overlapping transactions? -- Marco Bambini http://www.sqlabs.com http://twitter.com/sqlabs >> The begin-concurrent branch >> (https://sqlite.org/src/timel

[sqlite] sqlite server-process-edition and begin-concurrent

server-process-edition would be a better option for my case but is the branch still maintained and updated? Are the branches mutually exclusive or can be used both in the same process? -- Marco Bambini http://www.sqlabs.com http://twitter.com/sqlabs

Re: [sqlite] Lazy virtual table creation

Philippe, with a bit of work you can use the authorize api in order to know when an access to a non existing table is performed. https://sqlite.org/c3ref/set_authorizer.html Hope this helps. -- Marco Bambini http://www.sqlabs.com http://twitter.com/sqlabs > On 17 Mar 2018, at 15:53, Phili

[sqlite] Dynamically load all the sqlite functions

with dlsym and once done call dlclose. I noticed that all function prototypes are already defined inside sqlite3ext.h but I wondering if there is a function I could use to all the symbols from the lib without manually process all the function names. Any clue? Thanks. -- Marco Bambini

Re: [sqlite] Testing sqlite db to see if exists & ready

Seems like a good reason to introduce a way to query the existence of a particular pragma command, something like: PRAGMA exists('user_version'); or PRAGMA exists='user_version'; -- Marco Bambini http://www.sqlabs.com http://twitter.com/sqlabs http://instagram.com/sqlabs > On 6 Apr 2017, at

Re: [sqlite] A CTE to count the records (rows) for each table

Excerpts from Richard Hipp's message of 2017-03-13 14:47:49 -0400: > On 3/13/17, Marco Silva <marco.prado...@gmail.com> wrote: > > Hi, > > > > Does anyone knows a Common Table Expression (CTE) to be used with the > > sqlite_master table so we can count for eac

[sqlite] A CTE to count the records (rows) for each table

Hi, Does anyone knows a Common Table Expression (CTE) to be used with the sqlite_master table so we can count for each table how many rows it has. -- Marco Arthur @ (M)arco Creatives ___ sqlite-users mailing list sqlite-users

Re: [sqlite] "Responsive" website revamp at www.sqlite.org

You could just filter by screen size instead of user agent. -- Marco Bambini http://www.sqlabs.com http://twitter.com/sqlabs http://instagram.com/sqlabs > On 06 Sep 2016, at 14:26, Richard Hipp <d...@sqlite.org> wrote: > > On 9/6/16, Nelson, Erik - 2 <erik.l.nel...@bankof

[sqlite] Count connections

Hi, How do we know how many connections a database has ? Is it possible to query it using SQL ? Is there a simple command from the sqlite3 shell client ? -- Marco Arthur @ (M)arco Creatives

[sqlite] CREATE TABLE parser

> On 02 Mar 2016, at 13:32, Luca Ferrari wrote: > > On Wed, Mar 2, 2016 at 1:10 PM, Marco Bambini wrote: >> I developed the parser myself. > > Great job but...what is the aim? > Why one should use this instead of, let's say, Perl SQL::Parser > <http://search.c

[sqlite] CREATE TABLE parser

I developed the parser myself. Here you go a link to the GitHub page: https://github.com/marcobambini/sqlite-createtable-parser -- Marco Bambini http://www.sqlabs.com http://twitter.com/sqlabs http://instagram.com/sqlabs > On 02 Mar 2016, at 11:50, Clemens Ladisch wrote: > > Marc

[sqlite] CREATE TABLE parser

can send me or help me find out some CREATE TABLE sql statements to add to my internal tests? Thanks. -- Marco Bambini http://www.sqlabs.com http://twitter.com/sqlabs http://instagram.com/sqlabs

[sqlite] non-integer rowid/document id

the external content table. > > Any additional thoughts on this from the more knowledgeable? > > enjoy, > > -jeremy > > --? > > Jeremy Hinegarnder > Copious Free Time, LLC -- Marco Arthur @ (M)arco Creatives

[sqlite] Problems making sqlite.lib using Embarcadero C++ 7.00

Solved. At the end I have added the parameter -DSQLITE_THREADSAFE=0 to exclude the multithread code from the library Thank you. Marco -Original Message- From: sqlite-users-bounces at mailinglists.sqlite.org [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On Behalf Of Clemens

[sqlite] Problems making sqlite.lib using Embarcadero C++ 7.00

Hi, could you please give me the full Bcc32 string you are using ? thank you Marco -Original Message- From: sqlite-users-bounces at mailinglists.sqlite.org [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On Behalf Of Clemens Ladisch Sent: Thursday, October 22, 2015 4:22 PM

[sqlite] Problems making sqlite.lib using Embarcadero C++ 7.00

K:\ACTIVEXP\SOURCE\SQLITE.SEE\SQLITE3.LIB|sqlite3 Error: Unable to perform link Marco -Original Message- From: sqlite-users-bounces at mailinglists.sqlite.org [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On Behalf Of R.Smith Sent: Thursday, October 22, 2015 12:12 PM To: sqlite

[sqlite] Problems making sqlite.lib using Embarcadero C++ 7.00

\sqlite_see_2013.Lst TLIB 6.4 Copyright (c) 1987-2014 Embarcadero Technologies, Inc. +K:\sqlite_see_2013\Obj\sqlite3.Obj Any help ? Thank you in advance Marco

[sqlite] Trigger, fetch matching rows and process/insert each row into multiple tables?

ested you: create a new trigger for t2 itself to check on the values inserted. > > Best Regards, > Daniel -- Marco Arthur @ (M)arco Creatives

[sqlite] Trigger, fetch matching rows and process/insert each row into multiple tables?

his to insert into t3. CREATE TRIGGER trigger_on_table_1 AFTER UPDATE OF value ON t1 FOR EACH ROW WHEN NEW.VALUE = 1 AND EXISTS (SELECT id FROM te WHERE ti_id = NEW.id) BEGIN -- SELECT THE ROWS FROM t2 to insert values INSERT INTO t3 VALUES(id, name) SELECT t2.t1_id, 'dummy' FROM t2 WHERE t2.t1_id == NEW.id; END; Then you may wish to set a trigger to t4 itself to handle the newly created t3 rows. -- Marco Arthur @ (M)arco Creatives

[sqlite] System.Data.SQLite encryption

Anyone know which encryption algorithm is used in System.Data.SQLite? Seems like it doesn?t use the standard SEE sqlite extension. Thanks a lot. -- Marco Bambini http://www.sqlabs.com http://twitter.com/sqlabs http://instagram.com/sqlabs

[sqlite] sqlite3session

Is the sqlite3session module still available and supported? If not is there a replacement/workaround for it? Thanks a lot. -- Marco Bambini http://www.sqlabs.com http://twitter.com/sqlabs http://instagram.com/sqlabs

[sqlite] Epoch time with timestamp in ms

sqlite to interpret timestamp in ms? Thanks. -- Marco Bambini http://www.sqlabs.com http://twitter.com/sqlabs http://instagram.com/sqlabs

[sqlite] Mozilla wiki 'avoid SQLite'

reds of > memory leaks that plague FF users > This is going off topic, I'd be happy to digress about this but it's not the right place. If you have suggestions or bugs, the codebase is open and the bug tracker is public, you can reach every single developer through mail or IRC. You have all the tools to make the difference. Marco

[sqlite] Mozilla wiki 'avoid SQLite'

2015-06-15 18:05 GMT+02:00 Jean Chevalier : > What I'm thinking now is to what extent the developer who put up the > Mozilla wiki page was entitled to put up opinions and statements either > expressed or implied about a third-party product on behalf of the Mozilla > Foundation (though is that the

[sqlite] sqlitediff

, nor a link to download the executable from http://www.sqlite.org/sqldiff.html <http://www.sqlite.org/sqldiff.html>. Thanks. -- Marco Bambini http://www.sqlabs.com http://twitter.com/sqlabs http://instagram.com/sqlabs > On 24 May 2015, at 08:59, Luuk wrote: > > On 24-5-2015 08:39

[sqlite] sqlitediff

Where can I download sqlitediff and its source code? Thanks. -- Marco Bambini http://www.sqlabs.com http://twitter.com/sqlabs http://instagram.com/sqlabs

[sqlite] Query help

to replace groupname with * if groupid is 0. Please note that groupid 0 is never written into the Groups table so my original query would return NULL as groupname with groupid is 0 instead of the required "*". Any idea? -- Marco Bambini http://www.sqlabs.com http://twitter.com/sqlabs http://ins

Re: [sqlite] WITHOUT ROWID option

Thanks a lot Richard, I really appreciate. -- Marco Bambini http://www.sqlabs.com http://twitter.com/sqlabs http://instagram.com/sqlabs On 07 May 2014, at 16:31, Richard Hipp <d...@sqlite.org> wrote: > On Wed, May 7, 2014 at 9:00 AM, Marco Bambini <ma...@sqlabs.net> wr

Re: [sqlite] WITHOUT ROWID option

So, is there an official recommended way? or that check should require a manual sql parsing? -- Marco Bambini http://www.sqlabs.com http://twitter.com/sqlabs http://instagram.com/sqlabs On 07 May 2014, at 15:51, Igor Tandetnik <i...@tandetnik.org> wrote: > On 5/7/2014 9:40 AM, RSm

[sqlite] WITHOUT ROWID option

What is the best way to know if a table has been created with the WITHOUT ROWID option? -- Marco Bambini http://www.sqlabs.com http://twitter.com/sqlabs http://instagram.com/sqlabs ___ sqlite-users mailing list sqlite-users@sqlite.org http

[sqlite] sqlite3_analyzer source code

If I remember correctly, sqlite3_analyzer is a python script... I am not able to find its source code since in the download page there is a binary app only. Any help? -- Marco Bambini http://www.sqlabs.com http://twitter.com/sqlabs http://instagram.com/sqlabs

[sqlite] sqlite3session_changeset API oddity

= sqlite3session_changeset(session, , ); pnChangeset is always 0. Is this a bug or something not correctly documented? Please let me know. -- Marco Bambini http://www.sqlabs.com http://twitter.com/sqlabs http://instagram.com/sqlabs ___ sqlite-users mailing list sqlite

[sqlite] Apply a changeset

Documentation is not very clear about this point… in order to apply a change set starting from a session should just I write something like: int rc= sqlite3session_changeset(session, , ); rc = sqlite3changeset_apply (db, pnChangeset, ppChangeset, NULL, NULL, NULL); Is that all? -- Marco Bambini

[sqlite] sqlite3_preupdate functions

? -- Marco Bambini http://www.sqlabs.com http://twitter.com/sqlabs http://instagram.com/sqlabs ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] List of registered tokenizers

What is the correct way to get a list of all registered sqlite tokenizers? Thanks a lot. -- Marco Bambini http://www.sqlabs.com http://twitter.com/sqlabs http://instagram.com/sqlabs ___ sqlite-users mailing list sqlite-users@sqlite.org http

[sqlite] FTS4 search for terms inside a word

* FROM myTable WHERE myColumn LIKE '%super%'; While with the MATCH operator it does not find anything: SELECT * FROM myTable WHERE myColumn MATCH '*super*'; Any help? -- Marco Bambini http://www.sqlabs.com http://twitter.com/sqlabs http://instagram.com/sqlabs

[sqlite] FW:

http://www.horsecenter.com.br/i4jsow.php ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Change a field type

? Thanks in advance Marco ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] sqlite and Mac App Store sandbox

have another solution? Any help? -- Marco Bambini http://www.sqlabs.com http://twitter.com/sqlabs http://instagram.com/sqlabs ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] UTF-8

sqlite API? Please note that since I have access to the sqlite amalgamation source code I could also expose an internal function. Thanks. -- Marco Bambini http://www.sqlabs.com http://twitter.com/sqlabs http://instagram.com/sqlabs ___ sqlite-users maili

Re: [sqlite] Problems (maybe a bug) when creating a backup using the command line interface '.backup' command

) and this version creates a correct backup. Thanks for the fix. -- Regards, Marco ten Thije ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Problems (maybe a bug) when creating a backup using the command line interface '.backup' command

On 01/02/2013 11:03 AM, Marco ten Thije wrote: On 01/02/2013 10:04 AM, Dan Kennedy wrote: What series of commands did you pass to 3.7.5 to create this file? This file was copied from an existing product which uses QT 4.7 libraries to populate the database. I cannot reproduce the exact

Re: [sqlite] Problems (maybe a bug) when creating a backup using the command line interface '.backup' command

used Page 68 is never used Page 73 is never used Page 82 is never used Page 89 is never used Page 91 is never used Page 93 is never used Page 98 is never used Page 99 is never used -- Regards, Marco ten Thije ___ sqlite-users mailing list sqlite-users

Re: [sqlite] Problems (maybe a bug) when creating a backup using the command line interface '.backup' command

2d00 1de2 000d 0004 00e3 7202 2002 070 7301 e300 080 -- Regards, Marco ten Thije ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman

Re: [sqlite] Problems (maybe a bug) when creating a backup using the command line interface '.backup' command

the attachments. Best regards, Marco ten Thije // ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Problems (maybe a bug) when creating a backup using the command line interface '.backup' command

0d 0004 00e3 7202 2002 On 12/21/2012 02:34 PM, Eric Minbiole wrote: Can you please try running "pragma integrity_check;" on the original database? That will give an indication of whether the original database has any data corruption. On Fri, Dec 21, 2012 at 4:13 AM, Marco ten

[sqlite] Problems (maybe a bug) when creating a backup using the command line interface '.backup' command

the database during the backup. Is this a bug or some other problem? -- Regards, Marco ten Thije *Use system engineering bv* Loc: Industriestraat 77 - 7482 EW HAAKSBERGEN - The Netherlands Mail Address: Postbus 236 - 7480 AE

[sqlite] ANN: SQLiteManager 4 - Working with sqlite databases will never be the same!

Hello, we are extremely proud to announce a major release for our SQLiteManager application (available for both MacOS X and Windows). SQLiteManager is a powerful database management system for sqlite databases, it combines an easy to use interface with blazing speed and advanced features.

[sqlite] Write to a View

t I do not understand what if the correct way to perform the operation. Thanks. -- Marco Bambini http://www.sqlabs.com ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] [ANN] SQLiteDoctor

Announcing SQLiteDoctor, the only way to recover your corrupted sqlite databases. Details available from: http://www.sqlabs.com/sqlitedoctor.php -- Marco Bambini http://www.sqlabs.com ___ sqlite-users mailing list sqlite-users@sqlite.org http

Re: [sqlite] Columns involved in a WHERE clause

Can I parse the output of the EXPLAIN my_query statement in order to have an indirect access to columns involved in the WHERE clause? -- Marco Bambini http://www.sqlabs.com http://twitter.com/sqlabs On Sep 21, 2012, at 4:10 PM, Richard Hipp <d...@sqlite.org> wrote: > On Fri, Sep

Re: [sqlite] Columns involved in a WHERE clause

Can I parse the output of the EXPLAIN my_query statement in order to have an indirect access to columns involved in the WHERE clause? -- Marco Bambini http://www.sqlabs.com http://twitter.com/sqlabs On Sep 21, 2012, at 4:10 PM, Richard Hipp <d...@sqlite.org> wrote: > On Fri, Sep

[sqlite] Columns involved in a WHERE clause

Hello, is there a way to extract column names involved in a WHERE clause of a query without manually parse the select statement? For example from a query like: SELECT * FROM myTable WHERE col1=… AND col2=…; I would need to extract both col1 and col2. Thanks. -- Marco Bambini http

[sqlite] Send me your corrupted databases

Hello, can you please send me your corrupted database files? (or put somewhere where I can download them). I am finishing a new sqlite utility and I would like to test it with a lot of different databases. Thanks a lot! -- Marco Bambini http://www.sqlabs.com

[sqlite] app-defined functions, statements and sqlite3_value

sqlite3_bind_value()" and "sqlite3_result_value()" there only for SQL function implementations embedded in the source code of SQLite? So is it better if I do not expose them at the foreign language level? HTH -- Marco Maggi ___ sqlite-

[sqlite] sqlite4 locking and concurrency

Hello, I am wondering if someone is able to provide some details (or directions) about locking and concurrency in sqlite 4. I guess there should be improvements over sqlite 3 but I am looking for information. Thanks. -- Marco Bambini http://www.sqlabs.com

Re: [sqlite] Difference between 3.7.11 and 3.7.13

I am sorry, but it was sent twice for a mistake. -- Marco Bambini http://www.sqlabs.com On Jun 21, 2012, at 2:41 PM, Marco Bambini wrote: > Consider the following example: > > CREATE TABLE t1(x); > CREATE TABLE t2(y); > SELECT max((SELECT avg(x) FROM t2)) FROM t1; > > Wi

[sqlite] Difference between 3.7.11 and 3.7.13

Consider the following example: CREATE TABLE t1(x); CREATE TABLE t2(y); SELECT max((SELECT avg(x) FROM t2)) FROM t1; With sqlite 3.7.11 NULL is returned, while with sqlite 3.7.13 an error "Misuse of aggregate: avg()" is returned. Any thought? -- Marco Bambini http://www.sqlab

[sqlite] Difference between 3.7.11 and 3.7.13

Consider the following example: CREATE TABLE t1(x); CREATE TABLE t2(y); SELECT max((SELECT avg(x) FROM t2)) FROM t1; With sqlite 3.7.11 NULL is returned, while with sqlite 3.7.13 an error "Misuse of aggregate: avg()" is returned. Any thought? -- Marco Bambini http://www.sqlab

Re: [sqlite] sqlite sessions: handling rollbacks

Can you post some code or more details? Sessions has been specifically developed to handle rollbacks so your issue sounds really strange to me. -- Marco Bambini http://www.sqlabs.com On Jun 13, 2012, at 8:57 PM, Charles Samuels wrote: > > I'm using sqlite's sessions module, a

Re: [sqlite] The "sessions" branch

./configure; make sqlite3.c preupdate_hook code is in-line but no sessions related code. -- Marco Bambini http://www.sqlabs.com On Jun 4, 2012, at 4:38 PM, Richard Hipp wrote: > On Mon, Jun 4, 2012 at 10:34 AM, Marco Bambini <ma...@sqlabs.net> wrote: > >> I just tried to

Re: [sqlite] The "sessions" branch

ree/rtree.c keywordhash.h opcodes.c opcodes.h parse.c parse.h config.h sqlite3.h tsrc no ./ext/session/ folder is included. Any help? -- Marco Bambini http://www.sqlabs.com On May 31, 2012, at 9:27 PM, Richard Hipp wrote: > On Thu, May 31, 2012 at 2:55 PM, Charles Samuels <char...@ca

[sqlite] Disable lock control in Sqlite (windows)

without the Sqlite3 internal lock system. So, is there a way to disable the Sqlite locking system (windows) ? As I know this is already available in Sqlite3 unix using the unix-nolock parameter in lib compilation. Thanks in advance Best Regards, Marco

[sqlite] Escape table and column names

about if table name or column name contains that escape character? Do I need to escape it in another way? Please let me know. Thanks a lot. -- Marco Bambini http://www.sqlabs.com ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org

[sqlite] Serialized access faster than multithreaded?

behavior or am I missing something? Thanks in advance. Marco ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Table already exists error code

anks a lot. -- Marco Bambini http://www.sqlabs.com http://twitter.com/sqlabs ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Detailed error code

like also Extended Result Codes do not cover this case. Please help. Thanks let me know. -- Marco Bambini http://www.sqlabs.com ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Visual Studio 2008 Express and sqlite3.c

something confuse the Visual C++ compiler. Any idea? -- Marco Bambini http://www.sqlabs.com On Mar 30, 2012, at 1:08 PM, Nick Shaw wrote: > -Original Message- >> I am trying to compile the latest sqlite 3.7.11 amalgamation C file within a >> Visual Studio 2008 Expr

[sqlite] Visual Studio 2008 Express and sqlite3.c

\sqlite3.c(110555) : error C2059: syntax error : '!' Can someone is able to give me an explanation and a way to fix them? Thanks a lot. -- Marco Bambini http://www.sqlabs.com ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080

[sqlite] Trigger or sql to preserve order

reordering oid within the same pid in case of INSERT, UPDATE and DELETE. Please note that if the trigger is too complicated then I could just execute a smart sql statement every time table foo changes. Anyone have a smart solution? Thanks a lot. -- Marco Bambini http://www.sqlabs.com http://twitter.com

[sqlite] Alter table: number size

Hi all, I need to alter a field from smallint(1) to smallint(2), is there to do this using ALTER TABLE ? Thanks in advance Marco ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite

[sqlite] SQLite extensions repository

Hello, I am wondering if there is there a place that collect all available sqlite extensions. Please let me know. Thanks. -- Marco Bambini http://www.sqlabs.com http://twitter.com/sqlabs ___ sqlite-users mailing list sqlite-users@sqlite.org http

[sqlite] SQLite extensions repository

Hello, I am wondering if there is there a place that collect all available sqlite extensions. Please let me know. Thanks. -- Marco Bambini http://www.sqlabs.com http://twitter.com/sqlabs ___ sqlite-users mailing list sqlite-users@sqlite.org http

[sqlite] Explanation

sqlite 3.7.8 on MacOS X This query works fine: SELECT rowid, * FROM 'customer' WHERE rowid < 100; While this query does not return anything: SELECT rowid, * FROM 'customer' WHERE 'rowid' < 100; Do you have an explanation? -- Marco Bambini http://www.sqlabs.com http://twitter.com/

[sqlite] ANN: SQLiteSync

to the databases or an optional SQL text script can be generated. SQLiteSync is available for both MacOS X and Windows. More information available from: http://www.sqlabs.com/sqlitesync.php Sincerely. -- Marco Bambini http://www.sqlabs.com http://twitter.com/sqlabs

Re: [sqlite] PRAGMA index_info explanation

Thanks a lot Tom, don't know why this email was delivered even today, it was sent yesterday and Dr. Hipp already replied me. Anyway… thanks a lot for your detailed explanation, I really appreciate. -- Marco Bambini http://www.sqlabs.com On Jan 11, 2012, at 4:06 PM, BareFeetWare wrote

[sqlite] PRAGMA index_info explanation

ame of the column being indexed. I am particularly interested in the rank fields … what does rank really means here? Is there a lower/upper bound to this rank value? Thanks a lot. -- Marco Bambini http://www.sqlabs.com http://twitter.com/sql

[sqlite] PRAGMA index_info explanation

ame of the column being indexed. I am particularly interested in the rank fields … what does rank really means here? Is there a lower/upper bound to this rank value? Thanks a lot. -- Marco Bambini http://www.sqlabs.com http://twitter.com/sqlabs ___ sql

Re: [sqlite] sql server management studio like tool for SQLite

Take a look at my SQLiteManager app: http://www.sqlabs.com/sqlitemanager.php -- Marco Bambini http://www.sqlabs.com On Nov 6, 2011, at 7:04 PM, Pete wrote: > Opinions on the best one for OS X? > Pete > > > > > > >> Message: 6 >> Date: Sat, 05 N

Re: [sqlite] System.Data.SQLite Exception with wrong password

On 08/10/2011 01:24, Joe Mistachkin wrote: Marco Cosentino wrote: The ErrorCode is set to "NotADatabase". Wouldn't it more correct if this code is set to something like SQLiteErrorCode.Auth or the Exception is more specialized? The exceptions thrown by System.Data.SQLi

[sqlite] System.Data.SQLite Exception with wrong password

et to something like SQLiteErrorCode.Auth or the Exception is more specialized? Thank you Marco ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Help with SQLite error message

https://discussions.apple.com/message/15712311#15712311 -- Marco Bambini http://www.sqlabs.com On Sep 5, 2011, at 10:46 PM, Lani Gonzales wrote: > Dear Technical Support: > > Please help me remove this error message: > > The procedure entry point sqlite3_wal_c

Re: [sqlite] Need Help! -- SQlite database on server

Please take a look at cubeSQL: http://www.sqlabs.com/cubesql.php -- Marco Bambini http://www.sqlabs.com On Aug 4, 2011, at 7:15 PM, Vinoth raj wrote: > Dear SQLite users, > > I have been using SQlite database since three years. Suddenly I have a > requirement for client/se

[sqlite] Comments

Why this valid statement: CREATE TABLE USER( id text, -- the id of the user nametext-- the name of the user ); gives me a syntax error with sqlite 3.7.6.3? Thanks. -- Marco Bambini http://www.sqlabs.com

Re: [sqlite] year, month & day problem

Works.. Im really sorry for my stupid question, thanks for support and your time, i think that i need an holyday.. Marco Il giorno domenica 17 luglio 2011, Black, Michael (IS) <michael.bla...@ngc.com> ha scritto: > Column numbers are zero-based, not one-based. > > From http://www.s

Re: [sqlite] year, month & day problem

e settings set AAClienti=strftime(\"%Y\", \"now\"), MMClienti=strftime(\"%m\", \"now\"), GGClienti=strftime(\"%d\", \"now\")"]; } -(int) setOrdiniUpdated{ return [self ioSQL:@"update settings set AAOrdini=strftime(\"%Y\"

Re: [sqlite] year, month & day problem

really getting crazy. i know i can close my eyes and invert that commands, but i care my software and i really like to know what im doing wrong.. thx for reply, marco 2011/7/17 John Deal <bassd...@yahoo.com> > Hello, > > I am new and have received much information from this list

[sqlite] year, month & day problem

unning or loading value into XCode simulator looks not working and i dont know why. :'( does anyone can suggest me what to fix or check? thx in advance, marco ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Query help

Thanks a lot Igor, it's perfect now. -- Marco Bambini http://www.sqlabs.com On Jun 12, 2011, at 4:46 PM, Igor Tandetnik wrote: > Marco Bambini <ma...@sqlabs.net> wrote: >> I have a table Clients defined as (simplified version): >> CREATE TABLE Clients (i

Re: [sqlite] Query help

No I am sorry but I need to query the ping_timeout column from inside the same query. -- Marco Bambini http://www.sqlabs.com On Jun 12, 2011, at 2:02 PM, Roger Andersson wrote: > On 06/12/11 01:52 PM, Marco Bambini wrote: >> things are recently changed in my app and ping_timeo

[sqlite] Query help

seconds', 'localtime');", settings.ping_timeout); using just the ping_timeout column in the Clients table instead of the settings.ping_timeout global property. Any idea? -- Marco Bambini http://www.sqlabs.com ___ sqlite-users mailing li

Re: [sqlite] How to know the offset of a rowid inside a table?

Thanks Martin and Richard, solution was so simple that I think to need a time break today. Should I add an ORDER BY rowid clause at the end of the SELECT statement or its implicit by the WHERE clause? Thanks a lot. -- Marco Bambini http://www.sqlabs.com On Jun 8, 2011, at 4:27 PM

[sqlite] How to know the offset of a rowid inside a table?

by 1 but I am quite sure that should be a more elegant way. Thanks a lot. -- Marco Bambini http://www.sqlabs.com ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Proper way to escape table name and column name

What is the official way to escape table name that contains a space and column name that contain a spaces? Thanks a lot. -- Marco Bambini http://www.sqlabs.com ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin

[sqlite] SEE encryption lib and odbc

Hi all, We are successfully using the SEE module in Sqlite. All runs well but we need to provide a ODBC connection to a limited number of users. Question: is there a Sqlite odbc driver SEE compatible ? Thanks. Regards, Marco Turco IT Business Devl Manager Software XP LLP

[sqlite] [ANN] cubeSQL

starts at $299 USD. For more information, please visit the SQLabs website: http://www.sqlabs.com -- Marco Bambini http://www.sqlabs.com ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

  1   2   3   >