Re: [sqlite] Incompatible versions of SQLite on same system

2012-01-24 Thread epankoke
1. Could we please stay on topic 2. Could we please not go down this road again? If you guys really want to argue about proper posting etiquette and / or using something besides an email list, they've both been done to death. Just search the archives or start a new thread that's appropriately

Re: [sqlite] insert error

2011-12-20 Thread epankoke
Besides that, shouldn't it be cursor.execute "insert into ""default"" (rowname) values('1');" I would expect that the execute command is expecting a string containing the SQL to execute. - Original Message - From: "Petite Abeille" To: "General

Re: [sqlite] How about a proper forum rather than an e-mail list

2011-10-18 Thread epankoke
I'll say one thing - a forum would have saved me the wasted time of having to download and then delete all of this discussion about forums :) - Original Message - From: "Danny Staten" To: "General Discussion of SQLite Database"

Re: [sqlite] Max Value In Group By Scenario

2009-05-05 Thread epankoke
Thanks. - Original Message - From: "Igor Tandetnik" To: sqlite-users@sqlite.org Sent: Tuesday, May 5, 2009 8:05:42 AM GMT -05:00 US/Canada Eastern Subject: Re: [sqlite] Max Value In Group By Scenario "Eric Pankoke" wrote in message

[sqlite] SQLite and Liberty Basic

2008-10-15 Thread epankoke
I searched all the archives to no avail, so I'm probably just making this up, but I was positive that someone posted an SQLite interface written in Liberty Basic in the last month or two. If you are the person who posted such a program, if you know who did, or if you are neither but have done

Re: [sqlite] Populating and scrolling the Listbox using query

2008-04-21 Thread epankoke
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

Re: [sqlite] what platforms does SQLite run on?

2008-02-19 Thread epankoke
Honestly, the last time I did a WinCE compile was before the amalgamation, so I did not realize it had become so easy to compile for WinCE. Guess I'll be needing to make a new build when I get home tonight :) -- Eric Pankoke Founder / Lead Developer Point Of Light Software

Re: [sqlite] Re[sqlite] trieving only one record in the database

2008-01-25 Thread epankoke
You could do SELECT whatever FROM table WHERE criteria LIMIT 1 or SELECT COUNT(*) AS RowCount FROM table WHERE criteria Then just check that the value of RowCount > 0. The nice thing about the latter is that now you are set up if you ever want to know how many rows meet the criteria that

RE: [sqlite] Improving performance of SQLite. Anyone heard of Devic eSQL?

2007-12-17 Thread epankoke
Wow, I know this isn't really the point of your comment, but I always have to jump in when I see VB programmers "attacked". So as a Delphi / C++ / VB programmer, where do I fit into your analogy? Do I end up replacing myself :) -- Eric Pankoke Founder / Lead Developer Point Of Light Software

Re: [sqlite] Precompiled 2.x for Windows?

2007-09-20 Thread epankoke
Actually, it compiled, but it appears that I was not successful. The compile I made did not work for what I wanted. However, the DLL at the link you provided for me did work, so thanks for pointing that out. -- Eric Pankoke Founder / Lead Developer Point Of Light Software

[sqlite] Precompiled 2.x for Windows?

2007-09-20 Thread epankoke
Would anyone happen to have a precompiled DLL for Windows of the latest 2.x version of SQLite? I don't have the facilities to make one myself where I'm at right now, but I need one to test out a problem with an application I'm trying to support. Thank you to anyone who might be able to

Re: [sqlite] Re: Case Insensitive Equality Searches

2007-03-08 Thread epankoke
My first suggestion was using upper around both operands in the equation, but the person who needed it said that didn't work, which actually leads me to another question. Is any of this stuff (upper, collate nocase, etc) available in 2.x, or are they 3.x innovations? -- Eric Pankoke Founder /

Re: [sqlite] Case Insensitive Equality Searches

