Re: Oracle 8 and PowerBuilder 6.5 Data Window Source

Make sure you have not enabled the PB option in the Datawindow called something like "Data Retained on Save", which is under the 'Rows/Data" menu option I believe.
Also, check to make sure you re-retrieve the data after executing your stored procedure. Remember PB is a client/server application. Thus, data is brought to the client and NOT refreshed when the data on the table changes unless you refresh it via a 'retrieve'. One last option to check.... Who is doing the commit? Is there one?

Thats all the things I can think of. Hope it helps...

neslonik_at_my-deja.com wrote:

> I'm trying to convert an application from Sybase 11 to Oracle 8. In one
> of my windows an Oracle stored procedure which changes the contents of a
> table. This table is a data source for another data window. This
> stored procedure is executed thereby changing the contents of the
> database. But this change is not reflected in the data window when I
> run or debug the application. What am I doing wrong? Any suggestions
> would be welcome. Thank you.
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Fri Dec 17 1999 - 13:25:07 CST