This isn't a bug in the ODBC driver. That is the way it should work by
default.
It will only read committed reads. You either need to commit the
records yourself
in a transaction or let the program do it automatically by turning on
AutoCommit.

vmdd_tech wrote:

>Background:
>My PowerBuilder app can not see changes that
>have been committed by other apps (e.g., Java apps). Note that
>by default, PB apps have sqlca's autocommit to be off.
>
>This has been reported since v1.1 beta 1 and 2. I've just tested
>with v1.2, and the problem is still there.
>
>However, when I make PB's sqlca's autocommit to be true, then PB
>apps can see other changes by other apps.
>
>Ben
>
>PS: Will someone please forward this message to the ODBC development
>group? Thanks.
>
>
>
>
>
>
>
>Yahoo! Groups Links
>
>
>
>
>
>
>
>

--
Thomas Miller
Delphi Client/Server Certified Developer
BSS Accounting & Distribution Software
BSS Enterprise Accounting FrameWork

http://www.bss-software.com
http://sourceforge.net/projects/dbexpressplus