home *** CD-ROM | disk | FTP | other *** search
Unknown | 1994-04-28 | 13.7 KB |
open in:
MacOS 8.1
|
Win98
|
DOS
view JSON data
|
view as text
This file was not able to be converted.
This format is not currently supported by dexvert.
Confidence | Program | Detection | Match Type | Support
|
---|
66%
| dexvert
| AMOS Picture Packer (image/amosPicturePacker)
| ext
| Supported |
1%
| dexvert
| Debian floppy split (archive/debianFloppySplit)
| ext
| Unsupported |
1%
| dexvert
| Sound Images sound sample (audio/soundImagesSoundSample)
| ext
| Unsupported |
1%
| dexvert
| STarKos tune (music/sTarKosTune)
| ext
| Unsupported |
1%
| dexvert
| CADVANCE drawing (image/cadvanceDrawing)
| ext
| Unsupported |
1%
| dexvert
| DESI-III drawing (image/desiIIIDrawing)
| ext
| Unsupported |
1%
| dexvert
| MS-DOS PMODE extender executable (executable/msdosPMODEExtenderExecutable)
| ext
| Unsupported |
1%
| dexvert
| Alien Trilogytextures (other/alienTrilogyTextures)
| ext
| Unsupported |
1%
| dexvert
| APT cache data (other/aptCacheData)
| ext
| Unsupported |
1%
| dexvert
| CADVANCE 2D symbol (other/cadvance2DSymbol)
| ext
| Unsupported |
1%
| dexvert
| Cakewalk Groove (other/cakewalkGroove)
| ext
| Unsupported |
1%
| dexvert
| Comic Book Creator Background (other/comicBookCreatorBackground)
| ext
| Unsupported |
1%
| dexvert
| Comic Book Creator shape Table (other/comicBookCreatorShapeTable)
| ext
| Unsupported |
1%
| dexvert
| CorelTRACE configuration (other/corelTRACEConfiguration)
| ext
| Unsupported |
1%
| dexvert
| Dreamcast Disc (other/dreamcastDisc)
| ext
| Unsupported |
1%
| dexvert
| EST flat binary (other/estFlatBinary)
| ext
| Unsupported |
1%
| dexvert
| Finale Enigma Binary Format (other/finaleEnigmaBinaryFormat)
| ext
| Unsupported |
1%
| dexvert
| Sega Genesis/Megadrive/32x ROM (other/genesisROM)
| ext
| Unsupported |
1%
| dexvert
| Myth: The Fallen Lords game archive (other/mythTheFallenLordsGameArchive)
| ext
| Unsupported |
1%
| dexvert
| Sega Saturn ROM (other/segaSaturnROM)
| ext
| Unsupported |
1%
| dexvert
| Sound Images Sound Driver (other/soundImagesSoundDriver)
| ext
| Unsupported |
1%
| dexvert
| Symantec/Norton Config (other/symantecNortonConfig)
| ext
| Unsupported |
1%
| dexvert
| Vectrex ROM (other/vectrexROM)
| ext
| Unsupported |
1%
| dexvert
| Adrenaline Rush Hour game data (other/adrenalineRushHourGameData)
| ext
| Unsupported |
1%
| dexvert
| Bandai Tamagochi game data (other/bandaiTamagochiGameData)
| ext
| Unsupported |
1%
| dexvert
| BIS raP encoded format (other/bisraPEncoded)
| ext
| Unsupported |
1%
| dexvert
| Linksys RT31P2-NA firmware (other/linksysRT31P2NAFirmware)
| ext
| Unsupported |
1%
| dexvert
| Pascal Script binary (other/pascalScriptBinary)
| ext
| Unsupported |
1%
| dexvert
| 7th Level game data archive (other/seventhLevelGameDataArchive)
| ext
| Unsupported |
1%
| dexvert
| Star Wars Galaxies TRE archive (other/starWarsGalaxiesTREArchive)
| ext
| Unsupported |
1%
| dexvert
| Statistica MFM data (other/statisticaMFMData)
| ext
| Unsupported |
1%
| dexvert
| Surf's Up game data archive (other/surfsUpGameDataArchive)
| ext
| Unsupported |
1%
| dexvert
| TP-Link router firmware (other/tpLinkRouterFirmware)
| ext
| Unsupported |
1%
| dexvert
| Binary Text (image/binaryText)
| fallback
| Supported |
100%
| file
| Adobe Photoshop Color swatch, version 0, 424 colors; 1st RGB space (0), w 0x21, x 0, y 0, z 0 ; 2nd RGB space (0), w 0, x 0, y 0, z 0
| default (weak)
| |
99%
| file
| data
| default
| |
100%
| TrID
| MacBinary 1
| default (weak)
|
|
hex view+--------+-------------------------+-------------------------+--------+--------+
|00000000| 00 00 01 a8 00 00 00 21 | 00 00 00 00 00 00 00 00 |.......!|........|
|00000010| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000020| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000030| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000040| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000050| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000060| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000070| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000080| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000090| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000000a0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000000b0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000000c0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000000d0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000000e0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000000f0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000100| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000110| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000120| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000130| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000140| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000150| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000160| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000170| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000180| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000190| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000001a0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000001b0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000001c0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000001d0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000001e0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000001f0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000200| 74 0d 0a 20 20 20 20 20 | 20 52 45 50 4c 41 43 45 |t.. | REPLACE|
|00000210| 00 00 00 01 00 00 00 e8 | 53 45 54 20 53 59 53 4d |........|SET SYSM|
|00000220| 45 4e 55 20 41 55 54 4f | 4d 41 54 49 43 0d 0a 45 |ENU AUTO|MATIC..E|
|00000230| 58 54 45 52 4e 41 4c 20 | 50 52 4f 43 45 44 55 52 |XTERNAL |PROCEDUR|
|00000240| 45 20 73 68 6f 77 70 6f | 70 2c 20 6a 75 73 74 73 |E showpo|p, justs|
|00000250| 74 65 6d 2c 20 6a 75 73 | 74 66 6e 61 6d 65 2c 20 |tem, jus|tfname, |
|00000260| 6a 75 73 74 70 61 74 68 | 2c 20 61 64 64 62 73 2c |justpath|, addbs,|
|00000270| 20 3b 0d 0a 20 20 20 66 | 6f 72 63 65 65 78 74 2c | ;.. f|orceext,|
|00000280| 20 64 65 66 61 75 6c 74 | 65 78 74 2c 20 6a 75 73 | default|ext, jus|
|00000290| 74 65 78 74 0d 0a 0d 0a | 49 46 20 54 59 50 45 28 |text....|IF TYPE(|
|000002a0| 22 53 4b 49 50 56 41 52 | 22 29 20 3c 3e 20 22 55 |"SKIPVAR|") <> "U|
|000002b0| 22 0d 0a 20 20 20 52 45 | 4c 45 41 53 45 20 6d 2e |".. RE|LEASE m.|
|000002c0| 73 6b 69 70 76 61 72 0d | 0a 45 4e 44 49 46 0d 0a |skipvar.|.ENDIF..|
|000002d0| 50 55 42 4c 49 43 20 6d | 2e 73 6b 69 70 76 61 72 |PUBLIC m|.skipvar|
|000002e0| 0d 0a 6d 2e 73 6b 69 70 | 76 61 72 20 3d 20 2e 46 |..m.skip|var = .F|
|000002f0| 2e 0d 0a 43 4c 45 41 52 | 20 4d 41 43 52 4f 0d 0a |...CLEAR| MACRO..|
|00000300| 20 20 20 20 45 4e 44 49 | 46 0d 0a 20 20 20 20 20 | ENDI|F.. |
|00000310| 20 49 46 20 28 6f 6c 64 | 00 00 00 01 00 00 00 09 | IF (old|........|
|00000320| 5f 4d 53 59 53 4d 45 4e | 55 00 00 00 00 00 00 00 |_MSYSMEN|U.......|
|00000330| 00 00 00 00 00 00 00 00 | 00 00 00 00 01 00 00 00 |........|........|
|00000340| 06 5c 3c 46 69 6c 65 00 | 00 00 00 00 00 00 00 00 |.\<File.|........|
|00000350| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 01 00 00 |........|........|
|00000360| 00 04 46 69 6c 65 00 00 | 00 00 00 00 00 00 00 00 |..File..|........|
|00000370| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 01 00 |........|........|
|00000380| 00 00 0d 5c 3c 50 72 69 | 6e 74 20 53 65 74 75 70 |...\<Pri|nt Setup|
|00000390| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 01 |........|........|
|000003a0| 00 00 00 0a 5f 4d 46 49 | 5f 53 45 54 55 50 00 00 |...._MFI|_SETUP..|
|000003b0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000003c0| 01 00 00 00 02 5c 2d 00 | 00 00 00 00 00 00 00 00 |.....\-.|........|
|000003d0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000003e0| 00 01 00 00 00 0a 5f 71 | 39 6f 30 6b 6b 70 76 6d |......_q|9o0kkpvm|
|000003f0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000400| 00 00 01 00 00 00 06 5c | 3c 51 75 69 74 00 00 00 |.......\|<Quit...|
|00000410| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000420| 00 00 00 01 00 00 00 88 | 2a 20 53 65 6c 65 63 74 |........|* Select|
|00000430| 20 74 68 65 20 6d 61 69 | 6e 20 64 61 74 61 62 61 | the mai|n databa|
|00000440| 73 65 0d 0a 64 62 66 73 | 74 65 6d 20 3d 20 6a 75 |se..dbfs|tem = ju|
|00000450| 73 74 73 74 65 6d 28 6d | 2e 64 62 66 6e 61 6d 65 |ststem(m|.dbfname|
|00000460| 29 0d 0a 53 45 4c 45 43 | 54 20 28 64 62 66 73 74 |)..SELEC|T (dbfst|
|00000470| 65 6d 29 0d 0a 3d 61 63 | 74 77 69 6e 28 6d 2e 77 |em)..=ac|twin(m.w|
|00000480| 69 6e 5f 6e 61 6d 65 29 | 0d 0a 0d 0a 62 61 69 6c |in_name)|....bail|
|00000490| 6f 75 74 20 3d 20 2e 54 | 2e 0d 0a 43 4c 45 41 52 |out = .T|...CLEAR|
|000004a0| 20 52 45 41 44 0d 0a 0d | 0a 0d 0a 20 20 20 0d 0a | READ...|... ..|
|000004b0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000004c0| 00 00 00 00 00 00 00 00 | 01 00 00 00 06 5c 3c 45 |........|.....\<E|
|000004d0| 64 69 74 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |dit.....|........|
|000004e0| 00 00 00 00 00 00 00 00 | 00 01 00 00 00 05 41 4c |........|......AL|
|000004f0| 54 2b 45 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |T+E.....|........|
|00000500| 00 00 00 00 00 00 00 00 | 00 00 01 00 00 00 04 45 |........|.......E|
|00000510| 64 69 74 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |dit.....|........|
|00000520| 00 00 00 00 00 00 00 00 | 00 00 00 01 00 00 00 05 |........|........|
|00000530| 43 75 5c 3c 74 00 00 00 | 00 00 00 00 00 00 00 00 |Cu\<t...|........|
|00000540| 00 00 00 00 00 00 00 00 | 00 00 00 00 01 00 00 00 |........|........|
|00000550| 06 43 54 52 4c 2b 58 00 | 00 00 00 00 00 00 00 00 |.CTRL+X.|........|
|00000560| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 01 00 00 |........|........|
|00000570| 00 06 43 74 72 6c 2b 58 | 00 00 00 00 00 00 00 00 |..Ctrl+X|........|
|00000580| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 01 00 |........|........|
|00000590| 00 00 08 5f 4d 45 44 5f | 43 55 54 00 00 00 00 00 |..._MED_|CUT.....|
|000005a0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 01 |........|........|
|000005b0| 00 00 00 06 5c 3c 43 6f | 70 79 00 00 00 00 00 00 |....\<Co|py......|
|000005c0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000005d0| 01 00 00 00 06 43 54 52 | 4c 2b 43 00 00 00 00 00 |.....CTR|L+C.....|
|000005e0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000005f0| 00 01 00 00 00 06 43 74 | 72 6c 2b 43 52 45 50 4c |......Ct|rl+CREPL|
|00000600| 41 43 45 20 6e 65 77 2e | 76 70 6f 73 20 57 49 00 |ACE new.|vpos WI.|
|00000610| 00 00 01 00 00 00 09 5f | 4d 45 44 5f 43 4f 50 59 |......._|MED_COPY|
|00000620| 20 20 20 20 20 52 45 50 | 4c 41 43 45 20 6e 65 77 | REP|LACE new|
|00000630| 00 00 00 01 00 00 00 07 | 5c 3c 50 61 73 74 65 00 |........|\<Paste.|
|00000640| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000650| 00 00 00 00 01 00 00 00 | 06 43 54 52 4c 2b 56 00 |........|.CTRL+V.|
|00000660| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000670| 00 00 00 00 00 01 00 00 | 00 06 43 74 72 6c 2b 56 |........|..Ctrl+V|
|00000680| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000690| 00 00 00 00 00 00 01 00 | 00 00 0a 5f 4d 45 44 5f |........|..._MED_|
|000006a0| 50 41 53 54 45 00 00 00 | 00 00 00 00 00 00 00 00 |PASTE...|........|
|000006b0| 00 00 00 00 00 00 00 01 | 00 00 00 12 50 61 73 74 |........|....Past|
|000006c0| 65 20 5c 3c 53 70 65 63 | 69 61 6c 2e 2e 2e 00 00 |e \<Spec|ial.....|
|000006d0| 00 00 00 00 00 00 00 00 | 01 00 00 00 0a 5f 4d 45 |........|....._ME|
|000006e0| 44 5f 50 53 54 4c 4b 00 | 00 00 00 00 00 00 00 00 |D_PSTLK.|........|
|000006f0| 00 00 00 00 00 00 00 00 | 00 01 00 00 00 05 43 6c |........|......Cl|
|00000700| 65 61 72 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |ear.....|........|
|00000710| 00 00 00 00 00 00 00 00 | 00 00 01 00 00 00 0a 5f |........|......._|
|00000720| 4d 45 44 5f 43 4c 45 41 | 52 00 00 00 00 00 00 00 |MED_CLEA|R.......|
|00000730| 00 00 00 00 00 00 00 00 | 00 00 00 01 00 00 00 02 |........|........|
|00000740| 5c 2d 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |\-......|........|
|00000750| 00 00 00 00 00 00 00 00 | 00 00 00 00 01 00 00 00 |........|........|
|00000760| 0a 5f 4d 45 44 5f 53 50 | 32 30 30 00 00 00 00 00 |._MED_SP|200.....|
|00000770| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 01 00 00 |........|........|
|00000780| 00 12 5c 3c 49 6e 73 65 | 72 74 20 4f 62 6a 65 63 |..\<Inse|rt Objec|
|00000790| 74 2e 2e 2e 00 00 00 00 | 00 00 00 00 00 00 01 00 |t.......|........|
|000007a0| 00 00 0a 5f 4d 45 44 5f | 49 4e 53 4f 42 00 00 00 |..._MED_|INSOB...|
|000007b0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 01 |........|........|
|000007c0| 00 00 00 0b 5c 3c 4f 62 | 6a 65 63 74 2e 2e 2e 00 |....\<Ob|ject....|
|000007d0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000007e0| 01 00 00 00 08 5f 4d 45 | 44 5f 4f 42 4a 00 00 00 |....._ME|D_OBJ...|
|000007f0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000800| 00 01 00 00 00 0d 43 68 | 61 6e 67 65 20 4c 69 6e |......Ch|ange Lin|
|00000810| 5c 3c 6b 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |\<k.....|........|
|00000820| 00 00 01 00 00 00 09 5f | 4d 45 44 5f 4c 49 4e 4b |......._|MED_LINK|
|00000830| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000840| 00 00 00 01 00 00 00 13 | 43 6f 6e 5c 3c 76 65 72 |........|Con\<ver|
|00000850| 74 20 54 6f 20 53 74 61 | 74 69 63 00 00 00 00 00 |t To Sta|tic.....|
|00000860| 00 00 00 00 01 00 00 00 | 0a 5f 4d 45 44 5f 43 56 |........|._MED_CV|
|00000870| 54 53 54 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |TST.....|........|
|00000880| 00 00 00 00 00 01 00 00 | 00 02 5c 2d 00 00 00 00 |........|..\-....|
|00000890| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000008a0| 00 00 00 00 00 00 01 00 | 00 00 0a 5f 6d 65 64 5f |........|..._med_|
|000008b0| 73 70 33 30 30 00 00 00 | 00 00 00 00 00 00 00 00 |sp300...|........|
|000008c0| 00 00 00 00 00 00 00 01 | 00 00 00 0c 53 65 6c 65 |........|....Sele|
|000008d0| 63 74 20 5c 3c 41 6c 6c | 00 00 00 00 00 00 00 00 |ct \<All|........|
|000008e0| 00 00 00 00 00 00 00 00 | 01 00 00 00 06 43 54 52 |........|.....CTR|
|000008f0| 4c 2b 41 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |L+A.....|........|
|00000900| 00 00 00 00 00 00 00 00 | 00 01 00 00 00 06 43 74 |........|......Ct|
|00000910| 72 6c 2b 41 00 00 00 00 | 00 00 00 00 00 00 00 00 |rl+A....|........|
|00000920| 00 00 00 00 00 00 00 00 | 00 00 01 00 00 00 0a 5f |........|......._|
|00000930| 4d 45 44 5f 53 4c 43 54 | 41 00 00 00 00 00 00 00 |MED_SLCT|A.......|
|00000940| 00 00 00 00 00 00 00 00 | 00 00 00 01 00 00 00 02 |........|........|
|00000950| 5c 2d 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |\-......|........|
|00000960| 00 00 00 00 00 00 00 00 | 00 00 00 00 01 00 00 00 |........|........|
|00000970| 0a 5f 4d 45 44 5f 53 50 | 33 30 30 00 00 00 00 00 |._MED_SP|300.....|
|00000980| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 01 00 00 |........|........|
|00000990| 00 10 5c 3c 50 72 65 66 | 65 72 65 6e 63 65 73 2e |..\<Pref|erences.|
|000009a0| 2e 2e 00 00 00 00 00 00 | 00 00 00 00 00 00 01 00 |........|........|
|000009b0| 00 00 09 5f 4d 45 44 5f | 50 52 45 46 00 00 00 00 |..._MED_|PREF....|
|000009c0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 01 |........|........|
|000009d0| 00 00 00 0d 5c 3c 41 70 | 70 6c 69 63 61 74 69 6f |....\<Ap|plicatio|
|000009e0| 6e 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |n.......|........|
|000009f0| 01 00 00 00 05 41 4c 54 | 2b 41 00 00 00 00 00 00 |.....ALT|+A......|
|00000a00| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000a10| 00 01 00 00 00 01 20 00 | 00 00 00 00 00 00 00 00 |...... .|........|
|00000a20| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000a30| 00 00 01 00 00 00 0a 41 | 70 70 6c 69 63 61 74 69 |.......A|pplicati|
|00000a40| 6f 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |o.......|........|
|00000a50| 00 00 00 01 00 00 00 05 | 5c 3c 54 6f 70 00 00 00 |........|\<Top...|
|00000a60| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000a70| 00 00 00 00 01 00 00 00 | 02 46 32 00 00 00 00 00 |........|.F2.....|
|00000a80| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000a90| 00 00 00 00 00 01 00 00 | 00 02 46 32 00 00 00 00 |........|..F2....|
|00000aa0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000ab0| 00 00 00 00 00 00 01 00 | 00 00 10 73 6b 69 70 76 |........|...skipv|
|00000ac0| 61 72 20 6f 72 20 62 6f | 66 28 29 00 00 00 00 00 |ar or bo|f().....|
|00000ad0| 00 00 00 00 00 00 00 01 | 00 00 00 2e 47 4f 54 4f |........|....GOTO|
|00000ae0| 20 54 4f 50 0d 0a 41 43 | 54 49 56 41 54 45 20 57 | TOP..AC|TIVATE W|
|00000af0| 49 4e 44 4f 57 20 61 70 | 70 63 74 72 6c 0d 0a 53 |INDOW ap|pctrl..S|
|00000b00| 48 4f 57 20 47 45 54 53 | 0d 0a 00 00 00 00 00 00 |HOW GETS|........|
|00000b10| 00 00 00 00 00 00 00 00 | 00 01 00 00 00 08 5c 3c |........|......\<|
|00000b20| 42 6f 74 74 6f 6d 00 00 | 00 00 00 00 00 00 00 00 |Bottom..|........|
|00000b30| 00 00 00 00 00 00 00 00 | 00 00 01 00 00 00 02 46 |........|.......F|
|00000b40| 33 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |3.......|........|
|00000b50| 00 00 00 00 00 00 00 00 | 00 00 00 01 00 00 00 02 |........|........|
|00000b60| 46 33 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |F3......|........|
|00000b70| 00 00 00 00 00 00 00 00 | 00 00 00 00 01 00 00 00 |........|........|
|00000b80| 10 73 6b 69 70 76 61 72 | 20 6f 72 20 65 6f 66 28 |.skipvar| or eof(|
|00000b90| 29 00 00 00 00 00 00 00 | 00 00 00 00 00 01 00 00 |).......|........|
|00000ba0| 00 18 47 4f 54 4f 20 42 | 4f 54 54 4f 4d 0d 0a 53 |..GOTO B|OTTOM..S|
|00000bb0| 48 4f 57 20 47 45 54 53 | 0d 0a 00 00 00 00 01 00 |HOW GETS|........|
|00000bc0| 00 00 06 5c 3c 4e 65 78 | 74 00 00 00 00 00 00 00 |...\<Nex|t.......|
|00000bd0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 01 |........|........|
|00000be0| 00 00 00 02 46 34 00 00 | 00 00 00 00 00 00 00 00 |....F4..|........|
|00000bf0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000c00| 01 00 00 00 02 46 34 00 | 00 00 00 00 00 00 00 00 |.....F4.|........|
|00000c10| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000c20| 00 01 00 00 00 10 73 6b | 69 70 76 61 72 20 6f 72 |......sk|ipvar or|
|00000c30| 20 65 6f 66 28 29 00 00 | 00 00 00 00 00 00 00 00 | eof()..|........|
|00000c40| 00 00 01 00 00 00 5a 53 | 4b 49 50 0d 0a 49 46 20 |......ZS|KIP..IF |
|00000c50| 45 4f 46 28 29 0d 0a 20 | 20 20 57 41 49 54 20 57 |EOF().. | WAIT W|
|00000c60| 49 4e 44 4f 57 20 22 42 | 6f 74 74 6f 6d 20 6f 66 |INDOW "B|ottom of|
|00000c70| 20 66 69 6c 65 22 20 4e | 4f 57 41 49 54 0d 0a 20 | file" N|OWAIT.. |
|00000c80| 20 20 47 4f 54 4f 20 42 | 4f 54 54 4f 4d 0d 0a 45 | GOTO B|OTTOM..E|
|00000c90| 4e 44 49 46 0d 0a 53 48 | 4f 57 20 47 45 54 53 0d |NDIF..SH|OW GETS.|
|00000ca0| 0a 00 00 00 00 01 00 00 | 00 07 5c 3c 50 72 69 6f |........|..\<Prio|
|00000cb0| 72 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |r.......|........|
|00000cc0| 00 00 00 00 00 00 01 00 | 00 00 02 46 35 00 00 00 |........|...F5...|
|00000cd0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000ce0| 00 00 00 00 00 00 00 01 | 00 00 00 02 46 35 00 00 |........|....F5..|
|00000cf0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000d00| 00 00 00 00 00 00 00 00 | 01 00 00 00 10 73 6b 69 |........|.....ski|
|00000d10| 70 76 61 72 20 6f 72 20 | 62 6f 66 28 29 00 00 00 |pvar or |bof()...|
|00000d20| 00 00 00 00 00 00 00 00 | 00 01 00 00 00 57 53 4b |........|.....WSK|
|00000d30| 49 50 20 2d 31 0d 0a 49 | 46 20 42 4f 46 28 29 0d |IP -1..I|F BOF().|
|00000d40| 0a 20 20 20 57 41 49 54 | 20 57 49 4e 44 4f 57 20 |. WAIT| WINDOW |
|00000d50| 22 54 6f 70 20 6f 66 20 | 66 69 6c 65 22 20 4e 4f |"Top of |file" NO|
|00000d60| 57 41 49 54 0d 0a 20 20 | 20 47 4f 54 4f 20 54 4f |WAIT.. | GOTO TO|
|00000d70| 50 0d 0a 45 4e 44 49 46 | 0d 0a 53 48 4f 57 20 47 |P..ENDIF|..SHOW G|
|00000d80| 45 54 53 0d 0a 00 00 00 | 00 00 00 00 01 00 00 00 |ETS.....|........|
|00000d90| 07 43 5c 3c 79 63 6c 65 | 00 00 00 00 00 00 00 00 |.C\<ycle|........|
|00000da0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 01 00 00 |........|........|
|00000db0| 00 07 43 54 52 4c 2b 46 | 31 00 00 00 00 00 00 00 |..CTRL+F|1.......|
|00000dc0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 01 00 |........|........|
|00000dd0| 00 00 07 43 74 72 6c 2b | 46 31 00 00 00 00 00 00 |...Ctrl+|F1......|
|00000de0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 01 |........|........|
|00000df0| 00 00 00 0a 5f 4d 57 49 | 5f 52 4f 54 41 54 0d 0a |...._MWI|_ROTAT..|
|00000e00| 55 53 45 0d 0a 0d 0a 49 | 46 20 6d 2e 66 00 00 00 |USE....I|F m.f...|
|00000e10| 01 00 00 00 02 5c 2d 72 | 78 31 30 32 72 65 70 6f |.....\-r|x102repo|
|00000e20| 0d 0a 20 20 20 2a 20 42 | 61 63 6b 20 75 70 00 00 |.. * B|ack up..|
|00000e30| 00 01 00 00 00 0c 5c 3c | 41 64 64 20 52 65 63 6f |......\<|Add Reco|
|00000e40| 72 64 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |rd......|........|
|00000e50| 00 00 01 00 00 00 06 43 | 54 52 4c 2b 4e 00 00 00 |.......C|TRL+N...|
|00000e60| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000e70| 00 00 00 01 00 00 00 06 | 43 74 72 6c 2b 4e 00 00 |........|Ctrl+N..|
|00000e80| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000e90| 00 00 00 00 01 00 00 00 | 07 73 6b 69 70 76 61 72 |........|.skipvar|
|00000ea0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000eb0| 00 00 00 00 00 01 00 00 | 09 78 2a 20 41 64 64 20 |........|.x* Add |
|00000ec0| 61 20 72 65 63 6f 72 64 | 20 74 6f 20 74 68 65 20 |a record| to the |
|00000ed0| 63 75 72 72 65 6e 74 20 | 64 61 74 61 62 61 73 65 |current |database|
|00000ee0| 0d 0a 45 58 54 45 52 4e | 41 4c 20 41 52 52 41 59 |..EXTERN|AL ARRAY|
|00000ef0| 20 64 62 66 6c 69 73 74 | 0d 0a 0d 0a 50 52 49 56 | dbflist|....PRIV|
|00000f00| 41 54 45 20 61 6c 6c 62 | 6c 61 6e 6b 2c 20 69 2c |ATE allb|lank, i,|
|00000f10| 20 66 6c 64 6e 61 6d 65 | 2c 20 73 6e 61 6d 65 2c | fldname|, sname,|
|00000f20| 20 63 5f 72 65 63 0d 0a | 0d 0a 49 46 20 28 6d 2e | c_rec..|..IF (m.|
|00000f30| 6e 65 78 74 64 62 66 20 | 3c 3d 20 32 29 20 4f 52 |nextdbf |<= 2) OR|
|00000f40| 20 28 41 4c 49 41 53 28 | 29 20 3d 20 64 62 66 6c | (ALIAS(|) = dbfl|
|00000f50| 69 73 74 5b 31 2c 6d 2e | 63 73 74 65 6d 6e 75 6d |ist[1,m.|cstemnum|
|00000f60| 5d 29 0d 0a 20 20 20 2a | 20 41 70 70 65 6e 64 69 |]).. *| Appendi|
|00000f70| 6e 67 20 69 6e 74 6f 20 | 6d 61 69 6e 20 64 61 74 |ng into |main dat|
|00000f80| 61 62 61 73 65 0d 0a 0d | 0a 20 20 20 2a 20 41 6c |abase...|. * Al|
|00000f90| 77 61 79 73 20 61 6c 6c | 6f 77 20 74 68 69 73 20 |ways all|ow this |
|00000fa0| 69 66 20 74 68 65 72 65 | 20 61 72 65 20 6e 6f 20 |if there| are no |
|00000fb0| 72 65 63 6f 72 64 73 3b | 20 6f 74 68 65 72 77 69 |records;| otherwi|
|00000fc0| 73 65 20 63 68 65 63 6b | 20 66 6f 72 20 65 78 69 |se check| for exi|
|00000fd0| 73 74 69 6e 67 0d 0a 20 | 20 20 2a 20 62 6c 61 6e |sting.. | * blan|
|00000fe0| 6b 20 72 65 63 6f 72 64 | 73 2e 0d 0a 20 20 20 61 |k record|s... a|
|00000ff0| 6c 6c 62 6c 61 6e 6b 20 | 3d 20 2e 46 2e 0d 0a 20 |llblank |= .F... |
|00001000| 20 20 49 46 20 52 45 43 | 43 4f 55 4e 54 28 29 20 | IF REC|COUNT() |
|00001010| 3e 20 30 0d 0a 20 20 20 | 20 20 20 73 6e 61 6d 65 |> 0.. | sname|
|00001020| 20 3d 20 6a 75 73 74 73 | 74 65 6d 28 6d 2e 64 62 | = justs|tem(m.db|
|00001030| 66 6e 61 6d 65 29 0d 0a | 20 20 20 20 20 20 53 45 |fname)..| SE|
|00001040| 4c 45 43 54 20 26 73 6e | 61 6d 65 0d 0a 20 20 20 |LECT &sn|ame.. |
|00001050| 20 20 20 47 4f 54 4f 20 | 54 4f 50 0d 0a 0d 0a 20 | GOTO |TOP.... |
|00001060| 20 20 20 20 20 44 4f 20 | 57 48 49 4c 45 20 44 45 | DO |WHILE DE|
|00001070| 4c 45 54 45 44 28 29 20 | 41 4e 44 20 21 45 4f 46 |LETED() |AND !EOF|
|00001080| 28 29 0d 0a 20 20 20 20 | 20 20 20 20 20 53 4b 49 |().. | SKI|
|00001090| 50 0d 0a 20 20 20 20 20 | 20 45 4e 44 44 4f 0d 0a |P.. | ENDDO..|
|000010a0| 20 20 20 20 20 20 49 46 | 20 45 4f 46 28 29 20 20 | IF| EOF() |
|000010b0| 20 26 26 20 61 6c 6c 20 | 72 65 63 6f 72 64 73 20 | && all |records |
|000010c0| 61 70 70 65 61 72 20 74 | 6f 20 62 65 20 64 65 6c |appear t|o be del|
|000010d0| 65 74 65 64 0d 0a 20 20 | 20 20 20 20 20 20 20 47 |eted.. | G|
|000010e0| 4f 54 4f 20 54 4f 50 0d | 0a 20 20 20 20 20 20 45 |OTO TOP.|. E|
|000010f0| 4e 44 49 46 0d 0a 0d 0a | 20 20 20 20 20 20 3d 61 |NDIF....| =a|
|00001100| 63 74 77 69 6e 28 6d 2e | 77 69 6e 5f 6e 61 6d 65 |ctwin(m.|win_name|
|00001110| 29 0d 0a 0d 0a 20 20 20 | 20 20 20 6d 2e 61 6c 6c |).... | m.all|
|00001120| 62 6c 61 6e 6b 20 3d 20 | 2e 54 2e 0d 0a 20 20 20 |blank = |.T... |
|00001130| 20 20 20 46 4f 52 20 69 | 20 3d 20 31 20 54 4f 20 | FOR i| = 1 TO |
|00001140| 46 43 4f 55 4e 54 28 29 | 0d 0a 20 20 20 20 20 20 |FCOUNT()|.. |
|00001150| 20 20 20 6d 2e 66 6c 64 | 6e 61 6d 65 20 3d 20 46 | m.fld|name = F|
|00001160| 49 45 4c 44 28 69 29 0d | 0a 20 20 20 20 20 20 20 |IELD(i).|. |
|00001170| 20 20 49 46 20 21 45 4d | 50 54 59 28 26 66 6c 64 | IF !EM|PTY(&fld|
|00001180| 6e 61 6d 65 29 0d 0a 20 | 20 20 20 20 20 20 20 20 |name).. | |
|00001190| 20 20 20 6d 2e 61 6c 6c | 62 6c 61 6e 6b 20 3d 20 | m.all|blank = |
|000011a0| 2e 46 2e 0d 0a 20 20 20 | 20 20 20 20 20 20 45 4e |.F... | EN|
|000011b0| 44 49 46 0d 0a 20 20 20 | 20 20 20 45 4e 44 46 4f |DIF.. | ENDFO|
|000011c0| 52 0d 0a 0d 0a 20 20 20 | 20 20 20 2a 20 4d 61 6b |R.... | * Mak|
|000011d0| 65 20 73 75 72 65 20 61 | 6c 6c 20 72 65 63 6f 72 |e sure a|ll recor|
|000011e0| 64 73 20 61 72 65 6e 27 | 74 20 64 65 6c 65 74 65 |ds aren'|t delete|
|000011f0| 64 0d 0a 20 20 20 20 20 | 20 49 46 20 6d 2e 61 6c |d.. | IF m.al|
|00001200| 6c 62 6c 61 6e 6b 0d 0a | 20 20 20 20 20 20 20 20 |lblank..| |
|00001210| 20 49 46 20 52 45 43 43 | 4f 55 4e 54 28 29 20 3c | IF RECC|OUNT() <|
|00001220| 20 31 30 20 20 20 26 26 | 20 6a 75 73 74 20 61 20 | 10 &&| just a |
|00001230| 72 75 6c 65 20 6f 66 20 | 74 68 75 6d 62 0d 0a 20 |rule of |thumb.. |
|00001240| 20 20 20 20 20 20 20 20 | 20 20 20 43 4f 55 4e 54 | | COUNT|
|00001250| 20 46 4f 52 20 21 44 45 | 4c 45 54 45 44 28 29 20 | FOR !DE|LETED() |
|00001260| 54 4f 20 6e 6f 74 64 65 | 6c 0d 0a 20 20 20 20 20 |TO notde|l.. |
|00001270| 20 20 20 20 20 20 20 47 | 4f 54 4f 20 54 4f 50 0d | G|OTO TOP.|
|00001280| 0a 20 20 20 20 20 20 20 | 20 20 20 20 20 49 46 20 |. | IF |
|00001290| 6d 2e 6e 6f 74 64 65 6c | 20 3d 20 30 0d 0a 20 20 |m.notdel| = 0.. |
|000012a0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 6d 2e 61 | | m.a|
|000012b0| 6c 6c 62 6c 61 6e 6b 20 | 3d 20 2e 46 2e 0d 0a 20 |llblank |= .F... |
|000012c0| 20 20 20 20 20 20 20 20 | 20 20 20 45 4e 44 49 46 | | ENDIF|
|000012d0| 0d 0a 20 20 20 20 20 20 | 20 20 20 45 4e 44 49 46 |.. | ENDIF|
|000012e0| 0d 0a 20 20 20 20 20 20 | 45 4e 44 49 46 0d 0a 20 |.. |ENDIF.. |
|000012f0| 20 20 45 4e 44 49 46 0d | 0a 0d 0a 20 20 20 49 46 | ENDIF.|... IF|
|00001300| 20 21 6d 2e 61 6c 6c 62 | 6c 61 6e 6b 0d 0a 20 20 | !m.allb|lank.. |
|00001310| 20 20 20 20 41 50 50 45 | 4e 44 20 42 4c 41 4e 4b | APPE|ND BLANK|
|00001320| 0d 0a 20 20 20 20 20 20 | 53 48 4f 57 20 47 45 54 |.. |SHOW GET|
|00001330| 53 0d 0a 20 20 20 45 4e | 44 49 46 0d 0a 0d 0a 20 |S.. EN|DIF.... |
|00001340| 20 20 5f 43 55 52 4f 42 | 4a 20 3d 20 31 0d 0a 0d | _CUROB|J = 1...|
|00001350| 0a 20 20 20 3d 61 63 74 | 77 69 6e 28 6d 2e 77 69 |. =act|win(m.wi|
|00001360| 6e 5f 6e 61 6d 65 29 0d | 0a 0d 0a 45 4c 53 45 20 |n_name).|...ELSE |
|00001370| 20 20 26 26 20 61 70 70 | 65 6e 64 69 6e 67 20 72 | && app|ending r|
|00001380| 65 63 6f 72 64 20 69 6e | 74 6f 20 61 20 63 68 69 |ecord in|to a chi|
|00001390| 6c 64 20 62 72 6f 77 73 | 65 0d 0a 20 20 20 2a 20 |ld brows|e.. * |
|000013a0| 46 69 6c 6c 20 69 6e 20 | 74 68 65 20 6b 65 79 20 |Fill in |the key |
|000013b0| 66 69 65 6c 64 73 2e 20 | 20 46 69 72 73 74 20 66 |fields. | First f|
|000013c0| 69 6e 64 20 74 68 65 20 | 64 62 66 6c 69 73 74 20 |ind the |dbflist |
|000013d0| 72 65 63 6f 72 64 20 66 | 6f 72 20 74 68 69 73 20 |record f|or this |
|000013e0| 0d 0a 20 20 20 2a 20 64 | 61 74 61 62 61 73 65 2e |.. * d|atabase.|
|000013f0| 0d 0a 20 20 20 69 20 3d | 20 31 0d 0a 20 20 20 67 |.. i =| 1.. g|
|00001400| 6f 74 5f 69 74 20 3d 20 | 2e 46 2e 0d 0a 20 20 20 |ot_it = |.F... |
|00001410| 44 4f 20 57 48 49 4c 45 | 20 69 20 3c 3d 20 6d 2e |DO WHILE| i <= m.|
|00001420| 6e 75 6d 61 72 65 61 73 | 20 41 4e 44 20 21 67 6f |numareas| AND !go|
|00001430| 74 5f 69 74 0d 0a 20 20 | 20 20 20 20 49 46 20 55 |t_it.. | IF U|
|00001440| 50 50 45 52 28 64 62 66 | 6c 69 73 74 5b 69 2c 6d |PPER(dbf|list[i,m|
|00001450| 2e 63 73 74 65 6d 6e 75 | 6d 5d 29 20 3d 3d 20 41 |.cstemnu|m]) == A|
|00001460| 4c 49 41 53 28 29 0d 0a | 20 20 20 20 20 20 20 20 |LIAS()..| |
|00001470| 20 67 6f 74 5f 69 74 20 | 3d 20 2e 54 2e 0d 0a 20 | got_it |= .T... |
|00001480| 20 20 20 20 20 45 4c 53 | 45 0d 0a 20 20 20 20 20 | ELS|E.. |
|00001490| 20 20 20 20 69 20 3d 20 | 69 20 2b 20 31 0d 0a 20 | i = |i + 1.. |
|000014a0| 20 20 20 20 20 45 4e 44 | 49 46 0d 0a 20 20 20 45 | END|IF.. E|
|000014b0| 4e 44 44 4f 0d 0a 20 20 | 20 2a 20 49 66 20 77 65 |NDDO.. | * If we|
|000014c0| 20 66 6f 75 6e 64 20 74 | 68 65 20 63 75 72 72 65 | found t|he curre|
|000014d0| 6e 74 20 64 61 74 61 62 | 61 73 65 2c 20 66 69 67 |nt datab|ase, fig|
|000014e0| 75 72 65 20 6f 75 74 20 | 77 68 61 74 20 74 68 65 |ure out |what the|
|000014f0| 20 70 61 72 65 6e 74 20 | 64 61 74 61 62 61 73 65 | parent |database|
|00001500| 20 0d 0a 20 20 20 2a 20 | 69 73 20 61 6e 64 20 6d | .. * |is and m|
|00001510| 61 6b 65 20 73 75 72 65 | 20 74 68 61 74 20 74 68 |ake sure| that th|
|00001520| 65 20 70 61 72 65 6e 74 | 20 69 73 20 6e 6f 74 20 |e parent| is not |
|00001530| 61 74 20 45 4f 46 28 29 | 2e 0d 0a 20 20 20 49 46 |at EOF()|... IF|
|00001540| 20 21 45 4f 46 28 64 62 | 66 6c 69 73 74 5b 6d 2e | !EOF(db|flist[m.|
|00001550| 69 2c 6d 2e 70 64 62 66 | 6e 75 6d 5d 29 0d 0a 09 |i,m.pdbf|num])...|
|00001560| 20 20 20 2a 20 41 6c 73 | 6f 20 64 65 74 65 72 6d | * Als|o determ|
|00001570| 69 6e 65 20 77 68 61 74 | 20 69 74 73 20 6b 65 79 |ine what| its key|
|00001580| 20 66 69 65 6c 64 20 69 | 73 20 61 6e 64 20 6d 61 | field i|s and ma|
|00001590| 6b 65 20 69 74 20 64 65 | 66 61 75 6c 74 0d 0a 09 |ke it de|fault...|
|000015a0| 20 20 20 2a 20 74 6f 20 | 74 68 65 20 63 6f 72 72 | * to |the corr|
|000015b0| 65 73 70 6f 6e 64 69 6e | 67 20 76 61 6c 75 65 20 |espondin|g value |
|000015c0| 69 6e 20 74 68 65 20 70 | 61 72 65 6e 74 20 64 61 |in the p|arent da|
|000015d0| 74 61 62 61 73 65 2e 20 | 20 46 6f 72 20 0d 0a 09 |tabase. | For ...|
|000015e0| 20 20 20 2a 20 65 78 61 | 6d 70 6c 65 2c 20 69 66 | * exa|mple, if|
|000015f0| 20 74 68 65 20 63 75 72 | 72 65 6e 74 20 64 61 74 | the cur|rent dat|
|00001600| 61 62 61 73 65 20 69 73 | 20 61 6e 20 69 6e 76 6f |abase is| an invo|
|00001610| 69 63 65 20 66 69 6c 65 | 2c 20 6d 61 6b 65 20 74 |ice file|, make t|
|00001620| 68 65 0d 0a 09 20 20 20 | 2a 20 63 75 73 74 6f 6d |he... |* custom|
|00001630| 65 72 20 6e 75 6d 62 65 | 72 20 64 65 66 61 75 6c |er numbe|r defaul|
|00001640| 74 20 74 6f 20 74 68 65 | 20 63 75 73 74 6f 6d 65 |t to the| custome|
|00001650| 72 20 6e 75 6d 62 65 72 | 20 6f 66 20 74 68 65 20 |r number| of the |
|00001660| 63 75 72 72 65 6e 74 0d | 0a 09 20 20 20 2a 20 72 |current.|.. * r|
|00001670| 65 63 6f 72 64 20 69 6e | 20 74 68 65 20 63 75 73 |ecord in| the cus|
|00001680| 74 6f 6d 65 72 20 66 69 | 6c 65 2e 0d 0a 09 20 20 |tomer fi|le.... |
|00001690| 20 41 50 50 45 4e 44 20 | 42 4c 41 4e 4b 0d 0a 09 | APPEND |BLANK...|
|000016a0| 20 20 20 49 46 20 67 6f | 74 5f 69 74 0d 0a 09 20 | IF go|t_it... |
|000016b0| 20 20 20 20 20 2a 20 64 | 62 66 6c 69 73 74 5b 6d | * d|bflist[m|
|000016c0| 2e 69 2c 6d 2e 63 66 6c | 64 6e 75 6d 5d 20 6c 6f |.i,m.cfl|dnum] lo|
|000016d0| 6f 6b 73 20 6c 69 6b 65 | 20 22 44 45 54 41 49 4c |oks like| "DETAIL|
|000016e0| 2e 49 4e 4f 22 0d 0a 09 | 20 20 20 20 20 20 63 68 |.INO"...| ch|
|000016f0| 69 6c 64 66 6c 64 20 20 | 3d 20 64 62 66 6c 69 73 |ildfld |= dbflis|
|00001700| 74 5b 6d 2e 69 2c 6d 2e | 63 66 6c 64 6e 75 6d 5d |t[m.i,m.|cfldnum]|
|00001710| 0d 0a 09 20 20 20 20 20 | 20 70 61 72 65 6e 74 66 |... | parentf|
|00001720| 6c 64 20 3d 20 64 62 66 | 6c 69 73 74 5b 6d 2e 69 |ld = dbf|list[m.i|
|00001730| 2c 6d 2e 70 66 6c 64 6e | 75 6d 5d 0d 0a 0d 0a 09 |,m.pfldn|um].....|
|00001740| 20 20 20 20 20 20 2a 20 | 52 65 70 6c 61 63 65 20 | * |Replace |
|00001750| 74 68 65 20 6b 65 79 20 | 66 69 65 6c 64 20 69 6e |the key |field in|
|00001760| 74 6f 20 74 68 65 20 6e | 65 77 6c 79 20 61 70 70 |to the n|ewly app|
|00001770| 65 6e 64 65 64 20 72 65 | 63 6f 72 64 0d 0a 09 20 |ended re|cord... |
|00001780| 20 20 20 20 20 52 45 50 | 4c 41 43 45 20 26 63 68 | REP|LACE &ch|
|00001790| 69 6c 64 66 6c 64 20 57 | 49 54 48 20 26 70 61 72 |ildfld W|ITH &par|
|000017a0| 65 6e 74 66 6c 64 0d 0a | 09 20 20 20 45 4e 44 49 |entfld..|. ENDI|
|000017b0| 46 0d 0a 09 45 4c 53 45 | 0d 0a 09 20 20 20 57 41 |F...ELSE|... WA|
|000017c0| 49 54 20 57 49 4e 44 4f | 57 20 22 59 6f 75 20 63 |IT WINDO|W "You c|
|000017d0| 61 6e 6e 6f 74 20 61 64 | 64 20 61 20 63 68 69 6c |annot ad|d a chil|
|000017e0| 64 20 72 65 63 6f 72 64 | 20 69 66 20 74 68 65 72 |d record| if ther|
|000017f0| 65 20 69 73 20 6e 6f 20 | 70 61 72 65 6e 74 2e 22 |e is no |parent."|
|00001800| 20 0d 0a 09 45 4e 44 49 | 46 0d 0a 09 53 48 4f 57 | ...ENDI|F...SHOW|
|00001810| 20 57 49 4e 44 4f 57 20 | 28 41 4c 49 41 53 28 29 | WINDOW |(ALIAS()|
|00001820| 29 20 52 45 46 52 45 53 | 48 0d 0a 45 4e 44 49 46 |) REFRES|H..ENDIF|
|00001830| 0d 0a 00 00 00 00 00 00 | 00 00 00 00 00 00 00 01 |........|........|
|00001840| 00 00 00 0d 5c 3c 43 6f | 70 79 20 52 65 63 6f 72 |....\<Co|py Recor|
|00001850| 64 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |d.......|........|
|00001860| 01 00 00 00 07 73 6b 69 | 70 76 61 72 00 00 00 00 |.....ski|pvar....|
|00001870| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001880| 00 01 00 00 00 d6 53 43 | 41 54 54 45 52 20 4d 45 |......SC|ATTER ME|
|00001890| 4d 56 41 52 0d 0a 41 50 | 50 45 4e 44 20 42 4c 41 |MVAR..AP|PEND BLA|
|000018a0| 4e 4b 0d 0a 47 41 54 48 | 45 52 20 4d 45 4d 56 41 |NK..GATH|ER MEMVA|
|000018b0| 52 0d 0a 49 46 20 54 59 | 50 45 28 22 44 42 46 4c |R..IF TY|PE("DBFL|
|000018c0| 49 53 54 22 29 20 3d 20 | 22 55 22 20 4f 52 20 41 |IST") = |"U" OR A|
|000018d0| 4c 49 41 53 28 29 20 3d | 3d 20 55 50 50 45 52 28 |LIAS() =|= UPPER(|
|000018e0| 64 62 66 6c 69 73 74 5b | 31 2c 6d 2e 63 73 74 65 |dbflist[|1,m.cste|
|000018f0| 6d 6e 75 6d 5d 29 0d 0a | 20 20 20 53 48 4f 57 20 |mnum])..| SHOW |
|00001900| 47 45 54 53 0d 0a 20 20 | 20 3d 61 63 74 77 69 6e |GETS.. | =actwin|
|00001910| 28 6d 2e 77 69 6e 5f 6e | 61 6d 65 29 20 20 20 26 |(m.win_n|ame) &|
|00001920| 26 20 61 63 74 69 76 61 | 74 65 20 75 73 65 72 20 |& activa|te user |
|00001930| 77 69 6e 64 6f 77 0d 0a | 45 4e 44 49 46 0d 0a 53 |window..|ENDIF..S|
|00001940| 48 4f 57 20 57 49 4e 44 | 4f 57 20 28 41 4c 49 41 |HOW WIND|OW (ALIA|
|00001950| 53 28 29 29 20 52 45 46 | 52 45 53 48 00 00 00 00 |S()) REF|RESH....|
|00001960| 00 00 00 00 00 00 00 00 | 01 00 00 00 0f 5c 3c 44 |........|.....\<D|
|00001970| 65 6c 65 74 65 20 52 65 | 63 6f 72 64 00 00 00 00 |elete Re|cord....|
|00001980| 00 00 00 00 00 00 00 00 | 00 01 00 00 00 06 43 54 |........|......CT|
|00001990| 52 4c 2b 44 00 00 00 00 | 00 00 00 00 00 00 00 00 |RL+D....|........|
|000019a0| 00 00 00 00 00 00 00 00 | 00 00 01 00 00 00 06 43 |........|.......C|
|000019b0| 74 72 6c 2b 44 00 00 00 | 00 00 00 00 00 00 00 00 |trl+D...|........|
|000019c0| 00 00 00 00 00 00 00 00 | 00 00 00 01 00 00 00 07 |........|........|
|000019d0| 73 6b 69 70 76 61 72 00 | 00 00 00 00 00 00 00 00 |skipvar.|........|
|000019e0| 00 00 00 00 00 00 00 00 | 00 00 00 00 01 00 00 02 |........|........|
|000019f0| 8c 2a 20 44 65 6c 65 74 | 65 20 74 68 69 73 20 72 |.* Delet|e this r|
|00001a00| 65 63 6f 72 64 20 28 61 | 6e 64 20 61 6e 79 20 63 |ecord (a|nd any c|
|00001a10| 68 69 6c 64 72 65 6e 20 | 66 6f 72 20 77 68 69 63 |hildren |for whic|
|00001a20| 68 20 74 68 65 20 63 61 | 73 63 61 64 69 6e 67 0d |h the ca|scading.|
|00001a30| 0a 2a 20 64 65 6c 65 74 | 65 20 6f 70 74 69 6f 6e |.* delet|e option|
|00001a40| 20 69 73 20 73 65 74 29 | 20 66 72 6f 6d 20 74 68 | is set)| from th|
|00001a50| 65 20 63 75 72 72 65 6e | 74 20 64 61 74 61 62 61 |e curren|t databa|
|00001a60| 73 65 2e 0d 0a 49 46 20 | 52 45 43 43 4f 55 4e 54 |se...IF |RECCOUNT|
|00001a70| 28 29 20 3e 20 30 0d 0a | 0d 0a 20 20 20 57 41 49 |() > 0..|.. WAI|
|00001a80| 54 20 57 49 4e 44 4f 57 | 20 22 44 65 6c 65 74 69 |T WINDOW| "Deleti|
|00001a90| 6e 67 2d 2d 50 6c 65 61 | 73 65 20 77 61 69 74 2e |ng--Plea|se wait.|
|00001aa0| 22 20 4e 4f 57 41 49 54 | 0d 0a 20 20 20 0d 0a 20 |" NOWAIT|.. .. |
|00001ab0| 20 20 2a 20 50 65 72 66 | 6f 72 6d 20 61 6e 79 20 | * Perf|orm any |
|00001ac0| 6e 65 63 65 73 73 61 72 | 79 20 63 61 73 63 61 64 |necessar|y cascad|
|00001ad0| 69 6e 67 20 64 65 6c 65 | 74 65 73 20 0d 0a 20 20 |ing dele|tes .. |
|00001ae0| 20 49 46 20 6d 2e 6e 65 | 78 74 64 62 66 20 3e 20 | IF m.ne|xtdbf > |
|00001af0| 31 0d 0a 20 20 20 20 20 | 20 44 4f 20 43 61 73 63 |1.. | DO Casc|
|00001b00| 61 64 65 20 57 49 54 48 | 20 41 4c 49 41 53 28 29 |ade WITH| ALIAS()|
|00001b10| 2c 20 22 44 45 4c 45 54 | 45 22 0d 0a 20 20 20 45 |, "DELET|E".. E|
|00001b20| 4e 44 49 46 0d 0a 20 20 | 20 0d 0a 20 20 20 44 45 |NDIF.. | .. DE|
|00001b30| 4c 45 54 45 0d 0a 0d 0a | 20 20 20 2a 20 4d 6f 76 |LETE....| * Mov|
|00001b40| 69 6e 67 20 6f 66 66 20 | 74 68 65 20 64 65 6c 65 |ing off |the dele|
|00001b50| 74 65 64 20 72 65 63 6f | 72 64 20 69 66 20 77 65 |ted reco|rd if we|
|00001b60| 20 61 72 65 20 69 6e 20 | 74 68 65 20 6d 61 69 6e | are in |the main|
|00001b70| 20 73 63 72 65 65 6e 0d | 0a 20 20 20 49 46 20 54 | screen.|. IF T|
|00001b80| 59 50 45 28 22 44 42 46 | 4c 49 53 54 22 29 20 3d |YPE("DBF|LIST") =|
|00001b90| 20 22 55 22 20 4f 52 20 | 41 4c 49 41 53 28 29 20 | "U" OR |ALIAS() |
|00001ba0| 3d 20 64 62 66 6c 69 73 | 74 5b 31 2c 6d 2e 63 73 |= dbflis|t[1,m.cs|
|00001bb0| 74 65 6d 6e 75 6d 5d 0d | 0a 20 20 20 20 20 20 49 |temnum].|. I|
|00001bc0| 46 20 21 45 4f 46 28 29 | 0d 0a 20 20 20 20 20 20 |F !EOF()|.. |
|00001bd0| 20 20 20 53 4b 49 50 0d | 0a 20 20 20 20 20 20 45 | SKIP.|. E|
|00001be0| 4e 44 49 46 0d 0a 20 20 | 20 20 20 20 49 46 20 45 |NDIF.. | IF E|
|00001bf0| 4f 46 28 29 0d 0a 20 20 | 20 20 20 20 20 20 20 47 |OF().. | G|
|00001c00| 4f 54 4f 20 54 4f 50 0d | 0a 20 20 20 20 20 20 45 |OTO TOP.|. E|
|00001c10| 4e 44 49 46 0d 0a 20 20 | 20 20 20 20 53 48 4f 57 |NDIF.. | SHOW|
|00001c20| 20 47 45 54 53 0d 0a 20 | 20 20 45 4c 53 45 0d 0a | GETS.. | ELSE..|
|00001c30| 20 20 20 20 20 20 53 48 | 4f 57 20 57 49 4e 44 4f | SH|OW WINDO|
|00001c40| 57 20 28 41 4c 49 41 53 | 28 29 29 20 52 45 46 52 |W (ALIAS|()) REFR|
|00001c50| 45 53 48 0d 0a 20 20 20 | 45 4e 44 49 46 0d 0a 20 |ESH.. |ENDIF.. |
|00001c60| 20 20 20 20 20 0d 0a 20 | 20 20 57 41 49 54 20 43 | .. | WAIT C|
|00001c70| 4c 45 41 52 0d 0a 45 4e | 44 49 46 0d 0a 00 00 00 |LEAR..EN|DIF.....|
|00001c80| 01 00 00 00 02 5c 2d 00 | 00 00 00 00 00 00 00 00 |.....\-.|........|
|00001c90| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001ca0| 00 01 00 00 00 08 42 72 | 6f 5c 3c 77 73 65 00 00 |......Br|o\<wse..|
|00001cb0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001cc0| 00 00 01 00 00 00 06 43 | 54 52 4c 2b 42 00 00 00 |.......C|TRL+B...|
|00001cd0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001ce0| 00 00 00 01 00 00 00 06 | 43 74 72 6c 2b 42 00 00 |........|Ctrl+B..|
|00001cf0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001d00| 00 00 00 00 01 00 00 00 | 07 73 6b 69 70 76 61 72 |........|.skipvar|
|00001d10| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001d20| 00 00 00 00 00 01 00 00 | 00 ef 6d 2e 73 6b 69 70 |........|..m.skip|
|00001d30| 76 61 72 20 3d 20 2e 54 | 2e 0d 0a 64 62 66 73 74 |var = .T|...dbfst|
|00001d40| 65 6d 20 3d 20 6a 75 73 | 74 73 74 65 6d 28 6d 2e |em = jus|tstem(m.|
|00001d50| 64 62 66 6e 61 6d 65 29 | 0d 0a 53 45 4c 45 43 54 |dbfname)|..SELECT|
|00001d60| 20 28 64 62 66 73 74 65 | 6d 29 0d 0a 4f 4e 20 4b | (dbfste|m)..ON K|
|00001d70| 45 59 20 4c 41 42 45 4c | 20 65 6e 74 65 72 20 4b |EY LABEL| enter K|
|00001d80| 45 59 42 4f 41 52 44 28 | 43 48 52 28 32 33 29 29 |EYBOARD(|CHR(23))|
|00001d90| 0d 0a 42 52 4f 57 53 45 | 20 4c 41 53 54 20 4e 4f |..BROWSE| LAST NO|
|00001da0| 52 4d 41 4c 20 4e 4f 41 | 50 50 45 4e 44 20 43 4f |RMAL NOA|PPEND CO|
|00001db0| 4c 4f 52 20 53 43 48 45 | 4d 45 20 31 30 0d 0a 4f |LOR SCHE|ME 10..O|
|00001dc0| 4e 20 4b 45 59 20 4c 41 | 42 45 4c 20 65 6e 74 65 |N KEY LA|BEL ente|
|00001dd0| 72 0d 0a 53 48 4f 57 20 | 4d 45 4e 55 20 5f 6d 73 |r..SHOW |MENU _ms|
|00001de0| 79 73 6d 65 6e 75 0d 0a | 6d 2e 73 6b 69 70 76 61 |ysmenu..|m.skipva|
|00001df0| 72 20 3d 20 2e 46 2e 0d | 0a 3d 61 63 74 77 69 6e |r = .F..|.=actwin|
|00001e00| 28 6d 2e 77 69 6e 5f 6e | 61 6d 65 29 0d 0a 53 48 |(m.win_n|ame)..SH|
|00001e10| 4f 57 20 47 45 54 53 0d | 0a 72 65 70 6f 0d 0a 20 |OW GETS.|.repo.. |
|00001e20| 20 20 2a 20 42 61 63 6b | 20 75 00 00 00 01 00 00 | * Back| u......|
|00001e30| 00 0b 5c 3c 53 65 61 72 | 63 68 2e 2e 2e 00 00 00 |..\<Sear|ch......|
|00001e40| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 01 00 |........|........|
|00001e50| 00 00 06 43 54 52 4c 2b | 53 00 00 00 00 00 00 00 |...CTRL+|S.......|
|00001e60| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 01 |........|........|
|00001e70| 00 00 00 06 43 74 72 6c | 2b 53 00 00 00 00 00 00 |....Ctrl|+S......|
|00001e80| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001e90| 01 00 00 00 07 73 6b 69 | 70 76 61 72 00 00 00 00 |.....ski|pvar....|
|00001ea0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001eb0| 00 01 00 00 00 94 64 62 | 66 73 74 65 6d 20 3d 20 |......db|fstem = |
|00001ec0| 6a 75 73 74 73 74 65 6d | 28 6d 2e 64 62 66 6e 61 |juststem|(m.dbfna|
|00001ed0| 6d 65 29 0d 0a 53 45 4c | 45 43 54 20 28 64 62 66 |me)..SEL|ECT (dbf|
|00001ee0| 73 74 65 6d 29 0d 0a 49 | 46 20 21 72 65 67 65 6e |stem)..I|F !regen|
|00001ef0| 0d 0a 20 20 20 6d 6e 61 | 6d 65 20 3d 20 27 61 70 |.. mna|me = 'ap|
|00001f00| 70 73 72 63 68 2e 70 72 | 67 27 0d 0a 45 4c 53 45 |psrch.pr|g'..ELSE|
|00001f10| 0d 0a 20 20 20 6d 6e 61 | 6d 65 20 3d 20 27 61 70 |.. mna|me = 'ap|
|00001f20| 70 73 72 63 68 2e 73 70 | 72 27 0d 0a 45 4e 44 49 |psrch.sp|r'..ENDI|
|00001f30| 46 0d 0a 44 4f 20 28 6d | 6e 61 6d 65 29 0d 0a 53 |F..DO (m|name)..S|
|00001f40| 48 4f 57 20 47 45 54 53 | 0d 0a 00 00 00 00 00 00 |HOW GETS|........|
|00001f50| 00 00 00 00 00 00 01 00 | 00 00 0b 5c 3c 46 69 6c |........|...\<Fil|
|00001f60| 74 65 72 2e 2e 2e 00 00 | 00 00 00 00 00 00 00 00 |ter.....|........|
|00001f70| 00 00 00 00 00 00 00 01 | 00 00 00 06 43 54 52 4c |........|....CTRL|
|00001f80| 2b 46 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |+F......|........|
|00001f90| 00 00 00 00 00 00 00 00 | 01 00 00 00 06 43 74 72 |........|.....Ctr|
|00001fa0| 6c 2b 46 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |l+F.....|........|
|00001fb0| 00 00 00 00 00 00 00 00 | 00 01 00 00 00 07 73 6b |........|......sk|
|00001fc0| 69 70 76 61 72 00 00 00 | 00 00 00 00 00 00 00 00 |ipvar...|........|
|00001fd0| 00 00 00 00 00 00 00 00 | 00 00 01 00 00 01 76 6d |........|......vm|
|00001fe0| 2e 6f 72 69 67 5f 72 65 | 63 20 3d 20 52 45 43 4e |.orig_re|c = RECN|
|00001ff0| 4f 28 29 0d 0a 47 45 54 | 45 58 50 52 20 27 46 69 |O()..GET|EXPR 'Fi|
|00002000| 6c 74 65 72 20 45 78 70 | 72 65 73 73 69 6f 6e 27 |lter Exp|ression'|
|00002010| 20 54 4f 20 66 69 6c 74 | 5f 65 78 70 72 20 54 59 | TO filt|_expr TY|
|00002020| 50 45 20 27 4c 27 20 44 | 45 46 41 55 4c 54 20 66 |PE 'L' D|EFAULT f|
|00002030| 69 6c 74 5f 65 78 70 72 | 0d 0a 49 46 20 21 45 4d |ilt_expr|..IF !EM|
|00002040| 50 54 59 28 6d 2e 66 69 | 6c 74 5f 65 78 70 72 29 |PTY(m.fi|lt_expr)|
|00002050| 0d 0a 20 20 20 53 45 54 | 20 46 49 4c 54 45 52 20 |.. SET| FILTER |
|00002060| 54 4f 20 26 66 69 6c 74 | 5f 65 78 70 72 0d 0a 20 |TO &filt|_expr.. |
|00002070| 20 20 47 4f 54 4f 20 54 | 4f 50 0d 0a 20 20 20 49 | GOTO T|OP.. I|
|00002080| 46 20 45 4f 46 28 29 0d | 0a 20 20 20 20 20 20 57 |F EOF().|. W|
|00002090| 41 49 54 20 57 49 4e 44 | 4f 57 20 22 4e 6f 20 72 |AIT WIND|OW "No r|
|000020a0| 65 63 6f 72 64 73 20 6d | 61 74 63 68 20 74 68 61 |ecords m|atch tha|
|000020b0| 74 20 66 69 6c 74 65 72 | 22 20 4e 4f 57 41 49 54 |t filter|" NOWAIT|
|000020c0| 0d 0a 20 20 20 20 20 20 | 53 45 54 20 46 49 4c 54 |.. |SET FILT|
|000020d0| 45 52 20 54 4f 0d 0a 20 | 20 20 20 20 20 49 46 20 |ER TO.. | IF |
|000020e0| 6d 2e 6f 72 69 67 5f 72 | 65 63 20 3c 3d 20 52 45 |m.orig_r|ec <= RE|
|000020f0| 43 43 4f 55 4e 54 28 29 | 0d 0a 20 20 20 20 20 20 |CCOUNT()|.. |
|00002100| 20 20 20 47 4f 54 4f 20 | 6d 2e 6f 72 69 67 5f 72 | GOTO |m.orig_r|
|00002110| 65 63 0d 0a 20 20 20 20 | 20 20 45 4e 44 49 46 0d |ec.. | ENDIF.|
|00002120| 0a 20 20 20 45 4e 44 49 | 46 0d 0a 45 4c 53 45 0d |. ENDI|F..ELSE.|
|00002130| 0a 20 20 20 53 45 54 20 | 46 49 4c 54 45 52 20 54 |. SET |FILTER T|
|00002140| 4f 0d 0a 45 4e 44 49 46 | 0d 0a 53 48 4f 57 20 47 |O..ENDIF|..SHOW G|
|00002150| 45 54 53 0d 0a 00 00 00 | 00 00 00 00 00 00 00 00 |ETS.....|........|
|00002160| 00 00 00 00 00 00 01 00 | 00 00 0a 5c 3c 4f 72 64 |........|...\<Ord|
|00002170| 65 72 2e 2e 2e 00 00 00 | 00 00 00 00 00 00 00 00 |er......|........|
|00002180| 00 00 00 00 00 00 00 01 | 00 00 00 06 43 54 52 4c |........|....CTRL|
|00002190| 2b 4f 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |+O......|........|
|000021a0| 00 00 00 00 00 00 00 00 | 01 00 00 00 06 43 74 72 |........|.....Ctr|
|000021b0| 6c 2b 4f 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |l+O.....|........|
|000021c0| 00 00 00 00 00 00 00 00 | 00 01 00 00 00 07 73 6b |........|......sk|
|000021d0| 69 70 76 61 72 00 00 00 | 00 00 00 00 00 00 00 00 |ipvar...|........|
|000021e0| 00 00 00 00 00 00 00 00 | 00 00 01 00 00 00 f3 64 |........|.......d|
|000021f0| 62 66 73 74 65 6d 20 3d | 20 6a 75 73 74 73 74 65 |bfstem =| justste|
|00002200| 6d 28 6d 2e 64 62 66 6e | 61 6d 65 29 0d 0a 53 45 |m(m.dbfn|ame)..SE|
|00002210| 4c 45 43 54 20 28 64 62 | 66 73 74 65 6d 29 0d 0a |LECT (db|fstem)..|
|00002220| 49 46 20 21 45 4d 50 54 | 59 28 43 44 58 28 31 29 |IF !EMPT|Y(CDX(1)|
|00002230| 29 0d 0a 20 20 20 49 46 | 20 21 72 65 67 65 6e 0d |).. IF| !regen.|
|00002240| 0a 20 20 20 20 20 20 6d | 6e 61 6d 65 20 3d 20 27 |. m|name = '|
|00002250| 67 65 74 6f 72 64 65 72 | 2e 70 72 67 27 0d 0a 20 |getorder|.prg'.. |
|00002260| 20 20 45 4c 53 45 0d 0a | 20 20 20 20 20 20 6d 6e | ELSE..| mn|
|00002270| 61 6d 65 20 3d 20 27 67 | 65 74 6f 72 64 65 72 2e |ame = 'g|etorder.|
|00002280| 73 70 72 27 0d 0a 20 20 | 20 45 4e 44 49 46 0d 0a |spr'.. | ENDIF..|
|00002290| 20 20 20 44 4f 20 28 6d | 6e 61 6d 65 29 0d 0a 20 | DO (m|name).. |
|000022a0| 20 20 53 48 4f 57 20 47 | 45 54 53 0d 0a 45 4c 53 | SHOW G|ETS..ELS|
|000022b0| 45 0d 0a 20 20 20 57 41 | 49 54 20 57 49 4e 44 4f |E.. WA|IT WINDO|
|000022c0| 57 20 22 4e 6f 20 69 6e | 64 65 78 65 73 20 77 65 |W "No in|dexes we|
|000022d0| 72 65 20 66 6f 75 6e 64 | 22 0d 0a 45 4e 44 49 46 |re found|"..ENDIF|
|000022e0| 0d 0a 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000022f0| 00 00 01 00 00 00 02 5c | 2d 00 00 00 00 00 00 00 |.......\|-.......|
|00002300| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002310| 00 00 00 01 00 00 00 0b | 50 69 63 6b 20 5c 3c 4c |........|Pick \<L|
|00002320| 69 73 74 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |ist.....|........|
|00002330| 00 00 00 00 01 00 00 00 | 06 43 54 52 4c 2b 4c 00 |........|.CTRL+L.|
|00002340| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002350| 00 00 00 00 00 01 00 00 | 00 06 43 74 72 6c 2b 4c |........|..Ctrl+L|
|00002360| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002370| 00 00 00 00 00 00 01 00 | 00 00 1b 6d 2e 73 6b 69 |........|...m.ski|
|00002380| 70 76 61 72 20 6f 72 20 | 6d 2e 6e 65 78 74 64 62 |pvar or |m.nextdb|
|00002390| 66 20 3c 3d 20 32 00 00 | 00 00 00 00 00 00 00 00 |f <= 2..|........|
|000023a0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000023b0| 00 00 00 00 00 00 00 00 | 01 00 00 00 21 44 4f 20 |........|....!DO |
|000023c0| 73 68 6f 77 70 6f 70 20 | 57 49 54 48 20 41 4c 49 |showpop |WITH ALI|
|000023d0| 41 53 28 29 2c 56 41 52 | 52 45 41 44 28 29 00 00 |AS(),VAR|READ()..|
|000023e0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000023f0| 00 00 00 00 00 00 00 00 | 00 00 01 00 00 00 02 5c |........|.......\|
|00002400| 2d 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |-.......|........|
|00002410| 00 00 00 00 00 00 00 00 | 00 00 00 01 00 00 00 0a |........|........|
|00002420| 5c 3c 51 75 65 72 79 2e | 2e 2e 00 00 00 00 00 00 |\<Query.|........|
|00002430| 00 00 00 00 00 00 00 00 | 00 00 00 00 01 00 00 00 |........|........|
|00002440| 06 43 54 52 4c 2b 51 00 | 00 00 00 00 00 00 00 00 |.CTRL+Q.|........|
|00002450| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 01 00 00 |........|........|
|00002460| 00 06 43 74 72 6c 2b 51 | 00 00 00 00 00 00 00 00 |..Ctrl+Q|........|
|00002470| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 01 00 |........|........|
|00002480| 00 00 1e 73 6b 69 70 76 | 61 72 20 6f 72 20 28 27 |...skipv|ar or ('|
|00002490| 45 58 45 27 20 24 20 56 | 45 52 53 49 4f 4e 28 29 |EXE' $ V|ERSION()|
|000024a0| 29 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |).......|........|
|000024b0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000024c0| 01 00 00 0b 22 50 52 49 | 56 41 54 45 20 67 65 6e |...."PRI|VATE gen|
|000024d0| 5f 6e 61 6d 65 2c 20 69 | 2c 20 71 6e 61 6d 65 2c |_name, i|, qname,|
|000024e0| 20 70 6e 61 6d 65 2c 20 | 77 69 6e 5f 6e 61 6d 65 | pname, |win_name|
|000024f0| 0d 0a 0d 0a 43 52 45 41 | 54 45 20 56 49 45 57 20 |....CREA|TE VIEW |
|00002500| 71 70 72 76 69 65 77 0d | 0a 0d 0a 2a 20 53 65 6c |qprview.|...* Sel|
|00002510| 65 63 74 20 74 68 65 20 | 6d 61 69 6e 20 64 61 74 |ect the |main dat|
|00002520| 61 62 61 73 65 0d 0a 64 | 62 66 73 74 65 6d 20 3d |abase..d|bfstem =|
|00002530| 20 6a 75 73 74 73 74 65 | 6d 28 6d 2e 64 62 66 6e | justste|m(m.dbfn|
|00002540| 61 6d 65 29 0d 0a 53 45 | 4c 45 43 54 20 28 64 62 |ame)..SE|LECT (db|
|00002550| 66 73 74 65 6d 29 0d 0a | 0d 0a 73 6b 69 70 76 61 |fstem)..|..skipva|
|00002560| 72 20 3d 20 2e 54 2e 0d | 0a 67 65 6e 5f 6e 61 6d |r = .T..|.gen_nam|
|00002570| 65 20 3d 20 2e 46 2e 0d | 0a 0d 0a 2a 20 44 65 66 |e = .F..|...* Def|
|00002580| 61 75 6c 74 20 71 75 65 | 72 79 20 6e 61 6d 65 20 |ault que|ry name |
|00002590| 69 73 20 74 68 65 20 64 | 61 74 61 62 61 73 65 20 |is the d|atabase |
|000025a0| 6e 61 6d 65 20 77 69 74 | 68 20 61 20 51 50 52 20 |name wit|h a QPR |
|000025b0| 65 78 74 65 6e 73 69 6f | 6e 2e 0d 0a 6d 2e 71 6e |extensio|n...m.qn|
|000025c0| 61 6d 65 20 3d 20 61 64 | 64 62 73 28 71 70 72 70 |ame = ad|dbs(qprp|
|000025d0| 61 74 68 29 20 2b 20 66 | 6f 72 63 65 65 78 74 28 |ath) + f|orceext(|
|000025e0| 6a 75 73 74 66 6e 61 6d | 65 28 6d 2e 64 62 66 6e |justfnam|e(m.dbfn|
|000025f0| 61 6d 65 29 2c 27 51 50 | 52 27 29 0d 0a 0d 0a 2a |ame),'QP|R')....*|
|00002600| 20 49 66 20 74 68 65 72 | 65 20 61 72 65 20 6d 75 | If ther|e are mu|
|00002610| 6c 74 69 70 6c 65 20 64 | 61 74 61 62 61 73 65 73 |ltiple d|atabases|
|00002620| 20 69 6e 20 74 68 69 73 | 20 61 70 70 2c 20 63 72 | in this| app, cr|
|00002630| 65 61 74 65 20 61 20 71 | 75 65 72 79 20 74 65 6d |eate a q|uery tem|
|00002640| 70 6c 61 74 65 0d 0a 2a | 20 73 6f 20 74 68 61 74 |plate..*| so that|
|00002650| 20 74 68 65 20 75 73 65 | 72 20 64 6f 65 73 6e 27 | the use|r doesn'|
|00002660| 74 20 68 61 76 65 20 74 | 6f 20 65 6e 74 65 72 20 |t have t|o enter |
|00002670| 61 6c 6c 20 74 68 65 20 | 72 65 6c 61 74 69 6f 6e |all the |relation|
|00002680| 73 20 61 67 61 69 6e 2e | 0d 0a 49 46 20 6d 2e 6e |s again.|..IF m.n|
|00002690| 65 78 74 64 62 66 20 3e | 20 32 20 41 4e 44 20 54 |extdbf >| 2 AND T|
|000026a0| 59 50 45 28 22 64 62 66 | 6c 69 73 74 22 29 20 3c |YPE("dbf|list") <|
|000026b0| 3e 20 22 55 22 0d 0a 20 | 20 20 2a 20 43 72 65 61 |> "U".. | * Crea|
|000026c0| 74 65 20 61 20 62 6c 61 | 6e 6b 20 71 75 65 72 79 |te a bla|nk query|
|000026d0| 20 66 69 6c 65 20 74 6f | 20 70 61 73 73 20 74 68 | file to| pass th|
|000026e0| 65 20 64 61 74 61 62 61 | 73 65 73 20 61 6e 64 20 |e databa|ses and |
|000026f0| 72 65 6c 61 74 69 6f 6e | 73 0d 0a 20 20 20 2a 20 |relation|s.. * |
|00002700| 61 6c 6f 6e 67 20 74 6f | 20 52 51 42 45 0d 0a 0d |along to| RQBE...|
|00002710| 0a 20 20 20 2a 20 54 72 | 79 20 74 6f 20 63 6f 6d |. * Tr|y to com|
|00002720| 65 20 75 70 20 77 69 74 | 68 20 61 20 72 65 61 73 |e up wit|h a reas|
|00002730| 6f 6e 61 62 6c 65 2d 73 | 6f 75 6e 64 69 6e 67 20 |onable-s|ounding |
|00002740| 75 6e 69 71 75 65 20 6e | 61 6d 65 20 66 6f 72 20 |unique n|ame for |
|00002750| 74 68 65 20 71 75 65 72 | 79 2c 0d 0a 20 20 20 2a |the quer|y,.. *|
|00002760| 20 69 66 20 74 68 65 20 | 64 65 66 61 75 6c 74 20 | if the |default |
|00002770| 6e 61 6d 65 20 69 73 20 | 61 6c 72 65 61 64 79 20 |name is |already |
|00002780| 74 61 6b 65 6e 2e 0d 0a | 20 20 20 69 20 3d 20 30 |taken...| i = 0|
|00002790| 0d 0a 20 20 20 44 4f 20 | 57 48 49 4c 45 20 46 49 |.. DO |WHILE FI|
|000027a0| 4c 45 28 6d 2e 71 6e 61 | 6d 65 29 20 41 4e 44 20 |LE(m.qna|me) AND |
|000027b0| 69 20 3c 20 31 30 30 0d | 0a 20 20 20 20 20 20 6d |i < 100.|. m|
|000027c0| 2e 71 6e 61 6d 65 20 3d | 20 41 4c 4c 54 52 49 4d |.qname =| ALLTRIM|
|000027d0| 28 4c 45 46 54 28 6a 75 | 73 74 73 74 65 6d 28 6d |(LEFT(ju|ststem(m|
|000027e0| 2e 71 6e 61 6d 65 29 2c | 36 29 29 20 2b 20 53 54 |.qname),|6)) + ST|
|000027f0| 52 28 69 2c 32 29 0d 0a | 20 20 20 20 20 20 6d 2e |R(i,2)..| m.|
|00002800| 71 6e 61 6d 65 20 3d 20 | 43 48 52 54 52 41 4e 28 |qname = |CHRTRAN(|
|00002810| 6d 2e 71 6e 61 6d 65 2c | 27 20 27 2c 27 30 27 29 |m.qname,|' ','0')|
|00002820| 0d 0a 20 20 20 20 20 20 | 6d 2e 71 6e 61 6d 65 20 |.. |m.qname |
|00002830| 3d 20 66 6f 72 63 65 65 | 78 74 28 6d 2e 71 6e 61 |= forcee|xt(m.qna|
|00002840| 6d 65 2c 27 51 50 52 27 | 29 0d 0a 20 20 20 20 20 |me,'QPR'|).. |
|00002850| 20 6d 2e 71 6e 61 6d 65 | 20 3d 20 61 64 64 62 73 | m.qname| = addbs|
|00002860| 28 6d 2e 71 70 72 70 61 | 74 68 29 20 2b 20 6d 2e |(m.qprpa|th) + m.|
|00002870| 71 6e 61 6d 65 0d 0a 20 | 20 20 20 20 20 69 20 3d |qname.. | i =|
|00002880| 20 69 20 2b 20 31 0d 0a | 20 20 20 45 4e 44 44 4f | i + 1..| ENDDO|
|00002890| 0d 0a 0d 0a 20 20 20 2a | 20 50 72 6f 6d 70 74 20 |.... *| Prompt |
|000028a0| 74 68 65 20 75 73 65 72 | 20 66 6f 72 20 74 68 65 |the user| for the|
|000028b0| 20 71 75 65 72 79 20 6e | 61 6d 65 20 61 6e 64 20 | query n|ame and |
|000028c0| 61 6c 6c 6f 77 20 63 68 | 61 6e 67 65 73 2e 20 0d |allow ch|anges. .|
|000028d0| 0a 20 20 20 2a 20 43 68 | 61 6e 67 65 20 74 6f 20 |. * Ch|ange to |
|000028e0| 74 68 65 20 64 69 72 65 | 63 74 6f 72 79 20 74 68 |the dire|ctory th|
|000028f0| 65 20 75 73 65 72 20 77 | 61 6e 74 73 20 74 6f 20 |e user w|ants to |
|00002900| 75 73 65 20 73 6f 20 74 | 68 61 74 20 74 68 65 20 |use so t|hat the |
|00002910| 0d 0a 20 20 20 2a 20 50 | 55 54 46 49 4c 45 20 64 |.. * P|UTFILE d|
|00002920| 69 72 65 63 74 6f 72 79 | 20 64 65 66 61 75 6c 74 |irectory| default|
|00002930| 73 20 61 72 65 20 72 69 | 67 68 74 2e 0d 0a 20 20 |s are ri|ght... |
|00002940| 20 69 6e 5f 64 69 72 20 | 3d 20 53 45 54 28 27 44 | in_dir |= SET('D|
|00002950| 45 46 41 55 4c 54 27 29 | 2b 43 55 52 44 49 52 28 |EFAULT')|+CURDIR(|
|00002960| 29 0d 0a 20 20 20 53 45 | 54 20 44 45 46 41 55 4c |).. SE|T DEFAUL|
|00002970| 54 20 54 4f 20 26 71 70 | 72 70 61 74 68 0d 0a 20 |T TO &qp|rpath.. |
|00002980| 20 20 6d 2e 71 6e 61 6d | 65 20 3d 20 50 55 54 46 | m.qnam|e = PUTF|
|00002990| 49 4c 45 28 27 51 75 65 | 72 79 20 6e 61 6d 65 27 |ILE('Que|ry name'|
|000029a0| 2c 6d 2e 71 6e 61 6d 65 | 2c 27 51 50 52 27 2c 27 |,m.qname|,'QPR','|
|000029b0| 4f 4b 27 29 0d 0a 20 20 | 20 53 45 54 20 44 45 46 |OK').. | SET DEF|
|000029c0| 41 55 4c 54 20 54 4f 20 | 26 69 6e 5f 64 69 72 0d |AULT TO |&in_dir.|
|000029d0| 0a 0d 0a 20 20 20 49 46 | 20 45 4d 50 54 59 28 6d |... IF| EMPTY(m|
|000029e0| 2e 71 6e 61 6d 65 29 20 | 20 20 26 26 20 75 73 65 |.qname) | && use|
|000029f0| 72 20 63 68 61 6e 67 65 | 64 20 68 69 73 20 6d 69 |r change|d his mi|
|00002a00| 6e 64 2e 0d 0a 20 20 20 | 20 20 20 73 6b 69 70 76 |nd... | skipv|
|00002a10| 61 72 20 3d 20 2e 46 2e | 0d 0a 20 20 20 20 20 20 |ar = .F.|.. |
|00002a20| 52 45 54 55 52 4e 0d 0a | 20 20 20 45 4c 53 45 0d |RETURN..| ELSE.|
|00002a30| 0a 20 20 20 20 20 20 2a | 20 55 73 65 20 74 68 69 |. *| Use thi|
|00002a40| 73 20 70 61 74 68 20 66 | 6f 72 20 66 75 74 75 72 |s path f|or futur|
|00002a50| 65 20 71 75 65 72 69 65 | 73 0d 0a 20 20 20 20 20 |e querie|s.. |
|00002a60| 20 71 70 72 70 61 74 68 | 20 3d 20 6a 75 73 74 70 | qprpath| = justp|
|00002a70| 61 74 68 28 6d 2e 71 6e | 61 6d 65 29 0d 0a 20 20 |ath(m.qn|ame).. |
|00002a80| 20 45 4e 44 49 46 0d 0a | 0d 0a 20 20 20 2a 20 43 | ENDIF..|.. * C|
|00002a90| 72 65 61 74 65 20 74 68 | 65 20 71 75 65 72 79 20 |reate th|e query |
|00002aa0| 74 65 6d 70 6c 61 74 65 | 20 66 69 6c 65 0d 0a 20 |template| file.. |
|00002ab0| 20 20 53 45 54 20 54 45 | 58 54 4d 45 52 47 45 20 | SET TE|XTMERGE |
|00002ac0| 54 4f 20 26 71 6e 61 6d | 65 0d 0a 20 20 20 53 45 |TO &qnam|e.. SE|
|00002ad0| 54 20 54 45 58 54 4d 45 | 52 47 45 20 4f 4e 0d 0a |T TEXTME|RGE ON..|
|00002ae0| 20 20 20 53 45 54 20 43 | 4f 4e 53 4f 4c 45 20 4f | SET C|ONSOLE O|
|00002af0| 46 46 0d 0a 0d 0a 20 20 | 20 67 65 6e 5f 6e 61 6d |FF.... | gen_nam|
|00002b00| 65 20 3d 20 2e 54 2e 20 | 20 20 20 20 26 26 20 6e |e = .T. | && n|
|00002b10| 6f 74 65 20 74 68 61 74 | 20 74 68 69 73 20 69 73 |ote that| this is|
|00002b20| 20 61 20 67 65 6e 65 72 | 61 74 65 64 20 66 69 6c | a gener|ated fil|
|00002b30| 65 0d 0a 0d 0a 20 20 20 | 5c 53 45 4c 45 43 54 20 |e.... |\SELECT |
|00002b40| 2a 20 3b 0d 0a 20 20 20 | 5c 20 46 52 4f 4d 20 3c |* ;.. |\ FROM <|
|00002b50| 3c 64 62 66 6c 69 73 74 | 5b 31 2c 6d 2e 63 73 74 |<dbflist|[1,m.cst|
|00002b60| 65 6d 6e 75 6d 5d 3e 3e | 0d 0a 20 20 20 46 4f 52 |emnum]>>|.. FOR|
|00002b70| 20 69 20 3d 20 32 20 54 | 4f 20 6d 2e 6e 65 78 74 | i = 2 T|O m.next|
|00002b80| 64 62 66 20 2d 20 31 0d | 0a 20 20 20 20 20 20 5c |dbf - 1.|. \|
|00002b90| 5c 2c 20 3c 3c 64 62 66 | 6c 69 73 74 5b 69 2c 6d |\, <<dbf|list[i,m|
|00002ba0| 2e 63 73 74 65 6d 6e 75 | 6d 5d 3e 3e 0d 0a 20 20 |.cstemnu|m]>>.. |
|00002bb0| 20 45 4e 44 46 4f 52 0d | 0a 20 20 20 5c 5c 20 3b | ENDFOR.|. \\ ;|
|00002bc0| 0d 0a 20 20 20 5c 20 57 | 48 45 52 45 20 3b 20 0d |.. \ W|HERE ; .|
|00002bd0| 0a 20 20 20 46 4f 52 20 | 69 20 3d 20 32 20 54 4f |. FOR |i = 2 TO|
|00002be0| 20 6d 2e 6e 65 78 74 64 | 62 66 20 2d 20 31 0d 0a | m.nextd|bf - 1..|
|00002bf0| 20 20 20 20 20 20 49 46 | 20 69 20 3e 20 32 0d 0a | IF| i > 2..|
|00002c00| 20 20 20 20 20 20 20 20 | 20 5c 20 20 20 41 4e 44 | | \ AND|
|00002c10| 0d 0a 20 20 20 20 20 20 | 45 4c 53 45 0d 0a 20 20 |.. |ELSE.. |
|00002c20| 20 20 20 20 20 20 20 5c | 0d 0a 20 20 20 20 20 20 | \|.. |
|00002c30| 45 4e 44 49 46 0d 0a 20 | 20 20 20 20 20 5c 5c 20 |ENDIF.. | \\ |
|00002c40| 20 20 3c 3c 64 62 66 6c | 69 73 74 5b 69 2c 6d 2e | <<dbfl|ist[i,m.|
|00002c50| 63 66 6c 64 6e 75 6d 5d | 3e 3e 20 3d 20 3c 3c 64 |cfldnum]|>> = <<d|
|00002c60| 62 66 6c 69 73 74 5b 69 | 2c 6d 2e 70 66 6c 64 6e |bflist[i|,m.pfldn|
|00002c70| 75 6d 5d 3e 3e 20 3b 0d | 0a 20 20 20 45 4e 44 46 |um]>> ;.|. ENDF|
|00002c80| 4f 52 0d 0a 20 20 20 5c | 49 4e 54 4f 20 43 55 52 |OR.. \|INTO CUR|
|00002c90| 53 4f 52 20 46 6f 78 41 | 70 70 0d 0a 20 20 20 5c |SOR FoxA|pp.. \|
|00002ca0| 42 52 4f 57 53 45 20 4e | 4f 4d 4f 44 49 46 59 0d |BROWSE N|OMODIFY.|
|00002cb0| 0a 0d 0a 20 20 20 53 45 | 54 20 43 4f 4e 53 4f 4c |... SE|T CONSOL|
|00002cc0| 45 20 4f 4e 0d 0a 20 20 | 20 53 45 54 20 54 45 58 |E ON.. | SET TEX|
|00002cd0| 54 4d 45 52 47 45 20 4f | 46 46 0d 0a 20 20 20 53 |TMERGE O|FF.. S|
|00002ce0| 45 54 20 54 45 58 54 4d | 45 52 47 45 20 54 4f 0d |ET TEXTM|ERGE TO.|
|00002cf0| 0a 45 4c 53 45 0d 0a 20 | 20 20 2a 20 50 72 6f 6d |.ELSE.. | * Prom|
|00002d00| 70 74 20 74 68 65 20 75 | 73 65 72 20 66 6f 72 20 |pt the u|ser for |
|00002d10| 74 68 65 20 71 75 65 72 | 79 20 6e 61 6d 65 0d 0a |the quer|y name..|
|00002d20| 20 20 20 6d 2e 71 6e 61 | 6d 65 20 3d 20 50 55 54 | m.qna|me = PUT|
|00002d30| 46 49 4c 45 28 27 51 75 | 65 72 79 20 6e 61 6d 65 |FILE('Qu|ery name|
|00002d40| 27 2c 6d 2e 71 6e 61 6d | 65 2c 27 51 50 52 27 2c |',m.qnam|e,'QPR',|
|00002d50| 27 4f 4b 27 29 0d 0a 45 | 4e 44 49 46 0d 0a 0d 0a |'OK')..E|NDIF....|
|00002d60| 49 46 20 21 45 4d 50 54 | 59 28 6d 2e 71 6e 61 6d |IF !EMPT|Y(m.qnam|
|00002d70| 65 29 0d 0a 20 20 20 77 | 69 6e 5f 6e 61 6d 65 20 |e).. w|in_name |
|00002d80| 3d 20 57 4f 55 54 50 55 | 54 28 29 0d 0a 20 20 20 |= WOUTPU|T().. |
|00002d90| 41 43 54 49 56 41 54 45 | 20 53 43 52 45 45 4e 0d |ACTIVATE| SCREEN.|
|00002da0| 0a 20 20 20 49 46 20 46 | 49 4c 45 28 6d 2e 71 6e |. IF F|ILE(m.qn|
|00002db0| 61 6d 65 29 0d 0a 20 20 | 20 20 20 20 4d 4f 44 49 |ame).. | MODI|
|00002dc0| 46 59 20 51 55 45 52 59 | 20 28 6d 2e 71 6e 61 6d |FY QUERY| (m.qnam|
|00002dd0| 65 29 0d 0a 20 20 20 45 | 4c 53 45 0d 0a 20 20 20 |e).. E|LSE.. |
|00002de0| 20 20 20 43 52 45 41 54 | 45 20 51 55 45 52 59 20 | CREAT|E QUERY |
|00002df0| 28 6d 2e 71 6e 61 6d 65 | 29 0d 0a 20 20 20 45 4e |(m.qname|).. EN|
|00002e00| 44 49 46 0d 0a 20 20 20 | 43 4c 45 41 52 0d 0a 20 |DIF.. |CLEAR.. |
|00002e10| 20 20 49 46 20 21 45 4d | 50 54 59 28 6d 2e 77 69 | IF !EM|PTY(m.wi|
|00002e20| 6e 5f 6e 61 6d 65 29 0d | 0a 20 20 20 20 20 20 41 |n_name).|. A|
|00002e30| 43 54 49 56 41 54 45 20 | 57 49 4e 44 4f 57 20 28 |CTIVATE |WINDOW (|
|00002e40| 6d 2e 77 69 6e 5f 6e 61 | 6d 65 29 0d 0a 20 20 20 |m.win_na|me).. |
|00002e50| 45 4e 44 49 46 0d 0a 45 | 4c 53 45 0d 0a 20 20 20 |ENDIF..E|LSE.. |
|00002e60| 2a 20 44 65 6c 65 74 65 | 20 74 68 69 73 20 66 69 |* Delete| this fi|
|00002e70| 6c 65 20 69 66 20 69 74 | 20 77 61 73 20 61 20 67 |le if it| was a g|
|00002e80| 65 6e 65 72 61 74 65 64 | 20 66 69 6c 65 20 61 6e |enerated| file an|
|00002e90| 64 20 74 68 65 20 0d 0a | 20 20 20 2a 20 75 73 65 |d the ..| * use|
|00002ea0| 72 20 63 61 6e 63 65 6c | 6c 65 64 20 74 68 65 20 |r cancel|led the |
|00002eb0| 71 75 65 72 79 2e 0d 0a | 20 20 20 49 46 20 6d 2e |query...| IF m.|
|00002ec0| 67 65 6e 5f 6e 61 6d 65 | 20 41 4e 44 20 46 49 4c |gen_name| AND FIL|
|00002ed0| 45 28 6d 2e 71 6e 61 6d | 65 29 0d 0a 20 20 20 20 |E(m.qnam|e).. |
|00002ee0| 20 20 44 45 4c 45 54 45 | 20 46 49 4c 45 20 6d 2e | DELETE| FILE m.|
|00002ef0| 71 6e 61 6d 65 0d 0a 20 | 20 20 45 4e 44 49 46 0d |qname.. | ENDIF.|
|00002f00| 0a 45 4e 44 49 46 0d 0a | 49 46 20 45 4d 50 54 59 |.ENDIF..|IF EMPTY|
|00002f10| 28 6f 70 65 6e 64 62 66 | 28 6d 2e 64 62 66 6e 61 |(opendbf|(m.dbfna|
|00002f20| 6d 65 29 29 0d 0a 20 20 | 20 6d 2e 64 62 66 6e 61 |me)).. | m.dbfna|
|00002f30| 6d 65 20 3d 20 4c 4f 43 | 46 49 4c 45 28 6d 2e 64 |me = LOC|FILE(m.d|
|00002f40| 62 66 6e 61 6d 65 2c 27 | 44 42 46 27 2c 27 50 6c |bfname,'|DBF','Pl|
|00002f50| 65 61 73 65 20 6c 6f 63 | 61 74 65 20 74 68 65 20 |ease loc|ate the |
|00002f60| 64 61 74 61 62 61 73 65 | 27 29 0d 0a 45 4e 44 49 |database|')..ENDI|
|00002f70| 46 0d 0a 73 6b 69 70 76 | 61 72 20 3d 20 2e 46 2e |F..skipv|ar = .F.|
|00002f80| 0d 0a 0d 0a 49 46 20 46 | 49 4c 45 28 27 71 70 72 |....IF F|ILE('qpr|
|00002f90| 76 69 65 77 2e 76 75 65 | 27 29 0d 0a 20 20 20 53 |view.vue|').. S|
|00002fa0| 45 54 20 56 49 45 57 20 | 54 4f 20 71 70 72 76 69 |ET VIEW |TO qprvi|
|00002fb0| 65 77 0d 0a 45 4e 44 49 | 46 0d 0a 4b 45 59 42 4f |ew..ENDI|F..KEYBO|
|00002fc0| 41 52 44 20 43 48 52 28 | 32 37 29 20 20 20 26 26 |ARD CHR(|27) &&|
|00002fd0| 20 66 6f 72 63 65 20 73 | 63 72 65 65 6e 20 72 65 | force s|creen re|
|00002fe0| 66 72 65 73 68 0d 0a 00 | 00 00 00 00 00 00 00 00 |fresh...|........|
|00002ff0| 00 00 00 00 00 00 00 01 | 00 00 00 0b 5c 3c 52 65 |........|....\<Re|
|00003000| 70 6f 72 74 2e 2e 2e 00 | 00 00 00 00 00 00 00 00 |port....|........|
|00003010| 00 00 00 00 00 00 00 00 | 01 00 00 00 06 43 54 52 |........|.....CTR|
|00003020| 4c 2b 52 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |L+R.....|........|
|00003030| 00 00 00 00 00 00 00 00 | 00 01 00 00 00 06 43 74 |........|......Ct|
|00003040| 72 6c 2b 52 00 00 00 00 | 00 00 00 00 00 00 00 00 |rl+R....|........|
|00003050| 00 00 00 00 00 00 00 00 | 00 00 01 00 00 00 07 73 |........|.......s|
|00003060| 6b 69 70 76 61 72 00 00 | 00 00 00 00 00 00 00 00 |kipvar..|........|
|00003070| 00 00 00 00 00 00 00 00 | 00 00 00 01 00 00 00 58 |........|.......X|
|00003080| 49 46 20 21 72 65 67 65 | 6e 0d 0a 20 20 20 6d 6e |IF !rege|n.. mn|
|00003090| 61 6d 65 20 3d 20 27 70 | 72 74 6f 70 74 73 2e 70 |ame = 'p|rtopts.p|
|000030a0| 72 67 27 0d 0a 45 4c 53 | 45 0d 0a 20 20 20 6d 6e |rg'..ELS|E.. mn|
|000030b0| 61 6d 65 20 3d 20 27 70 | 72 74 6f 70 74 73 2e 73 |ame = 'p|rtopts.s|
|000030c0| 70 72 27 0d 0a 45 4e 44 | 49 46 0d 0a 44 4f 20 28 |pr'..END|IF..DO (|
|000030d0| 6d 6e 61 6d 65 29 0d 0a | 00 00 00 00 00 00 01 00 |mname)..|........|
|000030e0| 00 00 0b 5c 3c 55 74 69 | 6c 69 74 69 65 73 00 00 |...\<Uti|lities..|
|000030f0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 01 |........|........|
|00003100| 00 00 00 05 41 4c 54 2b | 55 00 00 00 00 00 00 00 |....ALT+|U.......|
|00003110| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003120| 01 00 00 00 01 20 00 00 | 00 00 00 00 00 00 00 00 |..... ..|........|
|00003130| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003140| 00 01 00 00 00 09 55 74 | 69 6c 69 74 69 65 73 00 |......Ut|ilities.|
|00003150| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003160| 00 00 01 00 00 00 10 5c | 3c 52 65 66 72 65 73 68 |.......\|<Refresh|
|00003170| 20 53 63 72 65 65 6e 00 | 00 00 00 00 00 00 00 00 | Screen.|........|
|00003180| 00 00 00 01 00 00 00 07 | 73 6b 69 70 76 61 72 00 |........|skipvar.|
|00003190| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000031a0| 00 00 00 00 01 00 00 00 | 2e 41 43 54 49 56 41 54 |........|.ACTIVAT|
|000031b0| 45 20 57 49 4e 44 4f 57 | 20 28 77 69 6e 5f 6e 61 |E WINDOW| (win_na|
|000031c0| 6d 65 29 0d 0a 4b 45 59 | 42 4f 41 52 44 20 43 48 |me)..KEY|BOARD CH|
|000031d0| 52 28 32 37 29 0d 0a 00 | 00 00 00 00 00 00 00 00 |R(27)...|........|
|000031e0| 00 00 00 00 00 00 01 00 | 00 00 11 5c 3c 43 6f 6e |........|...\<Con|
|000031f0| 73 74 72 75 63 74 20 49 | 6e 64 65 78 00 00 00 00 |struct I|ndex....|
|00003200| 00 00 00 00 00 00 00 01 | 00 00 00 07 73 6b 69 70 |........|....skip|
|00003210| 76 61 72 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |var.....|........|
|00003220| 00 00 00 00 00 00 00 00 | 01 00 00 00 77 44 4f 20 |........|....wDO |
|00003230| 69 6e 76 65 72 74 20 57 | 49 54 48 20 41 4c 49 41 |invert W|ITH ALIA|
|00003240| 53 28 29 0d 0a 53 45 54 | 20 4f 52 44 45 52 20 54 |S()..SET| ORDER T|
|00003250| 4f 20 31 0d 0a 47 4f 54 | 4f 20 54 4f 50 0d 0a 5f |O 1..GOT|O TOP.._|
|00003260| 43 55 52 4f 42 4a 20 3d | 20 31 0d 0a 57 41 49 54 |CUROBJ =| 1..WAIT|
|00003270| 20 57 49 4e 44 4f 57 20 | 22 52 65 69 6e 64 65 78 | WINDOW |"Reindex|
|00003280| 69 6e 67 20 63 6f 6d 70 | 6c 65 74 65 64 22 20 4e |ing comp|leted" N|
|00003290| 4f 57 41 49 54 0d 0a 53 | 48 4f 57 20 47 45 54 53 |OWAIT..S|HOW GETS|
|000032a0| 0d 0a 0d 0a 00 00 00 00 | 00 00 00 00 01 00 00 00 |........|........|
|000032b0| 06 5c 3c 50 61 63 6b 00 | 00 00 00 00 00 00 00 00 |.\<Pack.|........|
|000032c0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 01 00 00 |........|........|
|000032d0| 00 07 73 6b 69 70 76 61 | 72 00 00 00 00 00 00 00 |..skipva|r.......|
|000032e0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 01 00 |........|........|
|000032f0| 00 00 dd 50 41 43 4b 20 | 20 20 26 26 20 61 6c 73 |...PACK | && als|
|00003300| 6f 20 72 65 69 6e 64 65 | 78 65 73 20 74 68 65 20 |o reinde|xes the |
|00003310| 66 69 6c 65 0d 0a 53 45 | 54 20 4f 52 44 45 52 20 |file..SE|T ORDER |
|00003320| 54 4f 20 31 0d 0a 47 4f | 54 4f 20 54 4f 50 0d 0a |TO 1..GO|TO TOP..|
|00003330| 49 46 20 52 45 43 43 4f | 55 4e 54 28 29 20 3d 20 |IF RECCO|UNT() = |
|00003340| 30 0d 0a 20 20 20 41 50 | 50 45 4e 44 20 42 4c 41 |0.. AP|PEND BLA|
|00003350| 4e 4b 0d 0a 45 4e 44 49 | 46 0d 0a 57 41 49 54 20 |NK..ENDI|F..WAIT |
|00003360| 57 49 4e 44 4f 57 20 22 | 50 61 63 6b 20 63 6f 6d |WINDOW "|Pack com|
|00003370| 70 6c 65 74 65 64 22 20 | 4e 4f 57 41 49 54 0d 0a |pleted" |NOWAIT..|
|00003380| 4b 45 59 42 4f 41 52 44 | 20 43 48 52 28 32 37 29 |KEYBOARD| CHR(27)|
|00003390| 20 20 20 20 26 26 20 63 | 61 75 73 65 73 20 73 63 | && c|auses sc|
|000033a0| 72 65 65 6e 20 72 65 66 | 72 65 73 68 20 61 6e 64 |reen ref|resh and|
|000033b0| 20 72 65 73 74 6f 72 65 | 73 20 62 72 6f 77 73 65 | restore|s browse|
|000033c0| 73 0d 0a 53 48 4f 57 20 | 47 45 54 53 0d 0a 0d 0a |s..SHOW |GETS....|
|000033d0| 00 00 00 00 00 01 00 00 | 00 06 5c 3c 48 65 6c 70 |........|..\<Help|
|000033e0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000033f0| 00 00 00 00 00 00 01 00 | 00 00 05 41 4c 54 2b 53 |........|...ALT+S|
|00003400| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003410| 00 00 00 00 00 00 00 01 | 00 00 00 04 48 65 6c 70 |........|....Help|
|00003420| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003430| 00 00 00 00 00 00 00 00 | 01 00 00 00 09 5c 3c 48 |........|.....\<H|
|00003440| 65 6c 70 2e 2e 2e 00 00 | 00 00 00 00 00 00 00 00 |elp.....|........|
|00003450| 00 00 00 00 00 00 00 00 | 00 01 00 00 00 02 46 31 |........|......F1|
|00003460| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003470| 00 00 00 00 00 00 00 00 | 00 00 01 00 00 00 02 46 |........|.......F|
|00003480| 31 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |1.......|........|
|00003490| 00 00 00 00 00 00 00 00 | 00 00 00 01 00 00 00 09 |........|........|
|000034a0| 5f 4d 53 54 5f 48 45 4c | 50 00 00 00 00 00 00 00 |_MST_HEL|P.......|
|000034b0| 00 00 00 00 00 00 00 00 | 00 00 00 00 01 00 00 00 |........|........|
|000034c0| 02 5c 2d 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |.\-.....|........|
|000034d0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 01 00 00 |........|........|
|000034e0| 00 08 5c 3c 4d 61 63 72 | 6f 73 00 00 00 00 00 00 |..\<Macr|os......|
|000034f0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 01 00 |........|........|
|00003500| 00 00 0a 5f 4d 53 54 5f | 4d 41 43 52 4f 00 00 00 |..._MST_|MACRO...|
|00003510| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 01 |........|........|
|00003520| 00 00 00 0c 5c 3c 43 61 | 6c 63 75 6c 61 74 6f 72 |....\<Ca|lculator|
|00003530| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003540| 01 00 00 00 0a 5f 4d 53 | 54 5f 43 41 4c 43 55 00 |....._MS|T_CALCU.|
|00003550| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003560| 00 01 00 00 00 10 43 61 | 6c 65 6e 64 61 72 2f 5c |......Ca|lendar/\|
|00003570| 3c 44 69 61 72 79 00 00 | 00 00 00 00 00 00 00 00 |<Diary..|........|
|00003580| 00 00 01 00 00 00 0a 5f | 4d 53 54 5f 44 49 41 52 |......._|MST_DIAR|
|00003590| 59 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |Y.......|........|
|000035a0| 00 00 00 01 00 00 00 08 | 50 75 5c 3c 7a 7a 6c 65 |........|Pu\<zzle|
|000035b0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000035c0| 00 00 00 00 01 00 00 00 | 0a 5f 4d 53 54 5f 50 55 |........|._MST_PU|
|000035d0| 5a 5a 4c 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |ZZL.....|........|
|000035e0| 00 00 00 00 00 01 00 00 | 00 02 5c 2d 00 00 00 00 |........|..\-....|
|000035f0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003600| 00 00 00 00 00 00 01 00 | 00 00 07 4e 65 77 49 74 |........|...NewIt|
|00003610| 65 6d 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |em......|........|
|00003620| 00 00 00 00 00 00 00 01 | 00 00 00 0a 5c 3c 41 62 |........|....\<Ab|
|00003630| 6f 75 74 2e 2e 2e 00 00 | 00 00 00 00 00 00 00 00 |out.....|........|
|00003640| 00 00 00 00 00 00 00 00 | 01 00 00 00 5a 49 46 20 |........|....ZIF |
|00003650| 21 72 65 67 65 6e 0d 0a | 20 20 20 6d 6e 61 6d 65 |!regen..| mname|
|00003660| 20 3d 20 27 61 70 70 61 | 62 6f 75 74 2e 70 72 67 | = 'appa|bout.prg|
|00003670| 27 0d 0a 45 4c 53 45 0d | 0a 20 20 20 6d 6e 61 6d |'..ELSE.|. mnam|
|00003680| 65 20 3d 20 27 61 70 70 | 61 62 6f 75 74 2e 73 70 |e = 'app|about.sp|
|00003690| 72 27 0d 0a 45 4e 44 49 | 46 0d 0a 44 4f 20 28 6d |r'..ENDI|F..DO (m|
|000036a0| 6e 61 6d 65 29 0d 0a 2a | |name)..*| |
+--------+-------------------------+-------------------------+--------+--------+