SmartGWT:
SNAPSHOT_v8.3d_2012-06-01/PowerEdition Deployment (built 2012-06-01)
Firefox 9.0
I have a data source that uses a value map like as defined in the attachment
BCG_STA_Setup.ds.xml.txt.
When it creates the SQL fetch query it is as in the attachment:
Incorrect Select Generated.txt
I have corrected the Select to add the CASE statement keyword back in as shown in the attachment:
Corrected Select Generated.txt
The corrected select works fine, just by adding the CASE keyword.
This seems like a bug.
If I change the Value map of the ENUM in the Datasource to where there is no ID defined for each entry the select is correctly generated but of course is missing the CASE statement.
I need to us this form of ValueMap definition in the DS otherwise simple code like the following crashes with an exception on the line where valueMap is evaluated.
DataSourceField[] dsFields = srcDS.getFields();
Map valueMap = null;
for (i = 0; i < dsFields.length; i++) {
String fieldName = dsFields[i].getName();
if (fieldName.contains("WaiveState")) {
valueMap = dsFields[i].getValueMap();
}
}
Please comment
SNAPSHOT_v8.3d_2012-06-01/PowerEdition Deployment (built 2012-06-01)
Firefox 9.0
I have a data source that uses a value map like as defined in the attachment
BCG_STA_Setup.ds.xml.txt.
When it creates the SQL fetch query it is as in the attachment:
Incorrect Select Generated.txt
I have corrected the Select to add the CASE statement keyword back in as shown in the attachment:
Corrected Select Generated.txt
The corrected select works fine, just by adding the CASE keyword.
This seems like a bug.
If I change the Value map of the ENUM in the Datasource to where there is no ID defined for each entry the select is correctly generated but of course is missing the CASE statement.
I need to us this form of ValueMap definition in the DS otherwise simple code like the following crashes with an exception on the line where valueMap is evaluated.
DataSourceField[] dsFields = srcDS.getFields();
Map valueMap = null;
for (i = 0; i < dsFields.length; i++) {
String fieldName = dsFields[i].getName();
if (fieldName.contains("WaiveState")) {
valueMap = dsFields[i].getValueMap();
}
}
Please comment
Comment