private void UpdateTextField(LanguageTableInfo languageTable)
{
string SqlQuery = string.Empty;
try
{
if (languageTable.TextColumnSize == -1)
{
SqlQuery = " UPDATE " + languageTable.TableName
+ " SET " + languageTable.ColumnName + " = '#' & " + languageTable.ColumnName;
}
else
{
SqlQuery = " UPDATE " + languageTable.TableName
+ " SET " + languageTable.ColumnName + " = '#' &" +
" iif( len(" + languageTable.ColumnName + ")>" + languageTable.TextColumnSize + " ,left(" + languageTable.ColumnName + ", " + languageTable.TextColumnSize + " ) ," + languageTable.ColumnName + ") ";
}
this.DBConnection.ExecuteNonQuery(SqlQuery);
}
catch (Exception ex)
{
ExceptionFacade.ThrowException(ex);
}
}
private void UpdateTextField(LanguageTableInfo languageTable)
{
string SqlQuery = string.Empty;
try
{
if (languageTable.TextColumnSize == -1)
{
SqlQuery = " UPDATE " + languageTable.TableName
+ " SET " + languageTable.ColumnName + " = '#' & " + languageTable.ColumnName;
}
else
{
SqlQuery = " UPDATE " + languageTable.TableName
+ " SET " + languageTable.ColumnName + " = '#' &" +
" iif( len(" + languageTable.ColumnName + ")>" + languageTable.TextColumnSize + " ,left(" + languageTable.ColumnName + ", " + languageTable.TextColumnSize + " ) ," + languageTable.ColumnName + ") ";
}
this.DBConnection.ExecuteNonQuery(SqlQuery);
}
catch (Exception ex)
{
ExceptionFacade.ThrowException(ex);
}
}