Re: [sqlite] hi

thanks for sending tht sample code on how to store and retrieve images into and from databases regards abirami p - Original Message - From: "Gerry Snyder" <[EMAIL PROTECTED]> To: Sent: Monday, September 11, 2006 7:32 PM Subject: Re: [sqlite] hi

RE: [sqlite] met "ARM7TDMI raised an exception,data abort" when executing sqlite3Parser() in ARM environment

Hi We have sqlite (v3.3.7) running on an os-less ARM based platform - we use MINGW cross compilers (GCC3.4.4) - from CodeSourcery. There was an issue earlier on that seems to be an issue with 64 bit support - we switched off the 64bit support in the compilation of the sqlite library and this for

RE: [sqlite] building sqlite.lib

> Download the source with the .DEF file, then run: > > LIB /DEF:sqlite.def > > That will make a lib file. Pardon my ignorance, but run how? What sort of command is that? I tried in the dos shell that obviously didn't work, oh I'm running win XP if that makes a difference. Where do I run

Re: [sqlite] building sqlite.lib

Look in the start menu, you want the Visual Studio Command Prompt. On 9/12/06, Richard Stern <[EMAIL PROTECTED]> wrote: > Download the source with the .DEF file, then run: > > LIB /DEF:sqlite.def > > That will make a lib file. Pardon my ignorance, but run how? What sort of command is that? I

RE: [sqlite] building sqlite.lib

Hi Rick! The 'LIB' itself is a command for building library from command line. But if you are using VisualC++ IDE, enter these data as an linker's commandline option. It may be not easy to find out, so there's a screenshot from my computer. Please note I use MSVC 7.1 -Original Message-

Re: Re: [sqlite] met "ARM7TDMI raised an exception,data abort" when executing sqlite3Parser() in ARM environment

[EMAIL PROTECTED] uttered: I don't think NULL callback and error pointer will be the reason. Because I've seen this kind of usage in the list for several times. Anyway, I'll try later and report the result to the list. If it is a misaligned-pointer problem, what can I do? You say you are

[sqlite] Error: file is encrypted or is not a database

SQLite Version: 2.8.17 (not 3) I have a database that when I try to open it, either with the 'C' libraries or with the sqlite.exe command-line utility, gives me the error "file is encrypted or is not a database". I opened the data file in a hex editor and noticed that the 48 byte header string

[sqlite] SQLite3 working with Visual C++.net 2003

After a lot of reading and experimenting, I was able to get SQLite3 working with Visual C++.net 2003. Here is what I did Steps to use SQLite3 in VC++.net 2003 Download the source code for sqlite3 from

Re: [sqlite] Inserting Values in Bulk

Rich Shepard wrote: Yes, 'row' is the string of values. Note, you have only got 4 columns in your column list, so you will get an error if you feed in 31 columns of data. I've corrected this already. You may need to extract the relevant columns using split to separate your string at

[sqlite] sqlit3_step question

Howdy!   I perused the documentation and wiki entries, and couldn’t find an answer to this.  If it’s obvious (and in the documentation), please feel free to tell me to RTFM and point me toward the page J   We have a multithreaded application that uses a sqlite3 database for asset

Re: [sqlite] SQLite3 working with Visual C++.net 2003

Abhilash Menon uttered: After a lot of reading and experimenting, I was able to get SQLite3 working with Visual C++.net 2003. Here is what I did ... Built the project and it worked without any issues. If you have a database ready you are ready to test and it works fine Wow! You poor soul!

Re: [sqlite] sqlit3_step question

"Evans, Mitchell" <[EMAIL PROTECTED]> wrote: > > We have a multithreaded application that uses a sqlite3 database for > asset tracking. I'm having some performance issues, and was wondering > how best to proceed. We're storing arbitrary blobs in the database, and > retrieving them in a standard

Re: [sqlite] Error: file is encrypted or is not a database

On 9/12/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: What in the world could have caused this?? Is it possible that you did some kind of global search and replace on files on your computer and this database file accidently got snagged?

RE: [sqlite] Error: file is encrypted or is not a database

Thanks, but this application resides on a PDA and my customer is reporting this issue on several PDA's. No search/replace operations are being performed at a file level on these devices. Richard -Original Message- From: Will Leshner [mailto:[EMAIL PROTECTED] Sent: Tuesday, September

[sqlite] SQLite Timeout question

