I published a parameter which is of Choice Multiple type. I wish to use values from this parameter for WHERE Clause when Reading Inputed Data in the begin of Workbench.
So there is no problem if I have type of published parameter just Choice, then I use following:
WHERE Clause Tile = '$(Name)'
but I do not know how to write SQL WHERE Clause statement if I have Multiple Choice and want to read all data for Name of Tiles selected in Multiple Choice, because SQL form above does not work ...
Example:
In multiple choice i select the names: Anna, John, Tim. Then, I want that data for tiles that have those names are read.
Answer
FME 2012 Beta (nightly build) has introduced:
===========================================================================
=========================== BUILD 12130 20110818 ===========================
===========================================================================
SQLExecutor and SQLCreator: Implemented support for multiple SQL
statements through the FME_SQL_DELIMITER. Implemented ability to ignore
SQL errors by prefixing statements with a
hyphen (C40056 C40314 C42660 PR#29343)
ftp://ftp.safe.com/fme/beta/whatsnew.txt
Beta Builds available ftp://ftp.safe.com/fme/beta/
(Not tested it yet but will be doing so in the near future)
No comments:
Post a Comment