Re: [sqlite] Crash in sqlite3_mutex_try [Was: SQLite 3.8.6 beta]

 Jan wrote: " ** can manually set this value to 1 to emulate Win98 behavior. */" Can anyone give me one good reason apart from nostalgia to support a MS system not supported by MS? Kind regards | Cordiali saluti | Vriendelijke groeten | Freundliche Grüsse, Klaas `Z4us` V  - OrcID

Re: [sqlite] Crash in sqlite3_mutex_try [Was: SQLite 3.8.6 beta]

2014-08-11 13:12 GMT+02:00 Jan Nijtmans : > And below is a minimal patch which fixes this problem. > Unfortunately, latest SQLite trunk, which fixes the SQLITE_WIN32_GETVERSIONEX problem brought back the SQLITE_WIN32_NO_ANSI problem I reported earlier -( $

Re: [sqlite] HELP sqlite3 used in vxworks has someproblem？

2014-08-03 9:56 GMT+02:00 Jan Nijtmans : > 2014-08-02 16:00 GMT+02:00 王庆刚 <2004wqg2...@163.com>: > > hi ， Can Sqlite3.c and sqlite.h be compiled in Workbench3.2 for > Vxworks6.8 ? > > When I compile them , there have so many problems . > > You can find the

Re: [sqlite] CREATE INDEX Placement

Hi, Von: Drago, William @ MWG - NARDAEAST > Does it matter if I group all of my CREATE INDEX statements at the end of > my .sql file or should they appear right after each CREATE TABLE statement? > Does SQLITE care one way or another? Semantically, it's equivalent (apart from the fact that you

Re: [sqlite] HELP sqlite3 used in vxworks has someproblem？

On Tue, Aug 12, 2014 at 8:10 AM, Jan Nijtmans wrote: > New attempt here, base on current SQLite trunk: > > I fixed the obvious errors in the fileHasMoved() routine. But as for the other patches, I don't understand

Re: [sqlite] HELP sqlite3 used in vxworks has someproblem？

2014-08-12 14:26 GMT+02:00 Richard Hipp : > This is very awkward working through a proxy. If Mr. Ling (or anybody else > with access to a VxWorks development system) wants VxWorks support in > SQLite, he can come to this mailing list himself and submit suggestions > here, where

Re: [sqlite] HELP sqlite3 used in vxworks has someproblem？

From: drhsql...@gmail.com [mailto:drhsql...@gmail.com] On Behalf Of Richard Hipp Sent: 12 August 2014 13:27 > This is very awkward working through a proxy.  If Mr. Ling (or anybody else > with access > to a VxWorks development system) wants VxWorks support in SQLite, he can > come to > this

Re: [sqlite] HELP sqlite3 used in vxworks has someproblem？

On Tue, Aug 12, 2014 at 9:23 AM, Andy Ling wrote: > > > I have been testing > the changes Jan has made and at the moment I am happy. > But we cannot use Jan's changes directly because he lives in a jurisdiction that does not recognize the ability of an author to

Re: [sqlite] Crash in sqlite3_mutex_try [Was: SQLite 3.8.6 beta]

1a) Somebody is paying you to do it. 1b) Incremental cost (or risk) of supporting it is small compared to the cost (or risk) of porting /upgrading Adam On Tue, Aug 12, 2014 at 2:46 AM, Klaas V wrote: > > > Jan wrote: " ** can manually set this value to 1 to emulate

Re: [sqlite] HELP sqlite3 used in vxworks has someproblem？

2014-08-12 15:27 GMT+02:00 Richard Hipp : > But we cannot use Jan's changes directly because he lives in a jurisdiction > that does not recognize the ability of an author to contribute their work > into the public domain. We can only use Jan's changes as a guideline for >

Re: [sqlite] HELP sqlite3 used in vxworks has someproblem？

