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

2012-02-13 Thread Tim Leland
...@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 du

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

2012-02-11 Thread Black, Michael (IS)
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 .separa

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

2012-02-10 Thread Tim Leland
: 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; >&g

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

2012-02-10 Thread Tim Leland
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

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

2012-02-10 Thread 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

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

2012-02-09 Thread 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

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

2012-02-09 Thread Tim Leland
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 wi

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

2012-02-09 Thread Black, Michael (IS)
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 Databa

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

2012-02-09 Thread 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

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

2012-02-09 Thread Tim Leland
ql 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 M

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

2012-02-09 Thread noel.frankinet
: 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 neve

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

2012-02-09 Thread 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

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

2012-02-09 Thread Tim Leland
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 sto

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

2012-02-09 Thread 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

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

2012-02-09 Thread Tim Leland
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 Windo

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

2012-02-09 Thread 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

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

2012-02-09 Thread 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

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

2012-02-09 Thread 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

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

2012-02-09 Thread Tim Leland
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 emen

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

2012-02-09 Thread Jim Morris
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

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

2012-02-09 Thread Tim Leland
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

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

2012-02-09 Thread 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,

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

2012-02-09 Thread 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 (

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

2012-02-09 Thread 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

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

2012-02-09 Thread 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 >

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

2012-02-09 Thread 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