[sqlite] Need help on build query.

Hello. I like delete some of table. For example: I can run query: select name from sqlite_master where name like 'prefix_%'; Can I delete found tables? Using only sql. It's real? Best regards, Artem Yankovskiy

Re: [sqlite] Running out of disk space.

Hi. You do not receive the error message until receive 0 free disk spaces. When queryes are running in transaction, record in a DB does not write, the journal-file is created only, therefore you see your changes. As soon as you make commit, there is a records of changes in a DB. During this moment

[sqlite] Running out of disk space.

What happens, and/or what is supposed to happen when sqlite runs out of disk space? In an extremely disk-space constrained situation, I create a bunch of tables, without any sqlite errors, and then later the tables are not found. I see the same thing when inserting rows: no error, but later

RE: [sqlite] Re: SQL syntax issue?

Thanks Igor yes that works too! -Original Message- From: Igor Tandetnik [mailto:[EMAIL PROTECTED] Sent: Friday, 9 February 2007 13:47 To: SQLite Subject: [sqlite] Re: SQL syntax issue? Known SQLite limitation. Just drop the parentheses, you don't need them here. Igor Tandetnik

[sqlite] Re: SQL syntax issue?

Sherlock, Ric <[EMAIL PROTECTED]> wrote: But gives and error with the following statement (it will run fine on the same tables in Access) SELECT clients.cl_lname, clients.cl_title, price_profiles.pp_year, prices.pr_mfd, prices.pr_price FROM (clients LEFT JOIN price_profiles ON clients.cl_id

[sqlite] Re: Leading zeros in strings

Robert Simpson <[EMAIL PROTECTED]> wrote: Issued from the 3.3.12 comand-line: CREATE TABLE blah (ID INTEGER PRIMARY KEY, STUFF string NOT NULL); INSERT INTO blah (STUFF) VALUES('00302'); SELECT * FROM blah; 1|302 Same query, slightly different table definition: CREATE TABLE blah (ID

Re: [sqlite] Select and deletion

On 2/8/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: Perhaps what Jay did occurred before [3355] (first released with 3.3.8) and what DragonK did occurred afterwards. http://www.sqlite.org/cvstrac/chngview?cn=3355 That explains it. You have a phenomenal memory for detail! -- The

[sqlite] Leading zeros in strings

Issued from the 3.3.12 comand-line: CREATE TABLE blah (ID INTEGER PRIMARY KEY, STUFF string NOT NULL); INSERT INTO blah (STUFF) VALUES('00302'); SELECT * FROM blah; 1|302 Same query, slightly different table definition: CREATE TABLE blah (ID INTEGER PRIMARY KEY, STUFF text NOT NULL);

[sqlite] SQL syntax issue?

I've come across the following SQL syntax issue in Sqlite that is maybe a bug (or maybe just a product of my poor SQL knowledge!) I have a database that from the command line will execute the following statement fine: SELECT clients.cl_lname, clients.cl_title, price_profiles.pp_year FROM clients

Re: [sqlite] Performance problems potentially related to index scalability

"Stan Bielski" <[EMAIL PROTECTED]> wrote: > > Anyone care to take a guess what's going on here? The problem is that you are thrashing. The working set on the database file is exceeding the amount of memory that your OS has set aside for disk cache. The best solution, if possible, is to insert

Re: [sqlite] Please unsubscribe

I don't know what happened to him, but I tried to get off the list 3 times. Is the address: [EMAIL PROTECTED] -- OR -- sqlite-users-unsubscribe-GBanschbach=sandata . [EMAIL PROTECTED] The 2nd address was in my "Welcome" letter, from when I joined the list. NOTICE ** I altered the dot (.) in the

Re: [sqlite] misuse of aggregate function

Found the answer!!! :D change this query by this query INSERT INTO users(user,pass,name,email) VALUES('root',md5("root"),'Root',' [EMAIL PROTECTED]'); and works very well INSERT INTO users(user,pass,name,email) VALUES('root',(select md5("root")),'Root',' [EMAIL PROTECTED]'); thanks to all

Re: [sqlite] Performance problems potentially related to index scalability

On 2/8/07, Griggs, Donald <[EMAIL PROTECTED]> wrote: Regarding: "...Next, I add in an index on [one] of my numeric columns. ... This is where the problem comes in." You may already know this, but if you can tolerate waiting until the loads are complete before adding the index, the total

RE: [sqlite] Performance problems potentially related to index scalability

Regarding: "...Next, I add in an index on [one] of my numeric columns. ... This is where the problem comes in." You may already know this, but if you can tolerate waiting until the loads are complete before adding the index, the total performance should be better.

[sqlite] misuse of aggregate function

I am compliled the test_md5.c with my sqlite, but when i execute something I get the follow error "Error: misuse of aggregate function md5() " Any one can helpme please? Thanks to all Here i post my code /* ** SQLite uses this code for testing only. It is not a part of ** the SQLite

[sqlite] Performance problems potentially related to index scalability

Greetings, I'm running into some performance problems with my insert operations using sqlite 3.35. OS is linux with a 2.69 kernel using an out-of-box ext3 file system. My schema consists of a single table with 12 columns with a numeric affinity and 5 columns with text affinity. The table has a

RE: [sqlite] What does this mean???

From: "Anderson, James H (IT)" <[EMAIL PROTECTED]> Reply-To: sqlite-users@sqlite.org To: Subject: [sqlite] What does this mean??? Date: Wed, 7 Feb 2007 17:33:21 -0500 not an error(21) at dbdimp.c line 398 I'm using DBD::SQLite and got this error. What does it mean

[sqlite] Please unsubscribe

Please unsubscribe _ Gossips, movie reviews, photogallery and more http://content.msn.co.in/Entertainment/Default - To unsubscribe, send email to

Re: [sqlite] What does this mean???

WOW. Good to know. Thanks Jim (and Matt). -Clark - Original Message From: "Anderson, James H (IT)" <[EMAIL PROTECTED]> To: Matt Sergeant <[EMAIL PROTECTED]> Cc: sqlite-users@sqlite.org Sent: Thursday, February 8, 2007 8:36:31 AM Subject: RE: [sqlite] What does this mean??? Looks

RE: [sqlite] What does this mean???

Looks like removing the semi-colon did the trick. Thanks very much. -Original Message- From: Matt Sergeant [mailto:[EMAIL PROTECTED] Sent: Thursday, February 08, 2007 11:09 AM To: Anderson, James H (IT) Cc: sqlite-users@sqlite.org Subject: Re: [sqlite] What does this mean??? On

RE: [sqlite] What does this mean???

The output after setting $dbh->trace(3): insert or replace into TMP_credDerivOrig select A.date, A.CDId, A.CDName, A.CDTicket, A.tradeId, A.tapsAccount, A.CDBook, coalesce(A.CDFid,'') CDFid, A.CDStatus, A.CDTradeDate, A.CDExpDate, A.CDNotional, A.CDCurr, A.CDSellBuy, A.CDType, A.CDExerType,

RE: [sqlite] What does this mean???

I get the exact same failure after making the suggested changes. DBD::SQLite::st execute failed: not an error(21) at dbdimp.c line 398 [for Statement " "] at /u/crdceed/lib/perl5/DBUtilLite.pm line 185. DBD::SQLite::st execute failed: not an error(21) at dbdimp.c line 398 [for Statement " "] at

RE: [sqlite] What does this mean???

Found the following in sqlite.h.in. This indicates to me that DBD-SQLite isn't handling this "error" string correctly. /* ** Return the error code for the most recent sqlite3_* API call associated ** with sqlite3 handle 'db'. SQLITE_OK is returned if the most recent ** API call was successful.

RE: [sqlite] What does this mean???

Thanks, Clark. I'll give that a try. jim -Original Message- From: Clark Christensen [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 07, 2007 7:30 PM To: sqlite-users@sqlite.org Subject: Re: [sqlite] What does this mean??? Jim, Line 398 in dbdimp.c appears to be in DBD-SQLite's

RE: [sqlite] x000 line queries - only for benchmarks?

No trouble, I thought that might be the case. I am pleased I finally nailed this down. RBS -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 08 February 2007 13:14 To: sqlite-users@sqlite.org Subject: RE: [sqlite] x000 line queries - only for benchmarks? No, I

RE: [sqlite] x000 line queries - only for benchmarks?

No, I just forgot that this all stemmed from the original problem of sqlite_get_table throwing errors. After a while these threads all tend to get a little fuzzy to me. Sorry about that. -- Eric Pankoke Founder / Lead Developer Point Of Light Software http://www.polsoftware.com/

RE: [sqlite] x000 line queries - only for benchmarks?

Yes, VBA supports both, but as it is just for logging purposes my solution is fine, particularly as these long queries have repetitions of similar elements. Also the function sqlite_get_table will produce an array and the error happens directly when that function is called, so how is using a

Re: [sqlite] x000 line queries - only for benchmarks?

Does VBA support collections? Or you could use an ADO recordset. Either one should easily let you store elements that are over 2K bytes in length. -- Eric Pankoke Founder / Lead Developer Point Of Light Software http://www.polsoftware.com/ -- Original message

Re: [sqlite] Select and deletion

DragonK <[EMAIL PROTECTED]> wrote: > > So, as I understand it, this is supported from version 3.3.8 upwards, right? > Correct. -- D. Richard Hipp <[EMAIL PROTECTED]> - To unsubscribe, send email to [EMAIL PROTECTED]

Re: [sqlite] Select and deletion

On 2/8/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: "Jay Sprenkle" <[EMAIL PROTECTED]> wrote: > On 2/7/07, DragonK <[EMAIL PROTECTED]> wrote: > > > > > > This seems to work... but I'm not sure if it should, that's why I'm > > asking. > > I hope the code will show more exactly what I intend

Re: [sqlite] Select and deletion

"Jay Sprenkle" <[EMAIL PROTECTED]> wrote: > On 2/7/07, DragonK <[EMAIL PROTECTED]> wrote: > > > > > > This seems to work... but I'm not sure if it should, that's why I'm > > asking. > > I hope the code will show more exactly what I intend to do. Sorry for the > > lack of proper error checking,

Re: [sqlite] x000 line queries - only for benchmarks?

There is no problem running queries of whatever length, so I could do benchmarks fine, it is just that VBA has a problem with array elements holding over 1823 characters. RBS > [EMAIL PROTECTED] wrote: >> In my (commercial) app I regularly have queries with over 1000 >> characters. >> Not over

Re: [sqlite] x000 line queries - only for benchmarks?

[EMAIL PROTECTED] wrote: In my (commercial) app I regularly have queries with over 1000 characters. Not over 1000 lines though. As VBA (not sure now about VB6) has a problem with array elements having over 1823 characters I had to truncate my SQL logging routine. Under 2k? That seems a bit

Re: [sqlite] x000 line queries - only for benchmarks?

In my (commercial) app I regularly have queries with over 1000 characters. Not over 1000 lines though. As VBA (not sure now about VB6) has a problem with array elements having over 1823 characters I had to truncate my SQL logging routine. RBS > I've seen some longish SQL queries posted to this

[sqlite] x000 line queries - only for benchmarks?

I've seen some longish SQL queries posted to this list but I was wondering, how often do 1000+ line queries (as in the SQLite benchmark) occur in the real world? Do queries of this sort of size exist outside of initialising tables with a long lists of inserts? Martin

Re: [sqlite] Re: DROP TABLE IF EXISTS my_table

Thank you for response. How can I install a more recent version with my php ? (I'm using Wamp5) Igor Tandetnik a écrit : Cecilia VIGNY wrote: I'm using SQLite with a PHP program and I would like to execute this SQL request : DROP TABLE IF EXISTS clients; When I test my program, this error