On Tue, Aug 12, 2014 at 9:37 AM, Jan Nijtmans wrote: > 2014-08-12 15:27 GMT+02:00 Richard Hipp : > > > But we cannot use Jan's changes directly because he lives in a > jurisdiction > > that does not recognize the ability of an author to contribute their

Re: [sqlite] Not SQLite related, but, SQLite Mailing List related

Thanks Jose, this looks to be like a browser issue. Tried with Chrome and the buttons are there and working. Wonder if Google is trying to say something? {smirk} I'll check to see if JS is giving off errors or something. I've tried using a mail client before, and have installed ThunderBird and

Re: [sqlite] HELP sqlite3 used in vxworks has someproblem？

> From: drhsql...@gmail.com [mailto:drhsql...@gmail.com] On Behalf Of Richard > Hipp > Sent: 12 August 2014 14:28 > To: Andy Ling > On Tue, Aug 12, 2014 at 9:23 AM, Andy Ling wrote: >> I have been testing >> the changes Jan has made and at the moment I am happy. > But

Re: [sqlite] Cross-Platform ADO wrapper for iOS, Android and Win 8.1 WP 8.1?

Short answer: no. Longer answer: Microsoft does not (yet?) support ADO on WinRT or WP8, much less on Xamarin platforms. But it looks like the future holds a glimmer of hope. Their vNext project seems to be heading toward portable ADO, and also includes SQLite support:

Re: [sqlite] HELP sqlite3 used in vxworks has someproblem？

On Tue, Aug 12, 2014 at 10:38 AM, Andy Ling wrote: > 've just downloaded the latest pre-release > sqlite-amalgamation-201408081749.zip > a > I put a new snapshot on the download page. Please try it, *without* SQLITE_ENABLE_LOCKING_MODE. -- D. Richard Hipp

Re: [sqlite] HELP sqlite3 used in vxworks has someproblem？

> From: drhsql...@gmail.com [mailto:drhsql...@gmail.com] On Behalf Of Richard > Hipp > Sent: 12 August 2014 15:46 > I put a new snapshot on the download page.  Please try it, *without* > SQLITE_ENABLE_LOCKING_MODE. OK, it builds, but doesn't run. It is missing the patch to unixDelete. Whilst

Re: [sqlite] UEFA EURO 2012 Football Championship problem - SOLVED!!!

Thanks Petite...You, like Keith Medcalf, are a great mentor, helping me to develop my burgeoning skills in SQL. I appreciate the reason for the cause of each of the problems I encountered and how to correct them. 'Granularity' is a new term for me and I now know why multiple entries

Re: [sqlite] HELP sqlite3 used in vxworks has someproblem？

On Tue, Aug 12, 2014 at 11:40 AM, Andy Ling wrote: > > From: drhsql...@gmail.com [mailto:drhsql...@gmail.com] On Behalf Of > Richard Hipp > > Sent: 12 August 2014 15:46 > > > I put a new snapshot on the download page. Please try it, *without* > SQLITE_ENABLE_LOCKING_MODE.

Re: [sqlite] HELP sqlite3 used in vxworks has someproblem？

Doing a create table generates a disk I/O error I open / create a new database with sqlite3_open_v2 int err = sqlite3_open_v2 (file, , SQLITE_OPEN_READWRITE | SQLITE_OPEN_CREATE, "unix-namedsem") ; Then call sqlite3_exec with “CREATE TABLE t (id INTEGER PRIMARY KEY ASC)” This generates a

Re: [sqlite] HELP sqlite3 used in vxworks has someproblem？

On Tue, Aug 12, 2014 at 12:45 PM, Andy Ling wrote: > Doing a create table generates a disk I/O error > > > > I open / create a new database with sqlite3_open_v2 > > > > *int* err = sqlite3_open_v2 (file, , SQLITE_OPEN_READWRITE | > SQLITE_OPEN_CREATE, "unix-namedsem") ;

[sqlite] SQLite relative dates and join query help

