search

thomastom99 / wc

wc Public Repository
0 stars 0 forks source link

Add Remark Type Error #9

Closed thomastom99 closed 9 years ago

thomastom99 commented 9 years ago

When we try to add Remark Type like Salary from EmployeeDetails/EDDefaultSettings.aspx It is showing error . Seems to be Database Table filed problem..

see the error System.Data.OleDb.OleDbException: Data type mismatch in criteria expression. at System.Data.OleDb.OleDbCommand.ExecuteCommandTextErrorHandling(OleDbHResult hr) at System.Data.OleDb.OleDbCommand.ExecuteCommandTextForSingleResult(tagDBPARAMS dbParams, Object& executeResult) at System.Data.OleDb.OleDbCommand.ExecuteCommandText(Object& executeResult) at System.Data.OleDb.OleDbCommand.ExecuteCommand(CommandBehavior behavior, Object& executeResult) at System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior behavior, String method) at System.Data.OleDb.OleDbCommand.ExecuteNonQuery() at DatabaseUtils.ExceuteQuery(String strQuery)

Please Discuss this with Jithin and then fix it..

Revathyms commented 9 years ago

The Issue was When we try to add Remark Type like Salary from EmployeeDetails/EDDefaultSettings.aspx It is showing error. Now I fix the bug using alter table query ALTER TABLE EMP_DETAILS_REMARK_MASTER_TB ALTER COLUMN RemarkName text