Dennis Cote wrote:
>Then you should add an index on the Name column and use that to process
>your queries in Name order more quickly.
>create index on MyTable(Name);
Thanks a lot Dennis. My process is more fast by means indexing.
Dennis Cote wrote:
>If you really insist on reordering your
Given a table t (name, date)
I want to find all rows within, say, 6 months of a specific row, say
name = 'foo'. So, I am doing
SELECT name
FROM t
WHERE
(SELECT julianday(date) FROM t WHERE name = 'foo') -
julianday(date) < 180 OR
julianday(date) - (SELECT julianday(date) FROM
I didnt realize that it could cause livelocks. Thank you for bringing that to
my attention. It still doesnt explain why the database stays locked. I could
just ignore the error and wait to update the database the next time the thread
runs again. What I want to know is why once I got the
Alex Katebi wrote:
>
> I was woundering how I can update a column in my table back to its default
> value.
>
> For example:
>
> create table t1 (value integer default 55, name text);
> insert into t1(name) values('hello');
> update t1 set value=default; /* for illustration only */
>
This
Jus GoodFun wrote:
>
> Thanks for the info but before I embark on a huge coding excercise
> could you give me a vague clue as to how much work would be involved
> to get up and running?
>
Well that depends upon how similar uC/OS is to one of the supported OS.
If it is quite similar you can
"Noah Hart" <[EMAIL PROTECTED]> wrote:
> The documentation for Triggers defines a trigger step as follows:
>
> trigger-step ::= update-statement | insert-statement |
> delete-statement | select-statement
>
> What would be an example of the select-statement?
>
SELECT statements are useful
Noah Hart <[EMAIL PROTECTED]> wrote:
> The documentation for Triggers defines a trigger step as follows:
>
> trigger-step ::= update-statement | insert-statement |
> delete-statement | select-statement
>
> What would be an example of the select-statement?
Just your plain old SELECT statement.
The documentation for Triggers defines a trigger step as follows:
trigger-step ::=update-statement | insert-statement |
delete-statement | select-statement
What would be an example of the select-statement?
Regards,
Noah Hart
CONFIDENTIALITY NOTICE:
This message may contain
Jus GoodFun <[EMAIL PROTECTED]> wrote:
>
> I tried the DSQLITE_MUTEX_NOOP and then a rebuild but still
> got the following compile errors, I'm sure I'm missing something
> simple...
Try compiling with -DSQLITE_THREADSAFE=0
--
D. Richard Hipp <[EMAIL PROTECTED]>
Hi Dennis,
Thanks for the info but before I embark on a huge coding excercise could you
give me a vague clue as to how much work would be involved to get up and
running?
Is there any documentation which will help me in implementing ur suggested
changes?
Sqlite would be
Xuanvinh Vu <[EMAIL PROTECTED]> wrote:
> I did check and I have all the BEGINs and COMMITs. I understand that
> by default the sqlite busy signal is given right away so what I do is
> I wait till the next interval elapses to try to update the DB again
> by that time whatever the transaction that
I don't see any error handling in your code for SQLITE_BUSY...
Also, Depending upon the odbc driver your using, you might want to change the
begin to a "begin immediate" causing the lock to be taken out at the begin vs
later on...
Xuanvinh Vu <[EMAIL PROTECTED]> wrote:
I did check and I
"Severin Müller" <[EMAIL PROTECTED]> wrote:
> Hi Folks
>
> I have the following C funtion:
>
> void get_acc(char *src,int ac,char **av)
> {
>char *buf = "SELECT accmask FROM testtable;");
> sqlite3 *db;
> struct sqlite3_stmt *oStmt;
> int rc;
>
Well, I'm no C programmer, so I might be full of crap, but it looks like you're
closing the db connection inside your while block (after you get the first
row's data). Not sure about the exact usage for reset() and finalize(), but
they don't seem proper inside a loop like yours. Last, it
I did check and I have all the BEGINs and COMMITs. I understand that by default
the sqlite busy signal is given right away so what I do is I wait till the next
interval elapses to try to update the DB again by that time whatever the
transaction that causes the DB to block me before should
Hi Folks
I have the following C funtion:
void get_acc(char *src,int ac,char **av)
{
char *buf = "SELECT accmask FROM testtable;");
sqlite3 *db;
struct sqlite3_stmt *oStmt;
int rc;
if(sqlite3_prepare_v2(db,buf,strlen(buf),,NULL)==SQLITE_OK)
{
Xuanvinh Vu <[EMAIL PROTECTED]> wrote:
> Here is what the error looks like...
>
> [1436] 25 Mar 16:24:24 OnEveryHour: Failure occurred while updating
> the OneMonth table. Exception: System.Data.Odbc.OdbcException: ERROR
> [HY000] database is locked (5)
> What does the error code 5 stands for?
Here is what the error looks like...
[1436] 25 Mar 16:24:24 OnEveryHour: Failure occurred while updating the
OneMonth table. Exception: System.Data.Odbc.OdbcException: ERROR [HY000]
database is locked (5)
What does the error code 5 stands for? Also I started getting the errors when I
On Tue, 25 Mar 2008 11:09:55 -0400, "Derrell Lipman"
<[EMAIL PROTECTED]>
wrote:
>http://www.sqlite.org/cvstrac/wiki?p=DateAndTimeFunctions
Thanks guys. For those interested, here's a way to do it:
$sql = "SELECT * FROM calls ";
$sql .= "WHERE (julianday('now') - julianday(calls_date)) < 15";
On 3/25/08, Alex Katebi <[EMAIL PROTECTED]> wrote:
> Hi,
>
> I was woundering how I can update a column in my table back to its default
> value.
>
> For example:
>
> create table t1 (value integer default 55, name text);
> insert into t1(name) values('hello');
> update t1 set value=default;
Hi,
I was woundering how I can update a column in my table back to its default
value.
For example:
create table t1 (value integer default 55, name text);
insert into t1(name) values('hello');
update t1 set value=default; /* for illustration only */
How can I achive the desired behavior short
Russell wrote:
>
> My project had to use Qt 3.3.8, which supports sqlite V2 only. How
> can I get the source of V2?
>
You can use the CVS repository as described at the bottom of the
download page http://www.sqlite.org/download.html
Or you can modify the links shown on the download page. For
Daniel Ring wrote:
> The following behavior when using LEFT OUTER JOIN with an indexed column
> and literals in the ON clause is, I'm pretty sure, wrong. SQLite seems
> to convert the join to an INNER JOIN in some cases.
>
> The capture is from SQLite 3.4.2, but I get the same results with
I don't have TCL, so I'm trying to validate sqlite by running some of
the tests by hand.
In insert4.test, there is a sub-test
do_test insert4-2.4.1 {
execsql {
DELETE FROM t3;
INSERT INTO t3 SELECT DISTINCT * FROM t2;
SELECT * FROM t3;
}
} {9 1 1 9}
I can run this test by
Jus GoodFun wrote:
>
> I develop in 'C' within the Windows version of the Eclipse
> Environement producing embedded systems focused on the Motorola
> ColdFire Processors specifically the MCF5282.
>
> The target operating system is The uC/OS which is a preemptive
> multitasking RTOS.
>
You will
On 3/25/08, Prabowo Murti <[EMAIL PROTECTED]> wrote:
> BanuPrakash G wrote:
> > Hi,
> >
> > I have used the latest verision of sqlite i.e. sqlite-3.5.7
> > Amalgamation release
> > for PPC Arch.
> >
> > I was able to cross compile it successfull and when i use the db to
> > create
BanuPrakash G wrote:
> Hi,
>
> I have used the latest verision of sqlite i.e. sqlite-3.5.7
> Amalgamation release
> for PPC Arch.
>
> I was able to cross compile it successfull and when i use the db to
> create tables
> I see on the SQLITE shell the ERROR message as "SQL error: SQL logic
>
Try ./sqlite3
BanuPrakash G <[EMAIL PROTECTED]> wrote: Hi,
I have used the latest verision of sqlite i.e. sqlite-3.5.7
Amalgamation release
for PPC Arch.
I was able to cross compile it successfull and when i use the db to
create tables
I see on the SQLITE shell the ERROR message as
Hi,
I have used the latest verision of sqlite i.e. sqlite-3.5.7
Amalgamation release
for PPC Arch.
I was able to cross compile it successfull and when i use the db to
create tables
I see on the SQLITE shell the ERROR message as "SQL error: SQL logic
error or missing database".
i.e.
L B wrote:
> Sorry for this post, but I can't find a way to reply to a post. It seems that
> I can only reply via email to the person who answered me.
> How to reply and see my answer on this site?
>
Your email client must be using the From header rather than the Reply-To
header field when
Regarding:
In MySQL, I used the following to only get calls received in the last
two weeks:
WHERE calls_date > DATE_SUB(CURRENT_DATE, INTERVAL 15 DAY)
Is there an equivalent in SQLite, or should I perform this test in PHP?
===
Hi Giles,
The sqlite
On Tue, Mar 25, 2008 at 11:02 AM, Gilles Ganault <[EMAIL PROTECTED]> wrote:
> Hello
>
> In MySQL, I used the following to only get calls received in the last
> two weeks:
>
> WHERE calls_date > DATE_SUB(CURRENT_DATE, INTERVAL 15 DAY)
>
> Is there an equivalent in SQLite, or should I
Do a SELECT, read 100 rows, then read another 100. Your program
controls it.
Shailesh Madhukar Birari wrote:
> Does Sqlite support Paged query? what I mean is on doing select* it should
> return me first, say 100, rows and then subsequent calls should return me
> successive rows.
> Is this
Hello
In MySQL, I used the following to only get calls received in the last
two weeks:
WHERE calls_date > DATE_SUB(CURRENT_DATE, INTERVAL 15 DAY)
Is there an equivalent in SQLite, or should I perform this test in
PHP?
Thank you.
___
Mahalakshmi.m wrote:
>
> I wish to perform all operations in my code with sorted order of the Name
> field.
>
Then you should add an index on the Name column and use that to process
your queries in Name order more quickly.
create index on MyTable(Name);
If you really insist on reordering
another aproach is to use OFFSET and LIMIT in your select queries:
select * from table limit 100 offset 1
then
select * from table limit 100 offset 101
then
select * from table limit 100 offset 201
etc.
Shailesh Madhukar Birari escribió:
> Does Sqlite support Paged query? what I mean is on
"Shailesh Madhukar Birari"
<[EMAIL PROTECTED]> wrote in
message
news:[EMAIL PROTECTED]
> Does Sqlite support Paged query? what I mean is on doing select* it
> should return me first, say 100, rows and then subsequent calls
> should return me successive rows.
Do a select for all rows. Call
Does Sqlite support Paged query? what I mean is on doing select* it should
return me first, say 100, rows and then subsequent calls should return me
successive rows.
Is this supported in sqlite:? If yes, what are the interfaces?
If not, is there an easy way to add this functionality using existing
38 matches
Mail list logo