I'm trying to solve the following problem in SQLite: Items are being produced with a short, fixed shelf life. Say 50 days. Item can be collected every two weeks, where each item must be registered a week before. I am trying to create a query where I can list current items and the latest day

Re: [sqlite] HELP sqlite3 used in vxworks has someproblem？

Because the file doesn't exist. I assume because this is a brand new database the file hasn't been created yet. I did debug this originally, but I don't remember the file it is trying to delete. It definitely didn't exist though. To some extent it doesn't really matter. The unixDelete

Re: [sqlite] SQLite relative dates and join query help

On 12-8-2014 19:38, Ben wrote: I'm trying to solve the following problem in SQLite: Items are being produced with a short, fixed shelf life. Say 50 days. Item can be collected every two weeks, where each item must be registered a week before. I am trying to create a query where I can list

Re: [sqlite] HELP sqlite3 used in vxworks has someproblem？

On Tue, Aug 12, 2014 at 2:00 PM, Andy Ling wrote: > Because the file doesn't exist. I assume because this is a brand new > database the file hasn't been created yet. > > I did debug this originally, but I don't remember the file it is trying to > delete. It definitely

Re: [sqlite] SQLite relative dates and join query help

On Aug 12, 2014, at 7:38 PM, Ben wrote: > The result I'm after is: > > id, prod_code, creation_date, last_book_in_date, last_collection_date > > Where the final two columns are from the collection which is the farthest in > the future, but still within the 50-day

Re: [sqlite] HELP sqlite3 used in vxworks has someproblem？

What is the name of the file that SQLite is trying to delete but which does not exist? And what is the name of the corresponding database file? The name of the file that fails unlink() will give us a big clue about what is going wrong. On Tue, Aug 12, 2014 at 2:13 PM, Richard Hipp

Re: [sqlite] HELP sqlite3 used in vxworks has someproblem？

I don't know. The standard debug doesn't print the name, so I will have to add something tomorrow. I can tell you the name of the database file is /ata0:3/testdb.sql and it gets created. It is possible things are working. It is just that the sqlite3_exec is not returning SQLITE_OK, so I give

Re: [sqlite] HELP sqlite3 used in vxworks has someproblem？

On Tue, Aug 12, 2014 at 2:46 PM, Andy Ling wrote: > I don't know. The standard debug doesn't print the name, so I will have > to add something tomorrow. > > I can tell you the name of the database file is /ata0:3/testdb.sql and it > gets created. > > It is possible things

Re: [sqlite] HELP sqlite3 used in vxworks has someproblem？

On 12 Aug 2014, at 7:46pm, Andy Ling wrote: > I can tell you the name of the database file is /ata0:3/testdb.sql and it > gets created. Can you add some commands to one of your apps using the library which create and delete a file in '/ata0:3/' and see they work ? In

Re: [sqlite] HELP sqlite3 used in vxworks has someproblem？

Our code is already creating lots of files in /ata0:3 without any problem. This is quite a mature product that is working well and is exercising the hardware and drivers extensively. The database is a new feature to initially provide persistence of some data. So I am confident there is nothing

Re: [sqlite] HELP sqlite3 used in vxworks has someproblem？

On Tue, Aug 12, 2014 at 3:54 PM, Andy Ling wrote: > > I did wonder if SQLite was making any assumptions about current > directories or the makeup of a file name. > No. Any filename will do. You have to specify -DSQLITE_ENABLE_8_3_NAMES if your filesystem is limited to

[sqlite] 2nd Call For Papers, 21th Annual Tcl/Tk Conference 2014

21'th Annual Tcl/Tk Conference (Tcl'2014) http://www.tcl.tk/community/tcl2014/ [ It is 4 weeks to the deadline for Abstracts and proposals ... ] November 10 - 14, 2014 Embassy Suites Downtown Portland, Oregon, USA Important Dates: Abstracts and proposals due Sep 8, 2014 Notification to

