Re: Re: Two-way MySQL <--> FM9 connection Options, part II

On Tue, 26 Aug 2008 07:00:24 -0700 (PDT), Diego B <messadua@xxxxxxxx>
wrote:

[snip]

I will go for ODBC/SQL statements then,
although the "cleaning up" process of the improted records
from MySQL is not totally clear yet.
I would really appreciate some templates or links to a practical
scenario, but maybe I am asking too much now.

"Asking too much" ... lol ... I personally am descended from a long
and distinguished line of luck-pushers, and my partner's ancestors in
the New World were selected by some of the finest judges in England
.... but I digress ...

I think what Lynn means by "cleaning up" the data is taking the data
you get from SQL and making them compatible with your FMP solution.
The way I do this is: I import the SQL data into a table set up to
receive them. Then for each field that needs "cleaning up" I create a
calc field that performs whatever operations needed to do that. To
borrow Lynn's example, a typical date in SQL might be in the format
yyyy-mm-dd, but your FMP solution (and your users) might want their
dates in the format dd/mm/yyyy. So you would pull the yyyy-mm-dd date
from SQL into one (non-calc) field, then run a function on it in a
second (calc) field to reformat it to dd/mm/yyyy. That's an example
of the basic concept of "cleaning up" SQL data for FMP, if I
understand it aright.

hope this helps

--
FW
RL's Axiom #14: "The result of doing nothing is, invariably, nothing."

FileMaker Pro 8.5 Advanced on Windows XP Pro SP2
FileMaker Server 8.0 on Windows 2003 Server R2
.

Relevant Pages

  • Re: Two-way MySQL <--> FM9 connection Options, part II
    ... you get from SQL and making them compatible with your FMP solution. ... calc field that performs whatever operations needed to do that. ... of the basic concept of "cleaning up" SQL data for FMP, ...
    (comp.databases.filemaker)
  • SQL View Format
    ... In my SQL View I wanted to change the format so that each item that the query grabs is on its own line, basically just cleaning up the look of the SQL View and making it easier to read. ...
    (microsoft.public.access.queries)
  • Re: Computer Needs Restart - SQL Express 2008 Install
    ... cleaning up? ... Links for SQL Server Books Online: ... operation and a reboot didn't fix the SQL problem either. ...
    (microsoft.public.sqlserver.setup)
  • RE: Moving SQL 2005 cluster nodes to new OU
    ... "UnderCoverGuy" wrote: ... I am cleaning up AD and need to move the SQL cluster to a new OU. ...
    (microsoft.public.sqlserver.clustering)