Re: [sqlite] Building SQLite on Windows Embedded Compact 7(WEC7)

2012-10-15 Thread Simon Slavin
On 15 Oct 2012, at 10:41pm, "Caleb A. Austin" wrote: > There is one odd part to all this > > FILE *fp; > fp = fopen("/release/sql/MYFILE.txt", "a"); > fprintf(fp, "%s\n ", "Hello World, Where there is will, there is a > way."); > fclose(fp) ; > > This works... but

Re: [sqlite] Building SQLite on Windows Embedded Compact 7(WEC7)

2012-10-15 Thread Caleb A. Austin
Slavin Sent: Monday, October 15, 2012 2:33 PM To: General Discussion of SQLite Database Subject: Re: [sqlite] Building SQLite on Windows Embedded Compact 7(WEC7) On 15 Oct 2012, at 9:50pm, "Caleb A. Austin" <caus...@climet.com> wrote: > Hmm, I will try a few other locations. It

Re: [sqlite] Building SQLite on Windows Embedded Compact 7(WEC7)

2012-10-15 Thread Caleb A. Austin
al Discussion of SQLite Database Subject: Re: [sqlite] Building SQLite on Windows Embedded Compact 7(WEC7) On 15 Oct 2012, at 9:50pm, "Caleb A. Austin" <caus...@climet.com> wrote: > Hmm, I will try a few other locations. It seems that CE does not > have a local directory t

Re: [sqlite] Building SQLite on Windows Embedded Compact 7(WEC7)

2012-10-15 Thread Caleb A. Austin
the problem... Caleb Austin -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Simon Slavin Sent: Monday, October 15, 2012 2:33 PM To: General Discussion of SQLite Database Subject: Re: [sqlite] Building SQLite on Windows Embedded Compact

Re: [sqlite] Building SQLite on Windows Embedded Compact 7(WEC7)

2012-10-15 Thread Simon Slavin
On 15 Oct 2012, at 9:50pm, "Caleb A. Austin" wrote: > Hmm, I will try a few other locations. It seems that CE does not have > a local directory that windows does. So the sqlite3_open(("count.db"), > ); even when run from /release/sql/ it thinks the root is the local >

Re: [sqlite] Building SQLite on Windows Embedded Compact 7(WEC7)

2012-10-15 Thread Caleb A. Austin
sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Joe Mistachkin Sent: Monday, October 15, 2012 10:55 AM To: 'General Discussion of SQLite Database' Subject: Re: [sqlite] Building SQLite on Windows Embedded Compact 7(WEC7) Caleb A. Austin wrote: > > What is odd, is that i

Re: [sqlite] Building SQLite on Windows Embedded Compact 7(WEC7)

2012-10-15 Thread Joe Mistachkin
Caleb A. Austin wrote: > > What is odd, is that if I use the root folder then I don't get any > errors. Meaning if I use sqlite3_open(("count.db"), ); I get a > created db file with content. > Perhaps the other directory is actually a mount point to another file system with different

Re: [sqlite] Building SQLite on Windows Embedded Compact 7(WEC7)

2012-10-15 Thread Caleb A. Austin
ing SQLite on Windows Embedded Compact 7(WEC7) Caleb A. Austin wrote: > > sqlite3_open(("/release/sql/count.db"), ); > > 1034: os_win.c: 32125: (50) winSync(/release/sql/count.db-journal) > -osError 0x32 > (50) ... > > ... create table fails... disk IO error That er

Re: [sqlite] Building SQLite on Windows Embedded Compact 7(WEC7)

2012-10-15 Thread Joe Mistachkin
Caleb A. Austin wrote: > > sqlite3_open(("/release/sql/count.db"), ); > > 1034: os_win.c: 32125: (50) winSync(/release/sql/count.db-journal) > -osError 0x32 > (50) ... > > ... create table fails... disk IO error That error code is ERROR_NOT_SUPPORTED, coming from winSync(), which probably

Re: [sqlite] Building SQLite on Windows Embedded Compact 7(WEC7)

2012-10-15 Thread Caleb A. Austin
users-boun...@sqlite.org] On Behalf Of Joe Mistachkin Sent: Friday, October 12, 2012 9:41 PM To: 'General Discussion of SQLite Database' Subject: Re: [sqlite] Building SQLite on Windows Embedded Compact 7(WEC7) Caleb A. Austin wrote: > > The top file operation works, but the sqlite3_open does not...

Re: [sqlite] Building SQLite on Windows Embedded Compact 7(WEC7)

2012-10-12 Thread Joe Mistachkin
Caleb A. Austin wrote: > > The top file operation works, but the sqlite3_open does not... > > Wondering if I need to compile an option for SQLite to be using the > correct file io for WEC7 > What return code is coming back from sqlite3_open()? Can you enable logging via the

Re: [sqlite] Building SQLite on Windows Embedded Compact 7(WEC7)

2012-10-12 Thread Caleb A. Austin
Mistachkin Sent: Friday, October 12, 2012 10:39 AM To: 'General Discussion of SQLite Database' Subject: Re: [sqlite] Building SQLite on Windows Embedded Compact 7(WEC7) Caleb A. Austin wrote: > > Any ideas on why the database is being placed in root and not in local? > My understanding is that Win

Re: [sqlite] Building SQLite on Windows Embedded Compact 7(WEC7)

2012-10-12 Thread Joe Mistachkin
Caleb A. Austin wrote: > > I have tried: > > sqlite3_open("/release/sql/countries.db", ); > I'm not sure if it will make a difference; however, I think Windows CE may need backslashes, not forward slashes. -- Joe Mistachkin ___ sqlite-users

Re: [sqlite] Building SQLite on Windows Embedded Compact 7(WEC7)

