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

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

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] Functions

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

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

w in t3 to the > corresponding row in t2 may try this 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?

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

[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] 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

[sqlite] Escape table and column names

What 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://sqlit

[sqlite] non-integer rowid/document id

fts5 table, I might as well use use 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

Re: [sqlite] Causes of SQLITE_SCHEMA errors

Are you using sqlite_prepare or sqlite_prepare_v2? If you use the v2 version I think that your problem will be solved... Regards, --- Marco Bambini http://www.sqlabs.net http://www.sqlabs.net/blog/ http://www.sqlabs.net/realsqlserver/ On Mar 6, 2007, at 2:22 PM, Ian Frosst wrote: Hey all

Re: [sqlite] I Need database fot some test

The space between Order and Details is the problem. This syntax: SELECT * FROM [Order Details] works fine with SQLiteManager. Regards, --- Marco Bambini http://www.sqlabs.net http://www.sqlabs.net/blog/ http://www.sqlabs.net/realsqlserver/ On Mar 7, 2007, at 7:43 PM, Stef Mientki wrote

[sqlite] sqlite3_rowid

-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

ser_id) CREATE INDEX 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 lo

[sqlite] An explanation?

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 - To

Re: [sqlite] An explanation?

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?

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?

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

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...

ot the data 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 SQLit

Re: [sqlite] fts2 in the amalgamation source?

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, I

Re: [sqlite] Proposed incompatible change to SQLite

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 back

Re: [sqlite] Towards SQLite version 3.5.0

ave 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

, 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

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

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

[sqlite] Custom functions and *

like: SELECT myfunction(*) FROM table1 WHERE ... but when myfunction is executed the argc parameter is set to 0. Is the * syntax supported in custom sqlite3 functions? --- Marco Bambini http://www.sqlabs.net http://www.sqlabs.net/blog/ http://www.sqlabs.net/realsqls

Re: [sqlite] sqlite3_update_hook

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.sqlab

Re: [sqlite] Re: Custom functions and *

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/rea

Re: [sqlite] Re: Custom functions and *

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 t

[sqlite] SQL logic error or missing database

gic error or missing database (printed with sqlite3_errmsg). Any explanation of the possible causes for the missed rows? Thanks. -- Marco Bambini ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQL logic error or missing database

Thanks a lot for the explanation Igor. -- Marco Bambini On May 14, 2009, at 1:55 PM, Igor Tandetnik wrote: > "Marco Bambini" wrote > in message news:aa7dd05f-4679-43dd-9dd3-2ba6b98af...@sqlabs.net >> I have two threads that are writing 2000 rows each to the same &

Re: [sqlite] most efficient way to get 1st row

SELECT ... LIMIT 1; -- Marco Bambini http://www.sqlabs.com http://www.creolabs.com/payshield/ On May 19, 2009, at 5:03 PM, Sam Carleton wrote: > I am far from a SQL expert, but I am 99.9% sure there is SQL syntax > to limit > the number of results, I have not looked it up but

[sqlite] Why row is not found?

Anyone can please explain me why this query: SELECT * FROM lo_user WHERE lo_name='admin'; returns 0 rows in this db? Thanks. -- Marco Bambini http://www.sqlabs.com http://www.creolabs.com/payshield/ ___ sqlite-users mailing list sq

Re: [sqlite] Why row is not found?

You can download the db from: http://www.sqlabs.com/download/test.sqlite It's only 4KB. -- Marco Bambini http://www.sqlabs.com http://www.creolabs.com/payshield/ On Jun 5, 2009, at 11:04 AM, Marco Bambini wrote: > Anyone can please explain me why this query: > SELECT * FROM lo

Re: [sqlite] Why row is not found?

I just posted the db on my website... there is one row and there aren't invisible characters. Please note that the following query returns the exact row: SELECT * FROM lo_user WHERE CAST(lo_name AS TEXT)='admin'; but I really don't have an explanation... -- Marco Bambini h

Re: [sqlite] Why row is not found?

I understand that the issue could be caused by the wrong datatype... but what is strange is that the same db and the same query worked fine with sqlite 3.4.2 and the behavior changed with sqlite 3.6.x -- Marco Bambini http://www.sqlabs.com http://www.creolabs.com/payshield/ On Jun 5

