| Make.Index |
| !File Records |
| Relational Indexes - Reordering |
| Referential Integrity |
| QTIPS - Deleting Master Relationally Indexed Records |
| Utility Diskette # 4 |
| QTIPS - Command Line Options |
| QTIPS - Invalid Code and Command |
| QTIPS - Code/Command Help |
| Utility Diskette # 4 |
| SecureUser |
| VERBatim - V25 |
| @ATTACK - @Files.System |
| Advanced Revelation Initialisation Sequence (Overview) by Mike Pope |
| REVMEDIA Revisted |
| Form.List.S |
| QTIPS - Aesthetically Improving RLIST Reports |
| QTIPS - Form Processor |
| QTIPS - Suppressing Initial Form Feed |
| QTIPS - Using RTP29 In Place of V6 |
| Vroom |
| RTP Series - RTP5 |
| VERBatim - V15 |
| Play it Again, Cam |
| QTIPS - BASIC Options |
| Utility Diskette # 4 |
| QTIPS - Using @Upper.Case and @Lower.Case with Foreign Languages |
| @ATTACK - @Lower.Case |
| @ATTACK - @Upper.Case |
| Sorting out Collation Sequences by Mike Pope |
RevMedia FKB
| Document | V2I6A6 |
| Title | QTIPS - Deleting Master Relationally Indexed Records |
| Keywords | INDEX RELATIONAL DELETE |
| Text | (Tested on 1 16) There may be times when it is considered desirable to delete a record that contains relational keys linking it to other table(s) If a DELETE file rec_id command is issued the record is deleted but at the next "Updating Indexes" the system restores the record blank but for the related keys In some ways this is desirable as it enforces a form of referential integrity but it can make things difficult Jim Owens was provided WITH a routine by Sprezzatura to do this but using the basic principles provided refined the routine into that found below OPEN DATAFILE TO TARGET THEN DELETE TARGET REC_TO_DELETE X = "" WRITE X ON TARGET REC_TO_DELETE DELETE TARGET REC_TO_DELETE END As Jim says "I'm not sure WHY it works! but it works" What is probably happening is that the TRANSACTION record sequence is in some way being fooled by the rapid sequence of events As this is the case there is a strong possibility that this will be rectified in a future release of the software so if you use this tip check it WITH every AREV upgrade (Volume 2 Issue 6 Page 5) |
Page last modified: 08/02/03