Liren Large Software Subsidy 5

home *** CD-ROM | disk | FTP | other *** search
/ Liren Large Software Subsidy 5 / 05.iso / a / a108 / 15.ddi / RELSELEC.SC_ / RELSELEC.bin
Unknown | 1994-03-10 | 31.9 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, 991 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
`74%`	TrID	Matlab Level 4 MAT-File (big-endian)	default (weak)
`25%`	TrID	MacBinary 1	default (weak)
`100%`	siegfried	x-fmt/342 Microsoft FoxPro Memo	default (weak)
`100%`	xdgMime	image/x-tga	default
hex view
+--------+-------------------------+-------------------------+--------+--------+
|00000000| 00 00 03 df 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 00 00 00 00 00 |........|........|
|00000210| 00 00 00 01 00 00 00 08 | 52 45 4c 53 45 4c 45 43 |........|RELSELEC|
|00000220| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000230| 00 00 00 00 01 00 00 00 | 0d 4d 53 20 53 61 6e 73 |........|.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 16 22 4f 70 74 69 6f |........|.."Optio|
|00000260| 6e 73 20 66 6f 72 20 26 | 74 68 69 73 64 62 66 22 |ns for &|thisdbf"|
|00000270| 00 00 00 00 00 00 01 00 | 00 00 c5 49 46 20 45 4d |........|...IF EM|
|00000280| 50 54 59 28 6d 2e 70 61 | 72 65 6e 74 66 6c 64 29 |PTY(m.pa|rentfld)|
|00000290| 20 3b 0d 0a 20 20 20 20 | 20 20 4f 52 20 4c 45 46 | ;..    |  OR LEF|
|000002a0| 54 28 6d 2e 70 61 72 65 | 6e 74 66 6c 64 2c 31 29 |T(m.pare|ntfld,1)|
|000002b0| 20 3d 20 27 5c 27 20 3b | 0d 0a 20 20 20 20 20 20 | = '\' ;|..      |
|000002c0| 4f 52 20 28 67 65 74 74 | 79 70 65 28 6d 2e 70 61 |OR (gett|ype(m.pa|
|000002d0| 72 65 6e 74 66 6c 64 29 | 20 21 3d 20 67 65 74 74 |rentfld)| != gett|
|000002e0| 79 70 65 28 6d 2e 63 68 | 69 6c 64 66 6c 64 29 29 |ype(m.ch|ildfld))|
|000002f0| 0d 0a 20 20 20 53 48 4f | 57 20 47 45 54 20 6d 2e |..   SHO|W GET m.|
|00000300| 6f 6b 63 61 6e 63 6c 2c | 31 20 44 49 53 41 42 4c |okcancl,|1 DISABL|
|00000310| 45 0d 0a 45 4c 53 45 0d | 0a 20 20 20 53 48 4f 57 |E..ELSE.|.   SHOW|
|00000320| 20 47 45 54 20 6d 2e 6f | 6b 63 61 6e 63 6c 2c 31 | GET m.o|kcancl,1|
|00000330| 20 45 4e 41 42 4c 45 0d | 0a 45 4e 44 49 46 0d 0a | ENABLE.|.ENDIF..|
|00000340| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000350| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 01 00 00 |........|........|
|00000360| 0d 6b 23 54 52 41 4e 20 | 53 4e 49 50 50 45 54 20 |.k#TRAN |SNIPPET |
|00000370| 4f 4e 4c 59 0d 0a 23 53 | 45 43 54 49 4f 4e 20 31 |ONLY..#S|ECTION 1|
|00000380| 0d 0a 50 41 52 41 4d 45 | 54 45 52 53 20 6d 2e 63 |..PARAME|TERS m.c|
|00000390| 68 69 6c 64 73 74 65 6d | 2c 20 6d 2e 63 68 69 6c |hildstem|, m.chil|
|000003a0| 64 64 62 66 2c 20 6d 2e | 63 68 69 6c 64 66 6c 64 |ddbf, m.|childfld|
|000003b0| 2c 20 6d 2e 70 61 72 65 | 6e 74 66 6c 64 2c 20 6d |, m.pare|ntfld, m|
|000003c0| 2e 69 67 6e 63 61 73 65 | 2c 20 3b 0d 0a 20 20 20 |.igncase|, ;..   |
|000003d0| 6d 2e 72 65 6c 73 74 72 | 2c 20 6d 2e 70 61 72 65 |m.relstr|, m.pare|
|000003e0| 6e 74 64 62 66 2c 20 6d | 2e 61 64 64 6d 6f 64 65 |ntdbf, m|.addmode|
|000003f0| 0d 0a 0d 0a 50 52 49 56 | 41 54 45 20 6d 2e 69 67 |....PRIV|ATE m.ig|
|00000400| 6e 63 61 73 65 2c 20 6d | 2e 61 64 64 6d 6f 64 65 |ncase, m|.addmode|
|00000410| 2c 20 6d 2e 69 2c 20 6d | 2e 6a 2c 20 6d 2e 61 6c |, m.i, m|.j, m.al|
|00000420| 5f 6e 61 6d 65 2c 20 6d | 2e 74 68 69 73 64 62 66 |_name, m|.thisdbf|
|00000430| 2c 20 6d 2e 64 6f 6e 65 | 2c 20 6d 2e 69 6e 5f 61 |, m.done|, m.in_a|
|00000440| 72 65 61 0d 0a 0d 0a 2a | 20 41 73 73 65 6d 62 6c |rea....*| Assembl|
|00000450| 65 20 73 74 72 69 6e 67 | 20 66 6f 72 20 64 69 61 |e string| for dia|
|00000460| 6c 6f 67 20 74 69 74 6c | 65 0d 0a 6d 2e 74 68 69 |log titl|e..m.thi|
|00000470| 73 64 62 66 20 3d 20 6a | 75 73 74 66 6e 61 6d 65 |sdbf = j|ustfname|
|00000480| 28 6d 2e 63 68 69 6c 64 | 64 62 66 29 0d 0a 0d 0a |(m.child|dbf)....|
|00000490| 2a 20 61 64 64 6d 6f 64 | 65 20 64 65 74 65 72 6d |* addmod|e determ|
|000004a0| 69 6e 65 73 20 69 66 20 | 77 65 20 61 72 65 20 61 |ines if |we are a|
|000004b0| 64 64 69 6e 67 20 61 20 | 6e 65 77 20 72 65 6c 61 |dding a |new rela|
|000004c0| 74 69 6f 6e 73 68 69 70 | 20 6f 72 20 65 64 69 74 |tionship| or edit|
|000004d0| 69 6e 67 0d 0a 2a 20 61 | 6e 20 65 78 69 73 69 6e |ing..* a|n exisin|
|000004e0| 67 20 6f 6e 65 0d 0a 0d | 0a 2a 20 53 74 61 72 74 |g one...|.* Start|
|000004f0| 20 77 69 74 68 20 6e 65 | 77 20 63 6f 70 69 65 73 | with ne|w copies|
|00000500| 20 6f 66 20 74 68 65 20 | 6c 69 73 74 20 61 72 72 | of the |list arr|
|00000510| 61 79 73 20 61 6e 64 20 | 72 65 6c 65 61 73 65 20 |ays and |release |
|00000520| 61 6e 79 20 74 68 61 74 | 20 0d 0a 2a 20 61 6c 72 |any that| ..* alr|
|00000530| 65 61 64 79 20 65 78 69 | 73 74 0d 0a 52 45 4c 45 |eady exi|st..RELE|
|00000540| 41 53 45 20 63 68 69 6c | 64 6c 69 73 74 2c 20 70 |ASE chil|dlist, p|
|00000550| 61 72 65 6e 74 6c 69 73 | 74 0d 0a 0d 0a 23 53 45 |arentlis|t....#SE|
|00000560| 43 54 49 4f 4e 20 32 0d | 0a 0d 0a 6d 2e 69 6e 5f |CTION 2.|...m.in_|
|00000570| 61 72 65 61 20 3d 20 53 | 45 4c 45 43 54 28 29 0d |area = S|ELECT().|
|00000580| 0a 0d 0a 2a 20 4d 61 6b | 65 20 73 75 72 65 20 63 |...* Mak|e sure c|
|00000590| 68 69 6c 64 20 64 61 74 | 61 62 61 73 65 20 65 78 |hild dat|abase ex|
|000005a0| 69 73 74 73 0d 0a 49 46 | 20 21 46 49 4c 45 28 6d |ists..IF| !FILE(m|
|000005b0| 2e 63 68 69 6c 64 64 62 | 66 29 0d 0a 20 20 20 6d |.childdb|f)..   m|
|000005c0| 2e 63 68 69 6c 64 64 62 | 66 20 3d 20 47 45 54 46 |.childdb|f = GETF|
|000005d0| 49 4c 45 28 27 44 42 46 | 27 2c 27 50 6c 65 61 73 |ILE('DBF|','Pleas|
|000005e0| 65 20 6c 6f 63 61 74 65 | 20 74 68 65 20 27 2b 6a |e locate| the '+j|
|000005f0| 75 73 74 73 74 65 6d 28 | 6d 2e 63 68 69 6c 64 64 |uststem(|m.childd|
|00000600| 62 66 29 2b 27 20 64 61 | 74 61 62 61 73 65 27 29 |bf)+' da|tabase')|
|00000610| 0d 0a 45 4e 44 49 46 0d | 0a 49 46 20 45 4d 50 54 |..ENDIF.|.IF EMPT|
|00000620| 59 28 6d 2e 63 68 69 6c | 64 64 62 66 29 20 4f 52 |Y(m.chil|ddbf) OR|
|00000630| 20 21 46 49 4c 45 28 6d | 2e 63 68 69 6c 64 64 62 | !FILE(m|.childdb|
|00000640| 66 29 0d 0a 20 20 20 6d | 2e 63 68 69 6c 64 64 62 |f)..   m|.childdb|
|00000650| 66 20 3d 20 27 27 0d 0a | 20 20 20 52 45 54 55 52 |f = ''..|   RETUR|
|00000660| 4e 0d 0a 45 4e 44 49 46 | 0d 0a 0d 0a 0d 0a 2a 20 |N..ENDIF|......* |
|00000670| 46 69 6c 6c 20 69 6e 20 | 74 68 65 20 70 61 72 65 |Fill in |the pare|
|00000680| 6e 74 6c 69 73 74 20 77 | 69 74 68 20 74 68 65 20 |ntlist w|ith the |
|00000690| 6e 61 6d 65 73 20 6f 66 | 20 61 6c 6c 20 66 69 65 |names of| all fie|
|000006a0| 6c 64 73 0d 0a 2a 20 20 | 20 69 6e 20 61 6c 6c 20 |lds..*  | in all |
|000006b0| 6f 70 65 6e 20 64 61 74 | 61 62 61 73 65 73 0d 0a |open dat|abases..|
|000006c0| 6d 2e 70 61 72 65 6e 74 | 72 6f 77 20 3d 20 30 0d |m.parent|row = 0.|
|000006d0| 0a 44 49 4d 45 4e 53 49 | 4f 4e 20 70 61 72 65 6e |.DIMENSI|ON paren|
|000006e0| 74 6c 69 73 74 5b 31 5d | 0d 0a 70 61 72 65 6e 74 |tlist[1]|..parent|
|000006f0| 6c 69 73 74 5b 31 5d 20 | 3d 20 22 22 0d 0a 46 4f |list[1] |= ""..FO|
|00000700| 52 20 6d 2e 69 20 3d 20 | 31 20 54 4f 20 32 35 0d |R m.i = |1 TO 25.|
|00000710| 0a 20 20 20 53 45 4c 45 | 43 54 20 28 6d 2e 69 29 |.   SELE|CT (m.i)|
|00000720| 0d 0a 20 20 20 49 46 20 | 21 45 4d 50 54 59 28 44 |..   IF |!EMPTY(D|
|00000730| 42 46 28 6d 2e 69 29 29 | 20 41 4e 44 20 6d 61 6b |BF(m.i))| AND mak|
|00000740| 65 61 6c 69 61 73 28 6a | 75 73 74 73 74 65 6d 28 |ealias(j|uststem(|
|00000750| 44 42 46 28 6d 2e 69 29 | 29 29 20 3c 3e 20 6d 61 |DBF(m.i)|)) <> ma|
|00000760| 6b 65 61 6c 69 61 73 28 | 6a 75 73 74 73 74 65 6d |kealias(|juststem|
|00000770| 28 6d 2e 63 68 69 6c 64 | 73 74 65 6d 29 29 0d 0a |(m.child|stem))..|
|00000780| 20 20 20 20 20 20 46 4f | 52 20 6d 2e 6a 20 3d 20 |      FO|R m.j = |
|00000790| 31 20 54 4f 20 46 43 4f | 55 4e 54 28 6d 2e 69 29 |1 TO FCO|UNT(m.i)|
|000007a0| 0d 0a 20 20 20 20 20 20 | 20 20 20 6d 2e 70 61 72 |..      |   m.par|
|000007b0| 65 6e 74 72 6f 77 20 3d | 20 6d 2e 70 61 72 65 6e |entrow =| m.paren|
|000007c0| 74 72 6f 77 20 2b 20 31 | 0d 0a 20 20 20 20 20 20 |trow + 1|..      |
|000007d0| 20 20 20 44 49 4d 45 4e | 53 49 4f 4e 20 70 61 72 |   DIMEN|SION par|
|000007e0| 65 6e 74 6c 69 73 74 5b | 6d 2e 70 61 72 65 6e 74 |entlist[|m.parent|
|000007f0| 72 6f 77 5d 0d 0a 20 20 | 20 20 20 20 20 20 20 70 |row]..  |       p|
|00000800| 61 72 65 6e 74 6c 69 73 | 74 5b 6d 2e 70 61 72 65 |arentlis|t[m.pare|
|00000810| 6e 74 72 6f 77 5d 20 3d | 20 61 64 64 74 79 70 65 |ntrow] =| addtype|
|00000820| 28 41 4c 49 41 53 28 6d | 2e 69 29 2b 27 2e 27 2b |(ALIAS(m|.i)+'.'+|
|00000830| 46 49 45 4c 44 28 6d 2e | 6a 2c 6d 2e 69 29 29 0d |FIELD(m.|j,m.i)).|
|00000840| 0a 20 20 20 20 20 20 45 | 4e 44 46 4f 52 0d 0a 20 |.      E|NDFOR.. |
|00000850| 20 20 45 4e 44 49 46 0d | 0a 45 4e 44 46 4f 52 0d |  ENDIF.|.ENDFOR.|
|00000860| 0a 0d 0a 0d 0a 2a 20 46 | 69 6c 6c 20 69 6e 20 74 |.....* F|ill in t|
|00000870| 68 65 20 63 68 69 6c 64 | 6c 69 73 74 20 77 69 74 |he child|list wit|
|00000880| 68 20 74 68 65 20 6e 61 | 6d 65 73 20 6f 66 20 61 |h the na|mes of a|
|00000890| 6c 6c 20 66 69 65 6c 64 | 73 0d 0a 2a 20 20 20 69 |ll field|s..*   i|
|000008a0| 6e 20 74 68 65 20 63 68 | 69 6c 64 20 64 61 74 61 |n the ch|ild data|
|000008b0| 62 61 73 65 0d 0a 6d 2e | 63 68 69 6c 64 72 6f 77 |base..m.|childrow|
|000008c0| 20 3d 20 30 0d 0a 44 49 | 4d 45 4e 53 49 4f 4e 20 | = 0..DI|MENSION |
|000008d0| 63 68 69 6c 64 6c 69 73 | 74 5b 31 5d 0d 0a 63 68 |childlis|t[1]..ch|
|000008e0| 69 6c 64 6c 69 73 74 28 | 31 29 20 3d 20 22 22 0d |ildlist(|1) = "".|
|000008f0| 0a 49 46 20 55 53 45 44 | 28 6d 61 6b 65 61 6c 69 |.IF USED|(makeali|
|00000900| 61 73 28 6d 2e 63 68 69 | 6c 64 73 74 65 6d 29 29 |as(m.chi|ldstem))|
|00000910| 0d 0a 20 20 20 6d 2e 61 | 6c 5f 6e 61 6d 65 20 3d |..   m.a|l_name =|
|00000920| 20 6d 61 6b 65 61 6c 69 | 61 73 28 6d 2e 63 68 69 | makeali|as(m.chi|
|00000930| 6c 64 73 74 65 6d 29 0d | 0a 20 20 20 53 45 4c 45 |ldstem).|.   SELE|
|00000940| 43 54 20 28 6d 2e 61 6c | 5f 6e 61 6d 65 29 0d 0a |CT (m.al|_name)..|
|00000950| 45 4c 53 45 0d 0a 20 20 | 20 53 45 4c 45 43 54 20 |ELSE..  | SELECT |
|00000960| 30 0d 0a 20 20 20 55 53 | 45 20 28 6d 2e 63 68 69 |0..   US|E (m.chi|
|00000970| 6c 64 64 62 66 29 0d 0a | 45 4e 44 49 46 0d 0a 46 |lddbf)..|ENDIF..F|
|00000980| 4f 52 20 6d 2e 6a 20 3d | 20 31 20 54 4f 20 46 43 |OR m.j =| 1 TO FC|
|00000990| 4f 55 4e 54 28 29 0d 0a | 20 20 20 49 46 20 54 59 |OUNT()..|   IF TY|
|000009a0| 50 45 28 46 49 45 4c 44 | 28 6d 2e 6a 29 29 20 3c |PE(FIELD|(m.j)) <|
|000009b0| 3e 20 22 4d 22 0d 0a 20 | 20 20 20 20 20 6d 2e 63 |> "M".. |     m.c|
|000009c0| 68 69 6c 64 72 6f 77 20 | 3d 20 6d 2e 63 68 69 6c |hildrow |= m.chil|
|000009d0| 64 72 6f 77 20 2b 20 31 | 0d 0a 20 20 20 20 20 20 |drow + 1|..      |
|000009e0| 44 49 4d 45 4e 53 49 4f | 4e 20 63 68 69 6c 64 6c |DIMENSIO|N childl|
|000009f0| 69 73 74 5b 6d 2e 63 68 | 69 6c 64 72 6f 77 5d 0d |ist[m.ch|ildrow].|
|00000a00| 0a 20 20 20 20 20 20 63 | 68 69 6c 64 6c 69 73 74 |.      c|hildlist|
|00000a10| 5b 6d 2e 63 68 69 6c 64 | 72 6f 77 5d 20 3d 20 61 |[m.child|row] = a|
|00000a20| 64 64 74 79 70 65 28 41 | 4c 49 41 53 28 29 2b 27 |ddtype(A|LIAS()+'|
|00000a30| 2e 27 2b 46 49 45 4c 44 | 28 6d 2e 6a 29 29 0d 0a |.'+FIELD|(m.j))..|
|00000a40| 20 20 20 45 4e 44 49 46 | 0d 0a 45 4e 44 46 4f 52 |   ENDIF|..ENDFOR|
|00000a50| 0d 0a 0d 0a 2a 20 50 6f | 73 69 74 69 6f 6e 20 73 |....* Po|sition s|
|00000a60| 65 6c 65 63 74 69 6f 6e | 20 62 61 72 73 20 6f 6e |election| bars on|
|00000a70| 74 6f 20 69 6e 74 65 6c | 6c 69 67 65 6e 74 20 64 |to intel|ligent d|
|00000a80| 65 66 61 75 6c 74 73 2e | 20 20 54 72 79 20 74 6f |efaults.|  Try to|
|00000a90| 20 6d 61 74 63 68 0d 0a | 2a 20 66 69 65 6c 64 20 | match..|* field |
|00000aa0| 6e 61 6d 65 73 20 62 65 | 74 77 65 65 6e 20 74 68 |names be|tween th|
|00000ab0| 65 20 70 61 72 65 6e 74 | 20 61 6e 64 20 63 68 69 |e parent| and chi|
|00000ac0| 6c 64 20 64 61 74 61 62 | 61 73 65 73 2e 0d 0a 6d |ld datab|ases...m|
|00000ad0| 2e 64 6f 6e 65 20 3d 20 | 2e 46 2e 0d 0a 49 46 20 |.done = |.F...IF |
|00000ae0| 45 4d 50 54 59 28 6d 2e | 70 61 72 65 6e 74 66 6c |EMPTY(m.|parentfl|
|00000af0| 64 29 0d 0a 20 20 20 49 | 46 20 45 4d 50 54 59 28 |d)..   I|F EMPTY(|
|00000b00| 6d 2e 63 68 69 6c 64 66 | 6c 64 29 0d 0a 20 20 20 |m.childf|ld)..   |
|00000b10| 20 20 20 2a 20 53 65 65 | 20 69 66 20 74 68 65 72 |   * See| if ther|
|00000b20| 65 20 61 72 65 20 61 6e | 79 20 66 69 65 6c 64 73 |e are an|y fields|
|00000b30| 20 69 6e 20 74 68 65 20 | 70 61 72 65 6e 74 20 64 | in the |parent d|
|00000b40| 61 74 61 62 61 73 65 20 | 77 69 74 68 0d 0a 20 20 |atabase |with..  |
|00000b50| 20 20 20 20 2a 20 74 68 | 65 20 73 61 6d 65 20 6e |    * th|e same n|
|00000b60| 61 6d 65 20 61 6e 64 20 | 74 79 70 65 20 61 73 20 |ame and |type as |
|00000b70| 61 20 66 69 65 6c 64 20 | 69 6e 20 74 68 65 20 63 |a field |in the c|
|00000b80| 68 69 6c 64 20 64 61 74 | 61 62 61 73 65 0d 0a 20 |hild dat|abase.. |
|00000b90| 20 20 20 20 20 6d 2e 69 | 20 3d 20 31 0d 0a 20 20 |     m.i| = 1..  |
|00000ba0| 20 20 20 20 44 4f 20 57 | 48 49 4c 45 20 21 64 6f |    DO W|HILE !do|
|00000bb0| 6e 65 20 41 4e 44 20 6d | 2e 69 20 3c 3d 20 6d 2e |ne AND m|.i <= m.|
|00000bc0| 63 68 69 6c 64 72 6f 77 | 0d 0a 20 20 20 20 20 20 |childrow|..      |
|00000bd0| 20 20 20 6d 2e 6e 65 77 | 63 68 69 6c 64 20 20 3d |   m.new|child  =|
|00000be0| 20 53 55 42 53 54 52 28 | 63 68 69 6c 64 6c 69 73 | SUBSTR(|childlis|
|00000bf0| 74 5b 6d 2e 69 5d 2c 41 | 54 28 27 2e 27 2c 63 68 |t[m.i],A|T('.',ch|
|00000c00| 69 6c 64 6c 69 73 74 5b | 6d 2e 69 5d 29 2b 31 29 |ildlist[|m.i])+1)|
|00000c10| 0d 0a 20 20 20 20 20 20 | 20 20 20 6d 2e 6e 65 77 |..      |   m.new|
|00000c20| 63 68 69 6c 64 20 20 3d | 20 43 48 52 54 52 41 4e |child  =| CHRTRAN|
|00000c30| 28 6d 2e 6e 65 77 63 68 | 69 6c 64 2c 27 20 27 2c |(m.newch|ild,' ',|
|00000c40| 27 27 29 0d 0a 20 20 20 | 20 20 20 20 20 20 6d 2e |'')..   |      m.|
|00000c50| 6a 20 3d 20 31 0d 0a 20 | 20 20 20 20 20 20 20 20 |j = 1.. |        |
|00000c60| 44 4f 20 57 48 49 4c 45 | 20 21 6d 2e 64 6f 6e 65 |DO WHILE| !m.done|
|00000c70| 20 41 4e 44 20 6d 2e 6a | 20 3c 3d 20 6d 2e 70 61 | AND m.j| <= m.pa|
|00000c80| 72 65 6e 74 72 6f 77 0d | 0a 20 20 20 20 20 20 20 |rentrow.|.       |
|00000c90| 20 20 20 20 20 2a 20 41 | 73 73 65 6d 62 6c 65 20 |     * A|ssemble |
|00000ca0| 61 20 6e 65 77 20 6e 61 | 6d 65 20 62 61 73 65 64 |a new na|me based|
|00000cb0| 20 6f 6e 20 74 68 65 20 | 66 69 65 6c 64 20 6e 61 | on the |field na|
|00000cc0| 6d 65 20 61 6e 64 20 74 | 68 65 20 66 69 65 6c 64 |me and t|he field|
|00000cd0| 20 74 79 70 65 0d 0a 20 | 20 20 20 20 20 20 20 20 | type.. |        |
|00000ce0| 20 20 20 2a 20 54 68 65 | 20 70 61 72 65 6e 74 6c |   * The| parentl|
|00000cf0| 69 73 74 20 72 65 63 6f | 72 64 73 20 6c 6f 6f 6b |ist reco|rds look|
|00000d00| 20 6c 69 6b 65 20 74 68 | 69 73 3a 0d 0a 20 20 20 | like th|is:..   |
|00000d10| 20 20 20 20 20 20 20 20 | 20 2a 20 20 20 20 61 6c |        | *    al|
|00000d20| 69 61 73 2e 66 6c 64 20 | 20 20 20 20 20 20 28 4e |ias.fld |      (N|
|00000d30| 29 0d 0a 20 20 20 20 20 | 20 20 20 20 20 20 20 2a |)..     |       *|
|00000d40| 20 22 4e 65 77 70 61 72 | 65 6e 74 22 20 6e 6f 77 | "Newpar|ent" now|
|00000d50| 20 6c 6f 6f 6b 73 20 6c | 69 6b 65 20 74 68 69 73 | looks l|ike this|
|00000d60| 3a 0d 0a 20 20 20 20 20 | 20 20 20 20 20 20 20 2a |:..     |       *|
|00000d70| 20 20 20 20 20 66 6c 64 | 28 4e 29 0d 0a 20 20 20 |     fld|(N)..   |
|00000d80| 20 20 20 20 20 20 20 20 | 20 6d 2e 6e 65 77 70 61 |        | m.newpa|
|00000d90| 72 65 6e 74 20 3d 20 53 | 55 42 53 54 52 28 70 61 |rent = S|UBSTR(pa|
|00000da0| 72 65 6e 74 6c 69 73 74 | 5b 6d 2e 6a 5d 2c 41 54 |rentlist|[m.j],AT|
|00000db0| 28 27 2e 27 2c 70 61 72 | 65 6e 74 6c 69 73 74 5b |('.',par|entlist[|
|00000dc0| 6d 2e 6a 5d 29 2b 31 29 | 0d 0a 20 20 20 20 20 20 |m.j])+1)|..      |
|00000dd0| 20 20 20 20 20 20 6d 2e | 6e 65 77 70 61 72 65 6e |      m.|newparen|
|00000de0| 74 20 3d 20 43 48 52 54 | 52 41 4e 28 6e 65 77 70 |t = CHRT|RAN(newp|
|00000df0| 61 72 65 6e 74 2c 27 20 | 27 2c 27 27 29 0d 0a 0d |arent,' |','')...|
|00000e00| 0a 20 20 20 20 20 20 20 | 20 20 20 20 20 49 46 20 |.       |     IF |
|00000e10| 6d 2e 6e 65 77 70 61 72 | 65 6e 74 20 3d 3d 20 6d |m.newpar|ent == m|
|00000e20| 2e 6e 65 77 63 68 69 6c | 64 0d 0a 20 20 20 20 20 |.newchil|d..     |
|00000e30| 20 20 20 20 20 20 20 20 | 20 20 6d 2e 70 61 72 65 |        |  m.pare|
|00000e40| 6e 74 66 6c 64 20 3d 20 | 70 61 72 65 6e 74 6c 69 |ntfld = |parentli|
|00000e50| 73 74 5b 6d 2e 6a 5d 0d | 0a 20 20 20 20 20 20 20 |st[m.j].|.       |
|00000e60| 20 20 20 20 20 20 20 20 | 6d 2e 63 68 69 6c 64 66 |        |m.childf|
|00000e70| 6c 64 20 20 3d 20 63 68 | 69 6c 64 6c 69 73 74 5b |ld  = ch|ildlist[|
|00000e80| 6d 2e 69 5d 0d 0a 20 20 | 20 20 20 20 20 20 20 20 |m.i]..  |        |
|00000e90| 20 20 20 20 20 6d 2e 64 | 6f 6e 65 20 3d 20 2e 54 |     m.d|one = .T|
|00000ea0| 2e 0d 0a 20 20 20 20 20 | 20 20 20 20 20 20 20 45 |...     |       E|
|00000eb0| 4e 44 49 46 0d 0a 20 20 | 20 20 20 20 20 20 20 20 |NDIF..  |        |
|00000ec0| 20 20 6d 2e 6a 20 3d 20 | 6d 2e 6a 20 2b 20 31 0d |  m.j = |m.j + 1.|
|00000ed0| 0a 20 20 20 20 20 20 20 | 20 20 45 4e 44 44 4f 0d |.       |  ENDDO.|
|00000ee0| 0a 20 20 20 20 20 20 20 | 20 20 6d 2e 69 20 3d 20 |.       |  m.i = |
|00000ef0| 6d 2e 69 20 2b 20 31 0d | 0a 20 20 20 20 20 20 45 |m.i + 1.|.      E|
|00000f00| 4e 44 44 4f 0d 0a 0d 0a | 20 20 20 20 20 20 49 46 |NDDO....|      IF|
|00000f10| 20 21 6d 2e 64 6f 6e 65 | 20 20 20 20 26 26 20 6e | !m.done|    && n|
|00000f20| 6f 20 6d 61 74 63 68 65 | 73 20 66 6f 75 6e 64 2e |o matche|s found.|
|00000f30| 20 20 44 65 66 61 75 6c | 74 20 74 6f 20 66 69 72 |  Defaul|t to fir|
|00000f40| 73 74 20 66 69 65 6c 64 | 2e 0d 0a 20 20 20 20 20 |st field|...     |
|00000f50| 20 20 20 20 6d 2e 63 68 | 69 6c 64 66 6c 64 20 20 |    m.ch|ildfld  |
|00000f60| 20 3d 20 63 68 69 6c 64 | 6c 69 73 74 5b 31 5d 0d | = child|list[1].|
|00000f70| 0a 20 20 20 20 20 20 20 | 20 20 6d 2e 70 61 72 65 |.       |  m.pare|
|00000f80| 6e 74 66 6c 64 20 20 3d | 20 70 61 72 65 6e 74 6c |ntfld  =| parentl|
|00000f90| 69 73 74 5b 31 5d 0d 0a | 20 20 20 20 20 20 45 4e |ist[1]..|      EN|
|00000fa0| 44 49 46 0d 0a 20 20 20 | 45 4c 53 45 0d 0a 20 20 |DIF..   |ELSE..  |
|00000fb0| 20 20 20 20 2a 20 44 65 | 66 61 75 6c 74 20 74 6f |    * De|fault to|
|00000fc0| 20 74 68 65 20 66 69 72 | 73 74 20 66 69 65 6c 64 | the fir|st field|
|00000fd0| 20 0d 0a 20 20 20 20 20 | 20 6d 2e 70 61 72 65 6e | ..     | m.paren|
|00000fe0| 74 66 6c 64 20 20 3d 20 | 70 61 72 65 6e 74 6c 69 |tfld  = |parentli|
|00000ff0| 73 74 5b 31 5d 0d 0a 20 | 20 20 20 20 20 6d 2e 63 |st[1].. |     m.c|
|00001000| 68 69 6c 64 66 6c 64 20 | 20 20 3d 20 61 64 64 74 |hildfld |  = addt|
|00001010| 79 70 65 28 6d 2e 63 68 | 69 6c 64 66 6c 64 29 0d |ype(m.ch|ildfld).|
|00001020| 0a 20 20 20 45 4e 44 49 | 46 0d 0a 45 4c 53 45 0d |.   ENDI|F..ELSE.|
|00001030| 0a 20 20 20 6d 2e 70 61 | 72 65 6e 74 66 6c 64 20 |.   m.pa|rentfld |
|00001040| 20 3d 20 61 64 64 74 79 | 70 65 28 6d 2e 70 61 72 | = addty|pe(m.par|
|00001050| 65 6e 74 66 6c 64 29 0d | 0a 20 20 20 6d 2e 63 68 |entfld).|.   m.ch|
|00001060| 69 6c 64 66 6c 64 20 20 | 20 3d 20 61 64 64 74 79 |ildfld  | = addty|
|00001070| 70 65 28 6d 2e 63 68 69 | 6c 64 66 6c 64 29 0d 0a |pe(m.chi|ldfld)..|
|00001080| 45 4e 44 49 46 0d 0a 0d | 0a 44 4f 20 63 64 69 73 |ENDIF...|.DO cdis|
|00001090| 6c 69 73 74 20 57 49 54 | 48 20 41 53 43 41 4e 28 |list WIT|H ASCAN(|
|000010a0| 63 68 69 6c 64 6c 69 73 | 74 2c 6d 2e 63 68 69 6c |childlis|t,m.chil|
|000010b0| 64 66 6c 64 29 0d 0a 0d | 0a 53 45 4c 45 43 54 20 |dfld)...|.SELECT |
|000010c0| 28 6d 2e 69 6e 5f 61 72 | 65 61 29 0d 0a 00 00 00 |(m.in_ar|ea).....|
|000010d0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000010e0| 00 00 00 00 00 00 01 00 | 00 06 e7 0d 0a 2a 21 2a |........|.....*!*|
|000010f0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00001100| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00001110| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00001120| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00001130| 0d 0a 2a 21 0d 0a 2a 21 | 20 20 20 20 20 20 50 72 |..*!..*!|      Pr|
|00001140| 6f 63 65 64 75 72 65 3a | 20 41 44 44 54 59 50 45 |ocedure:| ADDTYPE|
|00001150| 0d 0a 2a 21 0d 0a 2a 21 | 2a 2a 2a 2a 2a 2a 2a 2a |..*!..*!|********|
|00001160| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00001170| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00001180| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00001190| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 0d 0a 46 55 4e 43 54 |********|*..FUNCT|
|000011a0| 49 4f 4e 20 61 64 64 74 | 79 70 65 0d 0a 2a 20 41 |ION addt|ype..* A|
|000011b0| 64 64 20 74 68 65 20 64 | 61 74 61 20 74 79 70 65 |dd the d|ata type|
|000011c0| 20 74 6f 20 61 20 66 69 | 65 6c 64 20 6e 61 6d 65 | to a fi|eld name|
|000011d0| 0d 0a 50 41 52 41 4d 45 | 54 45 52 20 66 6c 64 6e |..PARAME|TER fldn|
|000011e0| 61 6d 65 0d 0a 0d 0a 49 | 46 20 21 45 4d 50 54 59 |ame....I|F !EMPTY|
|000011f0| 28 6d 2e 66 6c 64 6e 61 | 6d 65 29 0d 0a 20 20 20 |(m.fldna|me)..   |
|00001200| 52 45 54 55 52 4e 20 50 | 41 44 52 28 6d 2e 66 6c |RETURN P|ADR(m.fl|
|00001210| 64 6e 61 6d 65 2c 32 30 | 29 20 2b 20 27 28 27 20 |dname,20|) + '(' |
|00001220| 2b 20 54 59 50 45 28 6d | 2e 66 6c 64 6e 61 6d 65 |+ TYPE(m|.fldname|
|00001230| 29 20 2b 20 27 29 27 0d | 0a 45 4c 53 45 0d 0a 20 |) + ')'.|.ELSE.. |
|00001240| 20 20 52 45 54 55 52 4e | 20 27 27 0d 0a 45 4e 44 |  RETURN| ''..END|
|00001250| 49 46 0d 0a 0d 0a 0d 0a | 2a 21 2a 2a 2a 2a 2a 2a |IF......|*!******|
|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 2a 2a 2a 2a 2a | 2a 2a 2a 0d 0a 2a 21 0d |********|***..*!.|
|000012a0| 0a 2a 21 20 20 20 20 20 | 20 50 72 6f 63 65 64 75 |.*!     | Procedu|
|000012b0| 72 65 3a 20 47 45 54 54 | 59 50 45 0d 0a 2a 21 0d |re: GETT|YPE..*!.|
|000012c0| 0a 2a 21 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |.*!*****|********|
|000012d0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|000012e0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|000012f0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00001300| 2a 2a 2a 2a 0d 0a 46 55 | 4e 43 54 49 4f 4e 20 67 |****..FU|NCTION g|
|00001310| 65 74 74 79 70 65 0d 0a | 50 41 52 41 4d 45 54 45 |ettype..|PARAMETE|
|00001320| 52 20 6d 2e 66 6c 64 6e | 61 6d 65 0d 0a 50 52 49 |R m.fldn|ame..PRI|
|00001330| 56 41 54 45 20 6d 2e 72 | 65 74 76 61 6c 0d 0a 2a |VATE m.r|etval..*|
|00001340| 20 54 68 69 73 20 66 75 | 6e 63 74 69 6f 6e 20 65 | This fu|nction e|
|00001350| 78 74 72 61 63 74 73 20 | 74 68 65 20 64 61 74 61 |xtracts |the data|
|00001360| 20 74 79 70 65 20 66 72 | 6f 6d 20 74 68 65 20 66 | type fr|om the f|
|00001370| 6f 72 6d 61 74 20 75 73 | 65 64 20 69 6e 0d 0a 2a |ormat us|ed in..*|
|00001380| 20 74 68 65 20 70 61 72 | 65 6e 74 6c 69 73 74 20 | the par|entlist |
|00001390| 61 6e 64 20 63 68 69 6c | 64 6c 69 73 74 20 61 72 |and chil|dlist ar|
|000013a0| 72 61 79 73 2e 20 20 54 | 68 65 20 69 6e 63 6f 6d |rays.  T|he incom|
|000013b0| 69 6e 67 20 66 6f 72 6d | 61 74 20 6c 6f 6f 6b 73 |ing form|at looks|
|000013c0| 0d 0a 2a 20 6c 69 6b 65 | 3a 0d 0a 2a 20 20 20 20 |..* like|:..*    |
|000013d0| 20 20 20 20 44 42 46 41 | 4c 49 41 53 2e 46 49 45 |    DBFA|LIAS.FIE|
|000013e0| 4c 44 20 20 20 20 20 20 | 28 43 29 0d 0a 2a 0d 0a |LD      |(C)..*..|
|000013f0| 2a 20 54 68 65 20 66 75 | 6e 63 74 69 6f 6e 20 72 |* The fu|nction r|
|00001400| 65 74 75 72 6e 73 20 27 | 43 27 0d 0a 0d 0a 6d 2e |eturns '|C'....m.|
|00001410| 72 65 74 76 61 6c 20 3d | 20 52 49 47 48 54 28 54 |retval =| RIGHT(T|
|00001420| 52 49 4d 28 6d 2e 66 6c | 64 6e 61 6d 65 29 2c 33 |RIM(m.fl|dname),3|
|00001430| 29 0d 0a 6d 2e 72 65 74 | 76 61 6c 20 3d 20 55 50 |)..m.ret|val = UP|
|00001440| 50 45 52 28 41 4c 4c 54 | 52 49 4d 28 6d 2e 72 65 |PER(ALLT|RIM(m.re|
|00001450| 74 76 61 6c 29 29 0d 0a | 52 45 54 55 52 4e 20 43 |tval))..|RETURN C|
|00001460| 48 52 54 52 41 4e 28 6d | 2e 72 65 74 76 61 6c 2c |HRTRAN(m|.retval,|
|00001470| 27 28 29 27 2c 27 27 29 | 0d 0a 0d 0a 2a 21 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 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|000014b0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 0d |********|*******.|
|000014c0| 0a 2a 21 0d 0a 2a 21 20 | 20 20 20 20 20 50 72 6f |.*!..*! |     Pro|
|000014d0| 63 65 64 75 72 65 3a 20 | 43 44 49 53 4c 49 53 54 |cedure: |CDISLIST|
|000014e0| 0d 0a 2a 21 0d 0a 2a 21 | 2a 2a 2a 2a 2a 2a 2a 2a |..*!..*!|********|
|000014f0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00001500| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00001510| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00001520| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 0d 0a 50 52 4f 43 45 |********|*..PROCE|
|00001530| 44 55 52 45 20 63 64 69 | 73 6c 69 73 74 0d 0a 2a |DURE cdi|slist..*|
|00001540| 20 54 68 69 73 20 70 72 | 6f 63 65 64 75 72 65 20 | This pr|ocedure |
|00001550| 64 69 73 61 62 6c 65 73 | 20 66 69 65 6c 64 73 20 |disables| fields |
|00001560| 69 6e 20 74 68 65 20 70 | 61 72 65 6e 74 20 6c 69 |in the p|arent li|
|00001570| 73 74 20 74 68 61 74 20 | 68 61 76 65 20 61 20 64 |st that |have a d|
|00001580| 69 66 66 65 72 65 6e 74 | 0d 0a 2a 20 74 79 70 65 |ifferent|..* type|
|00001590| 20 66 72 6f 6d 20 74 68 | 65 20 63 75 72 72 65 6e | from th|e curren|
|000015a0| 74 20 66 69 65 6c 64 20 | 69 6e 20 74 68 65 20 63 |t field |in the c|
|000015b0| 68 69 6c 64 20 6c 69 73 | 74 0d 0a 0d 0a 50 41 52 |hild lis|t....PAR|
|000015c0| 41 4d 45 54 45 52 20 63 | 75 72 69 74 65 6d 0d 0a |AMETER c|uritem..|
|000015d0| 50 52 49 56 41 54 45 20 | 6d 2e 63 75 72 69 74 65 |PRIVATE |m.curite|
|000015e0| 6d 2c 20 6d 2e 73 6f 75 | 72 63 65 74 79 70 65 2c |m, m.sou|rcetype,|
|000015f0| 20 6d 2e 74 61 72 67 74 | 79 70 65 2c 20 6d 2e 69 | m.targt|ype, m.i|
|00001600| 0d 0a 0d 0a 49 46 20 6d | 2e 63 75 72 69 74 65 6d |....IF m|.curitem|
|00001610| 20 3c 3d 20 30 0d 0a 20 | 20 20 6d 2e 63 75 72 69 | <= 0.. |  m.curi|
|00001620| 74 65 6d 20 3d 20 31 0d | 0a 45 4e 44 49 46 0d 0a |tem = 1.|.ENDIF..|
|00001630| 0d 0a 6d 2e 73 6f 75 72 | 63 65 74 79 70 65 20 3d |..m.sour|cetype =|
|00001640| 20 67 65 74 74 79 70 65 | 28 63 68 69 6c 64 6c 69 | gettype|(childli|
|00001650| 73 74 5b 6d 2e 63 75 72 | 69 74 65 6d 5d 29 0d 0a |st[m.cur|item])..|
|00001660| 0d 0a 46 4f 52 20 6d 2e | 69 20 3d 20 31 20 54 4f |..FOR m.|i = 1 TO|
|00001670| 20 41 4c 45 4e 28 70 61 | 72 65 6e 74 6c 69 73 74 | ALEN(pa|rentlist|
|00001680| 29 0d 0a 20 20 20 6d 2e | 74 61 72 67 74 79 70 65 |)..   m.|targtype|
|00001690| 20 3d 20 67 65 74 74 79 | 70 65 28 70 61 72 65 6e | = getty|pe(paren|
|000016a0| 74 6c 69 73 74 5b 6d 2e | 69 5d 29 0d 0a 20 20 20 |tlist[m.|i])..   |
|000016b0| 49 46 20 6d 2e 73 6f 75 | 72 63 65 74 79 70 65 20 |IF m.sou|rcetype |
|000016c0| 3d 3d 20 6d 2e 74 61 72 | 67 74 79 70 65 0d 0a 20 |== m.tar|gtype.. |
|000016d0| 20 20 20 20 20 49 46 20 | 4c 45 46 54 28 70 61 72 |     IF |LEFT(par|
|000016e0| 65 6e 74 6c 69 73 74 5b | 6d 2e 69 5d 2c 31 29 20 |entlist[|m.i],1) |
|000016f0| 3d 20 27 5c 27 0d 0a 20 | 20 20 20 20 20 20 20 20 |= '\'.. |        |
|00001700| 70 61 72 65 6e 74 6c 69 | 73 74 5b 6d 2e 69 5d 20 |parentli|st[m.i] |
|00001710| 3d 20 53 55 42 53 54 52 | 28 70 61 72 65 6e 74 6c |= SUBSTR|(parentl|
|00001720| 69 73 74 5b 6d 2e 69 5d | 2c 32 29 0d 0a 20 20 20 |ist[m.i]|,2)..   |
|00001730| 20 20 20 45 4e 44 49 46 | 0d 0a 20 20 20 45 4c 53 |   ENDIF|..   ELS|
|00001740| 45 0d 0a 20 20 20 20 20 | 20 49 46 20 4c 45 46 54 |E..     | IF LEFT|
|00001750| 28 70 61 72 65 6e 74 6c | 69 73 74 5b 6d 2e 69 5d |(parentl|ist[m.i]|
|00001760| 2c 31 29 20 3c 3e 20 27 | 5c 27 0d 0a 20 20 20 20 |,1) <> '|\'..    |
|00001770| 20 20 20 20 20 70 61 72 | 65 6e 74 6c 69 73 74 5b |     par|entlist[|
|00001780| 6d 2e 69 5d 20 3d 20 27 | 5c 27 2b 70 61 72 65 6e |m.i] = '|\'+paren|
|00001790| 74 6c 69 73 74 5b 6d 2e | 69 5d 0d 0a 20 20 20 20 |tlist[m.|i]..    |
|000017a0| 20 20 45 4e 44 49 46 0d | 0a 20 20 20 45 4e 44 49 |  ENDIF.|.   ENDI|
|000017b0| 46 0d 0a 45 4e 44 46 4f | 52 0d 0a 53 48 4f 57 20 |F..ENDFO|R..SHOW |
|000017c0| 47 45 54 20 70 61 72 65 | 6e 74 6c 69 73 74 0d 0a |GET pare|ntlist..|
|000017d0| 0d 0a 00 00 00 00 00 00 | 00 00 00 00 01 00 00 00 |........|........|
|000017e0| 0b 43 6f 75 72 69 65 72 | 20 4e 65 77 00 00 00 00 |.Courier| New....|
|000017f0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 01 00 00 |........|........|
|00001800| 00 0b 6d 2e 70 61 72 65 | 6e 74 66 6c 64 00 00 00 |..m.pare|ntfld...|
|00001810| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 01 00 |........|........|
|00001820| 00 00 0a 70 61 72 65 6e | 74 6c 69 73 74 00 00 00 |...paren|tlist...|
|00001830| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 01 |........|........|
|00001840| 00 00 00 05 22 40 5e 20 | 22 00 00 00 00 00 00 00 |...."@^ |".......|
|00001850| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001860| 01 00 00 00 0b 53 48 4f | 57 20 47 45 54 53 0d 0a |.....SHO|W GETS..|
|00001870| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001880| 00 01 00 00 00 0d 4d 53 | 20 53 61 6e 73 20 53 65 |......MS| Sans Se|
|00001890| 72 69 66 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |rif.....|........|
|000018a0| 00 00 01 00 00 00 08 22 | 45 71 75 61 6c 73 22 00 |......."|Equals".|
|000018b0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000018c0| 00 00 00 01 00 00 00 0b | 43 6f 75 72 69 65 72 20 |........|Courier |
|000018d0| 4e 65 77 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |New.....|........|
|000018e0| 00 00 00 00 01 00 00 00 | 0a 6d 2e 63 68 69 6c 64 |........|.m.child|
|000018f0| 66 6c 64 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |fld.....|........|
|00001900| 00 00 00 00 00 01 00 00 | 00 09 63 68 69 6c 64 6c |........|..childl|
|00001910| 69 73 74 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |ist.....|........|
|00001920| 00 00 00 00 00 00 01 00 | 00 00 05 22 40 5e 20 22 |........|..."@^ "|
|00001930| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001940| 00 00 00 00 00 00 00 01 | 00 00 00 37 44 4f 20 63 |........|...7DO c|
|00001950| 64 69 73 6c 69 73 74 20 | 57 49 54 48 20 41 53 43 |dislist |WITH ASC|
|00001960| 41 4e 28 63 68 69 6c 64 | 6c 69 73 74 2c 63 68 69 |AN(child|list,chi|
|00001970| 6c 64 66 6c 64 29 0d 0a | 53 48 4f 57 20 47 45 54 |ldfld)..|SHOW GET|
|00001980| 53 0d 0a 00 00 00 00 00 | 00 01 00 00 00 0d 4d 53 |S.......|......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 00 17 22 |........|......."|
|000019b0| 46 69 65 6c 64 20 69 6e | 20 4f 74 68 65 72 20 54 |Field in| Other T|
|000019c0| 61 62 6c 65 3a 22 00 00 | 00 00 00 01 00 00 00 0d |able:"..|........|
|000019d0| 4d 53 20 53 61 6e 73 20 | 53 65 72 69 66 00 00 00 |MS Sans |Serif...|
|000019e0| 00 00 00 00 00 00 00 00 | 00 00 00 00 01 00 00 00 |........|........|
|000019f0| 16 22 46 69 65 6c 64 20 | 69 6e 20 54 68 69 73 20 |."Field |in This |
|00001a00| 54 61 62 6c 65 3a 22 00 | 00 00 00 00 00 01 00 00 |Table:".|........|
|00001a10| 00 0d 4d 53 20 53 61 6e | 73 20 53 65 72 69 66 00 |..MS San|s Serif.|
|00001a20| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 01 00 |........|........|
|00001a30| 00 00 2d 22 48 6f 77 20 | 69 73 20 54 68 69 73 20 |..-"How |is This |
|00001a40| 54 61 62 6c 65 20 52 65 | 6c 61 74 65 64 20 74 6f |Table Re|lated to|
|00001a50| 20 41 6e 6f 74 68 65 72 | 20 54 61 62 6c 65 3f 22 | Another| Table?"|
|00001a60| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001a70| 01 00 00 00 0d 4d 53 20 | 53 61 6e 73 20 53 65 72 |.....MS |Sans Ser|
|00001a80| 69 66 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |if......|........|
|00001a90| 00 01 00 00 00 09 6d 2e | 6f 6b 63 61 6e 63 6c 00 |......m.|okcancl.|
|00001aa0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001ab0| 00 00 01 00 00 00 18 22 | 40 2a 48 4e 20 5c 21 5c |......."|@*HN \!\|
|00001ac0| 3c 4f 4b 3b 5c 3f 5c 3c | 43 61 6e 63 65 6c 22 00 |<OK;\?\<|Cancel".|
|00001ad0| 00 00 00 01 00 00 05 b4 | 2a 20 53 74 72 69 70 20 |........|* Strip |
|00001ae0| 6f 66 66 20 74 68 65 20 | 74 79 70 65 20 64 65 73 |off the |type des|
|00001af0| 69 67 6e 61 74 69 6f 6e | 73 20 66 72 6f 6d 20 66 |ignation|s from f|
|00001b00| 69 65 6c 64 20 6e 61 6d | 65 73 0d 0a 6d 2e 70 66 |ield nam|es..m.pf|
|00001b10| 6c 64 20 3d 20 6d 2e 70 | 61 72 65 6e 74 66 6c 64 |ld = m.p|arentfld|
|00001b20| 0d 0a 6d 2e 63 66 6c 64 | 20 3d 20 6d 2e 63 68 69 |..m.cfld| = m.chi|
|00001b30| 6c 64 66 6c 64 0d 0a 49 | 46 20 41 54 28 27 28 27 |ldfld..I|F AT('('|
|00001b40| 2c 6d 2e 70 61 72 65 6e | 74 66 6c 64 29 20 3e 20 |,m.paren|tfld) > |
|00001b50| 30 0d 0a 20 20 20 6d 2e | 70 61 72 65 6e 74 66 6c |0..   m.|parentfl|
|00001b60| 64 20 3d 20 41 4c 4c 54 | 52 49 4d 28 53 55 42 53 |d = ALLT|RIM(SUBS|
|00001b70| 54 52 28 6d 2e 70 61 72 | 65 6e 74 66 6c 64 2c 31 |TR(m.par|entfld,1|
|00001b80| 2c 4c 45 4e 28 54 52 49 | 4d 28 6d 2e 70 61 72 65 |,LEN(TRI|M(m.pare|
|00001b90| 6e 74 66 6c 64 29 29 2d | 33 29 29 0d 0a 45 4e 44 |ntfld))-|3))..END|
|00001ba0| 49 46 0d 0a 49 46 20 41 | 54 28 27 28 27 2c 6d 2e |IF..IF A|T('(',m.|
|00001bb0| 63 68 69 6c 64 66 6c 64 | 29 20 3e 20 30 0d 0a 20 |childfld|) > 0.. |
|00001bc0| 20 20 6d 2e 63 68 69 6c | 64 66 6c 64 20 20 3d 20 |  m.chil|dfld  = |
|00001bd0| 41 4c 4c 54 52 49 4d 28 | 53 55 42 53 54 52 28 6d |ALLTRIM(|SUBSTR(m|
|00001be0| 2e 63 68 69 6c 64 66 6c | 64 2c 31 2c 4c 45 4e 28 |.childfl|d,1,LEN(|
|00001bf0| 54 52 49 4d 28 6d 2e 63 | 68 69 6c 64 66 6c 64 29 |TRIM(m.c|hildfld)|
|00001c00| 29 2d 33 29 29 0d 0a 45 | 4e 44 49 46 0d 0a 0d 0a |)-3))..E|NDIF....|
|00001c10| 44 4f 20 43 41 53 45 0d | 0a 43 41 53 45 20 6d 2e |DO CASE.|.CASE m.|
|00001c20| 6f 6b 63 61 6e 63 6c 20 | 3d 20 31 0d 0a 20 20 20 |okcancl |= 1..   |
|00001c30| 2a 20 4d 61 6b 65 20 73 | 75 72 65 20 74 68 69 73 |* Make s|ure this|
|00001c40| 20 69 73 20 61 20 76 61 | 6c 69 64 20 73 65 6c 65 | is a va|lid sele|
|00001c50| 63 74 69 6f 6e 20 77 69 | 74 68 20 72 65 73 70 65 |ction wi|th respe|
|00001c60| 63 74 20 74 6f 20 64 61 | 74 61 20 74 79 70 65 0d |ct to da|ta type.|
|00001c70| 0a 20 20 20 44 4f 20 43 | 41 53 45 0d 0a 20 20 20 |.   DO C|ASE..   |
|00001c80| 43 41 53 45 20 54 59 50 | 45 28 6d 2e 63 68 69 6c |CASE TYP|E(m.chil|
|00001c90| 64 66 6c 64 29 20 3d 20 | 27 55 27 0d 0a 20 20 20 |dfld) = |'U'..   |
|00001ca0| 20 20 20 57 41 49 54 20 | 57 49 4e 44 4f 57 20 22 |   WAIT |WINDOW "|
|00001cb0| 54 68 65 20 63 68 69 6c | 64 20 64 61 74 61 62 61 |The chil|d databa|
|00001cc0| 73 65 20 63 6f 75 6c 64 | 20 6e 6f 74 20 62 65 20 |se could| not be |
|00001cd0| 66 6f 75 6e 64 2e 22 0d | 0a 20 20 20 43 41 53 45 |found.".|.   CASE|
|00001ce0| 20 54 59 50 45 28 6d 2e | 70 61 72 65 6e 74 66 6c | TYPE(m.|parentfl|
|00001cf0| 64 29 20 3d 20 27 55 27 | 0d 0a 20 20 20 20 20 20 |d) = 'U'|..      |
|00001d00| 57 41 49 54 20 57 49 4e | 44 4f 57 20 22 54 68 65 |WAIT WIN|DOW "The|
|00001d10| 20 70 61 72 65 6e 74 20 | 64 61 74 61 62 61 73 65 | parent |database|
|00001d20| 20 63 6f 75 6c 64 20 6e | 6f 74 20 62 65 20 66 6f | could n|ot be fo|
|00001d30| 75 6e 64 2e 22 0d 0a 20 | 20 20 43 41 53 45 20 54 |und.".. |  CASE T|
|00001d40| 59 50 45 28 6d 2e 63 68 | 69 6c 64 66 6c 64 29 20 |YPE(m.ch|ildfld) |
|00001d50| 3d 3d 20 54 59 50 45 28 | 6d 2e 70 61 72 65 6e 74 |== TYPE(|m.parent|
|00001d60| 66 6c 64 29 0d 0a 20 20 | 20 20 20 20 6d 2e 64 62 |fld)..  |    m.db|
|00001d70| 66 70 61 72 74 20 20 20 | 3d 20 53 55 42 53 54 52 |fpart   |= SUBSTR|
|00001d80| 28 6d 2e 63 68 69 6c 64 | 66 6c 64 2c 31 2c 41 54 |(m.child|fld,1,AT|
|00001d90| 28 27 2e 27 2c 6d 2e 63 | 68 69 6c 64 66 6c 64 29 |('.',m.c|hildfld)|
|00001da0| 2d 31 29 0d 0a 20 20 20 | 20 20 20 6d 2e 72 65 6c |-1)..   |   m.rel|
|00001db0| 73 74 72 20 20 20 20 3d | 20 27 53 45 54 20 52 45 |str    =| 'SET RE|
|00001dc0| 4c 41 54 49 4f 4e 20 54 | 4f 20 27 3b 0d 0a 20 20 |LATION T|O ';..  |
|00001dd0| 20 20 20 20 20 20 20 2b | 53 55 42 53 54 52 28 6d |       +|SUBSTR(m|
|00001de0| 2e 70 61 72 65 6e 74 66 | 6c 64 2c 41 54 28 27 2e |.parentf|ld,AT('.|
|00001df0| 27 2c 6d 2e 70 61 72 65 | 6e 74 66 6c 64 29 2b 31 |',m.pare|ntfld)+1|
|00001e00| 29 3b 0d 0a 20 20 20 20 | 20 20 20 20 20 2b 27 20 |);..    |     +' |
|00001e10| 49 4e 54 4f 20 27 2b 6d | 2e 64 62 66 70 61 72 74 |INTO '+m|.dbfpart|
|00001e20| 0d 0a 20 20 20 20 20 20 | 6d 2e 70 61 72 65 6e 74 |..      |m.parent|
|00001e30| 64 62 66 20 3d 20 53 55 | 42 53 54 52 28 6d 2e 70 |dbf = SU|BSTR(m.p|
|00001e40| 61 72 65 6e 74 66 6c 64 | 2c 31 2c 41 54 28 27 2e |arentfld|,1,AT('.|
|00001e50| 27 2c 6d 2e 70 61 72 65 | 6e 74 66 6c 64 29 2d 31 |',m.pare|ntfld)-1|
|00001e60| 29 0d 0a 20 20 20 20 20 | 20 43 4c 45 41 52 20 52 |)..     | CLEAR R|
|00001e70| 45 41 44 0d 0a 20 20 20 | 4f 54 48 45 52 57 49 53 |EAD..   |OTHERWIS|
|00001e80| 45 0d 0a 20 20 20 20 20 | 20 57 41 49 54 20 57 49 |E..     | WAIT WI|
|00001e90| 4e 44 4f 57 20 22 50 61 | 72 65 6e 74 20 61 6e 64 |NDOW "Pa|rent and|
|00001ea0| 20 63 68 69 6c 64 20 68 | 61 76 65 20 64 69 66 66 | child h|ave diff|
|00001eb0| 65 72 65 6e 74 20 64 61 | 74 61 20 74 79 70 65 73 |erent da|ta types|
|00001ec0| 2e 22 0d 0a 20 20 20 20 | 20 20 2a 20 52 65 73 74 |."..    |  * Rest|
|00001ed0| 6f 72 65 20 66 75 6c 6c | 20 73 74 72 69 6e 67 20 |ore full| string |
|00001ee0| 74 6f 20 70 61 72 65 6e | 74 20 61 6e 64 20 63 68 |to paren|t and ch|
|00001ef0| 69 6c 64 20 66 69 65 6c | 64 73 0d 0a 20 20 20 20 |ild fiel|ds..    |
|00001f00| 20 20 6d 2e 70 61 72 65 | 6e 74 66 6c 64 20 3d 20 |  m.pare|ntfld = |
|00001f10| 6d 2e 70 66 6c 64 0d 0a | 20 20 20 20 20 20 6d 2e |m.pfld..|      m.|
|00001f20| 63 68 69 6c 64 66 6c 64 | 20 20 3d 20 6d 2e 63 66 |childfld|  = m.cf|
|00001f30| 6c 64 0d 0a 20 20 20 45 | 4e 44 43 41 53 45 0d 0a |ld..   E|NDCASE..|
|00001f40| 43 41 53 45 20 6d 2e 6f | 6b 63 61 6e 63 6c 20 3d |CASE m.o|kcancl =|
|00001f50| 20 32 20 20 20 20 20 26 | 26 20 63 61 6e 63 65 6c | 2     &|& cancel|
|00001f60| 20 74 68 69 73 20 72 65 | 6c 61 74 69 6f 6e 73 68 | this re|lationsh|
|00001f70| 69 70 0d 0a 20 20 20 2a | 20 57 65 20 6f 70 65 6e |ip..   *| We open|
|00001f80| 65 64 20 63 68 69 6c 64 | 73 74 65 6d 20 69 6e 20 |ed child|stem in |
|00001f90| 74 68 65 20 73 65 74 75 | 70 20 73 6e 69 70 70 65 |the setu|p snippe|
|00001fa0| 74 2e 20 20 43 6c 6f 73 | 65 20 69 74 20 6e 6f 77 |t.  Clos|e it now|
|00001fb0| 2e 0d 0a 20 20 20 49 46 | 20 6d 2e 61 64 64 6d 6f |...   IF| m.addmo|
|00001fc0| 64 65 20 41 4e 44 20 55 | 53 45 44 28 6d 2e 63 68 |de AND U|SED(m.ch|
|00001fd0| 69 6c 64 73 74 65 6d 29 | 0d 0a 20 20 20 20 20 20 |ildstem)|..      |
|00001fe0| 53 45 4c 45 43 54 20 28 | 6d 2e 63 68 69 6c 64 73 |SELECT (|m.childs|
|00001ff0| 74 65 6d 29 0d 0a 20 20 | 20 20 20 20 55 53 45 0d |tem)..  |    USE.|
|00002000| 0a 20 20 20 45 4e 44 49 | 46 0d 0a 20 20 20 6d 2e |.   ENDI|F..   m.|
|00002010| 64 62 66 70 61 72 74 20 | 20 20 3d 20 27 27 0d 0a |dbfpart |  = ''..|
|00002020| 20 20 20 6d 2e 63 68 69 | 6c 64 66 6c 64 20 20 3d |   m.chi|ldfld  =|
|00002030| 20 27 27 0d 0a 20 20 20 | 6d 2e 63 68 69 6c 64 64 | ''..   |m.childd|
|00002040| 62 66 20 20 3d 20 27 27 | 0d 0a 20 20 20 6d 2e 72 |bf  = ''|..   m.r|
|00002050| 65 6c 73 74 72 20 20 20 | 20 3d 20 27 27 0d 0a 20 |elstr   | = ''.. |
|00002060| 20 20 6d 2e 70 61 72 65 | 6e 74 64 62 66 20 3d 20 |  m.pare|ntdbf = |
|00002070| 27 27 0d 0a 20 20 20 43 | 4c 45 41 52 20 52 45 41 |''..   C|LEAR REA|
|00002080| 44 0d 0a 45 4e 44 43 41 | 53 45 0d 0a 00 00 00 00 |D..ENDCA|SE......|
|00002090| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000020a0| 01 00 00 00 04 22 4f 4b | 22 00 00 00 00 00 00 00 |....."OK|".......|
|000020b0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000020c0| 00 01 00 00 00 0d 4d 53 | 20 53 61 6e 73 20 53 65 |......MS| Sans Se|
|000020d0| 72 69 66 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |rif.....|........|
|000020e0| 00 00 01 00 00 00 08 6d | 2e 61 64 76 62 75 74 00 |.......m|.advbut.|
|000020f0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002100| 00 00 00 01 00 00 00 14 | 22 40 2a 48 4e 20 5c 3c |........|"@*HN \<|
|00002110| 41 64 76 61 6e 63 65 64 | 2e 2e 2e 22 00 00 00 00 |Advanced|..."....|
|00002120| 00 00 00 00 01 00 00 00 | 3c 44 4f 20 63 61 73 63 |........|<DO casc|
|00002130| 64 6c 67 2e 73 70 72 20 | 57 49 54 48 20 64 62 66 |dlg.spr |WITH dbf|
|00002140| 6c 69 73 74 5b 6d 2e 6e | 65 78 74 64 62 66 2c 6d |list[m.n|extdbf,m|
|00002150| 2e 63 73 74 65 6d 6e 75 | 6d 5d 0d 0a 0d 0a 20 20 |.cstemnu|m]....  |
|00002160| 20 0d 0a 0d 0a 00 00 00 | 00 00 00 00 00 00 00 00 | .......|........|
|00002170| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002180| 00 00 00 00 00 00 00 01 | 00 00 00 0d 22 41 64 76 |........|...."Adv|
|00002190| 61 6e 63 65 64 2e 2e 2e | 22 00 00 00 00 00 00 00 |anced...|".......|
|000021a0| 00 00 00 00 00 00 00 00 | 01 00 00 00 0d 4d 53 20 |........|.....MS |
|000021b0| 53 61 6e 73 20 53 65 72 | 69 66 00 00 00 00 00 00 |Sans Ser|if......|
|000021c0| 00 00 00 00 00 00 00 00 | 00 01 00 00 00 0b 43 6f |........|......Co|
|000021d0| 75 72 69 65 72 20 4e 65 | 77 00 00 00 00 00 00 00 |urier Ne|w.......|
|000021e0| 00 00 00 00 00 00 00 00 | 00 00 01 00 00 00 08 52 |........|.......R|
|000021f0| 45 4c 53 45 4c 45 43 00 | 00 00 00 00 00 00 00 00 |ELSELEC.|........|
|00002200| 00 00 00 00 00 00 00 00 | 00 00 00 01 00 00 00 16 |........|........|
|00002210| 22 4f 70 74 69 6f 6e 73 | 20 66 6f 72 20 26 74 68 |"Options| for &th|
|00002220| 69 73 64 62 66 22 00 00 | 00 00 00 00 01 00 00 00 |isdbf"..|........|
|00002230| 0d 4d 53 20 53 61 6e 73 | 20 53 65 72 69 66 00 00 |.MS Sans| Serif..|
|00002240| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 01 00 00 |........|........|
|00002250| 00 c5 49 46 20 45 4d 50 | 54 59 28 6d 2e 70 61 72 |..IF EMP|TY(m.par|
|00002260| 65 6e 74 66 6c 64 29 20 | 3b 0d 0a 20 20 20 20 20 |entfld) |;..     |
|00002270| 20 4f 52 20 4c 45 46 54 | 28 6d 2e 70 61 72 65 6e | OR LEFT|(m.paren|
|00002280| 74 66 6c 64 2c 31 29 20 | 3d 20 27 5c 27 20 3b 0d |tfld,1) |= '\' ;.|
|00002290| 0a 20 20 20 20 20 20 4f | 52 20 28 67 65 74 74 79 |.      O|R (getty|
|000022a0| 70 65 28 6d 2e 70 61 72 | 65 6e 74 66 6c 64 29 20 |pe(m.par|entfld) |
|000022b0| 21 3d 20 67 65 74 74 79 | 70 65 28 6d 2e 63 68 69 |!= getty|pe(m.chi|
|000022c0| 6c 64 66 6c 64 29 29 0d | 0a 20 20 20 53 48 4f 57 |ldfld)).|.   SHOW|
|000022d0| 20 47 45 54 20 6d 2e 6f | 6b 63 61 6e 63 6c 2c 31 | GET m.o|kcancl,1|
|000022e0| 20 44 49 53 41 42 4c 45 | 0d 0a 45 4c 53 45 0d 0a | DISABLE|..ELSE..|
|000022f0| 20 20 20 53 48 4f 57 20 | 47 45 54 20 6d 2e 6f 6b |   SHOW |GET m.ok|
|00002300| 63 61 6e 63 6c 2c 31 20 | 45 4e 41 42 4c 45 0d 0a |cancl,1 |ENABLE..|
|00002310| 45 4e 44 49 46 0d 0a 00 | 00 00 00 00 00 00 00 00 |ENDIF...|........|
|00002320| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002330| 00 00 00 00 01 00 00 06 | e7 0d 0a 2a 21 2a 2a 2a |........|...*!***|
|00002340| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00002350| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00002360| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00002370| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 0d 0a |********|******..|
|00002380| 2a 21 0d 0a 2a 21 20 20 | 20 20 20 20 50 72 6f 63 |*!..*!  |    Proc|
|00002390| 65 64 75 72 65 3a 20 41 | 44 44 54 59 50 45 0d 0a |edure: A|DDTYPE..|
|000023a0| 2a 21 0d 0a 2a 21 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |*!..*!**|********|
|000023b0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|000023c0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|000023d0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|000023e0| 2a 2a 2a 2a 2a 2a 2a 0d | 0a 46 55 4e 43 54 49 4f |*******.|.FUNCTIO|
|000023f0| 4e 20 61 64 64 74 79 70 | 65 0d 0a 2a 20 41 64 64 |N addtyp|e..* Add|
|00002400| 20 74 68 65 20 64 61 74 | 61 20 74 79 70 65 20 74 | the dat|a type t|
|00002410| 6f 20 61 20 66 69 65 6c | 64 20 6e 61 6d 65 0d 0a |o a fiel|d name..|
|00002420| 50 41 52 41 4d 45 54 45 | 52 20 66 6c 64 6e 61 6d |PARAMETE|R fldnam|
|00002430| 65 0d 0a 0d 0a 49 46 20 | 21 45 4d 50 54 59 28 6d |e....IF |!EMPTY(m|
|00002440| 2e 66 6c 64 6e 61 6d 65 | 29 0d 0a 20 20 20 52 45 |.fldname|)..   RE|
|00002450| 54 55 52 4e 20 50 41 44 | 52 28 6d 2e 66 6c 64 6e |TURN PAD|R(m.fldn|
|00002460| 61 6d 65 2c 32 30 29 20 | 2b 20 27 28 27 20 2b 20 |ame,20) |+ '(' + |
|00002470| 54 59 50 45 28 6d 2e 66 | 6c 64 6e 61 6d 65 29 20 |TYPE(m.f|ldname) |
|00002480| 2b 20 27 29 27 0d 0a 45 | 4c 53 45 0d 0a 20 20 20 |+ ')'..E|LSE..   |
|00002490| 52 45 54 55 52 4e 20 27 | 27 0d 0a 45 4e 44 49 46 |RETURN '|'..ENDIF|
|000024a0| 0d 0a 0d 0a 0d 0a 2a 21 | 2a 2a 2a 2a 2a 2a 2a 2a |......*!|********|
|000024b0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|000024c0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|000024d0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|000024e0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 0d 0a 2a 21 0d 0a 2a |********|*..*!..*|
|000024f0| 21 20 20 20 20 20 20 50 | 72 6f 63 65 64 75 72 65 |!      P|rocedure|
|00002500| 3a 20 47 45 54 54 59 50 | 45 0d 0a 2a 21 0d 0a 2a |: GETTYP|E..*!..*|
|00002510| 21 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |!*******|********|
|00002520| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00002530| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00002540| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00002550| 2a 2a 0d 0a 46 55 4e 43 | 54 49 4f 4e 20 67 65 74 |**..FUNC|TION get|
|00002560| 74 79 70 65 0d 0a 50 41 | 52 41 4d 45 54 45 52 20 |type..PA|RAMETER |
|00002570| 6d 2e 66 6c 64 6e 61 6d | 65 0d 0a 50 52 49 56 41 |m.fldnam|e..PRIVA|
|00002580| 54 45 20 6d 2e 72 65 74 | 76 61 6c 0d 0a 2a 20 54 |TE m.ret|val..* T|
|00002590| 68 69 73 20 66 75 6e 63 | 74 69 6f 6e 20 65 78 74 |his func|tion ext|
|000025a0| 72 61 63 74 73 20 74 68 | 65 20 64 61 74 61 20 74 |racts th|e data t|
|000025b0| 79 70 65 20 66 72 6f 6d | 20 74 68 65 20 66 6f 72 |ype from| the for|
|000025c0| 6d 61 74 20 75 73 65 64 | 20 69 6e 0d 0a 2a 20 74 |mat used| in..* t|
|000025d0| 68 65 20 70 61 72 65 6e | 74 6c 69 73 74 20 61 6e |he paren|tlist an|
|000025e0| 64 20 63 68 69 6c 64 6c | 69 73 74 20 61 72 72 61 |d childl|ist arra|
|000025f0| 79 73 2e 20 20 54 68 65 | 20 69 6e 63 6f 6d 69 6e |ys.  The| incomin|
|00002600| 67 20 66 6f 72 6d 61 74 | 20 6c 6f 6f 6b 73 0d 0a |g format| looks..|
|00002610| 2a 20 6c 69 6b 65 3a 0d | 0a 2a 20 20 20 20 20 20 |* like:.|.*      |
|00002620| 20 20 44 42 46 41 4c 49 | 41 53 2e 46 49 45 4c 44 |  DBFALI|AS.FIELD|
|00002630| 20 20 20 20 20 20 28 43 | 29 0d 0a 2a 0d 0a 2a 20 |      (C|)..*..* |
|00002640| 54 68 65 20 66 75 6e 63 | 74 69 6f 6e 20 72 65 74 |The func|tion ret|
|00002650| 75 72 6e 73 20 27 43 27 | 0d 0a 0d 0a 6d 2e 72 65 |urns 'C'|....m.re|
|00002660| 74 76 61 6c 20 3d 20 52 | 49 47 48 54 28 54 52 49 |tval = R|IGHT(TRI|
|00002670| 4d 28 6d 2e 66 6c 64 6e | 61 6d 65 29 2c 33 29 0d |M(m.fldn|ame),3).|
|00002680| 0a 6d 2e 72 65 74 76 61 | 6c 20 3d 20 55 50 50 45 |.m.retva|l = UPPE|
|00002690| 52 28 41 4c 4c 54 52 49 | 4d 28 6d 2e 72 65 74 76 |R(ALLTRI|M(m.retv|
|000026a0| 61 6c 29 29 0d 0a 52 45 | 54 55 52 4e 20 43 48 52 |al))..RE|TURN CHR|
|000026b0| 54 52 41 4e 28 6d 2e 72 | 65 74 76 61 6c 2c 27 28 |TRAN(m.r|etval,'(|
|000026c0| 29 27 2c 27 27 29 0d 0a | 0d 0a 2a 21 2a 2a 2a 2a |)','')..|..*!****|
|000026d0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|000026e0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|000026f0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00002700| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 0d 0a 2a |********|*****..*|
|00002710| 21 0d 0a 2a 21 20 20 20 | 20 20 20 50 72 6f 63 65 |!..*!   |   Proce|
|00002720| 64 75 72 65 3a 20 43 44 | 49 53 4c 49 53 54 0d 0a |dure: CD|ISLIST..|
|00002730| 2a 21 0d 0a 2a 21 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |*!..*!**|********|
|00002740| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00002750| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00002760| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00002770| 2a 2a 2a 2a 2a 2a 2a 0d | 0a 50 52 4f 43 45 44 55 |*******.|.PROCEDU|
|00002780| 52 45 20 63 64 69 73 6c | 69 73 74 0d 0a 2a 20 54 |RE cdisl|ist..* T|
|00002790| 68 69 73 20 70 72 6f 63 | 65 64 75 72 65 20 64 69 |his proc|edure di|
|000027a0| 73 61 62 6c 65 73 20 66 | 69 65 6c 64 73 20 69 6e |sables f|ields in|
|000027b0| 20 74 68 65 20 70 61 72 | 65 6e 74 20 6c 69 73 74 | the par|ent list|
|000027c0| 20 74 68 61 74 20 68 61 | 76 65 20 61 20 64 69 66 | that ha|ve a dif|
|000027d0| 66 65 72 65 6e 74 0d 0a | 2a 20 74 79 70 65 20 66 |ferent..|* type f|
|000027e0| 72 6f 6d 20 74 68 65 20 | 63 75 72 72 65 6e 74 20 |rom the |current |
|000027f0| 66 69 65 6c 64 20 69 6e | 20 74 68 65 20 63 68 69 |field in| the chi|
|00002800| 6c 64 20 6c 69 73 74 0d | 0a 0d 0a 50 41 52 41 4d |ld list.|...PARAM|
|00002810| 45 54 45 52 20 63 75 72 | 69 74 65 6d 0d 0a 50 52 |ETER cur|item..PR|
|00002820| 49 56 41 54 45 20 6d 2e | 63 75 72 69 74 65 6d 2c |IVATE m.|curitem,|
|00002830| 20 6d 2e 73 6f 75 72 63 | 65 74 79 70 65 2c 20 6d | m.sourc|etype, m|
|00002840| 2e 74 61 72 67 74 79 70 | 65 2c 20 6d 2e 69 0d 0a |.targtyp|e, m.i..|
|00002850| 0d 0a 49 46 20 6d 2e 63 | 75 72 69 74 65 6d 20 3c |..IF m.c|uritem <|
|00002860| 3d 20 30 0d 0a 20 20 20 | 6d 2e 63 75 72 69 74 65 |= 0..   |m.curite|
|00002870| 6d 20 3d 20 31 0d 0a 45 | 4e 44 49 46 0d 0a 0d 0a |m = 1..E|NDIF....|
|00002880| 6d 2e 73 6f 75 72 63 65 | 74 79 70 65 20 3d 20 67 |m.source|type = g|
|00002890| 65 74 74 79 70 65 28 63 | 68 69 6c 64 6c 69 73 74 |ettype(c|hildlist|
|000028a0| 5b 6d 2e 63 75 72 69 74 | 65 6d 5d 29 0d 0a 0d 0a |[m.curit|em])....|
|000028b0| 46 4f 52 20 6d 2e 69 20 | 3d 20 31 20 54 4f 20 41 |FOR m.i |= 1 TO A|
|000028c0| 4c 45 4e 28 70 61 72 65 | 6e 74 6c 69 73 74 29 0d |LEN(pare|ntlist).|
|000028d0| 0a 20 20 20 6d 2e 74 61 | 72 67 74 79 70 65 20 3d |.   m.ta|rgtype =|
|000028e0| 20 67 65 74 74 79 70 65 | 28 70 61 72 65 6e 74 6c | gettype|(parentl|
|000028f0| 69 73 74 5b 6d 2e 69 5d | 29 0d 0a 20 20 20 49 46 |ist[m.i]|)..   IF|
|00002900| 20 6d 2e 73 6f 75 72 63 | 65 74 79 70 65 20 3d 3d | m.sourc|etype ==|
|00002910| 20 6d 2e 74 61 72 67 74 | 79 70 65 0d 0a 20 20 20 | m.targt|ype..   |
|00002920| 20 20 20 49 46 20 4c 45 | 46 54 28 70 61 72 65 6e |   IF LE|FT(paren|
|00002930| 74 6c 69 73 74 5b 6d 2e | 69 5d 2c 31 29 20 3d 20 |tlist[m.|i],1) = |
|00002940| 27 5c 27 0d 0a 20 20 20 | 20 20 20 20 20 20 70 61 |'\'..   |      pa|
|00002950| 72 65 6e 74 6c 69 73 74 | 5b 6d 2e 69 5d 20 3d 20 |rentlist|[m.i] = |
|00002960| 53 55 42 53 54 52 28 70 | 61 72 65 6e 74 6c 69 73 |SUBSTR(p|arentlis|
|00002970| 74 5b 6d 2e 69 5d 2c 32 | 29 0d 0a 20 20 20 20 20 |t[m.i],2|)..     |
|00002980| 20 45 4e 44 49 46 0d 0a | 20 20 20 45 4c 53 45 0d | ENDIF..|   ELSE.|
|00002990| 0a 20 20 20 20 20 20 49 | 46 20 4c 45 46 54 28 70 |.      I|F LEFT(p|
|000029a0| 61 72 65 6e 74 6c 69 73 | 74 5b 6d 2e 69 5d 2c 31 |arentlis|t[m.i],1|
|000029b0| 29 20 3c 3e 20 27 5c 27 | 0d 0a 20 20 20 20 20 20 |) <> '\'|..      |
|000029c0| 20 20 20 70 61 72 65 6e | 74 6c 69 73 74 5b 6d 2e |   paren|tlist[m.|
|000029d0| 69 5d 20 3d 20 27 5c 27 | 2b 70 61 72 65 6e 74 6c |i] = '\'|+parentl|
|000029e0| 69 73 74 5b 6d 2e 69 5d | 0d 0a 20 20 20 20 20 20 |ist[m.i]|..      |
|000029f0| 45 4e 44 49 46 0d 0a 20 | 20 20 45 4e 44 49 46 0d |ENDIF.. |  ENDIF.|
|00002a00| 0a 45 4e 44 46 4f 52 0d | 0a 53 48 4f 57 20 47 45 |.ENDFOR.|.SHOW GE|
|00002a10| 54 20 70 61 72 65 6e 74 | 6c 69 73 74 0d 0a 0d 0a |T parent|list....|
|00002a20| 00 00 00 00 00 00 00 00 | 00 00 01 00 00 0d 6b 23 |........|......k#|
|00002a30| 54 52 41 4e 20 53 4e 49 | 50 50 45 54 20 4f 4e 4c |TRAN SNI|PPET ONL|
|00002a40| 59 0d 0a 23 53 45 43 54 | 49 4f 4e 20 31 0d 0a 50 |Y..#SECT|ION 1..P|
|00002a50| 41 52 41 4d 45 54 45 52 | 53 20 6d 2e 63 68 69 6c |ARAMETER|S m.chil|
|00002a60| 64 73 74 65 6d 2c 20 6d | 2e 63 68 69 6c 64 64 62 |dstem, m|.childdb|
|00002a70| 66 2c 20 6d 2e 63 68 69 | 6c 64 66 6c 64 2c 20 6d |f, m.chi|ldfld, m|
|00002a80| 2e 70 61 72 65 6e 74 66 | 6c 64 2c 20 6d 2e 69 67 |.parentf|ld, m.ig|
|00002a90| 6e 63 61 73 65 2c 20 3b | 0d 0a 20 20 20 6d 2e 72 |ncase, ;|..   m.r|
|00002aa0| 65 6c 73 74 72 2c 20 6d | 2e 70 61 72 65 6e 74 64 |elstr, m|.parentd|
|00002ab0| 62 66 2c 20 6d 2e 61 64 | 64 6d 6f 64 65 0d 0a 0d |bf, m.ad|dmode...|
|00002ac0| 0a 50 52 49 56 41 54 45 | 20 6d 2e 69 67 6e 63 61 |.PRIVATE| m.ignca|
|00002ad0| 73 65 2c 20 6d 2e 61 64 | 64 6d 6f 64 65 2c 20 6d |se, m.ad|dmode, m|
|00002ae0| 2e 69 2c 20 6d 2e 6a 2c | 20 6d 2e 61 6c 5f 6e 61 |.i, m.j,| m.al_na|
|00002af0| 6d 65 2c 20 6d 2e 74 68 | 69 73 64 62 66 2c 20 6d |me, m.th|isdbf, m|
|00002b00| 2e 64 6f 6e 65 2c 20 6d | 2e 69 6e 5f 61 72 65 61 |.done, m|.in_area|
|00002b10| 0d 0a 0d 0a 2a 20 41 73 | 73 65 6d 62 6c 65 20 73 |....* As|semble s|
|00002b20| 74 72 69 6e 67 20 66 6f | 72 20 64 69 61 6c 6f 67 |tring fo|r dialog|
|00002b30| 20 74 69 74 6c 65 0d 0a | 6d 2e 74 68 69 73 64 62 | title..|m.thisdb|
|00002b40| 66 20 3d 20 6a 75 73 74 | 66 6e 61 6d 65 28 6d 2e |f = just|fname(m.|
|00002b50| 63 68 69 6c 64 64 62 66 | 29 0d 0a 0d 0a 2a 20 61 |childdbf|)....* a|
|00002b60| 64 64 6d 6f 64 65 20 64 | 65 74 65 72 6d 69 6e 65 |ddmode d|etermine|
|00002b70| 73 20 69 66 20 77 65 20 | 61 72 65 20 61 64 64 69 |s if we |are addi|
|00002b80| 6e 67 20 61 20 6e 65 77 | 20 72 65 6c 61 74 69 6f |ng a new| relatio|
|00002b90| 6e 73 68 69 70 20 6f 72 | 20 65 64 69 74 69 6e 67 |nship or| editing|
|00002ba0| 0d 0a 2a 20 61 6e 20 65 | 78 69 73 69 6e 67 20 6f |..* an e|xising o|
|00002bb0| 6e 65 0d 0a 0d 0a 2a 20 | 53 74 61 72 74 20 77 69 |ne....* |Start wi|
|00002bc0| 74 68 20 6e 65 77 20 63 | 6f 70 69 65 73 20 6f 66 |th new c|opies of|
|00002bd0| 20 74 68 65 20 6c 69 73 | 74 20 61 72 72 61 79 73 | the lis|t arrays|
|00002be0| 20 61 6e 64 20 72 65 6c | 65 61 73 65 20 61 6e 79 | and rel|ease any|
|00002bf0| 20 74 68 61 74 20 0d 0a | 2a 20 61 6c 72 65 61 64 | that ..|* alread|
|00002c00| 79 20 65 78 69 73 74 0d | 0a 52 45 4c 45 41 53 45 |y exist.|.RELEASE|
|00002c10| 20 63 68 69 6c 64 6c 69 | 73 74 2c 20 70 61 72 65 | childli|st, pare|
|00002c20| 6e 74 6c 69 73 74 0d 0a | 0d 0a 23 53 45 43 54 49 |ntlist..|..#SECTI|
|00002c30| 4f 4e 20 32 0d 0a 0d 0a | 6d 2e 69 6e 5f 61 72 65 |ON 2....|m.in_are|
|00002c40| 61 20 3d 20 53 45 4c 45 | 43 54 28 29 0d 0a 0d 0a |a = SELE|CT()....|
|00002c50| 2a 20 4d 61 6b 65 20 73 | 75 72 65 20 63 68 69 6c |* Make s|ure chil|
|00002c60| 64 20 64 61 74 61 62 61 | 73 65 20 65 78 69 73 74 |d databa|se exist|
|00002c70| 73 0d 0a 49 46 20 21 46 | 49 4c 45 28 6d 2e 63 68 |s..IF !F|ILE(m.ch|
|00002c80| 69 6c 64 64 62 66 29 0d | 0a 20 20 20 6d 2e 63 68 |ilddbf).|.   m.ch|
|00002c90| 69 6c 64 64 62 66 20 3d | 20 47 45 54 46 49 4c 45 |ilddbf =| GETFILE|
|00002ca0| 28 27 44 42 46 27 2c 27 | 50 6c 65 61 73 65 20 6c |('DBF','|Please l|
|00002cb0| 6f 63 61 74 65 20 74 68 | 65 20 27 2b 6a 75 73 74 |ocate th|e '+just|
|00002cc0| 73 74 65 6d 28 6d 2e 63 | 68 69 6c 64 64 62 66 29 |stem(m.c|hilddbf)|
|00002cd0| 2b 27 20 64 61 74 61 62 | 61 73 65 27 29 0d 0a 45 |+' datab|ase')..E|
|00002ce0| 4e 44 49 46 0d 0a 49 46 | 20 45 4d 50 54 59 28 6d |NDIF..IF| EMPTY(m|
|00002cf0| 2e 63 68 69 6c 64 64 62 | 66 29 20 4f 52 20 21 46 |.childdb|f) OR !F|
|00002d00| 49 4c 45 28 6d 2e 63 68 | 69 6c 64 64 62 66 29 0d |ILE(m.ch|ilddbf).|
|00002d10| 0a 20 20 20 6d 2e 63 68 | 69 6c 64 64 62 66 20 3d |.   m.ch|ilddbf =|
|00002d20| 20 27 27 0d 0a 20 20 20 | 52 45 54 55 52 4e 0d 0a | ''..   |RETURN..|
|00002d30| 45 4e 44 49 46 0d 0a 0d | 0a 0d 0a 2a 20 46 69 6c |ENDIF...|...* Fil|
|00002d40| 6c 20 69 6e 20 74 68 65 | 20 70 61 72 65 6e 74 6c |l in the| parentl|
|00002d50| 69 73 74 20 77 69 74 68 | 20 74 68 65 20 6e 61 6d |ist with| the nam|
|00002d60| 65 73 20 6f 66 20 61 6c | 6c 20 66 69 65 6c 64 73 |es of al|l fields|
|00002d70| 0d 0a 2a 20 20 20 69 6e | 20 61 6c 6c 20 6f 70 65 |..*   in| all ope|
|00002d80| 6e 20 64 61 74 61 62 61 | 73 65 73 0d 0a 6d 2e 70 |n databa|ses..m.p|
|00002d90| 61 72 65 6e 74 72 6f 77 | 20 3d 20 30 0d 0a 44 49 |arentrow| = 0..DI|
|00002da0| 4d 45 4e 53 49 4f 4e 20 | 70 61 72 65 6e 74 6c 69 |MENSION |parentli|
|00002db0| 73 74 5b 31 5d 0d 0a 70 | 61 72 65 6e 74 6c 69 73 |st[1]..p|arentlis|
|00002dc0| 74 5b 31 5d 20 3d 20 22 | 22 0d 0a 46 4f 52 20 6d |t[1] = "|"..FOR m|
|00002dd0| 2e 69 20 3d 20 31 20 54 | 4f 20 32 35 0d 0a 20 20 |.i = 1 T|O 25..  |
|00002de0| 20 53 45 4c 45 43 54 20 | 28 6d 2e 69 29 0d 0a 20 | SELECT |(m.i).. |
|00002df0| 20 20 49 46 20 21 45 4d | 50 54 59 28 44 42 46 28 |  IF !EM|PTY(DBF(|
|00002e00| 6d 2e 69 29 29 20 41 4e | 44 20 6d 61 6b 65 61 6c |m.i)) AN|D makeal|
|00002e10| 69 61 73 28 6a 75 73 74 | 73 74 65 6d 28 44 42 46 |ias(just|stem(DBF|
|00002e20| 28 6d 2e 69 29 29 29 20 | 3c 3e 20 6d 61 6b 65 61 |(m.i))) |<> makea|
|00002e30| 6c 69 61 73 28 6a 75 73 | 74 73 74 65 6d 28 6d 2e |lias(jus|tstem(m.|
|00002e40| 63 68 69 6c 64 73 74 65 | 6d 29 29 0d 0a 20 20 20 |childste|m))..   |
|00002e50| 20 20 20 46 4f 52 20 6d | 2e 6a 20 3d 20 31 20 54 |   FOR m|.j = 1 T|
|00002e60| 4f 20 46 43 4f 55 4e 54 | 28 6d 2e 69 29 0d 0a 20 |O FCOUNT|(m.i).. |
|00002e70| 20 20 20 20 20 20 20 20 | 6d 2e 70 61 72 65 6e 74 |        |m.parent|
|00002e80| 72 6f 77 20 3d 20 6d 2e | 70 61 72 65 6e 74 72 6f |row = m.|parentro|
|00002e90| 77 20 2b 20 31 0d 0a 20 | 20 20 20 20 20 20 20 20 |w + 1.. |        |
|00002ea0| 44 49 4d 45 4e 53 49 4f | 4e 20 70 61 72 65 6e 74 |DIMENSIO|N parent|
|00002eb0| 6c 69 73 74 5b 6d 2e 70 | 61 72 65 6e 74 72 6f 77 |list[m.p|arentrow|
|00002ec0| 5d 0d 0a 20 20 20 20 20 | 20 20 20 20 70 61 72 65 |]..     |    pare|
|00002ed0| 6e 74 6c 69 73 74 5b 6d | 2e 70 61 72 65 6e 74 72 |ntlist[m|.parentr|
|00002ee0| 6f 77 5d 20 3d 20 61 64 | 64 74 79 70 65 28 41 4c |ow] = ad|dtype(AL|
|00002ef0| 49 41 53 28 6d 2e 69 29 | 2b 27 2e 27 2b 46 49 45 |IAS(m.i)|+'.'+FIE|
|00002f00| 4c 44 28 6d 2e 6a 2c 6d | 2e 69 29 29 0d 0a 20 20 |LD(m.j,m|.i))..  |
|00002f10| 20 20 20 20 45 4e 44 46 | 4f 52 0d 0a 20 20 20 45 |    ENDF|OR..   E|
|00002f20| 4e 44 49 46 0d 0a 45 4e | 44 46 4f 52 0d 0a 0d 0a |NDIF..EN|DFOR....|
|00002f30| 0d 0a 2a 20 46 69 6c 6c | 20 69 6e 20 74 68 65 20 |..* Fill| in the |
|00002f40| 63 68 69 6c 64 6c 69 73 | 74 20 77 69 74 68 20 74 |childlis|t with t|
|00002f50| 68 65 20 6e 61 6d 65 73 | 20 6f 66 20 61 6c 6c 20 |he names| of all |
|00002f60| 66 69 65 6c 64 73 0d 0a | 2a 20 20 20 69 6e 20 74 |fields..|*   in t|
|00002f70| 68 65 20 63 68 69 6c 64 | 20 64 61 74 61 62 61 73 |he child| databas|
|00002f80| 65 0d 0a 6d 2e 63 68 69 | 6c 64 72 6f 77 20 3d 20 |e..m.chi|ldrow = |
|00002f90| 30 0d 0a 44 49 4d 45 4e | 53 49 4f 4e 20 63 68 69 |0..DIMEN|SION chi|
|00002fa0| 6c 64 6c 69 73 74 5b 31 | 5d 0d 0a 63 68 69 6c 64 |ldlist[1|]..child|
|00002fb0| 6c 69 73 74 28 31 29 20 | 3d 20 22 22 0d 0a 49 46 |list(1) |= ""..IF|
|00002fc0| 20 55 53 45 44 28 6d 61 | 6b 65 61 6c 69 61 73 28 | USED(ma|kealias(|
|00002fd0| 6d 2e 63 68 69 6c 64 73 | 74 65 6d 29 29 0d 0a 20 |m.childs|tem)).. |
|00002fe0| 20 20 6d 2e 61 6c 5f 6e | 61 6d 65 20 3d 20 6d 61 |  m.al_n|ame = ma|
|00002ff0| 6b 65 61 6c 69 61 73 28 | 6d 2e 63 68 69 6c 64 73 |kealias(|m.childs|
|00003000| 74 65 6d 29 0d 0a 20 20 | 20 53 45 4c 45 43 54 20 |tem)..  | SELECT |
|00003010| 28 6d 2e 61 6c 5f 6e 61 | 6d 65 29 0d 0a 45 4c 53 |(m.al_na|me)..ELS|
|00003020| 45 0d 0a 20 20 20 53 45 | 4c 45 43 54 20 30 0d 0a |E..   SE|LECT 0..|
|00003030| 20 20 20 55 53 45 20 28 | 6d 2e 63 68 69 6c 64 64 |   USE (|m.childd|
|00003040| 62 66 29 0d 0a 45 4e 44 | 49 46 0d 0a 46 4f 52 20 |bf)..END|IF..FOR |
|00003050| 6d 2e 6a 20 3d 20 31 20 | 54 4f 20 46 43 4f 55 4e |m.j = 1 |TO FCOUN|
|00003060| 54 28 29 0d 0a 20 20 20 | 49 46 20 54 59 50 45 28 |T()..   |IF TYPE(|
|00003070| 46 49 45 4c 44 28 6d 2e | 6a 29 29 20 3c 3e 20 22 |FIELD(m.|j)) <> "|
|00003080| 4d 22 0d 0a 20 20 20 20 | 20 20 6d 2e 63 68 69 6c |M"..    |  m.chil|
|00003090| 64 72 6f 77 20 3d 20 6d | 2e 63 68 69 6c 64 72 6f |drow = m|.childro|
|000030a0| 77 20 2b 20 31 0d 0a 20 | 20 20 20 20 20 44 49 4d |w + 1.. |     DIM|
|000030b0| 45 4e 53 49 4f 4e 20 63 | 68 69 6c 64 6c 69 73 74 |ENSION c|hildlist|
|000030c0| 5b 6d 2e 63 68 69 6c 64 | 72 6f 77 5d 0d 0a 20 20 |[m.child|row]..  |
|000030d0| 20 20 20 20 63 68 69 6c | 64 6c 69 73 74 5b 6d 2e |    chil|dlist[m.|
|000030e0| 63 68 69 6c 64 72 6f 77 | 5d 20 3d 20 61 64 64 74 |childrow|] = addt|
|000030f0| 79 70 65 28 41 4c 49 41 | 53 28 29 2b 27 2e 27 2b |ype(ALIA|S()+'.'+|
|00003100| 46 49 45 4c 44 28 6d 2e | 6a 29 29 0d 0a 20 20 20 |FIELD(m.|j))..   |
|00003110| 45 4e 44 49 46 0d 0a 45 | 4e 44 46 4f 52 0d 0a 0d |ENDIF..E|NDFOR...|
|00003120| 0a 2a 20 50 6f 73 69 74 | 69 6f 6e 20 73 65 6c 65 |.* Posit|ion sele|
|00003130| 63 74 69 6f 6e 20 62 61 | 72 73 20 6f 6e 74 6f 20 |ction ba|rs onto |
|00003140| 69 6e 74 65 6c 6c 69 67 | 65 6e 74 20 64 65 66 61 |intellig|ent defa|
|00003150| 75 6c 74 73 2e 20 20 54 | 72 79 20 74 6f 20 6d 61 |ults.  T|ry to ma|
|00003160| 74 63 68 0d 0a 2a 20 66 | 69 65 6c 64 20 6e 61 6d |tch..* f|ield nam|
|00003170| 65 73 20 62 65 74 77 65 | 65 6e 20 74 68 65 20 70 |es betwe|en the p|
|00003180| 61 72 65 6e 74 20 61 6e | 64 20 63 68 69 6c 64 20 |arent an|d child |
|00003190| 64 61 74 61 62 61 73 65 | 73 2e 0d 0a 6d 2e 64 6f |database|s...m.do|
|000031a0| 6e 65 20 3d 20 2e 46 2e | 0d 0a 49 46 20 45 4d 50 |ne = .F.|..IF EMP|
|000031b0| 54 59 28 6d 2e 70 61 72 | 65 6e 74 66 6c 64 29 0d |TY(m.par|entfld).|
|000031c0| 0a 20 20 20 49 46 20 45 | 4d 50 54 59 28 6d 2e 63 |.   IF E|MPTY(m.c|
|000031d0| 68 69 6c 64 66 6c 64 29 | 0d 0a 20 20 20 20 20 20 |hildfld)|..      |
|000031e0| 2a 20 53 65 65 20 69 66 | 20 74 68 65 72 65 20 61 |* See if| there a|
|000031f0| 72 65 20 61 6e 79 20 66 | 69 65 6c 64 73 20 69 6e |re any f|ields in|
|00003200| 20 74 68 65 20 70 61 72 | 65 6e 74 20 64 61 74 61 | the par|ent data|
|00003210| 62 61 73 65 20 77 69 74 | 68 0d 0a 20 20 20 20 20 |base wit|h..     |
|00003220| 20 2a 20 74 68 65 20 73 | 61 6d 65 20 6e 61 6d 65 | * the s|ame name|
|00003230| 20 61 6e 64 20 74 79 70 | 65 20 61 73 20 61 20 66 | and typ|e as a f|
|00003240| 69 65 6c 64 20 69 6e 20 | 74 68 65 20 63 68 69 6c |ield in |the chil|
|00003250| 64 20 64 61 74 61 62 61 | 73 65 0d 0a 20 20 20 20 |d databa|se..    |
|00003260| 20 20 6d 2e 69 20 3d 20 | 31 0d 0a 20 20 20 20 20 |  m.i = |1..     |
|00003270| 20 44 4f 20 57 48 49 4c | 45 20 21 64 6f 6e 65 20 | DO WHIL|E !done |
|00003280| 41 4e 44 20 6d 2e 69 20 | 3c 3d 20 6d 2e 63 68 69 |AND m.i |<= m.chi|
|00003290| 6c 64 72 6f 77 0d 0a 20 | 20 20 20 20 20 20 20 20 |ldrow.. |        |
|000032a0| 6d 2e 6e 65 77 63 68 69 | 6c 64 20 20 3d 20 53 55 |m.newchi|ld  = SU|
|000032b0| 42 53 54 52 28 63 68 69 | 6c 64 6c 69 73 74 5b 6d |BSTR(chi|ldlist[m|
|000032c0| 2e 69 5d 2c 41 54 28 27 | 2e 27 2c 63 68 69 6c 64 |.i],AT('|.',child|
|000032d0| 6c 69 73 74 5b 6d 2e 69 | 5d 29 2b 31 29 0d 0a 20 |list[m.i|])+1).. |
|000032e0| 20 20 20 20 20 20 20 20 | 6d 2e 6e 65 77 63 68 69 |        |m.newchi|
|000032f0| 6c 64 20 20 3d 20 43 48 | 52 54 52 41 4e 28 6d 2e |ld  = CH|RTRAN(m.|
|00003300| 6e 65 77 63 68 69 6c 64 | 2c 27 20 27 2c 27 27 29 |newchild|,' ','')|
|00003310| 0d 0a 20 20 20 20 20 20 | 20 20 20 6d 2e 6a 20 3d |..      |   m.j =|
|00003320| 20 31 0d 0a 20 20 20 20 | 20 20 20 20 20 44 4f 20 | 1..    |     DO |
|00003330| 57 48 49 4c 45 20 21 6d | 2e 64 6f 6e 65 20 41 4e |WHILE !m|.done AN|
|00003340| 44 20 6d 2e 6a 20 3c 3d | 20 6d 2e 70 61 72 65 6e |D m.j <=| m.paren|
|00003350| 74 72 6f 77 0d 0a 20 20 | 20 20 20 20 20 20 20 20 |trow..  |        |
|00003360| 20 20 2a 20 41 73 73 65 | 6d 62 6c 65 20 61 20 6e |  * Asse|mble a n|
|00003370| 65 77 20 6e 61 6d 65 20 | 62 61 73 65 64 20 6f 6e |ew name |based on|
|00003380| 20 74 68 65 20 66 69 65 | 6c 64 20 6e 61 6d 65 20 | the fie|ld name |
|00003390| 61 6e 64 20 74 68 65 20 | 66 69 65 6c 64 20 74 79 |and the |field ty|
|000033a0| 70 65 0d 0a 20 20 20 20 | 20 20 20 20 20 20 20 20 |pe..    |        |
|000033b0| 2a 20 54 68 65 20 70 61 | 72 65 6e 74 6c 69 73 74 |* The pa|rentlist|
|000033c0| 20 72 65 63 6f 72 64 73 | 20 6c 6f 6f 6b 20 6c 69 | records| look li|
|000033d0| 6b 65 20 74 68 69 73 3a | 0d 0a 20 20 20 20 20 20 |ke this:|..      |
|000033e0| 20 20 20 20 20 20 2a 20 | 20 20 20 61 6c 69 61 73 |      * |   alias|
|000033f0| 2e 66 6c 64 20 20 20 20 | 20 20 20 28 4e 29 0d 0a |.fld    |   (N)..|
|00003400| 20 20 20 20 20 20 20 20 | 20 20 20 20 2a 20 22 4e |        |    * "N|
|00003410| 65 77 70 61 72 65 6e 74 | 22 20 6e 6f 77 20 6c 6f |ewparent|" now lo|
|00003420| 6f 6b 73 20 6c 69 6b 65 | 20 74 68 69 73 3a 0d 0a |oks like| this:..|
|00003430| 20 20 20 20 20 20 20 20 | 20 20 20 20 2a 20 20 20 |        |    *   |
|00003440| 20 20 66 6c 64 28 4e 29 | 0d 0a 20 20 20 20 20 20 |  fld(N)|..      |
|00003450| 20 20 20 20 20 20 6d 2e | 6e 65 77 70 61 72 65 6e |      m.|newparen|
|00003460| 74 20 3d 20 53 55 42 53 | 54 52 28 70 61 72 65 6e |t = SUBS|TR(paren|
|00003470| 74 6c 69 73 74 5b 6d 2e | 6a 5d 2c 41 54 28 27 2e |tlist[m.|j],AT('.|
|00003480| 27 2c 70 61 72 65 6e 74 | 6c 69 73 74 5b 6d 2e 6a |',parent|list[m.j|
|00003490| 5d 29 2b 31 29 0d 0a 20 | 20 20 20 20 20 20 20 20 |])+1).. |        |
|000034a0| 20 20 20 6d 2e 6e 65 77 | 70 61 72 65 6e 74 20 3d |   m.new|parent =|
|000034b0| 20 43 48 52 54 52 41 4e | 28 6e 65 77 70 61 72 65 | CHRTRAN|(newpare|
|000034c0| 6e 74 2c 27 20 27 2c 27 | 27 29 0d 0a 0d 0a 20 20 |nt,' ','|')....  |
|000034d0| 20 20 20 20 20 20 20 20 | 20 20 49 46 20 6d 2e 6e |        |  IF m.n|
|000034e0| 65 77 70 61 72 65 6e 74 | 20 3d 3d 20 6d 2e 6e 65 |ewparent| == m.ne|
|000034f0| 77 63 68 69 6c 64 0d 0a | 20 20 20 20 20 20 20 20 |wchild..|        |
|00003500| 20 20 20 20 20 20 20 6d | 2e 70 61 72 65 6e 74 66 |       m|.parentf|
|00003510| 6c 64 20 3d 20 70 61 72 | 65 6e 74 6c 69 73 74 5b |ld = par|entlist[|
|00003520| 6d 2e 6a 5d 0d 0a 20 20 | 20 20 20 20 20 20 20 20 |m.j]..  |        |
|00003530| 20 20 20 20 20 6d 2e 63 | 68 69 6c 64 66 6c 64 20 |     m.c|hildfld |
|00003540| 20 3d 20 63 68 69 6c 64 | 6c 69 73 74 5b 6d 2e 69 | = child|list[m.i|
|00003550| 5d 0d 0a 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |]..     |        |
|00003560| 20 20 6d 2e 64 6f 6e 65 | 20 3d 20 2e 54 2e 0d 0a |  m.done| = .T...|
|00003570| 20 20 20 20 20 20 20 20 | 20 20 20 20 45 4e 44 49 |        |    ENDI|
|00003580| 46 0d 0a 20 20 20 20 20 | 20 20 20 20 20 20 20 6d |F..     |       m|
|00003590| 2e 6a 20 3d 20 6d 2e 6a | 20 2b 20 31 0d 0a 20 20 |.j = m.j| + 1..  |
|000035a0| 20 20 20 20 20 20 20 45 | 4e 44 44 4f 0d 0a 20 20 |       E|NDDO..  |
|000035b0| 20 20 20 20 20 20 20 6d | 2e 69 20 3d 20 6d 2e 69 |       m|.i = m.i|
|000035c0| 20 2b 20 31 0d 0a 20 20 | 20 20 20 20 45 4e 44 44 | + 1..  |    ENDD|
|000035d0| 4f 0d 0a 0d 0a 20 20 20 | 20 20 20 49 46 20 21 6d |O....   |   IF !m|
|000035e0| 2e 64 6f 6e 65 20 20 20 | 20 26 26 20 6e 6f 20 6d |.done   | && no m|
|000035f0| 61 74 63 68 65 73 20 66 | 6f 75 6e 64 2e 20 20 44 |atches f|ound.  D|
|00003600| 65 66 61 75 6c 74 20 74 | 6f 20 66 69 72 73 74 20 |efault t|o first |
|00003610| 66 69 65 6c 64 2e 0d 0a | 20 20 20 20 20 20 20 20 |field...|        |
|00003620| 20 6d 2e 63 68 69 6c 64 | 66 6c 64 20 20 20 3d 20 | m.child|fld   = |
|00003630| 63 68 69 6c 64 6c 69 73 | 74 5b 31 5d 0d 0a 20 20 |childlis|t[1]..  |
|00003640| 20 20 20 20 20 20 20 6d | 2e 70 61 72 65 6e 74 66 |       m|.parentf|
|00003650| 6c 64 20 20 3d 20 70 61 | 72 65 6e 74 6c 69 73 74 |ld  = pa|rentlist|
|00003660| 5b 31 5d 0d 0a 20 20 20 | 20 20 20 45 4e 44 49 46 |[1]..   |   ENDIF|
|00003670| 0d 0a 20 20 20 45 4c 53 | 45 0d 0a 20 20 20 20 20 |..   ELS|E..     |
|00003680| 20 2a 20 44 65 66 61 75 | 6c 74 20 74 6f 20 74 68 | * Defau|lt to th|
|00003690| 65 20 66 69 72 73 74 20 | 66 69 65 6c 64 20 0d 0a |e first |field ..|
|000036a0| 20 20 20 20 20 20 6d 2e | 70 61 72 65 6e 74 66 6c |      m.|parentfl|
|000036b0| 64 20 20 3d 20 70 61 72 | 65 6e 74 6c 69 73 74 5b |d  = par|entlist[|
|000036c0| 31 5d 0d 0a 20 20 20 20 | 20 20 6d 2e 63 68 69 6c |1]..    |  m.chil|
|000036d0| 64 66 6c 64 20 20 20 3d | 20 61 64 64 74 79 70 65 |dfld   =| addtype|
|000036e0| 28 6d 2e 63 68 69 6c 64 | 66 6c 64 29 0d 0a 20 20 |(m.child|fld)..  |
|000036f0| 20 45 4e 44 49 46 0d 0a | 45 4c 53 45 0d 0a 20 20 | ENDIF..|ELSE..  |
|00003700| 20 6d 2e 70 61 72 65 6e | 74 66 6c 64 20 20 3d 20 | m.paren|tfld  = |
|00003710| 61 64 64 74 79 70 65 28 | 6d 2e 70 61 72 65 6e 74 |addtype(|m.parent|
|00003720| 66 6c 64 29 0d 0a 20 20 | 20 6d 2e 63 68 69 6c 64 |fld)..  | m.child|
|00003730| 66 6c 64 20 20 20 3d 20 | 61 64 64 74 79 70 65 28 |fld   = |addtype(|
|00003740| 6d 2e 63 68 69 6c 64 66 | 6c 64 29 0d 0a 45 4e 44 |m.childf|ld)..END|
|00003750| 49 46 0d 0a 0d 0a 44 4f | 20 63 64 69 73 6c 69 73 |IF....DO| cdislis|
|00003760| 74 20 57 49 54 48 20 41 | 53 43 41 4e 28 63 68 69 |t WITH A|SCAN(chi|
|00003770| 6c 64 6c 69 73 74 2c 6d | 2e 63 68 69 6c 64 66 6c |ldlist,m|.childfl|
|00003780| 64 29 0d 0a 0d 0a 53 45 | 4c 45 43 54 20 28 6d 2e |d)....SE|LECT (m.|
|00003790| 69 6e 5f 61 72 65 61 29 | 0d 0a 00 00 00 00 00 00 |in_area)|........|
|000037a0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000037b0| 00 00 00 01 00 00 00 0b | 6d 2e 70 61 72 65 6e 74 |........|m.parent|
|000037c0| 66 6c 64 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |fld.....|........|
|000037d0| 00 00 00 00 01 00 00 00 | 0a 70 61 72 65 6e 74 6c |........|.parentl|
|000037e0| 69 73 74 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |ist.....|........|
|000037f0| 00 00 00 00 00 01 00 00 | 00 05 22 40 5e 20 22 00 |........|.."@^ ".|
|00003800| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003810| 00 00 00 00 00 00 01 00 | 00 00 0b 43 6f 75 72 69 |........|...Couri|
|00003820| 65 72 20 4e 65 77 00 00 | 00 00 00 00 00 00 00 00 |er New..|........|
|00003830| 00 00 00 00 00 00 00 01 | 00 00 00 0b 53 48 4f 57 |........|....SHOW|
|00003840| 20 47 45 54 53 0d 0a 00 | 00 00 00 00 00 00 00 00 | GETS...|........|
|00003850| 00 00 00 00 00 00 00 00 | 01 00 00 00 08 22 45 71 |........|....."Eq|
|00003860| 75 61 6c 73 22 00 00 00 | 00 00 00 00 00 00 00 00 |uals"...|........|
|00003870| 00 00 00 00 00 00 00 00 | 00 01 00 00 00 0d 4d 53 |........|......MS|
|00003880| 20 53 61 6e 73 20 53 65 | 72 69 66 00 00 00 00 00 | Sans Se|rif.....|
|00003890| 00 00 00 00 00 00 00 00 | 00 00 01 00 00 00 0a 6d |........|.......m|
|000038a0| 2e 63 68 69 6c 64 66 6c | 64 00 00 00 00 00 00 00 |.childfl|d.......|
|000038b0| 00 00 00 00 00 00 00 00 | 00 00 00 01 00 00 00 09 |........|........|
|000038c0| 63 68 69 6c 64 6c 69 73 | 74 00 00 00 00 00 00 00 |childlis|t.......|
|000038d0| 00 00 00 00 00 00 00 00 | 00 00 00 00 01 00 00 00 |........|........|
|000038e0| 05 22 40 5e 20 22 00 00 | 00 00 00 00 00 00 00 00 |."@^ "..|........|
|000038f0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 01 00 00 |........|........|
|00003900| 00 0b 43 6f 75 72 69 65 | 72 20 4e 65 77 00 00 00 |..Courie|r New...|
|00003910| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 01 00 |........|........|
|00003920| 00 00 37 44 4f 20 63 64 | 69 73 6c 69 73 74 20 57 |..7DO cd|islist W|
|00003930| 49 54 48 20 41 53 43 41 | 4e 28 63 68 69 6c 64 6c |ITH ASCA|N(childl|
|00003940| 69 73 74 2c 63 68 69 6c | 64 66 6c 64 29 0d 0a 53 |ist,chil|dfld)..S|
|00003950| 48 4f 57 20 47 45 54 53 | 0d 0a 00 00 00 00 00 00 |HOW GETS|........|
|00003960| 01 00 00 00 17 22 46 69 | 65 6c 64 20 69 6e 20 4f |....."Fi|eld in O|
|00003970| 74 68 65 72 20 54 61 62 | 6c 65 3a 22 00 00 00 00 |ther Tab|le:"....|
|00003980| 00 01 00 00 00 0d 4d 53 | 20 53 61 6e 73 20 53 65 |......MS| Sans Se|
|00003990| 72 69 66 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |rif.....|........|
|000039a0| 00 00 01 00 00 00 16 22 | 46 69 65 6c 64 20 69 6e |......."|Field in|
|000039b0| 20 54 68 69 73 20 54 61 | 62 6c 65 3a 22 00 00 00 | This Ta|ble:"...|
|000039c0| 00 00 00 01 00 00 00 0d | 4d 53 20 53 61 6e 73 20 |........|MS Sans |
|000039d0| 53 65 72 69 66 00 00 00 | 00 00 00 00 00 00 00 00 |Serif...|........|
|000039e0| 00 00 00 00 01 00 00 00 | 2d 22 48 6f 77 20 69 73 |........|-"How is|
|000039f0| 20 54 68 69 73 20 54 61 | 62 6c 65 20 52 65 6c 61 | This Ta|ble Rela|
|00003a00| 74 65 64 20 74 6f 20 41 | 6e 6f 74 68 65 72 20 54 |ted to A|nother T|
|00003a10| 61 62 6c 65 3f 22 00 00 | 00 00 00 00 00 00 00 00 |able?"..|........|
|00003a20| 00 00 00 00 00 00 01 00 | 00 00 0d 4d 53 20 53 61 |........|...MS Sa|
|00003a30| 6e 73 20 53 65 72 69 66 | 00 00 00 00 00 00 00 00 |ns Serif|........|
|00003a40| 00 00 00 00 00 00 00 01 | 00 00 00 09 6d 2e 6f 6b |........|....m.ok|
|00003a50| 63 61 6e 63 6c 00 00 00 | 00 00 00 00 00 00 00 00 |cancl...|........|
|00003a60| 00 00 00 00 00 00 00 00 | 01 00 00 00 18 22 40 2a |........|....."@*|
|00003a70| 48 4e 20 5c 21 5c 3c 4f | 4b 3b 5c 3f 5c 3c 43 61 |HN \!\<O|K;\?\<Ca|
|00003a80| 6e 63 65 6c 22 00 00 00 | 00 01 00 00 00 0d 4d 53 |ncel"...|......MS|
|00003a90| 20 53 61 6e 73 20 53 65 | 72 69 66 00 00 00 00 00 | Sans Se|rif.....|
|00003aa0| 00 00 00 00 00 00 00 00 | 00 00 01 00 00 05 b4 2a |........|.......*|
|00003ab0| 20 53 74 72 69 70 20 6f | 66 66 20 74 68 65 20 74 | Strip o|ff the t|
|00003ac0| 79 70 65 20 64 65 73 69 | 67 6e 61 74 69 6f 6e 73 |ype desi|gnations|
|00003ad0| 20 66 72 6f 6d 20 66 69 | 65 6c 64 20 6e 61 6d 65 | from fi|eld name|
|00003ae0| 73 0d 0a 6d 2e 70 66 6c | 64 20 3d 20 6d 2e 70 61 |s..m.pfl|d = m.pa|
|00003af0| 72 65 6e 74 66 6c 64 0d | 0a 6d 2e 63 66 6c 64 20 |rentfld.|.m.cfld |
|00003b00| 3d 20 6d 2e 63 68 69 6c | 64 66 6c 64 0d 0a 49 46 |= m.chil|dfld..IF|
|00003b10| 20 41 54 28 27 28 27 2c | 6d 2e 70 61 72 65 6e 74 | AT('(',|m.parent|
|00003b20| 66 6c 64 29 20 3e 20 30 | 0d 0a 20 20 20 6d 2e 70 |fld) > 0|..   m.p|
|00003b30| 61 72 65 6e 74 66 6c 64 | 20 3d 20 41 4c 4c 54 52 |arentfld| = ALLTR|
|00003b40| 49 4d 28 53 55 42 53 54 | 52 28 6d 2e 70 61 72 65 |IM(SUBST|R(m.pare|
|00003b50| 6e 74 66 6c 64 2c 31 2c | 4c 45 4e 28 54 52 49 4d |ntfld,1,|LEN(TRIM|
|00003b60| 28 6d 2e 70 61 72 65 6e | 74 66 6c 64 29 29 2d 33 |(m.paren|tfld))-3|
|00003b70| 29 29 0d 0a 45 4e 44 49 | 46 0d 0a 49 46 20 41 54 |))..ENDI|F..IF AT|
|00003b80| 28 27 28 27 2c 6d 2e 63 | 68 69 6c 64 66 6c 64 29 |('(',m.c|hildfld)|
|00003b90| 20 3e 20 30 0d 0a 20 20 | 20 6d 2e 63 68 69 6c 64 | > 0..  | m.child|
|00003ba0| 66 6c 64 20 20 3d 20 41 | 4c 4c 54 52 49 4d 28 53 |fld  = A|LLTRIM(S|
|00003bb0| 55 42 53 54 52 28 6d 2e | 63 68 69 6c 64 66 6c 64 |UBSTR(m.|childfld|
|00003bc0| 2c 31 2c 4c 45 4e 28 54 | 52 49 4d 28 6d 2e 63 68 |,1,LEN(T|RIM(m.ch|
|00003bd0| 69 6c 64 66 6c 64 29 29 | 2d 33 29 29 0d 0a 45 4e |ildfld))|-3))..EN|
|00003be0| 44 49 46 0d 0a 0d 0a 44 | 4f 20 43 41 53 45 0d 0a |DIF....D|O CASE..|
|00003bf0| 43 41 53 45 20 6d 2e 6f | 6b 63 61 6e 63 6c 20 3d |CASE m.o|kcancl =|
|00003c00| 20 31 0d 0a 20 20 20 2a | 20 4d 61 6b 65 20 73 75 | 1..   *| Make su|
|00003c10| 72 65 20 74 68 69 73 20 | 69 73 20 61 20 76 61 6c |re this |is a val|
|00003c20| 69 64 20 73 65 6c 65 63 | 74 69 6f 6e 20 77 69 74 |id selec|tion wit|
|00003c30| 68 20 72 65 73 70 65 63 | 74 20 74 6f 20 64 61 74 |h respec|t to dat|
|00003c40| 61 20 74 79 70 65 0d 0a | 20 20 20 44 4f 20 43 41 |a type..|   DO CA|
|00003c50| 53 45 0d 0a 20 20 20 43 | 41 53 45 20 54 59 50 45 |SE..   C|ASE TYPE|
|00003c60| 28 6d 2e 63 68 69 6c 64 | 66 6c 64 29 20 3d 20 27 |(m.child|fld) = '|
|00003c70| 55 27 0d 0a 20 20 20 20 | 20 20 57 41 49 54 20 57 |U'..    |  WAIT W|
|00003c80| 49 4e 44 4f 57 20 22 54 | 68 65 20 63 68 69 6c 64 |INDOW "T|he child|
|00003c90| 20 64 61 74 61 62 61 73 | 65 20 63 6f 75 6c 64 20 | databas|e could |
|00003ca0| 6e 6f 74 20 62 65 20 66 | 6f 75 6e 64 2e 22 0d 0a |not be f|ound."..|
|00003cb0| 20 20 20 43 41 53 45 20 | 54 59 50 45 28 6d 2e 70 |   CASE |TYPE(m.p|
|00003cc0| 61 72 65 6e 74 66 6c 64 | 29 20 3d 20 27 55 27 0d |arentfld|) = 'U'.|
|00003cd0| 0a 20 20 20 20 20 20 57 | 41 49 54 20 57 49 4e 44 |.      W|AIT WIND|
|00003ce0| 4f 57 20 22 54 68 65 20 | 70 61 72 65 6e 74 20 64 |OW "The |parent d|
|00003cf0| 61 74 61 62 61 73 65 20 | 63 6f 75 6c 64 20 6e 6f |atabase |could no|
|00003d00| 74 20 62 65 20 66 6f 75 | 6e 64 2e 22 0d 0a 20 20 |t be fou|nd."..  |
|00003d10| 20 43 41 53 45 20 54 59 | 50 45 28 6d 2e 63 68 69 | CASE TY|PE(m.chi|
|00003d20| 6c 64 66 6c 64 29 20 3d | 3d 20 54 59 50 45 28 6d |ldfld) =|= TYPE(m|
|00003d30| 2e 70 61 72 65 6e 74 66 | 6c 64 29 0d 0a 20 20 20 |.parentf|ld)..   |
|00003d40| 20 20 20 6d 2e 64 62 66 | 70 61 72 74 20 20 20 3d |   m.dbf|part   =|
|00003d50| 20 53 55 42 53 54 52 28 | 6d 2e 63 68 69 6c 64 66 | SUBSTR(|m.childf|
|00003d60| 6c 64 2c 31 2c 41 54 28 | 27 2e 27 2c 6d 2e 63 68 |ld,1,AT(|'.',m.ch|
|00003d70| 69 6c 64 66 6c 64 29 2d | 31 29 0d 0a 20 20 20 20 |ildfld)-|1)..    |
|00003d80| 20 20 6d 2e 72 65 6c 73 | 74 72 20 20 20 20 3d 20 |  m.rels|tr    = |
|00003d90| 27 53 45 54 20 52 45 4c | 41 54 49 4f 4e 20 54 4f |'SET REL|ATION TO|
|00003da0| 20 27 3b 0d 0a 20 20 20 | 20 20 20 20 20 20 2b 53 | ';..   |      +S|
|00003db0| 55 42 53 54 52 28 6d 2e | 70 61 72 65 6e 74 66 6c |UBSTR(m.|parentfl|
|00003dc0| 64 2c 41 54 28 27 2e 27 | 2c 6d 2e 70 61 72 65 6e |d,AT('.'|,m.paren|
|00003dd0| 74 66 6c 64 29 2b 31 29 | 3b 0d 0a 20 20 20 20 20 |tfld)+1)|;..     |
|00003de0| 20 20 20 20 2b 27 20 49 | 4e 54 4f 20 27 2b 6d 2e |    +' I|NTO '+m.|
|00003df0| 64 62 66 70 61 72 74 0d | 0a 20 20 20 20 20 20 6d |dbfpart.|.      m|
|00003e00| 2e 70 61 72 65 6e 74 64 | 62 66 20 3d 20 53 55 42 |.parentd|bf = SUB|
|00003e10| 53 54 52 28 6d 2e 70 61 | 72 65 6e 74 66 6c 64 2c |STR(m.pa|rentfld,|
|00003e20| 31 2c 41 54 28 27 2e 27 | 2c 6d 2e 70 61 72 65 6e |1,AT('.'|,m.paren|
|00003e30| 74 66 6c 64 29 2d 31 29 | 0d 0a 20 20 20 20 20 20 |tfld)-1)|..      |
|00003e40| 43 4c 45 41 52 20 52 45 | 41 44 0d 0a 20 20 20 4f |CLEAR RE|AD..   O|
|00003e50| 54 48 45 52 57 49 53 45 | 0d 0a 20 20 20 20 20 20 |THERWISE|..      |
|00003e60| 57 41 49 54 20 57 49 4e | 44 4f 57 20 22 50 61 72 |WAIT WIN|DOW "Par|
|00003e70| 65 6e 74 20 61 6e 64 20 | 63 68 69 6c 64 20 68 61 |ent and |child ha|
|00003e80| 76 65 20 64 69 66 66 65 | 72 65 6e 74 20 64 61 74 |ve diffe|rent dat|
|00003e90| 61 20 74 79 70 65 73 2e | 22 0d 0a 20 20 20 20 20 |a types.|"..     |
|00003ea0| 20 2a 20 52 65 73 74 6f | 72 65 20 66 75 6c 6c 20 | * Resto|re full |
|00003eb0| 73 74 72 69 6e 67 20 74 | 6f 20 70 61 72 65 6e 74 |string t|o parent|
|00003ec0| 20 61 6e 64 20 63 68 69 | 6c 64 20 66 69 65 6c 64 | and chi|ld field|
|00003ed0| 73 0d 0a 20 20 20 20 20 | 20 6d 2e 70 61 72 65 6e |s..     | m.paren|
|00003ee0| 74 66 6c 64 20 3d 20 6d | 2e 70 66 6c 64 0d 0a 20 |tfld = m|.pfld.. |
|00003ef0| 20 20 20 20 20 6d 2e 63 | 68 69 6c 64 66 6c 64 20 |     m.c|hildfld |
|00003f00| 20 3d 20 6d 2e 63 66 6c | 64 0d 0a 20 20 20 45 4e | = m.cfl|d..   EN|
|00003f10| 44 43 41 53 45 0d 0a 43 | 41 53 45 20 6d 2e 6f 6b |DCASE..C|ASE m.ok|
|00003f20| 63 61 6e 63 6c 20 3d 20 | 32 20 20 20 20 20 26 26 |cancl = |2     &&|
|00003f30| 20 63 61 6e 63 65 6c 20 | 74 68 69 73 20 72 65 6c | cancel |this rel|
|00003f40| 61 74 69 6f 6e 73 68 69 | 70 0d 0a 20 20 20 2a 20 |ationshi|p..   * |
|00003f50| 57 65 20 6f 70 65 6e 65 | 64 20 63 68 69 6c 64 73 |We opene|d childs|
|00003f60| 74 65 6d 20 69 6e 20 74 | 68 65 20 73 65 74 75 70 |tem in t|he setup|
|00003f70| 20 73 6e 69 70 70 65 74 | 2e 20 20 43 6c 6f 73 65 | snippet|.  Close|
|00003f80| 20 69 74 20 6e 6f 77 2e | 0d 0a 20 20 20 49 46 20 | it now.|..   IF |
|00003f90| 6d 2e 61 64 64 6d 6f 64 | 65 20 41 4e 44 20 55 53 |m.addmod|e AND US|
|00003fa0| 45 44 28 6d 2e 63 68 69 | 6c 64 73 74 65 6d 29 0d |ED(m.chi|ldstem).|
|00003fb0| 0a 20 20 20 20 20 20 53 | 45 4c 45 43 54 20 28 6d |.      S|ELECT (m|
|00003fc0| 2e 63 68 69 6c 64 73 74 | 65 6d 29 0d 0a 20 20 20 |.childst|em)..   |
|00003fd0| 20 20 20 55 53 45 0d 0a | 20 20 20 45 4e 44 49 46 |   USE..|   ENDIF|
|00003fe0| 0d 0a 20 20 20 6d 2e 64 | 62 66 70 61 72 74 20 20 |..   m.d|bfpart  |
|00003ff0| 20 3d 20 27 27 0d 0a 20 | 20 20 6d 2e 63 68 69 6c | = ''.. |  m.chil|
|00004000| 64 66 6c 64 20 20 3d 20 | 27 27 0d 0a 20 20 20 6d |dfld  = |''..   m|
|00004010| 2e 63 68 69 6c 64 64 62 | 66 20 20 3d 20 27 27 0d |.childdb|f  = ''.|
|00004020| 0a 20 20 20 6d 2e 72 65 | 6c 73 74 72 20 20 20 20 |.   m.re|lstr    |
|00004030| 3d 20 27 27 0d 0a 20 20 | 20 6d 2e 70 61 72 65 6e |= ''..  | m.paren|
|00004040| 74 64 62 66 20 3d 20 27 | 27 0d 0a 20 20 20 43 4c |tdbf = '|'..   CL|
|00004050| 45 41 52 20 52 45 41 44 | 0d 0a 45 4e 44 43 41 53 |EAR READ|..ENDCAS|
|00004060| 45 0d 0a 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |E.......|........|
|00004070| 00 00 00 00 00 00 00 01 | 00 00 00 04 22 4f 4b 22 |........|...."OK"|
|00004080| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004090| 00 00 00 00 00 00 00 00 | 01 00 00 00 08 6d 2e 61 |........|.....m.a|
|000040a0| 64 76 62 75 74 00 00 00 | 00 00 00 00 00 00 00 00 |dvbut...|........|
|000040b0| 00 00 00 00 00 00 00 00 | 00 01 00 00 00 14 22 40 |........|......"@|
|000040c0| 2a 48 4e 20 5c 3c 41 64 | 76 61 6e 63 65 64 2e 2e |*HN \<Ad|vanced..|
|000040d0| 2e 22 00 00 00 00 00 00 | 00 00 01 00 00 00 0d 4d |."......|.......M|
|000040e0| 53 20 53 61 6e 73 20 53 | 65 72 69 66 00 00 00 00 |S Sans S|erif....|
|000040f0| 00 00 00 00 00 00 00 00 | 00 00 00 01 00 00 00 49 |........|.......I|
|00004100| 73 65 74 20 73 74 65 70 | 20 6f 6e 0d 0a 44 4f 20 |set step| on..DO |
|00004110| 63 61 73 63 64 6c 67 2e | 73 70 72 20 57 49 54 48 |cascdlg.|spr WITH|
|00004120| 20 64 62 66 6c 69 73 74 | 5b 6d 2e 6e 65 78 74 64 | dbflist|[m.nextd|
|00004130| 62 66 2c 6d 2e 63 73 74 | 65 6d 6e 75 6d 5d 0d 0a |bf,m.cst|emnum]..|
|00004140| 0d 0a 20 20 20 0d 0a 0d | 0a 00 00 00 00 00 00 00 |..   ...|........|
|00004150| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 01 00 |........|........|
|00004160| 00 00 0d 22 41 64 76 61 | 6e 63 65 64 2e 2e 2e 22 |..."Adva|nced..."|
|00004170| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 01 |........|........|
|00004180| 00 00 00 0d 4d 53 20 53 | 61 6e 73 20 53 65 72 69 |....MS S|ans Seri|
|00004190| 66 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |f.......|........|
|000041a0| 01 00 00 00 0b 43 6f 75 | 72 69 65 72 20 4e 65 77 |.....Cou|rier New|
|000041b0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000041c0| 00 01 00 00 00 08 52 45 | 4c 53 45 4c 45 43 00 00 |......RE|LSELEC..|
|000041d0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000041e0| 00 00 01 00 00 00 16 22 | 4f 70 74 69 6f 6e 73 20 |......."|Options |
|000041f0| 66 6f 72 20 26 74 68 69 | 73 64 62 66 22 00 00 00 |for &thi|sdbf"...|
|00004200| 00 00 00 01 00 00 00 c5 | 49 46 20 45 4d 50 54 59 |........|IF EMPTY|
|00004210| 28 6d 2e 70 61 72 65 6e | 74 66 6c 64 29 20 3b 0d |(m.paren|tfld) ;.|
|00004220| 0a 20 20 20 20 20 20 4f | 52 20 4c 45 46 54 28 6d |.      O|R LEFT(m|
|00004230| 2e 70 61 72 65 6e 74 66 | 6c 64 2c 31 29 20 3d 20 |.parentf|ld,1) = |
|00004240| 27 5c 27 20 3b 0d 0a 20 | 20 20 20 20 20 4f 52 20 |'\' ;.. |     OR |
|00004250| 28 67 65 74 74 79 70 65 | 28 6d 2e 70 61 72 65 6e |(gettype|(m.paren|
|00004260| 74 66 6c 64 29 20 21 3d | 20 67 65 74 74 79 70 65 |tfld) !=| gettype|
|00004270| 28 6d 2e 63 68 69 6c 64 | 66 6c 64 29 29 0d 0a 20 |(m.child|fld)).. |
|00004280| 20 20 53 48 4f 57 20 47 | 45 54 20 6d 2e 6f 6b 63 |  SHOW G|ET m.okc|
|00004290| 61 6e 63 6c 2c 31 20 44 | 49 53 41 42 4c 45 0d 0a |ancl,1 D|ISABLE..|
|000042a0| 45 4c 53 45 0d 0a 20 20 | 20 53 48 4f 57 20 47 45 |ELSE..  | SHOW GE|
|000042b0| 54 20 6d 2e 6f 6b 63 61 | 6e 63 6c 2c 31 20 45 4e |T m.okca|ncl,1 EN|
|000042c0| 41 42 4c 45 0d 0a 45 4e | 44 49 46 0d 0a 00 00 00 |ABLE..EN|DIF.....|
|000042d0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000042e0| 00 00 00 00 00 00 00 00 | 00 00 01 00 00 06 e7 0d |........|........|
|000042f0| 0a 2a 21 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |.*!*****|********|
|00004300| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00004310| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00004320| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00004330| 2a 2a 2a 2a 0d 0a 2a 21 | 0d 0a 2a 21 20 20 20 20 |****..*!|..*!    |
|00004340| 20 20 50 72 6f 63 65 64 | 75 72 65 3a 20 41 44 44 |  Proced|ure: ADD|
|00004350| 54 59 50 45 0d 0a 2a 21 | 0d 0a 2a 21 2a 2a 2a 2a |TYPE..*!|..*!****|
|00004360| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00004370| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00004380| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00004390| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 0d 0a 46 |********|*****..F|
|000043a0| 55 4e 43 54 49 4f 4e 20 | 61 64 64 74 79 70 65 0d |UNCTION |addtype.|
|000043b0| 0a 2a 20 41 64 64 20 74 | 68 65 20 64 61 74 61 20 |.* Add t|he data |
|000043c0| 74 79 70 65 20 74 6f 20 | 61 20 66 69 65 6c 64 20 |type to |a field |
|000043d0| 6e 61 6d 65 0d 0a 50 41 | 52 41 4d 45 54 45 52 20 |name..PA|RAMETER |
|000043e0| 66 6c 64 6e 61 6d 65 0d | 0a 0d 0a 49 46 20 21 45 |fldname.|...IF !E|
|000043f0| 4d 50 54 59 28 6d 2e 66 | 6c 64 6e 61 6d 65 29 0d |MPTY(m.f|ldname).|
|00004400| 0a 20 20 20 52 45 54 55 | 52 4e 20 50 41 44 52 28 |.   RETU|RN PADR(|
|00004410| 6d 2e 66 6c 64 6e 61 6d | 65 2c 32 30 29 20 2b 20 |m.fldnam|e,20) + |
|00004420| 27 28 27 20 2b 20 54 59 | 50 45 28 6d 2e 66 6c 64 |'(' + TY|PE(m.fld|
|00004430| 6e 61 6d 65 29 20 2b 20 | 27 29 27 0d 0a 45 4c 53 |name) + |')'..ELS|
|00004440| 45 0d 0a 20 20 20 52 45 | 54 55 52 4e 20 27 27 0d |E..   RE|TURN ''.|
|00004450| 0a 45 4e 44 49 46 0d 0a | 0d 0a 0d 0a 2a 21 2a 2a |.ENDIF..|....*!**|
|00004460| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00004470| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00004480| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00004490| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 0d |********|*******.|
|000044a0| 0a 2a 21 0d 0a 2a 21 20 | 20 20 20 20 20 50 72 6f |.*!..*! |     Pro|
|000044b0| 63 65 64 75 72 65 3a 20 | 47 45 54 54 59 50 45 0d |cedure: |GETTYPE.|
|000044c0| 0a 2a 21 0d 0a 2a 21 2a | 2a 2a 2a 2a 2a 2a 2a 2a |.*!..*!*|********|
|000044d0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|000044e0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|000044f0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00004500| 2a 2a 2a 2a 2a 2a 2a 2a | 0d 0a 46 55 4e 43 54 49 |********|..FUNCTI|
|00004510| 4f 4e 20 67 65 74 74 79 | 70 65 0d 0a 50 41 52 41 |ON getty|pe..PARA|
|00004520| 4d 45 54 45 52 20 6d 2e | 66 6c 64 6e 61 6d 65 0d |METER m.|fldname.|
|00004530| 0a 50 52 49 56 41 54 45 | 20 6d 2e 72 65 74 76 61 |.PRIVATE| m.retva|
|00004540| 6c 0d 0a 2a 20 54 68 69 | 73 20 66 75 6e 63 74 69 |l..* Thi|s functi|
|00004550| 6f 6e 20 65 78 74 72 61 | 63 74 73 20 74 68 65 20 |on extra|cts the |
|00004560| 64 61 74 61 20 74 79 70 | 65 20 66 72 6f 6d 20 74 |data typ|e from t|
|00004570| 68 65 20 66 6f 72 6d 61 | 74 20 75 73 65 64 20 69 |he forma|t used i|
|00004580| 6e 0d 0a 2a 20 74 68 65 | 20 70 61 72 65 6e 74 6c |n..* the| parentl|
|00004590| 69 73 74 20 61 6e 64 20 | 63 68 69 6c 64 6c 69 73 |ist and |childlis|
|000045a0| 74 20 61 72 72 61 79 73 | 2e 20 20 54 68 65 20 69 |t arrays|.  The i|
|000045b0| 6e 63 6f 6d 69 6e 67 20 | 66 6f 72 6d 61 74 20 6c |ncoming |format l|
|000045c0| 6f 6f 6b 73 0d 0a 2a 20 | 6c 69 6b 65 3a 0d 0a 2a |ooks..* |like:..*|
|000045d0| 20 20 20 20 20 20 20 20 | 44 42 46 41 4c 49 41 53 |        |DBFALIAS|
|000045e0| 2e 46 49 45 4c 44 20 20 | 20 20 20 20 28 43 29 0d |.FIELD  |    (C).|
|000045f0| 0a 2a 0d 0a 2a 20 54 68 | 65 20 66 75 6e 63 74 69 |.*..* Th|e functi|
|00004600| 6f 6e 20 72 65 74 75 72 | 6e 73 20 27 43 27 0d 0a |on retur|ns 'C'..|
|00004610| 0d 0a 6d 2e 72 65 74 76 | 61 6c 20 3d 20 52 49 47 |..m.retv|al = RIG|
|00004620| 48 54 28 54 52 49 4d 28 | 6d 2e 66 6c 64 6e 61 6d |HT(TRIM(|m.fldnam|
|00004630| 65 29 2c 33 29 0d 0a 6d | 2e 72 65 74 76 61 6c 20 |e),3)..m|.retval |
|00004640| 3d 20 55 50 50 45 52 28 | 41 4c 4c 54 52 49 4d 28 |= UPPER(|ALLTRIM(|
|00004650| 6d 2e 72 65 74 76 61 6c | 29 29 0d 0a 52 45 54 55 |m.retval|))..RETU|
|00004660| 52 4e 20 43 48 52 54 52 | 41 4e 28 6d 2e 72 65 74 |RN CHRTR|AN(m.ret|
|00004670| 76 61 6c 2c 27 28 29 27 | 2c 27 27 29 0d 0a 0d 0a |val,'()'|,'')....|
|00004680| 2a 21 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |*!******|********|
|00004690| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|000046a0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|000046b0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|000046c0| 2a 2a 2a 0d 0a 2a 21 0d | 0a 2a 21 20 20 20 20 20 |***..*!.|.*!     |
|000046d0| 20 50 72 6f 63 65 64 75 | 72 65 3a 20 43 44 49 53 | Procedu|re: CDIS|
|000046e0| 4c 49 53 54 0d 0a 2a 21 | 0d 0a 2a 21 2a 2a 2a 2a |LIST..*!|..*!****|
|000046f0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00004700| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00004710| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00004720| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 0d 0a 50 |********|*****..P|
|00004730| 52 4f 43 45 44 55 52 45 | 20 63 64 69 73 6c 69 73 |ROCEDURE| cdislis|
|00004740| 74 0d 0a 2a 20 54 68 69 | 73 20 70 72 6f 63 65 64 |t..* Thi|s proced|
|00004750| 75 72 65 20 64 69 73 61 | 62 6c 65 73 20 66 69 65 |ure disa|bles fie|
|00004760| 6c 64 73 20 69 6e 20 74 | 68 65 20 70 61 72 65 6e |lds in t|he paren|
|00004770| 74 20 6c 69 73 74 20 74 | 68 61 74 20 68 61 76 65 |t list t|hat have|
|00004780| 20 61 20 64 69 66 66 65 | 72 65 6e 74 0d 0a 2a 20 | a diffe|rent..* |
|00004790| 74 79 70 65 20 66 72 6f | 6d 20 74 68 65 20 63 75 |type fro|m the cu|
|000047a0| 72 72 65 6e 74 20 66 69 | 65 6c 64 20 69 6e 20 74 |rrent fi|eld in t|
|000047b0| 68 65 20 63 68 69 6c 64 | 20 6c 69 73 74 0d 0a 0d |he child| list...|
|000047c0| 0a 50 41 52 41 4d 45 54 | 45 52 20 63 75 72 69 74 |.PARAMET|ER curit|
|000047d0| 65 6d 0d 0a 50 52 49 56 | 41 54 45 20 6d 2e 63 75 |em..PRIV|ATE m.cu|
|000047e0| 72 69 74 65 6d 2c 20 6d | 2e 73 6f 75 72 63 65 74 |ritem, m|.sourcet|
|000047f0| 79 70 65 2c 20 6d 2e 74 | 61 72 67 74 79 70 65 2c |ype, m.t|argtype,|
|00004800| 20 6d 2e 69 0d 0a 0d 0a | 49 46 20 6d 2e 63 75 72 | m.i....|IF m.cur|
|00004810| 69 74 65 6d 20 3c 3d 20 | 30 0d 0a 20 20 20 6d 2e |item <= |0..   m.|
|00004820| 63 75 72 69 74 65 6d 20 | 3d 20 31 0d 0a 45 4e 44 |curitem |= 1..END|
|00004830| 49 46 0d 0a 0d 0a 6d 2e | 73 6f 75 72 63 65 74 79 |IF....m.|sourcety|
|00004840| 70 65 20 3d 20 67 65 74 | 74 79 70 65 28 63 68 69 |pe = get|type(chi|
|00004850| 6c 64 6c 69 73 74 5b 6d | 2e 63 75 72 69 74 65 6d |ldlist[m|.curitem|
|00004860| 5d 29 0d 0a 0d 0a 46 4f | 52 20 6d 2e 69 20 3d 20 |])....FO|R m.i = |
|00004870| 31 20 54 4f 20 41 4c 45 | 4e 28 70 61 72 65 6e 74 |1 TO ALE|N(parent|
|00004880| 6c 69 73 74 29 0d 0a 20 | 20 20 6d 2e 74 61 72 67 |list).. |  m.targ|
|00004890| 74 79 70 65 20 3d 20 67 | 65 74 74 79 70 65 28 70 |type = g|ettype(p|
|000048a0| 61 72 65 6e 74 6c 69 73 | 74 5b 6d 2e 69 5d 29 0d |arentlis|t[m.i]).|
|000048b0| 0a 20 20 20 49 46 20 6d | 2e 73 6f 75 72 63 65 74 |.   IF m|.sourcet|
|000048c0| 79 70 65 20 3d 3d 20 6d | 2e 74 61 72 67 74 79 70 |ype == m|.targtyp|
|000048d0| 65 0d 0a 20 20 20 20 20 | 20 49 46 20 4c 45 46 54 |e..     | IF LEFT|
|000048e0| 28 70 61 72 65 6e 74 6c | 69 73 74 5b 6d 2e 69 5d |(parentl|ist[m.i]|
|000048f0| 2c 31 29 20 3d 20 27 5c | 27 0d 0a 20 20 20 20 20 |,1) = '\|'..     |
|00004900| 20 20 20 20 70 61 72 65 | 6e 74 6c 69 73 74 5b 6d |    pare|ntlist[m|
|00004910| 2e 69 5d 20 3d 20 53 55 | 42 53 54 52 28 70 61 72 |.i] = SU|BSTR(par|
|00004920| 65 6e 74 6c 69 73 74 5b | 6d 2e 69 5d 2c 32 29 0d |entlist[|m.i],2).|
|00004930| 0a 20 20 20 20 20 20 45 | 4e 44 49 46 0d 0a 20 20 |.      E|NDIF..  |
|00004940| 20 45 4c 53 45 0d 0a 20 | 20 20 20 20 20 49 46 20 | ELSE.. |     IF |
|00004950| 4c 45 46 54 28 70 61 72 | 65 6e 74 6c 69 73 74 5b |LEFT(par|entlist[|
|00004960| 6d 2e 69 5d 2c 31 29 20 | 3c 3e 20 27 5c 27 0d 0a |m.i],1) |<> '\'..|
|00004970| 20 20 20 20 20 20 20 20 | 20 70 61 72 65 6e 74 6c |        | parentl|
|00004980| 69 73 74 5b 6d 2e 69 5d | 20 3d 20 27 5c 27 2b 70 |ist[m.i]| = '\'+p|
|00004990| 61 72 65 6e 74 6c 69 73 | 74 5b 6d 2e 69 5d 0d 0a |arentlis|t[m.i]..|
|000049a0| 20 20 20 20 20 20 45 4e | 44 49 46 0d 0a 20 20 20 |      EN|DIF..   |
|000049b0| 45 4e 44 49 46 0d 0a 45 | 4e 44 46 4f 52 0d 0a 53 |ENDIF..E|NDFOR..S|
|000049c0| 48 4f 57 20 47 45 54 20 | 70 61 72 65 6e 74 6c 69 |HOW GET |parentli|
|000049d0| 73 74 0d 0a 0d 0a 00 00 | 00 00 00 00 00 00 00 00 |st......|........|
|000049e0| 01 00 00 0d 44 23 54 52 | 41 4e 20 53 4e 49 50 50 |....D#TR|AN SNIPP|
|000049f0| 45 54 20 4f 4e 4c 59 0d | 0a 23 53 45 43 54 49 4f |ET ONLY.|.#SECTIO|
|00004a00| 4e 20 31 0d 0a 50 41 52 | 41 4d 45 54 45 52 53 20 |N 1..PAR|AMETERS |
|00004a10| 6d 2e 63 68 69 6c 64 73 | 74 65 6d 2c 20 6d 2e 63 |m.childs|tem, m.c|
|00004a20| 68 69 6c 64 64 62 66 2c | 20 6d 2e 63 68 69 6c 64 |hilddbf,| m.child|
|00004a30| 66 6c 64 2c 20 6d 2e 70 | 61 72 65 6e 74 66 6c 64 |fld, m.p|arentfld|
|00004a40| 2c 20 6d 2e 69 67 6e 63 | 61 73 65 2c 20 3b 0d 0a |, m.ignc|ase, ;..|
|00004a50| 20 20 20 6d 2e 72 65 6c | 73 74 72 2c 20 6d 2e 70 |   m.rel|str, m.p|
|00004a60| 61 72 65 6e 74 64 62 66 | 2c 20 6d 2e 61 64 64 6d |arentdbf|, m.addm|
|00004a70| 6f 64 65 0d 0a 0d 0a 50 | 52 49 56 41 54 45 20 6d |ode....P|RIVATE m|
|00004a80| 2e 69 67 6e 63 61 73 65 | 2c 20 6d 2e 61 64 64 6d |.igncase|, m.addm|
|00004a90| 6f 64 65 2c 20 6d 2e 69 | 2c 20 6d 2e 6a 2c 20 6d |ode, m.i|, m.j, m|
|00004aa0| 2e 61 6c 5f 6e 61 6d 65 | 2c 20 6d 2e 74 68 69 73 |.al_name|, m.this|
|00004ab0| 64 62 66 2c 20 6d 2e 64 | 6f 6e 65 2c 20 6d 2e 69 |dbf, m.d|one, m.i|
|00004ac0| 6e 5f 61 72 65 61 0d 0a | 0d 0a 2a 20 41 73 73 65 |n_area..|..* Asse|
|00004ad0| 6d 62 6c 65 20 73 74 72 | 69 6e 67 20 66 6f 72 20 |mble str|ing for |
|00004ae0| 64 69 61 6c 6f 67 20 74 | 69 74 6c 65 0d 0a 6d 2e |dialog t|itle..m.|
|00004af0| 74 68 69 73 64 62 66 20 | 3d 20 6a 75 73 74 66 6e |thisdbf |= justfn|
|00004b00| 61 6d 65 28 6d 2e 63 68 | 69 6c 64 64 62 66 29 0d |ame(m.ch|ilddbf).|
|00004b10| 0a 0d 0a 2a 20 61 64 64 | 6d 6f 64 65 20 64 65 74 |...* add|mode det|
|00004b20| 65 72 6d 69 6e 65 73 20 | 69 66 20 77 65 20 61 72 |ermines |if we ar|
|00004b30| 65 20 61 64 64 69 6e 67 | 20 61 20 6e 65 77 20 72 |e adding| a new r|
|00004b40| 65 6c 61 74 69 6f 6e 73 | 68 69 70 20 6f 72 20 65 |elations|hip or e|
|00004b50| 64 69 74 69 6e 67 0d 0a | 2a 20 61 6e 20 65 78 69 |diting..|* an exi|
|00004b60| 73 69 6e 67 20 6f 6e 65 | 0d 0a 0d 0a 2a 20 53 74 |sing one|....* St|
|00004b70| 61 72 74 20 77 69 74 68 | 20 6e 65 77 20 63 6f 70 |art with| new cop|
|00004b80| 69 65 73 20 6f 66 20 74 | 68 65 20 6c 69 73 74 20 |ies of t|he list |
|00004b90| 61 72 72 61 79 73 20 61 | 6e 64 20 72 65 6c 65 61 |arrays a|nd relea|
|00004ba0| 73 65 20 61 6e 79 20 74 | 68 61 74 20 0d 0a 2a 20 |se any t|hat ..* |
|00004bb0| 61 6c 72 65 61 64 79 20 | 65 78 69 73 74 0d 0a 52 |already |exist..R|
|00004bc0| 45 4c 45 41 53 45 20 63 | 68 69 6c 64 6c 69 73 74 |ELEASE c|hildlist|
|00004bd0| 2c 20 70 61 72 65 6e 74 | 6c 69 73 74 0d 0a 0d 0a |, parent|list....|
|00004be0| 23 53 45 43 54 49 4f 4e | 20 32 0d 0a 0d 0a 6d 2e |#SECTION| 2....m.|
|00004bf0| 69 6e 5f 61 72 65 61 20 | 3d 20 53 45 4c 45 43 54 |in_area |= SELECT|
|00004c00| 28 29 0d 0a 0d 0a 2a 20 | 4d 61 6b 65 20 73 75 72 |()....* |Make sur|
|00004c10| 65 20 63 68 69 6c 64 20 | 64 61 74 61 62 61 73 65 |e child |database|
|00004c20| 20 65 78 69 73 74 73 0d | 0a 49 46 20 21 46 49 4c | exists.|.IF !FIL|
|00004c30| 45 28 6d 2e 63 68 69 6c | 64 64 62 66 29 0d 0a 20 |E(m.chil|ddbf).. |
|00004c40| 20 20 6d 2e 63 68 69 6c | 64 64 62 66 20 3d 20 47 |  m.chil|ddbf = G|
|00004c50| 45 54 46 49 4c 45 28 27 | 44 42 46 27 2c 27 50 6c |ETFILE('|DBF','Pl|
|00004c60| 65 61 73 65 20 6c 6f 63 | 61 74 65 20 74 68 65 20 |ease loc|ate the |
|00004c70| 27 2b 6a 75 73 74 73 74 | 65 6d 28 6d 2e 63 68 69 |'+justst|em(m.chi|
|00004c80| 6c 64 64 62 66 29 2b 27 | 20 64 61 74 61 62 61 73 |lddbf)+'| databas|
|00004c90| 65 27 29 0d 0a 45 4e 44 | 49 46 0d 0a 49 46 20 45 |e')..END|IF..IF E|
|00004ca0| 4d 50 54 59 28 6d 2e 63 | 68 69 6c 64 64 62 66 29 |MPTY(m.c|hilddbf)|
|00004cb0| 20 4f 52 20 21 46 49 4c | 45 28 6d 2e 63 68 69 6c | OR !FIL|E(m.chil|
|00004cc0| 64 64 62 66 29 0d 0a 20 | 20 20 6d 2e 63 68 69 6c |ddbf).. |  m.chil|
|00004cd0| 64 64 62 66 20 3d 20 27 | 27 0d 0a 20 20 20 52 45 |ddbf = '|'..   RE|
|00004ce0| 54 55 52 4e 0d 0a 45 4e | 44 49 46 0d 0a 0d 0a 0d |TURN..EN|DIF.....|
|00004cf0| 0a 2a 20 46 69 6c 6c 20 | 69 6e 20 74 68 65 20 70 |.* Fill |in the p|
|00004d00| 61 72 65 6e 74 6c 69 73 | 74 20 77 69 74 68 20 74 |arentlis|t with t|
|00004d10| 68 65 20 6e 61 6d 65 73 | 20 6f 66 20 61 6c 6c 20 |he names| of all |
|00004d20| 66 69 65 6c 64 73 0d 0a | 2a 20 20 20 69 6e 20 61 |fields..|*   in a|
|00004d30| 6c 6c 20 6f 70 65 6e 20 | 64 61 74 61 62 61 73 65 |ll open |database|
|00004d40| 73 0d 0a 6d 2e 70 61 72 | 65 6e 74 72 6f 77 20 3d |s..m.par|entrow =|
|00004d50| 20 30 0d 0a 44 49 4d 45 | 4e 53 49 4f 4e 20 70 61 | 0..DIME|NSION pa|
|00004d60| 72 65 6e 74 6c 69 73 74 | 5b 31 5d 0d 0a 70 61 72 |rentlist|[1]..par|
|00004d70| 65 6e 74 6c 69 73 74 5b | 31 5d 20 3d 20 22 22 0d |entlist[|1] = "".|
|00004d80| 0a 46 4f 52 20 6d 2e 69 | 20 3d 20 31 20 54 4f 20 |.FOR m.i| = 1 TO |
|00004d90| 32 35 0d 0a 20 20 20 53 | 45 4c 45 43 54 20 28 6d |25..   S|ELECT (m|
|00004da0| 2e 69 29 0d 0a 20 20 20 | 49 46 20 21 45 4d 50 54 |.i)..   |IF !EMPT|
|00004db0| 59 28 44 42 46 28 6d 2e | 69 29 29 20 41 4e 44 20 |Y(DBF(m.|i)) AND |
|00004dc0| 6d 61 6b 65 61 6c 69 61 | 73 28 6a 75 73 74 73 74 |makealia|s(justst|
|00004dd0| 65 6d 28 44 42 46 28 6d | 2e 69 29 29 29 20 3c 3e |em(DBF(m|.i))) <>|
|00004de0| 20 6d 61 6b 65 61 6c 69 | 61 73 28 6a 75 73 74 73 | makeali|as(justs|
|00004df0| 74 65 6d 28 6d 2e 63 68 | 69 6c 64 73 74 65 6d 29 |tem(m.ch|ildstem)|
|00004e00| 29 0d 0a 20 20 20 20 20 | 20 46 4f 52 20 6d 2e 6a |)..     | FOR m.j|
|00004e10| 20 3d 20 31 20 54 4f 20 | 46 43 4f 55 4e 54 28 6d | = 1 TO |FCOUNT(m|
|00004e20| 2e 69 29 0d 0a 20 20 20 | 20 20 20 20 20 20 6d 2e |.i)..   |      m.|
|00004e30| 70 61 72 65 6e 74 72 6f | 77 20 3d 20 6d 2e 70 61 |parentro|w = m.pa|
|00004e40| 72 65 6e 74 72 6f 77 20 | 2b 20 31 0d 0a 20 20 20 |rentrow |+ 1..   |
|00004e50| 20 20 20 20 20 20 44 49 | 4d 45 4e 53 49 4f 4e 20 |      DI|MENSION |
|00004e60| 70 61 72 65 6e 74 6c 69 | 73 74 5b 6d 2e 70 61 72 |parentli|st[m.par|
|00004e70| 65 6e 74 72 6f 77 5d 0d | 0a 20 20 20 20 20 20 20 |entrow].|.       |
|00004e80| 20 20 70 61 72 65 6e 74 | 6c 69 73 74 5b 6d 2e 70 |  parent|list[m.p|
|00004e90| 61 72 65 6e 74 72 6f 77 | 5d 20 3d 20 61 64 64 74 |arentrow|] = addt|
|00004ea0| 79 70 65 28 41 4c 49 41 | 53 28 6d 2e 69 29 2b 27 |ype(ALIA|S(m.i)+'|
|00004eb0| 2e 27 2b 46 49 45 4c 44 | 28 6d 2e 6a 2c 6d 2e 69 |.'+FIELD|(m.j,m.i|
|00004ec0| 29 29 0d 0a 20 20 20 20 | 20 20 45 4e 44 46 4f 52 |))..    |  ENDFOR|
|00004ed0| 0d 0a 20 20 20 45 4e 44 | 49 46 0d 0a 45 4e 44 46 |..   END|IF..ENDF|
|00004ee0| 4f 52 0d 0a 0d 0a 0d 0a | 2a 20 46 69 6c 6c 20 69 |OR......|* Fill i|
|00004ef0| 6e 20 74 68 65 20 63 68 | 69 6c 64 6c 69 73 74 20 |n the ch|ildlist |
|00004f00| 77 69 74 68 20 74 68 65 | 20 6e 61 6d 65 73 20 6f |with the| names o|
|00004f10| 66 20 61 6c 6c 20 66 69 | 65 6c 64 73 0d 0a 2a 20 |f all fi|elds..* |
|00004f20| 20 20 69 6e 20 74 68 65 | 20 63 68 69 6c 64 20 64 |  in the| child d|
|00004f30| 61 74 61 62 61 73 65 0d | 0a 6d 2e 63 68 69 6c 64 |atabase.|.m.child|
|00004f40| 72 6f 77 20 3d 20 30 0d | 0a 44 49 4d 45 4e 53 49 |row = 0.|.DIMENSI|
|00004f50| 4f 4e 20 63 68 69 6c 64 | 6c 69 73 74 5b 31 5d 0d |ON child|list[1].|
|00004f60| 0a 63 68 69 6c 64 6c 69 | 73 74 28 31 29 20 3d 20 |.childli|st(1) = |
|00004f70| 22 22 0d 0a 49 46 20 55 | 53 45 44 28 6d 61 6b 65 |""..IF U|SED(make|
|00004f80| 61 6c 69 61 73 28 6d 2e | 63 68 69 6c 64 73 74 65 |alias(m.|childste|
|00004f90| 6d 29 29 0d 0a 20 20 20 | 6d 2e 61 6c 5f 6e 61 6d |m))..   |m.al_nam|
|00004fa0| 65 20 3d 20 6d 61 6b 65 | 61 6c 69 61 73 28 6d 2e |e = make|alias(m.|
|00004fb0| 63 68 69 6c 64 73 74 65 | 6d 29 0d 0a 20 20 20 53 |childste|m)..   S|
|00004fc0| 45 4c 45 43 54 20 28 6d | 2e 61 6c 5f 6e 61 6d 65 |ELECT (m|.al_name|
|00004fd0| 29 0d 0a 45 4c 53 45 0d | 0a 20 20 20 53 45 4c 45 |)..ELSE.|.   SELE|
|00004fe0| 43 54 20 30 0d 0a 20 20 | 20 55 53 45 20 28 6d 2e |CT 0..  | USE (m.|
|00004ff0| 63 68 69 6c 64 64 62 66 | 29 0d 0a 45 4e 44 49 46 |childdbf|)..ENDIF|
|00005000| 0d 0a 46 4f 52 20 6d 2e | 6a 20 3d 20 31 20 54 4f |..FOR m.|j = 1 TO|
|00005010| 20 46 43 4f 55 4e 54 28 | 29 0d 0a 20 20 20 49 46 | FCOUNT(|)..   IF|
|00005020| 20 54 59 50 45 28 46 49 | 45 4c 44 28 6d 2e 6a 29 | TYPE(FI|ELD(m.j)|
|00005030| 29 20 3c 3e 20 22 4d 22 | 0d 0a 20 20 20 20 20 20 |) <> "M"|..      |
|00005040| 6d 2e 63 68 69 6c 64 72 | 6f 77 20 3d 20 6d 2e 63 |m.childr|ow = m.c|
|00005050| 68 69 6c 64 72 6f 77 20 | 2b 20 31 0d 0a 20 20 20 |hildrow |+ 1..   |
|00005060| 20 20 20 44 49 4d 45 4e | 53 49 4f 4e 20 63 68 69 |   DIMEN|SION chi|
|00005070| 6c 64 6c 69 73 74 5b 6d | 2e 63 68 69 6c 64 72 6f |ldlist[m|.childro|
|00005080| 77 5d 0d 0a 20 20 20 20 | 20 20 63 68 69 6c 64 6c |w]..    |  childl|
|00005090| 69 73 74 5b 6d 2e 63 68 | 69 6c 64 72 6f 77 5d 20 |ist[m.ch|ildrow] |
|000050a0| 3d 20 61 64 64 74 79 70 | 65 28 41 4c 49 41 53 28 |= addtyp|e(ALIAS(|
|000050b0| 29 2b 27 2e 27 2b 46 49 | 45 4c 44 28 6d 2e 6a 29 |)+'.'+FI|ELD(m.j)|
|000050c0| 29 0d 0a 20 20 20 45 4e | 44 49 46 0d 0a 45 4e 44 |)..   EN|DIF..END|
|000050d0| 46 4f 52 0d 0a 0d 0a 2a | 20 50 6f 73 69 74 69 6f |FOR....*| Positio|
|000050e0| 6e 20 73 65 6c 65 63 74 | 69 6f 6e 20 62 61 72 73 |n select|ion bars|
|000050f0| 20 6f 6e 74 6f 20 69 6e | 74 65 6c 6c 69 67 65 6e | onto in|telligen|
|00005100| 74 20 64 65 66 61 75 6c | 74 73 2e 20 20 54 72 79 |t defaul|ts.  Try|
|00005110| 20 74 6f 20 6d 61 74 63 | 68 0d 0a 2a 20 66 69 65 | to matc|h..* fie|
|00005120| 6c 64 20 6e 61 6d 65 73 | 20 62 65 74 77 65 65 6e |ld names| between|
|00005130| 20 74 68 65 20 70 61 72 | 65 6e 74 20 61 6e 64 20 | the par|ent and |
|00005140| 63 68 69 6c 64 20 64 61 | 74 61 62 61 73 65 73 2e |child da|tabases.|
|00005150| 0d 0a 6d 2e 64 6f 6e 65 | 20 3d 20 2e 46 2e 0d 0a |..m.done| = .F...|
|00005160| 49 46 20 45 4d 50 54 59 | 28 6d 2e 70 61 72 65 6e |IF EMPTY|(m.paren|
|00005170| 74 66 6c 64 29 0d 0a 20 | 20 20 49 46 20 45 4d 50 |tfld).. |  IF EMP|
|00005180| 54 59 28 6d 2e 63 68 69 | 6c 64 66 6c 64 29 0d 0a |TY(m.chi|ldfld)..|
|00005190| 20 20 20 20 20 20 2a 20 | 53 65 65 20 69 66 20 74 |      * |See if t|
|000051a0| 68 65 72 65 20 61 72 65 | 20 61 6e 79 20 66 69 65 |here are| any fie|
|000051b0| 6c 64 73 20 69 6e 20 74 | 68 65 20 70 61 72 65 6e |lds in t|he paren|
|000051c0| 74 20 64 61 74 61 62 61 | 73 65 20 77 69 74 68 0d |t databa|se with.|
|000051d0| 0a 20 20 20 20 20 20 2a | 20 74 68 65 20 73 61 6d |.      *| the sam|
|000051e0| 65 20 6e 61 6d 65 20 61 | 6e 64 20 74 79 70 65 20 |e name a|nd type |
|000051f0| 61 73 20 61 20 66 69 65 | 6c 64 20 69 6e 20 74 68 |as a fie|ld in th|
|00005200| 65 20 63 68 69 6c 64 20 | 64 61 74 61 62 61 73 65 |e child |database|
|00005210| 0d 0a 20 20 20 20 20 20 | 6d 2e 69 20 3d 20 31 0d |..      |m.i = 1.|
|00005220| 0a 20 20 20 20 20 20 44 | 4f 20 57 48 49 4c 45 20 |.      D|O WHILE |
|00005230| 21 64 6f 6e 65 20 41 4e | 44 20 6d 2e 69 20 3c 3d |!done AN|D m.i <=|
|00005240| 20 6d 2e 63 68 69 6c 64 | 72 6f 77 0d 0a 20 20 20 | m.child|row..   |
|00005250| 20 20 20 20 20 20 6d 2e | 6e 65 77 63 68 69 6c 64 |      m.|newchild|
|00005260| 20 20 3d 20 53 55 42 53 | 54 52 28 63 68 69 6c 64 |  = SUBS|TR(child|
|00005270| 6c 69 73 74 5b 6d 2e 69 | 5d 2c 41 54 28 27 2e 27 |list[m.i|],AT('.'|
|00005280| 2c 63 68 69 6c 64 6c 69 | 73 74 5b 6d 2e 69 5d 29 |,childli|st[m.i])|
|00005290| 2b 31 29 0d 0a 20 20 20 | 20 20 20 20 20 20 6d 2e |+1)..   |      m.|
|000052a0| 6e 65 77 63 68 69 6c 64 | 20 20 3d 20 43 48 52 54 |newchild|  = CHRT|
|000052b0| 52 41 4e 28 6d 2e 6e 65 | 77 63 68 69 6c 64 2c 27 |RAN(m.ne|wchild,'|
|000052c0| 20 27 2c 27 27 29 0d 0a | 20 20 20 20 20 20 20 20 | ','')..|        |
|000052d0| 20 6d 2e 6a 20 3d 20 31 | 0d 0a 20 20 20 20 20 20 | m.j = 1|..      |
|000052e0| 20 20 20 44 4f 20 57 48 | 49 4c 45 20 21 6d 2e 64 |   DO WH|ILE !m.d|
|000052f0| 6f 6e 65 20 41 4e 44 20 | 6d 2e 6a 20 3c 3d 20 6d |one AND |m.j <= m|
|00005300| 2e 70 61 72 65 6e 74 72 | 6f 77 0d 0a 20 20 20 20 |.parentr|ow..    |
|00005310| 20 20 20 20 20 20 20 20 | 2a 20 41 73 73 65 6d 62 |        |* Assemb|
|00005320| 6c 65 20 61 20 6e 65 77 | 20 6e 61 6d 65 20 62 61 |le a new| name ba|
|00005330| 73 65 64 20 6f 6e 20 74 | 68 65 20 66 69 65 6c 64 |sed on t|he field|
|00005340| 20 6e 61 6d 65 20 61 6e | 64 20 74 68 65 20 66 69 | name an|d the fi|
|00005350| 65 6c 64 20 74 79 70 65 | 0d 0a 20 20 20 20 20 20 |eld type|..      |
|00005360| 20 20 20 20 20 20 2a 20 | 54 68 65 20 70 61 72 65 |      * |The pare|
|00005370| 6e 74 6c 69 73 74 20 72 | 65 63 6f 72 64 73 20 6c |ntlist r|ecords l|
|00005380| 6f 6f 6b 20 6c 69 6b 65 | 20 74 68 69 73 3a 0d 0a |ook like| this:..|
|00005390| 20 20 20 20 20 20 20 20 | 20 20 20 20 2a 20 20 20 |        |    *   |
|000053a0| 20 61 6c 69 61 73 2e 66 | 6c 64 20 20 20 20 20 20 | alias.f|ld      |
|000053b0| 20 28 4e 29 0d 0a 20 20 | 20 20 20 20 20 20 20 20 | (N)..  |        |
|000053c0| 20 20 2a 20 22 4e 65 77 | 70 61 72 65 6e 74 22 20 |  * "New|parent" |
|000053d0| 6e 6f 77 20 6c 6f 6f 6b | 73 20 6c 69 6b 65 20 74 |now look|s like t|
|000053e0| 68 69 73 3a 0d 0a 20 20 | 20 20 20 20 20 20 20 20 |his:..  |        |
|000053f0| 20 20 2a 20 20 20 20 20 | 66 6c 64 28 4e 29 0d 0a |  *     |fld(N)..|
|00005400| 20 20 20 20 20 20 20 20 | 20 20 20 20 6d 2e 6e 65 |        |    m.ne|
|00005410| 77 70 61 72 65 6e 74 20 | 3d 20 53 55 42 53 54 52 |wparent |= SUBSTR|
|00005420| 28 70 61 72 65 6e 74 6c | 69 73 74 5b 6d 2e 6a 5d |(parentl|ist[m.j]|
|00005430| 2c 41 54 28 27 2e 27 2c | 70 61 72 65 6e 74 6c 69 |,AT('.',|parentli|
|00005440| 73 74 5b 6d 2e 6a 5d 29 | 2b 31 29 0d 0a 20 20 20 |st[m.j])|+1)..   |
|00005450| 20 20 20 20 20 20 20 20 | 20 6d 2e 6e 65 77 70 61 |        | m.newpa|
|00005460| 72 65 6e 74 20 3d 20 43 | 48 52 54 52 41 4e 28 6e |rent = C|HRTRAN(n|
|00005470| 65 77 70 61 72 65 6e 74 | 2c 27 20 27 2c 27 27 29 |ewparent|,' ','')|
|00005480| 0d 0a 0d 0a 20 20 20 20 | 20 20 20 20 20 20 20 20 |....    |        |
|00005490| 49 46 20 6d 2e 6e 65 77 | 70 61 72 65 6e 74 20 3d |IF m.new|parent =|
|000054a0| 3d 20 6d 2e 6e 65 77 63 | 68 69 6c 64 0d 0a 20 20 |= m.newc|hild..  |
|000054b0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 6d 2e 70 |        |     m.p|
|000054c0| 61 72 65 6e 74 66 6c 64 | 20 3d 20 70 61 72 65 6e |arentfld| = paren|
|000054d0| 74 6c 69 73 74 5b 6d 2e | 6a 5d 0d 0a 20 20 20 20 |tlist[m.|j]..    |
|000054e0| 20 20 20 20 20 20 20 20 | 20 20 20 6d 2e 63 68 69 |        |   m.chi|
|000054f0| 6c 64 66 6c 64 20 20 3d | 20 63 68 69 6c 64 6c 69 |ldfld  =| childli|
|00005500| 73 74 5b 6d 2e 69 5d 0d | 0a 20 20 20 20 20 20 20 |st[m.i].|.       |
|00005510| 20 20 20 20 20 20 20 20 | 6d 2e 64 6f 6e 65 20 3d |        |m.done =|
|00005520| 20 2e 54 2e 0d 0a 20 20 | 20 20 20 20 20 20 20 20 | .T...  |        |
|00005530| 20 20 45 4e 44 49 46 0d | 0a 20 20 20 20 20 20 20 |  ENDIF.|.       |
|00005540| 20 20 20 20 20 6d 2e 6a | 20 3d 20 6d 2e 6a 20 2b |     m.j| = m.j +|
|00005550| 20 31 0d 0a 20 20 20 20 | 20 20 20 20 20 45 4e 44 | 1..    |     END|
|00005560| 44 4f 0d 0a 20 20 20 20 | 20 20 20 20 20 6d 2e 69 |DO..    |     m.i|
|00005570| 20 3d 20 6d 2e 69 20 2b | 20 31 0d 0a 20 20 20 20 | = m.i +| 1..    |
|00005580| 20 20 45 4e 44 44 4f 0d | 0a 0d 0a 20 20 20 20 20 |  ENDDO.|...     |
|00005590| 20 49 46 20 21 6d 2e 64 | 6f 6e 65 20 20 20 20 26 | IF !m.d|one    &|
|000055a0| 26 20 6e 6f 20 6d 61 74 | 63 68 65 73 20 66 6f 75 |& no mat|ches fou|
|000055b0| 6e 64 2e 20 20 44 65 66 | 61 75 6c 74 20 74 6f 20 |nd.  Def|ault to |
|000055c0| 66 69 72 73 74 20 66 69 | 65 6c 64 2e 0d 0a 20 20 |first fi|eld...  |
|000055d0| 20 20 20 20 20 20 20 6d | 2e 63 68 69 6c 64 66 6c |       m|.childfl|
|000055e0| 64 20 20 20 3d 20 63 68 | 69 6c 64 6c 69 73 74 5b |d   = ch|ildlist[|
|000055f0| 31 5d 0d 0a 20 20 20 20 | 20 20 45 4e 44 49 46 0d |1]..    |  ENDIF.|
|00005600| 0a 20 20 20 45 4c 53 45 | 0d 0a 20 20 20 20 20 20 |.   ELSE|..      |
|00005610| 2a 20 44 65 66 61 75 6c | 74 20 74 6f 20 74 68 65 |* Defaul|t to the|
|00005620| 20 66 69 72 73 74 20 66 | 69 65 6c 64 20 0d 0a 20 | first f|ield .. |
|00005630| 20 20 20 20 20 6d 2e 70 | 61 72 65 6e 74 66 6c 64 |     m.p|arentfld|
|00005640| 20 20 3d 20 70 61 72 65 | 6e 74 6c 69 73 74 5b 31 |  = pare|ntlist[1|
|00005650| 5d 0d 0a 20 20 20 20 20 | 20 6d 2e 63 68 69 6c 64 |]..     | m.child|
|00005660| 66 6c 64 20 20 20 3d 20 | 61 64 64 74 79 70 65 28 |fld   = |addtype(|
|00005670| 6d 2e 63 68 69 6c 64 66 | 6c 64 29 0d 0a 20 20 20 |m.childf|ld)..   |
|00005680| 45 4e 44 49 46 0d 0a 45 | 4c 53 45 0d 0a 20 20 20 |ENDIF..E|LSE..   |
|00005690| 6d 2e 70 61 72 65 6e 74 | 66 6c 64 20 20 3d 20 61 |m.parent|fld  = a|
|000056a0| 64 64 74 79 70 65 28 6d | 2e 70 61 72 65 6e 74 66 |ddtype(m|.parentf|
|000056b0| 6c 64 29 0d 0a 20 20 20 | 6d 2e 63 68 69 6c 64 66 |ld)..   |m.childf|
|000056c0| 6c 64 20 20 20 3d 20 61 | 64 64 74 79 70 65 28 6d |ld   = a|ddtype(m|
|000056d0| 2e 63 68 69 6c 64 66 6c | 64 29 0d 0a 45 4e 44 49 |.childfl|d)..ENDI|
|000056e0| 46 0d 0a 0d 0a 44 4f 20 | 63 64 69 73 6c 69 73 74 |F....DO |cdislist|
|000056f0| 20 57 49 54 48 20 41 53 | 43 41 4e 28 63 68 69 6c | WITH AS|CAN(chil|
|00005700| 64 6c 69 73 74 2c 6d 2e | 63 68 69 6c 64 66 6c 64 |dlist,m.|childfld|
|00005710| 29 0d 0a 0d 0a 53 45 4c | 45 43 54 20 28 6d 2e 69 |)....SEL|ECT (m.i|
|00005720| 6e 5f 61 72 65 61 29 0d | 0a 00 00 00 00 00 00 00 |n_area).|........|
|00005730| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005740| 00 00 00 00 00 00 00 00 | 01 00 00 00 0b 6d 2e 70 |........|.....m.p|
|00005750| 61 72 65 6e 74 66 6c 64 | 00 00 00 00 00 00 00 00 |arentfld|........|
|00005760| 00 00 00 00 00 00 00 00 | 00 01 00 00 00 0a 70 61 |........|......pa|
|00005770| 72 65 6e 74 6c 69 73 74 | 00 00 00 00 00 00 00 00 |rentlist|........|
|00005780| 00 00 00 00 00 00 00 00 | 00 00 01 00 00 00 05 22 |........|......."|
|00005790| 40 5e 20 22 00 00 00 00 | 00 00 00 00 00 00 00 00 |@^ "....|........|
|000057a0| 00 00 00 00 00 00 00 00 | 00 00 00 01 00 00 00 0b |........|........|
|000057b0| 53 48 4f 57 20 47 45 54 | 53 0d 0a 00 00 00 00 00 |SHOW GET|S.......|
|000057c0| 00 00 00 00 00 00 00 00 | 00 00 00 00 01 00 00 00 |........|........|
|000057d0| 08 22 45 71 75 61 6c 73 | 22 00 00 00 00 00 00 00 |."Equals|".......|
|000057e0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 01 00 00 |........|........|
|000057f0| 00 0a 6d 2e 63 68 69 6c | 64 66 6c 64 00 00 00 00 |..m.chil|dfld....|
|00005800| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 01 00 |........|........|
|00005810| 00 00 09 63 68 69 6c 64 | 6c 69 73 74 00 00 00 00 |...child|list....|
|00005820| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 01 |........|........|
|00005830| 00 00 00 05 22 40 5e 20 | 22 00 00 00 00 00 00 00 |...."@^ |".......|
|00005840| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005850| 01 00 00 00 37 44 4f 20 | 63 64 69 73 6c 69 73 74 |....7DO |cdislist|
|00005860| 20 57 49 54 48 20 41 53 | 43 41 4e 28 63 68 69 6c | WITH AS|CAN(chil|
|00005870| 64 6c 69 73 74 2c 63 68 | 69 6c 64 66 6c 64 29 0d |dlist,ch|ildfld).|
|00005880| 0a 53 48 4f 57 20 47 45 | 54 53 0d 0a 00 00 00 00 |.SHOW GE|TS......|
|00005890| 00 00 01 00 00 00 17 22 | 46 69 65 6c 64 20 69 6e |......."|Field in|
|000058a0| 20 4f 74 68 65 72 20 54 | 61 62 6c 65 3a 22 00 00 | Other T|able:"..|
|000058b0| 00 00 00 01 00 00 00 16 | 22 46 69 65 6c 64 20 69 |........|"Field i|
|000058c0| 6e 20 54 68 69 73 20 54 | 61 62 6c 65 3a 22 00 00 |n This T|able:"..|
|000058d0| 00 00 00 00 01 00 00 00 | 2d 22 48 6f 77 20 69 73 |........|-"How is|
|000058e0| 20 54 68 69 73 20 54 61 | 62 6c 65 20 52 65 6c 61 | This Ta|ble Rela|
|000058f0| 74 65 64 20 74 6f 20 41 | 6e 6f 74 68 65 72 20 54 |ted to A|nother T|
|00005900| 61 62 6c 65 3f 22 00 00 | 00 00 00 00 00 00 00 00 |able?"..|........|
|00005910| 00 00 00 00 00 00 01 00 | 00 00 09 6d 2e 6f 6b 63 |........|...m.okc|
|00005920| 61 6e 63 6c 00 00 00 00 | 00 00 00 00 00 00 00 00 |ancl....|........|
|00005930| 00 00 00 00 00 00 00 01 | 00 00 00 18 22 40 2a 48 |........|...."@*H|
|00005940| 4e 20 5c 21 5c 3c 4f 4b | 3b 5c 3f 5c 3c 43 61 6e |N \!\<OK|;\?\<Can|
|00005950| 63 65 6c 22 00 00 00 00 | 01 00 00 05 b4 2a 20 53 |cel"....|.....* S|
|00005960| 74 72 69 70 20 6f 66 66 | 20 74 68 65 20 74 79 70 |trip off| the typ|
|00005970| 65 20 64 65 73 69 67 6e | 61 74 69 6f 6e 73 20 66 |e design|ations f|
|00005980| 72 6f 6d 20 66 69 65 6c | 64 20 6e 61 6d 65 73 0d |rom fiel|d names.|
|00005990| 0a 6d 2e 70 66 6c 64 20 | 3d 20 6d 2e 70 61 72 65 |.m.pfld |= m.pare|
|000059a0| 6e 74 66 6c 64 0d 0a 6d | 2e 63 66 6c 64 20 3d 20 |ntfld..m|.cfld = |
|000059b0| 6d 2e 63 68 69 6c 64 66 | 6c 64 0d 0a 49 46 20 41 |m.childf|ld..IF A|
|000059c0| 54 28 27 28 27 2c 6d 2e | 70 61 72 65 6e 74 66 6c |T('(',m.|parentfl|
|000059d0| 64 29 20 3e 20 30 0d 0a | 20 20 20 6d 2e 70 61 72 |d) > 0..|   m.par|
|000059e0| 65 6e 74 66 6c 64 20 3d | 20 41 4c 4c 54 52 49 4d |entfld =| ALLTRIM|
|000059f0| 28 53 55 42 53 54 52 28 | 6d 2e 70 61 72 65 6e 74 |(SUBSTR(|m.parent|
|00005a00| 66 6c 64 2c 31 2c 4c 45 | 4e 28 54 52 49 4d 28 6d |fld,1,LE|N(TRIM(m|
|00005a10| 2e 70 61 72 65 6e 74 66 | 6c 64 29 29 2d 33 29 29 |.parentf|ld))-3))|
|00005a20| 0d 0a 45 4e 44 49 46 0d | 0a 49 46 20 41 54 28 27 |..ENDIF.|.IF AT('|
|00005a30| 28 27 2c 6d 2e 63 68 69 | 6c 64 66 6c 64 29 20 3e |(',m.chi|ldfld) >|
|00005a40| 20 30 0d 0a 20 20 20 6d | 2e 63 68 69 6c 64 66 6c | 0..   m|.childfl|
|00005a50| 64 20 20 3d 20 41 4c 4c | 54 52 49 4d 28 53 55 42 |d  = ALL|TRIM(SUB|
|00005a60| 53 54 52 28 6d 2e 63 68 | 69 6c 64 66 6c 64 2c 31 |STR(m.ch|ildfld,1|
|00005a70| 2c 4c 45 4e 28 54 52 49 | 4d 28 6d 2e 63 68 69 6c |,LEN(TRI|M(m.chil|
|00005a80| 64 66 6c 64 29 29 2d 33 | 29 29 0d 0a 45 4e 44 49 |dfld))-3|))..ENDI|
|00005a90| 46 0d 0a 0d 0a 44 4f 20 | 43 41 53 45 0d 0a 43 41 |F....DO |CASE..CA|
|00005aa0| 53 45 20 6d 2e 6f 6b 63 | 61 6e 63 6c 20 3d 20 31 |SE m.okc|ancl = 1|
|00005ab0| 0d 0a 20 20 20 2a 20 4d | 61 6b 65 20 73 75 72 65 |..   * M|ake sure|
|00005ac0| 20 74 68 69 73 20 69 73 | 20 61 20 76 61 6c 69 64 | this is| a valid|
|00005ad0| 20 73 65 6c 65 63 74 69 | 6f 6e 20 77 69 74 68 20 | selecti|on with |
|00005ae0| 72 65 73 70 65 63 74 20 | 74 6f 20 64 61 74 61 20 |respect |to data |
|00005af0| 74 79 70 65 0d 0a 20 20 | 20 44 4f 20 43 41 53 45 |type..  | DO CASE|
|00005b00| 0d 0a 20 20 20 43 41 53 | 45 20 54 59 50 45 28 6d |..   CAS|E TYPE(m|
|00005b10| 2e 63 68 69 6c 64 66 6c | 64 29 20 3d 20 27 55 27 |.childfl|d) = 'U'|
|00005b20| 0d 0a 20 20 20 20 20 20 | 57 41 49 54 20 57 49 4e |..      |WAIT WIN|
|00005b30| 44 4f 57 20 22 54 68 65 | 20 63 68 69 6c 64 20 64 |DOW "The| child d|
|00005b40| 61 74 61 62 61 73 65 20 | 63 6f 75 6c 64 20 6e 6f |atabase |could no|
|00005b50| 74 20 62 65 20 66 6f 75 | 6e 64 2e 22 0d 0a 20 20 |t be fou|nd."..  |
|00005b60| 20 43 41 53 45 20 54 59 | 50 45 28 6d 2e 70 61 72 | CASE TY|PE(m.par|
|00005b70| 65 6e 74 66 6c 64 29 20 | 3d 20 27 55 27 0d 0a 20 |entfld) |= 'U'.. |
|00005b80| 20 20 20 20 20 57 41 49 | 54 20 57 49 4e 44 4f 57 |     WAI|T WINDOW|
|00005b90| 20 22 54 68 65 20 70 61 | 72 65 6e 74 20 64 61 74 | "The pa|rent dat|
|00005ba0| 61 62 61 73 65 20 63 6f | 75 6c 64 20 6e 6f 74 20 |abase co|uld not |
|00005bb0| 62 65 20 66 6f 75 6e 64 | 2e 22 0d 0a 20 20 20 43 |be found|."..   C|
|00005bc0| 41 53 45 20 54 59 50 45 | 28 6d 2e 63 68 69 6c 64 |ASE TYPE|(m.child|
|00005bd0| 66 6c 64 29 20 3d 3d 20 | 54 59 50 45 28 6d 2e 70 |fld) == |TYPE(m.p|
|00005be0| 61 72 65 6e 74 66 6c 64 | 29 0d 0a 20 20 20 20 20 |arentfld|)..     |
|00005bf0| 20 6d 2e 64 62 66 70 61 | 72 74 20 20 20 3d 20 53 | m.dbfpa|rt   = S|
|00005c00| 55 42 53 54 52 28 6d 2e | 63 68 69 6c 64 66 6c 64 |UBSTR(m.|childfld|
|00005c10| 2c 31 2c 41 54 28 27 2e | 27 2c 6d 2e 63 68 69 6c |,1,AT('.|',m.chil|
|00005c20| 64 66 6c 64 29 2d 31 29 | 0d 0a 20 20 20 20 20 20 |dfld)-1)|..      |
|00005c30| 6d 2e 72 65 6c 73 74 72 | 20 20 20 20 3d 20 27 53 |m.relstr|    = 'S|
|00005c40| 45 54 20 52 45 4c 41 54 | 49 4f 4e 20 54 4f 20 27 |ET RELAT|ION TO '|
|00005c50| 3b 0d 0a 20 20 20 20 20 | 20 20 20 20 2b 53 55 42 |;..     |    +SUB|
|00005c60| 53 54 52 28 6d 2e 70 61 | 72 65 6e 74 66 6c 64 2c |STR(m.pa|rentfld,|
|00005c70| 41 54 28 27 2e 27 2c 6d | 2e 70 61 72 65 6e 74 66 |AT('.',m|.parentf|
|00005c80| 6c 64 29 2b 31 29 3b 0d | 0a 20 20 20 20 20 20 20 |ld)+1);.|.       |
|00005c90| 20 20 2b 27 20 49 4e 54 | 4f 20 27 2b 6d 2e 64 62 |  +' INT|O '+m.db|
|00005ca0| 66 70 61 72 74 0d 0a 20 | 20 20 20 20 20 6d 2e 70 |fpart.. |     m.p|
|00005cb0| 61 72 65 6e 74 64 62 66 | 20 3d 20 53 55 42 53 54 |arentdbf| = SUBST|
|00005cc0| 52 28 6d 2e 70 61 72 65 | 6e 74 66 6c 64 2c 31 2c |R(m.pare|ntfld,1,|
|00005cd0| 41 54 28 27 2e 27 2c 6d | 2e 70 61 72 65 6e 74 66 |AT('.',m|.parentf|
|00005ce0| 6c 64 29 2d 31 29 0d 0a | 20 20 20 20 20 20 43 4c |ld)-1)..|      CL|
|00005cf0| 45 41 52 20 52 45 41 44 | 0d 0a 20 20 20 4f 54 48 |EAR READ|..   OTH|
|00005d00| 45 52 57 49 53 45 0d 0a | 20 20 20 20 20 20 57 41 |ERWISE..|      WA|
|00005d10| 49 54 20 57 49 4e 44 4f | 57 20 22 50 61 72 65 6e |IT WINDO|W "Paren|
|00005d20| 74 20 61 6e 64 20 63 68 | 69 6c 64 20 68 61 76 65 |t and ch|ild have|
|00005d30| 20 64 69 66 66 65 72 65 | 6e 74 20 64 61 74 61 20 | differe|nt data |
|00005d40| 74 79 70 65 73 2e 22 0d | 0a 20 20 20 20 20 20 2a |types.".|.      *|
|00005d50| 20 52 65 73 74 6f 72 65 | 20 66 75 6c 6c 20 73 74 | Restore| full st|
|00005d60| 72 69 6e 67 20 74 6f 20 | 70 61 72 65 6e 74 20 61 |ring to |parent a|
|00005d70| 6e 64 20 63 68 69 6c 64 | 20 66 69 65 6c 64 73 0d |nd child| fields.|
|00005d80| 0a 20 20 20 20 20 20 6d | 2e 70 61 72 65 6e 74 66 |.      m|.parentf|
|00005d90| 6c 64 20 3d 20 6d 2e 70 | 66 6c 64 0d 0a 20 20 20 |ld = m.p|fld..   |
|00005da0| 20 20 20 6d 2e 63 68 69 | 6c 64 66 6c 64 20 20 3d |   m.chi|ldfld  =|
|00005db0| 20 6d 2e 63 66 6c 64 0d | 0a 20 20 20 45 4e 44 43 | m.cfld.|.   ENDC|
|00005dc0| 41 53 45 0d 0a 43 41 53 | 45 20 6d 2e 6f 6b 63 61 |ASE..CAS|E m.okca|
|00005dd0| 6e 63 6c 20 3d 20 32 20 | 20 20 20 20 26 26 20 63 |ncl = 2 |    && c|
|00005de0| 61 6e 63 65 6c 20 74 68 | 69 73 20 72 65 6c 61 74 |ancel th|is relat|
|00005df0| 69 6f 6e 73 68 69 70 0d | 0a 20 20 20 2a 20 57 65 |ionship.|.   * We|
|00005e00| 20 6f 70 65 6e 65 64 20 | 63 68 69 6c 64 73 74 65 | opened |childste|
|00005e10| 6d 20 69 6e 20 74 68 65 | 20 73 65 74 75 70 20 73 |m in the| setup s|
|00005e20| 6e 69 70 70 65 74 2e 20 | 20 43 6c 6f 73 65 20 69 |nippet. | Close i|
|00005e30| 74 20 6e 6f 77 2e 0d 0a | 20 20 20 49 46 20 6d 2e |t now...|   IF m.|
|00005e40| 61 64 64 6d 6f 64 65 20 | 41 4e 44 20 55 53 45 44 |addmode |AND USED|
|00005e50| 28 6d 2e 63 68 69 6c 64 | 73 74 65 6d 29 0d 0a 20 |(m.child|stem).. |
|00005e60| 20 20 20 20 20 53 45 4c | 45 43 54 20 28 6d 2e 63 |     SEL|ECT (m.c|
|00005e70| 68 69 6c 64 73 74 65 6d | 29 0d 0a 20 20 20 20 20 |hildstem|)..     |
|00005e80| 20 55 53 45 0d 0a 20 20 | 20 45 4e 44 49 46 0d 0a | USE..  | ENDIF..|
|00005e90| 20 20 20 6d 2e 64 62 66 | 70 61 72 74 20 20 20 3d |   m.dbf|part   =|
|00005ea0| 20 27 27 0d 0a 20 20 20 | 6d 2e 63 68 69 6c 64 66 | ''..   |m.childf|
|00005eb0| 6c 64 20 20 3d 20 27 27 | 0d 0a 20 20 20 6d 2e 63 |ld  = ''|..   m.c|
|00005ec0| 68 69 6c 64 64 62 66 20 | 20 3d 20 27 27 0d 0a 20 |hilddbf | = ''.. |
|00005ed0| 20 20 6d 2e 72 65 6c 73 | 74 72 20 20 20 20 3d 20 |  m.rels|tr    = |
|00005ee0| 27 27 0d 0a 20 20 20 6d | 2e 70 61 72 65 6e 74 64 |''..   m|.parentd|
|00005ef0| 62 66 20 3d 20 27 27 0d | 0a 20 20 20 43 4c 45 41 |bf = ''.|.   CLEA|
|00005f00| 52 20 52 45 41 44 0d 0a | 45 4e 44 43 41 53 45 0d |R READ..|ENDCASE.|
|00005f10| 0a 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005f20| 00 00 00 00 00 01 00 00 | 00 04 22 4f 4b 22 00 00 |........|.."OK"..|
|00005f30| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005f40| 00 00 00 00 00 00 01 00 | 00 00 08 6d 2e 61 64 76 |........|...m.adv|
|00005f50| 62 75 74 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |but.....|........|
|00005f60| 00 00 00 00 00 00 00 01 | 00 00 00 14 22 40 2a 48 |........|...."@*H|
|00005f70| 4e 20 5c 3c 41 64 76 61 | 6e 63 65 64 2e 2e 2e 22 |N \<Adva|nced..."|
|00005f80| 00 00 00 00 00 00 00 00 | 01 00 00 00 3c 44 4f 20 |........|....<DO |
|00005f90| 63 61 73 63 64 6c 67 2e | 73 70 72 20 57 49 54 48 |cascdlg.|spr WITH|
|00005fa0| 20 64 62 66 6c 69 73 74 | 5b 6d 2e 6e 65 78 74 64 | dbflist|[m.nextd|
|00005fb0| 62 66 2c 6d 2e 63 73 74 | 65 6d 6e 75 6d 5d 0d 0a |bf,m.cst|emnum]..|
|00005fc0| 0d 0a 20 20 20 0d 0a 0d | 0a 00 00 00 00 00 00 00 |..   ...|........|
|00005fd0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005fe0| 00 00 00 00 00 00 00 00 | 00 00 00 01 00 00 00 0d |........|........|
|00005ff0| 22 41 64 76 61 6e 63 65 | 64 2e 2e 2e 22 00 00 00 |"Advance|d..."...|
|00006000| 00 00 00 00 00 00 00 00 | 00 00 00 00 01 00 00 00 |........|........|
|00006010| 08 52 45 4c 53 45 4c 45 | 43 00 00 00 00 00 00 00 |.RELSELE|C.......|
|00006020| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 01 00 00 |........|........|
|00006030| 00 16 22 4f 70 74 69 6f | 6e 73 20 66 6f 72 20 26 |.."Optio|ns for &|
|00006040| 74 68 69 73 64 62 66 22 | 00 00 00 00 00 00 01 00 |thisdbf"|........|
|00006050| 00 00 06 47 65 6e 65 76 | 61 00 00 00 00 00 00 00 |...Genev|a.......|
|00006060| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 01 |........|........|
|00006070| 00 00 00 c5 49 46 20 45 | 4d 50 54 59 28 6d 2e 70 |....IF E|MPTY(m.p|
|00006080| 61 72 65 6e 74 66 6c 64 | 29 20 3b 0d 0a 20 20 20 |arentfld|) ;..   |
|00006090| 20 20 20 4f 52 20 4c 45 | 46 54 28 6d 2e 70 61 72 |   OR LE|FT(m.par|
|000060a0| 65 6e 74 66 6c 64 2c 31 | 29 20 3d 20 27 5c 27 20 |entfld,1|) = '\' |
|000060b0| 3b 0d 0a 20 20 20 20 20 | 20 4f 52 20 28 67 65 74 |;..     | OR (get|
|000060c0| 74 79 70 65 28 6d 2e 70 | 61 72 65 6e 74 66 6c 64 |type(m.p|arentfld|
|000060d0| 29 20 21 3d 20 67 65 74 | 74 79 70 65 28 6d 2e 63 |) != get|type(m.c|
|000060e0| 68 69 6c 64 66 6c 64 29 | 29 0d 0a 20 20 20 53 48 |hildfld)|)..   SH|
|000060f0| 4f 57 20 47 45 54 20 6d | 2e 6f 6b 63 61 6e 63 6c |OW GET m|.okcancl|
|00006100| 2c 31 20 44 49 53 41 42 | 4c 45 0d 0a 45 4c 53 45 |,1 DISAB|LE..ELSE|
|00006110| 0d 0a 20 20 20 53 48 4f | 57 20 47 45 54 20 6d 2e |..   SHO|W GET m.|
|00006120| 6f 6b 63 61 6e 63 6c 2c | 31 20 45 4e 41 42 4c 45 |okcancl,|1 ENABLE|
|00006130| 0d 0a 45 4e 44 49 46 0d | 0a 00 00 00 00 00 00 00 |..ENDIF.|........|
|00006140| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00006150| 00 00 00 00 00 00 01 00 | 00 06 e7 0d 0a 2a 21 2a |........|.....*!*|
|00006160| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00006170| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00006180| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00006190| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|000061a0| 0d 0a 2a 21 0d 0a 2a 21 | 20 20 20 20 20 20 50 72 |..*!..*!|      Pr|
|000061b0| 6f 63 65 64 75 72 65 3a | 20 41 44 44 54 59 50 45 |ocedure:| ADDTYPE|
|000061c0| 0d 0a 2a 21 0d 0a 2a 21 | 2a 2a 2a 2a 2a 2a 2a 2a |..*!..*!|********|
|000061d0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|000061e0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|000061f0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00006200| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 0d 0a 46 55 4e 43 54 |********|*..FUNCT|
|00006210| 49 4f 4e 20 61 64 64 74 | 79 70 65 0d 0a 2a 20 41 |ION addt|ype..* A|
|00006220| 64 64 20 74 68 65 20 64 | 61 74 61 20 74 79 70 65 |dd the d|ata type|
|00006230| 20 74 6f 20 61 20 66 69 | 65 6c 64 20 6e 61 6d 65 | to a fi|eld name|
|00006240| 0d 0a 50 41 52 41 4d 45 | 54 45 52 20 66 6c 64 6e |..PARAME|TER fldn|
|00006250| 61 6d 65 0d 0a 0d 0a 49 | 46 20 21 45 4d 50 54 59 |ame....I|F !EMPTY|
|00006260| 28 6d 2e 66 6c 64 6e 61 | 6d 65 29 0d 0a 20 20 20 |(m.fldna|me)..   |
|00006270| 52 45 54 55 52 4e 20 50 | 41 44 52 28 6d 2e 66 6c |RETURN P|ADR(m.fl|
|00006280| 64 6e 61 6d 65 2c 32 30 | 29 20 2b 20 27 28 27 20 |dname,20|) + '(' |
|00006290| 2b 20 54 59 50 45 28 6d | 2e 66 6c 64 6e 61 6d 65 |+ TYPE(m|.fldname|
|000062a0| 29 20 2b 20 27 29 27 0d | 0a 45 4c 53 45 0d 0a 20 |) + ')'.|.ELSE.. |
|000062b0| 20 20 52 45 54 55 52 4e | 20 27 27 0d 0a 45 4e 44 |  RETURN| ''..END|
|000062c0| 49 46 0d 0a 0d 0a 0d 0a | 2a 21 2a 2a 2a 2a 2a 2a |IF......|*!******|
|000062d0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|000062e0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|000062f0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00006300| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 0d 0a 2a 21 0d |********|***..*!.|
|00006310| 0a 2a 21 20 20 20 20 20 | 20 50 72 6f 63 65 64 75 |.*!     | Procedu|
|00006320| 72 65 3a 20 47 45 54 54 | 59 50 45 0d 0a 2a 21 0d |re: GETT|YPE..*!.|
|00006330| 0a 2a 21 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |.*!*****|********|
|00006340| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00006350| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00006360| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00006370| 2a 2a 2a 2a 0d 0a 46 55 | 4e 43 54 49 4f 4e 20 67 |****..FU|NCTION g|
|00006380| 65 74 74 79 70 65 0d 0a | 50 41 52 41 4d 45 54 45 |ettype..|PARAMETE|
|00006390| 52 20 6d 2e 66 6c 64 6e | 61 6d 65 0d 0a 50 52 49 |R m.fldn|ame..PRI|
|000063a0| 56 41 54 45 20 6d 2e 72 | 65 74 76 61 6c 0d 0a 2a |VATE m.r|etval..*|
|000063b0| 20 54 68 69 73 20 66 75 | 6e 63 74 69 6f 6e 20 65 | This fu|nction e|
|000063c0| 78 74 72 61 63 74 73 20 | 74 68 65 20 64 61 74 61 |xtracts |the data|
|000063d0| 20 74 79 70 65 20 66 72 | 6f 6d 20 74 68 65 20 66 | type fr|om the f|
|000063e0| 6f 72 6d 61 74 20 75 73 | 65 64 20 69 6e 0d 0a 2a |ormat us|ed in..*|
|000063f0| 20 74 68 65 20 70 61 72 | 65 6e 74 6c 69 73 74 20 | the par|entlist |
+--------+-------------------------+-------------------------+--------+--------+
Only 25.0 KB of data is shown above.