I am building a Filemaker application using v9.03 for Windows.  The
purpose of the application is to be a GUI data input/entry system that
will export data for use in SQL later.  So the data is stored in FMP
first, then exported to SQL or MySql later.

One of the fields is a container that holds a picture.  How will
Filemaker export that data for use in MySQL or SQL ?

-S

<squeed2000@yahoo.com> wrote in message
news:0655846f-7a13-47e6-ab6c-43a9d33ef03f@r32g2000vba.googlegroups.com...
> I am building a Filemaker application using v9.03 for Windows.  The
> purpose of the application is to be a GUI data input/entry system that
> will export data for use in SQL later.  So the data is stored in FMP
> first, then exported to SQL or MySql later.
>
> One of the fields is a container that holds a picture.  How will
> Filemaker export that data for use in MySQL or SQL ?

FileMaker doesn't export image data (or sound or movies).

You would need to store the file path of the image, BUT you may need a
Calculation Field to change that file path to be the correct one for whevere
the SQL database is being hosted.

Helpful Harry

On Dec 29, 3:06=A0pm, "Your Name" <your.n...@isp.com> wrote:
> <squeed2...@yahoo.com> wrote in message
>
> news:0655846f-7a13-47e6-ab6c-43a9d33ef03f@r32g2000vba.googlegroups.com...
>
> > I am building a Filemaker application using v9.03 for Windows. =A0The
> > purpose of the application is to be a GUI data input/entry system that
> > will export data for use in SQL later. =A0So the data is stored in FMP
> > first, then exported to SQL or MySql later.
>
> > One of the fields is a container that holds a picture. =A0How will
> > Filemaker export that data for use in MySQL or SQL ?
>
> FileMaker doesn't export image data (or sound or movies).
>
> You would need to store the file path of the image, BUT you may need a
> Calculation Field to change that file path to be the correct one for whev=
ere
> the SQL database is being hosted.
>
> Helpful Harry

That's what I thought.  Thanks.