Re: [sqlite] error:library routine out of sequence

2011-08-30 Thread NOCaut
Ok I understand. And what i most do it? -- View this message in context: http://old.nabble.com/error%3Alibrary-routine-out-of-sequence-tp32365078p32367279.html Sent from the SQLite mailing list archive at Nabble.com. ___ sqlite-users mailing list sqli

Re: [sqlite] error:library routine out of sequence

2011-08-30 Thread George Brink
Yes, q.finalize() should close the previous query. But that is not the point here. All query objects are build upon the same resource (database connection). This resource cannot be shared between two queries. They have to be created and killed sequentially. CppSQLite3Query q1= db.execQuery("..

Re: [sqlite] error:library routine out of sequence

2011-08-30 Thread Stephan Beal
On Tue, Aug 30, 2011 at 6:41 PM, NOCaut wrote: > > This line most finalizate > q.finalize(); << > > or not? > it doesn't if the query throws unless the query class also calls finalize() in its dtor. -- - stephan beal http://wanderinghorse.net/home/stephan/ ___

Re: [sqlite] error:library routine out of sequence

2011-08-30 Thread NOCaut
This line most finalizate q.finalize(); << or not? IO use in the COM object when i open folder I do it somethink with Database STDMETHODIMP CMyOverlayIcon2::IsMemberOf(LPCWSTR pwszPath, DWORD dwAttrib) { // use only select query (!wcscmp(db.SQLGetConfigValue("Active") ... } -- View t

Re: [sqlite] error:library routine out of sequence

2011-08-30 Thread George Brink
This function does not have any real errors. The problem is how you call this function. If .execQuery() gives you an "out of sequence" error, that means you did not finalize() the previous query to the database. Do not forget, that CppSQLite3Query is a wrapper over serial interface, it is not an

[sqlite] error:library routine out of sequence

2011-08-30 Thread NOCaut
when i Offen use this code i see error "library routine out of sequence".I understand that swears on a second appeal to the already open as BD.No then make additional requests to fetch? wchar_t * IconDB::SQLGetConfigValue(char *Key) { CString s; wchar_t * result; char tmp[255]; CppSQLit