Hi ryan bel brillo,
Do you have sqlite-3.1.5.tar.gz? If you have , could you give me one?
Thanks
sincerely
zhang jie
ryan bel brillo <[EMAIL PROTECTED]> 写道：
Hi zhang jie,
I don���t think there was a problem on the creation and updating of the
database. You see, I log every
"ryan bel brillo" <[EMAIL PROTECTED]> wrote:
>
> On linux, I got an sqlite database version 3.3.2 while on windows its
> sqlite database version 3.2.1, I'll upgrade my sqlite database to
> version 3.3.x
>
> So that's explain why sqlite database created on windows can be read
> just fine in
>>> -Original Message-
>>> From: Christian Smith [mailto:[EMAIL PROTECTED]
>>> Sent: Tuesday, March 14, 2006 4:06 AM
>>> To: sqlite-users@sqlite.org
>>> Subject: RE: [sqlite] Database created in linux cant be read in
windows
>>>
>>> On Wed, 15 Mar 2006, ryan bel brillo wrote:
>>>
I would like to be more specific about the scenario I encountered.
Suppose the following SQL statement is executed by calling sqlite3_exec:
SELECT mySqlFunction()
Inside the body of the mySqlFuntion() the following statements are executed
through calls to sqlite3_exec:
CREATE TEMP TABLE
"Iulian Popescu" <[EMAIL PROTECTED]> wrote:
> Hello,
>
>
>
> Is that possible to define a SQL function that calls sqlite3_exec on the
> same db handler through which was executed (passed to the function as user
> data)?
>
Yes. But a table being read cannot be written by the
recursive call.
Hello,
Is that possible to define a SQL function that calls sqlite3_exec on the
same db handler through which was executed (passed to the function as user
data)?
Thanks,
Iulian.
On 3/14/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
>
> Hello again,
> Thank for your answers:
> first of all thank you who pointed that i should use a close(db) at line 17
> and call sqlite3_free_table(result) even if there was an error, but these
> solutions didn´t solve my problem (the
Eno Thereska <[EMAIL PROTECTED]> wrote:
> Hi,
>
> I noticed the following strange problem when the expression to WHERE
> contains clauses that refer to the same column. Here are three queries
> and their output:
>
>
> select count(*) from table1
> where ((timestamp >13448180261410868) and
Hello again,
Thank for your answers:
first of all thank you who pointed that i should use a close(db) at line 17 and
call sqlite3_free_table(result) even if there was an error, but these solutions
didn´t solve my problem (the execution code never reached that point because
ret value was always
Eno Thereska <[EMAIL PROTECTED]> wrote:
> the integer is a 64-bit value. Does SQLite have
> trouble with those?
Nope. Not that I am aware of.
>
> Although it appears the above is not the problem, I am curious if SQlite
> will ever store an integer as a string, if the column type is
>
I tried all bracket combinations before emailing. It doesn't seem to be
a problem with the brackets.
Thanks
Eno
[EMAIL PROTECTED] wrote:
Try:
select count(*) from table1
where (timestamp >13448180261410868 and timestamp <= 13448182164507680);
not:
select count(*) from table1
where
On March 14, 2006 12:03 pm, [EMAIL PROTECTED] wrote:
> Hi all,
> I am having real problems with SQLite on Windows CE (.NET 4.1 and
> Pocket PC 2003). I have tried everything and it seems that there is a
> memory leak with SQLite on Windows CE. I have test it with SQLite
> versions 3.2.2 and 3.3.4
Thanks for the quick reply.
>SELECT DISTINCT typeof(timestamp) FROM table1;
returned "integer". Now the integer is a 64-bit value. Does SQLite have
trouble with those?
Although it appears the above is not the problem, I am curious if SQlite
will ever store an integer as a string, if the
Try:
select count(*) from table1
where (timestamp >13448180261410868 and timestamp <= 13448182164507680);
not:
select count(*) from table1
where ((timestamp >13448180261410868) and (timestamp <=
13448182164507680));
Regards.
rayB
** PLEASE CONSIDER OUR ENVIRONMENT BEFORE
Sorry, I should have said "at or before time A" :)
The problem still remains (taking off the equal sign doesn't change
anything).
Thanks
Eno
[EMAIL PROTECTED] wrote:
"The second query says that before time A there are 46 entries."
No, that is not what the query states:
select count(*)
Eno Thereska <[EMAIL PROTECTED]> wrote:
> Hi,
>
> I noticed the following strange problem when the expression to WHERE
> contains clauses that refer to the same column. Here are three queries
> and their output:
>
>
> select count(*) from table1
> where ((timestamp >13448180261410868) and
You might look to recoding your application to not use get_table, a
memory hog. Instead use step in a loop.
Jay Sprenkle wrote:
On 3/14/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
Hi all,
I am having real problems with SQLite on Windows CE (.NET 4.1 and Pocket PC
2003).
ret =
"The second query says that before time A there are 46 entries."
No, that is not what the query states:
select count(*) from table1
where (timestamp<=13448180261410868);
^
Regards.
rayB
** PLEASE CONSIDER OUR ENVIRONMENT BEFORE PRINTING
*
On 3/14/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
>
> Hi all,
> I am having real problems with SQLite on Windows CE (.NET 4.1 and Pocket PC
> 2003).
> ret = sqlite3_get_table(db, SELECT * FROM artic, result,
> rows, cols, errmsg);
> if (ret != SQLITE_OK)
> {
> MessageBox(_T(Error en
Hi,
I noticed the following strange problem when the expression to WHERE
contains clauses that refer to the same column. Here are three queries
and their output:
select count(*) from table1
where ((timestamp >13448180261410868) and (timestamp <= 13448182164507680));
output: 100
select
Hi all,
I am having real problems with SQLite on Windows CE (.NET 4.1 and Pocket PC
2003).
I have tried everything and it seems that there is a memory leak with SQLite on
Windows CE.
I have test it with SQLite versions 3.2.2 and 3.3.4 and SQLite seems that it
reserves memory and doesn´t free
On 3/14/06, Dave Brown <[EMAIL PROTECTED]> wrote:
> Thanks Jay, but perhaps you could provide some useful links to the reading
> material you suggest instead of just stating what you think I need to do?
I tried to be helpful and point out where to start.
The encyclopedia is in front of you, but
Thanks Jay, but perhaps you could provide some useful links to the reading
material you suggest instead of just stating what you think I need to do?
For example, http://www.sqlite.org/lockingv3.html provides only minimal
information on the lock types in Sqlite3.
At any rate, I do understand what
David,
I asked a similar question, and here is drh's response to me, adapted
to your situation. I think it is probably applicable to you as well.
I'm not sure this is the type of query that can be made to go really
fast no matter what. I actually haven't gotten around to doing this
yet, so I
Hi,
Hope someone out there can help - I've got this query which runs VERY
slowly:
SELECTab_tran.ins_num, holiday.hol_id, holiday.ins_num
FROM ab_tran, holiday
WHERE ab_tran.ins_num = holiday.ins_num
AND holiday.hol_id NOT IN ( SELECT number from holiday_list )
All the tables
On 3/13/06, Dave Brown <[EMAIL PROTECTED]> wrote:
> Yeah if I put BEGIN IMMEDIATE in thread1 as well, then it works, but as you
> say I don't see why I need to do this. Perhaps the implicit transaction
> which is created in my 1-line INSERT statement isn't an immediate
> transaction??
>
> Seems
> Im using a software ipswitch WS_FTP to transfer the file from linux to
> windows. Im not sure before if I configured it to binary transfer but I
> tried it again and make sure to configure it and set it to binary
> transfer, still im getting the same result.
Try setting the transfer mode to
On Mon, 13 Mar 2006 [EMAIL PROTECTED] wrote:
> [snip aio API stuff]
>After finding out about this api, I found out that at least mysql and
>postgresql use it, so I am guessing that changing the sql engine to
>generate batches of read/writes is possible.
>
>My guess is that using this api will
On Wed, 15 Mar 2006, ryan bel brillo wrote:
> Im using a software ipswitch WS_FTP to transfer the file from linux to
>windows. Im not sure before if I configured it to binary transfer but I
>tried it again and make sure to configure it and set it to binary
>transfer, still im getting the same
Okay, here's what broke: yum
System: FC4
Yum requires rpm sqlite-3.1.2-3, which provides those 'stale'
libraries I referred to.
References:
http://www.fedoraforum.org/forum/archive/index.php/t-94027.html
http://nasrat.livejournal.com/42829.html
Chuck Lima wrote:
Thanks everyone for your
Hi ryan bel brillo,
I didn't see sql erro when I create database in linux , but there are thoes
sql erroes when I created database in arm-linux after I ported sqlite2.8.17 on
AT91ARM9200 successfully.
Sqlite is embeddable database. Why can not it create database in arm-linux
correctly
31 matches
Mail list logo
