Liren Large Software Subsidy 5

home *** CD-ROM | disk | FTP | other *** search
/ Liren Large Software Subsidy 5 / 05.iso / a / a106 / 2.ddi / DBFSELEC.SC_ / DBFSELEC.bin
Unknown | 1994-04-28 | 14.3 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, 445 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)
`100%`	siegfried	x-fmt/342 Microsoft FoxPro Memo	default (weak)
hex view
+--------+-------------------------+-------------------------+--------+--------+
|00000000| 00 00 01 bd 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| 00 00 00 00 00 00 00 00 | 00 00 00 6a 69 6d 67 72 |........|...jimgr|
|00000210| 00 00 00 01 00 00 00 08 | 44 42 46 53 45 4c 45 43 |........|DBFSELEC|
|00000220| 00 00 e2 d9 11 00 01 00 | 4a 69 6d 20 47 72 6f 76 |........|Jim Grov|
|00000230| 65 00 00 00 01 00 00 00 | 0d 4d 53 20 53 61 6e 73 |e.......|.MS Sans|
|00000240| 20 53 65 72 69 66 00 00 | 00 00 00 00 00 00 00 00 | Serif..|........|
|00000250| 00 00 00 00 00 01 00 00 | 00 11 22 20 52 65 6c 61 |........|.." Rela|
|00000260| 74 65 64 20 54 61 62 6c | 65 73 22 00 00 00 00 00 |ted Tabl|es".....|
|00000270| 00 00 00 00 00 00 01 00 | 00 00 56 49 46 20 6e 65 |........|..VIF ne|
|00000280| 78 74 64 62 66 20 3d 20 | 31 0d 0a 20 20 20 53 48 |xtdbf = |1..   SH|
|00000290| 4f 57 20 47 45 54 20 61 | 72 72 61 6e 67 65 20 44 |OW GET a|rrange D|
|000002a0| 49 53 41 42 4c 45 0d 0a | 45 4c 53 45 0d 0a 20 20 |ISABLE..|ELSE..  |
|000002b0| 20 53 48 4f 57 20 47 45 | 54 20 61 72 72 61 6e 67 | SHOW GE|T arrang|
|000002c0| 65 20 45 4e 41 42 4c 45 | 0d 0a 45 4e 44 49 46 0d |e ENABLE|..ENDIF.|
|000002d0| 0a 00 00 00 00 00 00 00 | 00 01 00 00 00 ed 49 46 |........|......IF|
|000002e0| 20 6e 65 78 74 64 62 66 | 20 3c 3d 20 32 0d 0a 20 | nextdbf| <= 2.. |
|000002f0| 20 20 53 48 4f 57 20 47 | 45 54 20 74 72 65 65 31 |  SHOW G|ET tree1|
|00000300| 20 44 49 53 41 42 4c 45 | 0d 0a 45 4c 53 45 0d 0a | DISABLE|..ELSE..|
|00000310| 20 20 20 53 48 4f 57 20 | 47 45 54 20 74 72 65 65 |   SHOW |GET tree|
|00000320| 31 20 45 4e 41 42 4c 45 | 20 20 20 0d 0a 45 4e 44 |1 ENABLE|   ..END|
|00000330| 49 46 0d 0a 49 46 20 57 | 56 49 53 49 42 4c 45 28 |IF..IF W|VISIBLE(|
|00000340| 27 74 72 65 65 77 69 6e | 64 27 29 0d 0a 20 20 20 |'treewin|d')..   |
|00000350| 41 43 54 49 56 41 54 45 | 20 57 49 4e 44 4f 57 20 |ACTIVATE| WINDOW |
|00000360| 74 72 65 65 77 69 6e 64 | 20 4e 4f 53 48 4f 57 0d |treewind| NOSHOW.|
|00000370| 0a 20 20 20 43 4c 45 41 | 52 0d 0a 20 20 20 53 45 |.   CLEA|R..   SE|
|00000380| 54 20 43 55 52 53 4f 52 | 20 4f 46 46 0d 0a 20 20 |T CURSOR| OFF..  |
|00000390| 20 44 4f 20 73 68 6f 77 | 74 72 65 65 20 57 49 54 | DO show|tree WIT|
|000003a0| 48 20 31 2c 30 0d 0a 20 | 20 20 41 43 54 49 56 41 |H 1,0.. |  ACTIVA|
|000003b0| 54 45 20 57 49 4e 44 4f | 57 20 74 72 65 65 77 69 |TE WINDO|W treewi|
|000003c0| 6e 64 0d 0a 45 4e 44 49 | 46 0d 0a 00 00 00 00 00 |nd..ENDI|F.......|
|000003d0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000003e0| 00 01 00 00 06 4c 2a 20 | 53 61 76 65 20 74 68 65 |.....L* |Save the|
|000003f0| 20 64 61 74 61 62 61 73 | 65 73 2c 20 65 74 63 2e | databas|es, etc.|
|00000400| 20 74 68 61 74 20 61 72 | 65 20 6f 70 65 6e 20 73 | that ar|e open s|
|00000410| 6f 20 74 68 61 74 20 77 | 65 20 63 61 6e 20 72 65 |o that w|e can re|
|00000420| 73 74 6f 72 65 0d 0a 2a | 20 74 68 65 20 65 6e 76 |store..*| the env|
|00000430| 69 72 6f 6e 6d 65 6e 74 | 20 70 72 6f 70 65 72 6c |ironment| properl|
|00000440| 79 20 69 66 20 74 68 65 | 20 75 73 65 72 20 6f 70 |y if the| user op|
|00000450| 65 6e 73 20 61 20 6c 6f | 74 20 6f 66 20 64 61 74 |ens a lo|t of dat|
|00000460| 61 62 61 73 65 73 0d 0a | 2a 20 28 62 79 20 61 64 |abases..|* (by ad|
|00000470| 64 69 6e 67 20 74 68 65 | 6d 20 74 6f 20 74 68 65 |ding the|m to the|
|00000480| 20 72 65 6c 61 74 69 6f | 6e 73 29 20 61 6e 64 20 | relatio|ns) and |
|00000490| 74 68 65 6e 20 70 72 65 | 73 73 65 73 20 63 61 6e |then pre|sses can|
|000004a0| 63 65 6c 2e 0d 0a 43 52 | 45 41 54 45 20 56 49 45 |cel...CR|EATE VIE|
|000004b0| 57 20 64 62 66 73 65 6c | 65 63 2e 76 75 65 0d 0a |W dbfsel|ec.vue..|
|000004c0| 0d 0a 49 46 20 54 59 50 | 45 28 27 44 42 46 4c 49 |..IF TYP|E('DBFLI|
|000004d0| 53 54 27 29 20 3d 20 27 | 55 27 0d 0a 20 20 20 49 |ST') = '|U'..   I|
|000004e0| 46 20 6d 2e 6e 65 78 74 | 64 62 66 20 3d 20 30 0d |F m.next|dbf = 0.|
|000004f0| 0a 0d 0a 20 20 20 20 20 | 20 44 4f 20 69 6e 69 74 |...     | DO init|
|00000500| 64 62 66 6c 69 73 74 0d | 0a 0d 0a 20 20 20 20 20 |dbflist.|...     |
|00000510| 20 2a 20 44 65 66 61 75 | 6c 74 20 6d 61 69 6e 20 | * Defau|lt main |
|00000520| 64 61 74 61 62 61 73 65 | 20 74 6f 20 74 68 65 20 |database| to the |
|00000530| 6f 6e 65 20 74 68 61 74 | 20 69 73 20 63 75 72 72 |one that| is curr|
|00000540| 65 6e 74 6c 79 20 6f 70 | 65 6e 0d 0a 20 20 20 20 |ently op|en..    |
|00000550| 20 20 49 46 20 21 45 4d | 50 54 59 28 41 4c 49 41 |  IF !EM|PTY(ALIA|
|00000560| 53 28 29 29 0d 0a 20 20 | 20 20 20 20 20 20 20 64 |S())..  |       d|
|00000570| 62 66 6c 69 73 74 5b 31 | 2c 6d 2e 63 73 74 65 6d |bflist[1|,m.cstem|
|00000580| 6e 75 6d 5d 20 3d 20 41 | 4c 49 41 53 28 29 0d 0a |num] = A|LIAS()..|
|00000590| 20 20 20 20 20 20 20 20 | 20 64 62 66 6c 69 73 74 |        | dbflist|
|000005a0| 5b 31 2c 6d 2e 63 64 62 | 66 6e 75 6d 5d 20 20 3d |[1,m.cdb|fnum]  =|
|000005b0| 20 46 55 4c 4c 50 41 54 | 48 28 44 42 46 28 29 29 | FULLPAT|H(DBF())|
|000005c0| 0d 0a 20 20 20 20 20 20 | 20 20 20 6d 2e 6e 65 78 |..      |   m.nex|
|000005d0| 74 64 62 66 20 3d 20 32 | 0d 0a 20 20 20 20 20 20 |tdbf = 2|..      |
|000005e0| 45 4c 53 45 0d 0a 20 20 | 20 20 20 20 20 20 20 2a |ELSE..  |       *|
|000005f0| 20 49 66 20 6e 6f 6e 65 | 20 63 75 72 72 65 6e 74 | If none| current|
|00000600| 6c 79 20 6f 70 65 6e 20 | 28 73 68 6f 75 6c 64 6e |ly open |(shouldn|
|00000610| 27 74 20 68 61 70 70 65 | 6e 29 2c 20 70 72 6f 6d |'t happe|n), prom|
|00000620| 70 74 20 66 6f 72 20 6f | 6e 65 0d 0a 20 20 20 20 |pt for o|ne..    |
|00000630| 20 20 20 20 20 6d 2e 6e | 65 77 64 62 66 20 3d 20 |     m.n|ewdbf = |
|00000640| 47 45 54 46 49 4c 45 28 | 22 44 42 46 22 2c 22 44 |GETFILE(|"DBF","D|
|00000650| 61 74 61 62 61 73 65 20 | 74 6f 20 6f 70 65 6e 3a |atabase |to open:|
|00000660| 22 29 0d 0a 20 20 20 20 | 20 20 20 20 20 49 46 20 |")..    |     IF |
|00000670| 21 45 4d 50 54 59 28 6d | 2e 6e 65 77 64 62 66 29 |!EMPTY(m|.newdbf)|
|00000680| 0d 0a 20 20 20 20 20 20 | 20 20 20 20 20 20 64 62 |..      |      db|
|00000690| 66 6c 69 73 74 5b 31 2c | 6d 2e 63 73 74 65 6d 6e |flist[1,|m.cstemn|
|000006a0| 75 6d 5d 20 3d 20 6a 75 | 73 74 73 74 65 6d 28 6d |um] = ju|ststem(m|
|000006b0| 2e 6e 65 77 64 62 66 29 | 0d 0a 20 20 20 20 20 20 |.newdbf)|..      |
|000006c0| 20 20 20 20 20 20 64 62 | 66 6c 69 73 74 5b 31 2c |      db|flist[1,|
|000006d0| 6d 2e 63 64 62 66 6e 75 | 6d 5d 20 3d 20 6d 2e 6e |m.cdbfnu|m] = m.n|
|000006e0| 65 77 64 62 66 0d 0a 0d | 0a 20 20 20 20 20 20 20 |ewdbf...|.       |
|000006f0| 20 20 20 20 20 49 46 20 | 55 53 45 44 28 64 62 66 |     IF |USED(dbf|
|00000700| 6c 69 73 74 5b 31 2c 6d | 2e 63 73 74 65 6d 6e 75 |list[1,m|.cstemnu|
|00000710| 6d 5d 29 0d 0a 20 20 20 | 20 20 20 20 20 20 20 20 |m])..   |        |
|00000720| 20 20 20 20 53 45 4c 45 | 43 54 20 28 64 62 66 6c |    SELE|CT (dbfl|
|00000730| 69 73 74 5b 31 2c 6d 2e | 63 73 74 65 6d 6e 75 6d |ist[1,m.|cstemnum|
|00000740| 5d 29 0d 0a 20 20 20 20 | 20 20 20 20 20 20 20 20 |])..    |        |
|00000750| 45 4c 53 45 0d 0a 20 20 | 20 20 20 20 20 20 20 20 |ELSE..  |        |
|00000760| 20 20 20 20 20 53 45 4c | 45 43 54 20 30 0d 0a 20 |     SEL|ECT 0.. |
|00000770| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 55 53 |        |      US|
|00000780| 45 20 28 6d 2e 6e 65 77 | 64 62 66 29 0d 0a 20 20 |E (m.new|dbf)..  |
|00000790| 20 20 20 20 20 20 20 20 | 20 20 45 4e 44 49 46 0d |        |  ENDIF.|
|000007a0| 0a 20 20 20 20 20 20 20 | 20 20 45 4c 53 45 0d 0a |.       |  ELSE..|
|000007b0| 20 20 20 20 20 20 20 20 | 20 20 20 20 52 45 54 55 |        |    RETU|
|000007c0| 52 4e 0d 0a 20 20 20 20 | 20 20 20 20 20 45 4e 44 |RN..    |     END|
|000007d0| 49 46 0d 0a 20 20 20 20 | 20 20 20 20 20 6d 2e 6e |IF..    |     m.n|
|000007e0| 65 78 74 64 62 66 20 3d | 20 31 0d 0a 20 20 20 20 |extdbf =| 1..    |
|000007f0| 20 20 45 4e 44 49 46 0d | 0a 20 20 20 20 20 20 6d |  ENDIF.|.      m|
|00000800| 2e 64 62 66 73 65 6c 65 | 63 20 3d 20 31 0d 0a 20 |.dbfsele|c = 1.. |
|00000810| 20 20 45 4e 44 49 46 0d | 0a 45 4c 53 45 20 20 20 |  ENDIF.|.ELSE   |
|00000820| 26 26 20 66 69 67 75 72 | 65 20 6f 75 74 20 77 68 |&& figur|e out wh|
|00000830| 69 63 68 20 69 73 20 74 | 68 65 20 6e 65 78 74 20 |ich is t|he next |
|00000840| 61 76 61 69 6c 61 62 6c | 65 20 44 42 46 6c 69 73 |availabl|e DBFlis|
|00000850| 74 20 73 6c 6f 74 0d 0a | 20 20 20 46 4f 52 20 69 |t slot..|   FOR i|
|00000860| 20 3d 20 31 20 54 4f 20 | 6d 2e 6e 75 6d 61 72 65 | = 1 TO |m.numare|
|00000870| 61 73 0d 0a 20 20 20 20 | 20 20 49 46 20 45 4d 50 |as..    |  IF EMP|
|00000880| 54 59 28 64 62 66 6c 69 | 73 74 5b 69 2c 6d 2e 63 |TY(dbfli|st[i,m.c|
|00000890| 73 74 65 6d 6e 75 6d 5d | 29 20 4f 52 20 64 62 66 |stemnum]|) OR dbf|
|000008a0| 6c 69 73 74 5b 69 2c 6d | 2e 63 73 74 65 6d 6e 75 |list[i,m|.cstemnu|
|000008b0| 6d 5d 20 3d 20 27 5c 27 | 0d 0a 20 20 20 20 20 20 |m] = '\'|..      |
|000008c0| 20 20 20 6d 2e 6e 65 78 | 74 64 62 66 20 3d 20 69 |   m.nex|tdbf = i|
|000008d0| 0d 0a 20 20 20 20 20 20 | 20 20 20 45 58 49 54 0d |..      |   EXIT.|
|000008e0| 0a 20 20 20 20 20 20 45 | 4e 44 49 46 0d 0a 20 20 |.      E|NDIF..  |
|000008f0| 20 45 4e 44 46 4f 52 0d | 0a 45 4e 44 49 46 0d 0a | ENDFOR.|.ENDIF..|
|00000900| 0d 0a 2a 20 53 74 6f 72 | 65 20 74 68 65 20 63 75 |..* Stor|e the cu|
|00000910| 72 72 65 6e 74 20 64 62 | 66 6c 69 73 74 20 69 6e |rrent db|flist in|
|00000920| 20 22 6f 72 69 67 64 62 | 66 6c 69 73 74 22 20 73 | "origdb|flist" s|
|00000930| 6f 20 74 68 61 74 20 77 | 65 20 63 61 6e 20 72 65 |o that w|e can re|
|00000940| 73 74 6f 72 65 20 69 74 | 0d 0a 2a 20 69 66 20 22 |store it|..* if "|
|00000950| 63 61 6e 63 65 6c 22 20 | 69 73 20 70 72 65 73 73 |cancel" |is press|
|00000960| 65 64 2e 20 20 41 6c 73 | 6f 20 73 74 6f 72 65 20 |ed.  Als|o store |
|00000970| 74 68 65 20 63 75 72 72 | 65 6e 74 20 22 6e 65 78 |the curr|ent "nex|
|00000980| 74 64 62 66 22 20 76 61 | 6c 75 65 2e 0d 0a 52 45 |tdbf" va|lue...RE|
|00000990| 4c 45 41 53 45 20 6f 72 | 69 67 64 62 66 6c 69 73 |LEASE or|igdbflis|
|000009a0| 74 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |t       |        |
|000009b0| 20 20 20 20 20 20 20 20 | 20 26 26 20 69 66 20 69 |        | && if i|
|000009c0| 74 20 61 6c 72 65 61 64 | 79 20 65 78 69 73 74 73 |t alread|y exists|
|000009d0| 0d 0a 50 55 42 4c 49 43 | 20 6f 72 69 67 64 62 66 |..PUBLIC| origdbf|
|000009e0| 6c 69 73 74 5b 6d 2e 6e | 75 6d 61 72 65 61 73 2c |list[m.n|umareas,|
|000009f0| 6d 2e 6e 75 6d 63 6f 6c | 73 5d 0d 0a 3d 41 43 4f |m.numcol|s]..=ACO|
|00000a00| 50 59 28 64 62 66 6c 69 | 73 74 2c 6f 72 69 67 64 |PY(dbfli|st,origd|
|00000a10| 62 66 6c 69 73 74 29 0d | 0a 6f 72 69 67 6e 65 78 |bflist).|.orignex|
|00000a20| 74 64 62 66 20 3d 20 6e | 65 78 74 64 62 66 0d 0a |tdbf = n|extdbf..|
|00000a30| 0d 0a 00 00 00 00 00 00 | 00 00 00 00 00 00 00 6a |........|.......j|
|00000a40| 69 6d 6d 63 00 00 00 00 | 00 00 65 78 63 65 6c 00 |immc....|..excel.|
|00000a50| 00 00 00 01 00 00 0e c4 | 2a 20 47 65 74 20 72 69 |........|* Get ri|
|00000a60| 64 20 6f 66 20 74 68 65 | 20 74 72 65 65 20 77 69 |d of the| tree wi|
|00000a70| 6e 64 6f 77 20 69 66 20 | 69 74 20 69 73 20 73 74 |ndow if |it is st|
|00000a80| 69 6c 6c 20 61 72 6f 75 | 6e 64 0d 0a 49 46 20 57 |ill arou|nd..IF W|
|00000a90| 45 58 49 53 54 28 27 74 | 72 65 65 77 69 6e 64 27 |EXIST('t|reewind'|
|00000aa0| 29 0d 0a 20 20 20 52 45 | 4c 45 41 53 45 20 57 49 |)..   RE|LEASE WI|
|00000ab0| 4e 44 4f 57 20 74 72 65 | 65 77 69 6e 64 0d 0a 45 |NDOW tre|ewind..E|
|00000ac0| 4e 44 49 46 0d 0a 0d 0a | 2a 21 2a 2a 2a 2a 2a 2a |NDIF....|*!******|
|00000ad0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00000ae0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00000af0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00000b00| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 0d 0a 2a 21 0d |********|***..*!.|
|00000b10| 0a 2a 21 20 20 20 20 20 | 20 50 72 6f 63 65 64 75 |.*!     | Procedu|
|00000b20| 72 65 3a 20 41 52 52 53 | 41 56 45 0d 0a 2a 21 0d |re: ARRS|AVE..*!.|
|00000b30| 0a 2a 21 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |.*!*****|********|
|00000b40| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00000b50| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00000b60| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00000b70| 2a 2a 2a 2a 0d 0a 50 52 | 4f 43 45 44 55 52 45 20 |****..PR|OCEDURE |
|00000b80| 61 72 72 73 61 76 65 0d | 0a 2a 20 53 61 76 65 20 |arrsave.|.* Save |
|00000b90| 61 72 72 61 6e 67 65 6d | 65 6e 74 20 6f 66 20 77 |arrangem|ent of w|
|00000ba0| 69 6e 64 6f 77 73 20 61 | 6e 64 20 72 65 74 75 72 |indows a|nd retur|
|00000bb0| 6e 20 74 6f 20 64 62 66 | 73 65 6c 65 63 74 20 73 |n to dbf|select s|
|00000bc0| 63 72 65 65 6e 0d 0a 0d | 0a 2a 20 53 65 74 20 65 |creen...|.* Set e|
|00000bd0| 78 69 74 20 66 6c 61 67 | 20 66 6f 72 20 52 45 41 |xit flag| for REA|
|00000be0| 44 20 56 41 4c 49 44 0d | 0a 61 72 72 65 78 66 6c |D VALID.|.arrexfl|
|00000bf0| 67 20 3d 20 2e 54 2e 0d | 0a 0d 0a 2a 20 52 65 63 |g = .T..|...* Rec|
|00000c00| 6f 72 64 20 77 69 6e 64 | 6f 77 20 63 6f 6f 72 64 |ord wind|ow coord|
|00000c10| 69 6e 61 74 65 73 20 61 | 6e 64 20 72 65 6c 65 61 |inates a|nd relea|
|00000c20| 73 65 20 61 6c 6c 20 74 | 68 65 20 61 70 70 6c 69 |se all t|he appli|
|00000c30| 63 61 74 69 6f 6e 20 77 | 69 6e 64 6f 77 73 0d 0a |cation w|indows..|
|00000c40| 6d 2e 63 74 72 6c 72 6f | 77 20 3d 20 49 4e 54 28 |m.ctrlro|w = INT(|
|00000c50| 57 4c 52 4f 57 28 27 43 | 54 52 4c 27 29 29 0d 0a |WLROW('C|TRL'))..|
|00000c60| 6d 2e 63 74 72 6c 63 6f | 6c 20 3d 20 49 4e 54 28 |m.ctrlco|l = INT(|
|00000c70| 57 4c 43 4f 4c 28 27 43 | 54 52 4c 27 29 29 0d 0a |WLCOL('C|TRL'))..|
|00000c80| 52 45 4c 45 41 53 45 20 | 57 49 4e 44 4f 57 20 63 |RELEASE |WINDOW c|
|00000c90| 74 72 6c 0d 0a 0d 0a 46 | 4f 52 20 69 20 3d 20 31 |trl....F|OR i = 1|
|00000ca0| 20 54 4f 20 6d 2e 6e 75 | 6d 61 72 65 61 73 0d 0a | TO m.nu|mareas..|
|00000cb0| 20 20 20 49 46 20 21 45 | 4d 50 54 59 28 64 62 66 |   IF !E|MPTY(dbf|
|00000cc0| 6c 69 73 74 5b 69 2c 6d | 2e 63 73 74 65 6d 6e 75 |list[i,m|.cstemnu|
|00000cd0| 6d 5d 29 20 41 4e 44 20 | 64 62 66 6c 69 73 74 5b |m]) AND |dbflist[|
|00000ce0| 69 2c 6d 2e 63 73 74 65 | 6d 6e 75 6d 5d 20 3c 3e |i,m.cste|mnum] <>|
|00000cf0| 20 27 5c 27 0d 0a 20 20 | 20 20 20 20 64 62 66 6c | '\'..  |    dbfl|
|00000d00| 69 73 74 5b 69 2c 6d 2e | 73 72 6f 77 6e 75 6d 5d |ist[i,m.|srownum]|
|00000d10| 20 3d 20 41 4c 4c 54 52 | 49 4d 28 53 54 52 28 57 | = ALLTR|IM(STR(W|
|00000d20| 4c 52 4f 57 28 64 62 66 | 6c 69 73 74 5b 69 2c 6d |LROW(dbf|list[i,m|
|00000d30| 2e 63 73 74 65 6d 6e 75 | 6d 5d 29 2c 33 29 29 0d |.cstemnu|m]),3)).|
|00000d40| 0a 20 20 20 20 20 20 64 | 62 66 6c 69 73 74 5b 69 |.      d|bflist[i|
|00000d50| 2c 6d 2e 73 63 6f 6c 6e | 75 6d 5d 20 3d 20 41 4c |,m.scoln|um] = AL|
|00000d60| 4c 54 52 49 4d 28 53 54 | 52 28 57 4c 43 4f 4c 28 |LTRIM(ST|R(WLCOL(|
|00000d70| 64 62 66 6c 69 73 74 5b | 69 2c 6d 2e 63 73 74 65 |dbflist[|i,m.cste|
|00000d80| 6d 6e 75 6d 5d 29 2c 33 | 29 29 0d 0a 20 20 20 20 |mnum]),3|))..    |
|00000d90| 20 20 64 62 66 6c 69 73 | 74 5b 69 2c 6d 2e 65 72 |  dbflis|t[i,m.er|
|00000da0| 6f 77 6e 75 6d 5d 20 3d | 20 3b 0d 0a 20 20 20 20 |ownum] =| ;..    |
|00000db0| 20 20 20 20 20 41 4c 4c | 54 52 49 4d 28 53 54 52 |     ALL|TRIM(STR|
|00000dc0| 28 56 41 4c 28 64 62 66 | 6c 69 73 74 5b 69 2c 6d |(VAL(dbf|list[i,m|
|00000dd0| 2e 73 72 6f 77 6e 75 6d | 5d 29 3b 0d 0a 20 20 20 |.srownum|]);..   |
|00000de0| 20 20 20 20 20 20 2b 31 | 2b 77 72 6f 77 28 64 62 |      +1|+wrow(db|
|00000df0| 66 6c 69 73 74 5b 69 2c | 6d 2e 63 73 74 65 6d 6e |flist[i,|m.cstemn|
|00000e00| 75 6d 5d 29 2c 33 29 29 | 0d 0a 20 20 20 20 20 20 |um]),3))|..      |
|00000e10| 64 62 66 6c 69 73 74 5b | 69 2c 6d 2e 65 63 6f 6c |dbflist[|i,m.ecol|
|00000e20| 6e 75 6d 5d 20 3d 20 3b | 0d 0a 20 20 20 20 20 20 |num] = ;|..      |
|00000e30| 20 20 20 41 4c 4c 54 52 | 49 4d 28 53 54 52 28 56 |   ALLTR|IM(STR(V|
|00000e40| 41 4c 28 64 62 66 6c 69 | 73 74 5b 69 2c 6d 2e 73 |AL(dbfli|st[i,m.s|
|00000e50| 63 6f 6c 6e 75 6d 5d 29 | 3b 0d 0a 20 20 20 20 20 |colnum])|;..     |
|00000e60| 20 20 20 20 2b 31 2b 77 | 63 6f 6c 28 64 62 66 6c |    +1+w|col(dbfl|
|00000e70| 69 73 74 5b 69 2c 6d 2e | 63 73 74 65 6d 6e 75 6d |ist[i,m.|cstemnum|
|00000e80| 5d 29 2c 33 29 29 0d 0a | 20 20 20 20 20 20 52 45 |]),3))..|      RE|
|00000e90| 4c 45 41 53 45 20 57 49 | 4e 44 4f 57 20 28 64 62 |LEASE WI|NDOW (db|
|00000ea0| 66 6c 69 73 74 5b 69 2c | 6d 2e 63 73 74 65 6d 6e |flist[i,|m.cstemn|
|00000eb0| 75 6d 5d 29 0d 0a 20 20 | 20 45 4e 44 49 46 0d 0a |um])..  | ENDIF..|
|00000ec0| 20 20 20 64 62 66 6c 69 | 73 74 5b 69 2c 6d 2e 61 |   dbfli|st[i,m.a|
|00000ed0| 72 72 61 6e 67 65 64 5d | 20 3d 20 22 59 22 0d 0a |rranged]| = "Y"..|
|00000ee0| 45 4e 44 46 4f 52 0d 0a | 0d 0a 2a 20 52 65 73 74 |ENDFOR..|..* Rest|
|00000ef0| 6f 72 65 20 65 6e 76 69 | 72 6f 6e 6d 65 6e 74 20 |ore envi|ronment |
|00000f00| 0d 0a 50 4f 50 20 4d 45 | 4e 55 20 5f 6d 73 79 73 |..POP ME|NU _msys|
|00000f10| 6d 65 6e 75 0d 0a 53 48 | 4f 57 20 57 49 4e 44 4f |menu..SH|OW WINDO|
|00000f20| 57 20 61 70 70 67 65 6e | 2c 20 64 62 66 73 65 6c |W appgen|, dbfsel|
|00000f30| 65 63 0d 0a 41 43 54 49 | 56 41 54 45 20 57 49 4e |ec..ACTI|VATE WIN|
|00000f40| 44 4f 57 20 64 62 66 73 | 65 6c 65 63 0d 0a 0d 0a |DOW dbfs|elec....|
|00000f50| 43 4c 45 41 52 20 52 45 | 41 44 0d 0a 0d 0a 52 45 |CLEAR RE|AD....RE|
|00000f60| 54 55 52 4e 0d 0a 0d 0a | 0d 0a 0d 0a 2a 21 2a 2a |TURN....|....*!**|
|00000f70| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00000f80| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00000f90| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00000fa0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 0d |********|*******.|
|00000fb0| 0a 2a 21 0d 0a 2a 21 20 | 20 20 20 20 20 50 72 6f |.*!..*! |     Pro|
|00000fc0| 63 65 64 75 72 65 3a 20 | 41 52 52 45 58 49 54 0d |cedure: |ARREXIT.|
|00000fd0| 0a 2a 21 0d 0a 2a 21 2a | 2a 2a 2a 2a 2a 2a 2a 2a |.*!..*!*|********|
|00000fe0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00000ff0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00001000| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00001010| 2a 2a 2a 2a 2a 2a 2a 2a | 0d 0a 50 52 4f 43 45 44 |********|..PROCED|
|00001020| 55 52 45 20 61 72 72 65 | 78 69 74 0d 0a 2a 20 45 |URE arre|xit..* E|
|00001030| 78 69 74 20 77 69 74 68 | 6f 75 74 20 73 61 76 69 |xit with|out savi|
|00001040| 6e 67 20 77 69 6e 64 6f | 77 20 70 6f 73 69 74 69 |ng windo|w positi|
|00001050| 6f 6e 73 0d 0a 0d 0a 2a | 20 53 65 74 20 65 78 69 |ons....*| Set exi|
|00001060| 74 20 66 6c 61 67 20 66 | 6f 72 20 52 45 41 44 20 |t flag f|or READ |
|00001070| 56 41 4c 49 44 0d 0a 61 | 72 72 65 78 66 6c 67 20 |VALID..a|rrexflg |
|00001080| 3d 20 2e 54 2e 0d 0a 0d | 0a 2a 20 52 65 6c 65 61 |= .T....|.* Relea|
|00001090| 73 65 20 61 6c 6c 20 74 | 68 65 20 61 70 70 6c 69 |se all t|he appli|
|000010a0| 63 61 74 69 6f 6e 20 77 | 69 6e 64 6f 77 73 0d 0a |cation w|indows..|
|000010b0| 52 45 4c 45 41 53 45 20 | 57 49 4e 44 4f 57 20 63 |RELEASE |WINDOW c|
|000010c0| 74 72 6c 0d 0a 46 4f 52 | 20 69 20 3d 20 31 20 54 |trl..FOR| i = 1 T|
|000010d0| 4f 20 6d 2e 6e 75 6d 61 | 72 65 61 73 0d 0a 20 20 |O m.numa|reas..  |
|000010e0| 20 49 46 20 21 45 4d 50 | 54 59 28 64 62 66 6c 69 | IF !EMP|TY(dbfli|
|000010f0| 73 74 5b 69 2c 6d 2e 63 | 73 74 65 6d 6e 75 6d 5d |st[i,m.c|stemnum]|
|00001100| 29 20 41 4e 44 20 64 62 | 66 6c 69 73 74 5b 69 2c |) AND db|flist[i,|
|00001110| 6d 2e 63 73 74 65 6d 6e | 75 6d 5d 20 3c 3e 20 27 |m.cstemn|um] <> '|
|00001120| 5c 27 0d 0a 20 20 20 20 | 20 20 52 45 4c 45 41 53 |\'..    |  RELEAS|
|00001130| 45 20 57 49 4e 44 4f 57 | 20 28 64 62 66 6c 69 73 |E WINDOW| (dbflis|
|00001140| 74 5b 69 2c 6d 2e 63 73 | 74 65 6d 6e 75 6d 5d 29 |t[i,m.cs|temnum])|
|00001150| 0d 0a 20 20 20 45 4e 44 | 49 46 0d 0a 45 4e 44 46 |..   END|IF..ENDF|
|00001160| 4f 52 0d 0a 0d 0a 2a 20 | 52 65 73 74 6f 72 65 20 |OR....* |Restore |
|00001170| 65 6e 76 69 72 6f 6e 6d | 65 6e 74 20 0d 0a 50 4f |environm|ent ..PO|
|00001180| 50 20 4d 45 4e 55 20 5f | 6d 73 79 73 6d 65 6e 75 |P MENU _|msysmenu|
|00001190| 0d 0a 53 48 4f 57 20 57 | 49 4e 44 4f 57 20 61 70 |..SHOW W|INDOW ap|
|000011a0| 70 67 65 6e 2c 20 64 62 | 66 73 65 6c 65 63 0d 0a |pgen, db|fselec..|
|000011b0| 41 43 54 49 56 41 54 45 | 20 57 49 4e 44 4f 57 20 |ACTIVATE| WINDOW |
|000011c0| 64 62 66 73 65 6c 65 63 | 0d 0a 0d 0a 43 4c 45 41 |dbfselec|....CLEA|
|000011d0| 52 20 52 45 41 44 0d 0a | 0d 0a 52 45 54 55 52 4e |R READ..|..RETURN|
|000011e0| 0d 0a 0d 0a 0d 0a 2a 21 | 2a 2a 2a 2a 2a 2a 2a 2a |......*!|********|
|000011f0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00001200| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00001210| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00001220| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 0d 0a 2a 21 0d 0a 2a |********|*..*!..*|
|00001230| 21 20 20 20 20 20 20 50 | 72 6f 63 65 64 75 72 65 |!      P|rocedure|
|00001240| 3a 20 48 41 53 43 48 49 | 4c 44 0d 0a 2a 21 0d 0a |: HASCHI|LD..*!..|
|00001250| 2a 21 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |*!******|********|
|00001260| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00001270| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00001280| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00001290| 2a 2a 2a 0d 0a 46 55 4e | 43 54 49 4f 4e 20 68 61 |***..FUN|CTION ha|
|000012a0| 73 63 68 69 6c 64 0d 0a | 2a 20 44 6f 65 73 20 74 |schild..|* Does t|
|000012b0| 68 65 20 64 61 74 61 62 | 61 73 65 20 61 74 20 70 |he datab|ase at p|
|000012c0| 6f 73 69 74 69 6f 6e 20 | 22 64 62 66 6e 75 6d 22 |osition |"dbfnum"|
|000012d0| 20 6f 66 20 44 42 46 4c | 49 53 54 20 68 61 76 65 | of DBFL|IST have|
|000012e0| 20 61 20 63 68 69 6c 64 | 0d 0a 2a 20 74 61 62 6c | a child|..* tabl|
|000012f0| 65 3f 0d 0a 70 61 72 61 | 6d 65 74 65 72 20 64 62 |e?..para|meter db|
|00001300| 66 6e 75 6d 0d 0a 50 52 | 49 56 41 54 45 20 64 62 |fnum..PR|IVATE db|
|00001310| 66 6e 75 6d 2c 20 69 0d | 0a 0d 0a 2a 20 53 65 65 |fnum, i.|...* See|
|00001320| 20 69 66 20 61 6e 6f 74 | 68 65 72 20 64 61 74 61 | if anot|her data|
|00001330| 62 61 73 65 20 68 61 73 | 20 74 68 69 73 20 6f 6e |base has| this on|
|00001340| 65 20 61 73 20 69 74 73 | 20 70 61 72 65 6e 74 0d |e as its| parent.|
|00001350| 0a 46 4f 52 20 6d 2e 69 | 20 3d 20 31 20 54 4f 20 |.FOR m.i| = 1 TO |
|00001360| 6d 2e 6e 75 6d 61 72 65 | 61 73 0d 0a 20 20 20 49 |m.numare|as..   I|
|00001370| 46 20 41 4c 4c 54 52 49 | 4d 28 64 62 66 6c 69 73 |F ALLTRI|M(dbflis|
|00001380| 74 5b 6d 2e 69 2c 6d 2e | 70 64 62 66 6e 75 6d 5d |t[m.i,m.|pdbfnum]|
|00001390| 29 20 3b 0d 0a 20 20 20 | 20 20 20 20 20 20 3d 3d |) ;..   |      ==|
|000013a0| 20 41 4c 4c 54 52 49 4d | 28 64 62 66 6c 69 73 74 | ALLTRIM|(dbflist|
|000013b0| 5b 6d 2e 64 62 66 6e 75 | 6d 2c 6d 2e 63 73 74 65 |[m.dbfnu|m,m.cste|
|000013c0| 6d 6e 75 6d 5d 29 0d 0a | 20 20 20 20 20 20 52 45 |mnum])..|      RE|
|000013d0| 54 55 52 4e 20 2e 54 2e | 0d 0a 20 20 20 45 4e 44 |TURN .T.|..   END|
|000013e0| 49 46 0d 0a 45 4e 44 46 | 4f 52 0d 0a 52 45 54 55 |IF..ENDF|OR..RETU|
|000013f0| 52 4e 20 2e 46 2e 0d 0a | 0d 0a 2a 21 2a 2a 2a 2a |RN .F...|..*!****|
|00001400| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00001410| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00001420| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00001430| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 0d 0a 2a |********|*****..*|
|00001440| 21 0d 0a 2a 21 20 20 20 | 20 20 20 50 72 6f 63 65 |!..*!   |   Proce|
|00001450| 64 75 72 65 3a 20 53 48 | 4f 57 54 52 45 45 0d 0a |dure: SH|OWTREE..|
|00001460| 2a 21 0d 0a 2a 21 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |*!..*!**|********|
|00001470| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00001480| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00001490| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|000014a0| 2a 2a 2a 2a 2a 2a 2a 0d | 0a 50 52 4f 43 45 44 55 |*******.|.PROCEDU|
|000014b0| 52 45 20 73 68 6f 77 74 | 72 65 65 0d 0a 70 61 72 |RE showt|ree..par|
|000014c0| 61 6d 65 74 65 72 20 64 | 62 66 6e 75 6d 2c 20 69 |ameter d|bfnum, i|
|000014d0| 6e 64 65 6e 74 0d 0a 50 | 52 49 56 41 54 45 20 64 |ndent..P|RIVATE d|
|000014e0| 62 66 6e 75 6d 2c 20 69 | 6e 64 65 6e 74 0d 0a 2a |bfnum, i|ndent..*|
|000014f0| 20 52 65 63 75 72 73 69 | 76 65 20 72 6f 75 74 69 | Recursi|ve routi|
|00001500| 6e 65 20 74 6f 20 64 69 | 73 70 6c 61 79 20 61 20 |ne to di|splay a |
|00001510| 74 72 65 65 20 64 69 61 | 67 72 61 6d 20 6f 66 20 |tree dia|gram of |
|00001520| 64 61 74 61 62 61 73 65 | 20 72 65 6c 61 74 69 6f |database| relatio|
|00001530| 6e 73 68 69 70 73 2e 0d | 0a 0d 0a 2a 20 54 68 65 |nships..|...* The|
|00001540| 20 77 69 6e 64 6f 77 20 | 69 6e 20 77 68 69 63 68 | window |in which|
|00001550| 20 74 6f 20 64 69 73 70 | 6c 61 79 20 74 68 65 20 | to disp|lay the |
|00001560| 74 72 65 65 20 6d 75 73 | 74 20 62 65 20 61 63 74 |tree mus|t be act|
|00001570| 69 76 61 74 65 64 20 62 | 65 66 6f 72 65 0d 0a 2a |ivated b|efore..*|
|00001580| 20 63 61 6c 6c 69 6e 67 | 20 73 68 6f 77 74 72 65 | calling| showtre|
|00001590| 65 2e 0d 0a 0d 0a 2a 20 | 46 69 72 73 74 20 64 69 |e.....* |First di|
|000015a0| 73 70 6c 61 79 20 74 68 | 69 73 20 64 61 74 61 62 |splay th|is datab|
|000015b0| 61 73 65 20 69 6e 20 69 | 74 73 20 63 6f 72 72 65 |ase in i|ts corre|
|000015c0| 63 74 20 70 6f 73 69 74 | 69 6f 6e 20 6f 6e 20 74 |ct posit|ion on t|
|000015d0| 68 65 20 74 72 65 65 2e | 0d 0a 49 46 20 57 45 58 |he tree.|..IF WEX|
|000015e0| 49 53 54 28 27 74 72 65 | 65 77 69 6e 64 27 29 0d |IST('tre|ewind').|
|000015f0| 0a 20 20 20 74 72 65 65 | 73 74 72 20 3d 20 53 50 |.   tree|str = SP|
|00001600| 41 43 45 28 4d 41 58 28 | 6d 2e 69 6e 64 65 6e 74 |ACE(MAX(|m.indent|
|00001610| 2d 31 2c 30 29 2a 33 29 | 3b 0d 0a 20 20 20 20 20 |-1,0)*3)|;..     |
|00001620| 20 2b 49 49 46 28 6d 2e | 69 6e 64 65 6e 74 3c 3e | +IIF(m.|indent<>|
|00001630| 30 2c 43 48 52 28 31 39 | 32 29 2b 43 48 52 28 31 |0,CHR(19|2)+CHR(1|
|00001640| 39 36 29 2b 43 48 52 28 | 32 36 29 2c 27 27 29 3b |96)+CHR(|26),'');|
|00001650| 0d 0a 20 20 20 20 20 20 | 2b 64 62 66 6c 69 73 74 |..      |+dbflist|
|00001660| 5b 6d 2e 64 62 66 6e 75 | 6d 2c 6d 2e 63 73 74 65 |[m.dbfnu|m,m.cste|
|00001670| 6d 6e 75 6d 5d 0d 0a 20 | 20 20 65 6e 64 5f 72 6f |mnum].. |  end_ro|
|00001680| 77 20 3d 20 4d 49 4e 28 | 57 4c 52 4f 57 28 27 74 |w = MIN(|WLROW('t|
|00001690| 72 65 65 77 69 6e 64 27 | 29 20 2b 20 34 20 2b 20 |reewind'|) + 4 + |
|000016a0| 6d 2e 6e 65 78 74 64 62 | 66 2c 20 53 52 4f 57 53 |m.nextdb|f, SROWS|
|000016b0| 28 29 2d 31 29 0d 0a 20 | 20 20 49 46 20 4c 45 4e |()-1).. |  IF LEN|
|000016c0| 28 74 72 65 65 73 74 72 | 29 20 3e 3d 20 57 43 4f |(treestr|) >= WCO|
|000016d0| 4c 53 28 29 20 2d 20 32 | 0d 0a 20 20 20 20 20 20 |LS() - 2|..      |
|000016e0| 73 5f 63 6f 6c 20 3d 20 | 57 4c 43 4f 4c 28 27 74 |s_col = |WLCOL('t|
|000016f0| 72 65 65 77 69 6e 64 27 | 29 0d 0a 20 20 20 20 20 |reewind'|)..     |
|00001700| 20 2a 20 4d 6f 76 65 20 | 74 68 65 20 77 69 6e 64 | * Move |the wind|
|00001710| 6f 77 20 74 6f 20 74 68 | 65 20 6c 65 66 74 20 69 |ow to th|e left i|
|00001720| 66 20 6e 65 63 65 73 73 | 61 72 79 0d 0a 20 20 20 |f necess|ary..   |
|00001730| 20 20 20 49 46 20 73 5f | 63 6f 6c 20 2b 20 4c 45 |   IF s_|col + LE|
|00001740| 4e 28 74 72 65 65 73 74 | 72 29 20 2b 20 33 20 3e |N(treest|r) + 3 >|
|00001750| 3d 20 53 43 4f 4c 53 28 | 29 20 2d 20 33 0d 0a 20 |= SCOLS(|) - 3.. |
|00001760| 20 20 20 20 20 20 20 20 | 73 5f 63 6f 6c 20 3d 20 |        |s_col = |
|00001770| 53 43 4f 4c 53 28 29 20 | 2d 20 4c 45 4e 28 74 72 |SCOLS() |- LEN(tr|
|00001780| 65 65 73 74 72 29 20 2d | 20 36 0d 0a 20 20 20 20 |eestr) -| 6..    |
|00001790| 20 20 45 4e 44 49 46 0d | 0a 20 20 20 20 20 20 5a |  ENDIF.|.      Z|
|000017a0| 4f 4f 4d 20 57 49 4e 44 | 4f 57 20 74 72 65 65 77 |OOM WIND|OW treew|
|000017b0| 69 6e 64 20 4e 4f 52 4d | 20 3b 0d 0a 20 20 20 20 |ind NORM| ;..    |
|000017c0| 20 20 20 20 20 46 52 4f | 4d 20 57 4c 52 4f 57 28 |     FRO|M WLROW(|
|000017d0| 27 74 72 65 65 77 69 6e | 64 27 29 2c 73 5f 63 6f |'treewin|d'),s_co|
|000017e0| 6c 20 54 4f 20 65 6e 64 | 5f 72 6f 77 2c 20 73 5f |l TO end|_row, s_|
|000017f0| 63 6f 6c 2b 4c 45 4e 28 | 74 72 65 65 73 74 72 29 |col+LEN(|treestr)|
|00001800| 2b 34 0d 0a 20 20 20 45 | 4e 44 49 46 0d 0a 20 20 |+4..   E|NDIF..  |
|00001810| 20 3f 20 74 72 65 65 73 | 74 72 0d 0a 45 4c 53 45 | ? trees|tr..ELSE|
|00001820| 0d 0a 20 20 20 52 45 54 | 55 52 4e 0d 0a 45 4e 44 |..   RET|URN..END|
|00001830| 49 46 0d 0a 0d 0a 2a 20 | 46 69 6e 64 20 61 6e 79 |IF....* |Find any|
|00001840| 20 63 68 69 6c 64 72 65 | 6e 20 6f 66 20 74 68 69 | childre|n of thi|
|00001850| 73 20 64 61 74 61 62 61 | 73 65 20 61 6e 64 20 64 |s databa|se and d|
|00001860| 69 73 70 6c 61 79 20 74 | 68 65 6d 0d 0a 46 4f 52 |isplay t|hem..FOR|
|00001870| 20 69 20 3d 20 31 20 54 | 4f 20 6d 2e 6e 75 6d 61 | i = 1 T|O m.numa|
|00001880| 72 65 61 73 0d 0a 20 20 | 20 49 46 20 41 4c 4c 54 |reas..  | IF ALLT|
|00001890| 52 49 4d 28 64 62 66 6c | 69 73 74 5b 6d 2e 69 2c |RIM(dbfl|ist[m.i,|
|000018a0| 6d 2e 70 64 62 66 6e 75 | 6d 5d 29 20 3b 0d 0a 20 |m.pdbfnu|m]) ;.. |
|000018b0| 20 20 20 20 20 20 20 20 | 3d 3d 20 41 4c 4c 54 52 |        |== ALLTR|
|000018c0| 49 4d 28 64 62 66 6c 69 | 73 74 5b 6d 2e 64 62 66 |IM(dbfli|st[m.dbf|
|000018d0| 6e 75 6d 2c 6d 2e 63 73 | 74 65 6d 6e 75 6d 5d 29 |num,m.cs|temnum])|
|000018e0| 0d 0a 20 20 20 20 20 20 | 44 4f 20 73 68 6f 77 74 |..      |DO showt|
|000018f0| 72 65 65 20 57 49 54 48 | 20 69 2c 20 69 6e 64 65 |ree WITH| i, inde|
|00001900| 6e 74 20 2b 20 31 0d 0a | 20 20 20 45 4e 44 49 46 |nt + 1..|   ENDIF|
|00001910| 0d 0a 45 4e 44 46 4f 52 | 0d 0a 0d 0a 12 00 01 00 |..ENDFOR|........|
|00001920| 4a 4d 20 00 00 00 01 00 | 00 00 08 64 62 66 73 65 |JM .....|...dbfse|
|00001930| 6c 65 63 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |lec.....|........|
|00001940| 00 00 00 00 00 00 00 01 | 00 00 00 07 64 62 66 6c |........|....dbfl|
|00001950| 69 73 74 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |ist.....|........|
|00001960| 00 00 00 00 00 00 00 00 | 01 00 00 00 05 22 40 26 |........|....."@&|
|00001970| 4e 22 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |N"......|........|
|00001980| 00 00 00 00 00 00 00 00 | 00 01 00 00 00 0d 4d 53 |........|......MS|
|00001990| 20 53 61 6e 73 20 53 65 | 72 69 66 00 00 00 00 00 | Sans Se|rif.....|
|000019a0| 00 00 00 00 00 00 00 00 | 00 00 01 00 00 05 35 44 |........|......5D|
|000019b0| 4f 20 43 41 53 45 0d 0a | 43 41 53 45 20 6d 2e 64 |O CASE..|CASE m.d|
|000019c0| 62 66 73 65 6c 65 63 20 | 3d 20 30 20 20 26 26 20 |bfselec |= 0  && |
|000019d0| 69 67 6e 6f 72 65 20 61 | 20 6e 75 6c 6c 20 73 65 |ignore a| null se|
|000019e0| 6c 65 63 74 69 6f 6e 0d | 0a 20 20 20 2a 20 54 68 |lection.|.   * Th|
|000019f0| 69 73 20 73 68 6f 75 6c | 64 6e 27 74 20 62 65 20 |is shoul|dn't be |
|00001a00| 70 6f 73 73 69 62 6c 65 | 20 62 65 63 61 75 73 65 |possible| because|
|00001a10| 20 6f 66 20 74 68 65 20 | 57 48 45 4e 20 63 6f 64 | of the |WHEN cod|
|00001a20| 65 2c 0d 0a 20 20 20 2a | 20 62 75 74 20 70 75 74 |e,..   *| but put|
|00001a30| 20 74 68 65 20 76 61 6c | 69 64 61 74 69 6f 6e 20 | the val|idation |
|00001a40| 74 65 73 74 20 69 6e 20 | 6a 75 73 74 20 74 6f 20 |test in |just to |
|00001a50| 62 65 20 73 75 72 65 2e | 0d 0a 20 20 20 52 45 54 |be sure.|..   RET|
|00001a60| 55 52 4e 20 2e 46 2e 0d | 0a 43 41 53 45 20 6d 2e |URN .F..|.CASE m.|
|00001a70| 64 62 66 73 65 6c 65 63 | 20 3d 20 31 0d 0a 20 20 |dbfselec| = 1..  |
|00001a80| 20 57 41 49 54 20 57 49 | 4e 44 4f 57 20 22 4d 61 | WAIT WI|NDOW "Ma|
|00001a90| 69 6e 20 64 61 74 61 62 | 61 73 65 2e 22 20 4e 4f |in datab|ase." NO|
|00001aa0| 57 41 49 54 0d 0a 43 41 | 53 45 20 6d 2e 64 62 66 |WAIT..CA|SE m.dbf|
|00001ab0| 73 65 6c 65 63 20 3e 20 | 31 0d 0a 20 20 20 6d 2e |selec > |1..   m.|
|00001ac0| 6e 65 77 64 62 66 20 20 | 20 20 20 3d 20 64 62 66 |newdbf  |   = dbf|
|00001ad0| 6c 69 73 74 5b 6d 2e 64 | 62 66 73 65 6c 65 63 2c |list[m.d|bfselec,|
|00001ae0| 6d 2e 63 73 74 65 6d 6e | 75 6d 5d 0d 0a 20 20 20 |m.cstemn|um]..   |
|00001af0| 6d 2e 63 68 69 6c 64 66 | 6c 64 20 20 20 3d 20 64 |m.childf|ld   = d|
|00001b00| 62 66 6c 69 73 74 5b 6d | 2e 64 62 66 73 65 6c 65 |bflist[m|.dbfsele|
|00001b10| 63 2c 6d 2e 63 66 6c 64 | 6e 75 6d 5d 0d 0a 20 20 |c,m.cfld|num]..  |
|00001b20| 20 6d 2e 63 68 69 6c 64 | 64 62 66 20 20 20 3d 20 | m.child|dbf   = |
|00001b30| 64 62 66 6c 69 73 74 5b | 6d 2e 64 62 66 73 65 6c |dbflist[|m.dbfsel|
|00001b40| 65 63 2c 6d 2e 63 64 62 | 66 6e 75 6d 5d 0d 0a 20 |ec,m.cdb|fnum].. |
|00001b50| 20 20 6d 2e 70 61 72 65 | 6e 74 66 6c 64 20 20 3d |  m.pare|ntfld  =|
|00001b60| 20 64 62 66 6c 69 73 74 | 5b 6d 2e 64 62 66 73 65 | dbflist|[m.dbfse|
|00001b70| 6c 65 63 2c 6d 2e 70 66 | 6c 64 6e 75 6d 5d 0d 0a |lec,m.pf|ldnum]..|
|00001b80| 20 20 20 6d 2e 69 67 6e | 63 61 73 65 20 20 20 20 |   m.ign|case    |
|00001b90| 3d 20 2e 54 2e 0d 0a 20 | 20 20 6d 2e 72 65 6c 73 |= .T... |  m.rels|
|00001ba0| 74 72 20 20 20 20 20 3d | 20 64 62 66 6c 69 73 74 |tr     =| dbflist|
|00001bb0| 5b 6d 2e 64 62 66 73 65 | 6c 65 63 2c 6d 2e 72 65 |[m.dbfse|lec,m.re|
|00001bc0| 6c 73 74 72 6e 75 6d 5d | 0d 0a 20 20 20 6d 2e 70 |lstrnum]|..   m.p|
|00001bd0| 61 72 65 6e 74 64 62 66 | 20 20 3d 20 64 62 66 6c |arentdbf|  = dbfl|
|00001be0| 69 73 74 5b 6d 2e 64 62 | 66 73 65 6c 65 63 2c 6d |ist[m.db|fselec,m|
|00001bf0| 2e 70 64 62 66 6e 75 6d | 5d 0d 0a 20 20 20 6d 2e |.pdbfnum|]..   m.|
|00001c00| 61 64 64 6d 6f 64 65 20 | 20 20 20 3d 20 2e 46 2e |addmode |   = .F.|
|00001c10| 20 20 20 20 26 26 20 77 | 65 27 72 65 20 65 64 69 |    && w|e're edi|
|00001c20| 74 69 6e 67 20 61 6e 20 | 65 78 69 73 74 69 6e 67 |ting an |existing|
|00001c30| 20 6f 6e 65 0d 0a 0d 0a | 20 20 20 2a 20 46 69 6e | one....|   * Fin|
|00001c40| 64 20 6f 75 74 20 68 6f | 77 20 74 68 69 73 20 64 |d out ho|w this d|
|00001c50| 61 74 61 62 61 73 65 20 | 72 65 6c 61 74 65 73 20 |atabase |relates |
|00001c60| 74 6f 20 74 68 65 20 6f | 74 68 65 72 20 6f 6e 65 |to the o|ther one|
|00001c70| 73 2e 0d 0a 20 20 20 2a | 20 52 65 6c 73 65 6c 65 |s...   *| Relsele|
|00001c80| 63 20 77 69 6c 6c 20 72 | 65 74 75 72 6e 20 61 6e |c will r|eturn an|
|00001c90| 20 65 6d 70 74 79 20 22 | 63 68 69 6c 64 66 6c 64 | empty "|childfld|
|00001ca0| 22 20 69 66 20 63 61 6e | 63 65 6c 20 77 61 73 20 |" if can|cel was |
|00001cb0| 0d 0a 20 20 20 2a 20 70 | 72 65 73 73 65 64 2e 0d |..   * p|ressed..|
|00001cc0| 0a 20 20 20 44 4f 20 72 | 65 6c 73 65 6c 65 63 2e |.   DO r|elselec.|
|00001cd0| 73 70 72 20 57 49 54 48 | 20 6d 2e 6e 65 77 64 62 |spr WITH| m.newdb|
|00001ce0| 66 2c 20 6d 2e 63 68 69 | 6c 64 64 62 66 2c 20 6d |f, m.chi|lddbf, m|
|00001cf0| 2e 63 68 69 6c 64 66 6c | 64 2c 20 6d 2e 70 61 72 |.childfl|d, m.par|
|00001d00| 65 6e 74 66 6c 64 2c 20 | 3b 0d 0a 20 20 20 20 20 |entfld, |;..     |
|00001d10| 20 6d 2e 69 67 6e 63 61 | 73 65 2c 20 6d 2e 72 65 | m.ignca|se, m.re|
|00001d20| 6c 73 74 72 2c 20 6d 2e | 70 61 72 65 6e 74 64 62 |lstr, m.|parentdb|
|00001d30| 66 2c 20 6d 2e 61 64 64 | 6d 6f 64 65 0d 0a 20 20 |f, m.add|mode..  |
|00001d40| 20 49 46 20 21 45 4d 50 | 54 59 28 6d 2e 63 68 69 | IF !EMP|TY(m.chi|
|00001d50| 6c 64 66 6c 64 29 0d 0a | 20 20 20 20 20 20 2a 20 |ldfld)..|      * |
|00001d60| 52 65 63 6f 72 64 20 64 | 61 74 61 20 61 62 6f 75 |Record d|ata abou|
|00001d70| 74 20 74 68 69 73 20 63 | 68 69 6c 64 20 44 42 46 |t this c|hild DBF|
|00001d80| 20 6f 6e 20 74 68 65 20 | 44 42 46 4c 49 53 54 0d | on the |DBFLIST.|
|00001d90| 0a 20 20 20 20 20 20 64 | 62 66 6c 69 73 74 5b 6d |.      d|bflist[m|
|00001da0| 2e 64 62 66 73 65 6c 65 | 63 2c 6d 2e 63 73 74 65 |.dbfsele|c,m.cste|
|00001db0| 6d 6e 75 6d 5d 20 20 3d | 20 6a 75 73 74 73 74 65 |mnum]  =| justste|
|00001dc0| 6d 28 6d 2e 6e 65 77 64 | 62 66 29 0d 0a 20 20 20 |m(m.newd|bf)..   |
|00001dd0| 20 20 20 64 62 66 6c 69 | 73 74 5b 6d 2e 64 62 66 |   dbfli|st[m.dbf|
|00001de0| 73 65 6c 65 63 2c 6d 2e | 72 65 6c 73 74 72 6e 75 |selec,m.|relstrnu|
|00001df0| 6d 5d 20 3d 20 6d 2e 72 | 65 6c 73 74 72 0d 0a 20 |m] = m.r|elstr.. |
|00001e00| 20 20 20 20 20 64 62 66 | 6c 69 73 74 5b 6d 2e 64 |     dbf|list[m.d|
|00001e10| 62 66 73 65 6c 65 63 2c | 6d 2e 70 66 6c 64 6e 75 |bfselec,|m.pfldnu|
|00001e20| 6d 5d 20 20 20 3d 20 6d | 2e 70 61 72 65 6e 74 66 |m]   = m|.parentf|
|00001e30| 6c 64 0d 0a 20 20 20 20 | 20 20 64 62 66 6c 69 73 |ld..    |  dbflis|
|00001e40| 74 5b 6d 2e 64 62 66 73 | 65 6c 65 63 2c 6d 2e 63 |t[m.dbfs|elec,m.c|
|00001e50| 66 6c 64 6e 75 6d 5d 20 | 20 20 3d 20 6d 2e 63 68 |fldnum] |  = m.ch|
|00001e60| 69 6c 64 66 6c 64 0d 0a | 20 20 20 20 20 20 64 62 |ildfld..|      db|
|00001e70| 66 6c 69 73 74 5b 6d 2e | 64 62 66 73 65 6c 65 63 |flist[m.|dbfselec|
|00001e80| 2c 6d 2e 63 64 62 66 6e | 75 6d 5d 20 20 20 3d 20 |,m.cdbfn|um]   = |
|00001e90| 6d 2e 63 68 69 6c 64 64 | 62 66 0d 0a 20 20 20 20 |m.childd|bf..    |
|00001ea0| 20 20 64 62 66 6c 69 73 | 74 5b 6d 2e 64 62 66 73 |  dbflis|t[m.dbfs|
|00001eb0| 65 6c 65 63 2c 6d 2e 70 | 64 62 66 6e 75 6d 5d 20 |elec,m.p|dbfnum] |
|00001ec0| 20 20 3d 20 6d 2e 70 61 | 72 65 6e 74 64 62 66 0d |  = m.pa|rentdbf.|
|00001ed0| 0a 20 20 20 45 4e 44 49 | 46 0d 0a 45 4e 44 43 41 |.   ENDI|F..ENDCA|
|00001ee0| 53 45 0d 0a 6d 69 6c 65 | 79 00 00 00 00 00 00 00 |SE..mile|y.......|
|00001ef0| 00 00 00 01 00 00 00 ef | 49 46 20 64 62 66 73 65 |........|IF dbfse|
|00001f00| 6c 65 63 20 3d 20 30 0d | 0a 20 20 20 64 62 66 73 |lec = 0.|.   dbfs|
|00001f10| 65 6c 65 63 20 3d 20 6d | 2e 6e 65 78 74 64 62 66 |elec = m|.nextdbf|
|00001f20| 20 2d 20 31 0d 0a 20 20 | 20 53 48 4f 57 20 47 45 | - 1..  | SHOW GE|
|00001f30| 54 20 64 62 66 73 65 6c | 65 63 0d 0a 45 4e 44 49 |T dbfsel|ec..ENDI|
|00001f40| 46 0d 0a 0d 0a 44 4f 20 | 43 41 53 45 0d 0a 43 41 |F....DO |CASE..CA|
|00001f50| 53 45 20 64 62 66 73 65 | 6c 65 63 20 3d 20 31 0d |SE dbfse|lec = 1.|
|00001f60| 0a 20 20 20 53 48 4f 57 | 20 47 45 54 20 61 64 64 |.   SHOW| GET add|
|00001f70| 63 6c 72 2c 32 20 44 49 | 53 41 42 4c 45 0d 0a 43 |clr,2 DI|SABLE..C|
|00001f80| 41 53 45 20 68 61 73 63 | 68 69 6c 64 28 64 62 66 |ASE hasc|hild(dbf|
|00001f90| 73 65 6c 65 63 29 0d 0a | 20 20 20 53 48 4f 57 20 |selec)..|   SHOW |
|00001fa0| 47 45 54 20 61 64 64 63 | 6c 72 2c 32 20 44 49 53 |GET addc|lr,2 DIS|
|00001fb0| 41 42 4c 45 0d 0a 4f 54 | 48 45 52 57 49 53 45 0d |ABLE..OT|HERWISE.|
|00001fc0| 0a 20 20 20 53 48 4f 57 | 20 47 45 54 20 61 64 64 |.   SHOW| GET add|
|00001fd0| 63 6c 72 2c 32 20 45 4e | 41 42 4c 45 0d 0a 45 4e |clr,2 EN|ABLE..EN|
|00001fe0| 44 43 41 53 45 0d 0a 00 | 00 00 00 00 00 00 00 00 |DCASE...|........|
|00001ff0| 00 00 00 00 00 00 00 00 | 00 00 00 01 00 00 00 0d |........|........|
|00002000| 4d 53 20 53 61 6e 73 20 | 53 65 72 69 66 00 00 00 |MS Sans |Serif...|
|00002010| 00 00 00 00 00 00 00 00 | 00 00 00 00 01 00 00 00 |........|........|
|00002020| 06 61 64 64 63 6c 72 00 | 00 00 00 00 00 00 00 00 |.addclr.|........|
|00002030| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 01 00 00 |........|........|
|00002040| 00 15 22 40 2a 56 4e 20 | 5c 3c 41 64 64 3b 5c 3c |.."@*VN |\<Add;\<|
|00002050| 44 65 6c 65 74 65 22 00 | 00 00 00 00 00 00 01 00 |Delete".|........|
|00002060| 00 11 c9 44 4f 20 43 41 | 53 45 0d 0a 43 41 53 45 |...DO CA|SE..CASE|
|00002070| 20 6d 2e 61 64 64 63 6c | 72 20 3d 20 31 20 20 20 | m.addcl|r = 1   |
|00002080| 26 26 20 61 64 64 20 61 | 6e 6f 74 68 65 72 20 64 |&& add a|nother d|
|00002090| 61 74 61 62 61 73 65 20 | 74 6f 20 74 68 65 20 70 |atabase |to the p|
|000020a0| 6f 74 0d 0a 20 20 20 49 | 46 20 6d 2e 6e 65 78 74 |ot..   I|F m.next|
|000020b0| 64 62 66 20 3e 3d 20 6d | 2e 6e 75 6d 61 72 65 61 |dbf >= m|.numarea|
|000020c0| 73 0d 0a 20 20 20 20 20 | 20 57 41 49 54 20 57 49 |s..     | WAIT WI|
|000020d0| 4e 44 4f 57 20 22 54 68 | 65 72 65 20 61 72 65 20 |NDOW "Th|ere are |
|000020e0| 6e 6f 20 61 76 61 69 6c | 61 62 6c 65 20 77 6f 72 |no avail|able wor|
|000020f0| 6b 20 61 72 65 61 73 20 | 6c 65 66 74 2e 22 20 4e |k areas |left." N|
|00002100| 4f 57 41 49 54 0d 0a 20 | 20 20 20 20 20 52 45 54 |OWAIT.. |     RET|
|00002110| 55 52 4e 0d 0a 20 20 20 | 45 4e 44 49 46 0d 0a 0d |URN..   |ENDIF...|
|00002120| 0a 20 20 20 2a 20 4f 6e | 6c 79 20 61 63 63 65 70 |.   * On|ly accep|
|00002130| 74 20 44 42 46 20 66 69 | 6c 65 73 2c 20 75 6e 6c |t DBF fi|les, unl|
|00002140| 65 73 73 20 75 73 65 72 | 20 63 61 6e 63 65 6c 73 |ess user| cancels|
|00002150| 0d 0a 20 20 20 6d 2e 6e | 65 77 64 62 66 20 3d 20 |..   m.n|ewdbf = |
|00002160| 22 58 58 58 22 20 20 20 | 26 26 20 61 6e 79 20 76 |"XXX"   |&& any v|
|00002170| 61 6c 75 65 20 6f 74 68 | 65 72 20 74 68 61 6e 20 |alue oth|er than |
|00002180| 62 6c 61 6e 6b 20 6f 72 | 20 61 20 44 42 46 20 66 |blank or| a DBF f|
|00002190| 69 6c 65 0d 0a 20 20 20 | 44 4f 20 57 48 49 4c 45 |ile..   |DO WHILE|
|000021a0| 20 21 45 4d 50 54 59 28 | 6d 2e 6e 65 77 64 62 66 | !EMPTY(|m.newdbf|
|000021b0| 29 20 41 4e 44 20 6a 75 | 73 74 65 78 74 28 6d 2e |) AND ju|stext(m.|
|000021c0| 6e 65 77 64 62 66 29 20 | 3c 3e 20 27 44 42 46 27 |newdbf) |<> 'DBF'|
|000021d0| 0d 0a 20 20 20 20 20 20 | 6d 2e 6e 65 77 64 62 66 |..      |m.newdbf|
|000021e0| 20 3d 20 47 45 54 46 49 | 4c 45 28 27 44 42 46 27 | = GETFI|LE('DBF'|
|000021f0| 2c 27 44 61 74 61 62 61 | 73 65 20 74 6f 20 6f 70 |,'Databa|se to op|
|00002200| 65 6e 3a 27 29 0d 0a 20 | 20 20 45 4e 44 44 4f 0d |en:').. |  ENDDO.|
|00002210| 0a 0d 0a 20 20 20 49 46 | 20 21 45 4d 50 54 59 28 |...   IF| !EMPTY(|
|00002220| 6d 2e 6e 65 77 64 62 66 | 29 0d 0a 20 20 20 20 20 |m.newdbf|)..     |
|00002230| 20 2a 20 43 68 65 63 6b | 20 66 6f 72 20 64 75 70 | * Check| for dup|
|00002240| 6c 69 63 61 74 65 20 44 | 42 46 20 73 74 65 6d 20 |licate D|BF stem |
|00002250| 6e 61 6d 65 0d 0a 20 20 | 20 20 20 20 46 4f 52 20 |name..  |    FOR |
|00002260| 69 20 3d 20 31 20 54 4f | 20 6d 2e 6e 75 6d 61 72 |i = 1 TO| m.numar|
|00002270| 65 61 73 0d 0a 20 20 20 | 20 20 20 20 20 20 49 46 |eas..   |      IF|
|00002280| 20 6a 75 73 74 73 74 65 | 6d 28 6d 2e 6e 65 77 64 | justste|m(m.newd|
|00002290| 62 66 29 20 3d 3d 20 64 | 62 66 6c 69 73 74 5b 69 |bf) == d|bflist[i|
|000022a0| 2c 6d 2e 63 73 74 65 6d | 6e 75 6d 5d 0d 0a 20 20 |,m.cstem|num]..  |
|000022b0| 20 20 20 20 20 20 20 20 | 20 20 57 41 49 54 20 57 |        |  WAIT W|
|000022c0| 49 4e 44 4f 57 20 22 44 | 75 70 6c 69 63 61 74 65 |INDOW "D|uplicate|
|000022d0| 20 64 61 74 61 62 61 73 | 65 20 6e 61 6d 65 73 20 | databas|e names |
|000022e0| 61 72 65 20 6e 6f 74 20 | 61 6c 6c 6f 77 65 64 2e |are not |allowed.|
|000022f0| 22 20 4e 4f 57 41 49 54 | 0d 0a 20 20 20 20 20 20 |" NOWAIT|..      |
|00002300| 20 20 20 20 20 20 52 45 | 54 55 52 4e 0d 0a 20 20 |      RE|TURN..  |
|00002310| 20 20 20 20 20 20 20 45 | 4e 44 49 46 0d 0a 20 20 |       E|NDIF..  |
|00002320| 20 20 20 20 45 4e 44 46 | 4f 52 0d 0a 0d 0a 20 20 |    ENDF|OR....  |
|00002330| 20 20 20 20 6d 2e 63 68 | 69 6c 64 66 6c 64 20 20 |    m.ch|ildfld  |
|00002340| 20 3d 20 22 22 0d 0a 20 | 20 20 20 20 20 6d 2e 63 | = "".. |     m.c|
|00002350| 68 69 6c 64 64 62 66 20 | 20 20 3d 20 6d 2e 6e 65 |hilddbf |  = m.ne|
|00002360| 77 64 62 66 0d 0a 20 20 | 20 20 20 20 6d 2e 6e 65 |wdbf..  |    m.ne|
|00002370| 77 64 62 66 20 20 20 20 | 20 3d 20 6a 75 73 74 73 |wdbf    | = justs|
|00002380| 74 65 6d 28 6d 2e 6e 65 | 77 64 62 66 29 0d 0a 20 |tem(m.ne|wdbf).. |
|00002390| 20 20 20 20 20 6d 2e 70 | 61 72 65 6e 74 66 6c 64 |     m.p|arentfld|
|000023a0| 20 20 3d 20 22 22 0d 0a | 20 20 20 20 20 20 6d 2e |  = ""..|      m.|
|000023b0| 69 67 6e 63 61 73 65 20 | 20 20 20 3d 20 2e 54 2e |igncase |   = .T.|
|000023c0| 0d 0a 20 20 20 20 20 20 | 6d 2e 72 65 6c 73 74 72 |..      |m.relstr|
|000023d0| 20 20 20 20 20 3d 20 22 | 22 0d 0a 20 20 20 20 20 |     = "|"..     |
|000023e0| 20 6d 2e 70 61 72 65 6e | 74 64 62 66 20 20 3d 20 | m.paren|tdbf  = |
|000023f0| 22 22 0d 0a 0d 0a 20 20 | 20 20 20 20 2a 20 46 69 |""....  |    * Fi|
|00002400| 6e 64 20 6f 75 74 20 68 | 6f 77 20 74 68 69 73 20 |nd out h|ow this |
|00002410| 64 61 74 61 62 61 73 65 | 20 72 65 6c 61 74 65 73 |database| relates|
|00002420| 20 74 6f 20 74 68 65 20 | 6f 74 68 65 72 20 6f 6e | to the |other on|
|00002430| 65 73 2e 0d 0a 20 20 20 | 20 20 20 2a 20 52 65 6c |es...   |   * Rel|
|00002440| 73 65 6c 65 63 20 77 69 | 6c 6c 20 72 65 74 75 72 |selec wi|ll retur|
|00002450| 6e 20 61 6e 20 65 6d 70 | 74 79 20 22 63 68 69 6c |n an emp|ty "chil|
|00002460| 64 66 6c 64 22 20 69 66 | 20 63 61 6e 63 65 6c 20 |dfld" if| cancel |
|00002470| 77 61 73 20 0d 0a 20 20 | 20 20 20 20 2a 20 70 72 |was ..  |    * pr|
|00002480| 65 73 73 65 64 2e 0d 0a | 20 20 20 20 20 20 44 4f |essed...|      DO|
|00002490| 20 72 65 6c 73 65 6c 65 | 63 2e 73 70 72 20 57 49 | relsele|c.spr WI|
|000024a0| 54 48 20 6d 2e 6e 65 77 | 64 62 66 2c 20 6d 2e 63 |TH m.new|dbf, m.c|
|000024b0| 68 69 6c 64 64 62 66 2c | 20 6d 2e 63 68 69 6c 64 |hilddbf,| m.child|
|000024c0| 66 6c 64 2c 20 6d 2e 70 | 61 72 65 6e 74 66 6c 64 |fld, m.p|arentfld|
|000024d0| 2c 20 3b 0d 0a 20 20 20 | 20 20 20 20 20 20 6d 2e |, ;..   |      m.|
|000024e0| 69 67 6e 63 61 73 65 2c | 20 6d 2e 72 65 6c 73 74 |igncase,| m.relst|
|000024f0| 72 2c 20 6d 2e 70 61 72 | 65 6e 74 64 62 66 2c 20 |r, m.par|entdbf, |
|00002500| 2e 54 2e 0d 0a 0d 0a 20 | 20 20 20 20 20 49 46 20 |.T..... |     IF |
|00002510| 21 45 4d 50 54 59 28 6d | 2e 63 68 69 6c 64 66 6c |!EMPTY(m|.childfl|
|00002520| 64 29 20 20 26 26 20 74 | 72 75 65 20 75 6e 6c 65 |d)  && t|rue unle|
|00002530| 73 73 20 75 73 65 72 20 | 63 61 6e 63 65 6c 6c 65 |ss user |cancelle|
|00002540| 64 20 52 65 6c 53 65 6c | 65 63 0d 0a 20 20 20 20 |d RelSel|ec..    |
|00002550| 20 20 20 20 20 2a 20 4f | 70 65 6e 20 74 68 65 20 |     * O|pen the |
|00002560| 6e 65 77 20 63 68 69 6c | 64 20 64 61 74 61 62 61 |new chil|d databa|
|00002570| 73 65 0d 0a 20 20 20 20 | 20 20 20 20 20 49 46 20 |se..    |     IF |
|00002580| 55 53 45 44 28 6d 2e 6e | 65 77 64 62 66 29 0d 0a |USED(m.n|ewdbf)..|
|00002590| 20 20 20 20 20 20 20 20 | 20 20 20 20 53 45 4c 45 |        |    SELE|
|000025a0| 43 54 20 28 6d 2e 6e 65 | 77 64 62 66 29 0d 0a 20 |CT (m.ne|wdbf).. |
|000025b0| 20 20 20 20 20 20 20 20 | 45 4c 53 45 0d 0a 20 20 |        |ELSE..  |
|000025c0| 20 20 20 20 20 20 20 20 | 20 20 53 45 4c 45 43 54 |        |  SELECT|
|000025d0| 20 30 0d 0a 20 20 20 20 | 20 20 20 20 20 20 20 20 | 0..    |        |
|000025e0| 55 53 45 20 28 6d 2e 63 | 68 69 6c 64 64 62 66 29 |USE (m.c|hilddbf)|
|000025f0| 0d 0a 20 20 20 20 20 20 | 20 20 20 45 4e 44 49 46 |..      |   ENDIF|
|00002600| 0d 0a 0d 0a 20 20 20 20 | 20 20 20 20 20 2a 20 53 |....    |     * S|
|00002610| 65 65 20 69 66 20 77 65 | 20 6e 65 65 64 20 74 6f |ee if we| need to|
|00002620| 20 61 64 64 20 61 20 43 | 44 58 20 6f 72 20 61 20 | add a C|DX or a |
|00002630| 74 61 67 20 6f 6e 20 74 | 68 65 20 72 65 6c 61 74 |tag on t|he relat|
|00002640| 69 6f 6e 20 66 69 65 6c | 64 20 0d 0a 20 20 20 20 |ion fiel|d ..    |
|00002650| 20 20 20 20 20 44 4f 20 | 6d 61 6b 65 63 64 78 20 |     DO |makecdx |
|00002660| 57 49 54 48 20 28 6d 2e | 63 68 69 6c 64 64 62 66 |WITH (m.|childdbf|
|00002670| 29 2c 20 28 6d 2e 63 68 | 69 6c 64 66 6c 64 29 0d |), (m.ch|ildfld).|
|00002680| 0a 0d 0a 20 20 20 20 20 | 20 20 20 20 2a 20 52 65 |...     |    * Re|
|00002690| 63 6f 72 64 20 64 61 74 | 61 20 61 62 6f 75 74 20 |cord dat|a about |
|000026a0| 74 68 69 73 20 63 68 69 | 6c 64 20 44 42 46 20 6f |this chi|ld DBF o|
|000026b0| 6e 20 74 68 65 20 44 42 | 46 4c 49 53 54 0d 0a 20 |n the DB|FLIST.. |
|000026c0| 20 20 20 20 20 20 20 20 | 64 62 66 6c 69 73 74 5b |        |dbflist[|
|000026d0| 6d 2e 6e 65 78 74 64 62 | 66 2c 6d 2e 63 73 74 65 |m.nextdb|f,m.cste|
|000026e0| 6d 6e 75 6d 5d 20 20 3d | 20 6a 75 73 74 73 74 65 |mnum]  =| justste|
|000026f0| 6d 28 6d 2e 6e 65 77 64 | 62 66 29 0d 0a 20 20 20 |m(m.newd|bf)..   |
|00002700| 20 20 20 20 20 20 64 62 | 66 6c 69 73 74 5b 6d 2e |      db|flist[m.|
|00002710| 6e 65 78 74 64 62 66 2c | 6d 2e 72 65 6c 73 74 72 |nextdbf,|m.relstr|
|00002720| 6e 75 6d 5d 20 3d 20 6d | 2e 72 65 6c 73 74 72 0d |num] = m|.relstr.|
|00002730| 0a 20 20 20 20 20 20 20 | 20 20 64 62 66 6c 69 73 |.       |  dbflis|
|00002740| 74 5b 6d 2e 6e 65 78 74 | 64 62 66 2c 6d 2e 70 66 |t[m.next|dbf,m.pf|
|00002750| 6c 64 6e 75 6d 5d 20 20 | 20 3d 20 6d 2e 70 61 72 |ldnum]  | = m.par|
|00002760| 65 6e 74 66 6c 64 0d 0a | 20 20 20 20 20 20 20 20 |entfld..|        |
|00002770| 20 64 62 66 6c 69 73 74 | 5b 6d 2e 6e 65 78 74 64 | dbflist|[m.nextd|
|00002780| 62 66 2c 6d 2e 63 66 6c | 64 6e 75 6d 5d 20 20 20 |bf,m.cfl|dnum]   |
|00002790| 3d 20 6d 2e 63 68 69 6c | 64 66 6c 64 0d 0a 20 20 |= m.chil|dfld..  |
|000027a0| 20 20 20 20 20 20 20 64 | 62 66 6c 69 73 74 5b 6d |       d|bflist[m|
|000027b0| 2e 6e 65 78 74 64 62 66 | 2c 6d 2e 63 64 62 66 6e |.nextdbf|,m.cdbfn|
|000027c0| 75 6d 5d 20 20 20 3d 20 | 6d 2e 63 68 69 6c 64 64 |um]   = |m.childd|
|000027d0| 62 66 0d 0a 20 20 20 20 | 20 20 20 20 20 64 62 66 |bf..    |     dbf|
|000027e0| 6c 69 73 74 5b 6d 2e 6e | 65 78 74 64 62 66 2c 6d |list[m.n|extdbf,m|
|000027f0| 2e 70 64 62 66 6e 75 6d | 5d 20 20 20 3d 20 6d 2e |.pdbfnum|]   = m.|
|00002800| 70 61 72 65 6e 74 64 62 | 66 0d 0a 20 20 20 20 20 |parentdb|f..     |
|00002810| 20 20 20 20 64 62 66 6c | 69 73 74 5b 6d 2e 6e 65 |    dbfl|ist[m.ne|
|00002820| 78 74 64 62 66 2c 6d 2e | 74 68 65 66 6f 6e 74 5d |xtdbf,m.|thefont]|
|00002830| 20 20 20 3d 20 6d 2e 64 | 65 66 61 75 6c 74 66 6f |   = m.d|efaultfo|
|00002840| 6e 74 0d 0a 20 20 20 20 | 20 20 20 20 20 64 62 66 |nt..    |     dbf|
|00002850| 6c 69 73 74 5b 6d 2e 6e | 65 78 74 64 62 66 2c 6d |list[m.n|extdbf,m|
|00002860| 2e 63 61 73 63 61 64 65 | 6e 75 6d 5d 3d 20 6d 2e |.cascade|num]= m.|
|00002870| 64 65 66 61 75 6c 74 63 | 61 73 63 0d 0a 0d 0a 20 |defaultc|asc.... |
|00002880| 20 20 20 20 20 20 20 20 | 2a 20 43 6f 6d 65 20 75 |        |* Come u|
|00002890| 70 20 77 69 74 68 20 72 | 65 61 73 6f 6e 61 62 6c |p with r|easonabl|
|000028a0| 65 20 64 65 66 61 75 6c | 74 20 70 6f 73 69 74 69 |e defaul|t positi|
|000028b0| 6f 6e 73 20 66 6f 72 20 | 74 68 65 20 64 61 74 61 |ons for |the data|
|000028c0| 62 61 73 65 0d 0a 20 20 | 20 20 20 20 20 20 20 2a |base..  |       *|
|000028d0| 20 62 72 6f 77 73 65 20 | 77 69 6e 64 6f 77 2e 20 | browse |window. |
|000028e0| 20 54 68 65 20 22 41 72 | 72 61 6e 67 65 22 20 6f | The "Ar|range" o|
|000028f0| 70 74 69 6f 6e 20 69 73 | 20 68 6f 77 20 74 68 65 |ption is| how the|
|00002900| 79 20 77 69 6c 6c 0d 0a | 20 20 20 20 20 20 20 20 |y will..|        |
|00002910| 20 2a 20 75 73 75 61 6c | 6c 79 20 62 65 20 73 65 | * usual|ly be se|
|00002920| 74 2e 0d 0a 20 20 20 20 | 20 20 20 20 20 49 46 20 |t...    |     IF |
|00002930| 6d 2e 6e 65 78 74 64 62 | 66 20 3e 20 32 0d 0a 20 |m.nextdb|f > 2.. |
|00002940| 20 20 20 20 20 20 20 20 | 20 20 20 64 62 66 6c 69 |        |   dbfli|
|00002950| 73 74 5b 6d 2e 6e 65 78 | 74 64 62 66 2c 6d 2e 73 |st[m.nex|tdbf,m.s|
|00002960| 72 6f 77 6e 75 6d 5d 20 | 3b 0d 0a 20 20 20 20 20 |rownum] |;..     |
|00002970| 20 20 20 20 20 20 20 20 | 20 20 3d 20 41 4c 4c 54 |        |  = ALLT|
|00002980| 52 49 4d 28 53 54 52 28 | 56 41 4c 28 64 62 66 6c |RIM(STR(|VAL(dbfl|
|00002990| 69 73 74 5b 6d 2e 6e 65 | 78 74 64 62 66 2d 31 2c |ist[m.ne|xtdbf-1,|
|000029a0| 6d 2e 73 72 6f 77 6e 75 | 6d 5d 29 2b 31 2c 33 29 |m.srownu|m])+1,3)|
|000029b0| 29 0d 0a 20 20 20 20 20 | 20 20 20 20 20 20 20 64 |)..     |       d|
|000029c0| 62 66 6c 69 73 74 5b 6d | 2e 6e 65 78 74 64 62 66 |bflist[m|.nextdbf|
|000029d0| 2c 6d 2e 73 63 6f 6c 6e | 75 6d 5d 20 3b 0d 0a 20 |,m.scoln|um] ;.. |
|000029e0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 3d 20 |        |      = |
|000029f0| 41 4c 4c 54 52 49 4d 28 | 53 54 52 28 56 41 4c 28 |ALLTRIM(|STR(VAL(|
|00002a00| 64 62 66 6c 69 73 74 5b | 6d 2e 6e 65 78 74 64 62 |dbflist[|m.nextdb|
|00002a10| 66 2c 6d 2e 73 63 6f 6c | 6e 75 6d 5d 29 2b 31 2c |f,m.scol|num])+1,|
|00002a20| 33 29 29 0d 0a 20 20 20 | 20 20 20 20 20 20 45 4c |3))..   |      EL|
|00002a30| 53 45 0d 0a 20 20 20 20 | 20 20 20 20 20 20 20 20 |SE..    |        |
|00002a40| 64 62 66 6c 69 73 74 5b | 6d 2e 6e 65 78 74 64 62 |dbflist[|m.nextdb|
|00002a50| 66 2c 6d 2e 73 72 6f 77 | 6e 75 6d 5d 20 3d 20 22 |f,m.srow|num] = "|
|00002a60| 31 22 0d 0a 20 20 20 20 | 20 20 20 20 20 20 20 20 |1"..    |        |
|00002a70| 64 62 66 6c 69 73 74 5b | 6d 2e 6e 65 78 74 64 62 |dbflist[|m.nextdb|
|00002a80| 66 2c 6d 2e 73 63 6f 6c | 6e 75 6d 5d 20 3d 20 22 |f,m.scol|num] = "|
|00002a90| 31 22 0d 0a 20 20 20 20 | 20 20 20 20 20 45 4e 44 |1"..    |     END|
|00002aa0| 49 46 0d 0a 20 20 20 20 | 20 20 20 20 20 64 62 66 |IF..    |     dbf|
|00002ab0| 6c 69 73 74 5b 6d 2e 6e | 65 78 74 64 62 66 2c 6d |list[m.n|extdbf,m|
|00002ac0| 2e 65 72 6f 77 6e 75 6d | 5d 20 3d 20 22 36 22 0d |.erownum|] = "6".|
|00002ad0| 0a 20 20 20 20 20 20 20 | 20 20 64 62 66 6c 69 73 |.       |  dbflis|
|00002ae0| 74 5b 6d 2e 6e 65 78 74 | 64 62 66 2c 6d 2e 65 63 |t[m.next|dbf,m.ec|
|00002af0| 6f 6c 6e 75 6d 5d 20 3d | 20 22 37 34 22 0d 0a 0d |olnum] =| "74"...|
|00002b00| 0a 20 20 20 20 20 20 20 | 20 20 6d 2e 6e 65 78 74 |.       |  m.next|
|00002b10| 64 62 66 20 20 3d 20 6d | 2e 6e 65 78 74 64 62 66 |dbf  = m|.nextdbf|
|00002b20| 20 2b 20 31 0d 0a 20 20 | 20 20 20 20 20 20 20 6d | + 1..  |       m|
|00002b30| 2e 64 62 66 73 65 6c 65 | 63 20 3d 20 6d 2e 6e 65 |.dbfsele|c = m.ne|
|00002b40| 78 74 64 62 66 20 2d 20 | 31 0d 0a 20 20 20 20 20 |xtdbf - |1..     |
|00002b50| 20 20 20 20 53 48 4f 57 | 20 47 45 54 20 61 72 72 |    SHOW| GET arr|
|00002b60| 61 6e 67 65 20 45 4e 41 | 42 4c 45 0d 0a 20 20 20 |ange ENA|BLE..   |
|00002b70| 20 20 20 20 20 20 53 48 | 4f 57 20 47 45 54 20 61 |      SH|OW GET a|
|00002b80| 64 64 63 6c 72 2c 32 20 | 45 4e 41 42 4c 45 20 20 |ddclr,2 |ENABLE  |
|00002b90| 20 20 26 26 20 65 6e 61 | 62 6c 65 20 74 68 65 20 |  && ena|ble the |
|00002ba0| 22 43 6c 65 61 72 22 20 | 62 75 74 74 6f 6e 0d 0a |"Clear" |button..|
|00002bb0| 20 20 20 20 20 20 45 4e | 44 49 46 0d 0a 20 20 20 |      EN|DIF..   |
|00002bc0| 45 4e 44 49 46 0d 0a 43 | 41 53 45 20 6d 2e 61 64 |ENDIF..C|ASE m.ad|
|00002bd0| 64 63 6c 72 20 3d 20 32 | 20 20 20 20 26 26 20 63 |dclr = 2|    && c|
|00002be0| 6c 65 61 72 20 74 68 69 | 73 20 64 62 66 0d 0a 20 |lear thi|s dbf.. |
|00002bf0| 20 20 44 4f 20 43 41 53 | 45 0d 0a 20 20 20 43 41 |  DO CAS|E..   CA|
|00002c00| 53 45 20 6d 2e 64 62 66 | 73 65 6c 65 63 20 3d 20 |SE m.dbf|selec = |
|00002c10| 30 20 20 20 26 26 20 63 | 68 6f 69 63 65 20 77 61 |0   && c|hoice wa|
|00002c20| 73 20 69 6e 76 61 6c 69 | 64 0d 0a 20 20 20 20 20 |s invali|d..     |
|00002c30| 20 52 45 54 55 52 4e 20 | 2e 46 2e 0d 0a 20 20 20 | RETURN |.F...   |
|00002c40| 43 41 53 45 20 6d 2e 64 | 62 66 73 65 6c 65 63 20 |CASE m.d|bfselec |
|00002c50| 3d 20 31 0d 0a 20 20 20 | 20 20 20 57 41 49 54 20 |= 1..   |   WAIT |
|00002c60| 57 49 4e 44 4f 57 20 22 | 59 6f 75 20 63 61 6e 6e |WINDOW "|You cann|
|00002c70| 6f 74 20 63 6c 65 61 72 | 20 74 68 65 20 6d 61 69 |ot clear| the mai|
|00002c80| 6e 20 64 61 74 61 62 61 | 73 65 2e 22 20 4e 4f 57 |n databa|se." NOW|
|00002c90| 41 49 54 0d 0a 20 20 20 | 20 20 20 52 45 54 55 52 |AIT..   |   RETUR|
|00002ca0| 4e 0d 0a 20 20 20 45 4e | 44 43 41 53 45 0d 0a 0d |N..   EN|DCASE...|
|00002cb0| 0a 20 20 20 2a 20 53 65 | 65 20 69 66 20 74 68 69 |.   * Se|e if thi|
|00002cc0| 73 20 64 61 74 61 62 61 | 73 65 20 68 61 73 20 61 |s databa|se has a|
|00002cd0| 20 63 68 69 6c 64 2e 20 | 20 49 66 20 73 6f 2c 20 | child. | If so, |
|00002ce0| 64 6f 6e 27 74 20 61 6c | 6c 6f 77 20 69 74 20 74 |don't al|low it t|
|00002cf0| 6f 20 62 65 0d 0a 20 20 | 20 2a 20 63 6c 65 61 72 |o be..  | * clear|
|00002d00| 65 64 2e 20 20 54 68 65 | 20 63 6c 65 61 72 20 62 |ed.  The| clear b|
|00002d10| 75 74 74 6f 6e 20 69 73 | 20 61 6c 73 6f 20 75 73 |utton is| also us|
|00002d20| 75 61 6c 6c 79 20 64 69 | 6d 6d 65 64 20 69 66 20 |ually di|mmed if |
|00002d30| 74 68 65 20 63 75 72 72 | 65 6e 74 20 0d 0a 20 20 |the curr|ent ..  |
|00002d40| 20 2a 20 64 62 66 6c 69 | 73 74 20 69 74 65 6d 20 | * dbfli|st item |
|00002d50| 68 61 73 20 61 20 63 68 | 69 6c 64 2e 0d 0a 20 20 |has a ch|ild...  |
|00002d60| 20 49 46 20 68 61 73 63 | 68 69 6c 64 28 6d 2e 64 | IF hasc|hild(m.d|
|00002d70| 62 66 73 65 6c 65 63 29 | 20 41 4e 44 20 21 45 4d |bfselec)| AND !EM|
|00002d80| 50 54 59 28 6d 2e 64 62 | 66 73 65 6c 65 63 29 0d |PTY(m.db|fselec).|
|00002d90| 0a 20 20 20 20 20 20 57 | 41 49 54 20 57 49 4e 44 |.      W|AIT WIND|
|00002da0| 4f 57 20 22 59 6f 75 20 | 63 61 6e 6e 6f 74 20 63 |OW "You |cannot c|
|00002db0| 6c 65 61 72 20 61 20 64 | 61 74 61 62 61 73 65 20 |lear a d|atabase |
|00002dc0| 74 68 61 74 20 68 61 73 | 20 72 65 6c 61 74 65 64 |that has| related|
|00002dd0| 20 64 61 74 61 62 61 73 | 65 73 2e 22 20 4e 4f 57 | databas|es." NOW|
|00002de0| 41 49 54 0d 0a 20 20 20 | 20 20 20 52 45 54 55 52 |AIT..   |   RETUR|
|00002df0| 4e 0d 0a 20 20 20 45 4e | 44 49 46 0d 0a 0d 0a 20 |N..   EN|DIF.... |
|00002e00| 20 20 2a 20 43 6c 65 61 | 72 20 74 68 65 20 44 42 |  * Clea|r the DB|
|00002e10| 46 2c 20 61 73 73 75 6d | 69 6e 67 20 77 65 20 61 |F, assum|ing we a|
|00002e20| 72 65 20 70 6f 69 6e 74 | 65 64 20 61 74 20 61 20 |re point|ed at a |
|00002e30| 76 61 6c 69 64 20 44 42 | 46 20 6e 61 6d 65 2e 20 |valid DB|F name. |
|00002e40| 20 20 0d 0a 20 20 20 49 | 46 20 21 45 4d 50 54 59 |  ..   I|F !EMPTY|
|00002e50| 28 64 62 66 6c 69 73 74 | 5b 6d 2e 64 62 66 73 65 |(dbflist|[m.dbfse|
|00002e60| 6c 65 63 2c 6d 2e 63 73 | 74 65 6d 6e 75 6d 5d 29 |lec,m.cs|temnum])|
|00002e70| 20 41 4e 44 20 64 62 66 | 6c 69 73 74 5b 6d 2e 64 | AND dbf|list[m.d|
|00002e80| 62 66 73 65 6c 65 63 2c | 6d 2e 63 73 74 65 6d 6e |bfselec,|m.cstemn|
|00002e90| 75 6d 5d 20 3c 3e 20 27 | 5c 27 0d 0a 20 20 20 20 |um] <> '|\'..    |
|00002ea0| 20 20 2a 20 43 6c 6f 73 | 65 20 74 68 65 20 64 61 |  * Clos|e the da|
|00002eb0| 74 61 62 61 73 65 2c 20 | 69 66 20 69 74 20 69 73 |tabase, |if it is|
|00002ec0| 20 6f 70 65 6e 20 28 69 | 74 20 73 68 6f 75 6c 64 | open (i|t should|
|00002ed0| 20 62 65 29 0d 0a 20 20 | 20 20 20 20 49 46 20 55 | be)..  |    IF U|
|00002ee0| 53 45 44 28 28 54 52 49 | 4d 28 64 62 66 6c 69 73 |SED((TRI|M(dbflis|
|00002ef0| 74 5b 6d 2e 64 62 66 73 | 65 6c 65 63 2c 6d 2e 63 |t[m.dbfs|elec,m.c|
|00002f00| 73 74 65 6d 6e 75 6d 5d | 29 29 29 0d 0a 20 20 20 |stemnum]|)))..   |
|00002f10| 20 20 20 20 20 20 53 45 | 4c 45 43 54 20 28 54 52 |      SE|LECT (TR|
|00002f20| 49 4d 28 64 62 66 6c 69 | 73 74 5b 6d 2e 64 62 66 |IM(dbfli|st[m.dbf|
|00002f30| 73 65 6c 65 63 2c 6d 2e | 63 73 74 65 6d 6e 75 6d |selec,m.|cstemnum|
|00002f40| 5d 29 29 0d 0a 20 20 20 | 20 20 20 20 20 20 55 53 |]))..   |      US|
|00002f50| 45 0d 0a 20 20 20 20 20 | 20 45 4e 44 49 46 0d 0a |E..     | ENDIF..|
|00002f60| 20 20 20 20 20 20 64 62 | 66 6c 69 73 74 5b 6d 2e |      db|flist[m.|
|00002f70| 64 62 66 73 65 6c 65 63 | 2c 6d 2e 63 73 74 65 6d |dbfselec|,m.cstem|
|00002f80| 6e 75 6d 5d 20 3d 20 53 | 50 41 43 45 28 32 35 29 |num] = S|PACE(25)|
|00002f90| 0d 0a 20 20 20 20 20 20 | 44 4f 20 43 41 53 45 0d |..      |DO CASE.|
|00002fa0| 0a 20 20 20 20 20 20 43 | 41 53 45 20 6d 2e 6e 65 |.      C|ASE m.ne|
|00002fb0| 78 74 64 62 66 20 3d 20 | 31 20 20 20 20 20 20 20 |xtdbf = |1       |
|00002fc0| 20 20 20 20 20 20 20 20 | 20 26 26 20 6e 6f 20 64 |        | && no d|
|00002fd0| 61 74 61 62 61 73 65 73 | 20 74 6f 20 63 6c 6f 73 |atabases| to clos|
|00002fe0| 65 0d 0a 20 20 20 20 20 | 20 43 41 53 45 20 6d 2e |e..     | CASE m.|
|00002ff0| 64 62 66 73 65 6c 65 63 | 20 3d 20 6d 2e 6e 65 78 |dbfselec| = m.nex|
|00003000| 74 64 62 66 20 20 20 20 | 20 20 20 26 26 20 63 6c |tdbf    |   && cl|
|00003010| 6f 73 65 20 74 68 65 20 | 6c 61 73 74 20 6f 6e 65 |ose the |last one|
|00003020| 20 69 6e 20 74 68 65 20 | 6c 69 73 74 0d 0a 20 20 | in the |list..  |
|00003030| 20 20 20 20 20 20 20 6d | 2e 6e 65 78 74 64 62 66 |       m|.nextdbf|
|00003040| 20 3d 20 6d 2e 6e 65 78 | 74 64 62 66 20 2d 20 31 | = m.nex|tdbf - 1|
|00003050| 0d 0a 20 20 20 20 20 20 | 4f 54 48 45 52 57 49 53 |..      |OTHERWIS|
|00003060| 45 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |E       |        |
|00003070| 20 20 20 20 20 20 20 20 | 20 20 26 26 20 63 6c 6f |        |  && clo|
|00003080| 73 65 20 73 6f 6d 65 20 | 6f 74 68 65 72 20 64 61 |se some |other da|
|00003090| 74 61 62 61 73 65 0d 0a | 20 20 20 20 20 20 20 20 |tabase..|        |
|000030a0| 20 3d 20 41 44 45 4c 28 | 64 62 66 6c 69 73 74 2c | = ADEL(|dbflist,|
|000030b0| 6d 2e 64 62 66 73 65 6c | 65 63 29 0d 0a 20 20 20 |m.dbfsel|ec)..   |
|000030c0| 20 20 20 20 20 20 64 62 | 66 6c 69 73 74 5b 6d 2e |      db|flist[m.|
|000030d0| 6e 75 6d 61 72 65 61 73 | 2c 6d 2e 63 73 74 65 6d |numareas|,m.cstem|
|000030e0| 6e 75 6d 5d 20 3d 20 27 | 5c 27 20 20 26 26 20 64 |num] = '|\'  && d|
|000030f0| 69 73 61 62 6c 65 20 74 | 68 69 73 20 6c 69 73 74 |isable t|his list|
|00003100| 20 69 74 65 6d 0d 0a 20 | 20 20 20 20 20 20 20 20 | item.. |        |
|00003110| 46 4f 52 20 69 20 3d 20 | 32 20 54 4f 20 6e 75 6d |FOR i = |2 TO num|
|00003120| 63 6f 6c 73 0d 0a 20 20 | 20 20 20 20 20 20 20 20 |cols..  |        |
|00003130| 20 20 64 62 66 6c 69 73 | 74 5b 6d 2e 6e 75 6d 61 |  dbflis|t[m.numa|
|00003140| 72 65 61 73 2c 69 5d 20 | 3d 20 27 27 0d 0a 20 20 |reas,i] |= ''..  |
|00003150| 20 20 20 20 20 20 20 45 | 4e 44 46 4f 52 0d 0a 20 |       E|NDFOR.. |
|00003160| 20 20 20 20 20 20 20 20 | 6d 2e 6e 65 78 74 64 62 |        |m.nextdb|
|00003170| 66 20 3d 20 6d 2e 6e 65 | 78 74 64 62 66 20 2d 20 |f = m.ne|xtdbf - |
|00003180| 31 0d 0a 20 20 20 20 20 | 20 45 4e 44 43 41 53 45 |1..     | ENDCASE|
|00003190| 0d 0a 20 20 20 20 20 20 | 6d 2e 64 62 66 73 65 6c |..      |m.dbfsel|
|000031a0| 65 63 20 3d 20 6d 2e 6e | 65 78 74 64 62 66 20 2d |ec = m.n|extdbf -|
|000031b0| 20 31 0d 0a 0d 0a 20 20 | 20 20 20 20 53 48 4f 57 | 1....  |    SHOW|
|000031c0| 20 47 45 54 20 64 62 66 | 73 65 6c 65 63 0d 0a 20 | GET dbf|selec.. |
|000031d0| 20 20 45 4e 44 49 46 0d | 0a 20 20 20 49 46 20 6d |  ENDIF.|.   IF m|
|000031e0| 2e 6e 65 78 74 64 62 66 | 20 3d 20 31 0d 0a 20 20 |.nextdbf| = 1..  |
|000031f0| 20 20 20 20 53 48 4f 57 | 20 47 45 54 20 61 72 72 |    SHOW| GET arr|
|00003200| 61 6e 67 65 20 44 49 53 | 41 42 4c 45 0d 0a 20 20 |ange DIS|ABLE..  |
|00003210| 20 45 4e 44 49 46 0d 0a | 45 4e 44 43 41 53 45 0d | ENDIF..|ENDCASE.|
|00003220| 0a 53 48 4f 57 20 47 45 | 54 53 0d 0a 00 00 00 00 |.SHOW GE|TS......|
|00003230| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003240| 00 00 00 00 00 00 00 00 | 00 01 00 00 00 05 22 41 |........|......"A|
|00003250| 64 64 22 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |dd".....|........|
|00003260| 00 00 00 00 00 00 00 00 | 00 00 01 00 00 00 0d 4d |........|.......M|
|00003270| 53 20 53 61 6e 73 20 53 | 65 72 69 66 00 00 00 00 |S Sans S|erif....|
|00003280| 00 00 00 00 00 00 00 00 | 00 00 00 01 00 00 00 05 |........|........|
|00003290| 6f 6b 62 75 74 00 00 00 | 00 00 00 00 00 00 00 00 |okbut...|........|
|000032a0| 00 00 00 00 00 00 00 00 | 00 00 00 00 01 00 00 00 |........|........|
|000032b0| 18 22 40 2a 56 54 20 5c | 21 5c 3c 4f 4b 3b 5c 3f |."@*VT \|!\<OK;\?|
|000032c0| 5c 3c 43 61 6e 63 65 6c | 22 00 00 00 00 01 00 00 |\<Cancel|".......|
|000032d0| 02 82 49 46 20 6f 6b 62 | 75 74 20 3d 20 31 0d 0a |..IF okb|ut = 1..|
|000032e0| 20 20 20 49 46 20 72 65 | 6c 61 74 65 64 64 62 66 |   IF re|lateddbf|
|000032f0| 73 28 29 0d 0a 20 20 20 | 20 20 20 2a 20 53 61 76 |s()..   |   * Sav|
|00003300| 65 20 74 68 65 20 64 61 | 74 61 62 61 73 65 20 72 |e the da|tabase r|
|00003310| 65 6c 61 74 69 6f 6e 73 | 68 69 70 73 0d 0a 20 20 |elations|hips..  |
|00003320| 20 20 20 20 49 46 20 6d | 2e 73 74 6f 72 65 72 73 |    IF m|.storers|
|00003330| 63 0d 0a 20 20 20 20 20 | 20 20 20 20 2a 20 54 65 |c..     |    * Te|
|00003340| 6c 6c 20 75 73 65 72 20 | 77 68 61 74 20 69 73 20 |ll user |what is |
|00003350| 67 6f 69 6e 67 20 6f 6e | 20 20 20 0d 0a 20 20 20 |going on|   ..   |
|00003360| 20 20 20 20 20 20 57 41 | 49 54 20 57 49 4e 44 4f |      WA|IT WINDO|
|00003370| 57 20 22 53 61 76 69 6e | 67 20 64 61 74 61 62 61 |W "Savin|g databa|
|00003380| 73 65 20 72 65 6c 61 74 | 69 6f 6e 73 20 61 6e 64 |se relat|ions and|
|00003390| 20 77 69 6e 64 6f 77 20 | 70 6f 73 69 74 69 6f 6e | window |position|
|000033a0| 73 2e 22 20 4e 4f 57 41 | 49 54 0d 0a 0d 0a 20 20 |s." NOWA|IT....  |
|000033b0| 20 20 20 20 20 20 20 44 | 4f 20 70 75 74 64 62 66 |       D|O putdbf|
|000033c0| 6c 69 73 74 20 57 49 54 | 48 20 64 62 66 6c 69 73 |list WIT|H dbflis|
|000033d0| 74 5b 31 2c 6d 2e 63 73 | 74 65 6d 6e 75 6d 5d 0d |t[1,m.cs|temnum].|
|000033e0| 0a 20 20 20 20 20 20 45 | 4e 44 49 46 0d 0a 0d 0a |.      E|NDIF....|
|000033f0| 20 20 20 20 20 20 57 41 | 49 54 20 43 4c 45 41 52 |      WA|IT CLEAR|
|00003400| 0d 0a 20 20 20 45 4e 44 | 49 46 0d 0a 45 4c 53 45 |..   END|IF..ELSE|
|00003410| 0d 0a 20 20 20 2a 20 52 | 65 73 74 6f 72 65 20 6f |..   * R|estore o|
|00003420| 72 69 67 69 6e 61 6c 20 | 44 42 46 4c 49 53 54 20 |riginal |DBFLIST |
|00003430| 61 72 72 61 79 0d 0a 20 | 20 20 3d 41 43 4f 50 59 |array.. |  =ACOPY|
|00003440| 28 6f 72 69 67 64 62 66 | 6c 69 73 74 2c 64 62 66 |(origdbf|list,dbf|
|00003450| 6c 69 73 74 29 0d 0a 20 | 20 20 6d 2e 6e 65 78 74 |list).. |  m.next|
|00003460| 64 62 66 20 3d 20 6d 2e | 6f 72 69 67 6e 65 78 74 |dbf = m.|orignext|
|00003470| 64 62 66 0d 0a 20 20 20 | 52 45 4c 45 41 53 45 20 |dbf..   |RELEASE |
|00003480| 6f 72 69 67 64 62 66 6c | 69 73 74 0d 0a 0d 0a 20 |origdbfl|ist.... |
|00003490| 20 20 2a 20 52 65 73 74 | 6f 72 65 20 69 6e 63 6f |  * Rest|ore inco|
|000034a0| 6d 69 6e 67 20 65 6e 76 | 69 72 6f 6e 6d 65 6e 74 |ming env|ironment|
|000034b0| 0d 0a 20 20 20 49 46 20 | 46 49 4c 45 28 27 64 62 |..   IF |FILE('db|
|000034c0| 66 73 65 6c 65 63 2e 76 | 75 65 27 29 0d 0a 20 20 |fselec.v|ue')..  |
|000034d0| 20 20 20 20 53 45 54 20 | 56 49 45 57 20 54 4f 20 |    SET |VIEW TO |
|000034e0| 64 62 66 73 65 6c 65 63 | 2e 76 75 65 0d 0a 20 20 |dbfselec|.vue..  |
|000034f0| 20 45 4e 44 49 46 0d 0a | 45 4e 44 49 46 0d 0a 0d | ENDIF..|ENDIF...|
|00003500| 0a 2a 20 44 72 6f 70 20 | 74 68 65 20 76 69 65 77 |.* Drop |the view|
|00003510| 20 66 69 6c 65 0d 0a 49 | 46 20 46 49 4c 45 28 27 | file..I|F FILE('|
|00003520| 64 62 66 73 65 6c 65 63 | 2e 76 75 65 27 29 0d 0a |dbfselec|.vue')..|
|00003530| 20 20 20 44 45 4c 45 54 | 45 20 46 49 4c 45 20 64 |   DELET|E FILE d|
|00003540| 62 66 73 65 6c 65 63 2e | 76 75 65 0d 0a 45 4e 44 |bfselec.|vue..END|
|00003550| 49 46 0d 0a 00 00 00 00 | 00 00 00 00 00 00 00 00 |IF......|........|
|00003560| 00 01 00 00 00 04 22 4f | 4b 22 00 00 00 00 00 00 |......"O|K"......|
|00003570| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003580| 00 00 01 00 00 00 0d 4d | 53 20 53 61 6e 73 20 53 |.......M|S Sans S|
|00003590| 65 72 69 66 00 00 00 00 | 00 00 00 00 00 00 00 00 |erif....|........|
|000035a0| 00 00 00 01 00 00 00 05 | 74 72 65 65 31 00 00 00 |........|tree1...|
|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 | 15 22 40 2a 48 4e 20 53 |........|."@*HN S|
|000035d0| 68 6f 77 20 41 73 20 5c | 3c 54 72 65 65 22 00 00 |how As \|<Tree"..|
|000035e0| 00 00 00 00 00 01 00 00 | 02 ea 2a 20 48 69 64 65 |........|..* Hide|
|000035f0| 20 74 68 65 20 74 72 65 | 65 20 64 69 61 67 72 61 | the tre|e diagra|
|00003600| 6d 20 69 66 20 69 74 20 | 69 73 20 76 69 73 69 62 |m if it |is visib|
|00003610| 6c 65 3b 20 64 69 73 70 | 6c 61 79 20 69 74 20 69 |le; disp|lay it i|
|00003620| 66 20 69 74 20 69 73 6e | 27 74 0d 0a 49 46 20 57 |f it isn|'t..IF W|
|00003630| 56 49 53 49 42 4c 45 28 | 27 74 72 65 65 77 69 6e |VISIBLE(|'treewin|
|00003640| 64 27 29 0d 0a 20 20 20 | 52 45 4c 45 41 53 45 20 |d')..   |RELEASE |
|00003650| 57 49 4e 44 4f 57 20 74 | 72 65 65 77 69 6e 64 0d |WINDOW t|reewind.|
|00003660| 0a 20 20 20 53 48 4f 57 | 20 47 45 54 20 74 72 65 |.   SHOW| GET tre|
|00003670| 65 31 2c 31 20 50 52 4f | 4d 50 54 20 22 5c 3c 53 |e1,1 PRO|MPT "\<S|
|00003680| 68 6f 77 20 74 72 65 65 | 22 0d 0a 45 4c 53 45 0d |how tree|"..ELSE.|
|00003690| 0a 20 20 20 49 46 20 6d | 2e 6e 65 78 74 64 62 66 |.   IF m|.nextdbf|
|000036a0| 20 3c 3d 20 31 0d 0a 20 | 20 20 20 20 20 57 41 49 | <= 1.. |     WAI|
|000036b0| 54 20 57 49 4e 44 4f 57 | 20 22 4e 6f 20 74 72 65 |T WINDOW| "No tre|
|000036c0| 65 20 74 6f 20 73 68 6f | 77 21 22 20 4e 4f 57 41 |e to sho|w!" NOWA|
|000036d0| 49 54 0d 0a 20 20 20 45 | 4c 53 45 0d 0a 20 20 20 |IT..   E|LSE..   |
|000036e0| 20 20 20 73 74 61 72 74 | 5f 72 6f 77 20 3d 20 33 |   start|_row = 3|
|000036f0| 0d 0a 20 20 20 20 20 20 | 65 6e 64 5f 72 6f 77 20 |..      |end_row |
|00003700| 20 20 3d 20 4d 49 4e 28 | 73 74 61 72 74 5f 72 6f |  = MIN(|start_ro|
|00003710| 77 20 2b 20 34 20 2b 20 | 6d 2e 6e 65 78 74 64 62 |w + 4 + |m.nextdb|
|00003720| 66 2c 20 53 52 4f 57 53 | 28 29 2d 31 29 0d 0a 20 |f, SROWS|()-1).. |
|00003730| 20 20 20 20 20 73 74 61 | 72 74 5f 63 6f 6c 20 3d |     sta|rt_col =|
|00003740| 20 31 0d 0a 20 20 20 20 | 20 20 65 6e 64 5f 63 6f | 1..    |  end_co|
|00003750| 6c 20 20 20 3d 20 32 30 | 0d 0a 20 20 20 20 20 20 |l   = 20|..      |
|00003760| 44 45 46 49 4e 45 20 57 | 49 4e 44 4f 57 20 74 72 |DEFINE W|INDOW tr|
|00003770| 65 65 77 69 6e 64 20 3b | 0d 0a 20 20 20 20 20 20 |eewind ;|..      |
|00003780| 20 20 20 46 52 4f 4d 20 | 73 74 61 72 74 5f 72 6f |   FROM |start_ro|
|00003790| 77 2c 73 74 61 72 74 5f | 63 6f 6c 20 54 4f 20 65 |w,start_|col TO e|
|000037a0| 6e 64 5f 72 6f 77 2c 65 | 6e 64 5f 63 6f 6c 20 3b |nd_row,e|nd_col ;|
|000037b0| 0d 0a 20 20 20 20 20 20 | 20 20 20 54 49 54 4c 45 |..      |   TITLE|
|000037c0| 20 22 44 61 74 61 62 61 | 73 65 20 74 72 65 65 22 | "Databa|se tree"|
|000037d0| 20 3b 0d 0a 20 20 20 20 | 20 20 20 20 20 53 59 53 | ;..    |     SYS|
|000037e0| 54 45 4d 20 46 4c 4f 41 | 54 20 4e 4f 5a 4f 4f 4d |TEM FLOA|T NOZOOM|
|000037f0| 20 4e 4f 43 4c 4f 53 45 | 20 4e 4f 47 52 4f 57 20 | NOCLOSE| NOGROW |
|00003800| 3b 0d 0a 20 20 20 20 20 | 20 20 20 20 43 4f 4c 4f |;..     |    COLO|
|00003810| 52 20 53 43 48 45 4d 45 | 20 31 30 0d 0a 20 20 20 |R SCHEME| 10..   |
|00003820| 20 20 20 41 43 54 49 56 | 41 54 45 20 57 49 4e 44 |   ACTIV|ATE WIND|
|00003830| 4f 57 20 74 72 65 65 77 | 69 6e 64 20 4e 4f 53 48 |OW treew|ind NOSH|
|00003840| 4f 57 0d 0a 20 20 20 20 | 20 20 53 45 54 20 43 55 |OW..    |  SET CU|
|00003850| 52 53 4f 52 20 4f 46 46 | 0d 0a 20 20 20 20 20 20 |RSOR OFF|..      |
|00003860| 44 4f 20 73 68 6f 77 74 | 72 65 65 20 57 49 54 48 |DO showt|ree WITH|
|00003870| 20 31 2c 30 0d 0a 20 20 | 20 20 20 20 41 43 54 49 | 1,0..  |    ACTI|
|00003880| 56 41 54 45 20 57 49 4e | 44 4f 57 20 74 72 65 65 |VATE WIN|DOW tree|
|00003890| 77 69 6e 64 0d 0a 20 20 | 20 20 20 20 53 48 4f 57 |wind..  |    SHOW|
|000038a0| 20 47 45 54 20 74 72 65 | 65 31 2c 31 20 50 52 4f | GET tre|e1,1 PRO|
|000038b0| 4d 50 54 20 22 5c 3c 48 | 69 64 65 20 74 72 65 65 |MPT "\<H|ide tree|
|000038c0| 22 0d 0a 20 20 20 45 4e | 44 49 46 0d 0a 45 4e 44 |"..   EN|DIF..END|
|000038d0| 49 46 0d 0a 00 00 00 00 | 00 00 00 00 01 00 00 00 |IF......|........|
|000038e0| 0e 22 53 68 6f 77 20 41 | 73 20 54 72 65 65 22 00 |."Show A|s Tree".|
|000038f0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 01 00 00 |........|........|
|00003900| 00 0d 4d 53 20 53 61 6e | 73 20 53 65 72 69 66 00 |..MS San|s Serif.|
|00003910| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 01 00 |........|........|
|00003920| 00 00 11 22 52 65 6c 61 | 74 65 64 20 54 61 62 6c |..."Rela|ted Tabl|
|00003930| 65 73 3a 22 00 00 00 00 | 00 00 00 00 00 00 00 01 |es:"....|........|
|00003940| 00 00 00 0d 4d 53 20 53 | 61 6e 73 20 53 65 72 69 |....MS S|ans Seri|
|00003950| 66 00 6d 61 79 61 00 00 | 00 00 00 00 00          |f.maya..|.....   |
+--------+-------------------------+-------------------------+--------+--------+