On Jul 21, 2010, at 11:12 AM, preeti.yad...@wipro.com
preeti.yad...@wipro.com
wrote:
In my case, the DB is created by the older version of application and
now the new version of application is installed and End user has
option
to see old data with selecting old version of DB so its
Try to launch your appliztion with Run As Administrator(right click on exe
- Run As..).
Note: Take care about fields information for old DB and new DB while opening
tables(backward compatibility). For ex: old DB might have x number of fields
and new DB might have y number fields where x is not
We are at the early stages of development of a full text search facility on a
small (5000 rows) database with a few text fields in an embedded application.
One of our requirements is to implement Google-like suggestion prompts as the
user enters the search string.
A similar requirements was
On Tue, Jul 20, 2010 at 8:34 PM, Simon Slavin slav...@bigfraud.org wrote:
On 21 Jul 2010, at 12:42am, Sam Carleton wrote:
There are two equally
important requires, one is to connect to the second EventDB, the other
is
that the system admin can change the EventDB at any time.
You mean
On 21 Jul 2010, at 2:30pm, Sam Carleton wrote:
My issue with only attaching to the EventDB for only as long as a command is
trying to use it is: The EventDB is used a LOT, a WHOLE lot. If I attach
and drop between each little call, then within one HTTP request I might
attach and drop 3 to
Greetings and salutations.
I believe this is possible, but I can not seem to get the syntax from the
site. I have these 3 commands and 3 different steps that I want to put into
one:
1. result1 = SELECT sum(price) FROM table1 WHERE subProjID = 24;
2. result2 = SELECT sum(price) FROM table2
If the following can be considered as one step then do it like this:
BEGIN;
UPDATE LSOpenSubProjects
SET price = (SELECT sum(price) FROM table1 WHERE subProjID = 24),
udate = now
WHERE subProjID = 24;
UPDATE LSOpenProjects
SET price = (SELECT sum(price) FROM
Pavel Ivanov willingly and out of the goodness of his heart wrote:
If the following can be considered as one step then do it like this:
BEGIN;
UPDATE LSOpenSubProjects
SET price = (SELECT sum(price) FROM table1 WHERE subProjID = 24),
udate = now
WHERE subProjID = 24;
On Wed, 21 Jul 2010 14:28:12 -0400, jose isaias cabrera
cabr...@wrc.xerox.com wrote:
Greetings and salutations.
I believe this is possible, but I can not seem to get the syntax from the
site. I have these 3 commands and 3 different steps that I want to put into
one:
1. result1 = SELECT
Kees Nuyt, out of the goodness of his heart, wrote:
On Wed, 21 Jul 2010 14:28:12 -0400, jose isaias cabrera
wrote:
Greetings and salutations.
I believe this is possible, but I can not seem to get the syntax from the
site. I have these 3 commands and 3 different steps that I want to put
SQLite version 3.7.0 is now available on the website
http://www.sqlite.org/
The most important change in version 3.7.0 is that SQLite now supports
write-ahead logs as an optional method for transaction control, for improved
performance and concurrency. Additional information can be found
I have a 30MB DB file with 4 tables.
Execution time for a query is 1 sec normally but it is like 40 secs
after restarting window.
This seems to be related with file caching of Windows. The same source
code does not cause this problem on Linux.
Any ideas?
--
*Samet YASLAN*
Hi all,
I'm using sqlite 3.6.22-1 in ubuntu 10.04.
If a precompiled statement become expired, and sqlite3_step() is called,
documentation says that it will fail with a SQLITE_SCHEMA error.
/* Opcode: Expire P1 * * * *
**
** Cause precompiled statements to become expired.
Hy.
I think i found a bug on the website. Please take a look.
from the news page of the website:
---
2009-Sep-11 - Version 3.6.18
Beginning with this release, the SQLite source code is tracked and
managed using the Fossil distributed configuration
On 21 Jul 2010, at 4:56pm, Samet YASLAN wrote:
I have a 30MB DB file with 4 tables.
Execution time for a query is 1 sec normally but it is like 40 secs
after restarting window.
This seems to be related with file caching of Windows. The same source
code does not cause this problem on
D. Richard Hipp wrote:
Of course, if you do happen to run into problems, please let me know at once.
Thanks!
Simply substituting in 3.7.0 causes a few new test failures for me with the
Perl
binding, DBD::SQLite, citing disk I/O error.
However, it is more likely that the problem is in
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 07/21/2010 08:01 PM, Darren Duncan wrote:
Simply substituting in 3.7.0 causes a few new test failures for me with the
Perl
binding, DBD::SQLite, citing disk I/O error.
I can't speak for the Perl binding, but some of the underlying error
17 matches
Mail list logo