| SecureUser |
| VERBatim - V25 |
| @ATTACK - @Files.System |
| Advanced Revelation Initialisation Sequence (Overview) by Mike Pope |
| REVMEDIA Revisted |
| Reader's Clinic - Fixing %Windows% Using Depend.Update |
| QTIPS - Updating Indexes |
| How Indexes Are Updated |
| REVMEDIA Revisted |
| Simple Security |
| QTIPS - Hiding Symbolic Source Code |
| Using One Dictionary With Multiple Tables - Aaron Kaplan - SoftMart Inc |
| VERBatim - V17 |
| VERBatim - V6 |
| VERBatim - V125 |
| Utility Diskette # 3 - Part I |
| Version 3 Technical Highlights - Copying Rows Programmatically |
| Version 3 TCL Subroutines - Copying Rows |
| QTIPS - Command Line Options |
| QTIPS - Invalid Code and Command |
| QTIPS - Code/Command Help |
| Utility Diskette # 4 |
| Advanced Revelation Initialisation Sequence (Overview) by Mike Pope |
| QTIPS - Updating Multiple Dictionaries With A Single Command |
| RTP Series - RTP5 |
| VERBatim - V27 |
| REVMEDIA Revisted |
| QTIPS - Updating Multiple Dictionaries With A Single Command |
| Playing with Scan Codes |
| QTIPS - Compiling Protection Code |
| QTIPS - Invalid Code and Command |
| QTIPS - Code/Command Help |
| Compiling 64K on a Shoestring by Blaise Wrenn (LexStat Systems Ltd) |
| Reader's Clinic - Functions and Subroutines |
| Argument passing - Subroutines and Functions - Mike Pope |
| VERBatim - V16 |
| @ATTACK - @Int.Const |
| @ATTACK - @Move.Keys |
| @ATTACK - @Priority.Int |
| @ATTACK - @Macro.Mode |
| Uncommon Knowledge - WC_Unkeys% |
| Utility Diskette # 3 - Part I |
| Utility Diskette # 4 |
RevMedia FKB
| Document | V4I4A2 |
| Title | QTIPS - Updating Multiple Dictionaries With A Single Command |
| Keywords | DICT SYSCOLUMNS DICTCOMPILE EDIT_SOFTKEYS |
| Text | Jim Poe of Adobe Mountain SYSTEMS Inc writes as follows "If you are updating a system and need to update more than one dictionary you can accomplish all the updates in one copy command by USING the SYSCOLUMNS file as the destination file As an example Updating file DICT CUSTOMERS field NAME Updating file DICT INVOICES field INVOICE_DATE Use this command: COPY UPDATE_FILE CUSTOMERS*NAME INVOICES*INVOICE_DATE TO:(SYSCOLUMNS One caveat SYSCOLUMNS will translate FILE_NAME to FILE NAME if appropriate but will not translate FIELD_NAME to FIELD NAME " He then expands on this by saying "When updating an include record such as an EQUATE list that is used in multiple table dictionaries you can do the following: SELECT SYSCOLUMNS IF FORMULA [] "$Insert Bp Dict_Equates" DICTCOMPILE SYSCOLUMNS Then finally to ensure that he has really earned his sweatshirt he comments "The following code is useful when called FROM the editor softkeys It allows you to retrieve a formula FROM a dictionary item or a record FROM a source file and have it inserted in the CURRENT formula or record that you are editing" Subroutine Insert_Source(Param) @Pseudo = "" * Use existing system window to get file and record(s) to merge Call Catalyst("W" "@COMMANDS@ EDIT ANOTHER") If Len(@Pseudo<1>) Then File = @Pseudo<1> Record = @Pseudo<2> If File[1 4] = "DICT" Then Record = Xlate(File Record 8 "X") Convert @Fm To @Vm In Record End Else Record = Xlate(File Record "" "X") End /* Now put the information into @Cur Buf and RESET Cur Buf<1> to point to it Use 6 as this is beyond where Cut/Paste normally operates */ @Cur Buf<1> = 6 @Cur Buf<7> = Record @Data = @Edit Keys<10> ; * ^F4 paste End Return Simply catalog the above program then add it as a softkey USING the CW EDIT_SOFTKEYS command as documented in the 2 12 upgrade information (Volume 4 Issue 4 Pages 4 5) |
Page last modified: 31/01/03