Be sure that under Rows-Update Properties the updateable check box is set
and the appropriate columns are specified. For dynamic datastores that you
are creating on the fly, be sure that values such as
datawindow.table.updatetable,
datawindow.table.updatewhere,
datawindow.table.updatekeyinplace
columnname.update
are all set properly. I would recommend building a datawindow object,
exporting the source and looking at it for examples.
D
----- Original Message -----
From: Laforce, Lester R, PERSCOM <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, June 16, 1999 1:34 PM
Subject: PFCSIG Dynamic DSs & DWOs: Updating Rows Deleted Rows
> 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]
>
> [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]
