The update properties are not usually set properly by powerbuilder, unless
the sql statement that is used to create the ds has only one table in it,
and has the primary key in the select clause.
Using the describe check the values of the update properties of the ds. Then
using the update function set the update properties properly as you think
approp for the application. This should fix the problems.
HTH
Surya
>From: "Laforce, Lester R, PERSCOM" <[EMAIL PROTECTED]>
>To: "'[EMAIL PROTECTED]'" <[EMAIL PROTECTED]>
>Subject: PFCSIG Dynamic DSs & DWOs: Updating Rows Deleted Rows
>Date: Wed, 16 Jun 1999 14:34:27 -0400
>
>All,
>
>Am attempting to replace embedded SQL with dynamic DSs & DWOs. Purpose of
>SQL is to delete rows from table. Have implemented dynamic DS & DWO's --
>including deletion of rows from DWO. However the update of the DS is
>skipping out because pfc_UpdatesPending() returns 0 ("No updates are
>pending"). I've traced the reason to a call to a DeletedCount() function
>in the event (pfc_UpdatesPending()) -- it is returning 0 (rows deleted).
>
>PowerBuilder help says "If a DataWindow is not updatable(SIC), rows that
>are
>deleted are discarded-they are not stored in the delete buffer. Therefore,
>DeletedCount always returns 0 for a nonupdatable(SIC) DataWindow
>
>Looks like I have to make the DSs "Updateable". Can anyone help with the
>solution?
>
>Lester LaForce
>Consultant, Metamor ITS
>US Army, Personnel Information Systems Directorate
> > [EMAIL PROTECTED] HOSTED BY IIGG, INC. FOR HELP WITH LIST SERVE COMMANDS,
>ADDRESS
> > A MESSAGE TO [EMAIL PROTECTED] WITH THE FOLLOWING MESSAGE: help
>pfcsig
> > SEND ALL OTHER INQUIRES TO [EMAIL PROTECTED]
_______________________________________________________________
Get Free Email and Do More On The Web. Visit http://www.msn.com
> [EMAIL PROTECTED] HOSTED BY IIGG, INC. FOR HELP WITH LIST SERVE COMMANDS, ADDRESS
> A MESSAGE TO [EMAIL PROTECTED] WITH THE FOLLOWING MESSAGE: help pfcsig
> SEND ALL OTHER INQUIRES TO [EMAIL PROTECTED]
