Re: [sqlite] cannot set connection while a datareader is active

So what have i do? Need to see others setting or state? If yes how? Could be a problem solved with a New compilation of dll? The strange thing is it happen sometimes in one passage, sometimes in another of proposero function. Could be generated by execution of particular sql query with date fiel

Re: [sqlite] Database access slowness on specific WinCE devices

The flash storage card can be taken out from the device. We have tried our application in the same card on other WinCE devices and the application performance is ok. The performance degrades only happen on that kind of WinCE devices. Any clue for further investigation? Phua Si Jie wrote: >>* We

Re: [sqlite] Problems with executereader in System.Data.SQLite

Ralf Jantschek wrote: > > The connection as such is ok. Updates are working. It is only the > executereader that is troubling me > For database files that need a UNC path, four leading backslashes are required. Without them, some things may appear to work correctly; however, it might also exhib

Re: [sqlite] cannot set connection while a datareader is active

Stefano Ravagni wrote: > > Can i send you a screenshot where you could see with your eyes my debug > situation ? So you could observe it cannot say there is a datareader > active and in the same time show that datareader is closed... > I've seen the screenshot; however, it does not show the in

Re: [sqlite] SQLite sub query with LIMIT not work in 2.3 device

On Mon, Apr 14, 2014 at 9:46 AM, Milap Tank wrote: > hello sir/madam > > my self milap tank from india , i am android developer > > i am develop one application in which i am using SQLITE database. > > > when i query do with multiple clause like UNION ALL,LIMIT ,GROUP BY and > also sub query >

Re: [sqlite] cannot set connection while a datareader is active

Il 14/04/2014 0.22, Joe Mistachkin ha scritto: Stefano Ravagni wrote: Hello Joe, here my code for CloseDati to help you to reproduce the error that i don't understand... ++ Public Sub CloseDati() 'chiude i dati del datareader associati all'oggetto DATI cui '

[sqlite] SQLite sub query with LIMIT not work in 2.3 device

hello sir/madam my self milap tank from india , i am android developer i am develop one application in which i am using SQLITE database. when i query do with multiple clause like UNION ALL,LIMIT ,GROUP BY and also sub query i used to run my app in > 4.0 device works fine but once i have i

Re: [sqlite] Problems with executereader in System.Data.SQLite

The connection as such is ok. Updates are working. It is only the executereader that is troubling me > -Ursprüngliche Nachricht- > Von: sqlite-users-boun...@sqlite.org [mailto:sqlite-users- > boun...@sqlite.org] Im Auftrag von Joe Mistachkin > Gesendet: Montag, 14. April 2014 20:36 > An: '

Re: [sqlite] cannot set connection while a datareader is active

Il 14/04/2014 21.12, Joe Mistachkin ha scritto: Stefano Ravagni wrote: Hello Joe, tryed to change the code in the IF expression but nothing change I would ask if you seen the screenshot i attached somes days ago because it show what happen From debugger Datareader result CLOSED and Ha

Re: [sqlite] cannot set connection while a datareader is active

Stefano Ravagni wrote: > > Hello Joe, tryed to change the code in the IF expression but nothing > change > I would ask if you seen the screenshot i attached somes days ago because > it show what happen > > From debugger Datareader result CLOSED and HasRows properties result NO > ROWS,

Re: [sqlite] Database access slowness on specific WinCE devices

Phua Si Jie wrote: > > We have used sqlite heavily in our WinCE application. Recently, we > encounter tremendously performance degrade on sqlite on some WinCE devices. > Is it possible that the flash storage on these devices is reaching the end of its useful life (i.e. and now it exhibits somew

Re: [sqlite] Problems with executereader in System.Data.SQLite

Ralf Jantschek wrote: > >$cn.ConnectionString = "Data Source=\\..." > If you are opening a database on a network share, there must now be four leading backslashes. -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@sqlite.org http://

Re: [sqlite] Problems with executereader in System.Data.SQLite

Hi, sorry for the delay. Here is the Info Table definition: CREATE TABLE next_key (max_key NUMERIC, next_key NUMERIC); Snippet> try{ [void][System.Reflection.Assembly]::LoadFrom("D:\Program Files\System.Data.SQLite\2008\bin\x32\System.Data.SQLite.dll")

Re: [sqlite] cannot set connection while a datareader is active

On 14 Apr 2014 at 15:14, Stefano Ravagni wrote: > I would ask if you seen the screenshot i attached somes days ago because > it show what happen Attachments are not allowed here. tim. ___ sqlite-users mailing list sqlite-users@sqlite.org http://

Re: [sqlite] cannot set connection while a datareader is active

Il 14/04/2014 0.22, Joe Mistachkin ha scritto: Stefano Ravagni wrote: Hello Joe, here my code for CloseDati to help you to reproduce the error that i don't understand... ++ Public Sub CloseDati() 'chiude i dati del datareader associati all'oggetto DATI cui '

Re: [sqlite] Database corruption issue

Hi, Actually we had data=writeback originally and problem also appeared. Our system has to be extremely stable and power loss can not cause any data damage at any time. We may deal with some latest data loss in such case, but no corruption is allowed. Thus, we decided to put journaling filesy

[sqlite] Database access slowness on specific WinCE devices

Hi, We have used sqlite heavily in our WinCE application. Recently, we encounter tremendously performance degrade on sqlite on some WinCE devices. On a query "select * from SysInfo" which has only 19 records, these slow units require about 2 seconds to complete the query while other device requi