RE: [sqlite] SQLite Version 3.4.1

Hi! has anybody tried to compile SQLite for the ARM CPU architecture? Thanks, Thomas > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Sent: Friday, July 20, 2007 1:02 PM > To: sqlite-users@sqlite.org > Subject: [sqlite] SQLite Version 3.4.1 ***SPAM*** > > S

Re: [sqlite] shared cache/ test_server.c

John, The sqlite api won't block, it will return a sqlite_busy type error to any other transactions that are attempted? Correct, so there is no sqlite blocking which is a good thing when writing a server. The clients will always block waiting upon a response from the server. The server simply k

Re: [sqlite] invalid subselect is not detected ?

Joe, Indeed you are correct its a correlated subquery! Thanks again. Ken Joe Wilson <[EMAIL PROTECTED]> wrote: --- Ken wrote: > Is this an error or by design? > create table ss( ssid, ss_value); > create table s(id, s_value); ... > select id from s where id in ( select id from ss);

Re: [sqlite] Re: Re: SQL Challenge, select stack

Yes that is much better. Thanks again! Ken Igor Tandetnik <[EMAIL PROTECTED]> wrote: Ken wrote: > The 22 is kind of like a time stamp.. (or you could just as easily > add another column indicative of a timestamp. > > insert into stack values (1, 1234); > insert into stack values (2, 1234);

Re: [sqlite] SQLite Version 3.4.1

On 7/23/07, Steinmaurer Thomas <[EMAIL PROTECTED]> wrote: Hi! has anybody tried to compile SQLite for the ARM CPU architecture? Sure, I've been using it for several years on an XScale-based system. It works just fine, in my experience. We configure it for cross-compilation with the parameters

RE: [sqlite] SQLite Version 3.4.1

> -Original Message- > From: Steinmaurer Thomas [mailto:[EMAIL PROTECTED] > Sent: Monday, July 23, 2007 1:12 AM > To: sqlite-users@sqlite.org > Subject: RE: [sqlite] SQLite Version 3.4.1 > > Hi! > > has anybody tried to compile SQLite for the ARM CPU architecture? > Yup. http://sqlite

Re: [sqlite] shared cache/ test_server.c

That is why the Sqlite locking is not a good fit for a threaded server. Why not use thread locks instead and achieve the synchronization with minimum overhead and latency? You do miss out on a couple of Sqlite features doing that (the pending and reserved locks which help with concurrency and

Re: [sqlite] shared cache/ test_server.c

John, The server can maintaine a "shared cache" but if a thread also opens the DB then that execution line will not have a "shared cache" but rather a cache per thread. Only the server thread may open and act upon the connection utilizing a shared cache on behalf of the client. The client may

[sqlite] Begining SQLite

hello please help me: i am New to SQLITE i want to begin Using SQLite with my Enterprise Application using Visual Basic 6 and VB .Net (2005) 1. ho to Create my First SQLite Database ? 2. ho to Connect, Add, modifi, Remove and ... my SQLite database ? 3. if you have a SQLite com component access

RE: [sqlite] Begining SQLite

> -Original Message- > From: Meftah Tayeb [mailto:[EMAIL PROTECTED] > Sent: Monday, July 23, 2007 12:27 PM > To: sqlite-users@sqlite.org; [EMAIL PROTECTED] > Subject: [sqlite] Begining SQLite > > hello > > please help me: > i am New to SQLITE > i want to begin Using SQLite with my Enterp

[sqlite] problem with date/time

Hi, I am having problems with my compiled sqlite (win32/vs2005). All was working fine until I needed to use date/time functions, following sql always returns same date/time (date part is correct only time was pointing to 18:00) SELECT strftime( '%s', 'now') After diging source code with debuger

Re: [sqlite] shared cache/ test_server.c

Ken wrote: I guess my point was that inside the server thread, once a transaction is entered upon behalf of a client then only that activity may continue and no others. So in my design i only had two choices, re-enqueue the message inside the server until the transactional thread completed or r

Re: [sqlite] Begining SQLite

Hello Thank you for this SQLite ADO .Net Data provider is working very correctly but ho to Create my SQLite database ? thank you my frients - Original Message - From: "Robert Simpson" <[EMAIL PROTECTED]> To: Sent: Monday, July 23, 2007 9:54 PM Subject: RE: [sqlite] Begining SQLite -

RE: [sqlite] Begining SQLite

> -Original Message- > From: Meftah Tayeb [mailto:[EMAIL PROTECTED] > Sent: Monday, July 23, 2007 3:33 PM > To: sqlite-users@sqlite.org > Subject: Re: [sqlite] Begining SQLite > > Hello > > Thank you for this SQLite ADO .Net Data provider > is working very correctly > but ho to Create my

RE: [sqlite] Begining SQLite

> -Original Message- > From: Meftah Tayeb [mailto:[EMAIL PROTECTED] > Sent: Monday, July 23, 2007 3:33 PM > To: sqlite-users@sqlite.org > Subject: Re: [sqlite] Begining SQLite > > Hello > > Thank you for this SQLite ADO .Net Data provider > is working very correctly > but ho to Create my

Re: [sqlite] problem with date/time

On 7/23/07, JJ <[EMAIL PROTECTED]> wrote: Hi, I am having problems with my compiled sqlite (win32/vs2005). All was working fine until I needed to use date/time functions, following sql always returns same date/time (date part is correct only time was pointing to 18:00) SELECT strftime( '%s', '

[sqlite] how can i bound signed integer (negative) to an identifier in select query

Hi, I have a table with one of the columns storing negative integers in it. There is one function that performs different query operations on this table based on input range for those negative integers. When I try to use a "select where" query with an inequality using negative number semantics, th

Re: [sqlite] how can i bound signed integer (negative) to an identifier in select query

Is it possible that the data type of the column in the CREATE TABLE statement is not "INTEGER" but some other string? This web page: describes the data type affinities applied for the various values of the data type in the create table statement, and if the

RE: [sqlite] how can i bound signed integer (negative) to an identifier in select query

Thanks for your reply Andrew, No, the column is defined as "integer primary key". Regards, -shashikant -Original Message- From: Andrew Finkenstadt [mailto:[EMAIL PROTECTED] Sent: Monday, July 23, 2007 7:51 PM To: sqlite-users@sqlite.org Subject: Re: [sqlite] how can i bound signed intege

Re: [sqlite] how can i bound signed integer (negative) to an identifier in select query

On Mon, 2007-07-23 at 19:33 -0700, Shashikant Shukla wrote: > Hi, > > I have a table with one of the columns storing negative integers in it. > There is one function that performs different query operations on this > table based on input range for those negative integers. When I try to > use a "se

RE: [sqlite] SQLite Version 3.4.1

Hello, thanks for the cross-compiling hints! This is something I had been looking for. Thanks, Thomas > -Original Message- > From: Ben Combee [mailto:[EMAIL PROTECTED] > Sent: Monday, July 23, 2007 5:35 PM > To: sqlite-users@sqlite.org > Subject: Re: [sqlite] SQLite Version 3.4.1 >

RE: [sqlite] SQLite Version 3.4.1

Hi, ___ > > -Original Message- > > From: Steinmaurer Thomas [mailto:[EMAIL PROTECTED] > > Sent: Monday, July 23, 2007 1:12 AM > > To: sqlite-users@sqlite.org > > Subject: RE: [sqlite] SQLite Version 3.4.1 > > > > Hi! > > > > has anybody