[sqlite] non-integer rowid/document id

2015-12-31 Thread Marco
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] Trigger, fetch matching rows and process/insert each row into multiple tables?

2015-09-24 Thread Marco
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] Trigger, fetch matching rows and process/insert each row into multiple tables?

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

Re: [sqlite] IS there some way of viewing an SQLite Database?

2006-11-04 Thread marco
is there some other way of viewing an SQLite database? > TIA!! You can try SQLiteManager: http://www.sqlabs.net/sqlitemanager.php Regards, Marco Bambini SQLabs - To unsubscribe, send email to [EMAIL PROTECTED] -

[sqlite] DELETE with 64bit unsigned integer key

2010-09-29 Thread Marco
lve this issue? Thank you, Marco ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] FW:

2013-04-26 Thread marco
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] Functions

2005-02-24 Thread marco
Hi *, Where I can find the list of the internal functions? for example: datetime() strftime() tks -- Marco Antonio J. Victor Fone: 11 6977-5406 Fax: 11 6973-9772 www.tactor.com.br

[sqlite] Questions

2005-02-24 Thread marco
Hi *, Where I can find the list of the internal functions? for example: datetime() strftime() Where I find the documentation on as I can make in agreement INSERT/UPDATE the type of column (BOOLEAN/DATE) tks -- Marco Antonio J. Victor Fone: 11 6977-5406 Fax: 11 6973-9772 www.tactor.com.br

[sqlite] Detailed error code

2012-04-14 Thread marco
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

[sqlite] Escape table and column names

2012-05-16 Thread marco
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] System.Data.SQLite encryption

2015-08-06 Thread Marco Bambini
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

2015-07-29 Thread Marco Bambini
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] Mozilla wiki 'avoid SQLite'

2015-06-16 Thread Marco Bonardo
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] Mozilla wiki 'avoid SQLite'

2015-06-16 Thread Marco Bonardo
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] Epoch time with timestamp in ms

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

[sqlite] Query help

2015-03-23 Thread Marco Bambini
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

[sqlite] sqlite3_preupdate functions

2014-01-03 Thread Marco Bambini
? -- 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] Apply a changeset

2014-01-03 Thread Marco Bambini
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] sqlite3session_changeset API oddity

2014-01-05 Thread Marco Bambini
= 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] sqlite3_analyzer source code

2014-04-15 Thread Marco Bambini
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] WITHOUT ROWID option

2014-05-07 Thread Marco Bambini
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

Re: [sqlite] WITHOUT ROWID option

2014-05-07 Thread Marco Bambini
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

Re: [sqlite] WITHOUT ROWID option

2014-05-07 Thread Marco Bambini
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

[sqlite] Disable lock controls on Windows

2011-04-12 Thread Marco Turco
he locking method from myself using a semaphone file. Any suggest ? Thanks in advance. Regards, Marco Turco IT Business Devl Manager Software XP LLP ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailma

Re: [sqlite] vacuum and rowids

2011-04-29 Thread Marco Bambini
Dave please take a look at this blog post: http://www.sqlabs.com/blog/?p=51 -- Marco Bambini http://www.sqlabs.com On Apr 28, 2011, at 9:36 PM, Dave Hayden wrote: > When the VACUUM feature was added I took a look at using it to keep database > file sizes down, but disc

Re: [sqlite] Using SQLite with R*Tree and FTS3 support in iOS

2011-05-16 Thread Marco Bambini
4.3 MB seems really too big... you are probably building a debug version of the library. -- Marco Bambini http://www.sqlabs.com On May 16, 2011, at 5:01 PM, Tito Ciuro wrote: > Hello, > > I have a question about SQLite running on iOS. If I'm not mistaken, SQLite on > iOS is

[sqlite] [ANN] cubeSQL

2011-05-24 Thread Marco Bambini
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

[sqlite] SEE encryption lib and odbc

2011-05-24 Thread Marco Turco
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] Proper way to escape table name and column name

