Larry, I'll disagree with you on one point. I use forms to edit a portion of a record, and update other parts of the record with an eep, w/o contention.
fwiw, Ben Petersen On 11 Mar 2002, at 22:14, Lawrence Lustig wrote: > > Specifically, I want to conditionally > > "skip" a set of records w/in a region during an EDIT USING, but populate > it > > with our values for "SKIPPED" along the way, "-999" in the example below. > > > --Update current record, which is being SKIPped > > UPDATE RA_TEMP_LOADED SET + > > ResponseInput = "-999" WHERE + > > VARName = (.vVARNameThis) > > You can't do this (UPDATE the record that is currently on the form) since > the form has it's own copy of the records information in a buffer. You will > either get a contention problem (because the record is locked by the form) > or you run the risk of overwriting the UPDATEd information with the (old) > information in the form buffer. > > What you want to do is return the information from your EEP to form in some > way. This can be done by setting a variable in the EEP and, in the form > expression list, setting the column equal to the variable. If you do this, > you need to make sure to capture the original value of the column (usually > in the row entry eep) so that you don't overwrite the "good" values > with -999. You can also write PLAYBACK file in the EEP, play that file, > then position yourself on the field to be changed and let PLAYBACK do the > work. > > Alternatively, you can collect the PK values for the rows you skip in the > EEP by appending them to a comma delimited list and then, when you leave the > form, issuing an UPDATE WHERE PKField IN ( &ListVarName ). Or, best of all, > just exclude the skipped rows from the EDIT statement to begin with. > -- > Larry > > > > _________________________________________________________ > Do You Yahoo!? > Get your free @yahoo.com address at http://mail.yahoo.com > > ================================================ > TO SEE MESSAGE POSTING GUIDELINES: > Send a plain text email to [EMAIL PROTECTED] > In the message body, put just two words: INTRO rbase-l > ================================================ > TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] > In the message body, put just two words: UNSUBSCRIBE rbase-l > ================================================ > TO SEARCH ARCHIVES: > http://www.mail-archive.com/rbase-l%40sonetmail.com/ > ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: INTRO rbase-l ================================================ TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: UNSUBSCRIBE rbase-l ================================================ TO SEARCH ARCHIVES: http://www.mail-archive.com/rbase-l%40sonetmail.com/
