span8
span4
span8
span4
As I am using a union query I need to convert text fields to nvarchr (Max)
The statement works well in Studio manager but in FME the attributes are
Without union clause the text fields display as expected using AttributeExposer so i feel certain it is the cast as Nvarchar(max) that is causing the problem.
How do I resolve this ?
Unless you've already done so, you will have to specify the name the resulting column, e.g.
select cast(fieldname as nvarchar2(max)) as fieldname from...
Otherwise the output column will actually be called "CAST(FIELDNAME AS NVARCHAR2(MAX))"
This is standard Oracle behavior, by the way.
Sorry for the delayed response , but yes thank you that was the answer it needed to know the fieldname
SQLExecutor, Geometry and Oracle Database5 Answers
Spatial query with SQLExecutor4 Answers
How to put string literal in sql statement3 Answers
Workspace Process with Date Variable and Subsequent Processing4 Answers
Table Where clause in PostGIS.How do I sort out all objects that are within an polygon?2 Answers
© 2020 Safe Software Inc |Legal