fluid-api/src/main/java/com/fluidbpm/program/api/util/sql/syntax/SyntaxFactory.java
public ISyntax getFieldValueSyntaxFor(
			ABaseSQLUtil.SQLServerType sqlTypeParam,
			SQLFormFieldUtil.FormFieldMapping formFieldMappingParam
	) {
		Long dataType = formFieldMappingParam.dataType;
		if(dataType == null) {
			return null;
		}

		switch (dataType.intValue()) {
			case UtilGlobal.FieldTypeId._1_TEXT:
				return this.getSyntaxFor(
						sqlTypeParam, ISyntax.ProcedureMapping.Field.GetFormFieldValue_1_Text);
			case UtilGlobal.FieldTypeId._2_TRUE_FALSE:
				return this.getSyntaxFor(
						sqlTypeParam, ISyntax.ProcedureMapping.Field.GetFormFieldValue_2_TrueFalse);
			case UtilGlobal.FieldTypeId._3_PARAGRAPH_TEXT:
				return this.getSyntaxFor(
						sqlTypeParam, ISyntax.ProcedureMapping.Field.GetFormFieldValue_3_ParagraphText);
			case UtilGlobal.FieldTypeId._4_MULTI_CHOICE:
				if(this.isPlain(formFieldMappingParam.metaData))
				{
					return this.getSyntaxFor(
							sqlTypeParam, ISyntax.ProcedureMapping.Field.GetFormFieldValue_4_MultiChoice);
				}
				else if(this.isSelectMany(formFieldMappingParam.metaData))
				{
					return this.getSyntaxFor(
							sqlTypeParam, ISyntax.ProcedureMapping.Field.GetFormFieldMultipleValue_4_MultiChoice);
				}
				else
				{
					throw new FluidSQLException(
							new SQLException("Data Type '"+
									dataType
									+"' does not support '"+
									formFieldMappingParam.metaData+"'."));
				}

			case UtilGlobal.FieldTypeId._5_DATE_TIME:
				return this.getSyntaxFor(
						sqlTypeParam, ISyntax.ProcedureMapping.Field.GetFormFieldValue_5_DateTime);
			case UtilGlobal.FieldTypeId._6_DECIMAL:
				return this.getSyntaxFor(
						sqlTypeParam, ISyntax.ProcedureMapping.Field.GetFormFieldValue_6_Decimal);
			case UtilGlobal.FieldTypeId._7_TABLE_FIELD:
				return this.getSyntaxFor(
						sqlTypeParam, ISyntax.ProcedureMapping.Field.GetFormFieldValue_7_TableField);
			case UtilGlobal.FieldTypeId._8_TEXT_ENCRYPTED:
			case UtilGlobal.FieldTypeId._9_LABEL:
				return null;
			default:
				throw new FluidSQLException(
						new SQLException("Data Type '"+
								dataType
								+"' is not supported."));

		}
	}
public ISyntax getFieldValueSyntaxFor(
			ABaseSQLUtil.SQLServerType sqlTypeParam,
			SQLFormFieldUtil.FormFieldMapping formFieldMappingParam
	) {
		Long dataType = formFieldMappingParam.dataType;
		if(dataType == null) {
			return null;
		}

		switch (dataType.intValue()) {
			case UtilGlobal.FieldTypeId._1_TEXT:
				return this.getSyntaxFor(
						sqlTypeParam, ISyntax.ProcedureMapping.Field.GetFormFieldValue_1_Text);
			case UtilGlobal.FieldTypeId._2_TRUE_FALSE:
				return this.getSyntaxFor(
						sqlTypeParam, ISyntax.ProcedureMapping.Field.GetFormFieldValue_2_TrueFalse);
			case UtilGlobal.FieldTypeId._3_PARAGRAPH_TEXT:
				return this.getSyntaxFor(
						sqlTypeParam, ISyntax.ProcedureMapping.Field.GetFormFieldValue_3_ParagraphText);
			case UtilGlobal.FieldTypeId._4_MULTI_CHOICE:
				if(this.isPlain(formFieldMappingParam.metaData))
				{
					return this.getSyntaxFor(
							sqlTypeParam, ISyntax.ProcedureMapping.Field.GetFormFieldValue_4_MultiChoice);
				}
				else if(this.isSelectMany(formFieldMappingParam.metaData))
				{
					return this.getSyntaxFor(
							sqlTypeParam, ISyntax.ProcedureMapping.Field.GetFormFieldMultipleValue_4_MultiChoice);
				}
				else
				{
					throw new FluidSQLException(
							new SQLException("Data Type '"+
									dataType
									+"' does not support '"+
									formFieldMappingParam.metaData+"'."));
				}

			case UtilGlobal.FieldTypeId._5_DATE_TIME:
				return this.getSyntaxFor(
						sqlTypeParam, ISyntax.ProcedureMapping.Field.GetFormFieldValue_5_DateTime);
			case UtilGlobal.FieldTypeId._6_DECIMAL:
				return this.getSyntaxFor(
						sqlTypeParam, ISyntax.ProcedureMapping.Field.GetFormFieldValue_6_Decimal);
			case UtilGlobal.FieldTypeId._7_TABLE_FIELD:
				return this.getSyntaxFor(
						sqlTypeParam, ISyntax.ProcedureMapping.Field.GetFormFieldValue_7_TableField);
			case UtilGlobal.FieldTypeId._8_TEXT_ENCRYPTED:
			case UtilGlobal.FieldTypeId._9_LABEL:
				return null;
			default:
				throw new FluidSQLException(
						new SQLException("Data Type '"+
								dataType
								+"' is not supported."));

		}
	}
