SQL (structured query language) isn't standard in FileMaker Pro's vocabulary and unless the FMP developer uses it otherwise, I can see the "difficult". :)
-- Beverly Voth Tier3 Data & Web Services Group, LLC 606-864-0041 http://www.tier3web.com/xml.htm Web Design & Hosting * Apple: CAN, ACN & ADC Certified FileMaker 7 & 9 Developer * FileMaker Business Alliance Coldfusion, Witango, PHP, MS SQL, MySQL, FMP, XML/XSLT, CSS Over 14 years experience integrating databases and the internet! On 12/15/08 4:19 PM, "Corn Walker" <[email protected]> wrote in whole or in part: > On Dec 15, 2008, at 4:08 PM, Beverly Voth wrote: > >> Rowland, Steve is referring to using ODBC (with IMPORT[] or Execute >> SQL[] >> script steps). The "ESS" method (which may be what you are using) >> *is* a >> direct connection to the live SQL source. These are two different >> things and >> I thought Steve explained that. > > And, as Steve pointed out, using ExecuteSQL you can indeed modify the > source data. I'm not certain why he considers it "difficult to > implement" since it's the same SQL syntax one would use to query the > data - unless he is implying the effort required to keep the FMP Data > and Oracle/SQL Server data in sync. In that case, ESS is the only > reasonable solution to this problem. > > Cheers, > -corn > > > Corn Walker > The Proof Group > http://proofgroup.com/
