| QTIPS - DOSTime |
| VERBatim - V11 |
| @ATTACK - @Backgrnd.Time |
| @ATTACK - @Index.Time |
| QTIPS - Time-outs in Windows |
| Reader's Clinic - Screen Width |
| Screen Grabber |
| Reader's Clinic - Slow Multivalued Screen Display |
| Utility Diskette # 4 |
| Networked %SK% |
| Network Contention |
| Directory Exists on Novell |
| QTIPS - String Space Format Errors |
| QTIPS - Postscript Driver Problem |
| Reader's Clinic - Preventing Records Being Amended |
| QTIPS - Finding/Replacing Spaces With The Editor |
| Reader's Clinic - Scribe Replace Processes in Window |
| Creating Your Own Background Processes |
| @ATTACK - @Last.Select.Process |
| Reader's Forum |
| QTIPS - Menu Item Pre-Processing |
| @ATTACK - @Record |
| @ATTACK - @Reduction.Done |
| Collector Windows |
| Soft Windows |
| Reader's Clinic - Template Name at Pre-Init |
| Networked %SK% |
| Catalyst |
| Reader's Clinic - Preventing Records Being Amended |
| Uncommon Knowledge - WC_DataFile_Next% |
| REVMEDIA Revisted |
| Uncommon Knowledge - WC_Src_File% |
RevMedia FKB
| Document | V1I7A1 |
| Title | Reader's Clinic - Preventing Records Being Amended |
| Keywords | WC_SRC_FILE% WINDOW_COMMON% REPLACE READ WC_WLOCKED% |
| Text | A user in Cardiff had a problem recently WITH trying to find an easy way of preventing records FROM being amended when certain trigger fields had been filled in That is they wished to allow time sheets to be entered and amended UNTIL an invoice had been produced AFTER the invoice was produced (and the invoice number was stored in the time sheet record) the user had to be able to call up the time sheet on screen and scroll through all values but not amend anything The question was "What is the most efficient way of achieving this ?" The initial solution of SETTING all of the fields to protected worked but was cumbersome A more elegant solution was achieved by the realisation that when a record is locked on the network no editing is possible Once this was realised duplicating this functionality provided the better solution The answer was to use a replace read process coded as follows $INSERT WINDOW_COMMON% READ @RECORD FROM WC_SRC_FILE% @ID THEN IF @RECORD<55> THEN * Or whatever condition you wish to assign WC_WLOCKED% = 0 UNLOCK WC_SRC_FILE% @ID END END ELSE @RECORD = "" END The WC_WLocked% = 0 instructs the window processor that the record could not be locked and is therefore NOT available for editing However because the window processor thinks that the record is locked it will not attempt to unlock it AFTER the record has been exited The record must therefore be explicitly unlocked by the process (Volume 1 Issue 7 Page 3) |
Page last modified: 08/02/03