Error while updating

[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

 

[Miha Markic]

Hi,

You might check what has prepareupdatecommand method generated.

 

[Guest]

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

generated.

 

[Miha Markic]

It doesn't make sense (combined with the error message you gave).
Can you share some code?

 

[Sachi]

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));