I'm attempting to implement the Linkage Service's TopDown_BottomUp
UpdateStyle (we're planning to use it to implement cascading deletes).
I'm certain I've correctly coded the initialization of the Linkage Service,
the registration of the various DWs and correctly initialized the
UpdateStyle.
In testing, I've inserted a row in one of the child DWs and then called
pfc_Save(). Everything seems to be working correctly except that the DW
Update() function is being called twice for my child DW and the second call
is causing a Duplicate Primary Key error.
This is, of course related to the fact the TopDown_BottomUp EditStyle does
its update in two passes, a TopDown pass and a BottomUp pass.
In the PFC, the SQLPreview event is supposed to provide selective updates,
inserts, and deletes.
In the case of an Insert, the second pass is trapped by the SQLPreview event
and the update suppressed by having SQLPreview return a 2.
The documentation says; "return 2 = Skip this request and execute the next
request"
In the debugger I can see. the event returns the correct value (2), but the
request is not skipped, thereby causing the DB error.
Does anyone have any suggestions? We are using PB6.5 with a MS SQL Server
6.5 back-end.
Lester LaForce
[EMAIL PROTECTED]
Sr. Software Developer (Contractor)
Future Technologies, Inc.
Armed Forces Institute of Pathology
Washington DC
> [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]
