Re: [sqlite] yet another Unable to open database erro

On Thu, Dec 2, 2010 at 2:28 PM, Puneet Kishor wrote: > > > jason d wrote: >> Hello everyone, >> I have search the web and the mailing list as much as I can for this >> error. Now I come to you for help like always >> >> In my case I am using shell with Sqlite2 and I have

Re: [sqlite] yet another Unable to open database erro

jason d wrote: > Hello everyone, > I have search the web and the mailing list as much as I can for this > error. Now I come to you for help like always > > In my case I am using shell with Sqlite2 and I have double...triple > checked permissions. > all other DB files open but there is one that

[sqlite] yet another Unable to open database erro

Hello everyone, I have search the web and the mailing list as much as I can for this error. Now I come to you for help like always In my case I am using shell with Sqlite2 and I have double...triple checked permissions. all other DB files open but there is one that just doesnt anymore. It was

Re: [sqlite] Select fails even though data is in the table.

It is hard to debug using debugger because the process is reading from a message queue and if I stop at a break point, the message queue will fill up and the process writing to the queue will start having problems. This is a in-memory database so I cannot query from the command line. I tried

Re: [sqlite] Select fails even though data is in the table.

Duplicate row is because of uniqueness of col3 and col4. I will try to change the code to select for col3 and col4, but I am not sure it would make any difference. Hemant Shah E-mail: hj...@yahoo.com --- On Wed, 12/1/10, Jim Morris wrote: > From: Jim Morris

Re: [sqlite] Select fails even though data is in the table.

