First Union Securities, Inc.
If you don't want the datawindow to do a delete>insert on update, then
simply change that setting in the datawindow to "update." If you want to
prevent inserting a duplicate row, you will have to check for existence and
(if the row already exists) change the row status to from newmodified! to
datamodified! Then do your update. The whole concept sounds fishy though.
Why would you want to allow the user to clobber perfectly good data without
even looking at it?
Jim Anderson - <>< FDFX
Time flies like an arrow. Fruit flies like a banana.
-----Original Message-----
From: Dario Schmidt [SMTP:[EMAIL PROTECTED]]
Sent: Tuesday, November 30, 1999 8:32 AM
To: Lista PFC
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.
This is for your information only and is not an offer to sell, or a solicitation of an
offer to buy, the securities or instruments mentioned. The information has been
obtained or derived from sources believed by us to be reliable, but we do not
represent that it is accurate or complete. Any opinions or estimates contained in
this information constitute our judgement as of this date and are subject to change
without notice. First Union Securities, Inc. (FUSI), or its affiliates may provide
advice or may from time to time acquire, hold or sell a position in the securities
mentioned herein. FUSI is a subsidiary of First Union Corporation and is a member of
the NYSE, NASD and SIPC. FUSI is a separate and distinct entity from its affiliated
banks and thrifts.
> [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]
