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

X-Trace
User-Agent: Unison/1.7.9
NNTP-Posting-Host: pool-71-189-225-222.lsanca.fios.verizon.net
X-Trace: news.bnb-lp.com 1219775204 pool-71-189-225-222.lsanca.fios.verizon.net (26 Aug 2008 14:26:44 -0400)
Lines: 23
X-Authenticated-User: vca037
X-DMCA-Complaints: Send abuse or DMCA complaints to abuse@xxxxxxxxxx
X-DMCA-Complaints: The subject line should contain only the 4 letters DMCA
X-Original-Bytes: 2115
Path: mail.derkeiler.com!t4!artnm!172.24.8.10.MISMATCH!t1!feeder.news-service.com!news.astraweb.com!newsrouter-eu.astraweb.com!proxad.net!feeder1-1.proxad.net!198.186.194.247.MISMATCH!transit3.readnews.com!news-out.readnews.com!news-xxxfer.readnews.com!207.99.111.53.MISMATCH!newspeer1.nac.net!border2.nntp.dca.giganews.com!border1.nntp.dca.giganews.com!nntp.giganews.com!news.bnb-lp.com!not-for-mail
Xref: mail.derkeiler.com comp.databases.filemaker:118306

On 2008-08-26 11:10:56 -0700, FastWolf <wolfsofast@xxxxxxxxxxxxxxxxx> said:

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.

Exactly. :)
--
Lynn Allen
--
www.semiotics.com
Member Filemaker Business Alliance
Long Beach, CA

.

Relevant Pages

  • Re: Re: Two-way MySQL <--> FM9 connection Options, part II
    ... 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 ...
    (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)