WinCE - Lazarus 0.28.3 - fpc 2.2.4

I know that I have to use unicode formatting to use eDB on WinCE.
After I have created database on device I need to import/export dataa.
I try with a simple SDF component, to manage CSV data file.

Problem is: fpc LESS THEN 2.4.0 seem have some problem to use  Unicode
(without BOM) CSV file.

Bug was resolved into 2.4.0, but this version have problem to produce
a working executable with EDB for WinCE (I don't know if is EDB or
WinCE the problem)

So how I can import/export data to/from WinCE eDB?
If I use import/export into stores defined in eDB, HOWTO:
1. mov it from WinCE to Win32
2. read it and put into another Win32 database?



Fabio Codebue
Gestionale Open srl

Fabio,

<< So how I can import/export data to/from WinCE eDB? >>

Use the native functionality for doing so in EDB.

<< If I use import/export into stores defined in eDB, HOWTO:
1. mov it from WinCE to Win32 >>

The only difference is in how the stores are defined using CREATE STORE.
You would simply define them without a drive letter when doing so on a WinCE
device (\MyApp\MyStore)

<< 2. read it and put into another Win32 database? >>

Read what ?  The .csv file that is exported from EDB ?  You can use local
and remote stores for copying the .csv files from the WinCE device to an EDB
Server, provided that you have network connectivity on the WinCE device.
Once the files are copied over to the EDB Server, you can simply use the
IMPORT TABLE statement to import them into the EDB Server database.

--
Tim Young
Elevate Software
www.elevatesoft.com

On Fri, 15 Jan 2010 14:52:48 -0500, "Tim Young [Elevate Software]"
<timyoung@elevatesoft.com> wrote:

>Fabio,
>
><< So how I can import/export data to/from WinCE eDB? >>
>
>Use the native functionality for doing so in EDB.
>
><< If I use import/export into stores defined in eDB, HOWTO:
> 1. mov it from WinCE to Win32 >>
>
>The only difference is in how the stores are defined using CREATE STORE.
>You would simply define them without a drive letter when doing so on a WinCE
>device (\MyApp\MyStore)
>
><< 2. read it and put into another Win32 database? >>
>
>Read what ?  The .csv file that is exported from EDB ?  You can use local
>and remote stores for copying the .csv files from the WinCE device to an EDB
>Server, provided that you have network connectivity on the WinCE device.
>Once the files are copied over to the EDB Server, you can simply use the
>IMPORT TABLE statement to import them into the EDB Server database.

Using local and remote stores imply having two eDB? One on WinCE and
one on Windows32?

What I wanna understand is the procedure to transfer to from an eDB on
winCE to a mySQL database on Win32.

1. create a local store into WinCE

CREATE STORE "miatabella" AS
LOCAL PATH '\miaapp\miatabella'

2. export data to local store
EXPORT TABLE "art"
TO '\miaapp\miatabella'
IN STORE "miatabella"

3 . copy file to win32
copy \miaapp\miatabella to my hard disk on win32

4. how to read this miatabella file?

Fabio Codebue
Gestionale Open srl

Fabio Codebue +AEA- GestionaleOpen wrote:

+AD4-
+AD4- What I wanna understand is the procedure to transfer to from an
eDB
+AD4- on winCE to a mySQL database on Win32.
+AD4-
+AD4- 1. create a local store into WinCE
+AD4-
+AD4- CREATE STORE +ACI-miatabella+ACI- AS
+AD4- LOCAL PATH '+AFw-miaapp+AFw-miatabella'
+AD4-
+AD4- 2. export data to local store
+AD4- EXPORT TABLE +ACI-art+ACI-
+AD4- TO '+AFw-miaapp+AFw-miatabella'
+AD4- IN STORE +ACI-miatabella+ACI-
+AD4-
+AD4- 3 . copy file to win32
+AD4- copy +AFw-miaapp+AFw-miatabella to my hard disk on win32
+AD4-
+AD4- 4. how to read this miatabella file?
+AD4-
+AD4- Fabio Codebue
+AD4- Gestionale Open srl

Fabio

Something like this:

1.  as above

2.
 EXPORT TABLE +ACI-art+ACI-
 TO +ACI-Data.txt+ACI-
 IN STORE +ACI-miatabella+ACIAOw-

3.  as above

4.
 Well you can 'read' it with any text editor, but to load it into
MySQL do something like:
 LOAD DATA LOCAL INFILE '+ADw-path+AD4-Data.txt' INTO TABLE
'art'+ADs-

Malcolm

Malcolm


What's with the +AD4- to indicate previous post contents?

Roy Lambert

Roy Lambert wrote:

+AD4- Malcolm
+AD4-
+AD4-
+AD4- What's with the +AD4- to indicate previous post contents?
+AD4-
+AD4- Roy Lambert

Dunno+ACE-  It's what XanaNews does for me.  Is it a problem?

--

Malcolm


>Dunno+ACE- It's what XanaNews does for me. Is it a problem?

Nah. Just being nosey

Roy Lambert