https://discussions.apple.com/message/15712311#15712311
--
Marco Bambini
http://www.sqlabs.com
On Sep 5, 2011, at 10:46 PM, Lani Gonzales wrote:
> Dear Technical Support:
>
> Please help me remove this error message:
>
> The procedure entry point sqlite3_wal_checkpoint could not be locat
Dear Technical Support:
Please help me remove this error message:
The procedure entry point sqlite3_wal_checkpoint could not be located in the
dynamic link library SQlite3.dll
Please kindly send instructions on how to resolve this problem.
Thank you,
Lani Gonzales
_
answer them, if I can help. And if I know of another Forum
that answers the better will provide it.
So do not be so sanctimonious.
Guy
-Original Message-
From: Simon Slavin
Sent: Monday, January 10, 2011 5:49 PM
To: General Discussion of SQLite Database
Subject: Re: [sqlite] Help with
answer them, if I can help. And if I know of another Forum
that answers the better will provide it.
So do not be so sanctimonious.
Guy
-Original Message-
From: Simon Slavin
Sent: Monday, January 10, 2011 5:49 PM
To: General Discussion of SQLite Database
Subject: Re: [sqlite] Help with
Thank you for the reply, it makes more sense now. I'll go to the forum on
System.Data.SQLite.
BobK
--- On Mon, 1/10/11, Simon Slavin wrote:
From: Simon Slavin
Subject: Re: [sqlite] Help with SQLite and VB2010 Express
To: "General Discussion of SQLite Database"
Date: Monday, J
On 10 Jan 2011, at 9:34pm, Bob Keeland wrote:
> Obviously I don't know what I'm doing with SQLite so I'll ask the question
> that shows my ignorance.
> What is the difference between what can or should be asked on this list and
> what should be directed to the System.Data.SQLite forum?
The eas
you
cause now every thing works fine now
Be patient,
Guy
-Original Message-
From: Bob Keeland
Sent: Monday, January 10, 2011 4:34 PM
To: General Discussion of SQLite Database
Subject: Re: [sqlite] Help with SQLite and VB2010 Express
Obviously I don't know what I'm doing with
Obviously I don't know what I'm doing with SQLite so I'll ask the question that
shows my ignorance.
What is the difference between what can or should be asked on this list and
what should be directed to the System.Data.SQLite forum? They seem to have
duplicate purposes - helping people who are h
You really don't need to run the msi. You can download the binary
package and added the dlls as references and start using the
dataprovider. In the future, this sort of question should be asked in
the System.Data.SQLite forum.
On Mon, Jan 10, 2011 at 12:10 PM, Bob Keeland wrote:
> I've been strug
I've been struggling with how to use SQLite with Visual Basic2010 Express.
VB2010 Express does not work with Microsoft Access (which I've used in the
past) and so I have to use SQL. I don't feel that I need the capabilities of
Microsoft SQL Server and so I've been looking at SQLite and MySQL. I'
Igor,
That has worked perfectly. Thankyou very much for your assistance.
Regards
Andrew
--
View this message in context:
http://www.nabble.com/Help-with-SQLite-Query-tp24297858p24305860.html
Sent from the SQLite mailing list archive at Nabble.com.
___
JokBoy wrote:
> I have tried your query and I don't get any rows returned. Any ideas
> why it wouldn't work?
If you tried it against the database file you showed in your original
post, note that you have MOEData.Date in different format from
Criteria.StartTime_crit and EndTime_crit. Recall that
Igor,
I have tried your query and I don't get any rows returned. Any ideas why it
wouldn't work?
Regards
Andrew
--
View this message in context:
http://www.nabble.com/Help-with-SQLite-Query-tp24297858p24298529.html
Sent from the SQLite mailing list archive at Nabble.com.
___
JokBoy wrote:
> Basically, I would like to be able to query one table based on
> criteria entered into another table.
>
> I have attached an excel file with a couple of hours of monitoring
> data, the 10 minute data has been interpolated to give minute answers
> (as MOEData Tab in the excel sheet)
Basically, I would like to be able to query one table based on criteria
entered into another table.
I have attached an excel file with a couple of hours of monitoring data, the
10 minute data has been interpolated to give minute answers (as MOEData Tab
in the excel sheet).
This Table of Data wou
On Wed, 2008-08-20 at 09:36 +0100, Brandon, Nicholas (UK) wrote:
> > I'm using the install of Firefox that comes with the Wubi
> > install of Linux. I like sqlite, but have a little problem.
> > Perhaps someone can help.
> >
> > When I add a new record to a database, an entry screen comes
> >
Thanks to all for the guidance. Yes, I'm using it as a FF extension.
I'll have to look further in the proper forms.
Thanks again.
On Wed, 2008-08-20 at 11:20 +0530, Graeme wrote:
> As the previous rely said, this is not a sqlite problem. I am not sure what
> it
> is because Firefox by itself
> I'm using the install of Firefox that comes with the Wubi
> install of Linux. I like sqlite, but have a little problem.
> Perhaps someone can help.
>
> When I add a new record to a database, an entry screen comes
> up with my fields and the ability to enter the new record.
> But the info
As the previous rely said, this is not a sqlite problem. I am not sure what it
is because Firefox by itself does not seem to allow direct editing of the
sqlite databases it uses (are you using some extension?).
I suggest you ask on the Ubuntu forums. Also, look for the issue in the Wubi
launchp
On 8/20/08, Jeffrey Needle <[EMAIL PROTECTED]> wrote:
> I'm using the install of Firefox that comes with the Wubi install of
> Linux. I like sqlite, but have a little problem. Perhaps someone can
> help.
You don't have any problem with SQLite. Your problem is with whatever
this Wubi thing is
I'm using the install of Firefox that comes with the Wubi install of
Linux. I like sqlite, but have a little problem. Perhaps someone can
help.
When I add a new record to a database, an entry screen comes up with my
fields and the ability to enter the new record. But the information I
type into
On 10/17/07, Uma Krishnan <[EMAIL PROTECTED]> wrote:
> Yes. Makes sense (not to cache query results for embedded apps).
> So what is cached. Just dirty pages? or are raw tables cached when
> queried?
SQLite implements a tables and indices as btrees over a pager layer.
The pager layer caches pages.
PostgreSQL has the capability of storing pre-compiled SQL so that it can
be reused and have data bound to the compiled statement. I have not
looked at the mechanics, but it would be of interest and educational for
you to see the PostgreSQL approach.
Sqlite does cache the results of a query.
Yes. Makes sense (not to cache query results for embedded apps). So what is
cached. Just dirty pages? or are raw tables cached when queried?
Thanks
Uma
Scott Hess <[EMAIL PROTECTED]> wrote: On 10/17/07, Trevor Talbot wrote:
> On 10/17/07, Uma Krishnan wrote:
> > One other question, when a que
On 10/17/07, Trevor Talbot <[EMAIL PROTECTED]> wrote:
> On 10/17/07, Uma Krishnan <[EMAIL PROTECTED]> wrote:
> > One other question, when a query is issued, does SQLite cache the results,
> > so that future queries can be processed off the cache (I think not)
>
> Like the "query cache" in some oth
On 10/17/07, Uma Krishnan <[EMAIL PROTECTED]> wrote:
> As far as I know, Postgres does not have a virtual engine. I could be wrong.
It's not a virtual machine style, where it has a specific instruction
set; instead it's more like a graph of operations. Execution means
walking a graph instead of
On 10/17/07, Uma Krishnan <[EMAIL PROTECTED]> wrote:
> One other question, when a query is issued, does SQLite cache the results, so
> that future queries can be processed off the cache (I think not)
Like the "query cache" in some other databases? No.
SQLite does have a cache of database pages
Regarding: "... when a query is issued, does SQLite cache the results,
so that future queries can be processed off the cache (I think not) "
...
=
P.S. And I should certainly have mentioned the sqlite items below:
http://sqlite.org/pragma.html
PRAGMA cache_size= Number-of-pages;
Regarding: "... when a query is issued, does SQLite cache the results,
so that future queries can be processed off the cache (I think not) "
Hi Uma,
In effect, powerful caching effects *do* occur because of the disk cache
provided by modern operating systems. Since the hard disk operations
are
Thanks John and Joe for your responses.
As far as I know, Postgres does not have a virtual engine. I could be wrong.
One other question, when a query is issued, does SQLite cache the results, so
that future queries can be processed off the cache (I think not)
Thanks
Uma
John Stanton <[EMAIL
Moreover, is it typical to have an implementation like VDBE in other databases
as well?
This is a common approach and has been used for a very long time. For
example we used it in products produced during the 1980s because
producing a virtual machine and a compiler for its application-specif
--- Uma Krishnan <[EMAIL PROTECTED]> wrote:
> I'm a student trying to understand SQLite for my DB project. There are a
> couple of aspects that
> I don't quite understand:
> 1) VDBE. I see how the vdbe stack is created using VDBEAddOp etc. But once
> the code is
> generated, I don't see when it's
Hello,
I'm a student trying to understand SQLite for my DB project. There are a couple
of aspects that I don't quite understand:
1) VDBE. I see how the vdbe stack is created using VDBEAddOp etc. But once the
code is generated, I don't see when it's executed. Moreover, is it typical to
have an i
Dennis Cote wrote:
To get every N'th row after deletions you need some way to assign a
series of integers to the result rows. The easiest way I can think of
is to create a temporary table from your initial query. Then you can
use the modulus operator to select every N'th record from that table
On 3/27/06, Uma Venkataraman <[EMAIL PROTECTED]> wrote:
> I would like to delete n records from a table, based on some condition. Can
> some one please let me know how to do this with sqlite?
http://sqlite.org/lang_delete.html
The following statement should help:
delete from "table_name" where "condition";
Of course, you'd make appropriate substitutions for "table_name" and
"condition".
HTH
On 3/27/06, Uma Venkataraman <[EMAIL PROTECTED]> wrote:
>
> I would like to delete n records from a table, based on some conditio
I would like to delete n records from a table, based on some condition. Can
some one please let me know how to do this with sqlite?
Thanks
Thanks Dennis..that seems to do the trick...
- Original Message -
From: "Dennis Cote" <[EMAIL PROTECTED]>
To:
Sent: Monday, March 27, 2006 2:46 PM
Subject: Re: [sqlite] help with sqlite command
Jay Sprenkle wrote:
I believe rowid is assigned dynamically to the
Too bad sqlite doesn't have Oracle's ROWNUM:
"Pseudo-Columns
While not actual datatypes, Oracle supports several special-purpose
data elements. These elements are not actually contained in a table,
but are available for use in SQL statements as though they were part
of the table.
ROWNUM
For each
On 3/27/06, Dennis Cote <[EMAIL PROTECTED]> wrote:
> Jay,
>
> The rowid is the key from the btree used to store the table rows. It is
> not generated dynamically.
Ah. Thanks! Learn something new every day.
Jay Sprenkle wrote:
I believe rowid is assigned dynamically to the result set so it would
give a different
set of results for a different query.
Jay,
The rowid is the key from the btree used to store the table rows. It is
not generated dynamically.
To get every N'th row after deletion
"Uma Venkataraman" <[EMAIL PROTECTED]> writes:
> Hi Jay,
>
> Thanks for your reply. I am trying the command
>
>select * from mytable where row_id = row_id % 5
Try this instead:
SELECT * FROM mytable WHERE ROWID % 5 = 0;
Note that if you have an integer primary key in mytable, then ROWID a
Clark
- Original Message
From: Uma Venkataraman <[EMAIL PROTECTED]>
To: sqlite-users@sqlite.org
Sent: Monday, March 27, 2006 11:07:18 AM
Subject: Re: [sqlite] help with sqlite command
Hi Jay,
Thanks for your reply. I am trying the command
select * from mytable where row_id =
> Thanks for your reply. I am trying the command
>
> select * from mytable where row_id = row_id % 5
>
> from sqlite browser and it says, no such column row_id.. Also I replaced
> row_id with rowid and it gave only the first 4 records from my table. My
> other concern is I will be deleting and
adding records to the table. If I
want to select every nth record after such deletions and additions will the
row id not get affected?
Thanks
Uma
- Original Message -
From: "Jay Sprenkle" <[EMAIL PROTECTED]>
To:
Sent: Monday, March 27, 2006 1:56 PM
Subject: Re: [s
On 3/27/06, Uma Venkataraman <[EMAIL PROTECTED]> wrote:
> Hi All,
>
> I need to be able to select the TOP N rows from a table. How do i do it =
select * from mytable limit 5
> with sqlite? Also how does one select EVERY Nth row from a table?
use modulus operator for that:
select * from mytabl
Hi All,
I need to be able to select the TOP N rows from a table. How do i do it =
with sqlite? Also how does one select EVERY Nth row from a table?
Thanks
Hi..
We had a question regarding the lock data structures in the file
os_unix.c. The data structure is the lockInfo structure. The fields in
the lock info structure are
struct lockInfo {
struct lockKey key; /* The lookup key */
int cnt; /* Number of SHARED locks held */
int loc
48 matches
Mail list logo