Re: [sqlite] Why row is not found?

Hello Martin, it's a db than an user sent me... so I really don't know... -- Marco Bambini http://www.sqlabs.com http://www.creolabs.com/payshield/ On Jun 5, 2009, at 11:31 AM, Martin Engelschalk wrote: > Hi Marco, > > How do you insert this data into your databa

[sqlite] [ANN] SQLiteManager 3.0

VIADANA, Italy (June 24, 2009) - SQLabs is proud to announce today the worldwide availability of SQLiteManager 3.0, the most powerful sqlite database manager tool for MacOS X and Windows. SQLiteManager is a "next generation" GUI database manager for sqlite databases. It combines an incredibl

Re: [sqlite] translating CSV file into sqlite3 database for iPhone?

Have you tried my SQLiteManager app? http://www.sqlabs.com/sqlitemanager.php It can easily convert/import your CSV file into an sqlite3 database. -- Marco Bambini http://www.sqlabs.com http://www.creolabs.com/payshield/ On Aug 7, 2009, at 4:57 PM, Adam DeVita wrote: > This is wh

[sqlite] Explanation

possible explanation? Thanks. -- Marco Bambini http://www.sqlabs.com http://www.creolabs.com/payshield/ ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Explanation

Library is statically linked into the final app and the db is newly created... -- Marco Bambini http://www.sqlabs.com http://www.creolabs.com/payshield/ On Aug 28, 2009, at 5:17 PM, Mike Eggleston wrote: > On Fri, 28 Aug 2009, Marco Bambini might have said: > >> Hello, >&g

Re: [sqlite] Explanation

Yes, you are right (as always). Time with SQLITE_THREADSAFE=0 is about 4.33 seconds now. Thanks a lot. -- Marco Bambini http://www.sqlabs.com http://www.creolabs.com/payshield/ On Aug 28, 2009, at 5:23 PM, D. Richard Hipp wrote: > > On Aug 28, 2009, at 11:17 AM, Mike Eggleston

Re: [sqlite] Viewer for blobs in hex?

Hello Yan, you could use my SQLiteManager application: http://www.sqlabs.com/sqlitemanager.php Regards, -- Marco Bambini http://www.sqlabs.com http://www.creolabs.com/payshield/ On Sep 21, 2009, at 9:43 AM, Yan Bertrand wrote: >Hi all, > > > > I would like

[sqlite] sqlite3_column_name

sqlite 3.6.19 CREATE TABLE foo (col1 INTEGER PRIMARY KEY, col2 TEXT); a SELECT rowid, col1, col2 returns the following column names with sqlite3_column_name: col1, col1, col2 Is there a way to force the first column name to be returned as rowid and not as its col1 alias? Thanks. -- Marco

Re: [sqlite] sqlite3_column_name

Unfortunately I cannot modify the query... it is supplied by an user. -- Marco Bambini http://www.sqlabs.com http://www.creolabs.com/payshield/ On Nov 13, 2009, at 3:10 PM, Virgilio Fornazin wrote: > SELECT > field as NAME > > does not work? > > On Fri, Nov 13, 20

[sqlite] Strange error in sqlite 3.4.2 Win32 version

OM One WHERE b1 = 99 AND 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.ne

Re: [sqlite] Proposed sqlite3_initialize() interface

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

query test 1 rc = sqlite3_get_table(db, "SELECT a FROM One WHERE b1 = 99 AND b2 = 100 and b3 = 101;", &result, &nrow, &ncol, NULL); if (rc != SQLITE_OK) goto abort; for(i=0; ihttp://www.sqlabs.net http://www.sqlabs.net/blog/ http://www.sqlabs.

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

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, St

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

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

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

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 pr

Re: [sqlite] Suggests for improving the SQLite website

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

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

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

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 the

Re: [sqlite] Next Version of SQLite

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

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

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] Transaction log writing performance

mprovement on MacOS X. So, is safe so to set PRAGMA synchronous=NORMAL; under MacOS X? It would be really nice to know under which modern file system it is safe to skip 3 and 4. --- Marco Bambini http://www.sqlabs.net http://www.sqlabs.net/blog/ http://www.sqlabs.net/realsqlserver/ ___