2011-06-06 Thread Marco Bambini
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] How to know the offset of a rowid inside a table?

2011-06-08 Thread Marco Bambini
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

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

2011-06-08 Thread Marco Bambini
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] Query help

2011-06-12 Thread Marco Bambini
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] Query help

2011-06-12 Thread Marco Bambini
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

Re: [sqlite] Query help

2011-06-12 Thread Marco Bambini
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

[sqlite] year, month & day problem

2011-07-17 Thread marco bianchini
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] year, month & day problem

2011-07-17 Thread marco bianchini
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

Re: [sqlite] year, month & day problem

2011-07-17 Thread marco bianchini
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

2011-07-17 Thread marco bianchini
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

[sqlite] Comments

2011-08-01 Thread Marco Bambini
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] Need Help! -- SQlite database on server

2011-08-05 Thread Marco Bambini
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

Re: [sqlite] Help with SQLite error message

2011-09-06 Thread Marco Bambini
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

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

2011-10-06 Thread Marco Cosentino
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] System.Data.SQLite Exception with wrong password

2011-10-08 Thread Marco Cosentino
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

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

2011-11-06 Thread Marco Bambini
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

[sqlite] sqlitediff

2015-05-24 Thread Marco Bambini
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] sqlitediff

2015-05-24 Thread Marco Bambini
, 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] Problems making sqlite.lib using Embarcadero C++ 7.00

2015-10-22 Thread Marco Turco
\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] Problems making sqlite.lib using Embarcadero C++ 7.00

2015-10-22 Thread Marco Turco
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

2015-10-22 Thread Marco Turco
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

2015-10-22 Thread Marco Turco
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] CREATE TABLE parser

2016-03-02 Thread Marco Bambini
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] CREATE TABLE parser

2016-03-02 Thread Marco Bambini
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

2016-03-02 Thread Marco Bambini
> 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] Count connections

2016-05-10 Thread Marco Silva
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] sqlite3_rowid

2007-04-13 Thread Marco Bambini
-archive.com/[EMAIL PROTECTED]/msg19341.html Anyone have tested it? Is there something else available? Thanks a lot. --- Marco Bambini - To unsubscribe, send email to [EMAIL PROTECTED] -

[sqlite] Optimize a query

2007-04-17 Thread Marco Bambini
segments_content on segments (content) CREATE INDEX segments_public on segments (public) CREATE INDEX segments_report_id on segments (report_id) CREATE INDEX segments_type on segments (type) CREATE INDEX segments_user_id on segments (user_id) Thanks a lot, --- Marco Bambini

[sqlite] An explanation?

2007-04-23 Thread Marco Bambini
is about two times slower, it takes 0.463 secs. (I know that only one index is used by the query). I repeated the test several times and results are confirmed... Anyone have an explanation? --- Marco Bambini

Re: [sqlite] An explanation?

2007-04-23 Thread Marco Bambini
Yes, I know that it is faster ... I just wonder why with one index the query is slower that without any index... --- Marco Bambini On Apr 23, 2007, at 6:31 PM, P Kishor wrote: On 4/23/07, Marco Bambini <[EMAIL PROTECTED]> wrote: As a performance test I created a db with 300,000 r

Re: [sqlite] An explanation?

2007-04-23 Thread Marco Bambini
index2 ON table1(b); --- Marco Bambini On Apr 23, 2007, at 9:36 PM, [EMAIL PROTECTED] wrote: Marco Bambini <[EMAIL PROTECTED]> wrote: Yes, I know that it is faster ... I just wonder why with one index the query is slower that without any index... Probably because most of the entries i

Re: [sqlite] An explanation?

2007-04-24 Thread Marco Bambini
Thanks a lot for the explanation Dennis, I really appreciate. --- Marco On Apr 24, 2007, at 12:35 AM, Dennis Cote wrote: Marco Bambini wrote: Database is uniformly distributed, I created it ad hoc just for my test (sqlite 3.3.12): Marco, Another way to think of this is that if your

Re: [sqlite] Concurrency

