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/