Re: [sqlite] HELP sqlite3 used in vxworks has someproblem？

OK, thanks. It isn't limited to 8+3. The dosFs name refers to the FAT nature of the file system, not any filename limitations. In fact files don't have to have a .extension. Regards Andy Ling From: sqlite-users-boun...@sqlite.org

Re: [sqlite] Crash in sqlite3_mutex_try [Was: SQLite 3.8.6 beta]

"Klaas V" wrote... Jan wrote: " ** can manually set this value to 1 to emulate Win98 behavior. */" Can anyone give me one good reason apart from nostalgia to support a MS system not supported by MS? There are 1000's of reason$ why, but if some win98 machines are doing jobs that are

Re: [sqlite] Crash in sqlite3_mutex_try [Was: SQLite 3.8.6 beta]

On Tue, Aug 12, 2014 at 6:50 PM, jose isaias cabrera < jic...@cinops.xerox.com> wrote: > > "Klaas V" wrote... > > >> Jan wrote: " ** can manually set this value to 1 to emulate Win98 >> behavior. >> */" >> >> Can anyone give me one good reason apart from nostalgia to support a MS >> system not

Re: [sqlite] Not SQLite related, but, SQLite Mailing List related

"Stephen Chrzanowski" wrote... Thanks Jose, this looks to be like a browser issue. Tried with Chrome and the buttons are there and working. Wonder if Google is trying to say something? {smirk} Google is trying to say something, very clear. The browser wars is just starting. josé

Re: [sqlite] Crash in sqlite3_mutex_try [Was: SQLite 3.8.6 beta]

"Richard Hipp" wrote... On Tue, Aug 12, 2014 at 6:50 PM, jose isaias cabrera < jic...@cinops.xerox.com> wrote: "Klaas V" wrote... Jan wrote: " ** can manually set this value to 1 to emulate Win98 behavior. */" Can anyone give me one good reason apart from nostalgia to support a MS

Re: [sqlite] SQLite relative dates and join query help

I don't think you want max() around collections.book_in_date. You want the max(collection_date) but the book_in_date from that row. Since the collection_date is unique, the book_in_date can only come from one record. >-Original Message- >From: sqlite-users-boun...@sqlite.org

Re: [sqlite] Not SQLite related, but, SQLite Mailing List related

*thinks back to IE1 and Netscape* Its just starting?? On Tue, Aug 12, 2014 at 7:15 PM, jose isaias cabrera < jic...@cinops.xerox.com> wrote: > "Stephen Chrzanowski" wrote... > > Thanks Jose, this looks to be like a browser issue. Tried with Chrome and >> the buttons are there and

Re: [sqlite] Not SQLite related, but, SQLite Mailing List related

"Stephen Chrzanowski" wrote... *thinks back to IE1 and Netscape* Its just starting?? True. (WebCrawler anyone?) On Tue, Aug 12, 2014 at 7:15 PM, jose isaias cabrera < jic...@cinops.xerox.com> wrote: "Stephen Chrzanowski" wrote... Thanks Jose, this looks to be like a browser issue.

Re: [sqlite] Not SQLite related, but, SQLite Mailing List related

On Tue, Aug 12, 2014 at 8:16 PM, jose isaias cabrera < jic...@cinops.xerox.com> wrote: > "Stephen Chrzanowski" wrote... > > *thinks back to IE1 and Netscape* >> >> Its just starting?? >> > > True. (WebCrawler anyone?) > I'm pretty sure vi vs emacs was the first browser war. Or IBM vs MAC.

Re: [sqlite] Not SQLite related, but, SQLite Mailing List related

On 13 Aug 2014, at 3:22am, Scott Robison wrote: > I'm pretty sure vi vs emacs was the first browser war. Or IBM vs MAC. Or > FORTRAN vs COBOL. One of those, anyway. EBCDIC vs. SIXBIT. Simon. ___ sqlite-users mailing list