[sqlite] Northwind example database

2010-03-27 Thread GeoffW
Hi Just for educational purposes I have been experimenting a little with the Northwind Sqlite database contained on the sqlite official site. Download link: http://download.vive.net/Northwind.zip. Am I misunderstanding here or are the dates in the wrong format for sqlite within this converted

[sqlite] Porting Sqlite to MQX OS: Question 3

2010-03-22 Thread GeoffW
Hello I am still working away at this porting exercise, I have a couple of general questions please that I would value some comments on. The absence of a file locking mechanism in MQX means the best I can do is a "dot lock" type locking strategy. I have implemented this now, but what is

Re: [sqlite] Porting Sqlite to MQX OS: Question 2

2010-03-16 Thread GeoffW
having read the locking bits of osUnix.c numerous times, I am still pretty much lost. Regards Geoff Dan Kennedy-4 wrote: > > > On Mar 16, 2010, at 5:22 AM, GeoffW wrote: > >> >> Hello Dan >> >> Thanks for your useful input. To answer your ques

Re: [sqlite] Porting Sqlite to MQX OS: Question 2

2010-03-15 Thread GeoffW
I am mis-interpreting your comments here though ? Thanks for any further clarification on how to implement this. Regards Geoff Dan Kennedy-4 wrote: > > > On Mar 15, 2010, at 10:04 PM, GeoffW wrote: > >> >> Hi Kees >> >> Thanks for the response and giving

Re: [sqlite] Porting Sqlite to MQX OS: Question 2

2010-03-15 Thread GeoffW
at can be simplified and ignored. Thanks if anyone can fill in some details here. Geoff Kees Nuyt wrote: > > On Fri, 12 Mar 2010 02:22:31 -0800 (PST), GeoffW > <geoffw...@hotmail.com> wrote: > >> >>Hi >> >>Now I have got a half ported version of Sqlite

[sqlite] Porting Sqlite to MQX OS: Question 2

2010-03-12 Thread GeoffW
Hi Now I have got a half ported version of Sqlite up and running on MQX I cant put off any longer the question of file locking and how I tackle that ? For the moment i had made the xLock() and xUnlock() the same as in osWin.c version but with the Windows lock() and unlock() function calls

Re: [sqlite] Porting Sqlite to MQX Operating system

2010-03-12 Thread GeoffW
hello I thought I had better update this and confess to my sins. Good job no one is reading this thread as it is an embarassingly stupid mistake :rules: I cant believe I did this and then took so long to spot it. int sqlite3_os_init(void) { static sqlite3_vfs mqxVfs = { 1,

Re: [sqlite] Porting Sqlite to MQX Operating system

2010-03-08 Thread GeoffW
jfpd where pMethods <> 0 This call to releaseAllSavepoints has the pMethods pointer pointing at the sqlite3_io_methods mqxIoMethod structure, so a call to mqxClose() occurs and a the db file is erroneously closed. Any ideas on this would be greatly appreciated. Thanks Geoff GeoffW wrot

Re: [sqlite] Porting Sqlite to MQX Operating system

2010-03-05 Thread GeoffW
hello Dan Thanks for the very speedy reply. I have just been experimenting with the working Windows version. I only get one hit of the winOpen() function and that is with a filename parameter of the full path to my test.db file So maybe it is not a temporary journal file or maybe I am

[sqlite] Porting Sqlite to MQX Operating system

2010-03-05 Thread GeoffW
hello MQX is an Operating system from Freescale available for a number of their Mid range processors. I have started the task of porting Sqlite to run on a Coldfire V4. MQX is not as full featured as the Windows, Unix etc ports, so it is going to be a challenge. If I ever manage to get this to