2007-06-01 Thread Marco Bambini
Why you said less than 29? --- Marco Bambini http://www.sqlabs.net http://www.sqlabs.net/blog/ http://www.sqlabs.net/realsqlserver/ On Jun 1, 2007, at 6:56 PM, Eduardo Morras wrote: At 11:17 01/06/2007, you wrote: Hi, I am having a scenario where I have one reader/writer and many writer

Re: [sqlite] Get the data from previous months: please, help me to optimize the query...

2007-07-16 Thread Marco NOVARO
a in 200ms, that is really good (compared to the one before). Thanks again Marco 2007/7/13, Joe Wilson <[EMAIL PROTECTED]>: --- Christian Smith <[EMAIL PROTECTED]> wrote: > > Much faster - add 3 new fields in CustomerData which you can populate > > via SQLite's trigge

Re: [sqlite] fts2 in the amalgamation source?

2007-07-27 Thread Marco Bambini
works fine and I was able to compile it. Hope this help. --- Marco Bambini http://www.sqlabs.net http://www.sqlabs.net/blog/ http://www.sqlabs.net/realsqlserver/ On Jul 26, 2007, at 4:41 PM, [EMAIL PROTECTED] wrote: "David Crawshaw" <[EMAIL PROTECTED]> wrote: Hello all,

Re: [sqlite] Proposed incompatible change to SQLite

2007-08-09 Thread Marco Bambini
We'll be more than happy with a change like that. --- Marco Bambini http://www.sqlabs.net http://www.sqlabs.net/blog/ http://www.sqlabs.net/realsqlserver/ On Aug 9, 2007, at 5:37 PM, [EMAIL PROTECTED] wrote: We are considering a change to the SQLite API which is technically not backwards

Re: [sqlite] Towards SQLite version 3.5.0

2007-08-28 Thread Marco Bambini
a concept of a NULL pointer. Dennis Cote Just pass 0 in that case. --- Marco Bambini http://www.sqlabs.net http://www.sqlabs.net/blog/ http://www.sqlabs.net/realsqlserver/ - To unsubscribe, send email to [EMAIL PROTECTED] -

[sqlite] Advice about a trigger

2007-10-04 Thread Marco Bambini
, operation) VALUES (old.rowid, "sql", "table1", 1); END The missing field is "sql" ... do you have a smart idea to solve my problem? Thanks. --- Marco Bambini http://www.sqlabs.net http://www.sqlabs.net/blog/ http:

Re: [sqlite] Advice about a trigger

2007-10-04 Thread Marco Bambini
I know John, obviously "sql" should be replaced with a way to get the original sql statement that created that row. My question was is there is some smart way to retrieve it... --- Marco Bambini http://www.sqlabs.net http://www.sqlabs.net/blog/ http://www.sqlabs.net/realsqlserver/

[sqlite] sqlite3_update_hook

2007-10-17 Thread Marco Bambini
Hi, with sqlite3_update_hook I can get the rowid of the row AFTER it has been INSERTed, DELETEd or UPDATEd. Is there a way to get the rowid of a row BEFORE it is DELETEd or UPDATEd ? If not, can someone suggest a good approach to this problem? Thanks a lot, --- Marco Bambini http

Re: [sqlite] sqlite3_update_hook

2007-10-18 Thread Marco Bambini
Thanks Dennis for your reply. I would like to avoid triggers for performance reasons. I haven't found an official solution so I am implementing my own sqlite3_update_notify API that is executed before the operation takes place. --- Marco Bambini http://www.sqlabs.net http://www.sqlabs.net

Re: [sqlite] Re: Custom functions and *

2007-10-18 Thread Marco Bambini
I need to create a custom function that returns all the value from that row. If the * syntax was supported then I don't need to save or retrieve all the column's name for that table. --- Marco Bambini http://www.sqlabs.net http://www.sqlabs.net/blog/ http://www.sqlabs.net/realsqlserver

Re: [sqlite] Re: Custom functions and *

