> 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/
