I'm using mysql. I guess this is be triggered because I'm using InnoDB tables on this database. Still, I find it strange that I need to put select statements in a transaction to get the updated data. When using select outside a transaction, this means that you'll always want the updated data (or at least I would think so).
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Uwe Grauer Sent: 20. desember 2007 12:26 To: Dabo Users list Subject: Re: [dabo-users] Cursor not updating..? Simen Haugen wrote: > The problem is when the database has been updated by external sources... > When I then run this code again, I get the same result, and not the > updated values. If I restart the application it of course gets the > correct result again. ... > Start a transaction for a select statement? Isn't that a bit of a weird > workaround as I'm not modifying the database? > I don't use postgres. But if your second select is in the same transaction as the first and the db data was changed from other connections then you should not see the change. At least that is how it works in firebird. Uwe [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-users Searchable Archives: http://leafe.com/archives/search/dabo-users This message: http://leafe.com/archives/byMID/dabo-users/[EMAIL PROTECTED]