Re: [sqlite] [Delphi7] TEXT vs. (VAR)CHAR?

n any case it is the Connector or Driver on top of SQLite which determines the actual field type into the component layer of Delphi. This is what the DbExpress driver is supposed to do, translate the database specifics into Delphi specifics (and ba

Re: [sqlite] Malformed database schema with SQLite version > 3.5.x

Yes, of course I can send you the DB: the file is under 1MB, about 100K if compressed via .zip Can I send it to you via e-mail? Thanks very much for the support ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/l

[sqlite] Available extensions for sqlite

Is there a repository that collects a list of available extensions for sqlite? Until now I found just an extension: http://www.gaia-gis.it/spatialite/ Thanks. --- Marco Bambini http://www.sqlabs.net http://www.sqlabs.net/blog/ http://www.sqlabs.net/realsqlserver

Re: [sqlite] how to select uncomitted rows?

. --- Marco Bambini http://www.sqlabs.net http://www.sqlabs.net/blog/ http://www.sqlabs.net/realsqlserver/ On Apr 17, 2008, at 9:43 PM, Alex Katebi wrote: > The reason I did not keep track in a seperate table was because I > wanted to > do it using triggers. But triggers don't trigge

Re: [sqlite] String is changing after inserting into database

Is your database UTF-16 encoded? More information at: http://www.sqlite.org/pragma.html PRAGMA encoding section. --- Marco Bambini http://www.sqlabs.net http://www.sqlabs.net/blog/ http://www.sqlabs.net/realsqlserver/ On Apr 18, 2008, at 8:37 AM, Harish Dixit wrote: > Hello, >

Re: [sqlite] Comparison of SQLite applications for Mac

Please take a look also at my SQLiteManager app: http://www.sqlabs.net/sqlitemanager.php --- Marco Bambini http://www.sqlabs.net http://www.sqlabs.net/blog/ http://www.sqlabs.net/realsqlserver/ On May 8, 2008, at 8:56 AM, Neville Franks wrote: > Hi Hartwig, > The last release for this w

Re: [sqlite] Max limits on the following

http://www.sqlite.org/limits.html --- Marco Bambini http://www.sqlabs.net http://www.sqlabs.net/blog/ http://www.sqlabs.net/realsqlserver/ On Jun 23, 2008, at 8:55 AM, Shailesh Birari wrote: > Hello all, > I wanted to know if there are any upper limits on the following: I > ha

[sqlite] PRAGMA table_info

Using PRAGMA table_info(...) there is no way to know if a column is declared as unique and/or autoincrement. Am I missing something? Is there a way to get these info? Thanks, Marco Bambini

[sqlite] Recursive Query Support?

Hi, Are you planning on any Recursive Query support in SQLite at any time? Many DBMS's support this and more are doing so. For me personally it would help a great deal. Pasted below is some example explaining the workings of such a query. Greetings, Marco. Example schema: Parent

[sqlite] Idea: Combine PRAGMA & Virtual Table

e these no-guarantee-PRAGMA-settings for public use ! Thanks for reading my insights. Marco Wobben. Relevant docs : http://www.sqlite.org/pragma.html#schema http://www.sqlite.org/cvstrac/wiki?p=VirtualTables

Re: [sqlite] Relative query cost

Well... it doesn't give you the details you are asking, but please take a look at my SQLiteManager, I think it could be useful to you: http://www.sqlabs.net/sqlitemanager.php --- Marco Bambini http://www.sqlabs.net http://www.sqlabs.net/blog/ On May 27, 2006, at 6:56 PM, Jay Sprenkle

Re: [sqlite] speed of ORDER BY clause?

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

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

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

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

[sqlite] PRAGMA integrity_check

. If everything is in order, "ok" is returned. So, if any problems are found, how can I repair them? VACUUM? Thanks a lot, --- Marco Bambini http://www.sqlabs.net http://www.sqlabs.net/blog/ - To unsubsc

Re: [sqlite] Database on usbstick

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

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

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

I am 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_comp

Re: [sqlite] question about search string

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

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: >

Re: [sqlite] When to release version 3.3.10?

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/realsqls

[sqlite] Locking support for remote databases with Mac OSX

: 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

ns 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

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 w

Re: [sqlite] Obtaining randomness on win32

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

Re: [sqlite] Abuse of the SQLite website

Maybe you can limit the times per hour that a single IP address can download something from your web site. For example max 50 download per file per hour for a single IP address. This prevents current and future abuses... --- Marco Bambini http://www.sqlabs.net http://www.sqlabs.net/blog/ http

Re: [sqlite] SQLITE_CORE use for ??

Can someone clarify this point please? I mean, if I want to compile sqlite in a way that it should be able to load extensions, SQLITE_CORE could be defined or not? Or if it doesn't matter, what is its role? Thanks. --- Marco Bambini http://www.sqlabs.net http://www.sqlabs.net/blog/

Re: [sqlite] SQLITE_CORE use for ??

Thanks a lot for the clarification. --- Marco Bambini http://www.sqlabs.net http://www.sqlabs.net/blog/ http://www.sqlabs.net/realsqlserver/ On Jul 30, 2008, at 4:28 PM, D. Richard Hipp wrote: > > On Jul 30, 2008, at 10:22 AM, Marco Bambini wrote: > >> Can someone clarify th

[sqlite] Virtual tables

What is the best way to identify virtual tables inside a sqlite database? Thanks a lot. --- Marco Bambini http://www.sqlabs.net http://www.sqlabs.net/blog/ http://www.sqlabs.net/realsqlserver/ ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] Virtual tables

Yes but creating a virtual tables involves the creations of other related tables ... does all the virtual table implementations (fts1, fts2, fts3) follow the same schema or it is implementation dependent? --- Marco Bambini http://www.sqlabs.net http://www.sqlabs.net/blog/ http

Re: [sqlite] Virtual tables

name of all the tables (not virtual) created inside the db (save their names somewhere) - and at the end copy all the tables whose name was not previously saved I wondering if is there a simpler/better solution... --- Marco Bambini http://www.sqlabs.net http://www.sqlabs.net/blog/ http

[sqlite] Unable to compile fts2 as loadable extension

sqlite3_api_routines *sqlite3_api; in fts2_tokenizer.c. But now the linked reports missing sqlite3_malloc, sqlite3_free, sqlite3_realloc symbols. Do I have to link with sqlite3.c or I should just write some wrapper functions? Can fts2 be compiled as an external loadable extension? --- Marco Bambini http

Re: [sqlite] Unable to compile fts2 as loadable extension

Yes I know and fts3 is enabled by default but I need to be able to load fts2 as an external extension for legacy support. --- Marco Bambini http://www.sqlabs.net http://www.sqlabs.net/blog/ http://www.sqlabs.net/realsqlserver/ On Oct 8, 2008, at 6:15 AM, Alexandre Courbot wrote: >

[sqlite] Why SQLITE_LOCKED here?

sometimes it still occurs. Any idea of the reason of the error? Any idea about how to solve the issue without using the sqlite3_busy_handler or sqlite3_busy_timeout functions? Thanks a lot for the clarifications. -- Marco Bambini ___ sqlite-users

[sqlite] Transactions on attached databases

st would like to know if db1 seems a db with write operations from sqlite's point of view)... and should the transaction be started on db2 or it doesn't matter when the two dbs are attached? Thanks a lot for the clarifications. -- Marco Bambini __

Re: [sqlite] Transactions on attached databases

It's a very useful API, thanks a lot. -- Marco Bambini http://www.sqlabs.net http://www.sqlabs.net/blog/ http://www.sqlabs.net/realsqlserver/ On Dec 12, 2008, at 5:26 PM, D. Richard Hipp wrote: > > On Dec 12, 2008, at 11:16 AM, Marco Bambini wrote: > >> I have two da

Re: [sqlite] Transaction within script

Is there any documentation available about savepoints? -- Marco Bambini http://www.sqlabs.net http://www.sqlabs.net/blog/ http://www.sqlabs.net/realsqlserver/ On Jan 2, 2009, at 2:19 AM, D. Richard Hipp wrote: > > On Jan 1, 2009, at 7:25 PM, Igor Tandetnik wrote: > >>

  1   2   3   >