Re: [sqlite] Compiling SQLite3 to run on Windows Mobile 6.5

[Tim Leland]

Thanks Michael I got it to work.

-Original Message-
From: sqlite-users-boun...@sqlite.org
[mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Black, Michael (IS)
Sent: Saturday, February 11, 2012 7:57 AM
To: General Discussion of SQLite Database
Subject: Re: [sqlite] Compiling SQLite3 to run on Windows Mobile 6.5



Here's exactly what I did.  You get a different result?



sqlite3 test1.db

create table grocery(a int,b int);

insert into grocery values(1,2);

insert into grocery values(2,3);

.quit



copy test1.db test2.db

copy test1.db test3.db



At this point I have:

02/11/2012  06:53 AM   228 dump.bat
02/11/2012  06:42 AM49 loop.bat
02/11/2012  06:48 AM 2,048 test1.db
02/11/2012  06:48 AM 2,048 test2.db
02/11/2012  06:48 AM 2,048 test3.db



loop test?.db



Then I have

02/11/2012  06:53 AM   228 dump.bat
02/11/2012  06:54 AM70 grocery.sql
02/11/2012  06:42 AM49 loop.bat
02/11/2012  06:54 AM 8 test1.csv
02/11/2012  06:48 AM 2,048 test1.db
02/11/2012  06:54 AM 8 test2.csv
02/11/2012  06:48 AM 2,048 test2.db
02/11/2012  06:54 AM 8 test3.csv
02/11/2012  06:48 AM 2,048 test3.db
   9 File(s)  6,515 bytes
   2 Dir(s)  201,627,729,920 bytes free

D:\SQLite\xx>more test1.csv
1,2
2,3



Using these two batch files

loop.bat

@for %%i in (%1) do @call dump %%i

dump.bat

@del /q %~n1.csv
@if not exist %1 echo No such file: %1
@echo .separator "," >grocery.sql
@echo .output %~n1.csv >>grocery.sql
@echo select * from grocery; >>grocery.sql
@echo .quit >>grocery.sql
@sqlite3 %1 mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Black, Michael (IS)
Sent: Thursday, February 09, 2012 3:04 PM
To: General Discussion of SQLite Database
Subject: Re: [sqlite] Compiling SQLite3 to run on Windows Mobile 6.5

Let's change them a touch...one too many @'s in loop.bat

loop.bat

@for %%i in (%1) do @call dump %%i

dump.bat

@echo .separator "," >grocery.sql
@echo .output %~n1.csv >>grocery.sql
@echo select * from grocery; >>grocery.sql
@echo .quit >>grocery.sql
@sqlite3 %1 grocery.sql
echo .output %~n1.csv >>grocery.sql
echo select * from grocery; >>grocery.sql echo .quit >>grocery.sql
sqlite3 %1 mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Simon Slavin
Sent: Thursday, February 09, 2012 1:39 PM
To: General Discussion of SQLite Database
Subject: Re: [sqlite] Compiling SQLite3 to run on Windows Mobile 6.5


On 9 Feb 2012, at 6:28pm, Tim Leland wrote:

> That will work but we have to import the sqlite file into our
AS400/Iseries
> IBM (DB2)system. Easiest way is convert it to a .csv file for the import.
My
> last resort is just run a script on the PC side that will run sqlite3.exe
> shell and convert the sqlite file to a .csv but I want to avoid that step.
> If you know of a way for an as400 to import sqlite files that would be
> great!

Oh, you're that guy.  Okay, I'd forgotten your hosting side was on an AS400.

Simon.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users


___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users


___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users


___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Compiling SQLite3 to run on Windows Mobile 6.5

[Black, Michael (IS)]

Here's exactly what I did.  You get a different result?



sqlite3 test1.db

create table grocery(a int,b int);

insert into grocery values(1,2);

insert into grocery values(2,3);

.quit



copy test1.db test2.db

copy test1.db test3.db



At this point I have:

02/11/2012  06:53 AM   228 dump.bat
02/11/2012  06:42 AM49 loop.bat
02/11/2012  06:48 AM 2,048 test1.db
02/11/2012  06:48 AM 2,048 test2.db
02/11/2012  06:48 AM 2,048 test3.db



loop test?.db



Then I have

02/11/2012  06:53 AM   228 dump.bat
02/11/2012  06:54 AM70 grocery.sql
02/11/2012  06:42 AM49 loop.bat
02/11/2012  06:54 AM 8 test1.csv
02/11/2012  06:48 AM 2,048 test1.db
02/11/2012  06:54 AM 8 test2.csv
02/11/2012  06:48 AM 2,048 test2.db
02/11/2012  06:54 AM 8 test3.csv
02/11/2012  06:48 AM 2,048 test3.db
   9 File(s)  6,515 bytes
   2 Dir(s)  201,627,729,920 bytes free

D:\SQLite\xx>more test1.csv
1,2
2,3



Using these two batch files

loop.bat

@for %%i in (%1) do @call dump %%i

dump.bat

@del /q %~n1.csv
@if not exist %1 echo No such file: %1
@echo .separator "," >grocery.sql
@echo .output %~n1.csv >>grocery.sql
@echo select * from grocery; >>grocery.sql
@echo .quit >>grocery.sql
@sqlite3 %1 mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Black, Michael (IS)
Sent: Thursday, February 09, 2012 3:04 PM
To: General Discussion of SQLite Database
Subject: Re: [sqlite] Compiling SQLite3 to run on Windows Mobile 6.5

Let's change them a touch...one too many @'s in loop.bat

loop.bat

@for %%i in (%1) do @call dump %%i

dump.bat

@echo .separator "," >grocery.sql
@echo .output %~n1.csv >>grocery.sql
@echo select * from grocery; >>grocery.sql
@echo .quit >>grocery.sql
@sqlite3 %1 grocery.sql
echo .output %~n1.csv >>grocery.sql
echo select * from grocery; >>grocery.sql echo .quit >>grocery.sql
sqlite3 %1 mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Simon Slavin
Sent: Thursday, February 09, 2012 1:39 PM
To: General Discussion of SQLite Database
Subject: Re: [sqlite] Compiling SQLite3 to run on Windows Mobile 6.5


On 9 Feb 2012, at 6:28pm, Tim Leland wrote:

> That will work but we have to import the sqlite file into our
AS400/Iseries
> IBM (DB2)system. Easiest way is convert it to a .csv file for the import.
My
> last resort is just run a script on the PC side that will run sqlite3.exe
> shell and convert the sqlite file to a .csv but I want to avoid that step.
> If you know of a way for an as400 to import sqlite files that would be
> great!

Oh, you're that guy.  Okay, I'd forgotten your hosting side was on an AS400.

Simon.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users


___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users


___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Compiling SQLite3 to run on Windows Mobile 6.5

[Tim Leland]

I still wasn't able to get this to work. It doesn't do anything.

-Original Message-
From: sqlite-users-boun...@sqlite.org
[mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Black, Michael (IS)
Sent: Thursday, February 09, 2012 3:04 PM
To: General Discussion of SQLite Database
Subject: Re: [sqlite] Compiling SQLite3 to run on Windows Mobile 6.5

Let's change them a touch...one too many @'s in loop.bat

loop.bat

@for %%i in (%1) do @call dump %%i

dump.bat

@echo .separator "," >grocery.sql
@echo .output %~n1.csv >>grocery.sql
@echo select * from grocery; >>grocery.sql
@echo .quit >>grocery.sql
@sqlite3 %1 grocery.sql
echo .output %~n1.csv >>grocery.sql
echo select * from grocery; >>grocery.sql echo .quit >>grocery.sql
sqlite3 %1 mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Simon Slavin
Sent: Thursday, February 09, 2012 1:39 PM
To: General Discussion of SQLite Database
Subject: Re: [sqlite] Compiling SQLite3 to run on Windows Mobile 6.5


On 9 Feb 2012, at 6:28pm, Tim Leland wrote:

> That will work but we have to import the sqlite file into our
AS400/Iseries
> IBM (DB2)system. Easiest way is convert it to a .csv file for the import.
My
> last resort is just run a script on the PC side that will run sqlite3.exe
> shell and convert the sqlite file to a .csv but I want to avoid that step.
> If you know of a way for an as400 to import sqlite files that would be
> great!

Oh, you're that guy.  Okay, I'd forgotten your hosting side was on an AS400.

Simon.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users


___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users


___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Compiling SQLite3 to run on Windows Mobile 6.5

[Tim Leland]

Would this be able to run on windows mobile or windows ce?

-Original Message-
From: sqlite-users-boun...@sqlite.org
[mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Andrew Barnes
Sent: Friday, February 10, 2012 1:46 PM
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] Compiling SQLite3 to run on Windows Mobile 6.5


Hi,

Not sure if anyone has suggested this already but rather than messing with
the shell and bat files, cant you write a little program which reads the
database, outputs a CSV file and puts it wherever it needs putting

Andy
  
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users


___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Compiling SQLite3 to run on Windows Mobile 6.5

[Andrew Barnes]

Hi,

Not sure if anyone has suggested this already but rather than messing with the 
shell and bat files, cant you write a little program which reads the database, 
outputs a CSV file and puts it wherever it needs putting

Andy
  
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Compiling SQLite3 to run on Windows Mobile 6.5

[Random Coder]

On Thu, Feb 9, 2012 at 2:34 PM, Tim Leland  wrote:
> I can use CE if that's the problem. Can someone get sqlite3.exe shell to run
> on windows CE?

I'm sure someone can, but they'll need to know which architecture
you're running on, and possibly what CE components are in that
platform.

Depending on your build of CE, you might be able to just create a
project and bring in shell.c and sqlite3.c and compile it in Platform
Builder.

Unfortunately, I won't be able to help beyond that, I no longer have
access to Platform Builder or random CE devices anymore.  Perhaps
there's another CE expert on the list.  Failing that, you can try
asking for more specific help in one of the CE support forums at
http://social.msdn.microsoft.com/Forums/en-US/category/windowsembeddedcompact

Good luck.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Compiling SQLite3 to run on Windows Mobile 6.5

[Tim Leland]

I can use CE if that's the problem. Can someone get sqlite3.exe shell to run
on windows CE?

-Original Message-
From: sqlite-users-boun...@sqlite.org
[mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Random Coder
Sent: Thursday, February 09, 2012 2:51 PM
To: General Discussion of SQLite Database
Subject: Re: [sqlite] Compiling SQLite3 to run on Windows Mobile 6.5

On Thu, Feb 9, 2012 at 10:17 AM, Tim Leland <tlel...@wleeflowers.com> wrote:
> Ok now I understand. I need the shell for windows mobile. The reason why
im
> doing this is the application running on windows mobile is really just an
> html5 browser storing data in a sqlite database. I need to convert the
> sqlite database to a .csv file and send that file to a ftp server. Any
ideas
> on getting the shell to work on windows mobile?

Since Windows Mobile doesn't include the console aspects of CE, not
only will you need to get the SQLite shell to compile, you'll have to
create some sort of GUI shell around it to use it interactively.

Unless someone knows of a Windows Mobile SQLite explorer application
that's already out there, you're going to need to start coding.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users


___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Compiling SQLite3 to run on Windows Mobile 6.5

[Black, Michael (IS)]

Let's change them a touch...one too many @'s in loop.bat

loop.bat

@for %%i in (%1) do @call dump %%i

dump.bat

@echo .separator "," >grocery.sql
@echo .output %~n1.csv >>grocery.sql
@echo select * from grocery; >>grocery.sql
@echo .quit >>grocery.sql
@sqlite3 %1 grocery.sql
echo .output %~n1.csv >>grocery.sql
echo select * from grocery; >>grocery.sql echo .quit >>grocery.sql
sqlite3 %1 mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Simon Slavin
Sent: Thursday, February 09, 2012 1:39 PM
To: General Discussion of SQLite Database
Subject: Re: [sqlite] Compiling SQLite3 to run on Windows Mobile 6.5


On 9 Feb 2012, at 6:28pm, Tim Leland wrote:

> That will work but we have to import the sqlite file into our
AS400/Iseries
> IBM (DB2)system. Easiest way is convert it to a .csv file for the import.
My
> last resort is just run a script on the PC side that will run sqlite3.exe
> shell and convert the sqlite file to a .csv but I want to avoid that step.
> If you know of a way for an as400 to import sqlite files that would be
> great!

Oh, you're that guy.  Okay, I'd forgotten your hosting side was on an AS400.

Simon.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users


___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Compiling SQLite3 to run on Windows Mobile 6.5

[Random Coder]

On Thu, Feb 9, 2012 at 10:17 AM, Tim Leland  wrote:
> Ok now I understand. I need the shell for windows mobile. The reason why im
> doing this is the application running on windows mobile is really just an
> html5 browser storing data in a sqlite database. I need to convert the
> sqlite database to a .csv file and send that file to a ftp server. Any ideas
> on getting the shell to work on windows mobile?

Since Windows Mobile doesn't include the console aspects of CE, not
only will you need to get the SQLite shell to compile, you'll have to
create some sort of GUI shell around it to use it interactively.

Unless someone knows of a Windows Mobile SQLite explorer application
that's already out there, you're going to need to start coding.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Compiling SQLite3 to run on Windows Mobile 6.5

[Tim Leland]

Haha ya Im "that guy". Ive tried to create these .bat files and they don't
seem to do anything. Here they are:
Two batch files will do it.



loop.bat

@for %%i in (%1) do @call @dump %%i

dump.bat

echo .separator "," >grocery.sql
echo .output %~n1.csv >>grocery.sql
echo select * from grocery; >>grocery.sql echo .quit >>grocery.sql
sqlite3 %1 mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Simon Slavin
Sent: Thursday, February 09, 2012 1:39 PM
To: General Discussion of SQLite Database
Subject: Re: [sqlite] Compiling SQLite3 to run on Windows Mobile 6.5


On 9 Feb 2012, at 6:28pm, Tim Leland wrote:

> That will work but we have to import the sqlite file into our
AS400/Iseries
> IBM (DB2)system. Easiest way is convert it to a .csv file for the import.
My
> last resort is just run a script on the PC side that will run sqlite3.exe
> shell and convert the sqlite file to a .csv but I want to avoid that step.
> If you know of a way for an as400 to import sqlite files that would be
> great!

Oh, you're that guy.  Okay, I'd forgotten your hosting side was on an AS400.

Simon.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users


___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Compiling SQLite3 to run on Windows Mobile 6.5

[noel.frankinet]

Le 9/02/2012 19:07, Tim Leland a écrit :
you certainly don't need the shell, sqlite is just a (static) library.
Noël



What software would I need to compile?

-Original Message-
From: sqlite-users-boun...@sqlite.org
[mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Random Coder
Sent: Thursday, February 09, 2012 1:06 PM
To: General Discussion of SQLite Database
Subject: Re: [sqlite] Compiling SQLite3 to run on Windows Mobile 6.5

On Thu, Feb 9, 2012 at 9:57 AM, Tim Leland<tlel...@wleeflowers.com>  wrote:

Ok so what would be the process of compiling the c#? Ive never done

anything

like that before.

Unless you have a need for the C# library, you should skip it.  Just
bring in the C source file and header from the amalgamation from
http://www.sqlite.org/download.html into your project and use it.

I don't remember needing to do anything special to compile sqlite3.c
on Windows Mobile.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users


___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users



___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Compiling SQLite3 to run on Windows Mobile 6.5

[Simon Slavin]

On 9 Feb 2012, at 6:28pm, Tim Leland wrote:

> That will work but we have to import the sqlite file into our AS400/Iseries
> IBM (DB2)system. Easiest way is convert it to a .csv file for the import. My
> last resort is just run a script on the PC side that will run sqlite3.exe
> shell and convert the sqlite file to a .csv but I want to avoid that step.
> If you know of a way for an as400 to import sqlite files that would be
> great!

Oh, you're that guy.  Okay, I'd forgotten your hosting side was on an AS400.

Simon.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Compiling SQLite3 to run on Windows Mobile 6.5

[Tim Leland]

That will work but we have to import the sqlite file into our AS400/Iseries
IBM (DB2)system. Easiest way is convert it to a .csv file for the import. My
last resort is just run a script on the PC side that will run sqlite3.exe
shell and convert the sqlite file to a .csv but I want to avoid that step.
If you know of a way for an as400 to import sqlite files that would be
great!

-Original Message-
From: sqlite-users-boun...@sqlite.org
[mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Simon Slavin
Sent: Thursday, February 09, 2012 1:26 PM
To: General Discussion of SQLite Database
Subject: Re: [sqlite] Compiling SQLite3 to run on Windows Mobile 6.5


On 9 Feb 2012, at 6:17pm, Tim Leland wrote:

> Ok now I understand. I need the shell for windows mobile. The reason why
im
> doing this is the application running on windows mobile is really just an
> html5 browser storing data in a sqlite database. I need to convert the
> sqlite database to a .csv file and send that file to a ftp server.

Why not send the sqlite database to the ftp server ?  It's just a single
file on disk.

Simon.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users


___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Compiling SQLite3 to run on Windows Mobile 6.5

[Simon Slavin]

On 9 Feb 2012, at 6:17pm, Tim Leland wrote:

> Ok now I understand. I need the shell for windows mobile. The reason why im
> doing this is the application running on windows mobile is really just an
> html5 browser storing data in a sqlite database. I need to convert the
> sqlite database to a .csv file and send that file to a ftp server.

Why not send the sqlite database to the ftp server ?  It's just a single file 
on disk.

Simon.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Compiling SQLite3 to run on Windows Mobile 6.5

[Tim Leland]

Ok now I understand. I need the shell for windows mobile. The reason why im
doing this is the application running on windows mobile is really just an
html5 browser storing data in a sqlite database. I need to convert the
sqlite database to a .csv file and send that file to a ftp server. Any ideas
on getting the shell to work on windows mobile?

-Original Message-
From: sqlite-users-boun...@sqlite.org
[mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Random Coder
Sent: Thursday, February 09, 2012 1:17 PM
To: General Discussion of SQLite Database
Subject: Re: [sqlite] Compiling SQLite3 to run on Windows Mobile 6.5

On Thu, Feb 9, 2012 at 10:07 AM, Tim Leland <tlel...@wleeflowers.com> wrote:
> What software would I need to compile?

Persumably whatever software you're using to compile the rest of your
application.  Visual Studio is the common way to compile Windows
Mobile applications.

SQLite is a library meant to be used in another program.  While there
is a shell application available for some operating systems, that
shell isn't available for Windows Mobile (nor would it be useful to
most people if it was), so you'll need to integrate the library
directly into your own application.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users


___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Compiling SQLite3 to run on Windows Mobile 6.5

[Random Coder]

On Thu, Feb 9, 2012 at 10:07 AM, Tim Leland  wrote:
> What software would I need to compile?

Persumably whatever software you're using to compile the rest of your
application.  Visual Studio is the common way to compile Windows
Mobile applications.

SQLite is a library meant to be used in another program.  While there
is a shell application available for some operating systems, that
shell isn't available for Windows Mobile (nor would it be useful to
most people if it was), so you'll need to integrate the library
directly into your own application.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Compiling SQLite3 to run on Windows Mobile 6.5

[Tim Leland]

What software would I need to compile?

-Original Message-
From: sqlite-users-boun...@sqlite.org
[mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Random Coder
Sent: Thursday, February 09, 2012 1:06 PM
To: General Discussion of SQLite Database
Subject: Re: [sqlite] Compiling SQLite3 to run on Windows Mobile 6.5

On Thu, Feb 9, 2012 at 9:57 AM, Tim Leland <tlel...@wleeflowers.com> wrote:
> Ok so what would be the process of compiling the c#? Ive never done
anything
> like that before.

Unless you have a need for the C# library, you should skip it.  Just
bring in the C source file and header from the amalgamation from
http://www.sqlite.org/download.html into your project and use it.

I don't remember needing to do anything special to compile sqlite3.c
on Windows Mobile.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users


___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Compiling SQLite3 to run on Windows Mobile 6.5

[Random Coder]

On Thu, Feb 9, 2012 at 9:57 AM, Tim Leland  wrote:
> Ok so what would be the process of compiling the c#? Ive never done anything
> like that before.

Unless you have a need for the C# library, you should skip it.  Just
bring in the C source file and header from the amalgamation from
http://www.sqlite.org/download.html into your project and use it.

I don't remember needing to do anything special to compile sqlite3.c
on Windows Mobile.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Compiling SQLite3 to run on Windows Mobile 6.5

[Tim Leland]

Ok so what would be the process of compiling the c#? Ive never done anything
like that before.

-Original Message-
From: sqlite-users-boun...@sqlite.org
[mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Jim Morris
Sent: Thursday, February 09, 2012 12:44 PM
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] Compiling SQLite3 to run on Windows Mobile 6.5

Sorry, no.  SQLite is embedded in our application and requires 
authentication and sync to server before you can get off the login page.


On 2/9/2012 9:33 AM, Tim Leland wrote:
> Is the sqlite part separate or emended in the application? Is it possible
to
> just send me the .exe and test it on the scan gun?
>
> -Original Message-
> From: sqlite-users-boun...@sqlite.org
> [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Jim Morris
> Sent: Thursday, February 09, 2012 12:22 PM
> To: sqlite-users@sqlite.org
> Subject: Re: [sqlite] Compiling SQLite3 to run on Windows Mobile 6.5
>
> It will definitely run.  Pelles is new to me.  Our application uses
> SQLite 3.5.9 on WinCE 4.2 through 6.5 using C++.  I don't recall that we
> had to change any source, but we did modify the shell for better input
> handling, but there were probably some compiler flags we needed to set.
> Been years since I had to touch it.
>
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
>
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users


___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Compiling SQLite3 to run on Windows Mobile 6.5

[Jim Morris]

Sorry, no.  SQLite is embedded in our application and requires 
authentication and sync to server before you can get off the login page.



On 2/9/2012 9:33 AM, Tim Leland wrote:

Is the sqlite part separate or emended in the application? Is it possible to
just send me the .exe and test it on the scan gun?

-Original Message-
From: sqlite-users-boun...@sqlite.org
[mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Jim Morris
Sent: Thursday, February 09, 2012 12:22 PM
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] Compiling SQLite3 to run on Windows Mobile 6.5

It will definitely run.  Pelles is new to me.  Our application uses
SQLite 3.5.9 on WinCE 4.2 through 6.5 using C++.  I don't recall that we
had to change any source, but we did modify the shell for better input
handling, but there were probably some compiler flags we needed to set.
Been years since I had to touch it.

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users


___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users


___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Compiling SQLite3 to run on Windows Mobile 6.5

[Tim Leland]

Is the sqlite part separate or emended in the application? Is it possible to
just send me the .exe and test it on the scan gun?

-Original Message-
From: sqlite-users-boun...@sqlite.org
[mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Jim Morris
Sent: Thursday, February 09, 2012 12:22 PM
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] Compiling SQLite3 to run on Windows Mobile 6.5

It will definitely run.  Pelles is new to me.  Our application uses 
SQLite 3.5.9 on WinCE 4.2 through 6.5 using C++.  I don't recall that we 
had to change any source, but we did modify the shell for better input 
handling, but there were probably some compiler flags we needed to set.  
Been years since I had to touch it.

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users


___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Compiling SQLite3 to run on Windows Mobile 6.5

[Jim Morris]

Don't know about those devices but we use the MC55A and related device 
without issue with C++ and I'm pretty sure they support C#.


http://www.motorola.com/Business/US-EN/Business+Product+and+Services/Mobile+Computers/Handheld+Computers/MC55A0

On 2/9/2012 9:24 AM, Richard Hipp wrote:

On Thu, Feb 9, 2012 at 12:21 PM, Noah Hart  wrote:


The C#-SQLite port at http://code.google.com/p/csharp-sqlite/ supports
both
Silverlight and Windows Phone


Tim tells me that he needs it to run on a handheld barcode scanner (
http://www.motorola.com/Business/US-EN/Business+Product+and+Services/Bar+Code+Scanning).
Do they run C#?  I dunno - I'm asking?





Hope that help,

Noah Hart


Tim Leland wrote:

Does anyone have any tips/suggestions for getting sqlite3 to run on
windows
mobile 6.5?



Thanks



Tim Leland

W. Lee Flowers&  Co.

127 E. W Lee Flowers Rd.

Scranton, S.C. 29591

(843)389-2731



___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users



--
View this message in context:
http://old.nabble.com/Compiling-SQLite3-to-run-on-Windows-Mobile-6.5-tp33294689p33294909.html
Sent from the SQLite mailing list archive at Nabble.com.

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users





___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Compiling SQLite3 to run on Windows Mobile 6.5

[Richard Hipp]

On Thu, Feb 9, 2012 at 12:21 PM, Noah Hart  wrote:

>
> The C#-SQLite port at http://code.google.com/p/csharp-sqlite/ supports
> both
> Silverlight and Windows Phone
>

Tim tells me that he needs it to run on a handheld barcode scanner (
http://www.motorola.com/Business/US-EN/Business+Product+and+Services/Bar+Code+Scanning).
Do they run C#?  I dunno - I'm asking?



>
>
> Hope that help,
>
> Noah Hart
>
>
> Tim Leland wrote:
> >
> > Does anyone have any tips/suggestions for getting sqlite3 to run on
> > windows
> > mobile 6.5?
> >
> >
> >
> > Thanks
> >
> >
> >
> > Tim Leland
> >
> > W. Lee Flowers & Co.
> >
> > 127 E. W Lee Flowers Rd.
> >
> > Scranton, S.C. 29591
> >
> > (843)389-2731
> >
> >
> >
> > ___
> > sqlite-users mailing list
> > sqlite-users@sqlite.org
> > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
> >
> >
>
> --
> View this message in context:
> http://old.nabble.com/Compiling-SQLite3-to-run-on-Windows-Mobile-6.5-tp33294689p33294909.html
> Sent from the SQLite mailing list archive at Nabble.com.
>
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>



-- 
D. Richard Hipp
d...@sqlite.org
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Compiling SQLite3 to run on Windows Mobile 6.5

[Jim Morris]

It will definitely run.  Pelles is new to me.  Our application uses 
SQLite 3.5.9 on WinCE 4.2 through 6.5 using C++.  I don't recall that we 
had to change any source, but we did modify the shell for better input 
handling, but there were probably some compiler flags we needed to set.  
Been years since I had to touch it.


___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Compiling SQLite3 to run on Windows Mobile 6.5

[Noah Hart]

The C#-SQLite port at http://code.google.com/p/csharp-sqlite/ supports both
Silverlight and Windows Phone


Hope that help,

Noah Hart


Tim Leland wrote:
> 
> Does anyone have any tips/suggestions for getting sqlite3 to run on
> windows
> mobile 6.5? 
> 
>  
> 
> Thanks
> 
>  
> 
> Tim Leland
> 
> W. Lee Flowers & Co.
> 
> 127 E. W Lee Flowers Rd.
> 
> Scranton, S.C. 29591
> 
> (843)389-2731
> 
>  
> 
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
> 
> 

-- 
View this message in context: 
http://old.nabble.com/Compiling-SQLite3-to-run-on-Windows-Mobile-6.5-tp33294689p33294909.html
Sent from the SQLite mailing list archive at Nabble.com.

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Compiling SQLite3 to run on Windows Mobile 6.5

[Tim Leland]

Found this site. Anyone have any experience using this? 
http://www.smorgasbordet.com/pellesc/

-Original Message-
From: sqlite-users-boun...@sqlite.org
[mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Tim Leland
Sent: Thursday, February 09, 2012 11:48 AM
To: 'General Discussion of SQLite Database'
Subject: [sqlite] Compiling SQLite3 to run on Windows Mobile 6.5

Does anyone have any tips/suggestions for getting sqlite3 to run on windows
mobile 6.5? 

 

Thanks

 

Tim Leland

W. Lee Flowers & Co.

127 E. W Lee Flowers Rd.

Scranton, S.C. 29591

(843)389-2731

 

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users


___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users