Re: [sqlite] sqlite-users Digest, Vol 46, Issue 29

Thanks. I guess I'd like to confirm just where column aliases can be referenced. I think they cannot be referenced within the list of column names in which they are defined, and they can be referenced in any other clauses of the SELECT statement, eg WHERE, ORDER BY, GROUP BY, HAVING. Is that

Re: [sqlite] Disk I/O Error

On Mon, Oct 31, 2011 at 5:40 PM, Pavel Ivanov wrote: > > Error code 522 is SQLITE_IOERR_SHORT_READ. It is generated here: > > > > http://www.sqlite.org/src/artifact/07acbb3e074e?ln=3012 > > > > SQLite was trying to read N bytes and got back M byes where M>0 and M > Could

Re: [sqlite] Disk I/O Error

> Error code 522 is SQLITE_IOERR_SHORT_READ.  It is generated here: > >     http://www.sqlite.org/src/artifact/07acbb3e074e?ln=3012 > > SQLite was trying to read N bytes and got back M byes where M>0 and M wrote: > On Mon, Oct 31, 2011 at 5:01 PM, Korey Calmettes > wrote:

Re: [sqlite] Disk I/O Error

On Mon, Oct 31, 2011 at 5:01 PM, Korey Calmettes wrote: > Hello, > > We are having a random problem with our system that has be puzzled at > this point. > > First a little background. We have an embedded system running an ARM > processor and JFFS file system. We are

[sqlite] UPDATE

I need help with a complex UPDATE. I want to update each row in a table, calculating an average, and then apply that value back into a column of the same row. Is this possible with Sqlite? Below is code that should work with SqlServer; its UPDATE supports a FROM statement. UPDATE m SET rtwgt =

Re: [sqlite] SQLite Expert

I use the free version of sqlite expert. I use sqlite for my IO handling. Having the power of sql available to test values, generate counts, etc... is indispensable. On Sun, Oct 30, 2011 at 2:50 PM, Abair Heart wrote: > Hi all, > > Searching the archives implies, that

[sqlite] Disk I/O Error

Hello, We are having a random problem with our system that has be puzzled at this point. First a little background. We have an embedded system running an ARM processor and JFFS file system. We are running 3.7.7.1. I e-mailed about a month ago about enabling WAL on our system. Found out

Re: [sqlite] SQLite Expert

Thanks for your answer, Jean-Christophe, I'll give it a try. Abair > On Sun, 30 Oct 2011 22:41:58 +0100 Jean-Christophe Deschamps said: > > >On 30 Oct 2011, at 7:50pm, Abair Heart wrote: > > > > > Searching the archives implies, that "sqlite expert" hasn't been asked > > > about. > > > > > >

Re: [sqlite] Slow inserts with UNIQUE

2011/10/30 Black, Michael (IS) > > #1 What version? > 3.7.8, using System.Data.Sqlite wrapper > #2 How long to insert the 1M? > 10 seconds > > #3 What's the average string size? > 55 characters > > #5 How long to create the index? > 10 seconds > #6 How long to

Re: [sqlite] ChangePassword method problem

Reading your code quickly, it seems the problem may be related to the use of single-quotes (') around the passwords in the connection string. Please remove all the single-quotes and try again. -- Joe Mistachkin ___ sqlite-users mailing list

Re: [sqlite] Best practices for dealing with password protected database

On 31 Oct 2011, at 8:07am, Eugene N wrote: > For your .NET application to use the, DB it must first decrypt it; That > means, storing the plain version in ram; A memory dump will pronto show the > contents of this sqlite database; Physical possession of the hardware concerned is always an end

Re: [sqlite] Corrupted Database

Özgür KELEŞ wrote: > We use sqlite in our industrial devices. But sometimes the database > corrupted. We could not find the problem , how it can be possible to > corrupt the database. http://www.sqlite.org/lockingv3.html Section 6.0 "How To Corrupt Your Database Files" --

Re: [sqlite] Default column values conflict with not null option

Евгений Земляков wrote: > Default column values conflict with not null option. Conflict in what sense? What statement are you executing, and how does the outcome of running that statement differ from your expectations? This works for me: create table t(x integer not

[sqlite] Default column values conflict with not null option

Default column values conflict with not null option. Truly yours, Eugene. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Corrupted Database

Hi, We use sqlite in our industrial devices. But sometimes the database corrupted. We could not find the problem , how it can be possible to corrupt the database. It is possible to see powerless on devices and OS crashes cause of electromagnetic noises, rarely. I attached some of corrupted

Re: [sqlite] Best practices for dealing with password protected database

Bernd wrote: > This may not be really SQLite specific, but as it's at least SQLite > related I thought I asked here. > Our program ships with an encrypted SQLite database that has to be > opened by the application to process some other data. As it's a .NET > application, it's very

Re: [sqlite] Best practices for dealing with password protected database

Hello Bernd! I have a very limited knowledge about such matters, but it seems to me there is a caveat in the whole area of using encrypted data on a end-user pc; For your .NET application to use the, DB it must first decrypt it; That means, storing the plain version in ram; A memory dump will

[sqlite] Best practices for dealing with password protected database

This may not be really SQLite specific, but as it's at least SQLite related I thought I asked here. Our program ships with an encrypted SQLite database that has to be opened by the application to process some other data. As it's a .NET application, it's very easy to peek inside the source code