public ISyntax getFieldValueSyntaxFor ( ABaseSQLUtil . SQLServerType sqlTypeParam , SQLFormFieldUtil . FormFieldMapping formFieldMappingParam ) { Long dataType = formFieldMappingParam . dataType ; if ( dataType == null ) { return null ; } switch ( dataType . intValue ( ) ) { case UtilGlobal . FieldTypeId . _1_TEXT : return this . getSyntaxFor ( sqlTypeParam , ISyntax . ProcedureMapping . Field . GetFormFieldValue_1_Text ) ; case UtilGlobal . FieldTypeId . _2_TRUE_FALSE : return this . getSyntaxFor ( sqlTypeParam , ISyntax . ProcedureMapping . Field . GetFormFieldValue_2_TrueFalse ) ; case UtilGlobal . FieldTypeId . _3_PARAGRAPH_TEXT : return this . getSyntaxFor ( sqlTypeParam , ISyntax . ProcedureMapping . Field . GetFormFieldValue_3_ParagraphText ) ; case UtilGlobal . FieldTypeId . _4_MULTI_CHOICE : if ( this . isPlain ( formFieldMappingParam . metaData ) ) { return this . getSyntaxFor ( sqlTypeParam , ISyntax . ProcedureMapping . Field . GetFormFieldValue_4_MultiChoice ) ; } else if ( this . isSelectMany ( formFieldMappingParam . metaData ) ) { return this . getSyntaxFor ( sqlTypeParam , ISyntax . ProcedureMapping . Field . GetFormFieldMultipleValue_4_MultiChoice ) ; } else { throw new FluidSQLException ( new SQLException ( "Data Type '" + dataType + "' does not support '" + formFieldMappingParam . metaData + "'." ) ) ; } case UtilGlobal . FieldTypeId . _5_DATE_TIME : return this . getSyntaxFor ( sqlTypeParam , ISyntax . ProcedureMapping . Field . GetFormFieldValue_5_DateTime ) ; case UtilGlobal . FieldTypeId . _6_DECIMAL : return this . getSyntaxFor ( sqlTypeParam , ISyntax . ProcedureMapping . Field . GetFormFieldValue_6_Decimal ) ; case UtilGlobal . FieldTypeId . _7_TABLE_FIELD : return this . getSyntaxFor ( sqlTypeParam , ISyntax . ProcedureMapping . Field . GetFormFieldValue_7_TableField ) ; case UtilGlobal . FieldTypeId . _8_TEXT_ENCRYPTED : case UtilGlobal . FieldTypeId . _9_LABEL : return null ; default : throw new FluidSQLException ( new SQLException ( "Data Type '" + dataType + "' is not supported." ) ) ; } }
Returns the {@code ISyntax} from the {@code sqlTypeParam} and {@code formFieldMappingParam}.

@param sqlTypeParam The type of SQL DB engine.
@param formFieldMappingParam The Form Field mapping.
@return implementation of {@code ISyntax}.

@see ISyntax
@see com.fluidbpm.program.api.util.sql.impl.SQLFormFieldUtil.FormFieldMapping
Returns the { @code ISyntax } from the { @code sqlTypeParam } and { @code formFieldMappingParam } .