2007-03-08 Thread epankoke
Thank you. I'm sure this has been addressed before, but I couldn't remember where the list archive was. You'd think as long as I've been on this list I'd have known the answer to this anyway :) -- Eric Pankoke Founder / Lead Developer Point Of Light Software http://www.polsoftware.com/

[sqlite] Case Insensitive Equality Searches

2007-03-08 Thread epankoke
If I want to do "SELECT * FROM table WHERE field = value", how can I do this matching text only and not case? -- Eric Pankoke Founder / Lead Developer Point Of Light Software http://www.polsoftware.com/ - To

[sqlite] Backwards Conversion Of Databases

2007-03-06 Thread epankoke
This is actually a forwarded question. Someone on another group I frequent would like to convert a database from SQLite 3 to SQLite 2. I'm guessing there's nothing complex about the database, and most likely nothing SQLite 3 specific. What would be the easiest way to accomplish this task?

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

2007-02-08 Thread epankoke
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?

2007-02-08 Thread epankoke
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] Is there a SQLiteSpy-like thing that will let me change data from a grid?

2007-02-07 Thread epankoke
1. When the application first starts up, click on the Servers icon in the middle of the window. Alternatively, select Tools | Server | Server Manager. 2. For Server Engine, select SQLite (of course). If you're still using 2.x, go to step 4. 3. Select the options tab, put 3 in the first box

RE: [sqlite] How do I know sqlite_get_table is finished

2007-02-02 Thread epankoke
If you want to email me a copy of the table I'd be more than happy to try running it here and see what happens. You can send it to epankoke @ gmail dot com. -- Eric Pankoke Founder / Lead Developer Point Of Light Software http://www.polsoftware.com/ -- Original message

RE: [sqlite] How do I know sqlite_get_table is finished

2007-02-02 Thread epankoke
I'll admit I'm not much of a C expert, so I'd say Guy has a much better handle on that part than I do. As far as your code goes I only had one thought, and forgive me if this is just my ignorance of VBA. I didn't see a declaration for lReturnedRows anywhere. If you don't declare a variable,

Re: [sqlite] How do I know sqlite_get_table is finished

2007-02-01 Thread epankoke
sqlite_get_table does not terminate unless there is an error or it has retrieved all the records you asked for. Something else must have been causing the error, or the wrapper you are using is not implementing the function call correctly. -- Eric Pankoke Founder / Lead Developer Point Of

Re: [sqlite] pragma table_info not working on empty table

2007-01-24 Thread epankoke
I'm not sure if this applies here, but you could try calling this first: PRAGMA empty_result_callbacks = true; -- Eric Pankoke Founder / Lead Developer Point Of Light Software http://www.polsoftware.com/ -- Original message -- From: "RB Smissaert" <[EMAIL

Re: [sqlite] LEMON

2006-12-29 Thread epankoke
I'm not familiar with Lemon, so I don't know if this will help: http://linuxgazette.net/106/chirico.html. Also, I'd highly recommend just doing a Google search for either "Lemon Parser" or "Lemon Tutorial". -- Eric Pankoke Founder / Lead Developer Point Of Light Software

Re: [sqlite] Determining Data Types

2006-12-08 Thread epankoke
This gets into my ignorance of how sqlite works internally, but if I quote an "integer" value, it will still be stored correctly? I have no problems doing that, I just wasn't sure if that was the case. Also, how do I need to send date fields to sqlite to have them stored properly? -- Eric

Re: [sqlite] Determining Data Types

2006-12-08 Thread epankoke
I appreciate the insight, but I'm not sure it helps with my situation. This is what I'm trying to accomplish: 1. User selects 1 or more fields from a table using basic "SELECT fields FROM table" syntax, and the result is retrieved using sqlite_get_table (this is still in v2.8x) 2. User calls

[sqlite] Determining Data Types

2006-12-08 Thread epankoke
Please forgive me, because I know this has been covered before, but at the moment I'm at a loss. I am writing an SQLite wrapper for a relatively new language, and one of the requirements is that the user be able to add and update date as if they were using an ADO recordset. As a result, I

