Dario,
You can't change the status from NewModified! to DataModified!. You go from
NewModified! to NotModified! and then to DataModified!. You can find a table
that illustrates all your options in help under SetItemStatus.
HTH,
Bill
-----Original Message-----
From: Daniel Coppersmith [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, November 30, 1999 6:28 AM
To: Dario Schmidt
Cc: PFCSIG
Subject: Re: PFCSIG SetItemStatus
Are you absolutely sure the status of the keys are NotModified! (check it
right before the update). Is it possible that any of the columns are still
set to New! (or NewModified!??), this might confuse PB if some of the other
columns are DataModified! and NotModified!....
I would execute a script right before the update that looks something like
this:
ll_cols = long(dw_1.describe("datawindow.column.count"))
do while ll_cols > 0
choose case dw_1.getItemStatus(1, ll_cols, Primary!)
case New!
messagebox("Column " + string(ll_cols), "New!")
case NewModified!
messagebox("Column " + string(ll_cols), "NewModified!")
case NotModified!
messagebox("Column " + string(ll_cols), "NotModified!")
case DataModified!
messagebox("Column " + string(ll_cols), "DataModified!")
end choose
ll_cols = ll_cols - 1
loop
If any pop up as New! or NewModified!, try setting the row's item status to
NotModified! right after the New!. Keep in mind also that you cannot always
go from 1 status to another status with one step. I think that going from
New! to NotModified! requires DataModified! then NotModified! (check my
facts though).
Also, check to make sure there is only 1 row and none in the delete buffer
as you expect....
D
(P.S. I didn't try to compile the above code, so there may be some syntax
issues, but it should be a good start).
----- Original Message -----
From: Dario Schmidt <mailto:[EMAIL PROTECTED]>
To: Lista PFC <mailto:[EMAIL PROTECTED]>
Sent: Tuesday, November 30, 1999 8:32 AM
Subject: RE: PFCSIG SetItemStatus
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] <mailto:[EMAIL PROTECTED]> >
Para: Dario Schmidt < [EMAIL PROTECTED]
<mailto:[EMAIL PROTECTED]> >
CC: Lista PFC < [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> >; Lista PB <
[EMAIL PROTECTED] <mailto:[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.
> [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]
