RE: PFCSIG SetItemStatus

[Dario Schmidt]

Hi Peter,   My problem is:   * Dw Update properties --> Key modification: Use delete then insert * I insert a new row (dw_x.insertrow(0)). The row's status is NewModified! * The user input values. If the database have a record with the values of the key columns, i retrieve this record and setitem the values of the nokey columns. The value of a nokey column is changed with setitem. In this situation, i need generate a Sql Update, not a Sql Insert. Then, i set the status of the row to Datamodified! and set the status of the key columns to NotModified!. Too, the status of the nokey columns is set to NotModified!, except one that is set to DataModified! * When i update the dw, this generate a sql Delete and then a sql Insert. I think that should be generate a Sql Update that update the only nokey column modified.   Any ideas   Thanks -----Mensaje original----- De: Peter Brawley <[EMAIL PROTECTED]> Para: Dario Schmidt <[EMAIL PROTECTED]> CC: Lista PFC <[EMAIL PROTECTED]>; Lista PB <[EMAIL PROTECTED]> Fecha: Miércoles, 01 de Diciembre de 1999 03:09 a.m. Asunto: Re: PFCSIG SetItemStatus What am I missing? Use of update vs. delete/insert is set in the dw painter update properties, dlg and why change the status of a new row from newmod to datamod? Peter ---------------- Dario Schmidt wrote:  Hi, I am using PB 6.5, PFC and Sybase ASE 11.9.2. I have problems with SetItemStatus: 1) I insert a new row (status NewModified!)2) I modified the status of the row to DataModified!. The status of the key columns is set to NotModified!.3) When update the dw, this generate a Delete and then a Insert. I want to generate a Update. Any ideas.