Re: [sqlite] capturing and testing a hot journal
-Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of mm.w Sent: Tuesday, July 15, 2014 8:34 PM To: R Smith Cc: General Discussion of SQLite Database Subject: Re: [sqlite] capturing and testing a hot journal >> and I stay public even it looks weird, but seriously grew up and fast kiddo. As someone who is new to this thread aside from reading, could you please just stop unless you have something useful to say? I honestly can't tell by most of your comments whether you're a professional programmer or a high school whiner pretending to be something else, and it's pretty sad that it often takes you multiple emails to finish one thought because apparently you have no reasonable control over whatever mechanism you're using to post to this list. I don't appreciate your spam and I'm pretty sure no one else that receives individual emails from this list does either. If you can't stay on topic, don't participate in the topic at all. That being said, enjoy this, flame it and don't expect a response, because I don't want to be any more hypocritical than I already am by posting this in the first place. Eric ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Is a column name of 'AS' a restricted column name
AS is a key word, so I believe you either have to put it in single or double quotes to use it as a column name: INSERT INTO [shopdata] (Date_TS, HS, "AS")... Hopefully I'm remembering correctly what I've read in the past. Eric Pankoke Mobile Games Reviewer My Site: http://www.rustysabre.com/ Reviews: http://www.technobrains.com/, http://www.touchmyapps.com Blog: http://www.iphonelife.com/blogs/eric-pankoke Twitter: http://www.twitter.com/RustySabre/ -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Account 69 Sent: Sunday, December 11, 2011 5:01 AM To: sqlite-users@sqlite.org Subject: [sqlite] Is a column name of 'AS' a restricted column name Hello, Just started to use SQLite3 instead of MSAccess within my programming environment can hit a problem. I have searched the mailing list and also other internet sites for help but could not find any. In my table I have (for simplicity) 4 columns (ID, Date, HS, AS) My data comes from an established hourly CSV file that I receive for the last 7 years. In the past I would use VB6 to process the CSV and then via a SQL Insert statement I would insert into an MSAccess database (for local PC usage) and also a MySQL database (for internet usage) The table is.. CREATE TABLE [shopdata] ( [ID] INTEGER PRIMARY KEY, [Date_TS] INTEGER, [HS] DOUBLE Default (0), [AS] DOUBLE Default (0)); When I use the following SQL in my application INSERT INTO [shopdata] (Date_TS, HS, AS) VALUES ('1012003200','15','9') The insert fails with an error of (near "AS": syntax error) This has had me stumped for a few days especially as I am getting to grips with SQLlite and kept thinking I am doing something wrong. I messed around late last night and I changed the column name of "AS" to "A_S" and the inset works fine and the data is stored in the database. To recheck I had not changed the table structure in an other way I reverted back to using a column name of "AS" and again I got the SQL errors of (near "AS": syntax error) I tried this also in SQLExpert and the exact same happens. In MSAccess and MySQL this column name of "AS" works fine (as has been for 7 years) Is a column name of "AS" a restricted column name in SQLlite? Can anyone point me to a webpage that species these restricted column names or is this an error on my part somewhere Thank you. PS, I do not have control over the incoming CSV, so I have to make any changes during processing. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] Max Value In Group By Scenario
I realize this is more of a general SQL question, but I figured while I was digging for the answer one of you would probably already know it. I have a table where the three import fields for my situation are MfgProductID, ProductID and Weight. For any given MfgProductID there can be multiple rows, and for any given MfgProductID / ProductID combination there can be multiple rows. The following query: SELECT MfgProductID, ProductID, SUM(Weight) As MaxWeight FROM dominantmaterials GROUP BY MfgProductID, ProductID Gets me most of the way to what I need. What I'm really after, however, is the ProductID for each MfgProductID that has the greatest combined weight from all MfgProductID / ProductID rows. I hope this makes sense, but as an illustration: Mfg | Product ID | Weight 1 | 1 | 10 1 | 1 | 10 1 | 2 | 15 When I'm done I want only 1 row for MfgProductID 1, where ProductID is 1 (since the combined total of rows with ProductID 1 is 20 for weight, which is greater than the single row of ProductID 2 at weight 15). Sorry for a rambling explanation for what I'm sure is a simple solution. Eric Pankoke Mobile Games Reviewer http://www.rustysabre.com/ http://www.technobrains.com/ ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Populating and scrolling the Listbox using query
That seems like it would cut down on some of your query times. When you say it's running slow, how slow are you talking about? Eric Pankoke Founder Point Of Light Software http://www.polsoftware.com/ -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Neville Franks Sent: Tuesday, April 22, 2008 1:08 AM To: General Discussion of SQLite Database Subject: Re: [sqlite] Populating and scrolling the Listbox using query Tuesday, April 22, 2008, 2:52:37 PM, you wrote: Why not just keep the rowid's in an array and query the actual row contents as needed. This is typical with virtual list or tree controls. That is you keep a reference to the data, not the data itself. F> Thanks for the quick reply Epankoke. F> We tried as you mentioned. But we are restricted with the memory size and F> the storage of the needed data occupies some MB's of space in the memory so F> we cannot go for it. Is there any other work around to perform the scrolling F> condition. F> Kindly help in this regard. F> Regards, F> Farzana. F> epankoke wrote: >> >> Is it possible to store all of the needed data in memory? If so, why not >> read the required information into an array and just update an index >> variable to keep track of where you are at in the array when the user >> clicks the up and down buttons? That should be quite fast. >> >> -- >> Eric Pankoke >> Founder / Lead Developer >> Point Of Light Software >> http://www.polsoftware.com/ >> >> -- Original message -- >> From: Farzana <[EMAIL PROTECTED]> >>> >>> Thanks for your reply Igor. >>> >>> We tried populating the listbox as mentioned in the URL.We are successful >>> in >>> populating the listbox but when we go for scrolling the data, it takes >>> more >>> time to move forward and backward since it has to execute the query >>> everytime. We are using a PocketPc so it is much slower. Is there any >>> other >>> way to do this or can some one provide us a sample code for the same. >>> We are using a Table say Employees where we have to dsiplay their Job >>> Description in ascending order in a user defined listbox with scroll up >>> and >>> scroll down buttons. Can anyone provide us a suggestion. >>> Thanks in Advance. >>> >>> Regards, >>> Farzana >>> >>> >>> >>> Igor Tandetnik wrote: >>> > >>> > "Farzana" <[EMAIL PROTECTED]> >>> > wrote in message news:[EMAIL PROTECTED] >>> >> We are working in eVC++ environment with SQLite database.We need to >>> >> populate the listbox with the values obtained by executing the query. >>> >> We were able to get the values of the query by using the API's >>> >> sqlite3_prepare and sqlite3_step. >>> >> But we were able to populate and move the listbox in the downward >>> >> direction only >>> > >>> > http://www.sqlite.org/cvstrac/wiki?p=ScrollingCursor >>> > >>> > Igor Tandetnik >>> > >>> > >>> > >>> > ___ >>> > sqlite-users mailing list >>> > sqlite-users@sqlite.org >>> > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users >>> > >>> > >>> >>> -- >>> View this message in context: >>> http://www.nabble.com/Populating-and-scrolling-the-Listbox-using-query-t p1667617 >>> 8p16806114.html >>> Sent from the SQLite mailing list archive at Nabble.com. >>> >>> ___ >>> sqlite-users mailing list >>> sqlite-users@sqlite.org >>> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users >> >> ___ >> sqlite-users mailing list >> sqlite-users@sqlite.org >> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users >> >> -- Best regards, Neville Franks, http://www.surfulater.com http://blog.surfulater.com ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
RE: [sqlite] sqlite3_open function
The best way is to just check if the file exists in whatever language you're using before you call sqlite3_open. Eric Pankoke Founder Point Of Light Software http://www.polsoftware.com/ -Original Message- From: fred238 [mailto:[EMAIL PROTECTED] Sent: Friday, August 10, 2007 11:28 PM To: sqlite-users@sqlite.org Subject: [sqlite] sqlite3_open function hello, Is there a way to not create a database while the db file is not found with the sqlite3_open function ? Why don't just create a create_table function instead of ? regards, fred. - To unsubscribe, send email to [EMAIL PROTECTED] - - To unsubscribe, send email to [EMAIL PROTECTED] -
RE: [sqlite] CREATE TRIGGER IF NOT EXISTS throws error
What version of SQLite are you using? I'm not sure the IF EXISTS option was present until a certain version of 3.x (though I'm not sure which version). Eric Pankoke Founder Point Of Light Software http://www.polsoftware.com/ -Original Message- From: stephan nies [mailto:[EMAIL PROTECTED] Sent: Sunday, March 25, 2007 1:47 PM To: sqlite-users@sqlite.org Subject: [sqlite] CREATE TRIGGER IF NOT EXISTS throws error Hello, when i build a test table with: CREATE TABLE test(a text); and try to implement a trigger using: CREATE TRIGGER IF NOT EXISTS trig_name BEFORE INSERT ON test FOR EACH ROW BEGIN SELECT RAISE(ROLLBACK, 'blabla') WHERE NEW.a = 'pong'; END; I get this error message: SQL error: near "NOT": syntax error if i omit the "IF NOT EXISTS" everything woks fine. According to the Documentation at http://www.sqlite.org/lang_createtrigger.html SQLite should understand this syntax. So what am i doing wrong here? Thanks, Stephan - To unsubscribe, send email to [EMAIL PROTECTED] -
RE: [sqlite] Appropriate uses for SQLite
By separate files, do you mean that each user has their own data store? If so, why not do the same thing with SQLite? If each user has a unique name or ID, append that to a generic file name and you have a separate instance for each user. I don't believe there's that much overhead to the system tables that SQLite uses, and you solve your concurrency issues. Eric Pankoke Founder Point Of Light Software http://www.polsoftware.com/ -Original Message- From: Anil Gulati -X (agulati - Michael Page at Cisco) [mailto:[EMAIL PROTECTED] Sent: Thursday, February 01, 2007 8:27 PM To: sqlite-users@sqlite.org Subject: RE: [sqlite] Appropriate uses for SQLite That's what I'm talking about! It's good to get the perspective from your setup, Phil. I'm beginning to get the picture. I am starting to think that I should stick to an enhancement of my current system. It's *very* basic, even more basic than SQLite, but corruption seems almost impossible when data is in separate files with no compression, etc. Thanks for taking the time. Anil. -Original Message- From: Philip Butler [mailto:[EMAIL PROTECTED] Sent: Friday, 2 February 2007 12:16 PM To: sqlite-users@sqlite.org Subject: Re: [sqlite] Appropriate uses for SQLite And this is when I'll step back and listen to the experts... Since it is a low-load situation, file/record locking on SQLite seems like it would be acceptable to me. As for data corruption - that's bad -- very bad. However, with automated backups some degree of comfort may be realized. With the db systems that I have designed, I have an automatic process that dumps the db to a text file every 4 hours or so. These are kept for a couple of days. I sleep easy at night knowing this... Phil On Feb 1, 2007, at 7:59 PM, Anil Gulati -X ((agulati - Michael Page at Cisco)) wrote: > Thanks for replying Phil... > > Actually I am not running separate websites - but I have to deploy to > multiple webservers which will all serve the same pages. Each > webserver will have their own copy of the SQLite code, but they need > to load the data from a network file server to share the same data. > > I guess this is why I am asking for feedback: it seems that this case > is a marginal case for SQLite and I am just trying to assess > performance and corruption possibilities in more detail than is > presented on the SQLite web pages. > > The main point that encourages me to try SQLite is that it is > recommended for 99.9% of websites. I believe my traffic is very low > and SQLite should be recommended from that point of view. > > However, although the likelihood of two users simultaneously updating > a particular record is going to be very low I believe it is going to > happen that two users will try to update the database simultaneously. > > I know that SQLite has some file locking features that have even been > improved in v 3.0. So: > - will simultaneous *database* access result in corruption? > - will simultaneous *record* access result in corruption? > - if not, when *can* corruption occur? > > I don't mind making the users wait in the unlikely event of a record > collision, or even drop data once in a blue moon, but corruption is > not acceptable. > > Thanks again. > Anil. > > -Original Message- > From: Philip Butler [mailto:[EMAIL PROTECTED] > Sent: Friday, 2 February 2007 11:39 AM > To: sqlite-users@sqlite.org > Subject: Re: [sqlite] Appropriate uses for SQLite > > I am not an expert on SQLite - but if you are running separate > websites from your multiple servers, then why not use 4 instances of > SQLite ?? > That is unless the websites need to share the same database/tables. > > If they do need to share the same database/tables, then PostgreSQL or > MySQL may be the more appropriate choice. They are designed to be > distributed (hence their increased overhead) while SQLite is designed > to be lean-and-mean. > > Just my 2 cents worth... > > Phil > > On Feb 1, 2007, at 7:03 PM, Anil Gulati -X ((agulati - Michael Page at > Cisco)) wrote: > >> Hi SQLite users >> >> Thank you for your attention - I am just hoping for some >> clarification > >> of usability of SQLite. >> Referring to: http://www.sqlite.org/whentouse.html >> - SQLite works well in websites >> - Other RDBMS may work better for Client/Server applications >> - SQLite will work over a network file system, but because of the >> latency associated with most network file systems, performance will >> not be great >> >> I am trying to decide whether I can use SQLite for a website that >> runs > >> on 4 load-balanced servers using networked file storage mounted by >> all > >> servers for common data access. SQLite will have to load it
RE: [sqlite] How do I know sqlite_get_table is finished
Is it possible for you to post the "offending" block of VBA code? Even seeing your list of steps, it might be easier to help if we can view the actual syntax. Eric Pankoke Founder Point Of Light Software http://www.polsoftware.com/ -Original Message- From: RB Smissaert [mailto:[EMAIL PROTECTED] Sent: Thursday, February 01, 2007 7:06 PM To: sqlite-users@sqlite.org Subject: RE: [sqlite] How do I know sqlite_get_table is finished Good thought, but 1. I set the connection 2. get the array 3. dump it in the sheet 4. and then close the connection. The crash happens at number 2. I am sure I must be overlooking something simple here. The trouble is that this error is not consistent. RBS -Original Message- From: Guy Hachlili [mailto:[EMAIL PROTECTED] Sent: 01 February 2007 23:50 To: sqlite-users@sqlite.org Subject: RE: [sqlite] How do I know sqlite_get_table is finished Well... At 23:17 2/1/2007 +, you wrote: >Thanks, yes, I somehow didn't think my explanation made sense and in fact I >just had another Excel crash, caused by the same call to sqlite_get_table. > >I just can't understand why this is happening. >There is a valid connection, there is a valid SQL, the DB file is there and >working otherwise fine, etc. > >The wrapper works otherwise 100% perfect and I only have the problem in this >particular procedure. I guess there must be a VBA bug then, but I just can't >find it. Is it possible that you are using the array returned by the function after you close the database, and that the VB wrapper frees the data when the database is closed? If that is the case, you will probably get a crash as you are accessing a memory that was already freed. Guy - To unsubscribe, send email to [EMAIL PROTECTED] - - To unsubscribe, send email to [EMAIL PROTECTED] - - To unsubscribe, send email to [EMAIL PROTECTED] -
RE: [sqlite] return table data without fields
Since you know how many columns are in the result set, can't you just ignore the first row when referencing your data? It seems to me at that point you won't have any significant performance penalties. Eric Pankoke Founder Point Of Light Software http://www.polsoftware.com/ -Original Message- From: RB Smissaert [mailto:[EMAIL PROTECTED] Sent: Saturday, January 27, 2007 11:22 AM To: sqlite-users@sqlite.org Subject: RE: [sqlite] return table data without fields Thanks for that information. Taking the first row out of the array will have a big performance penalty as you say as you will have to write a whole new array. I know near enough nil about C, so altering the source will be difficult. Will think of something. Didn't know about the NULL handling and that is worth knowing and will see if it affects my app in some way. RBS -Original Message- From: Trey Mack [mailto:[EMAIL PROTECTED] Sent: 27 January 2007 15:57 To: sqlite-users@sqlite.org Subject: Re: [sqlite] return table data without fields I cannot find a PRAGMA for turning column names on/off either. You may be thinking of ".headers on/off" in the SQLite shell.. I don't think there's a way to turn this off, except rewriting the code for sqlite_get_table (which, thankfully, he's provided). Maybe to include a 4th parameter that would be a flag to include column headers or not. Or you could wrap all your calls through a VB function of your design that strips that first row (the column headers) out of the array, but I'd worry about performance with that method. One thing worth mentioning about this wrapper is that it doens't handle NULL return values as you might expect. If you issue a query that should return NULL.. like: create table t (a integer); -- no records.. select max(a) from t; -- should return NULL, since there is no max select typeof(max(a)) from t; -- proves that SQLite returns NULL you'll receive "" (the empty string) in the spot in the array where your result ends up. But again, thankfully, he's provided the source, so you can add the following lines else { // I hope the following is safe, as I'm definitely NOT a C/C++ guru.. especially with memory allocation / deallocation tmpVariant.vt = VT_NULL; hr = SafeArrayPutElement(resultp, indices, ); VariantClear(); } at line 103 in my copy of VBSQL.c (I may have done some formatting, I forget), as the else for the following if: if (SQL_Results[sqlite_return_array_int]) { then, the Variant that will be sent to VB6 will be of type Null and can be tested with the VB6 function IsNull(..) properly. Regards, Trey - Original Message - From: "RB Smissaert" <[EMAIL PROTECTED]> To: <sqlite-users@sqlite.org> Sent: Saturday, January 27, 2007 7:01 AM Subject: [sqlite] return table data without fields > Using the VB wrapper dll from Todd Tanner: > http://www.tannertech.net/sqlite3vb/index.htm > > and it has this function to return table rows: > > Private Declare Function sqlite_get_table _ > Lib "SQLite3VB.dll" _ > (ByVal DB_Handle As Long, _ > ByVal SQLString As String, _ > ByRef ErrStr As String) As Variant() > > This will by default include the table field names. > Is there a way to return the table data without these field names? > I thought there was a Pragma command for this, but I couldn't find it. > > RBS > > > > - > To unsubscribe, send email to [EMAIL PROTECTED] > - > > - To unsubscribe, send email to [EMAIL PROTECTED] - - To unsubscribe, send email to [EMAIL PROTECTED] - - To unsubscribe, send email to [EMAIL PROTECTED] -
RE: [sqlite] Operation is not allowed when the object is closed
Can you try this code: Dim sqlite As New SQLiteDb.Connection With sqlite .Open "Data Source=c:\temp\test.db" If .State = slStateOpen Then .Execute "CREATE TABLE [A3Test8CA_F] ([PATIENT_ID] INTEGER, [ENTRY_ID] INTEGER, [READ_CODE] TEXT, [TERM_TEXT] TEXT, [START_DATE] INTEGER, [NUMERIC_VALUE] REAL)", , slExecuteNoRecords .Close End If End With Set sqlite = Nothing MsgBox "Done" I tried it both with and without test.db existing, and it worked fine both times. Eric Pankoke Founder Point Of Light Software http://www.polsoftware.com/ -Original Message- From: RB Smissaert [mailto:[EMAIL PROTECTED] Sent: Saturday, December 09, 2006 6:39 PM To: sqlite-users@sqlite.org; [EMAIL PROTECTED] Subject: RE: [sqlite] Operation is not allowed when the object is closed This is the full Sub that sets the connection, except for leaving out a msgbox text: Sub SetSQLiteConnection(Optional bNoRecords As Boolean, _ Optional strDBFile As String, _ Optional lPageSize As Long = -1) Dim strDBPath As String If Len(strDBFile) = 0 Then strDBPath = ReadINIValue(strINIPath, _ "Add-in behaviour", _ "Path to SQLite database") If bFileExists(strDBPath) = False Then Exit Sub End If Else strDBPath = strDBFile End If If Len(strDBFile) > 0 Then If Not SQLiteConn Is Nothing Then If SQLiteConn.State = slStateOpen Then SQLiteConn.Close End If Set SQLiteConn = Nothing End If End If If SQLiteConn Is Nothing Then Set SQLiteConn = New SQLiteDb.Connection SQLiteConn.ConnectionString = "Data Source=" & strDBPath End If On Error Resume Next Do While SQLiteConn.State = slStateClosed SQLiteConn.Open Loop If bNoRecords Then SQLiteConn.Execute "PRAGMA synchronous=off;", , slExecuteNoRecords SQLiteConn.Execute "PRAGMA encoding='UTF-8';", , slExecuteNoRecords End If If lPageSize > -1 Then SQLiteConn.Execute "PRAGMA page_size=" & lPageSize & ";", , slExecuteNoRecords End If End Sub And this is the relevant code leading up to the error: SetSQLiteConnection True, strDBFile With SQLiteConn .BeginTrans If SQLiteTableExists(strDBFile, strTable) = False Then .Execute strCreateTable, 0, 128 <<< error here <<< End If strCreateTable is a valid SQL to create a table: CREATE TABLE [A3Test8CA_F] ([PATIENT_ID] INTEGER, [ENTRY_ID] INTEGER, [READ_CODE] TEXT, [TERM_TEXT] TEXT, [START_DATE] INTEGER, [NUMERIC_VALUE] REAL) RBS -Original Message- From: Kees Nuyt [mailto:[EMAIL PROTECTED] Sent: 09 December 2006 23:27 To: sqlite-users@sqlite.org Subject: Re: [sqlite] Operation is not allowed when the object is closed On Sat, 9 Dec 2006 22:24:59 -, you wrote: > Keep getting this error when trying to create a table > in SQLite. There is a valid connection object and it > is open and I have no idea what is causing this: > > Operation is not allowed when the object is closed. > Error number: 3704 Please show us some code. Did you check for any errors on the connection statement? >Thanks for any advice > >RBS > > > >--- -- >To unsubscribe, send email to [EMAIL PROTECTED] >--- -- -- ( Kees Nuyt ) c[_] - To unsubscribe, send email to [EMAIL PROTECTED] - - To unsubscribe, send email to [EMAIL PROTECTED] - - To unsubscribe, send email to [EMAIL PROTECTED] -
RE: [sqlite] Operation is not allowed when the object is closed
It sounds to me like you're using ADO? How do you know for sure that the connection is truly open? Eric Pankoke Founder Point Of Light Software http://www.polsoftware.com/ -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Saturday, December 09, 2006 5:36 PM To: sqlite-users@sqlite.org Subject: Re: [sqlite] Operation is not allowed when the object is closed "RB Smissaert" <[EMAIL PROTECTED]> wrote: > Keep getting this error when trying to create a table in SQLite. There is a > valid connection object and it is open and I have no idea what is causing > this: > > Operation is not allowed when the object is closed. > Error number: 3704 > Ain't no such error in SQLite. This must be coming from whatever wrapper or interface you are using. -- D. Richard Hipp <[EMAIL PROTECTED]> - To unsubscribe, send email to [EMAIL PROTECTED] - - To unsubscribe, send email to [EMAIL PROTECTED] -
RE: [sqlite] Re: Number of rows in a query result
If by handheld you mean PocketPCs, then: http://sqlite-wince.sourceforge.net/. The database file itself stays the same. If you want Palm support, you'll be a lot harder pressed to find anything. Eric Pankoke Founder Point Of Light Software http://www.polsoftware.com/ -Original Message- From: vidushi tandon [mailto:[EMAIL PROTECTED] Sent: Friday, October 28, 2005 1:09 AM To: sqlite-users@sqlite.org Subject: Re: [sqlite] Re: Number of rows in a query result hi all can anyone tell me how to port sqlite databases to the handheld devices rgds vidushi tandon --- Dennis Cote <[EMAIL PROTECTED]> wrote: > Puneet Kishor wrote: > > > Igor Tandetnik wrote: > > > >> Alfredo Cole > <[EMAIL PROTECTED]> wrote: > >> > >>> In order to update a progress bar, I need to > know the total number of > >>> rows returned by a query, similar to MySQL's > mysql_num_rows. Is there > >>> a function like that in the C API? I may have > overlooked it, but have > >>> not found it so far. > >> > >> > >> There is no such function. Most of the time, > SQLite does not know how > >> many rows there are in the resultset until they > are all actually > >> retrieved. It just produces rows one by one as it > finds them. > >> > >> The only way I know to achieve what you want is > to run the query > >> twice, first as "select count(*)" to obtain the > count, then again > >> with the desired column list. Depending on the > query, "select > >> count(*)" may take as long as the full query, and > in some rare cases > >> it may even be slower. Bottom line, it is > impractical to try and > >> produce an accurate progress indicator for SQLite > queries. > > > > > > > > one suggestion has been to create another table > with a single row > > holding the number of rows in your table of > interest. Just query that > > one table for its one value. > > > > Use TRIGGERs on INSERT, UPDATE, and DELETE to > automatically adjust > > the value in the table with the row count. > > > > > This only works if your select query is returning > all the records in the > table. If you use where conditions to select a > subset of the rows this > will fail because any query could return a number of > rows that won't > match your carefully maintained count. > __ Yahoo! Mail - PC Magazine Editors' Choice 2005 http://mail.yahoo.com
RE: [sqlite] sqlitebrowser alternative
I gave it a try, and it told me a DLL was missing. So I put that DLL (msvcr71.dll, I believe) in my Windows\System32 directory, then it told me another DLL was missing, so at that point I gave up. Eric Pankoke Founder Point Of Light Software http://www.polsoftware.com/ -Original Message- From: Andrea Giammarchi [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 30, 2005 1:18 AM To: sqlite-users@sqlite.org Subject: Re: [sqlite] sqlitebrowser alternative Noel Frankinet wrote: > I was not able to do anything, the rogram crashed immediately, I have > several machine and virtual machine here, same result. It doesn't need any virtual machine, it's a stand alone executable program, however, 46 downloads and only you have this problem. Well, I don't know why it doesn't work on your windows PC, I am sorry :-( Any other comment from other ? That flash interface will be used with a PHP5 class file to manage, with user and password, your online sqlite files too, should be interesting ? Regards, Andrea Giammarchi
RE: [sqlite] Sqlite explorer
If Richard is unable to provide the space for you, I should be able to host the files for you (and I would be sure to give you fair warning if it got to the point where I couldn't). Just let me know if I can help. Eric Pankoke Founder Point Of Light Software http://www.polsoftware.com/ -Original Message- From: mike cariotoglou [mailto:[EMAIL PROTECTED] Sent: Thursday, October 07, 2004 8:05 PM To: [EMAIL PROTECTED] Subject: [sqlite] Sqlite explorer I have a new version of sqliteExplorer, which handles v3 databases, and has some other enhancements as well, for some time now. The problem is, I dont have a web server to put it on. DRH, is there some place on the site where I can upload it ? question to all: how many people use sqlite with Delphi ? I have a couple of delphi sqlite components, which are quite sophisticated, and make use of the engine very easy. I have not bothered to upload them anywhere, since I assumed that most people use sqlite with C anyway. if there is an interest, however, and if DRH can provide the upload space, I could make them public, free of charge of course. - Original Message - From: "Steve Frierdich" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, October 07, 2004 11:21 PM Subject: [sqlite] Does the Sqlite explorer program not view version 3 sqlite databases? > > > Does the sqlite explorer program not view version 3 sqlite databases? I > tried to open a sqlite version 3 database with the sqlite explorer > program and the program said that the database is malformed. Is there a > new sqlite explorer program to download to view sqlite version 3 databases? > > Thanks for all your help > > Steve Frierdich > > > >
RE: [sqlite] www.sqlite.com has disappeared
The address is www.sqlite.org. Eric Pankoke Founder Point Of Light Software http://www.polsoftware.com/ -Original Message- From: Ken Cooper [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 06, 2004 1:38 AM To: [EMAIL PROTECTED] Subject: [sqlite] www.sqlite.com has disappeared Anyone else experiencing this?
RE: [sqlite] QNX and PPC
I believe he's talking about Power PC, but since you brought up the PocketPC, what development environment do you use? I've been messing around with PocketPC development using SQLite, but I really don't like eVC++ for developing GUI interfaces. Eric Pankoke Founder Point Of Light Software http://www.polsoftware.com/ -Original Message- From: Mateusz Âoskot [mailto:[EMAIL PROTECTED] Sent: Monday, August 09, 2004 5:33 AM To: [EMAIL PROTECTED] Subject: Re: [sqlite] QNX and PPC On 8/9/2004 9:45 AM, Jakub Adamek wrote: > thank you for your notes. Could you please tell me more about "That's > the case"? Is it possible to use SQLite on PPC or not possible? Did you > hear about a big-endian port of SQLite? Do you mean Power PC or Pocket PC ? If you mean the second one, I can say sqlite works great on Pocket PC ;-) I use it for almost all database driven projects. Greets -- Mateusz Åoskot mateusz at loskot dot net
RE: [sqlite] sorry for the confusion re: academic software
I'm sorry if this isn't really in line with the current thread, because I've only been reading bits and pieces. If you just want Delphi, have you checked Borland's site lately? They used to give away the personal version of Delphi, as long as you didn't write anything commercial with it. Of course, I don't think it was the latest version, but for free it works. You can also get the Borland command line tools for free, and there are a number of different IDEs on the net that support various compilers. Eric Pankoke Founder Point Of Light Software http://www.polsoftware.com/ -Original Message- From: jim mcnamara [mailto:[EMAIL PROTECTED] Sent: Thursday, June 03, 2004 6:13 PM To: [EMAIL PROTECTED] Subject: [sqlite] sorry for the confusion re: academic software hi- i was recently a student but not any longer. I should have grabbed an academic copy of delphi on my way out the door when i graduated from college last year (poor planning...i am kicking myself). I am disabled and work part time and am on ssdi. I confused everyone when I mentioned the classes i use to take and that i was working part-time. It certainly made it seem like i am currently a student and i apologize. I will check maybe with a couple places and see if i can get a deal if i am disabled and do NOT build anything commercial. Maybe they cant get me a price any cheaper than what they already offer but they might take an extra minute to clarify a license issue if am confused. Thanks for writing. I will come up with some ideas eventually. I have lots of free time to think about it. I hope i can write some sqlite software tools or other free software soon. thanks, jim - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: [sqlite] SQLite version 3 design question: '500'=500?
Actually, I don't think MS SQL's reaction is really all that stupid. In the statement SELECT '500' = 500, I believe it is treating '500' as a field name, and assigning it the value 500. On the other hand, the statement SELECT 500 = '500' would in fact fail, because you can't use an integer as a field name without having it in quotes. Correct me if I'm wrong, but I believe this is why MS SQL returned the results that it did. Eric Pankoke Founder Point Of Light Software http://www.polsoftware.com "Lighting The Path To Glory" -Original Message- From: Andrew Piskorski [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 12, 2004 8:15 PM To: [EMAIL PROTECTED] Subject: Re: [sqlite] SQLite version 3 design question: '500'=500? On Wed, May 12, 2004 at 05:37:49PM -0700, Keith Herold wrote: > In MS SQL 2000, through the query analyzer > >SELECT '500' = 500 > > returns 500 . > >SELECT 500 = '500' > > returns > Server: Msg 170, Level 15, State 1, Line 1 > Line 1: Incorrect syntax near '='. Well that's sure inordinately stupid behavior. The test "A = B" should give the same result as "B = A", at least! In Oracle 8.1.7.4, string '5' does equal integer 5, but you seem to have to ask it via a case statement: SQL> select 5 = 5 from dual; ERROR at line 1: ORA-00923: FROM keyword not found where expected SQL> select case when 5 = '5' then 1 else 0 end as bool from dual; BOOL -- 1 SQL> select case when '5' = 5 then 1 else 0 end as bool from dual; BOOL -- 1 > > But if that is the case, then clearly, '500' != 500. So > > unless somebody can come up with a better idea, SQLite > > version 3.0 will return "0" for the following: > > > > SELECT '500'=500; > > > > On the other hand, the following two statements will return > > "1" (or true): > > > > SELECT '500'+0=500; > > SELECT '500'=(500||''); That sounds ok to me. Wouldn't it be clearer to have explicit cast statements though, rather than doing weird no-ops like "||''" solely to force a type conversion? Also, since you're introducing manifest typing, it would probably be very handy to have good boolean tests both for "is X currently of type Y?" and "CAN X be of type Y?". E.g., "CAN this thing be an integer?", where by "can" I mean, "Is it currently an integer, or if it is currently stored as a some other type, can it be LOSSLESSLY converted to an integer?" Some languages (e.g., S-Plus), make the latter oddly difficult. (Not THAT difficult; in S you can write that "can be integer" test in 5 lines, but those 5 lines are also somewhat easy to get wrong.) I think that in any system where objects can automatically change type, both the those sorts of "can be" boolean tests should also be built in. -- Andrew Piskorski <[EMAIL PROTECTED]> http://www.piskorski.com/ - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[sqlite] Compact Framework
Hi, I'm back to bug everyone again. First off, I want to say thanks to those who helped me out with getting SQLite working in the Pocket PC world with eVC++. Now I'd like to move up to .NET and the Compact Framework, and I've seen several links on the Wiki site that deal with .NET, but nothing specifically with the Compact Framework. Anyone out there using CF and SQLite to develop Pocket PC applications? Eric Pankoke Founder Point Of Light Software http://www.polsoftware.com "Lighting The Path To Glory"
[sqlite] sqlite with eVC++
Is there anyone on this group that uses sqlite with Embedded Visual C++ for the PocketPC? If so, what do I need to do to get a project with sqlite commands to compile? Any help would be greatly appreciated. Thanks. Eric Pankoke Founder Point Of Light Software http://www.polsoftware.com "Lighting The Path To Glory"