A description of this feature on the Filemaker website indicates that
the Filemaker 9 creates one-way or two-way connections to External SQL
Data Source. Does it also mean or imply that Filemaker 9 could be used
as a program to enter data into a MySQL database?
Would appreciate any comments from anyone having an experience with
this feature.
Thanks
On Nov 26, 10:41 am, "sovageo...@gmail.com"
wrote:
> A description of this feature on the Filemaker website indicates that
> the Filemaker 9 creates one-way or two-way connections to External SQL
> Data Source. Does it also mean or imply that Filemaker 9 could be used
> as a program to enter data into a MySQL database?
>
> Would appreciate any comments from anyone having an experience with
> this feature.
>
> Thanks
Yes, It certainly does. It also means the values entered into a
Filemaker interface to a MySQL (or any SQL datasource backend for that
matter; i.e. SQL server, DB2, etc) are subjected to any field
constraints implemented in MySQL (as one would hope and expect them to
be). You would have to write some custom dialogs with 'error capture
on' to return any meaningful error messages in FileMaker on the
attempted submission of invalid data to the datstrore (in the case you
mention, MySQL).
By extension this means that you can now readily have a RAD
development tool like FileMaker for desktop apps and still have the
flexibility of using the same datastore in a variety of other web and/
or enterprise apps. I have set up interfaces of FM to SQL server where
the same SQL server database that is accessed via the FileMaker front
end can be accessed via WinForms as well as C# websites.
best,
sg