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
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
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"
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
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
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
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
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
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
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
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
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 /
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/
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
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?
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/
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
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
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
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,
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
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
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
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
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
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
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/
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
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?
>
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
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
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,
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
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
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/
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
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
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
38 matches
Mail list logo