Daniel, The YIELD()did the trick. One more time thanks again for the help. Bill -----Original Message----- From: Daniel Coppersmith [mailto:[EMAIL PROTECTED]] Sent: Monday, August 16, 1999 11:04 AM To: Skiffington, Bill Cc: PFCSIG Subject: Re: PFCSIG pfc_save Try putting a YIELD() prior to calling the pfc_save event (i.e. in the SAVE button), that should cause anything you posted to execute before the pfc_save... ----- Original Message ----- From: Skiffington, Bill <[EMAIL PROTECTED]> To: Daniel Coppersmith <[EMAIL PROTECTED]>; PFC Mailing List <[EMAIL PROTECTED]> Sent: Monday, August 16, 1999 1:04 PM Subject: RE: PFCSIG pfc_save > Daniel, > > Thanks again for your help. I was out of the office last week, that's why I > haven't responded. I started looking at this save problem again today. What > I had missed was in the ancestor 'ItemChanged' event for the dw I'm posting > an event to trim off trailing spaces. This is the code: > ItemChanged: Post Event ue_Trim(row, dwo.name, data) > ue_Trim: RETURN this.SetItem(al_row, as_col, trim(as_data)) > I'm still not sure why this doesn't always work, it looks like a timing > issue as to when these events are actually fired. This seemed like a > good(and easy)way to remove trailing spaces but if it's going to cause other > problems I guess I'll have to think of something another way. > > Bill > > > > -----Original Message----- > From: Daniel Coppersmith [mailto:[EMAIL PROTECTED]] > Sent: Friday, August 06, 1999 2:41 PM > To: Skiffington, Bill > Cc: PFCSIG > Subject: Re: PFCSIG pfc_save > > > Bill, > > It sounds like an AcceptText is not being fired as it should. Are you sure > the update is actually happening? (Turn on SQLSpy, or put a break point in > the u_dw SQLPREVIEW event to make sure the statement is actually being sent > to the database). > > That would explain the behavior -- since you don't tab out, the datawindow > doesn't know the value was modified so PFC_SAVE thinks there is nothing to > do, but when you attempt to close the window, closeQuery peforms an > (pfc_)AcceptText (the equivalent of you tabbing out of the column) and makes > the datawindow think something was changed and asks you if you want to save > the changes -- but, when you DO tab out and hit PFC_SAVE, it knows something > changes so it doesn't ask you. > > What confuses me though is PFC_SAVE should be doing an accept text... is it > possible that you somehow altered (e.g. overrode) the functionality of > pfc_acceptText on either the window or the datawindow? Check the window and > controls ancestor scripts as well... > > Check that and let me know.... you can quickly prove or disprove my theory > by putting an accept text right before the call to the PFC_SAVE event... (I > wouldn't recommend keeping it if it works though since that would cure the > symptom, not the disease but it would tell you if we're on the the right > track....) > > Daniel > > > > ----- Original Message ----- > From: Skiffington, Bill <[EMAIL PROTECTED]> > To: Daniel Coppersmith <[EMAIL PROTECTED]> > Sent: Friday, August 06, 1999 3:58 PM > Subject: RE: PFCSIG pfc_save > > > > Daniel, > > > > You almost have it. A-D are correct. If I perform steps a-d then try to > > close the window, that's when the pfc_saveChanges message is displayed. In > > step 'B', if I tab out of the column everything works correctly. > > > > Thanks again for your help. If you have any other ideas I would appreciate > > the help. > > > > Bill > > > > -----Original Message----- > > From: Daniel Coppersmith [mailto:[EMAIL PROTECTED]] > > Sent: Friday, August 06, 1999 11:02 AM > > To: Skiffington, Bill > > Subject: Re: PFCSIG pfc_save > > > > > > Bill, > > > > Let me rephrase your issue to make sure I understand it correctly... > > > > (a) Retrieve datawindow > > (b) Modify a value in a column but do not tab out of it > > (c) Click button that calls PFC_SAVE > > (d) Change is sent to the database > > > > However, if in step (b) you modify the value and tab out of the column, > > when you click PFC_SAVE it asks you if you want to save changes (which > > is silly because you obviously do since you clicked SAVE). > > > > Is that right? I might have misunderstood your issue. If I phrased > > it correctly, I am not sure what could cause that off the top of my head > > since the pfc_saveChanges message should only be displayed from > > the closequery event... > > > > If you want, you can e-mail me the exported script from the window (and > > datawindow control if you modified it) and I'll see if something jumps > > out at me... > > > > D > > > > > > > > ----- Original Message ----- > > From: Skiffington, Bill <[EMAIL PROTECTED]> > > To: Daniel Coppersmith <[EMAIL PROTECTED]> > > Cc: PFCSIG <[EMAIL PROTECTED]> > > Sent: Friday, August 06, 1999 12:07 PM > > Subject: RE: PFCSIG pfc_save > > > > > > > Daniel, > > > > > > Thanks for your quick response! What I am doing is a simple retrieve for > 1 > > > record, then I type in a change to a column. During the save process and > > > during the closequery process 'pfc_updatespending' is called. This > returns > > > the modified + deleted counts. The return value is always 1, unless I > tab > > > out of the modified column before I save. This is what leads me to > believe > > > that the status is not getting updated. > > > > > > Any thoughts? > > > > > > Thanks, > > > Bill > > > > > > > > > -----Original Message----- > > > From: Daniel Coppersmith [mailto:[EMAIL PROTECTED]] > > > Sent: Friday, August 06, 1999 9:07 AM > > > To: Skiffington, Bill > > > Cc: PFCSIG > > > Subject: Re: PFCSIG pfc_save > > > > > > > > > Bill, > > > > > > I would do some investigating into which status is being changed (it > might > > > not even be the datawindow you expect). > > > > > > (1) If you have a second datawindow that is used for retrieval > criteria > > > or some other display and is never meant for updating, call > > > of_setUpdateable(False) on it and PFC will ignore it. > > > (2) If you are sure the datawindow you expect is the one with the > > changed > > > status, loop through all the rows and if you find one that has a value > > other > > > than NotModified!, then search all of it's columns until you find one > that > > > is NotModified!, then see if you are doing a setItem on it. > > > > > > Your note said "It seems that the dw status isn't getting reset"... that > > > makes me think that you are doing something to the datawindow other than > a > > > simple retrieve (because if you just retrieve the datawindow and nothing > > > else, it's statuses should all be NotModified!). Are you doing set > items > > > anywhere? > > > > > > - If you are doing a setItemStatus, are trying to change to one you > cannot > > > go to directly? i.e. NewModified! to NotModified! > > > - Is a row being inserted that you didn't expect (and cannot see because > > > there's only room for 1 and no scroll bars?) > > > - Did you try cursing at it? Sometimes that helps. :) > > > > > > D > > > > > > > > > ----- Original Message ----- > > > From: Skiffington, Bill <[EMAIL PROTECTED]> > > > To: PFC Mailing List <[EMAIL PROTECTED]> > > > Sent: Friday, August 06, 1999 10:39 AM > > > Subject: PFCSIG pfc_save > > > > > > > > > > Maybe it's because it's Friday or maybe my brain is fried, or maybe > > both, > > > > but I'm not seeing this. > > > > I have a window with 1 dw on it. I retrieve a record, change a column, > > > click > > > > save(call pfc_save), and the changes are saved. However, if I didn't > > > change > > > > columns before saving, I get the 'Do you want to save your changes?' > > > > message. It seems that the dw status isn't getting reset. I can > manually > > > > reset the status, but I would like to do it the right way, which I'm > not > > > > seeing... Could someone point me in the right direction. > > > > > > > > > > > > TIA, > > > > Bill > > > > > [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]