RE: [sqlite] Saving tables

2006-11-27 Thread epankoke
The extension doesn't actually matter. You could call it .bob for all SQLite cares. .db and .db3 are just conventions used to differentiate an SQLite 3 database from an older database. -- Eric Pankoke Founder / Lead Developer Point Of Light Software http://www.polsoftware.com/

RE: [sqlite] Saving tables

2006-11-27 Thread epankoke
It depends on how the wrapper was written. If it is a C wrapper with the SQLite code compiled in (like the SQLite COM control from NewObjects), then you are correct that all you need is the wrapper. However, if the wrapper makes calls to the DLL, then you will still need the SQLite dll along

Re: [sqlite] Saving tables

2006-11-27 Thread epankoke
Can you describe in more detail the process you're trying to use to do this? -- Eric Pankoke Founder / Lead Developer Point Of Light Software http://www.polsoftware.com/ -- Original message -- From: sebcity <[EMAIL PROTECTED]> > > Nope, how would i do that? >

Re: [sqlite] Saving tables

2006-11-27 Thread epankoke
Did you open the database when you launched SQLite again? Sorry if this is a stupid question, but I've never used SQLite from a command line or the shell. -- Eric Pankoke Founder / Lead Developer Point Of Light Software http://www.polsoftware.com/ -- Original message

Re: [sqlite] whether Sqlite Db supports jar files

2006-11-24 Thread epankoke
A .jar file is a Java package. If you can't open it, you must not have the Java runtime installed properly. It doesn't have anything to do with SQLite, however. -- Eric Pankoke Founder / Lead Developer Point Of Light Software http://www.polsoftware.com/ -- Original message

RE: [sqlite] Importing text file via .bat file

2006-11-15 Thread epankoke
I've noticed that you mention both VB and VBS. Is this something that you are eventually going to run from an actual VB application? If so, you might be able to use a directory notification on the directory where the import is, then just trigger an action when the import file is deleted,

Re: [sqlite] IF EXISTS when using DROP TABLE

2006-10-23 Thread epankoke
Thank you. My version does not. I had used one of the archives to search for this issue, but the thread I found did not have an answer to the question. -- Eric Pankoke Founder / Lead Developer Point Of Light Software http://www.polsoftware.com/ -- Original message

[sqlite] IF EXISTS when using DROP TABLE

2006-10-23 Thread epankoke
If I use the syntax "DROP TABLE tablename" everything is good, except of course I get a "no such table" error if the table does not exist. However, if I use the syntax "DROP TABLE IF EXISTS tablename", then I get the following error: 'near "EXISTS": syntax error'. Anyone have a thought as to

[sqlite] Random Row Selection

2003-12-04 Thread epankoke
In access, I use the following statement to select a random row: "SELECT TOP 1 * FROM Questions WHERE Not QuestionID IN (0) ORDER BY RND(QuestionID)". How might I accomplish this same thing in SQLite? -- Eric Pankoke Programmer Christian Family Software http://www.christianfamilysoftware.com/

Re: [sqlite] sqlite with eVC++

2003-11-21 Thread epankoke
Please forgive me, but I have been away from the C++ world for a long time, and as a Visual Basic developer I tend to get lazy. What do I need to do to build the .lib file through the ide? Do you have a project that you might be able to send me? I really appreciate all the help. -- Eric

Re: [sqlite] sqlite with eVC++

2003-11-21 Thread epankoke
I'm not actually sure how to compile the .lib. I used this command initially: LIB /DEF:sqlite.def /MACHINE:ARM. Is there some other way I should be building a .lib file? > > > I'm not sure what you mean by a WTL gui application, but the problem > I'm having is with compilation. I have

Re: [sqlite] sqlite with eVC++

2003-11-21 Thread epankoke
I'm not sure what you mean by a WTL gui application, but the problem I'm having is with compilation. I have included sqlite.h in my project, and I am calling two functions: sqlite_open and sqlite_close. When I compile, I get an "unresolved external" error on each of these functions, even