Here is the snippet of the code: int InsertIntoDatabase(char *TimeStamp, int Source, u_int32_t SeqNum, char *MD5Sum) { int ReturnCode; sqlite3_stmt *InsertStmtHandle; strcpy(SqlString, "INSERT INTO mytable(TimeStamp, col2, col3, col4) VALUES (?,?,?,?)"); ReturnCode =

Re: [sqlite] Just compiled SQLite in Visual Studio

Hello Bob, "In general, I guess that C++ is essentially the C language with a whole lot added. " If you ignore the silly minutia then this is true. My application is a mix of C and C++ all compiled with VC10. C for legacy code, C++ for the stuff I write. Most of the time I have my C code

Re: [sqlite] Cross-compiling SQLite for Blackfin+uClinux?

I don't think you need to do the LDFLAGS thing... gcc -O2 -fpic -shared -Wl,-soname,sqlite3.so -o sqlite3.so sqlite3.c Works fine for me. Though I'm not using the Blackfin compiler... Michael D. Black Senior Scientist Advanced Analytics Directorate Northrop Grumman Information Systems

Re: [sqlite] Cross-compiling SQLite for Blackfin+uClinux?

On Wed, 01 Dec 2010 17:28:29 +0100, Gilles Ganault wrote: >Any help appreciated on cross-compiling SQLite using the Autoconf >tool. Without necessarily knowing what I'm doing, the following does compile without errors:

Re: [sqlite] Select fails even though data is in the table.

To debug set your breakpoint on your error statement. Then examine col4 and build the SQL statement yourself while still at the breakpoint. Then run the command line shell and execute the SQL and see what you get. Theoretically you should see the same problem. In order to prove it you may need

Re: [sqlite] Select fails even though data is in the table.

I still think you should use the same columns for searching for the duplicate that cause the collision. Using col4 seem problematic. Can you change the code to use col2 and col3? On 12/1/2010 8:24 AM, Hemant Shah wrote: > This is a single thread/process. No other thread or process is

[sqlite] Cross-compiling SQLite for Blackfin+uClinux?

Hello I need to cross-compile SQLite on an x86 Ubuntu host for a device using the Blackfin CPU and the uClinux distribution. I downloaded sqlite-amalgamation-3.7.3.tar.gz, since it's "the recommended source distribution for all Unix and Unix-like platforms". Then, I read the README and

Re: [sqlite] Just compiled SQLite in Visual Studio

Igor,   You seemed to say that the only difference between C and C++ was the ending (.c versus whatever C++ uses), but that understanding of what you said was more a result of my ignorance of C and C++. Someone pointed out that, if I've gotten this right, in Visual Studio the ending controls

Re: [sqlite] Select fails even though data is in the table.

This is a single thread/process. No other thread or process is accessing the data. This is a single process that reads data from message queue and dumps into database to look for duplicate rows. The problem occurs for some rows only (about 3 to 5 an hour). Hemant Shah E-mail: hj...@yahoo.com

Re: [sqlite] Select fails even though data is in the table.

If you bind the wrong thing the wrong way the return code doesn't matter. Any particular reason you can't just show us the whole code section? Michael D. Black Senior Scientist Advanced Analytics Directorate Northrop Grumman Information Systems From:

Re: [sqlite] Select fails even though data is in the table.

I check for the return code after each bind call and if it is not SQLITE_OK then I return with error. So I do not think it is a bind problem. Hemant Shah E-mail: hj...@yahoo.com --- On Wed, 12/1/10, Black, Michael (IS) wrote: > From: Black, Michael (IS)

Re: [sqlite] Select fails even though data is in the table.

If you have another thread running that deletes or modifies the table, then move the commit to after the select for duplicate to ensure transactional integrity. On 12/1/2010 8:10 AM, Black, Michael (IS) wrote: > The problem is probably in the bind calls that you are not showing. > If you care

Re: [sqlite] Select fails even though data is in the table.

The problem is probably in the bind calls that you are not showing. If you care to share them we may be able to help. Michael D. Black Senior Scientist Advanced Analytics Directorate Northrop Grumman Information Systems From: sqlite-users-boun...@sqlite.org

Re: [sqlite] Select fails even though data is in the table.

The unique key is col3 and col4 (SeqNum and MD5Sum). If the insert fails for this unique key then col4 should be the same. It should find the row for the even if I select for col4 only. Hemant Shah E-mail: hj...@yahoo.com --- On Wed, 12/1/10, Jim Morris wrote: > From:

Re: [sqlite] Just compiled SQLite in Visual Studio

Igor Tandetnik wrote: > Chris Wolf wrote: > >> It depends on your definition of "object". I hate to nit-pick, but for >> me, "object" may >> contain data or code or both data and code. So with this definition, C >> implements objects >> without code. >> > > Is there

Re: [sqlite] Just compiled SQLite in Visual Studio

On Wed, Dec 01, 2010 at 03:49:40AM -0500, Chris Wolf scratched on the wall: > It depends on your definition of "object". I hate to nit-pick, but for > me, "object" may contain data or code or both data and code. So with > this definition, C implements objects without code. C++ classes don't

Re: [sqlite] Select fails even though data is in the table.

Why are you looking for a duplicate with col4 instead of the unique key, col2, col3 that caused the collision? On 12/1/2010 7:29 AM, Hemant Shah wrote: > Folks, > > My C program creates a in-memory database. It creates a table and a unique > index on two columns. If the insert fails due to

[sqlite] Select fails even though data is in the table.

Folks, My C program creates a in-memory database. It creates a table and a unique index on two columns. If the insert fails due to unique index, it prints old row and new row. Sometimes it cannot find the old row even though the insert failed. Here is the pseudo code: CreateStmt = “create

Re: [sqlite] Just compiled SQLite in Visual Studio

Chris Wolf wrote: > It depends on your definition of "object". I hate to nit-pick, but for > me, "object" may > contain data or code or both data and code. So with this definition, C > implements objects > without code. Is there really a fundamental difference between

Re: [sqlite] Fwd: [sqlite-dev] SQLIte 64bit precompiled libraries for Windows

On 1 Dec 2010, at 5:15am, Saar Carmi wrote: > Is there anyone publishing stable version of precompiled binaries of sqlite > for Windows 64-bit ? > I understand from the below sqlite.org doesn't, but there maybe another > site? SQLite comprises .c and .h files to be compiled into your own

Re: [sqlite] Just compiled SQLite in Visual Studio

>From: john darnell >Date: Mon, 29 Nov 2010 17:10:04 -0600 > >I just added it to a Visual Studio 8 project, turned off the use of >precompiled >headers (the project is a C++ project) and compiled the SQLite.c >file without >any errors.  Is it really that easy, or am

Re: [sqlite] Just compiled SQLite in Visual Studio

Doug wrote: > Igore didn't mean there is no difference between C and C++. He was just > saying a 'project' isn't C or C++. In other words, C and C++ have different > (though similar) compiler rules, syntax, etc. By default, the compiler will > compile a '.c' file using the C rules, and a