Inset problem

[mcginty]

Hi All,

I have a strange Insert problem (on MySQL v5).

If I have a Query Browser window open and somebody else inserts data into a table, when I select * from that table the newly inserted data is not displayed?

If I open a new instance of Query Browser and run the same query the data is returned.

It's as if the original Query Browser process does not see new data, or the data is cached somehow by process id?

Rgds,
Ed

 

[DonQuichote]

It looks like your query browser is using a transaction. I used a third-party database front-end that had the same problem. It took quite a while before I found out what the problem was and how to overcome it.

+++ Despite being wrong in every important aspect, that is a very good analogy +++
Hex (in Darwin's Watch)