Hi, I'm setting the sqlite_busy_timeout to 1500 millseconds using my database handle (DBI). When I lock the database and try to commit, it waits for 7 or 8 wallclock seconds before giving up. What's the reason for this behavior? Shouldn't the function return after 1.5 seconds? Thanks, Raj

Re: RE: [sqlite] Error: file is encrypted or is not a database

On 9/12/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: Thanks, but this application resides on a PDA and my customer is reporting this issue on several PDA's. No search/replace operations are being performed at a file level on these devices. Ah. Ok. It was just a shot in the dark. I've

Re: [sqlite] SQLite Timeout question

"Sripathi Raj" <[EMAIL PROTECTED]> wrote: > Hi, > > I'm setting the sqlite_busy_timeout to 1500 millseconds using my database > handle (DBI). When I lock the database and try to commit, it waits for 7 or > 8 wallclock seconds before giving up. What's the reason for this behavior? > Shouldn't the

Re: [sqlite] Error: file is encrypted or is not a database

Will Leshner wrote: Ah. Ok. It was just a shot in the dark. I've never seen SQLite itself change its header like that, so I suspect the culprit lies elsewhere. Most likely, the following is not the cause of your problem, but it's funny: There was once a virus that did a search and replace

Re: [sqlite] SQLite Timeout question

On 9/12/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: "Sripathi Raj" <[EMAIL PROTECTED]> wrote: > Hi, > > I'm setting the sqlite_busy_timeout to 1500 millseconds using my database > handle (DBI). When I lock the database and try to commit, it waits for 7 or > 8 wallclock seconds before

[sqlite] speed of access of table in attached database

for project reasons, I may have to break out my database and store individual tables in separate databases, ATTACH-ing them as needed. Are there any speed penalties on tables in attached databases versus tables _in_ a database, or is this a non-issue? -- Puneet Kishor http://punkish.eidesis.org/

[sqlite] HexValues

hi, i need to insert hex values in the data base and after that i have to select them again ... what's the best way for doing that ?? i first used INTERGER for that but i think that is the wrong way... p.s. i need to accress the db through my c-code thank you very much -- View this

[sqlite] Smallest INTEGER wrong? it is -9223372036854775807 and not -9223372036854775808...

Hi, in java, the smallest long is -9223372036854775808 in SQLite it seems to be -9223372036854775807 sqlite> create temp table t as select -9223372036854775807,-9223372036854775808; sqlite> select * from t; -9223372036854775807|-9.22337203685478e+18 ==> -9223372036854775808 is converted

Re: [sqlite] Smallest INTEGER wrong? it is -9223372036854775807 and not -9223372036854775808...

Michael Sizaki <[EMAIL PROTECTED]> wrote: > Hi, > > in java, the smallest long is >-9223372036854775808 > > in SQLite it seems to be >-9223372036854775807 > > sqlite> create temp table t as select > -9223372036854775807,-9223372036854775808; > sqlite> select * from t; >

Re: [sqlite] HexValues

guy12 wrote: i need to insert hex values in the data base and after that i have to select them again ... what's the best way for doing that ?? i first used INTERGER for that but i think that is the wrong way... p.s. i need to accress the db through my c-code You have a couple of

Re: [sqlite] Smallest INTEGER wrong? it is -9223372036854775807 and not -9223372036854775808...

[EMAIL PROTECTED] wrote: Michael Sizaki <[EMAIL PROTECTED]> wrote: Hi, in java, the smallest long is -9223372036854775808 in SQLite it seems to be -9223372036854775807 Bug or feature? I deliberately omitted the lower end to make the last line of sqlite3atoi64() a little

Re: [sqlite] Error: file is encrypted or is not a database

On Tue, 12 Sep 2006 14:29:12 -0400 <[EMAIL PROTECTED]> wrote: > files on your computer and this database file accidently got snagged?> > > Thanks, but this application resides on a PDA and my customer is > reporting this issue on several PDA's. No search/replace operations are > being performed

Re: [sqlite] Smallest INTEGER wrong? it is -9223372036854775807 and not -9223372036854775808...

[EMAIL PROTECTED] wrote: Michael Sizaki <[EMAIL PROTECTED]> wrote: in java, the smallest long is -9223372036854775808 in SQLite it seems to be -9223372036854775807 Bug or feature? Call it what you like. I deliberately omitted the lower end to make the last line of sqlite3atoi64() a