protected string DbNullAndDefault(TableFieldDefInfo fieldInfo) { if (fieldInfo == null) { return(DBConstants.EMPTY_STRING); } bool bColumnDefault = DbColumnDefault(); bool bFieldDefault = (fieldInfo.m_strDefaultValue.Length != 0); bool bRequiredDefault = DBPlatform.DefaultBindRequired(fieldInfo.m_lAttributes); bool bAutoIncremField = ((fieldInfo.m_lAttributes & DBConstants.dbAutoIncrField) != 0); string strFieldNames = DBConstants.EMPTY_STRING; if (bColumnDefault) { if (fieldInfo.m_bRequired && bRequiredDefault) { strFieldNames = StringUtils.JoinNonEmpty(" ", strFieldNames, DbTypeDefault(fieldInfo.m_nType)); } } if (bAutoIncremField == false) { if (fieldInfo.m_bRequired) { strFieldNames = StringUtils.JoinNonEmpty(" ", strFieldNames, "NOT NULL"); } else { strFieldNames = StringUtils.JoinNonEmpty(" ", strFieldNames, "NULL"); } } return(strFieldNames); }
public override string CreateTableBND(TableDefInfo tableDef, uint versCreate) { string strSQL = ""; var tableFields = tableDef.TableColumnsForVersion(versCreate); foreach (var field in tableFields) { string strDefaultSQL; bool bRequiredDefault = DBPlatform.DefaultBindRequired(field.m_lAttributes); if (field.m_bRequired && bRequiredDefault) { if (DBPlatform.DefaultBindDataType(field.m_nType)) { strDefaultSQL = BindDefaultDataTypeSql(tableDef.TableName(), field.m_strName); strSQL += (strDefaultSQL); strSQL += DBConstants.NEW_LINE_STR; strSQL += DBConstants.NEW_LINE_STR; } } } return(strSQL); }