2012-10-12 Thread Caleb A. Austin
e: [sqlite] Building SQLite on Windows Embedded Compact 7(WEC7) Caleb A. Austin wrote: > > Any ideas on why the database is being placed in root and not in local? > My understanding is that Windows CE does not support the concept of a current directory. Therefore, in order for a file

Re: [sqlite] Building SQLite on Windows Embedded Compact 7(WEC7)

2012-10-12 Thread Joe Mistachkin
Caleb A. Austin wrote: > > Any ideas on why the database is being placed in root and not in local? > My understanding is that Windows CE does not support the concept of a current directory. Therefore, in order for a file to be created in a particular directory, the full path to the file must

Re: [sqlite] Building SQLite on Windows Embedded Compact 7(WEC7)

2012-10-12 Thread Caleb A. Austin
On Behalf Of Joe Mistachkin Sent: Thursday, October 11, 2012 12:35 AM To: 'General Discussion of SQLite Database' Subject: Re: [sqlite] Building SQLite on Windows Embedded Compact 7(WEC7) Caleb A. Austin wrote: > > Added near line 14092: > #define HAVE_LOCALTIME_S 0 > Since the

Re: [sqlite] Building SQLite on Windows Embedded Compact 7(WEC7)

2012-10-11 Thread Joe Mistachkin
Caleb A. Austin wrote: > > Added near line 14092: > #define HAVE_LOCALTIME_S 0 > Since the SDK you are using does not appear to provide the localtime_s function, even though it uses MSVC and its associated CRT, this makes sense. This could be defined in the Makefile and/or project properties

Re: [sqlite] Building SQLite on Windows Embedded Compact 7(WEC7)

2012-10-10 Thread Caleb A. Austin
ite Database Subject: Re: [sqlite] Building SQLite on Windows Embedded Compact 7(WEC7) On 10 Oct 2012, at 4:44pm, Caleb A. Austin <caus...@climet.com> wrote: > Then I add the SQLite3.c and SQLite3.h to the project and include > SQLite3.h into the Hello World project. This is where I

Re: [sqlite] Building SQLite on Windows Embedded Compact 7(WEC7)

2012-10-10 Thread Caleb A. Austin
...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Simon Slavin Sent: Wednesday, October 10, 2012 8:52 AM To: General Discussion of SQLite Database Subject: Re: [sqlite] Building SQLite on Windows Embedded Compact 7(WEC7) On 10 Oct 2012, at 4:44pm, Caleb A. Austin <c

Re: [sqlite] Building SQLite on Windows Embedded Compact 7(WEC7)

2012-10-10 Thread Caleb A. Austin
[mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Simon Slavin Sent: Wednesday, October 10, 2012 8:52 AM To: General Discussion of SQLite Database Subject: Re: [sqlite] Building SQLite on Windows Embedded Compact 7(WEC7) On 10 Oct 2012, at 4:44pm, Caleb A. Austin <caus...@climet.com>

Re: [sqlite] Building SQLite on Windows Embedded Compact 7(WEC7)

2012-10-10 Thread Simon Slavin
On 10 Oct 2012, at 4:44pm, Caleb A. Austin wrote: > Then I add the SQLite3.c and SQLite3.h to the project and > include SQLite3.h into the Hello World project. This is where I get the > errors. Please make sure your compiler is set to compile '.c' files as C code, and not

Re: [sqlite] Building SQLite on Windows Embedded Compact 7(WEC7)

2012-10-10 Thread Caleb A. Austin
ite] Building SQLite on Windows Embedded Compact 7(WEC7) Caleb A. Austin wrote: > > I am using SQLITE_OS_WINCE as defined: > > #if defined(_WIN32_WCE) > # define SQLITE_OS_WINCE 1 > #else > # define SQLITE_OS_WINCE 0 > #endif > Is a special SDK being used for Windows Embedd

Re: [sqlite] Building SQLite on Windows Embedded Compact 7(WEC7)

2012-10-09 Thread Joe Mistachkin
Caleb A. Austin wrote: > > I am using SQLITE_OS_WINCE as defined: > > #if defined(_WIN32_WCE) > # define SQLITE_OS_WINCE 1 > #else > # define SQLITE_OS_WINCE 0 > #endif > Is a special SDK being used for Windows Embedded Compact 7? What other defines are you using? Are you using the

Re: [sqlite] Building SQLite on Windows Embedded Compact 7(WEC7)

2012-10-09 Thread Caleb A. Austin
I am using SQLITE_OS_WINCE as defined: #if defined(_WIN32_WCE) # define SQLITE_OS_WINCE 1 #else # define SQLITE_OS_WINCE 0 #endif I have also forced #define SQLITE_OS_WINCE 1 at the top of the .c file. Would there be a basic set of define's that would build a Windows CE SQLite? I hope this

Re: [sqlite] Building SQLite on Windows Embedded Compact 7(WEC7)

2012-10-09 Thread Joe Mistachkin
Caleb A. Austin wrote: > > Warning 2 warning C4013: 'localtime_s' > undefined; assuming extern returning int > What defines are you using to compile the sqlite3.c file? Are you using the defines SQLITE_OS_WIN and SQLITE_OS_WINCE? -- Joe Mistachkin

[sqlite] Building SQLite on Windows Embedded Compact 7(WEC7)

2012-10-09 Thread Caleb A. Austin
Hi All, I am working on building SQLite and I am using(from header file): #define SQLITE_VERSION"3.7.14" #define SQLITE_VERSION_NUMBER 3007014 #define SQLITE_SOURCE_ID "2012-09-03 15:42:36 c0d89d4a9752922f9e367362366efde4f1b06f2a" I am getting the following warning and