Re: [sqlite] 3.7.10 problem : SQLite header and source version mismatch

Thank you, Kevin Benson, for your hint about ldconfig Using ldconfig -p , I found their is an older version of libsqlite3 in /usr/lib/i386-linux-gnu So I replaced it with my compiled 3.7.10 version , and now sqlite3 works from the command line. regs, Kevin Youren

Re: [sqlite] FirstOrDefault crashes using linq

--- Den ons 2012-01-25 skrev Joe Mistachkin : > The supported alternative here is the ObjectContext class > from the Entity Framework Thank you. I will check this out. I am not using the Entity Framework, so I will have to figure out how to create an ObjectContext

Re: [sqlite] Found it

On 25 janv. 2012, at 22:30, John Elrick wrote: > > I have to say this has been a fascinating learning experience. It has been > enlightening reading the SQLite code and beginning to understand its inner > workings. > John > ___ What a thriller! I was holding my breath. Did you

[sqlite] sqlite3_bind_text data conversion

Hello, all. Could anybody clarify to me data conversion done in sqlite3_bind_text(), please? I've written simple test: test.c ;--X8 #include #include "sqlite3.h" int main(int argc, char* argv[]) { int rez = 0; sqlite3* ss_pdb = NULL; sqlite3_stmt* st; rez =

Re: [sqlite] sqlite3_bind_text data conversion

On 26 Jan 2012, at 12:15pm, darkelf wrote: > rez = sqlite3_exec(ss_pdb, "CREATE TABLE T(str STRING, val INTEGER);", NULL, > NULL, NULL); Datatypes in SQLite are as follows: http://www.sqlite.org/datatype3.html Your word 'STRING' is being interpreted as a numeric affinity. And as the value

Re: [sqlite] Found it

On 26/1/2012 5:21 AM, Nico Williams wrote: On Wed, Jan 25, 2012 at 3:07 PM, Richard Hipp wrote: The SQLite byte-code engine was being too conservative and was reparsing the schema in places where it was not strictly necessary. The fix was to restrict the places where the

Re: [sqlite] Found it

On Thu, Jan 26, 2012 at 3:29 AM, Jean-Denis MUYS wrote: > > On 25 janv. 2012, at 22:30, John Elrick wrote: > > > > > I have to say this has been a fascinating learning experience. It has > been > > enlightening reading the SQLite code and beginning to understand its > inner

Re: [sqlite] Query on Sqlite3 in an Android app

Thank you for your reply. I have created my own sqlite file from the command prompt. To access this database in an Android app, I should use content provider - is that what you are saying ? But I thought for using content provider, I create my own database using SQL statements in my Java code. So

Re: [sqlite] Found it

On Thu, Jan 26, 2012 at 2:53 PM, Mohit Sindhwani wrote: > Absolutely! I come home from work and tune in to this thread, gripped :) > +1 to Mohit and the others who's written similar responses. i rarely follow threads which don't directly affect me, but John Elrick's

Re: [sqlite] Found it

On Thu, Jan 26, 2012 at 12:36 PM, Stephan Beal wrote: > On Thu, Jan 26, 2012 at 2:53 PM, Mohit Sindhwani wrote: > > > Absolutely! I come home from work and tune in to this thread, gripped :) > > > > +1 to Mohit and the others who's written similar

Re: [sqlite] Query on Sqlite3 in an Android app

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 26/01/12 09:15, Lavanya Ramanan wrote: > I have created my own sqlite file from the command prompt. To access > this database in an Android app, I should use content provider - is > that what you are saying ? No. What I am saying is that if you

[sqlite] SQLite and Perl

I need to get going with Perl & SQLite and I'm wondering what I need to get off CPAN, if anything. Here's what I think I have now: root@fiberio:/etc/cron.daily# locate perl | grep SQLite /usr/share/perl/5.10.1/CPANPLUS/Internals/Source/SQLite

Re: [sqlite] SQLite and Perl

On Jan 26, 2012, at 11:59 AM, Bill McCormick wrote: > I need to get going with Perl & SQLite and I'm wondering what I need to get > off CPAN, if anything. $ cpanm DBD::SQLite there is no step two > > Here's what I think I have now: > > root@fiberio:/etc/cron.daily# locate perl | grep

[sqlite] undefined reference

Hi, I' am trying to rebuild application for a TI arm based (cortex A8) target with the arago compiler (Glibc). The program was original developed using GNU gcc with ucLibc for a 2.4 kernel. I know get undefined references (see below). Does anyone have a glue what I am doing wrong?

[sqlite] sqlite3 on Windows

I have been using sqlite on OS X for some time and sqlite3 comes pre-installed. I'm now looking at running some apps on Windows 7 and I don't think sqlite3 is pre-installed on that platform. I see there is a precompiled binary available of sqlite3 available for download - what directory should

Re: [sqlite] Found it

On 1/26/12 9:36 AM, "Stephan Beal" wrote: >On Thu, Jan 26, 2012 at 2:53 PM, Mohit Sindhwani wrote: > >> Absolutely! I come home from work and tune in to this thread, gripped >>:) >> > >+1 to Mohit and the others who's written similar responses. i rarely