2007-10-18 Thread Marco Bambini
Thanks a lot Joe, I'll take a look at that. --- Marco Bambini http://www.sqlabs.net http://www.sqlabs.net/blog/ http://www.sqlabs.net/realsqlserver/ On Oct 18, 2007, at 7:05 PM, Joe Wilson wrote: --- Marco Bambini <[EMAIL PROTECTED]> wrote: I need to create a custom function that r

[sqlite] Strange error in sqlite 3.4.2 Win32 version

2007-10-30 Thread Marco Bambini
b2 = 100 and b3 = 101" ) I wonder if there was a bug in the 3.4.2 version that I should fix... Please note that I cannot upgrade to the latest 3.5.x versions... Thanks a lot. --- Marco Bambini http://www.sqlabs.net http://www.sqlabs.net/blog/ http://www.sqlabs.net/realsqlserver/

Re: [sqlite] Proposed sqlite3_initialize() interface

2007-10-30 Thread Marco Bambini
I think that sqlite3_initialize should be allowed to be called more than once. With the help of a static flag, only the first time it is executed the proper initialize functions will be invoked, successive calls to the sqlite3_initialize should just be a NOP operation... --- Marco Bambini

Re: [sqlite] Strange error in sqlite 3.4.2 Win32 version

2007-10-31 Thread Marco Bambini
lt); // close db sqlite3_close(db); printf("simple test finished!\n"); return 0; abort: printf("%s\n", sqlite3_errmsg(db)); if (db != NULL) sqlite3_close(db); return -1; } On Windows (not on Mac!) it returns 99

Re: [sqlite] Strange error in sqlite 3.4.2 Win32 version

2007-10-31 Thread Marco Bambini
No, the database is created by the code it doesn't already exists. I was able to reproduce the issue only on Windows, Mac and Linux worked fine. --- Marco Bambini http://www.sqlabs.net http://www.sqlabs.net/blog/ http://www.sqlabs.net/realsqlserver/ On Oct 31, 2007, at 10:25 AM, Stephan

Re: [sqlite] Strange error in sqlite 3.4.2 Win32 version

2007-10-31 Thread Marco Bambini
Hmm ... I was using CodeWarrior for Windows ... maybe its time to upgrade --- Marco Bambini http://www.sqlabs.net http://www.sqlabs.net/blog/ http://www.sqlabs.net/realsqlserver/ On Oct 31, 2007, at 12:14 PM, Dan Petitt wrote: I compiled up your code and ran it on Windows using VC6

Re: [sqlite] Strange error in sqlite 3.4.2 Win32 version

2007-10-31 Thread Marco Bambini
The problem was somewhere inside CodeWarrior because the same exact code worked fine with Visual C. I used CodeWarrior for Win for all my win32 sqlite compilation but it seems time to update my Win Dev environment... --- Marco Bambini http://www.sqlabs.net http://www.sqlabs.net/blog/ http

Re: [sqlite] Strange error in sqlite 3.4.2 Win32 version

2007-11-01 Thread Marco Bambini
is still 99... --- Marco Bambini http://www.sqlabs.net http://www.sqlabs.net/blog/ http://www.sqlabs.net/realsqlserver/ On Oct 31, 2007, at 10:38 PM, Joe Wilson wrote: You're not the least bit interested in finding out what the issue in CodeWarrior was? It might be a symptom of another problem

Re: [sqlite] Suggests for improving the SQLite website

2007-11-09 Thread Marco Bambini
Another solution is to design your css for standard browser and then just create a iefixes.css file to load only in IE that contains the various fixes for that browser. The trick is to add that lines in the head section: --- Marco Bambini http://www.sqlabs.net http://www.sqlabs.net/blog

Re: [sqlite] Suggests for improving the SQLite website

2007-11-09 Thread Marco Bambini
I vote for (4). --- Marco Bambini http://www.sqlabs.net http://www.sqlabs.net/blog/ http://www.sqlabs.net/realsqlserver/ On Nov 9, 2007, at 7:45 PM, [EMAIL PROTECTED] wrote: "Mark Wyszomierski" <[EMAIL PROTECTED]> wrote: Not a terribly useful comment but was just glancing

