select returns deleted rows

[dgarcia]

I'm having a very odd problem, pretty much after I go to Edit Data in a table and drop some rows then submit the changes, a select statement on that table still returns the rows. I have to reboot my computer to get the select statement to not show the rows.

This is only true for a select statement that is inside a stored procedure. If I use the query analyzer the select statement returns what is expected.

Any idea what would cause this?

 

[mike]

dgarcia - I have version 7.0.3. I've noticed that after I edit data in the grid and close the lock, it doesn't change anything in the database. If I re-run the query, the "Post changed records to the database?" dialog comes up, but it doesn't commit.

Thereforer, after I make changes, I have a "commit;" in the SQL window on a separate line and execute that after I make the changes. Then other sessions will see the changes and you don't have to close the session.

Marco - It might be nicer to have the dialog box come up when the lock icon is closed and a commit executed for us.

Thanks,

Mike

 

[dgarcia]

Interesting, that would probably seem to be the problem. I assumed that accepting the "Post changed records to the database?" dialog was equivalent to running a "commit;" command. I'll have to try that out the next time I run into this issue.

 

[CTzen]

AFAIK, "Post changed records to the databases" is equivalent to running actual SQL statement (delete, insert, update). You still have to press "Commit" or press F10 button on toolbar to commit your change.

 

[mike]

That's funny! I have typed "commit" forever and forgot about F10.

After thinking about it and being reminded of F10, it probably makes sense to not commit. I think it would make sense to have the dialog show up when the lock icon is closed though.

Thanks,