Re: [sqlite] sqlite3 on Windows

On 26 Jan 2012, at 6:49pm, Pete wrote: > I have been using sqlite on OS X for some time and sqlite3 comes > pre-installed. I'm now looking at running some apps on Windows 7 and I > don't think sqlite3 is pre-installed on that platform. I see there is a > precompiled binary available of sqlite3

Re: [sqlite] Incompatible versions of SQLite on same system

Michael, That is one very cool utility! As soon as I can get access to the machine, I'll give it a spin. Thanks for the tip. Regards, Joe Original Message Subject: Re: [sqlite] Incompatible versions of SQLite on same system From: Black, Michael (IS)

Re: [sqlite] Incompatible versions of SQLite on same system

Tim, I disagree completely. It is a rare individual who will read through all of the back threads to get a handle on an issue, whereas if it were all there in a single message, the person might read it, get up to speed, and jump in. As far as your inbox growing, that's easily handled with the

Re: [sqlite] Incompatible versions of SQLite on same system

Normand, I participate in many Google and Yahoo Groups (and am an Owner, Moderator, or Manager of several), and while their web interfaces are decent, I still prefer to receive posts in my email client, for many reasons. The most important reason is search, which, strangely enough, is mediocre

Re: [sqlite] Incompatible versions of SQLite on same system

Original Message Subject: Re: [sqlite] Incompatible versions of SQLite on same system From: epank...@comcast.net To: General Discussion of SQLite Database Date: Tue Jan 24 2012 15:24:00 GMT-0600 (Central Standard Time) 1. Could we please stay on topic

Re: [sqlite] sqlite3 on Windows

On 1/26/2012 1:49 PM, Pete wrote: I have been using sqlite on OS X for some time and sqlite3 comes pre-installed. I'm now looking at running some apps on Windows 7 and I don't think sqlite3 is pre-installed on that platform. I see there is a precompiled binary available of sqlite3 available

Re: [sqlite] SQL query causes various hangs/crashes/exits

Thanks! Splitting the index into two did the trick and now the query is working well. Cheers, Larry On 25 January 2012 21:01, Igor Tandetnik wrote: > Larry Knibb wrote: >> SELECT DISTINCT d.rowid AS id, d.*, i.relevance >> FROM dictionary d >> JOIN

Re: [sqlite] Incompatible versions of SQLite on same system

I don't have access to the machine with HP Connection Manager on it, but I just ran Dependency Walker on the TurboTax 2010 executable on a W7/64-bit machine, which is the same OS as on the other box, and DW showed no entries in the module list with in the name of the module. Does this make

[sqlite] MyJSQLView Version 3.33 Released

MyJSQLView Version 3.33 Released The MyJSQLView project is pleased to release v3.33 to the public. The release includes improvements in the efficiency of use for the SQL Query Bucket and an Aggregation/GROUP BY feature for the Advanced Sort/Search Form. The new release also brings a new default

Re: [sqlite] SQLite and Perl

Puneet Kishor wrote, On 1/26/2012 12:02 PM: On Jan 26, 2012, at 11:59 AM, Bill McCormick wrote: I need to get going with Perl& SQLite and I'm wondering what I need to get off CPAN, if anything. $ cpanm DBD::SQLite there is no step two Actually, that's not correct. In my case it took

Re: [sqlite] SQLite and Perl

On Jan 26, 2012, at 2:53 PM, Bill McCormick wrote: > Puneet Kishor wrote, On 1/26/2012 12:02 PM: >> On Jan 26, 2012, at 11:59 AM, Bill McCormick wrote: >> >>> I need to get going with Perl& SQLite and I'm wondering what I need to get >>> off CPAN, if anything. >> >> >> $ cpanm DBD::SQLite

Re: [sqlite] SQLite and Perl

Puneet Kishor wrote, On 1/26/2012 3:01 PM: On Jan 26, 2012, at 2:53 PM, Bill McCormick wrote: Puneet Kishor wrote, On 1/26/2012 12:02 PM: On Jan 26, 2012, at 11:59 AM, Bill McCormick wrote: I need to get going with Perl& SQLite and I'm wondering what I need to get off CPAN, if anything.

Re: [sqlite] Incompatible versions of SQLite on same system

Joe Winograd wrote: > > I don't have access to the machine with HP Connection Manager on it, but I > just ran Dependency Walker on the TurboTax 2010 executable on a W7/64-bit > machine, which is the same OS as on the other box, and DW showed no entries > in the module list with in the name

Re: [sqlite] SQLite and Perl

Puneet Kishor wrote: On Jan 26, 2012, at 2:53 PM, Bill McCormick wrote: Puneet Kishor wrote, On 1/26/2012 12:02 PM: $ cpanm DBD::SQLite there is no step two Actually, that's not correct. In my case it took the following: Step 1: cpan DBI Step 2: cpan DBD:SQLite What is cpanm? A typo?