Simon, 

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 SQLite does not.... running the program multiple
times, adds lines to the txt file. So the full path in SQLite does not
work as I would expect....

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
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 that windows does. So the 
> sqlite3_open(("count.db"), &db); even when run from /release/sql/ it 
> thinks the root is the local directory.

Okay, I thought you knew this.  Sorry for not posting earlier.  Windows
CE does not have anything like a local directory, a current directory or
a default directory.  Every create and open command must specify a full
path.  If you do not specify a full path random things may happen,
including different things on different platforms and in different
versions.  You must learn how your device organises data files for each
application, and specify a path that your application is allowed to keep
its files in.

This is described in detail in several programming sources for WinCE,
but you can find confirmation here:

<http://msdn.microsoft.com/en-us/library/ms900336.aspx>

Simon.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
##################################################################################
CONFIDENTIALITY NOTICE: This email and any files transmitted with it are 
confidential and intended
solely for the use of the individual or entity to whom they are addressed. It 
may contain confidential,
privileged, and/or proprietary information. Any review, dissemination, 
distribution, copying, printing,
or other use of this email by persons or entities other than the addressee and 
his/her authorized agent
is prohibited. 

If you have received this email in error please notify the originator of the 
message and delete the
material from your computer.
##################################################################################
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to