[sqlite] UNION and ORDER BY errors starting from sqlite 3.4.2

2007-12-03 Thread Marco Bambini
are created by: CREATE TABLE a (field); CREATE TABLE b (field); Please note that the above queries worked fine with sqlite 3.2.x or 3.3.x. Any idea? --- Marco Bambini http://www.sqlabs.net http://www.sqlabs.net/blog/ http://www.sqlabs.net/realsqlserver

Re: [sqlite] How to get record count

2007-12-12 Thread Marco Bambini
SELECT count(*) FROM myTable; --- Marco Bambini http://www.sqlabs.net http://www.sqlabs.net/blog/ http://www.sqlabs.net/realsqlserver/ On Dec 12, 2007, at 2:55 PM, Tom Parke wrote: How can I get a count of the number of records in a table? Sqlite3_get_table() might work, but I only need

Re: [sqlite] Next Version of SQLite

2008-01-13 Thread Marco Bambini
What will be the main benefits of the new virtual machine? I mean, it will be just faster or there will be other improvements in the library? --- Marco Bambini http://www.sqlabs.net http://www.sqlabs.net/blog/ http://www.sqlabs.net/realsqlserver/ On Jan 13, 2008, at 3:07 AM, D. Richard

Re: [sqlite] Version 3.5.5 Released

2008-01-31 Thread Marco Bambini
What about speed? Can we expect the same performance of version 3.5.4? Thanks a lot for your continue improvements. --- Marco Bambini http://www.sqlabs.net http://www.sqlabs.net/blog/ http://www.sqlabs.net/realsqlserver/ On Jan 31, 2008, at 6:33 PM, [EMAIL PROTECTED] wrote: SQLite version

[sqlite] sqlite 3.5.5 and SQLITE_ENABLE_LOCKING_STYLE=1

2008-02-04 Thread Marco Bambini
It is safe to define SQLITE_ENABLE_LOCKING_STYLE=1 with sqlite 3.5.5 if I am interested in opening database files on a shared volumes on Mac? As far as I know it was the only workaround ... or something is changed in recent versions? Thanks. --- Marco Bambini http://www.sqlabs.net http

Re: [sqlite] speed of ORDER BY clause?

2006-06-14 Thread Marco Bambini
Have you tried to create an indexed? Have you tried to analyze your query with SQLiteManager in order to see which indexes are used? --- Marco Bambini http://www.sqlabs.net http://www.sqlabs.net/blog/ On Jun 14, 2006, at 5:56 PM, [EMAIL PROTECTED] wrote: I'm finding that ORDER

[sqlite] Borland DbExpress SQLite 3.3.6 Driver

2006-07-04 Thread Marco Wobben
Finally I've found the time and courage to upgrade the code from SQLite2 to SQLite3. For Delphi 6 a new DbxExpress driver is available. For a few $s you can purchase the sources and support maintenance for newer versions. You may download at http://www.bcp-software.nl Regards, Marco.

[sqlite] SQLite DbExpress Update

2006-07-31 Thread Marco Wobben
For the Borland DbExpress driver I've fixed the support for turning on and off the pragma setting for FullName. Download your registered sources or binaries from the known urls. Regards, Marco Wobben. http://www.bcp-software.nl

[sqlite] [ANN] SQLiteManager 2.1.4

2006-08-11 Thread Marco Bambini
VIADANA, Italy (August 11, 2006) - SQLabs today announced the availability of SQLiteManager 2.1.4, their new SQLite database manager tool for MacOS X and Windows. SQLiteManager is a "next generation" GUI database manager for sqlite databases, it combines an incredible easy to use interface

Re: [sqlite] Database on usbstick

2006-09-05 Thread Marco Radaelli
To try is the core of each science ;) Above all it's the core of Computer Science :) --- eWobbuh <[EMAIL PROTECTED]> ha scritto: > > Havent try it yet, just wondering if its possible. > Do you know how you tell > sqlite where to find a database? havent worked > before with it.. only with >

