I have an application using sqlite v. 3.2.1. This application is storing
some extremly important data in this database. Yesterday I received the
SQLITE_CORRUPT error message. This happened on a test system so it is not
that bad, but I am now very nervous about this happening in my production
syste
Does a virus checker have the file open?
Dave Dyer wrote:
I've got a database that is permanantly locked, presumably due to
some error. Any attempt to modify it results in a "sqlite_locked"
error. This error persists even if all users close the database.
sqlite> insert into user (nam
>
>Either there is a bug in your operating system (you didn't tell
>us what operating system you are using, by the way) or else there
>is still a process holding a transaction open that you are unaware
>of.
It turns out to be the latter.
It would be useful in such circumstances to identify the
Dave Dyer <[EMAIL PROTECTED]> wrote:
> I've got a database that is permanantly locked, presumably due to
> some error. Any attempt to modify it results in a "sqlite_locked"
> error. This error persists even if all users close the database.
>
Either there is a bug in your operating system (you
I've got a database that is permanantly locked, presumably due to
some error. Any attempt to modify it results in a "sqlite_locked"
error. This error persists even if all users close the database.
sqlite> insert into user (name) values ('fred');
SQL error: database is locked
-
On 10/19/06, Dennis Cote <[EMAIL PROTECTED]> wrote:
other mail wrote:
> Executing the following query
>
> SELECT tblLarger.* from tblSmaller JOIN tblLarger USING(id1,id2)
>
> will only return columns in tblLarger that do not exist in tblSmaller.
> For
> example id1, id2 columns will not be retur
other mail wrote:
Executing the following query
SELECT tblLarger.* from tblSmaller JOIN tblLarger USING(id1,id2)
will only return columns in tblLarger that do not exist in tblSmaller.
For
example id1, id2 columns will not be returned.
Reordering the query will correctly return all columns in
Executing the following query
SELECT tblLarger.* from tblSmaller JOIN tblLarger USING(id1,id2)
will only return columns in tblLarger that do not exist in tblSmaller. For
example id1, id2 columns will not be returned.
Reordering the query will correctly return all columns in tblLarger however
th
Executing the following query
SELECT tblLarger.* from tblSmaller JOIN tblLarger USING(id1,id2)
will only return columns in tblLarger that do not exist in tblSmaller. For
example id1, id2 columns will not be returned.
Reordering the query will correctly return all columns in tblLarger however
th
Sqlite does not use VARCHAR(n) or NUMERIC(s,p). Read up about manifest
typing in the documentation and just declare columns as underlying types
such as TEXT.
You can declare the column as anything you like, but Sqlite makes its
own decision as to what it will be.
Carlos Avogaro wrote:
Hi,
Jay Sprenkle wrote:
I didn't read the entire content of the documentation. I looked only
at the appropriate sections for the question I had. I see nothing in
the following section, or the section that lead me to it, that
indicates what versions it applies to:
[snip]
Simply substitute the less_
On 10/14/06, Will Leshner <[EMAIL PROTECTED]> wrote:
On 10/13/06, Jay Sprenkle <[EMAIL PROTECTED]> wrote:
> Having a builtin function that returns the row number of the row in
> the result set would be useful for some of the things I'm doing. Rowid
> is close, but not won't work in my applicatio
On 10/14/06, Gunnar Roth <[EMAIL PROTECTED]> wrote:
Am 14.10.2006 um 04:40 schrieb Jay Sprenkle:
>
> The problem is that the function: less_goofy_sqlite3_step(); does
> not exist in version 3.1.14.
> Nor does the function: sqlite3_extended_result_codes() ;
>
Mybe you should clean your glasse
Carlos Avogaro <[EMAIL PROTECTED]> wrote:
>
> but when I open a recorsed SELECT * FROM PRODUCT from lazarus I received
> this messages, FIELD TYPE VARCHAR(6) NOT RECOGNIZED.
>
This appears to be an issue with lazarus. Your query is
correct as written.
--
D. Richard Hipp <[EMAIL PROTEC
Hi,
I have sqLite version 3.3.6, and I'm using with lazarus in windows.
With sqlite3.exe, I created this table
create table product (cod varchar(6), ean varchar(13),
desc varchar(30), pvp numeric(10,2))
from lazarus I did 4000 insert, like this:
insert into product values (
15 matches
Mail list logo
