Error while updating

  • Thread starter Thread starter Sachiek_sachiek
  • Start date Start date
S

Sachiek_sachiek

Hi,
I am trying to update the records which is editing in
dataset with Datagrid.
After editing i am taking to my DAL layer where i use
prepareupdatecommand to construct the SQL.
But it throws a error saying "ORA-00904: "UPDATED_ON":
invalid identifier" while executing that command. I am
using oracle DB.
Please let me know if any one had solve this problem.

Best Regards,
Sachi
 
Hi,
Ya I debugged it. It failed when trying to
retrive "DataViewRowState.ModifiedCurrent" for
datatablechanged !!!.. I could'nt understand why???

Any clues?

...
Sachi
-----Original Message-----
Hi,

You might check what has prepareupdatecommand method
Click to expand...
generated.
 
It doesn't make sense (combined with the error message you gave).
Can you share some code?
 
Here is it...When it is looking for ModifiedCurrent it
fails and throw that error.

dataTableWithChanges =
associatedCommand.AssociatedTable.GetChanges
(DataRowState.Modified);

adapter.UpdateCommand = associatedCommand.Command;

adapter.Update(dataTableWithChanges.Select(null,
null, DataViewRowState.ModifiedCurrent));
 
Back
Top