Why not have config.h statically contain:
#define SQLITE_PTR_SZ (sizeof(char*))
Wouldn't that be much easier?
Best regards,
Frank.
just put sqlite3.exe in your path (like windows folder), then you can
open a command window and play with it from there.
On 4/14/05, Mahendra Batra <[EMAIL PROTECTED]> wrote:
> I refered www.sqlite.org for dowloading sqlite and i am working in Windows. I
> followed this link :-
>
>
Hi Ken,
I don't know enough to respond to all of your questions, but maybe the
following will help for a few of them.
Locking and concurrancy info:
http://www.sqlite.org/lockingv3.html
Date/timestamp variables:
http://www.sqlite.org/lang_createtable.html
Date/time manipulation
"Dennis Volodomanov" <[EMAIL PROTECTED]> writes:
> So, "CREATE TABLE AS" will basically duplicate the table that I have (if
> I say for example, "CREATE TABLE AS myNewTable AS SELECT * FROM
> myOldTable")? Sounds good if that's true :-)
You have one too many "AS" in your example. (No "AS"
Eric:
thank you for your reply.
I ended up creating a %dbh hash with $table as the index along with one
Operating System file for each table.
I was hoping there was a way not to create so many Operating System files
because of the extra Administration they require.
can you think of any way
Hello,
Can anyone shed light on the following problem,
experienced with the SQLite command line utility
(v3.0.8) on Solaris/SPARC?
The query below hangs (fails to complete within 5
minutes) using the indices shown, but after removing
the index on the Season column (used in the WHERE
condition),
field types are retained but indexes and triggers won't be copied
On 4/14/05, [EMAIL PROTECTED]
<[EMAIL PROTECTED]> wrote:
> "Dennis Volodomanov" <[EMAIL PROTECTED]> writes:
>
> > So, "CREATE TABLE AS" will basically duplicate the table that I have (if
> > I say for example, "CREATE TABLE AS
Without having seen the EXPLAIN output for the query both with and
without the indexes present: the indexes you've created don't really
support your query very well. Of the six indexes that you've created, I
believe that only one can be used, so I'd speculate that the cause of
the slowdown is
Hi,
sqlite dll is 3.2.1
I have the folowing query:
SELECT * FROM Mactor WHERE id < 9223372036854775807 ORDER BY id DESC LIMIT 1;
where 9223372036854775807 is Maximum value of signed Int64.
Table is defined as:
CREATE TABLE Mactor (
id INTEGER PRIMARY KEY,
name TEXT,
birthName TEXT,
birthday
try
SELECT * FROM Mactor WHERE id=(Select max(id) from Mactor); //with this you get
last id.
SELECT * FROM Mactor WHERE id=(Select min(id) from Mactor); //with this you get
first id.
Xavier
Miha Vrhovnik wrote:
Hi,
sqlite dll is 3.2.1
I have the folowing query:
SELECT * FROM Mactor WHERE id <
"Miha Vrhovnik"<[EMAIL PROTECTED]> writes:
> SELECT * FROM Mactor WHERE id < 9223372036854775807 ORDER BY id DESC LIMIT 1;
>
> where 9223372036854775807 is Maximum value of signed Int64.
>
> P.S. If anybody has better Idea of how to get the last/first row (the one
> with highest/lowest ID) then
I'm wrapping sqlite3 with a lightweight little C++ API to allow me to
use it more easily from C++ code and I have a couple questions about
the lifespan of data passed into and received from the sqlite3 API:
1. Will the const char* returned by sqlite3_column_name() persist
until the statement
On 4/14/05, [EMAIL PROTECTED]
<[EMAIL PROTECTED]> wrote:
> How about these:
>
> SELECT * from Mactor WHERE id = (SELECT MAX(id) FROM Mactor);
> SELECT * from Mactor WHERE id = (SELECT MIN(id) FROM Mactor);
I am working on a similar problem at the moment, but unless I missed
something, ORDER
Hello,
I was thinking about using memory tables for short term data and was
wondering whether SQLite does anything to stop the OS paging the memory to
disk?
I know there is a POSIX function "mlock" that stop memory being paged to
disk but I believe the program has to run as root/admin since
Not to discourage you from rolling your own, but what about CppSQLite??
www.codeproject.com/database/CppSQLite.asp
(the site is down at the moment, here is the google cache:
http://64.233.167.104/search?q=cache:qULjzgqRl0oJ:www.codeproject.com/
database/CppSQLite.asp+CppSQLite=en=safari )
It
[EMAIL PROTECTED] wrote:
Eric:
thank you for your reply.
I ended up creating a %dbh hash with $table as the index along with one
Operating System file for each table.
I was hoping there was a way not to create so many Operating System files
because of the extra Administration they require.
can
Thomas Steffen <[EMAIL PROTECTED]> writes:
> On 4/14/05, [EMAIL PROTECTED]
> <[EMAIL PROTECTED]> wrote:
>> How about these:
>>
>> SELECT * from Mactor WHERE id = (SELECT MAX(id) FROM Mactor);
>> SELECT * from Mactor WHERE id = (SELECT MIN(id) FROM Mactor);
>
> I am working on a similar
On 4/14/05, [EMAIL PROTECTED]
<[EMAIL PROTECTED]> wrote:
> EXPLAIN is your friend. As can be seen by EXPLAINing each query (see below),
> there are fewer instructions involved in the one with the subquery, and no
> sorts or loops as are done in the initial method.
Well, not everybody is a
Does "select * from mactor order by id desc limit 1" and
"select * from mactor order by id limit 1" not work?
Greetings, Christian
Hi,
I'm running the latest sqlite 3.2.1 command line tool on Windows XP and have
noticed that I don't seem to be able to store 48bit integers anymore :-S
CREATE TABLE test (a INTEGER);
INSERT INTO test VALUES(4294967295);
INSERT INTO test VALUES(1099511627775);
INSERT INTO test
[EMAIL PROTECTED] wrote:
I ended up creating a %dbh hash with $table as the index along with one
Operating System file for each table.
I was hoping there was a way not to create so many Operating System files
because of the extra Administration they require.
can you think of any way around this?
I
The sqlite_master table keeps the sql used to create the table automatically.
check out
select * from sqlite_master;
On 4/14/05, Eric Bohlman <[EMAIL PROTECTED]> wrote:
> [EMAIL PROTECTED] wrote:
> > I ended up creating a %dbh hash with $table as the index along with one
> > Operating System
Thanks Dan,
That's all it was. Knock on wood (tap head).
On 4/14/05, Dan Kennedy <[EMAIL PROTECTED]> wrote:
> SQLite needs write permission to the directory as well. It could be
> that.
>
Thank you Derrell and Cory,
I can create triggers when I create the database file and I'm not using
indexes in this particular program, so that seems like the way to go.
Wouldn't a function like sqlite3_copytable(sqlite3 *pDest, sqlite3 *pSrc,
...) be a good idea? Or it would make SQLite more
Same thing on Mac OSX. Must be a platform-independent issue.
Gé
Richard Boulton wrote:
>Hi,
>
>I'm running the latest sqlite 3.2.1 command line tool on Windows XP and have
>noticed that I don't seem to be able to store 48bit integers anymore :-S
>
>CREATE TABLE test (a INTEGER);
>INSERT INTO
[15-04-2005 5:47, Gé Weijers escreveu]
Same thing on Mac OSX. Must be a platform-independent issue.
Same thing on v3.2.1 on linux (gentoo ebuild).
It looks like a bug...
~Nuno Lucas
Richard Boulton wrote:
CREATE TABLE test (a INTEGER);
INSERT INTO test VALUES(4294967295);
INSERT INTO test
Someone, plz tell me how could i embed SQLite. I included sqlite.h but getting
unresolved errors i.e the definition of functions like sqlite3_open(..) and
sqlite3_exec(..) can not be found.
Please favor me as soon as possible.
regards,
Mahendra Batra
Someone, plz tell me how could i embed SQLite. I included sqlite.h but getting
unresolved errors i.e the definition of functions like sqlite3_open(..) and
sqlite3_exec(..) can not be found.
Please favor me as soon as possible.
regards,
Mahendra Batra
28 matches
Mail list logo