Error 7009 - Can Not Find The Row

[Michel Jr]

Hi,

After typing something inside the columns of the last row of a DataGrid, I try to delete that line, but occurs the following error:
Error 7009 - Can Not Find The Row
and also appears the word "#ERROR" inside each column.

I have a database bounded to the DataGrid and I don´t want to update the database.
How to avoid that error message?


Thanks in advance...

Michel Jr.

[InvisibleDuncan]

Sounds nasty.

Do you have any events that fire on your datagrid - e.g. RowColumn events? If so, the error might be caused in there.

Step through your code and see if the error happens as soon as you delete the row, or if it tries to run some code first.

[Michel Jr]

I already found the solution for the error message above.
But now I have another doubt:

If the user types something inside the columns of the last row of a DataGrid and then clicks on the left gray column (Row Selector) in another line, the consistence events (BeforeUpdate and BeforeColUpdate) of the last line are not verified.

So, the record is inserted in the database and may contain undesired values.


How can I avoid this inconvenience?

Thanks in advance...

Michel Jr.