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

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:

[sqlite] Max Value In Group By Scenario

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

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 Beha

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

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

RE: [sqlite] Appropriate uses for SQLite

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

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

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

RE: [sqlite] Operation is not allowed when the object is closed

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 Founde

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

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 Me

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

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

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

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 Ligh

RE: [sqlite] sorry for the confusion re: academic software

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

RE: [sqlite] SQLite version 3 design question: '500'=500?

l, 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"

[sqlite] The return value of sqlite_open

doesn't puke, my call to sqlite_get_table does, and I think it's because I'm not using the right type of variable to contain the database handle as returned by sqlite_open. Eric Pankoke Founder Point Of Light Software http://www.polsoftware.com "Lighting The Path To Glory"

[sqlite] Compact Framework

ET, 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] Data conversion problem

). Anyone have some thoughts as to why the bloating might have occurred? 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