Hi,
Is there a way to pass a variable defined in the FME_BEGIN_TCL into
the mapping ?
I am curently having problem with that. I have define a
FME_BEGIN_TCL which call a tcl script which calculate a date and
format a string as an Oracle where clause.
I need to provide this string to the mapping to set
the WhereClause of the Source Dataset.
Here is what i have put in the header of the Mapping
....
#
=====================================================================
# The following lines instructs the FME to perfom some pre- and post-
processing
# before and after the translation
FME_BEGIN_TCL source {$(FME_MF_DIR)\Begin_Tcl_
Load_CFMU_Flights.tcl}; set LobtFilter [BeginLoadFlights]
FME_END_TCL source {$(FME_MF_DIR)\End_Tcl_ Load_CFMU_Flights.tcl};
EndLoadFlights $LobtFilter
...
...
# And the Where Clause
#DEFAULT_MACRO DBIN_WhereClause_ORACLE8_DB_1
$(DBIN_WhereClause_ORACLE8_DB_ORACLE8_DB_1)
DEFAULT_MACRO DBIN_WhereClause_ORACLE8_DB_1 $LobtFilter
GUI TEXT DBIN_WhereClause_ORACLE8_DB_1 Where Clause:
ORACLE8_DB_1_WHERE_CLAUSE "$(DBIN_WhereClause_ORACLE8_DB_1)"
....
The result is that the WhereClause is set to "$LobtFilter" instead
of the value of the LobtFilter.
Any ideas ?
Thanks, André