[sqlite] Select ignoring accents

2006-10-12 Thread Marco Bambini
I need to find out a way to search all the records inside an sqlite database ignoring accents and case. So for example with a "select" I would like to find: Aero àero Aéro Ignoring case is the easy part, what about accents? Thanks a lot for your help. --- Mar

Re: [sqlite] Q about new SQLite API

2006-11-07 Thread Marco Bambini
an SQLITE_ROW is returned. 3. SQLITE_SCHEMA --- Marco Bambini http://www.sqlabs.net http://www.sqlabs.net/blog/ http://www.sqlabs.net/realsqlserver/ - To unsubscribe, send email to [EMAIL PROTECTED] -

Re: [sqlite] Re: Q about new SQLite API

2006-11-07 Thread Marco Bambini
sure this is true for a lot of other developers). --- Marco Bambini http://www.sqlabs.net http://www.sqlabs.net/blog/ http://www.sqlabs.net/realsqlserver/ On Nov 7, 2006, at 4:14 PM, Igor Tandetnik wrote: Marco Bambini <[EMAIL PROTECTED]> wrote: 2. maybe with the new sqlite3_compile r

Re: [sqlite] question about search string

2006-11-15 Thread Marco Radaelli
Try SELECT * FROM mytable where 'c:\\Program Files\\a.exe' like '%command%' --- Florin Serbanescu <[EMAIL PROTECTED]> ha scritto: > Hello, > > I have a string that contains a full path of a file > for example. Also I have a table in Sqlite that > contains a column name 'command' that has only

Re: [sqlite] question about search string

2006-11-15 Thread Marco Radaelli
Nevermind, I'm wrong. --- Marco Radaelli <[EMAIL PROTECTED]> ha scritto: > Try > > SELECT * FROM mytable where 'c:\\Program > Files\\a.exe' > like '%command%' > > > --- Florin Serbanescu <[EMAIL PROTECTED]> ha > scritto: > > > Hello, &g

Re: [sqlite] When to release version 3.3.10?

2007-01-05 Thread Marco Bambini
in my opinion you should release it as soon as possible, a lot of people haven't yet upgraded their library to the latest 3.3.9 so it seems reasonable to me to upgrade directly to 3.3.10. --- Marco Bambini http://www.sqlabs.net http://www.sqlabs.net/blog/ http://www.sqlabs.net/realsqlserver

[sqlite] Locking support for remote databases with Mac OSX

2007-01-09 Thread Marco Bambini
is: What I should do in order to compile an sqlite library that supports locking for remote databases with Mac OSX? Thanks a lot, --- Marco Bambini http://www.sqlabs.net http://www.sqlabs.net/blog/ http://www.sqlabs.net/realsqlserver

[sqlite] SQLITE_ENABLE_LOCKING_STYLE

2007-01-13 Thread Marco Bambini
of setting it to 1? Thanks a lot. --- Marco Bambini http://www.sqlabs.net http://www.sqlabs.net/blog/ http://www.sqlabs.net/realsqlserver/ - To unsubscribe, send email to [EMAIL PROTECTED] -

[sqlite] [ANN] SQLiteManager 2.5

2007-01-16 Thread Marco Bambini
VIADANA, Italy (January 16, 2007) - SQLabs today announced the availability of SQLiteManager 2.5, their new SQLite database manager tool for MacOS X and Windows. SQLiteManager is a "next generation" GUI database manager for sqlite databases, it combines an incredible easy to use interface

Re: [sqlite] Obtaining randomness on win32

2007-01-29 Thread Marco Bambini
I really think that this article http://eternallyconfuzzled.com/arts/jsw_art_rand.aspx worths a read. It talks about the general rand function and the problem of distribution... --- Marco Bambini http://www.sqlabs.net http://www.sqlabs.net/blog/ http://www.sqlabs.net/realsqlserver/ On Jan

  1   2   3   >