home *** CD-ROM | disk | FTP | other *** search
| Unknown | 1994-02-02 | 31.5 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, 978 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 d2 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 | 16 22 4f 70 74 69 6f 6e |........|."Option|
|00000240| 73 20 66 6f 72 20 26 74 | 68 69 73 64 62 66 22 00 |s for &t|hisdbf".|
|00000250| 00 00 00 00 00 01 00 00 | 00 c5 49 46 20 45 4d 50 |........|..IF EMP|
|00000260| 54 59 28 6d 2e 70 61 72 | 65 6e 74 66 6c 64 29 20 |TY(m.par|entfld) |
|00000270| 3b 0d 0a 20 20 20 20 20 | 20 4f 52 20 4c 45 46 54 |;.. | OR LEFT|
|00000280| 28 6d 2e 70 61 72 65 6e | 74 66 6c 64 2c 31 29 20 |(m.paren|tfld,1) |
|00000290| 3d 20 27 5c 27 20 3b 0d | 0a 20 20 20 20 20 20 4f |= '\' ;.|. O|
|000002a0| 52 20 28 67 65 74 74 79 | 70 65 28 6d 2e 70 61 72 |R (getty|pe(m.par|
|000002b0| 65 6e 74 66 6c 64 29 20 | 21 3d 20 67 65 74 74 79 |entfld) |!= getty|
|000002c0| 70 65 28 6d 2e 63 68 69 | 6c 64 66 6c 64 29 29 0d |pe(m.chi|ldfld)).|
|000002d0| 0a 20 20 20 53 48 4f 57 | 20 47 45 54 20 6d 2e 6f |. SHOW| GET m.o|
|000002e0| 6b 63 61 6e 63 6c 2c 31 | 20 44 49 53 41 42 4c 45 |kcancl,1| DISABLE|
|000002f0| 0d 0a 45 4c 53 45 0d 0a | 20 20 20 53 48 4f 57 20 |..ELSE..| SHOW |
|00000300| 47 45 54 20 6d 2e 6f 6b | 63 61 6e 63 6c 2c 31 20 |GET m.ok|cancl,1 |
|00000310| 45 4e 41 42 4c 45 0d 0a | 45 4e 44 49 46 0d 0a 00 |ENABLE..|ENDIF...|
|00000320| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000330| 00 00 00 00 00 00 00 00 | 00 00 00 00 01 00 00 0d |........|........|
|00000340| 44 23 54 52 41 4e 20 53 | 4e 49 50 50 45 54 20 4f |D#TRAN S|NIPPET O|
|00000350| 4e 4c 59 0d 0a 23 53 45 | 43 54 49 4f 4e 20 31 0d |NLY..#SE|CTION 1.|
|00000360| 0a 50 41 52 41 4d 45 54 | 45 52 53 20 6d 2e 63 68 |.PARAMET|ERS m.ch|
|00000370| 69 6c 64 73 74 65 6d 2c | 20 6d 2e 63 68 69 6c 64 |ildstem,| m.child|
|00000380| 64 62 66 2c 20 6d 2e 63 | 68 69 6c 64 66 6c 64 2c |dbf, m.c|hildfld,|
|00000390| 20 6d 2e 70 61 72 65 6e | 74 66 6c 64 2c 20 6d 2e | m.paren|tfld, m.|
|000003a0| 69 67 6e 63 61 73 65 2c | 20 3b 0d 0a 20 20 20 6d |igncase,| ;.. m|
|000003b0| 2e 72 65 6c 73 74 72 2c | 20 6d 2e 70 61 72 65 6e |.relstr,| m.paren|
|000003c0| 74 64 62 66 2c 20 6d 2e | 61 64 64 6d 6f 64 65 0d |tdbf, m.|addmode.|
|000003d0| 0a 0d 0a 50 52 49 56 41 | 54 45 20 6d 2e 69 67 6e |...PRIVA|TE m.ign|
|000003e0| 63 61 73 65 2c 20 6d 2e | 61 64 64 6d 6f 64 65 2c |case, m.|addmode,|
|000003f0| 20 6d 2e 69 2c 20 6d 2e | 6a 2c 20 6d 2e 61 6c 5f | m.i, m.|j, m.al_|
|00000400| 6e 61 6d 65 2c 20 6d 2e | 74 68 69 73 64 62 66 2c |name, m.|thisdbf,|
|00000410| 20 6d 2e 64 6f 6e 65 2c | 20 6d 2e 69 6e 5f 61 72 | m.done,| m.in_ar|
|00000420| 65 61 0d 0a 0d 0a 2a 20 | 41 73 73 65 6d 62 6c 65 |ea....* |Assemble|
|00000430| 20 73 74 72 69 6e 67 20 | 66 6f 72 20 64 69 61 6c | string |for dial|
|00000440| 6f 67 20 74 69 74 6c 65 | 0d 0a 6d 2e 74 68 69 73 |og title|..m.this|
|00000450| 64 62 66 20 3d 20 6a 75 | 73 74 66 6e 61 6d 65 28 |dbf = ju|stfname(|
|00000460| 6d 2e 63 68 69 6c 64 64 | 62 66 29 0d 0a 0d 0a 2a |m.childd|bf)....*|
|00000470| 20 61 64 64 6d 6f 64 65 | 20 64 65 74 65 72 6d 69 | addmode| determi|
|00000480| 6e 65 73 20 69 66 20 77 | 65 20 61 72 65 20 61 64 |nes if w|e are ad|
|00000490| 64 69 6e 67 20 61 20 6e | 65 77 20 72 65 6c 61 74 |ding a n|ew relat|
|000004a0| 69 6f 6e 73 68 69 70 20 | 6f 72 20 65 64 69 74 69 |ionship |or editi|
|000004b0| 6e 67 0d 0a 2a 20 61 6e | 20 65 78 69 73 69 6e 67 |ng..* an| exising|
|000004c0| 20 6f 6e 65 0d 0a 0d 0a | 2a 20 53 74 61 72 74 20 | one....|* Start |
|000004d0| 77 69 74 68 20 6e 65 77 | 20 63 6f 70 69 65 73 20 |with new| copies |
|000004e0| 6f 66 20 74 68 65 20 6c | 69 73 74 20 61 72 72 61 |of the l|ist arra|
|000004f0| 79 73 20 61 6e 64 20 72 | 65 6c 65 61 73 65 20 61 |ys and r|elease a|
|00000500| 6e 79 20 74 68 61 74 20 | 0d 0a 2a 20 61 6c 72 65 |ny that |..* alre|
|00000510| 61 64 79 20 65 78 69 73 | 74 0d 0a 52 45 4c 45 41 |ady exis|t..RELEA|
|00000520| 53 45 20 63 68 69 6c 64 | 6c 69 73 74 2c 20 70 61 |SE child|list, pa|
|00000530| 72 65 6e 74 6c 69 73 74 | 0d 0a 0d 0a 23 53 45 43 |rentlist|....#SEC|
|00000540| 54 49 4f 4e 20 32 0d 0a | 0d 0a 6d 2e 69 6e 5f 61 |TION 2..|..m.in_a|
|00000550| 72 65 61 20 3d 20 53 45 | 4c 45 43 54 28 29 0d 0a |rea = SE|LECT()..|
|00000560| 0d 0a 2a 20 4d 61 6b 65 | 20 73 75 72 65 20 63 68 |..* Make| sure ch|
|00000570| 69 6c 64 20 64 61 74 61 | 62 61 73 65 20 65 78 69 |ild data|base exi|
|00000580| 73 74 73 0d 0a 49 46 20 | 21 46 49 4c 45 28 6d 2e |sts..IF |!FILE(m.|
|00000590| 63 68 69 6c 64 64 62 66 | 29 0d 0a 20 20 20 6d 2e |childdbf|).. m.|
|000005a0| 63 68 69 6c 64 64 62 66 | 20 3d 20 47 45 54 46 49 |childdbf| = GETFI|
|000005b0| 4c 45 28 27 44 42 46 27 | 2c 27 50 6c 65 61 73 65 |LE('DBF'|,'Please|
|000005c0| 20 6c 6f 63 61 74 65 20 | 74 68 65 20 27 2b 6a 75 | locate |the '+ju|
|000005d0| 73 74 73 74 65 6d 28 6d | 2e 63 68 69 6c 64 64 62 |ststem(m|.childdb|
|000005e0| 66 29 2b 27 20 64 61 74 | 61 62 61 73 65 27 29 0d |f)+' dat|abase').|
|000005f0| 0a 45 4e 44 49 46 0d 0a | 49 46 20 45 4d 50 54 59 |.ENDIF..|IF EMPTY|
|00000600| 28 6d 2e 63 68 69 6c 64 | 64 62 66 29 20 4f 52 20 |(m.child|dbf) OR |
|00000610| 21 46 49 4c 45 28 6d 2e | 63 68 69 6c 64 64 62 66 |!FILE(m.|childdbf|
|00000620| 29 0d 0a 20 20 20 6d 2e | 63 68 69 6c 64 64 62 66 |).. m.|childdbf|
|00000630| 20 3d 20 27 27 0d 0a 20 | 20 20 52 45 54 55 52 4e | = ''.. | RETURN|
|00000640| 0d 0a 45 4e 44 49 46 0d | 0a 0d 0a 0d 0a 2a 20 46 |..ENDIF.|.....* F|
|00000650| 69 6c 6c 20 69 6e 20 74 | 68 65 20 70 61 72 65 6e |ill in t|he paren|
|00000660| 74 6c 69 73 74 20 77 69 | 74 68 20 74 68 65 20 6e |tlist wi|th the n|
|00000670| 61 6d 65 73 20 6f 66 20 | 61 6c 6c 20 66 69 65 6c |ames of |all fiel|
|00000680| 64 73 0d 0a 2a 20 20 20 | 69 6e 20 61 6c 6c 20 6f |ds..* |in all o|
|00000690| 70 65 6e 20 64 61 74 61 | 62 61 73 65 73 0d 0a 6d |pen data|bases..m|
|000006a0| 2e 70 61 72 65 6e 74 72 | 6f 77 20 3d 20 30 0d 0a |.parentr|ow = 0..|
|000006b0| 44 49 4d 45 4e 53 49 4f | 4e 20 70 61 72 65 6e 74 |DIMENSIO|N parent|
|000006c0| 6c 69 73 74 5b 31 5d 0d | 0a 70 61 72 65 6e 74 6c |list[1].|.parentl|
|000006d0| 69 73 74 5b 31 5d 20 3d | 20 22 22 0d 0a 46 4f 52 |ist[1] =| ""..FOR|
|000006e0| 20 6d 2e 69 20 3d 20 31 | 20 54 4f 20 32 35 0d 0a | m.i = 1| TO 25..|
|000006f0| 20 20 20 53 45 4c 45 43 | 54 20 28 6d 2e 69 29 0d | SELEC|T (m.i).|
|00000700| 0a 20 20 20 49 46 20 21 | 45 4d 50 54 59 28 44 42 |. IF !|EMPTY(DB|
|00000710| 46 28 6d 2e 69 29 29 20 | 41 4e 44 20 6d 61 6b 65 |F(m.i)) |AND make|
|00000720| 61 6c 69 61 73 28 6a 75 | 73 74 73 74 65 6d 28 44 |alias(ju|ststem(D|
|00000730| 42 46 28 6d 2e 69 29 29 | 29 20 3c 3e 20 6d 61 6b |BF(m.i))|) <> mak|
|00000740| 65 61 6c 69 61 73 28 6a | 75 73 74 73 74 65 6d 28 |ealias(j|uststem(|
|00000750| 6d 2e 63 68 69 6c 64 73 | 74 65 6d 29 29 0d 0a 20 |m.childs|tem)).. |
|00000760| 20 20 20 20 20 46 4f 52 | 20 6d 2e 6a 20 3d 20 31 | FOR| m.j = 1|
|00000770| 20 54 4f 20 46 43 4f 55 | 4e 54 28 6d 2e 69 29 0d | TO FCOU|NT(m.i).|
|00000780| 0a 20 20 20 20 20 20 20 | 20 20 6d 2e 70 61 72 65 |. | m.pare|
|00000790| 6e 74 72 6f 77 20 3d 20 | 6d 2e 70 61 72 65 6e 74 |ntrow = |m.parent|
|000007a0| 72 6f 77 20 2b 20 31 0d | 0a 20 20 20 20 20 20 20 |row + 1.|. |
|000007b0| 20 20 44 49 4d 45 4e 53 | 49 4f 4e 20 70 61 72 65 | DIMENS|ION pare|
|000007c0| 6e 74 6c 69 73 74 5b 6d | 2e 70 61 72 65 6e 74 72 |ntlist[m|.parentr|
|000007d0| 6f 77 5d 0d 0a 20 20 20 | 20 20 20 20 20 20 70 61 |ow].. | pa|
|000007e0| 72 65 6e 74 6c 69 73 74 | 5b 6d 2e 70 61 72 65 6e |rentlist|[m.paren|
|000007f0| 74 72 6f 77 5d 20 3d 20 | 61 64 64 74 79 70 65 28 |trow] = |addtype(|
|00000800| 41 4c 49 41 53 28 6d 2e | 69 29 2b 27 2e 27 2b 46 |ALIAS(m.|i)+'.'+F|
|00000810| 49 45 4c 44 28 6d 2e 6a | 2c 6d 2e 69 29 29 0d 0a |IELD(m.j|,m.i))..|
|00000820| 20 20 20 20 20 20 45 4e | 44 46 4f 52 0d 0a 20 20 | EN|DFOR.. |
|00000830| 20 45 4e 44 49 46 0d 0a | 45 4e 44 46 4f 52 0d 0a | ENDIF..|ENDFOR..|
|00000840| 0d 0a 0d 0a 2a 20 46 69 | 6c 6c 20 69 6e 20 74 68 |....* Fi|ll in th|
|00000850| 65 20 63 68 69 6c 64 6c | 69 73 74 20 77 69 74 68 |e childl|ist with|
|00000860| 20 74 68 65 20 6e 61 6d | 65 73 20 6f 66 20 61 6c | the nam|es of al|
|00000870| 6c 20 66 69 65 6c 64 73 | 0d 0a 2a 20 20 20 69 6e |l fields|..* in|
|00000880| 20 74 68 65 20 63 68 69 | 6c 64 20 64 61 74 61 62 | the chi|ld datab|
|00000890| 61 73 65 0d 0a 6d 2e 63 | 68 69 6c 64 72 6f 77 20 |ase..m.c|hildrow |
|000008a0| 3d 20 30 0d 0a 44 49 4d | 45 4e 53 49 4f 4e 20 63 |= 0..DIM|ENSION c|
|000008b0| 68 69 6c 64 6c 69 73 74 | 5b 31 5d 0d 0a 63 68 69 |hildlist|[1]..chi|
|000008c0| 6c 64 6c 69 73 74 28 31 | 29 20 3d 20 22 22 0d 0a |ldlist(1|) = ""..|
|000008d0| 49 46 20 55 53 45 44 28 | 6d 61 6b 65 61 6c 69 61 |IF USED(|makealia|
|000008e0| 73 28 6d 2e 63 68 69 6c | 64 73 74 65 6d 29 29 0d |s(m.chil|dstem)).|
|000008f0| 0a 20 20 20 6d 2e 61 6c | 5f 6e 61 6d 65 20 3d 20 |. m.al|_name = |
|00000900| 6d 61 6b 65 61 6c 69 61 | 73 28 6d 2e 63 68 69 6c |makealia|s(m.chil|
|00000910| 64 73 74 65 6d 29 0d 0a | 20 20 20 53 45 4c 45 43 |dstem)..| SELEC|
|00000920| 54 20 28 6d 2e 61 6c 5f | 6e 61 6d 65 29 0d 0a 45 |T (m.al_|name)..E|
|00000930| 4c 53 45 0d 0a 20 20 20 | 53 45 4c 45 43 54 20 30 |LSE.. |SELECT 0|
|00000940| 0d 0a 20 20 20 55 53 45 | 20 28 6d 2e 63 68 69 6c |.. USE| (m.chil|
|00000950| 64 64 62 66 29 0d 0a 45 | 4e 44 49 46 0d 0a 46 4f |ddbf)..E|NDIF..FO|
|00000960| 52 20 6d 2e 6a 20 3d 20 | 31 20 54 4f 20 46 43 4f |R m.j = |1 TO FCO|
|00000970| 55 4e 54 28 29 0d 0a 20 | 20 20 49 46 20 54 59 50 |UNT().. | IF TYP|
|00000980| 45 28 46 49 45 4c 44 28 | 6d 2e 6a 29 29 20 3c 3e |E(FIELD(|m.j)) <>|
|00000990| 20 22 4d 22 0d 0a 20 20 | 20 20 20 20 6d 2e 63 68 | "M".. | m.ch|
|000009a0| 69 6c 64 72 6f 77 20 3d | 20 6d 2e 63 68 69 6c 64 |ildrow =| m.child|
|000009b0| 72 6f 77 20 2b 20 31 0d | 0a 20 20 20 20 20 20 44 |row + 1.|. D|
|000009c0| 49 4d 45 4e 53 49 4f 4e | 20 63 68 69 6c 64 6c 69 |IMENSION| childli|
|000009d0| 73 74 5b 6d 2e 63 68 69 | 6c 64 72 6f 77 5d 0d 0a |st[m.chi|ldrow]..|
|000009e0| 20 20 20 20 20 20 63 68 | 69 6c 64 6c 69 73 74 5b | ch|ildlist[|
|000009f0| 6d 2e 63 68 69 6c 64 72 | 6f 77 5d 20 3d 20 61 64 |m.childr|ow] = ad|
|00000a00| 64 74 79 70 65 28 41 4c | 49 41 53 28 29 2b 27 2e |dtype(AL|IAS()+'.|
|00000a10| 27 2b 46 49 45 4c 44 28 | 6d 2e 6a 29 29 0d 0a 20 |'+FIELD(|m.j)).. |
|00000a20| 20 20 45 4e 44 49 46 0d | 0a 45 4e 44 46 4f 52 0d | ENDIF.|.ENDFOR.|
|00000a30| 0a 0d 0a 2a 20 50 6f 73 | 69 74 69 6f 6e 20 73 65 |...* Pos|ition se|
|00000a40| 6c 65 63 74 69 6f 6e 20 | 62 61 72 73 20 6f 6e 74 |lection |bars ont|
|00000a50| 6f 20 69 6e 74 65 6c 6c | 69 67 65 6e 74 20 64 65 |o intell|igent de|
|00000a60| 66 61 75 6c 74 73 2e 20 | 20 54 72 79 20 74 6f 20 |faults. | Try to |
|00000a70| 6d 61 74 63 68 0d 0a 2a | 20 66 69 65 6c 64 20 6e |match..*| field n|
|00000a80| 61 6d 65 73 20 62 65 74 | 77 65 65 6e 20 74 68 65 |ames bet|ween the|
|00000a90| 20 70 61 72 65 6e 74 20 | 61 6e 64 20 63 68 69 6c | parent |and chil|
|00000aa0| 64 20 64 61 74 61 62 61 | 73 65 73 2e 0d 0a 6d 2e |d databa|ses...m.|
|00000ab0| 64 6f 6e 65 20 3d 20 2e | 46 2e 0d 0a 49 46 20 45 |done = .|F...IF E|
|00000ac0| 4d 50 54 59 28 6d 2e 70 | 61 72 65 6e 74 66 6c 64 |MPTY(m.p|arentfld|
|00000ad0| 29 0d 0a 20 20 20 49 46 | 20 45 4d 50 54 59 28 6d |).. IF| EMPTY(m|
|00000ae0| 2e 63 68 69 6c 64 66 6c | 64 29 0d 0a 20 20 20 20 |.childfl|d).. |
|00000af0| 20 20 2a 20 53 65 65 20 | 69 66 20 74 68 65 72 65 | * See |if there|
|00000b00| 20 61 72 65 20 61 6e 79 | 20 66 69 65 6c 64 73 20 | are any| fields |
|00000b10| 69 6e 20 74 68 65 20 70 | 61 72 65 6e 74 20 64 61 |in the p|arent da|
|00000b20| 74 61 62 61 73 65 20 77 | 69 74 68 0d 0a 20 20 20 |tabase w|ith.. |
|00000b30| 20 20 20 2a 20 74 68 65 | 20 73 61 6d 65 20 6e 61 | * the| same na|
|00000b40| 6d 65 20 61 6e 64 20 74 | 79 70 65 20 61 73 20 61 |me and t|ype as a|
|00000b50| 20 66 69 65 6c 64 20 69 | 6e 20 74 68 65 20 63 68 | field i|n the ch|
|00000b60| 69 6c 64 20 64 61 74 61 | 62 61 73 65 0d 0a 20 20 |ild data|base.. |
|00000b70| 20 20 20 20 6d 2e 69 20 | 3d 20 31 0d 0a 20 20 20 | m.i |= 1.. |
|00000b80| 20 20 20 44 4f 20 57 48 | 49 4c 45 20 21 64 6f 6e | DO WH|ILE !don|
|00000b90| 65 20 41 4e 44 20 6d 2e | 69 20 3c 3d 20 6d 2e 63 |e AND m.|i <= m.c|
|00000ba0| 68 69 6c 64 72 6f 77 0d | 0a 20 20 20 20 20 20 20 |hildrow.|. |
|00000bb0| 20 20 6d 2e 6e 65 77 63 | 68 69 6c 64 20 20 3d 20 | m.newc|hild = |
|00000bc0| 53 55 42 53 54 52 28 63 | 68 69 6c 64 6c 69 73 74 |SUBSTR(c|hildlist|
|00000bd0| 5b 6d 2e 69 5d 2c 41 54 | 28 27 2e 27 2c 63 68 69 |[m.i],AT|('.',chi|
|00000be0| 6c 64 6c 69 73 74 5b 6d | 2e 69 5d 29 2b 31 29 0d |ldlist[m|.i])+1).|
|00000bf0| 0a 20 20 20 20 20 20 20 | 20 20 6d 2e 6e 65 77 63 |. | m.newc|
|00000c00| 68 69 6c 64 20 20 3d 20 | 43 48 52 54 52 41 4e 28 |hild = |CHRTRAN(|
|00000c10| 6d 2e 6e 65 77 63 68 69 | 6c 64 2c 27 20 27 2c 27 |m.newchi|ld,' ','|
|00000c20| 27 29 0d 0a 20 20 20 20 | 20 20 20 20 20 6d 2e 6a |').. | m.j|
|00000c30| 20 3d 20 31 0d 0a 20 20 | 20 20 20 20 20 20 20 44 | = 1.. | D|
|00000c40| 4f 20 57 48 49 4c 45 20 | 21 6d 2e 64 6f 6e 65 20 |O WHILE |!m.done |
|00000c50| 41 4e 44 20 6d 2e 6a 20 | 3c 3d 20 6d 2e 70 61 72 |AND m.j |<= m.par|
|00000c60| 65 6e 74 72 6f 77 0d 0a | 20 20 20 20 20 20 20 20 |entrow..| |
|00000c70| 20 20 20 20 2a 20 41 73 | 73 65 6d 62 6c 65 20 61 | * As|semble a|
|00000c80| 20 6e 65 77 20 6e 61 6d | 65 20 62 61 73 65 64 20 | new nam|e based |
|00000c90| 6f 6e 20 74 68 65 20 66 | 69 65 6c 64 20 6e 61 6d |on the f|ield nam|
|00000ca0| 65 20 61 6e 64 20 74 68 | 65 20 66 69 65 6c 64 20 |e and th|e field |
|00000cb0| 74 79 70 65 0d 0a 20 20 | 20 20 20 20 20 20 20 20 |type.. | |
|00000cc0| 20 20 2a 20 54 68 65 20 | 70 61 72 65 6e 74 6c 69 | * The |parentli|
|00000cd0| 73 74 20 72 65 63 6f 72 | 64 73 20 6c 6f 6f 6b 20 |st recor|ds look |
|00000ce0| 6c 69 6b 65 20 74 68 69 | 73 3a 0d 0a 20 20 20 20 |like thi|s:.. |
|00000cf0| 20 20 20 20 20 20 20 20 | 2a 20 20 20 20 61 6c 69 | |* ali|
|00000d00| 61 73 2e 66 6c 64 20 20 | 20 20 20 20 20 28 4e 29 |as.fld | (N)|
|00000d10| 0d 0a 20 20 20 20 20 20 | 20 20 20 20 20 20 2a 20 |.. | * |
|00000d20| 22 4e 65 77 70 61 72 65 | 6e 74 22 20 6e 6f 77 20 |"Newpare|nt" now |
|00000d30| 6c 6f 6f 6b 73 20 6c 69 | 6b 65 20 74 68 69 73 3a |looks li|ke this:|
|00000d40| 0d 0a 20 20 20 20 20 20 | 20 20 20 20 20 20 2a 20 |.. | * |
|00000d50| 20 20 20 20 66 6c 64 28 | 4e 29 0d 0a 20 20 20 20 | fld(|N).. |
|00000d60| 20 20 20 20 20 20 20 20 | 6d 2e 6e 65 77 70 61 72 | |m.newpar|
|00000d70| 65 6e 74 20 3d 20 53 55 | 42 53 54 52 28 70 61 72 |ent = SU|BSTR(par|
|00000d80| 65 6e 74 6c 69 73 74 5b | 6d 2e 6a 5d 2c 41 54 28 |entlist[|m.j],AT(|
|00000d90| 27 2e 27 2c 70 61 72 65 | 6e 74 6c 69 73 74 5b 6d |'.',pare|ntlist[m|
|00000da0| 2e 6a 5d 29 2b 31 29 0d | 0a 20 20 20 20 20 20 20 |.j])+1).|. |
|00000db0| 20 20 20 20 20 6d 2e 6e | 65 77 70 61 72 65 6e 74 | m.n|ewparent|
|00000dc0| 20 3d 20 43 48 52 54 52 | 41 4e 28 6e 65 77 70 61 | = CHRTR|AN(newpa|
|00000dd0| 72 65 6e 74 2c 27 20 27 | 2c 27 27 29 0d 0a 0d 0a |rent,' '|,'')....|
|00000de0| 20 20 20 20 20 20 20 20 | 20 20 20 20 49 46 20 6d | | IF m|
|00000df0| 2e 6e 65 77 70 61 72 65 | 6e 74 20 3d 3d 20 6d 2e |.newpare|nt == m.|
|00000e00| 6e 65 77 63 68 69 6c 64 | 0d 0a 20 20 20 20 20 20 |newchild|.. |
|00000e10| 20 20 20 20 20 20 20 20 | 20 6d 2e 70 61 72 65 6e | | m.paren|
|00000e20| 74 66 6c 64 20 3d 20 70 | 61 72 65 6e 74 6c 69 73 |tfld = p|arentlis|
|00000e30| 74 5b 6d 2e 6a 5d 0d 0a | 20 20 20 20 20 20 20 20 |t[m.j]..| |
|00000e40| 20 20 20 20 20 20 20 6d | 2e 63 68 69 6c 64 66 6c | m|.childfl|
|00000e50| 64 20 20 3d 20 63 68 69 | 6c 64 6c 69 73 74 5b 6d |d = chi|ldlist[m|
|00000e60| 2e 69 5d 0d 0a 20 20 20 | 20 20 20 20 20 20 20 20 |.i].. | |
|00000e70| 20 20 20 20 6d 2e 64 6f | 6e 65 20 3d 20 2e 54 2e | m.do|ne = .T.|
|00000e80| 0d 0a 20 20 20 20 20 20 | 20 20 20 20 20 20 45 4e |.. | EN|
|00000e90| 44 49 46 0d 0a 20 20 20 | 20 20 20 20 20 20 20 20 |DIF.. | |
|00000ea0| 20 6d 2e 6a 20 3d 20 6d | 2e 6a 20 2b 20 31 0d 0a | m.j = m|.j + 1..|
|00000eb0| 20 20 20 20 20 20 20 20 | 20 45 4e 44 44 4f 0d 0a | | ENDDO..|
|00000ec0| 20 20 20 20 20 20 20 20 | 20 6d 2e 69 20 3d 20 6d | | m.i = m|
|00000ed0| 2e 69 20 2b 20 31 0d 0a | 20 20 20 20 20 20 45 4e |.i + 1..| EN|
|00000ee0| 44 44 4f 0d 0a 0d 0a 20 | 20 20 20 20 20 49 46 20 |DDO.... | IF |
|00000ef0| 21 6d 2e 64 6f 6e 65 20 | 20 20 20 26 26 20 6e 6f |!m.done | && no|
|00000f00| 20 6d 61 74 63 68 65 73 | 20 66 6f 75 6e 64 2e 20 | matches| found. |
|00000f10| 20 44 65 66 61 75 6c 74 | 20 74 6f 20 66 69 72 73 | Default| to firs|
|00000f20| 74 20 66 69 65 6c 64 2e | 0d 0a 20 20 20 20 20 20 |t field.|.. |
|00000f30| 20 20 20 6d 2e 63 68 69 | 6c 64 66 6c 64 20 20 20 | m.chi|ldfld |
|00000f40| 3d 20 63 68 69 6c 64 6c | 69 73 74 5b 31 5d 0d 0a |= childl|ist[1]..|
|00000f50| 20 20 20 20 20 20 45 4e | 44 49 46 0d 0a 20 20 20 | EN|DIF.. |
|00000f60| 45 4c 53 45 0d 0a 20 20 | 20 20 20 20 2a 20 44 65 |ELSE.. | * De|
|00000f70| 66 61 75 6c 74 20 74 6f | 20 74 68 65 20 66 69 72 |fault to| the fir|
|00000f80| 73 74 20 66 69 65 6c 64 | 20 0d 0a 20 20 20 20 20 |st field| .. |
|00000f90| 20 6d 2e 70 61 72 65 6e | 74 66 6c 64 20 20 3d 20 | m.paren|tfld = |
|00000fa0| 70 61 72 65 6e 74 6c 69 | 73 74 5b 31 5d 0d 0a 20 |parentli|st[1].. |
|00000fb0| 20 20 20 20 20 6d 2e 63 | 68 69 6c 64 66 6c 64 20 | m.c|hildfld |
|00000fc0| 20 20 3d 20 61 64 64 74 | 79 70 65 28 6d 2e 63 68 | = addt|ype(m.ch|
|00000fd0| 69 6c 64 66 6c 64 29 0d | 0a 20 20 20 45 4e 44 49 |ildfld).|. ENDI|
|00000fe0| 46 0d 0a 45 4c 53 45 0d | 0a 20 20 20 6d 2e 70 61 |F..ELSE.|. m.pa|
|00000ff0| 72 65 6e 74 66 6c 64 20 | 20 3d 20 61 64 64 74 79 |rentfld | = addty|
|00001000| 70 65 28 6d 2e 70 61 72 | 65 6e 74 66 6c 64 29 0d |pe(m.par|entfld).|
|00001010| 0a 20 20 20 6d 2e 63 68 | 69 6c 64 66 6c 64 20 20 |. m.ch|ildfld |
|00001020| 20 3d 20 61 64 64 74 79 | 70 65 28 6d 2e 63 68 69 | = addty|pe(m.chi|
|00001030| 6c 64 66 6c 64 29 0d 0a | 45 4e 44 49 46 0d 0a 0d |ldfld)..|ENDIF...|
|00001040| 0a 44 4f 20 63 64 69 73 | 6c 69 73 74 20 57 49 54 |.DO cdis|list WIT|
|00001050| 48 20 41 53 43 41 4e 28 | 63 68 69 6c 64 6c 69 73 |H ASCAN(|childlis|
|00001060| 74 2c 6d 2e 63 68 69 6c | 64 66 6c 64 29 0d 0a 0d |t,m.chil|dfld)...|
|00001070| 0a 53 45 4c 45 43 54 20 | 28 6d 2e 69 6e 5f 61 72 |.SELECT |(m.in_ar|
|00001080| 65 61 29 0d 0a 00 00 00 | 00 00 00 00 00 00 00 00 |ea).....|........|
|00001090| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000010a0| 00 00 00 00 01 00 00 06 | e7 0d 0a 2a 21 2a 2a 2a |........|...*!***|
|000010b0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|000010c0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|000010d0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|000010e0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 0d 0a |********|******..|
|000010f0| 2a 21 0d 0a 2a 21 20 20 | 20 20 20 20 50 72 6f 63 |*!..*! | Proc|
|00001100| 65 64 75 72 65 3a 20 41 | 44 44 54 59 50 45 0d 0a |edure: A|DDTYPE..|
|00001110| 2a 21 0d 0a 2a 21 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| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00001140| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00001150| 2a 2a 2a 2a 2a 2a 2a 0d | 0a 46 55 4e 43 54 49 4f |*******.|.FUNCTIO|
|00001160| 4e 20 61 64 64 74 79 70 | 65 0d 0a 2a 20 41 64 64 |N addtyp|e..* Add|
|00001170| 20 74 68 65 20 64 61 74 | 61 20 74 79 70 65 20 74 | the dat|a type t|
|00001180| 6f 20 61 20 66 69 65 6c | 64 20 6e 61 6d 65 0d 0a |o a fiel|d name..|
|00001190| 50 41 52 41 4d 45 54 45 | 52 20 66 6c 64 6e 61 6d |PARAMETE|R fldnam|
|000011a0| 65 0d 0a 0d 0a 49 46 20 | 21 45 4d 50 54 59 28 6d |e....IF |!EMPTY(m|
|000011b0| 2e 66 6c 64 6e 61 6d 65 | 29 0d 0a 20 20 20 52 45 |.fldname|).. RE|
|000011c0| 54 55 52 4e 20 50 41 44 | 52 28 6d 2e 66 6c 64 6e |TURN PAD|R(m.fldn|
|000011d0| 61 6d 65 2c 32 30 29 20 | 2b 20 27 28 27 20 2b 20 |ame,20) |+ '(' + |
|000011e0| 54 59 50 45 28 6d 2e 66 | 6c 64 6e 61 6d 65 29 20 |TYPE(m.f|ldname) |
|000011f0| 2b 20 27 29 27 0d 0a 45 | 4c 53 45 0d 0a 20 20 20 |+ ')'..E|LSE.. |
|00001200| 52 45 54 55 52 4e 20 27 | 27 0d 0a 45 4e 44 49 46 |RETURN '|'..ENDIF|
|00001210| 0d 0a 0d 0a 0d 0a 2a 21 | 2a 2a 2a 2a 2a 2a 2a 2a |......*!|********|
|00001220| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00001230| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00001240| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00001250| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 0d 0a 2a 21 0d 0a 2a |********|*..*!..*|
|00001260| 21 20 20 20 20 20 20 50 | 72 6f 63 65 64 75 72 65 |! P|rocedure|
|00001270| 3a 20 47 45 54 54 59 50 | 45 0d 0a 2a 21 0d 0a 2a |: GETTYP|E..*!..*|
|00001280| 21 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 2a 2a 2a 2a 2a |********|********|
|000012a0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|000012b0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|000012c0| 2a 2a 0d 0a 46 55 4e 43 | 54 49 4f 4e 20 67 65 74 |**..FUNC|TION get|
|000012d0| 74 79 70 65 0d 0a 50 41 | 52 41 4d 45 54 45 52 20 |type..PA|RAMETER |
|000012e0| 6d 2e 66 6c 64 6e 61 6d | 65 0d 0a 50 52 49 56 41 |m.fldnam|e..PRIVA|
|000012f0| 54 45 20 6d 2e 72 65 74 | 76 61 6c 0d 0a 2a 20 54 |TE m.ret|val..* T|
|00001300| 68 69 73 20 66 75 6e 63 | 74 69 6f 6e 20 65 78 74 |his func|tion ext|
|00001310| 72 61 63 74 73 20 74 68 | 65 20 64 61 74 61 20 74 |racts th|e data t|
|00001320| 79 70 65 20 66 72 6f 6d | 20 74 68 65 20 66 6f 72 |ype from| the for|
|00001330| 6d 61 74 20 75 73 65 64 | 20 69 6e 0d 0a 2a 20 74 |mat used| in..* t|
|00001340| 68 65 20 70 61 72 65 6e | 74 6c 69 73 74 20 61 6e |he paren|tlist an|
|00001350| 64 20 63 68 69 6c 64 6c | 69 73 74 20 61 72 72 61 |d childl|ist arra|
|00001360| 79 73 2e 20 20 54 68 65 | 20 69 6e 63 6f 6d 69 6e |ys. The| incomin|
|00001370| 67 20 66 6f 72 6d 61 74 | 20 6c 6f 6f 6b 73 0d 0a |g format| looks..|
|00001380| 2a 20 6c 69 6b 65 3a 0d | 0a 2a 20 20 20 20 20 20 |* like:.|.* |
|00001390| 20 20 44 42 46 41 4c 49 | 41 53 2e 46 49 45 4c 44 | DBFALI|AS.FIELD|
|000013a0| 20 20 20 20 20 20 28 43 | 29 0d 0a 2a 0d 0a 2a 20 | (C|)..*..* |
|000013b0| 54 68 65 20 66 75 6e 63 | 74 69 6f 6e 20 72 65 74 |The func|tion ret|
|000013c0| 75 72 6e 73 20 27 43 27 | 0d 0a 0d 0a 6d 2e 72 65 |urns 'C'|....m.re|
|000013d0| 74 76 61 6c 20 3d 20 52 | 49 47 48 54 28 54 52 49 |tval = R|IGHT(TRI|
|000013e0| 4d 28 6d 2e 66 6c 64 6e | 61 6d 65 29 2c 33 29 0d |M(m.fldn|ame),3).|
|000013f0| 0a 6d 2e 72 65 74 76 61 | 6c 20 3d 20 55 50 50 45 |.m.retva|l = UPPE|
|00001400| 52 28 41 4c 4c 54 52 49 | 4d 28 6d 2e 72 65 74 76 |R(ALLTRI|M(m.retv|
|00001410| 61 6c 29 29 0d 0a 52 45 | 54 55 52 4e 20 43 48 52 |al))..RE|TURN CHR|
|00001420| 54 52 41 4e 28 6d 2e 72 | 65 74 76 61 6c 2c 27 28 |TRAN(m.r|etval,'(|
|00001430| 29 27 2c 27 27 29 0d 0a | 0d 0a 2a 21 2a 2a 2a 2a |)','')..|..*!****|
|00001440| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00001450| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00001460| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00001470| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 0d 0a 2a |********|*****..*|
|00001480| 21 0d 0a 2a 21 20 20 20 | 20 20 20 50 72 6f 63 65 |!..*! | Proce|
|00001490| 64 75 72 65 3a 20 43 44 | 49 53 4c 49 53 54 0d 0a |dure: CD|ISLIST..|
|000014a0| 2a 21 0d 0a 2a 21 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 2a |********|********|
|000014c0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|000014d0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|000014e0| 2a 2a 2a 2a 2a 2a 2a 0d | 0a 50 52 4f 43 45 44 55 |*******.|.PROCEDU|
|000014f0| 52 45 20 63 64 69 73 6c | 69 73 74 0d 0a 2a 20 54 |RE cdisl|ist..* T|
|00001500| 68 69 73 20 70 72 6f 63 | 65 64 75 72 65 20 64 69 |his proc|edure di|
|00001510| 73 61 62 6c 65 73 20 66 | 69 65 6c 64 73 20 69 6e |sables f|ields in|
|00001520| 20 74 68 65 20 70 61 72 | 65 6e 74 20 6c 69 73 74 | the par|ent list|
|00001530| 20 74 68 61 74 20 68 61 | 76 65 20 61 20 64 69 66 | that ha|ve a dif|
|00001540| 66 65 72 65 6e 74 0d 0a | 2a 20 74 79 70 65 20 66 |ferent..|* type f|
|00001550| 72 6f 6d 20 74 68 65 20 | 63 75 72 72 65 6e 74 20 |rom the |current |
|00001560| 66 69 65 6c 64 20 69 6e | 20 74 68 65 20 63 68 69 |field in| the chi|
|00001570| 6c 64 20 6c 69 73 74 0d | 0a 0d 0a 50 41 52 41 4d |ld list.|...PARAM|
|00001580| 45 54 45 52 20 63 75 72 | 69 74 65 6d 0d 0a 50 52 |ETER cur|item..PR|
|00001590| 49 56 41 54 45 20 6d 2e | 63 75 72 69 74 65 6d 2c |IVATE m.|curitem,|
|000015a0| 20 6d 2e 73 6f 75 72 63 | 65 74 79 70 65 2c 20 6d | m.sourc|etype, m|
|000015b0| 2e 74 61 72 67 74 79 70 | 65 2c 20 6d 2e 69 0d 0a |.targtyp|e, m.i..|
|000015c0| 0d 0a 49 46 20 6d 2e 63 | 75 72 69 74 65 6d 20 3c |..IF m.c|uritem <|
|000015d0| 3d 20 30 0d 0a 20 20 20 | 6d 2e 63 75 72 69 74 65 |= 0.. |m.curite|
|000015e0| 6d 20 3d 20 31 0d 0a 45 | 4e 44 49 46 0d 0a 0d 0a |m = 1..E|NDIF....|
|000015f0| 6d 2e 73 6f 75 72 63 65 | 74 79 70 65 20 3d 20 67 |m.source|type = g|
|00001600| 65 74 74 79 70 65 28 63 | 68 69 6c 64 6c 69 73 74 |ettype(c|hildlist|
|00001610| 5b 6d 2e 63 75 72 69 74 | 65 6d 5d 29 0d 0a 0d 0a |[m.curit|em])....|
|00001620| 46 4f 52 20 6d 2e 69 20 | 3d 20 31 20 54 4f 20 41 |FOR m.i |= 1 TO A|
|00001630| 4c 45 4e 28 70 61 72 65 | 6e 74 6c 69 73 74 29 0d |LEN(pare|ntlist).|
|00001640| 0a 20 20 20 6d 2e 74 61 | 72 67 74 79 70 65 20 3d |. m.ta|rgtype =|
|00001650| 20 67 65 74 74 79 70 65 | 28 70 61 72 65 6e 74 6c | gettype|(parentl|
|00001660| 69 73 74 5b 6d 2e 69 5d | 29 0d 0a 20 20 20 49 46 |ist[m.i]|).. IF|
|00001670| 20 6d 2e 73 6f 75 72 63 | 65 74 79 70 65 20 3d 3d | m.sourc|etype ==|
|00001680| 20 6d 2e 74 61 72 67 74 | 79 70 65 0d 0a 20 20 20 | m.targt|ype.. |
|00001690| 20 20 20 49 46 20 4c 45 | 46 54 28 70 61 72 65 6e | IF LE|FT(paren|
|000016a0| 74 6c 69 73 74 5b 6d 2e | 69 5d 2c 31 29 20 3d 20 |tlist[m.|i],1) = |
|000016b0| 27 5c 27 0d 0a 20 20 20 | 20 20 20 20 20 20 70 61 |'\'.. | pa|
|000016c0| 72 65 6e 74 6c 69 73 74 | 5b 6d 2e 69 5d 20 3d 20 |rentlist|[m.i] = |
|000016d0| 53 55 42 53 54 52 28 70 | 61 72 65 6e 74 6c 69 73 |SUBSTR(p|arentlis|
|000016e0| 74 5b 6d 2e 69 5d 2c 32 | 29 0d 0a 20 20 20 20 20 |t[m.i],2|).. |
|000016f0| 20 45 4e 44 49 46 0d 0a | 20 20 20 45 4c 53 45 0d | ENDIF..| ELSE.|
|00001700| 0a 20 20 20 20 20 20 49 | 46 20 4c 45 46 54 28 70 |. I|F LEFT(p|
|00001710| 61 72 65 6e 74 6c 69 73 | 74 5b 6d 2e 69 5d 2c 31 |arentlis|t[m.i],1|
|00001720| 29 20 3c 3e 20 27 5c 27 | 0d 0a 20 20 20 20 20 20 |) <> '\'|.. |
|00001730| 20 20 20 70 61 72 65 6e | 74 6c 69 73 74 5b 6d 2e | paren|tlist[m.|
|00001740| 69 5d 20 3d 20 27 5c 27 | 2b 70 61 72 65 6e 74 6c |i] = '\'|+parentl|
|00001750| 69 73 74 5b 6d 2e 69 5d | 0d 0a 20 20 20 20 20 20 |ist[m.i]|.. |
|00001760| 45 4e 44 49 46 0d 0a 20 | 20 20 45 4e 44 49 46 0d |ENDIF.. | ENDIF.|
|00001770| 0a 45 4e 44 46 4f 52 0d | 0a 53 48 4f 57 20 47 45 |.ENDFOR.|.SHOW GE|
|00001780| 54 20 70 61 72 65 6e 74 | 6c 69 73 74 0d 0a 0d 0a |T parent|list....|
|00001790| 00 00 00 00 00 00 00 00 | 00 00 01 00 00 00 0b 6d |........|.......m|
|000017a0| 2e 70 61 72 65 6e 74 66 | 6c 64 00 00 00 00 00 00 |.parentf|ld......|
|000017b0| 00 00 00 00 00 00 00 00 | 00 00 00 01 00 00 00 0a |........|........|
|000017c0| 70 61 72 65 6e 74 6c 69 | 73 74 00 00 00 00 00 00 |parentli|st......|
|000017d0| 00 00 00 00 00 00 00 00 | 00 00 00 00 01 00 00 00 |........|........|
|000017e0| 05 22 40 5e 20 22 00 00 | 00 00 00 00 00 00 00 00 |."@^ "..|........|
|000017f0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 01 00 00 |........|........|
|00001800| 00 0b 53 48 4f 57 20 47 | 45 54 53 0d 0a 00 00 00 |..SHOW G|ETS.....|
|00001810| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 01 00 |........|........|
|00001820| 00 00 08 22 45 71 75 61 | 6c 73 22 00 00 00 00 00 |..."Equa|ls".....|
|00001830| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 01 |........|........|
|00001840| 00 00 00 0a 6d 2e 63 68 | 69 6c 64 66 6c 64 00 00 |....m.ch|ildfld..|
|00001850| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001860| 01 00 00 00 09 63 68 69 | 6c 64 6c 69 73 74 00 00 |.....chi|ldlist..|
|00001870| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001880| 00 01 00 00 00 05 22 40 | 5e 20 22 00 00 00 00 00 |......"@|^ ".....|
|00001890| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000018a0| 00 00 01 00 00 00 37 44 | 4f 20 63 64 69 73 6c 69 |......7D|O cdisli|
|000018b0| 73 74 20 57 49 54 48 20 | 41 53 43 41 4e 28 63 68 |st WITH |ASCAN(ch|
|000018c0| 69 6c 64 6c 69 73 74 2c | 63 68 69 6c 64 66 6c 64 |ildlist,|childfld|
|000018d0| 29 0d 0a 53 48 4f 57 20 | 47 45 54 53 0d 0a 00 00 |)..SHOW |GETS....|
|000018e0| 00 00 00 00 01 00 00 00 | 17 22 46 69 65 6c 64 20 |........|."Field |
|000018f0| 69 6e 20 4f 74 68 65 72 | 20 54 61 62 6c 65 3a 22 |in Other| Table:"|
|00001900| 00 00 00 00 00 01 00 00 | 00 16 22 46 69 65 6c 64 |........|.."Field|
|00001910| 20 69 6e 20 54 68 69 73 | 20 54 61 62 6c 65 3a 22 | in This| Table:"|
|00001920| 00 00 00 00 00 00 01 00 | 00 00 2d 22 48 6f 77 20 |........|..-"How |
|00001930| 69 73 20 54 68 69 73 20 | 54 61 62 6c 65 20 52 65 |is This |Table Re|
|00001940| 6c 61 74 65 64 20 74 6f | 20 41 6e 6f 74 68 65 72 |lated to| Another|
|00001950| 20 54 61 62 6c 65 3f 22 | 00 00 00 00 00 00 00 00 | Table?"|........|
|00001960| 00 00 00 00 00 00 00 00 | 01 00 00 00 09 6d 2e 6f |........|.....m.o|
|00001970| 6b 63 61 6e 63 6c 00 00 | 00 00 00 00 00 00 00 00 |kcancl..|........|
|00001980| 00 00 00 00 00 00 00 00 | 00 01 00 00 00 18 22 40 |........|......"@|
|00001990| 2a 48 4e 20 5c 21 5c 3c | 4f 4b 3b 5c 3f 5c 3c 43 |*HN \!\<|OK;\?\<C|
|000019a0| 61 6e 63 65 6c 22 00 00 | 00 00 01 00 00 05 b4 2a |ancel"..|.......*|
|000019b0| 20 53 74 72 69 70 20 6f | 66 66 20 74 68 65 20 74 | Strip o|ff the t|
|000019c0| 79 70 65 20 64 65 73 69 | 67 6e 61 74 69 6f 6e 73 |ype desi|gnations|
|000019d0| 20 66 72 6f 6d 20 66 69 | 65 6c 64 20 6e 61 6d 65 | from fi|eld name|
|000019e0| 73 0d 0a 6d 2e 70 66 6c | 64 20 3d 20 6d 2e 70 61 |s..m.pfl|d = m.pa|
|000019f0| 72 65 6e 74 66 6c 64 0d | 0a 6d 2e 63 66 6c 64 20 |rentfld.|.m.cfld |
|00001a00| 3d 20 6d 2e 63 68 69 6c | 64 66 6c 64 0d 0a 49 46 |= m.chil|dfld..IF|
|00001a10| 20 41 54 28 27 28 27 2c | 6d 2e 70 61 72 65 6e 74 | AT('(',|m.parent|
|00001a20| 66 6c 64 29 20 3e 20 30 | 0d 0a 20 20 20 6d 2e 70 |fld) > 0|.. m.p|
|00001a30| 61 72 65 6e 74 66 6c 64 | 20 3d 20 41 4c 4c 54 52 |arentfld| = ALLTR|
|00001a40| 49 4d 28 53 55 42 53 54 | 52 28 6d 2e 70 61 72 65 |IM(SUBST|R(m.pare|
|00001a50| 6e 74 66 6c 64 2c 31 2c | 4c 45 4e 28 54 52 49 4d |ntfld,1,|LEN(TRIM|
|00001a60| 28 6d 2e 70 61 72 65 6e | 74 66 6c 64 29 29 2d 33 |(m.paren|tfld))-3|
|00001a70| 29 29 0d 0a 45 4e 44 49 | 46 0d 0a 49 46 20 41 54 |))..ENDI|F..IF AT|
|00001a80| 28 27 28 27 2c 6d 2e 63 | 68 69 6c 64 66 6c 64 29 |('(',m.c|hildfld)|
|00001a90| 20 3e 20 30 0d 0a 20 20 | 20 6d 2e 63 68 69 6c 64 | > 0.. | m.child|
|00001aa0| 66 6c 64 20 20 3d 20 41 | 4c 4c 54 52 49 4d 28 53 |fld = A|LLTRIM(S|
|00001ab0| 55 42 53 54 52 28 6d 2e | 63 68 69 6c 64 66 6c 64 |UBSTR(m.|childfld|
|00001ac0| 2c 31 2c 4c 45 4e 28 54 | 52 49 4d 28 6d 2e 63 68 |,1,LEN(T|RIM(m.ch|
|00001ad0| 69 6c 64 66 6c 64 29 29 | 2d 33 29 29 0d 0a 45 4e |ildfld))|-3))..EN|
|00001ae0| 44 49 46 0d 0a 0d 0a 44 | 4f 20 43 41 53 45 0d 0a |DIF....D|O CASE..|
|00001af0| 43 41 53 45 20 6d 2e 6f | 6b 63 61 6e 63 6c 20 3d |CASE m.o|kcancl =|
|00001b00| 20 31 0d 0a 20 20 20 2a | 20 4d 61 6b 65 20 73 75 | 1.. *| Make su|
|00001b10| 72 65 20 74 68 69 73 20 | 69 73 20 61 20 76 61 6c |re this |is a val|
|00001b20| 69 64 20 73 65 6c 65 63 | 74 69 6f 6e 20 77 69 74 |id selec|tion wit|
|00001b30| 68 20 72 65 73 70 65 63 | 74 20 74 6f 20 64 61 74 |h respec|t to dat|
|00001b40| 61 20 74 79 70 65 0d 0a | 20 20 20 44 4f 20 43 41 |a type..| DO CA|
|00001b50| 53 45 0d 0a 20 20 20 43 | 41 53 45 20 54 59 50 45 |SE.. C|ASE TYPE|
|00001b60| 28 6d 2e 63 68 69 6c 64 | 66 6c 64 29 20 3d 20 27 |(m.child|fld) = '|
|00001b70| 55 27 0d 0a 20 20 20 20 | 20 20 57 41 49 54 20 57 |U'.. | WAIT W|
|00001b80| 49 4e 44 4f 57 20 22 54 | 68 65 20 63 68 69 6c 64 |INDOW "T|he child|
|00001b90| 20 64 61 74 61 62 61 73 | 65 20 63 6f 75 6c 64 20 | databas|e could |
|00001ba0| 6e 6f 74 20 62 65 20 66 | 6f 75 6e 64 2e 22 0d 0a |not be f|ound."..|
|00001bb0| 20 20 20 43 41 53 45 20 | 54 59 50 45 28 6d 2e 70 | CASE |TYPE(m.p|
|00001bc0| 61 72 65 6e 74 66 6c 64 | 29 20 3d 20 27 55 27 0d |arentfld|) = 'U'.|
|00001bd0| 0a 20 20 20 20 20 20 57 | 41 49 54 20 57 49 4e 44 |. W|AIT WIND|
|00001be0| 4f 57 20 22 54 68 65 20 | 70 61 72 65 6e 74 20 64 |OW "The |parent d|
|00001bf0| 61 74 61 62 61 73 65 20 | 63 6f 75 6c 64 20 6e 6f |atabase |could no|
|00001c00| 74 20 62 65 20 66 6f 75 | 6e 64 2e 22 0d 0a 20 20 |t be fou|nd.".. |
|00001c10| 20 43 41 53 45 20 54 59 | 50 45 28 6d 2e 63 68 69 | CASE TY|PE(m.chi|
|00001c20| 6c 64 66 6c 64 29 20 3d | 3d 20 54 59 50 45 28 6d |ldfld) =|= TYPE(m|
|00001c30| 2e 70 61 72 65 6e 74 66 | 6c 64 29 0d 0a 20 20 20 |.parentf|ld).. |
|00001c40| 20 20 20 6d 2e 64 62 66 | 70 61 72 74 20 20 20 3d | m.dbf|part =|
|00001c50| 20 53 55 42 53 54 52 28 | 6d 2e 63 68 69 6c 64 66 | SUBSTR(|m.childf|
|00001c60| 6c 64 2c 31 2c 41 54 28 | 27 2e 27 2c 6d 2e 63 68 |ld,1,AT(|'.',m.ch|
|00001c70| 69 6c 64 66 6c 64 29 2d | 31 29 0d 0a 20 20 20 20 |ildfld)-|1).. |
|00001c80| 20 20 6d 2e 72 65 6c 73 | 74 72 20 20 20 20 3d 20 | m.rels|tr = |
|00001c90| 27 53 45 54 20 52 45 4c | 41 54 49 4f 4e 20 54 4f |'SET REL|ATION TO|
|00001ca0| 20 27 3b 0d 0a 20 20 20 | 20 20 20 20 20 20 2b 53 | ';.. | +S|
|00001cb0| 55 42 53 54 52 28 6d 2e | 70 61 72 65 6e 74 66 6c |UBSTR(m.|parentfl|
|00001cc0| 64 2c 41 54 28 27 2e 27 | 2c 6d 2e 70 61 72 65 6e |d,AT('.'|,m.paren|
|00001cd0| 74 66 6c 64 29 2b 31 29 | 3b 0d 0a 20 20 20 20 20 |tfld)+1)|;.. |
|00001ce0| 20 20 20 20 2b 27 20 49 | 4e 54 4f 20 27 2b 6d 2e | +' I|NTO '+m.|
|00001cf0| 64 62 66 70 61 72 74 0d | 0a 20 20 20 20 20 20 6d |dbfpart.|. m|
|00001d00| 2e 70 61 72 65 6e 74 64 | 62 66 20 3d 20 53 55 42 |.parentd|bf = SUB|
|00001d10| 53 54 52 28 6d 2e 70 61 | 72 65 6e 74 66 6c 64 2c |STR(m.pa|rentfld,|
|00001d20| 31 2c 41 54 28 27 2e 27 | 2c 6d 2e 70 61 72 65 6e |1,AT('.'|,m.paren|
|00001d30| 74 66 6c 64 29 2d 31 29 | 0d 0a 20 20 20 20 20 20 |tfld)-1)|.. |
|00001d40| 43 4c 45 41 52 20 52 45 | 41 44 0d 0a 20 20 20 4f |CLEAR RE|AD.. O|
|00001d50| 54 48 45 52 57 49 53 45 | 0d 0a 20 20 20 20 20 20 |THERWISE|.. |
|00001d60| 57 41 49 54 20 57 49 4e | 44 4f 57 20 22 50 61 72 |WAIT WIN|DOW "Par|
|00001d70| 65 6e 74 20 61 6e 64 20 | 63 68 69 6c 64 20 68 61 |ent and |child ha|
|00001d80| 76 65 20 64 69 66 66 65 | 72 65 6e 74 20 64 61 74 |ve diffe|rent dat|
|00001d90| 61 20 74 79 70 65 73 2e | 22 0d 0a 20 20 20 20 20 |a types.|".. |
|00001da0| 20 2a 20 52 65 73 74 6f | 72 65 20 66 75 6c 6c 20 | * Resto|re full |
|00001db0| 73 74 72 69 6e 67 20 74 | 6f 20 70 61 72 65 6e 74 |string t|o parent|
|00001dc0| 20 61 6e 64 20 63 68 69 | 6c 64 20 66 69 65 6c 64 | and chi|ld field|
|00001dd0| 73 0d 0a 20 20 20 20 20 | 20 6d 2e 70 61 72 65 6e |s.. | m.paren|
|00001de0| 74 66 6c 64 20 3d 20 6d | 2e 70 66 6c 64 0d 0a 20 |tfld = m|.pfld.. |
|00001df0| 20 20 20 20 20 6d 2e 63 | 68 69 6c 64 66 6c 64 20 | m.c|hildfld |
|00001e00| 20 3d 20 6d 2e 63 66 6c | 64 0d 0a 20 20 20 45 4e | = m.cfl|d.. EN|
|00001e10| 44 43 41 53 45 0d 0a 43 | 41 53 45 20 6d 2e 6f 6b |DCASE..C|ASE m.ok|
|00001e20| 63 61 6e 63 6c 20 3d 20 | 32 20 20 20 20 20 26 26 |cancl = |2 &&|
|00001e30| 20 63 61 6e 63 65 6c 20 | 74 68 69 73 20 72 65 6c | cancel |this rel|
|00001e40| 61 74 69 6f 6e 73 68 69 | 70 0d 0a 20 20 20 2a 20 |ationshi|p.. * |
|00001e50| 57 65 20 6f 70 65 6e 65 | 64 20 63 68 69 6c 64 73 |We opene|d childs|
|00001e60| 74 65 6d 20 69 6e 20 74 | 68 65 20 73 65 74 75 70 |tem in t|he setup|
|00001e70| 20 73 6e 69 70 70 65 74 | 2e 20 20 43 6c 6f 73 65 | snippet|. Close|
|00001e80| 20 69 74 20 6e 6f 77 2e | 0d 0a 20 20 20 49 46 20 | it now.|.. IF |
|00001e90| 6d 2e 61 64 64 6d 6f 64 | 65 20 41 4e 44 20 55 53 |m.addmod|e AND US|
|00001ea0| 45 44 28 6d 2e 63 68 69 | 6c 64 73 74 65 6d 29 0d |ED(m.chi|ldstem).|
|00001eb0| 0a 20 20 20 20 20 20 53 | 45 4c 45 43 54 20 28 6d |. S|ELECT (m|
|00001ec0| 2e 63 68 69 6c 64 73 74 | 65 6d 29 0d 0a 20 20 20 |.childst|em).. |
|00001ed0| 20 20 20 55 53 45 0d 0a | 20 20 20 45 4e 44 49 46 | USE..| ENDIF|
|00001ee0| 0d 0a 20 20 20 6d 2e 64 | 62 66 70 61 72 74 20 20 |.. m.d|bfpart |
|00001ef0| 20 3d 20 27 27 0d 0a 20 | 20 20 6d 2e 63 68 69 6c | = ''.. | m.chil|
|00001f00| 64 66 6c 64 20 20 3d 20 | 27 27 0d 0a 20 20 20 6d |dfld = |''.. m|
|00001f10| 2e 63 68 69 6c 64 64 62 | 66 20 20 3d 20 27 27 0d |.childdb|f = ''.|
|00001f20| 0a 20 20 20 6d 2e 72 65 | 6c 73 74 72 20 20 20 20 |. m.re|lstr |
|00001f30| 3d 20 27 27 0d 0a 20 20 | 20 6d 2e 70 61 72 65 6e |= ''.. | m.paren|
|00001f40| 74 64 62 66 20 3d 20 27 | 27 0d 0a 20 20 20 43 4c |tdbf = '|'.. CL|
|00001f50| 45 41 52 20 52 45 41 44 | 0d 0a 45 4e 44 43 41 53 |EAR READ|..ENDCAS|
|00001f60| 45 0d 0a 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |E.......|........|
|00001f70| 00 00 00 00 00 00 00 01 | 00 00 00 04 22 4f 4b 22 |........|...."OK"|
|00001f80| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001f90| 00 00 00 00 00 00 00 00 | 01 00 00 00 08 6d 2e 61 |........|.....m.a|
|00001fa0| 64 76 62 75 74 00 00 00 | 00 00 00 00 00 00 00 00 |dvbut...|........|
|00001fb0| 00 00 00 00 00 00 00 00 | 00 01 00 00 00 14 22 40 |........|......"@|
|00001fc0| 2a 48 4e 20 5c 3c 41 64 | 76 61 6e 63 65 64 2e 2e |*HN \<Ad|vanced..|
|00001fd0| 2e 22 00 00 00 00 00 00 | 00 00 01 00 00 00 3c 44 |."......|......<D|
|00001fe0| 4f 20 63 61 73 63 64 6c | 67 2e 73 70 72 20 57 49 |O cascdl|g.spr WI|
|00001ff0| 54 48 20 64 62 66 6c 69 | 73 74 5b 6d 2e 6e 65 78 |TH dbfli|st[m.nex|
|00002000| 74 64 62 66 2c 6d 2e 63 | 73 74 65 6d 6e 75 6d 5d |tdbf,m.c|stemnum]|
|00002010| 0d 0a 0d 0a 20 20 20 0d | 0a 0d 0a 00 00 00 00 00 |.... .|........|
|00002020| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002030| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 01 00 00 |........|........|
|00002040| 00 0d 22 41 64 76 61 6e | 63 65 64 2e 2e 2e 22 00 |.."Advan|ced...".|
|00002050| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 01 00 |........|........|
|00002060| 00 00 08 52 45 4c 53 45 | 4c 45 43 00 00 00 00 00 |...RELSE|LEC.....|
|00002070| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 01 |........|........|
|00002080| 00 00 00 16 22 4f 70 74 | 69 6f 6e 73 20 66 6f 72 |...."Opt|ions for|
|00002090| 20 26 74 68 69 73 64 62 | 66 22 00 00 00 00 00 00 | &thisdb|f"......|
|000020a0| 01 00 00 00 c5 49 46 20 | 45 4d 50 54 59 28 6d 2e |.....IF |EMPTY(m.|
|000020b0| 70 61 72 65 6e 74 66 6c | 64 29 20 3b 0d 0a 20 20 |parentfl|d) ;.. |
|000020c0| 20 20 20 20 4f 52 20 4c | 45 46 54 28 6d 2e 70 61 | OR L|EFT(m.pa|
|000020d0| 72 65 6e 74 66 6c 64 2c | 31 29 20 3d 20 27 5c 27 |rentfld,|1) = '\'|
|000020e0| 20 3b 0d 0a 20 20 20 20 | 20 20 4f 52 20 28 67 65 | ;.. | OR (ge|
|000020f0| 74 74 79 70 65 28 6d 2e | 70 61 72 65 6e 74 66 6c |ttype(m.|parentfl|
|00002100| 64 29 20 21 3d 20 67 65 | 74 74 79 70 65 28 6d 2e |d) != ge|ttype(m.|
|00002110| 63 68 69 6c 64 66 6c 64 | 29 29 0d 0a 20 20 20 53 |childfld|)).. S|
|00002120| 48 4f 57 20 47 45 54 20 | 6d 2e 6f 6b 63 61 6e 63 |HOW GET |m.okcanc|
|00002130| 6c 2c 31 20 44 49 53 41 | 42 4c 45 0d 0a 45 4c 53 |l,1 DISA|BLE..ELS|
|00002140| 45 0d 0a 20 20 20 53 48 | 4f 57 20 47 45 54 20 6d |E.. SH|OW GET m|
|00002150| 2e 6f 6b 63 61 6e 63 6c | 2c 31 20 45 4e 41 42 4c |.okcancl|,1 ENABL|
|00002160| 45 0d 0a 45 4e 44 49 46 | 0d 0a 00 00 00 00 00 00 |E..ENDIF|........|
|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 06 e7 0d 0a 2a 21 |........|......*!|
|00002190| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|000021a0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|000021b0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|000021c0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|000021d0| 2a 0d 0a 2a 21 0d 0a 2a | 21 20 20 20 20 20 20 50 |*..*!..*|! P|
|000021e0| 72 6f 63 65 64 75 72 65 | 3a 20 41 44 44 54 59 50 |rocedure|: ADDTYP|
|000021f0| 45 0d 0a 2a 21 0d 0a 2a | 21 2a 2a 2a 2a 2a 2a 2a |E..*!..*|!*******|
|00002200| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00002210| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00002220| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00002230| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 0d 0a 46 55 4e 43 |********|**..FUNC|
|00002240| 54 49 4f 4e 20 61 64 64 | 74 79 70 65 0d 0a 2a 20 |TION add|type..* |
|00002250| 41 64 64 20 74 68 65 20 | 64 61 74 61 20 74 79 70 |Add the |data typ|
|00002260| 65 20 74 6f 20 61 20 66 | 69 65 6c 64 20 6e 61 6d |e to a f|ield nam|
|00002270| 65 0d 0a 50 41 52 41 4d | 45 54 45 52 20 66 6c 64 |e..PARAM|ETER fld|
|00002280| 6e 61 6d 65 0d 0a 0d 0a | 49 46 20 21 45 4d 50 54 |name....|IF !EMPT|
|00002290| 59 28 6d 2e 66 6c 64 6e | 61 6d 65 29 0d 0a 20 20 |Y(m.fldn|ame).. |
|000022a0| 20 52 45 54 55 52 4e 20 | 50 41 44 52 28 6d 2e 66 | RETURN |PADR(m.f|
|000022b0| 6c 64 6e 61 6d 65 2c 32 | 30 29 20 2b 20 27 28 27 |ldname,2|0) + '('|
|000022c0| 20 2b 20 54 59 50 45 28 | 6d 2e 66 6c 64 6e 61 6d | + TYPE(|m.fldnam|
|000022d0| 65 29 20 2b 20 27 29 27 | 0d 0a 45 4c 53 45 0d 0a |e) + ')'|..ELSE..|
|000022e0| 20 20 20 52 45 54 55 52 | 4e 20 27 27 0d 0a 45 4e | RETUR|N ''..EN|
|000022f0| 44 49 46 0d 0a 0d 0a 0d | 0a 2a 21 2a 2a 2a 2a 2a |DIF.....|.*!*****|
|00002300| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00002310| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00002320| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00002330| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 0d 0a 2a 21 |********|****..*!|
|00002340| 0d 0a 2a 21 20 20 20 20 | 20 20 50 72 6f 63 65 64 |..*! | Proced|
|00002350| 75 72 65 3a 20 47 45 54 | 54 59 50 45 0d 0a 2a 21 |ure: GET|TYPE..*!|
|00002360| 0d 0a 2a 21 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 2a 2a |********|********|
|00002380| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00002390| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|000023a0| 2a 2a 2a 2a 2a 0d 0a 46 | 55 4e 43 54 49 4f 4e 20 |*****..F|UNCTION |
|000023b0| 67 65 74 74 79 70 65 0d | 0a 50 41 52 41 4d 45 54 |gettype.|.PARAMET|
|000023c0| 45 52 20 6d 2e 66 6c 64 | 6e 61 6d 65 0d 0a 50 52 |ER m.fld|name..PR|
|000023d0| 49 56 41 54 45 20 6d 2e | 72 65 74 76 61 6c 0d 0a |IVATE m.|retval..|
|000023e0| 2a 20 54 68 69 73 20 66 | 75 6e 63 74 69 6f 6e 20 |* This f|unction |
|000023f0| 65 78 74 72 61 63 74 73 | 20 74 68 65 20 64 61 74 |extracts| the dat|
|00002400| 61 20 74 79 70 65 20 66 | 72 6f 6d 20 74 68 65 20 |a type f|rom the |
|00002410| 66 6f 72 6d 61 74 20 75 | 73 65 64 20 69 6e 0d 0a |format u|sed in..|
|00002420| 2a 20 74 68 65 20 70 61 | 72 65 6e 74 6c 69 73 74 |* the pa|rentlist|
|00002430| 20 61 6e 64 20 63 68 69 | 6c 64 6c 69 73 74 20 61 | and chi|ldlist a|
|00002440| 72 72 61 79 73 2e 20 20 | 54 68 65 20 69 6e 63 6f |rrays. |The inco|
|00002450| 6d 69 6e 67 20 66 6f 72 | 6d 61 74 20 6c 6f 6f 6b |ming for|mat look|
|00002460| 73 0d 0a 2a 20 6c 69 6b | 65 3a 0d 0a 2a 20 20 20 |s..* lik|e:..* |
|00002470| 20 20 20 20 20 44 42 46 | 41 4c 49 41 53 2e 46 49 | DBF|ALIAS.FI|
|00002480| 45 4c 44 20 20 20 20 20 | 20 28 43 29 0d 0a 2a 0d |ELD | (C)..*.|
|00002490| 0a 2a 20 54 68 65 20 66 | 75 6e 63 74 69 6f 6e 20 |.* The f|unction |
|000024a0| 72 65 74 75 72 6e 73 20 | 27 43 27 0d 0a 0d 0a 6d |returns |'C'....m|
|000024b0| 2e 72 65 74 76 61 6c 20 | 3d 20 52 49 47 48 54 28 |.retval |= RIGHT(|
|000024c0| 54 52 49 4d 28 6d 2e 66 | 6c 64 6e 61 6d 65 29 2c |TRIM(m.f|ldname),|
|000024d0| 33 29 0d 0a 6d 2e 72 65 | 74 76 61 6c 20 3d 20 55 |3)..m.re|tval = U|
|000024e0| 50 50 45 52 28 41 4c 4c | 54 52 49 4d 28 6d 2e 72 |PPER(ALL|TRIM(m.r|
|000024f0| 65 74 76 61 6c 29 29 0d | 0a 52 45 54 55 52 4e 20 |etval)).|.RETURN |
|00002500| 43 48 52 54 52 41 4e 28 | 6d 2e 72 65 74 76 61 6c |CHRTRAN(|m.retval|
|00002510| 2c 27 28 29 27 2c 27 27 | 29 0d 0a 0d 0a 2a 21 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 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00002560| 0d 0a 2a 21 0d 0a 2a 21 | 20 20 20 20 20 20 50 72 |..*!..*!| Pr|
|00002570| 6f 63 65 64 75 72 65 3a | 20 43 44 49 53 4c 49 53 |ocedure:| CDISLIS|
|00002580| 54 0d 0a 2a 21 0d 0a 2a | 21 2a 2a 2a 2a 2a 2a 2a |T..*!..*|!*******|
|00002590| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|000025a0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|000025b0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|000025c0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 0d 0a 50 52 4f 43 |********|**..PROC|
|000025d0| 45 44 55 52 45 20 63 64 | 69 73 6c 69 73 74 0d 0a |EDURE cd|islist..|
|000025e0| 2a 20 54 68 69 73 20 70 | 72 6f 63 65 64 75 72 65 |* This p|rocedure|
|000025f0| 20 64 69 73 61 62 6c 65 | 73 20 66 69 65 6c 64 73 | disable|s fields|
|00002600| 20 69 6e 20 74 68 65 20 | 70 61 72 65 6e 74 20 6c | in the |parent l|
|00002610| 69 73 74 20 74 68 61 74 | 20 68 61 76 65 20 61 20 |ist that| have a |
|00002620| 64 69 66 66 65 72 65 6e | 74 0d 0a 2a 20 74 79 70 |differen|t..* typ|
|00002630| 65 20 66 72 6f 6d 20 74 | 68 65 20 63 75 72 72 65 |e from t|he curre|
|00002640| 6e 74 20 66 69 65 6c 64 | 20 69 6e 20 74 68 65 20 |nt field| in the |
|00002650| 63 68 69 6c 64 20 6c 69 | 73 74 0d 0a 0d 0a 50 41 |child li|st....PA|
|00002660| 52 41 4d 45 54 45 52 20 | 63 75 72 69 74 65 6d 0d |RAMETER |curitem.|
|00002670| 0a 50 52 49 56 41 54 45 | 20 6d 2e 63 75 72 69 74 |.PRIVATE| m.curit|
|00002680| 65 6d 2c 20 6d 2e 73 6f | 75 72 63 65 74 79 70 65 |em, m.so|urcetype|
|00002690| 2c 20 6d 2e 74 61 72 67 | 74 79 70 65 2c 20 6d 2e |, m.targ|type, m.|
|000026a0| 69 0d 0a 0d 0a 49 46 20 | 6d 2e 63 75 72 69 74 65 |i....IF |m.curite|
|000026b0| 6d 20 3c 3d 20 30 0d 0a | 20 20 20 6d 2e 63 75 72 |m <= 0..| m.cur|
|000026c0| 69 74 65 6d 20 3d 20 31 | 0d 0a 45 4e 44 49 46 0d |item = 1|..ENDIF.|
|000026d0| 0a 0d 0a 6d 2e 73 6f 75 | 72 63 65 74 79 70 65 20 |...m.sou|rcetype |
|000026e0| 3d 20 67 65 74 74 79 70 | 65 28 63 68 69 6c 64 6c |= gettyp|e(childl|
|000026f0| 69 73 74 5b 6d 2e 63 75 | 72 69 74 65 6d 5d 29 0d |ist[m.cu|ritem]).|
|00002700| 0a 0d 0a 46 4f 52 20 6d | 2e 69 20 3d 20 31 20 54 |...FOR m|.i = 1 T|
|00002710| 4f 20 41 4c 45 4e 28 70 | 61 72 65 6e 74 6c 69 73 |O ALEN(p|arentlis|
|00002720| 74 29 0d 0a 20 20 20 6d | 2e 74 61 72 67 74 79 70 |t).. m|.targtyp|
|00002730| 65 20 3d 20 67 65 74 74 | 79 70 65 28 70 61 72 65 |e = gett|ype(pare|
|00002740| 6e 74 6c 69 73 74 5b 6d | 2e 69 5d 29 0d 0a 20 20 |ntlist[m|.i]).. |
|00002750| 20 49 46 20 6d 2e 73 6f | 75 72 63 65 74 79 70 65 | IF m.so|urcetype|
|00002760| 20 3d 3d 20 6d 2e 74 61 | 72 67 74 79 70 65 0d 0a | == m.ta|rgtype..|
|00002770| 20 20 20 20 20 20 49 46 | 20 4c 45 46 54 28 70 61 | IF| LEFT(pa|
|00002780| 72 65 6e 74 6c 69 73 74 | 5b 6d 2e 69 5d 2c 31 29 |rentlist|[m.i],1)|
|00002790| 20 3d 20 27 5c 27 0d 0a | 20 20 20 20 20 20 20 20 | = '\'..| |
|000027a0| 20 70 61 72 65 6e 74 6c | 69 73 74 5b 6d 2e 69 5d | parentl|ist[m.i]|
|000027b0| 20 3d 20 53 55 42 53 54 | 52 28 70 61 72 65 6e 74 | = SUBST|R(parent|
|000027c0| 6c 69 73 74 5b 6d 2e 69 | 5d 2c 32 29 0d 0a 20 20 |list[m.i|],2).. |
|000027d0| 20 20 20 20 45 4e 44 49 | 46 0d 0a 20 20 20 45 4c | ENDI|F.. EL|
|000027e0| 53 45 0d 0a 20 20 20 20 | 20 20 49 46 20 4c 45 46 |SE.. | IF LEF|
|000027f0| 54 28 70 61 72 65 6e 74 | 6c 69 73 74 5b 6d 2e 69 |T(parent|list[m.i|
|00002800| 5d 2c 31 29 20 3c 3e 20 | 27 5c 27 0d 0a 20 20 20 |],1) <> |'\'.. |
|00002810| 20 20 20 20 20 20 70 61 | 72 65 6e 74 6c 69 73 74 | pa|rentlist|
|00002820| 5b 6d 2e 69 5d 20 3d 20 | 27 5c 27 2b 70 61 72 65 |[m.i] = |'\'+pare|
|00002830| 6e 74 6c 69 73 74 5b 6d | 2e 69 5d 0d 0a 20 20 20 |ntlist[m|.i].. |
|00002840| 20 20 20 45 4e 44 49 46 | 0d 0a 20 20 20 45 4e 44 | ENDIF|.. END|
|00002850| 49 46 0d 0a 45 4e 44 46 | 4f 52 0d 0a 53 48 4f 57 |IF..ENDF|OR..SHOW|
|00002860| 20 47 45 54 20 70 61 72 | 65 6e 74 6c 69 73 74 0d | GET par|entlist.|
|00002870| 0a 0d 0a 00 00 00 00 00 | 00 00 00 00 00 01 00 00 |........|........|
|00002880| 0d 44 23 54 52 41 4e 20 | 53 4e 49 50 50 45 54 20 |.D#TRAN |SNIPPET |
|00002890| 4f 4e 4c 59 0d 0a 23 53 | 45 43 54 49 4f 4e 20 31 |ONLY..#S|ECTION 1|
|000028a0| 0d 0a 50 41 52 41 4d 45 | 54 45 52 53 20 6d 2e 63 |..PARAME|TERS m.c|
|000028b0| 68 69 6c 64 73 74 65 6d | 2c 20 6d 2e 63 68 69 6c |hildstem|, m.chil|
|000028c0| 64 64 62 66 2c 20 6d 2e | 63 68 69 6c 64 66 6c 64 |ddbf, m.|childfld|
|000028d0| 2c 20 6d 2e 70 61 72 65 | 6e 74 66 6c 64 2c 20 6d |, m.pare|ntfld, m|
|000028e0| 2e 69 67 6e 63 61 73 65 | 2c 20 3b 0d 0a 20 20 20 |.igncase|, ;.. |
|000028f0| 6d 2e 72 65 6c 73 74 72 | 2c 20 6d 2e 70 61 72 65 |m.relstr|, m.pare|
|00002900| 6e 74 64 62 66 2c 20 6d | 2e 61 64 64 6d 6f 64 65 |ntdbf, m|.addmode|
|00002910| 0d 0a 0d 0a 50 52 49 56 | 41 54 45 20 6d 2e 69 67 |....PRIV|ATE m.ig|
|00002920| 6e 63 61 73 65 2c 20 6d | 2e 61 64 64 6d 6f 64 65 |ncase, m|.addmode|
|00002930| 2c 20 6d 2e 69 2c 20 6d | 2e 6a 2c 20 6d 2e 61 6c |, m.i, m|.j, m.al|
|00002940| 5f 6e 61 6d 65 2c 20 6d | 2e 74 68 69 73 64 62 66 |_name, m|.thisdbf|
|00002950| 2c 20 6d 2e 64 6f 6e 65 | 2c 20 6d 2e 69 6e 5f 61 |, m.done|, m.in_a|
|00002960| 72 65 61 0d 0a 0d 0a 2a | 20 41 73 73 65 6d 62 6c |rea....*| Assembl|
|00002970| 65 20 73 74 72 69 6e 67 | 20 66 6f 72 20 64 69 61 |e string| for dia|
|00002980| 6c 6f 67 20 74 69 74 6c | 65 0d 0a 6d 2e 74 68 69 |log titl|e..m.thi|
|00002990| 73 64 62 66 20 3d 20 6a | 75 73 74 66 6e 61 6d 65 |sdbf = j|ustfname|
|000029a0| 28 6d 2e 63 68 69 6c 64 | 64 62 66 29 0d 0a 0d 0a |(m.child|dbf)....|
|000029b0| 2a 20 61 64 64 6d 6f 64 | 65 20 64 65 74 65 72 6d |* addmod|e determ|
|000029c0| 69 6e 65 73 20 69 66 20 | 77 65 20 61 72 65 20 61 |ines if |we are a|
|000029d0| 64 64 69 6e 67 20 61 20 | 6e 65 77 20 72 65 6c 61 |dding a |new rela|
|000029e0| 74 69 6f 6e 73 68 69 70 | 20 6f 72 20 65 64 69 74 |tionship| or edit|
|000029f0| 69 6e 67 0d 0a 2a 20 61 | 6e 20 65 78 69 73 69 6e |ing..* a|n exisin|
|00002a00| 67 20 6f 6e 65 0d 0a 0d | 0a 2a 20 53 74 61 72 74 |g one...|.* Start|
|00002a10| 20 77 69 74 68 20 6e 65 | 77 20 63 6f 70 69 65 73 | with ne|w copies|
|00002a20| 20 6f 66 20 74 68 65 20 | 6c 69 73 74 20 61 72 72 | of the |list arr|
|00002a30| 61 79 73 20 61 6e 64 20 | 72 65 6c 65 61 73 65 20 |ays and |release |
|00002a40| 61 6e 79 20 74 68 61 74 | 20 0d 0a 2a 20 61 6c 72 |any that| ..* alr|
|00002a50| 65 61 64 79 20 65 78 69 | 73 74 0d 0a 52 45 4c 45 |eady exi|st..RELE|
|00002a60| 41 53 45 20 63 68 69 6c | 64 6c 69 73 74 2c 20 70 |ASE chil|dlist, p|
|00002a70| 61 72 65 6e 74 6c 69 73 | 74 0d 0a 0d 0a 23 53 45 |arentlis|t....#SE|
|00002a80| 43 54 49 4f 4e 20 32 0d | 0a 0d 0a 6d 2e 69 6e 5f |CTION 2.|...m.in_|
|00002a90| 61 72 65 61 20 3d 20 53 | 45 4c 45 43 54 28 29 0d |area = S|ELECT().|
|00002aa0| 0a 0d 0a 2a 20 4d 61 6b | 65 20 73 75 72 65 20 63 |...* Mak|e sure c|
|00002ab0| 68 69 6c 64 20 64 61 74 | 61 62 61 73 65 20 65 78 |hild dat|abase ex|
|00002ac0| 69 73 74 73 0d 0a 49 46 | 20 21 46 49 4c 45 28 6d |ists..IF| !FILE(m|
|00002ad0| 2e 63 68 69 6c 64 64 62 | 66 29 0d 0a 20 20 20 6d |.childdb|f).. m|
|00002ae0| 2e 63 68 69 6c 64 64 62 | 66 20 3d 20 47 45 54 46 |.childdb|f = GETF|
|00002af0| 49 4c 45 28 27 44 42 46 | 27 2c 27 50 6c 65 61 73 |ILE('DBF|','Pleas|
|00002b00| 65 20 6c 6f 63 61 74 65 | 20 74 68 65 20 27 2b 6a |e locate| the '+j|
|00002b10| 75 73 74 73 74 65 6d 28 | 6d 2e 63 68 69 6c 64 64 |uststem(|m.childd|
|00002b20| 62 66 29 2b 27 20 64 61 | 74 61 62 61 73 65 27 29 |bf)+' da|tabase')|
|00002b30| 0d 0a 45 4e 44 49 46 0d | 0a 49 46 20 45 4d 50 54 |..ENDIF.|.IF EMPT|
|00002b40| 59 28 6d 2e 63 68 69 6c | 64 64 62 66 29 20 4f 52 |Y(m.chil|ddbf) OR|
|00002b50| 20 21 46 49 4c 45 28 6d | 2e 63 68 69 6c 64 64 62 | !FILE(m|.childdb|
|00002b60| 66 29 0d 0a 20 20 20 6d | 2e 63 68 69 6c 64 64 62 |f).. m|.childdb|
|00002b70| 66 20 3d 20 27 27 0d 0a | 20 20 20 52 45 54 55 52 |f = ''..| RETUR|
|00002b80| 4e 0d 0a 45 4e 44 49 46 | 0d 0a 0d 0a 0d 0a 2a 20 |N..ENDIF|......* |
|00002b90| 46 69 6c 6c 20 69 6e 20 | 74 68 65 20 70 61 72 65 |Fill in |the pare|
|00002ba0| 6e 74 6c 69 73 74 20 77 | 69 74 68 20 74 68 65 20 |ntlist w|ith the |
|00002bb0| 6e 61 6d 65 73 20 6f 66 | 20 61 6c 6c 20 66 69 65 |names of| all fie|
|00002bc0| 6c 64 73 0d 0a 2a 20 20 | 20 69 6e 20 61 6c 6c 20 |lds..* | in all |
|00002bd0| 6f 70 65 6e 20 64 61 74 | 61 62 61 73 65 73 0d 0a |open dat|abases..|
|00002be0| 6d 2e 70 61 72 65 6e 74 | 72 6f 77 20 3d 20 30 0d |m.parent|row = 0.|
|00002bf0| 0a 44 49 4d 45 4e 53 49 | 4f 4e 20 70 61 72 65 6e |.DIMENSI|ON paren|
|00002c00| 74 6c 69 73 74 5b 31 5d | 0d 0a 70 61 72 65 6e 74 |tlist[1]|..parent|
|00002c10| 6c 69 73 74 5b 31 5d 20 | 3d 20 22 22 0d 0a 46 4f |list[1] |= ""..FO|
|00002c20| 52 20 6d 2e 69 20 3d 20 | 31 20 54 4f 20 32 35 0d |R m.i = |1 TO 25.|
|00002c30| 0a 20 20 20 53 45 4c 45 | 43 54 20 28 6d 2e 69 29 |. SELE|CT (m.i)|
|00002c40| 0d 0a 20 20 20 49 46 20 | 21 45 4d 50 54 59 28 44 |.. IF |!EMPTY(D|
|00002c50| 42 46 28 6d 2e 69 29 29 | 20 41 4e 44 20 6d 61 6b |BF(m.i))| AND mak|
|00002c60| 65 61 6c 69 61 73 28 6a | 75 73 74 73 74 65 6d 28 |ealias(j|uststem(|
|00002c70| 44 42 46 28 6d 2e 69 29 | 29 29 20 3c 3e 20 6d 61 |DBF(m.i)|)) <> ma|
|00002c80| 6b 65 61 6c 69 61 73 28 | 6a 75 73 74 73 74 65 6d |kealias(|juststem|
|00002c90| 28 6d 2e 63 68 69 6c 64 | 73 74 65 6d 29 29 0d 0a |(m.child|stem))..|
|00002ca0| 20 20 20 20 20 20 46 4f | 52 20 6d 2e 6a 20 3d 20 | FO|R m.j = |
|00002cb0| 31 20 54 4f 20 46 43 4f | 55 4e 54 28 6d 2e 69 29 |1 TO FCO|UNT(m.i)|
|00002cc0| 0d 0a 20 20 20 20 20 20 | 20 20 20 6d 2e 70 61 72 |.. | m.par|
|00002cd0| 65 6e 74 72 6f 77 20 3d | 20 6d 2e 70 61 72 65 6e |entrow =| m.paren|
|00002ce0| 74 72 6f 77 20 2b 20 31 | 0d 0a 20 20 20 20 20 20 |trow + 1|.. |
|00002cf0| 20 20 20 44 49 4d 45 4e | 53 49 4f 4e 20 70 61 72 | DIMEN|SION par|
|00002d00| 65 6e 74 6c 69 73 74 5b | 6d 2e 70 61 72 65 6e 74 |entlist[|m.parent|
|00002d10| 72 6f 77 5d 0d 0a 20 20 | 20 20 20 20 20 20 20 70 |row].. | p|
|00002d20| 61 72 65 6e 74 6c 69 73 | 74 5b 6d 2e 70 61 72 65 |arentlis|t[m.pare|
|00002d30| 6e 74 72 6f 77 5d 20 3d | 20 61 64 64 74 79 70 65 |ntrow] =| addtype|
|00002d40| 28 41 4c 49 41 53 28 6d | 2e 69 29 2b 27 2e 27 2b |(ALIAS(m|.i)+'.'+|
|00002d50| 46 49 45 4c 44 28 6d 2e | 6a 2c 6d 2e 69 29 29 0d |FIELD(m.|j,m.i)).|
|00002d60| 0a 20 20 20 20 20 20 45 | 4e 44 46 4f 52 0d 0a 20 |. E|NDFOR.. |
|00002d70| 20 20 45 4e 44 49 46 0d | 0a 45 4e 44 46 4f 52 0d | ENDIF.|.ENDFOR.|
|00002d80| 0a 0d 0a 0d 0a 2a 20 46 | 69 6c 6c 20 69 6e 20 74 |.....* F|ill in t|
|00002d90| 68 65 20 63 68 69 6c 64 | 6c 69 73 74 20 77 69 74 |he child|list wit|
|00002da0| 68 20 74 68 65 20 6e 61 | 6d 65 73 20 6f 66 20 61 |h the na|mes of a|
|00002db0| 6c 6c 20 66 69 65 6c 64 | 73 0d 0a 2a 20 20 20 69 |ll field|s..* i|
|00002dc0| 6e 20 74 68 65 20 63 68 | 69 6c 64 20 64 61 74 61 |n the ch|ild data|
|00002dd0| 62 61 73 65 0d 0a 6d 2e | 63 68 69 6c 64 72 6f 77 |base..m.|childrow|
|00002de0| 20 3d 20 30 0d 0a 44 49 | 4d 45 4e 53 49 4f 4e 20 | = 0..DI|MENSION |
|00002df0| 63 68 69 6c 64 6c 69 73 | 74 5b 31 5d 0d 0a 63 68 |childlis|t[1]..ch|
|00002e00| 69 6c 64 6c 69 73 74 28 | 31 29 20 3d 20 22 22 0d |ildlist(|1) = "".|
|00002e10| 0a 49 46 20 55 53 45 44 | 28 6d 61 6b 65 61 6c 69 |.IF USED|(makeali|
|00002e20| 61 73 28 6d 2e 63 68 69 | 6c 64 73 74 65 6d 29 29 |as(m.chi|ldstem))|
|00002e30| 0d 0a 20 20 20 6d 2e 61 | 6c 5f 6e 61 6d 65 20 3d |.. m.a|l_name =|
|00002e40| 20 6d 61 6b 65 61 6c 69 | 61 73 28 6d 2e 63 68 69 | makeali|as(m.chi|
|00002e50| 6c 64 73 74 65 6d 29 0d | 0a 20 20 20 53 45 4c 45 |ldstem).|. SELE|
|00002e60| 43 54 20 28 6d 2e 61 6c | 5f 6e 61 6d 65 29 0d 0a |CT (m.al|_name)..|
|00002e70| 45 4c 53 45 0d 0a 20 20 | 20 53 45 4c 45 43 54 20 |ELSE.. | SELECT |
|00002e80| 30 0d 0a 20 20 20 55 53 | 45 20 28 6d 2e 63 68 69 |0.. US|E (m.chi|
|00002e90| 6c 64 64 62 66 29 0d 0a | 45 4e 44 49 46 0d 0a 46 |lddbf)..|ENDIF..F|
|00002ea0| 4f 52 20 6d 2e 6a 20 3d | 20 31 20 54 4f 20 46 43 |OR m.j =| 1 TO FC|
|00002eb0| 4f 55 4e 54 28 29 0d 0a | 20 20 20 49 46 20 54 59 |OUNT()..| IF TY|
|00002ec0| 50 45 28 46 49 45 4c 44 | 28 6d 2e 6a 29 29 20 3c |PE(FIELD|(m.j)) <|
|00002ed0| 3e 20 22 4d 22 0d 0a 20 | 20 20 20 20 20 6d 2e 63 |> "M".. | m.c|
|00002ee0| 68 69 6c 64 72 6f 77 20 | 3d 20 6d 2e 63 68 69 6c |hildrow |= m.chil|
|00002ef0| 64 72 6f 77 20 2b 20 31 | 0d 0a 20 20 20 20 20 20 |drow + 1|.. |
|00002f00| 44 49 4d 45 4e 53 49 4f | 4e 20 63 68 69 6c 64 6c |DIMENSIO|N childl|
|00002f10| 69 73 74 5b 6d 2e 63 68 | 69 6c 64 72 6f 77 5d 0d |ist[m.ch|ildrow].|
|00002f20| 0a 20 20 20 20 20 20 63 | 68 69 6c 64 6c 69 73 74 |. c|hildlist|
|00002f30| 5b 6d 2e 63 68 69 6c 64 | 72 6f 77 5d 20 3d 20 61 |[m.child|row] = a|
|00002f40| 64 64 74 79 70 65 28 41 | 4c 49 41 53 28 29 2b 27 |ddtype(A|LIAS()+'|
|00002f50| 2e 27 2b 46 49 45 4c 44 | 28 6d 2e 6a 29 29 0d 0a |.'+FIELD|(m.j))..|
|00002f60| 20 20 20 45 4e 44 49 46 | 0d 0a 45 4e 44 46 4f 52 | ENDIF|..ENDFOR|
|00002f70| 0d 0a 0d 0a 2a 20 50 6f | 73 69 74 69 6f 6e 20 73 |....* Po|sition s|
|00002f80| 65 6c 65 63 74 69 6f 6e | 20 62 61 72 73 20 6f 6e |election| bars on|
|00002f90| 74 6f 20 69 6e 74 65 6c | 6c 69 67 65 6e 74 20 64 |to intel|ligent d|
|00002fa0| 65 66 61 75 6c 74 73 2e | 20 20 54 72 79 20 74 6f |efaults.| Try to|
|00002fb0| 20 6d 61 74 63 68 0d 0a | 2a 20 66 69 65 6c 64 20 | match..|* field |
|00002fc0| 6e 61 6d 65 73 20 62 65 | 74 77 65 65 6e 20 74 68 |names be|tween th|
|00002fd0| 65 20 70 61 72 65 6e 74 | 20 61 6e 64 20 63 68 69 |e parent| and chi|
|00002fe0| 6c 64 20 64 61 74 61 62 | 61 73 65 73 2e 0d 0a 6d |ld datab|ases...m|
|00002ff0| 2e 64 6f 6e 65 20 3d 20 | 2e 46 2e 0d 0a 49 46 20 |.done = |.F...IF |
|00003000| 45 4d 50 54 59 28 6d 2e | 70 61 72 65 6e 74 66 6c |EMPTY(m.|parentfl|
|00003010| 64 29 0d 0a 20 20 20 49 | 46 20 45 4d 50 54 59 28 |d).. I|F EMPTY(|
|00003020| 6d 2e 63 68 69 6c 64 66 | 6c 64 29 0d 0a 20 20 20 |m.childf|ld).. |
|00003030| 20 20 20 2a 20 53 65 65 | 20 69 66 20 74 68 65 72 | * See| if ther|
|00003040| 65 20 61 72 65 20 61 6e | 79 20 66 69 65 6c 64 73 |e are an|y fields|
|00003050| 20 69 6e 20 74 68 65 20 | 70 61 72 65 6e 74 20 64 | in the |parent d|
|00003060| 61 74 61 62 61 73 65 20 | 77 69 74 68 0d 0a 20 20 |atabase |with.. |
|00003070| 20 20 20 20 2a 20 74 68 | 65 20 73 61 6d 65 20 6e | * th|e same n|
|00003080| 61 6d 65 20 61 6e 64 20 | 74 79 70 65 20 61 73 20 |ame and |type as |
|00003090| 61 20 66 69 65 6c 64 20 | 69 6e 20 74 68 65 20 63 |a field |in the c|
|000030a0| 68 69 6c 64 20 64 61 74 | 61 62 61 73 65 0d 0a 20 |hild dat|abase.. |
|000030b0| 20 20 20 20 20 6d 2e 69 | 20 3d 20 31 0d 0a 20 20 | m.i| = 1.. |
|000030c0| 20 20 20 20 44 4f 20 57 | 48 49 4c 45 20 21 64 6f | DO W|HILE !do|
|000030d0| 6e 65 20 41 4e 44 20 6d | 2e 69 20 3c 3d 20 6d 2e |ne AND m|.i <= m.|
|000030e0| 63 68 69 6c 64 72 6f 77 | 0d 0a 20 20 20 20 20 20 |childrow|.. |
|000030f0| 20 20 20 6d 2e 6e 65 77 | 63 68 69 6c 64 20 20 3d | m.new|child =|
|00003100| 20 53 55 42 53 54 52 28 | 63 68 69 6c 64 6c 69 73 | SUBSTR(|childlis|
|00003110| 74 5b 6d 2e 69 5d 2c 41 | 54 28 27 2e 27 2c 63 68 |t[m.i],A|T('.',ch|
|00003120| 69 6c 64 6c 69 73 74 5b | 6d 2e 69 5d 29 2b 31 29 |ildlist[|m.i])+1)|
|00003130| 0d 0a 20 20 20 20 20 20 | 20 20 20 6d 2e 6e 65 77 |.. | m.new|
|00003140| 63 68 69 6c 64 20 20 3d | 20 43 48 52 54 52 41 4e |child =| CHRTRAN|
|00003150| 28 6d 2e 6e 65 77 63 68 | 69 6c 64 2c 27 20 27 2c |(m.newch|ild,' ',|
|00003160| 27 27 29 0d 0a 20 20 20 | 20 20 20 20 20 20 6d 2e |'').. | m.|
|00003170| 6a 20 3d 20 31 0d 0a 20 | 20 20 20 20 20 20 20 20 |j = 1.. | |
|00003180| 44 4f 20 57 48 49 4c 45 | 20 21 6d 2e 64 6f 6e 65 |DO WHILE| !m.done|
|00003190| 20 41 4e 44 20 6d 2e 6a | 20 3c 3d 20 6d 2e 70 61 | AND m.j| <= m.pa|
|000031a0| 72 65 6e 74 72 6f 77 0d | 0a 20 20 20 20 20 20 20 |rentrow.|. |
|000031b0| 20 20 20 20 20 2a 20 41 | 73 73 65 6d 62 6c 65 20 | * A|ssemble |
|000031c0| 61 20 6e 65 77 20 6e 61 | 6d 65 20 62 61 73 65 64 |a new na|me based|
|000031d0| 20 6f 6e 20 74 68 65 20 | 66 69 65 6c 64 20 6e 61 | on the |field na|
|000031e0| 6d 65 20 61 6e 64 20 74 | 68 65 20 66 69 65 6c 64 |me and t|he field|
|000031f0| 20 74 79 70 65 0d 0a 20 | 20 20 20 20 20 20 20 20 | type.. | |
|00003200| 20 20 20 2a 20 54 68 65 | 20 70 61 72 65 6e 74 6c | * The| parentl|
|00003210| 69 73 74 20 72 65 63 6f | 72 64 73 20 6c 6f 6f 6b |ist reco|rds look|
|00003220| 20 6c 69 6b 65 20 74 68 | 69 73 3a 0d 0a 20 20 20 | like th|is:.. |
|00003230| 20 20 20 20 20 20 20 20 | 20 2a 20 20 20 20 61 6c | | * al|
|00003240| 69 61 73 2e 66 6c 64 20 | 20 20 20 20 20 20 28 4e |ias.fld | (N|
|00003250| 29 0d 0a 20 20 20 20 20 | 20 20 20 20 20 20 20 2a |).. | *|
|00003260| 20 22 4e 65 77 70 61 72 | 65 6e 74 22 20 6e 6f 77 | "Newpar|ent" now|
|00003270| 20 6c 6f 6f 6b 73 20 6c | 69 6b 65 20 74 68 69 73 | looks l|ike this|
|00003280| 3a 0d 0a 20 20 20 20 20 | 20 20 20 20 20 20 20 2a |:.. | *|
|00003290| 20 20 20 20 20 66 6c 64 | 28 4e 29 0d 0a 20 20 20 | fld|(N).. |
|000032a0| 20 20 20 20 20 20 20 20 | 20 6d 2e 6e 65 77 70 61 | | m.newpa|
|000032b0| 72 65 6e 74 20 3d 20 53 | 55 42 53 54 52 28 70 61 |rent = S|UBSTR(pa|
|000032c0| 72 65 6e 74 6c 69 73 74 | 5b 6d 2e 6a 5d 2c 41 54 |rentlist|[m.j],AT|
|000032d0| 28 27 2e 27 2c 70 61 72 | 65 6e 74 6c 69 73 74 5b |('.',par|entlist[|
|000032e0| 6d 2e 6a 5d 29 2b 31 29 | 0d 0a 20 20 20 20 20 20 |m.j])+1)|.. |
|000032f0| 20 20 20 20 20 20 6d 2e | 6e 65 77 70 61 72 65 6e | m.|newparen|
|00003300| 74 20 3d 20 43 48 52 54 | 52 41 4e 28 6e 65 77 70 |t = CHRT|RAN(newp|
|00003310| 61 72 65 6e 74 2c 27 20 | 27 2c 27 27 29 0d 0a 0d |arent,' |','')...|
|00003320| 0a 20 20 20 20 20 20 20 | 20 20 20 20 20 49 46 20 |. | IF |
|00003330| 6d 2e 6e 65 77 70 61 72 | 65 6e 74 20 3d 3d 20 6d |m.newpar|ent == m|
|00003340| 2e 6e 65 77 63 68 69 6c | 64 0d 0a 20 20 20 20 20 |.newchil|d.. |
|00003350| 20 20 20 20 20 20 20 20 | 20 20 6d 2e 70 61 72 65 | | m.pare|
|00003360| 6e 74 66 6c 64 20 3d 20 | 70 61 72 65 6e 74 6c 69 |ntfld = |parentli|
|00003370| 73 74 5b 6d 2e 6a 5d 0d | 0a 20 20 20 20 20 20 20 |st[m.j].|. |
|00003380| 20 20 20 20 20 20 20 20 | 6d 2e 63 68 69 6c 64 66 | |m.childf|
|00003390| 6c 64 20 20 3d 20 63 68 | 69 6c 64 6c 69 73 74 5b |ld = ch|ildlist[|
|000033a0| 6d 2e 69 5d 0d 0a 20 20 | 20 20 20 20 20 20 20 20 |m.i].. | |
|000033b0| 20 20 20 20 20 6d 2e 64 | 6f 6e 65 20 3d 20 2e 54 | m.d|one = .T|
|000033c0| 2e 0d 0a 20 20 20 20 20 | 20 20 20 20 20 20 20 45 |... | E|
|000033d0| 4e 44 49 46 0d 0a 20 20 | 20 20 20 20 20 20 20 20 |NDIF.. | |
|000033e0| 20 20 6d 2e 6a 20 3d 20 | 6d 2e 6a 20 2b 20 31 0d | m.j = |m.j + 1.|
|000033f0| 0a 20 20 20 20 20 20 20 | 20 20 45 4e 44 44 4f 0d |. | ENDDO.|
|00003400| 0a 20 20 20 20 20 20 20 | 20 20 6d 2e 69 20 3d 20 |. | m.i = |
|00003410| 6d 2e 69 20 2b 20 31 0d | 0a 20 20 20 20 20 20 45 |m.i + 1.|. E|
|00003420| 4e 44 44 4f 0d 0a 0d 0a | 20 20 20 20 20 20 49 46 |NDDO....| IF|
|00003430| 20 21 6d 2e 64 6f 6e 65 | 20 20 20 20 26 26 20 6e | !m.done| && n|
|00003440| 6f 20 6d 61 74 63 68 65 | 73 20 66 6f 75 6e 64 2e |o matche|s found.|
|00003450| 20 20 44 65 66 61 75 6c | 74 20 74 6f 20 66 69 72 | Defaul|t to fir|
|00003460| 73 74 20 66 69 65 6c 64 | 2e 0d 0a 20 20 20 20 20 |st field|... |
|00003470| 20 20 20 20 6d 2e 63 68 | 69 6c 64 66 6c 64 20 20 | m.ch|ildfld |
|00003480| 20 3d 20 63 68 69 6c 64 | 6c 69 73 74 5b 31 5d 0d | = child|list[1].|
|00003490| 0a 20 20 20 20 20 20 45 | 4e 44 49 46 0d 0a 20 20 |. E|NDIF.. |
|000034a0| 20 45 4c 53 45 0d 0a 20 | 20 20 20 20 20 2a 20 44 | ELSE.. | * D|
|000034b0| 65 66 61 75 6c 74 20 74 | 6f 20 74 68 65 20 66 69 |efault t|o the fi|
|000034c0| 72 73 74 20 66 69 65 6c | 64 20 0d 0a 20 20 20 20 |rst fiel|d .. |
|000034d0| 20 20 6d 2e 70 61 72 65 | 6e 74 66 6c 64 20 20 3d | m.pare|ntfld =|
|000034e0| 20 70 61 72 65 6e 74 6c | 69 73 74 5b 31 5d 0d 0a | parentl|ist[1]..|
|000034f0| 20 20 20 20 20 20 6d 2e | 63 68 69 6c 64 66 6c 64 | m.|childfld|
|00003500| 20 20 20 3d 20 61 64 64 | 74 79 70 65 28 6d 2e 63 | = add|type(m.c|
|00003510| 68 69 6c 64 66 6c 64 29 | 0d 0a 20 20 20 45 4e 44 |hildfld)|.. END|
|00003520| 49 46 0d 0a 45 4c 53 45 | 0d 0a 20 20 20 6d 2e 70 |IF..ELSE|.. m.p|
|00003530| 61 72 65 6e 74 66 6c 64 | 20 20 3d 20 61 64 64 74 |arentfld| = addt|
|00003540| 79 70 65 28 6d 2e 70 61 | 72 65 6e 74 66 6c 64 29 |ype(m.pa|rentfld)|
|00003550| 0d 0a 20 20 20 6d 2e 63 | 68 69 6c 64 66 6c 64 20 |.. m.c|hildfld |
|00003560| 20 20 3d 20 61 64 64 74 | 79 70 65 28 6d 2e 63 68 | = addt|ype(m.ch|
|00003570| 69 6c 64 66 6c 64 29 0d | 0a 45 4e 44 49 46 0d 0a |ildfld).|.ENDIF..|
|00003580| 0d 0a 44 4f 20 63 64 69 | 73 6c 69 73 74 20 57 49 |..DO cdi|slist WI|
|00003590| 54 48 20 41 53 43 41 4e | 28 63 68 69 6c 64 6c 69 |TH ASCAN|(childli|
|000035a0| 73 74 2c 6d 2e 63 68 69 | 6c 64 66 6c 64 29 0d 0a |st,m.chi|ldfld)..|
|000035b0| 0d 0a 53 45 4c 45 43 54 | 20 28 6d 2e 69 6e 5f 61 |..SELECT| (m.in_a|
|000035c0| 72 65 61 29 0d 0a 00 00 | 00 00 00 00 00 00 00 00 |rea)....|........|
|000035d0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000035e0| 00 00 00 00 00 01 00 00 | 00 0b 6d 2e 70 61 72 65 |........|..m.pare|
|000035f0| 6e 74 66 6c 64 00 00 00 | 00 00 00 00 00 00 00 00 |ntfld...|........|
|00003600| 00 00 00 00 00 00 01 00 | 00 00 0a 70 61 72 65 6e |........|...paren|
|00003610| 74 6c 69 73 74 00 00 00 | 00 00 00 00 00 00 00 00 |tlist...|........|
|00003620| 00 00 00 00 00 00 00 01 | 00 00 00 05 22 40 5e 20 |........|...."@^ |
|00003630| 22 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |".......|........|
|00003640| 00 00 00 00 00 00 00 00 | 01 00 00 00 0b 53 48 4f |........|.....SHO|
|00003650| 57 20 47 45 54 53 0d 0a | 00 00 00 00 00 00 00 00 |W GETS..|........|
|00003660| 00 00 00 00 00 00 00 00 | 00 01 00 00 00 08 22 45 |........|......"E|
|00003670| 71 75 61 6c 73 22 00 00 | 00 00 00 00 00 00 00 00 |quals"..|........|
|00003680| 00 00 00 00 00 00 00 00 | 00 00 01 00 00 00 0a 6d |........|.......m|
|00003690| 2e 63 68 69 6c 64 66 6c | 64 00 00 00 00 00 00 00 |.childfl|d.......|
|000036a0| 00 00 00 00 00 00 00 00 | 00 00 00 01 00 00 00 09 |........|........|
|000036b0| 63 68 69 6c 64 6c 69 73 | 74 00 00 00 00 00 00 00 |childlis|t.......|
|000036c0| 00 00 00 00 00 00 00 00 | 00 00 00 00 01 00 00 00 |........|........|
|000036d0| 05 22 40 5e 20 22 00 00 | 00 00 00 00 00 00 00 00 |."@^ "..|........|
|000036e0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 01 00 00 |........|........|
|000036f0| 00 37 44 4f 20 63 64 69 | 73 6c 69 73 74 20 57 49 |.7DO cdi|slist WI|
|00003700| 54 48 20 41 53 43 41 4e | 28 63 68 69 6c 64 6c 69 |TH ASCAN|(childli|
|00003710| 73 74 2c 63 68 69 6c 64 | 66 6c 64 29 0d 0a 53 48 |st,child|fld)..SH|
|00003720| 4f 57 20 47 45 54 53 0d | 0a 00 00 00 00 00 00 01 |OW GETS.|........|
|00003730| 00 00 00 17 22 46 69 65 | 6c 64 20 69 6e 20 4f 74 |...."Fie|ld in Ot|
|00003740| 68 65 72 20 54 61 62 6c | 65 3a 22 00 00 00 00 00 |her Tabl|e:".....|
|00003750| 01 00 00 00 16 22 46 69 | 65 6c 64 20 69 6e 20 54 |....."Fi|eld in T|
|00003760| 68 69 73 20 54 61 62 6c | 65 3a 22 00 00 00 00 00 |his Tabl|e:".....|
|00003770| 00 01 00 00 00 2d 22 48 | 6f 77 20 69 73 20 54 68 |.....-"H|ow is Th|
|00003780| 69 73 20 54 61 62 6c 65 | 20 52 65 6c 61 74 65 64 |is Table| Related|
|00003790| 20 74 6f 20 41 6e 6f 74 | 68 65 72 20 54 61 62 6c | to Anot|her Tabl|
|000037a0| 65 3f 22 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |e?".....|........|
|000037b0| 00 00 00 01 00 00 00 09 | 6d 2e 6f 6b 63 61 6e 63 |........|m.okcanc|
|000037c0| 6c 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |l.......|........|
|000037d0| 00 00 00 00 01 00 00 00 | 18 22 40 2a 48 4e 20 5c |........|."@*HN \|
|000037e0| 21 5c 3c 4f 4b 3b 5c 3f | 5c 3c 43 61 6e 63 65 6c |!\<OK;\?|\<Cancel|
|000037f0| 22 00 00 00 00 01 00 00 | 05 b4 2a 20 53 74 72 69 |".......|..* Stri|
|00003800| 70 20 6f 66 66 20 74 68 | 65 20 74 79 70 65 20 64 |p off th|e type d|
|00003810| 65 73 69 67 6e 61 74 69 | 6f 6e 73 20 66 72 6f 6d |esignati|ons from|
|00003820| 20 66 69 65 6c 64 20 6e | 61 6d 65 73 0d 0a 6d 2e | field n|ames..m.|
|00003830| 70 66 6c 64 20 3d 20 6d | 2e 70 61 72 65 6e 74 66 |pfld = m|.parentf|
|00003840| 6c 64 0d 0a 6d 2e 63 66 | 6c 64 20 3d 20 6d 2e 63 |ld..m.cf|ld = m.c|
|00003850| 68 69 6c 64 66 6c 64 0d | 0a 49 46 20 41 54 28 27 |hildfld.|.IF AT('|
|00003860| 28 27 2c 6d 2e 70 61 72 | 65 6e 74 66 6c 64 29 20 |(',m.par|entfld) |
|00003870| 3e 20 30 0d 0a 20 20 20 | 6d 2e 70 61 72 65 6e 74 |> 0.. |m.parent|
|00003880| 66 6c 64 20 3d 20 41 4c | 4c 54 52 49 4d 28 53 55 |fld = AL|LTRIM(SU|
|00003890| 42 53 54 52 28 6d 2e 70 | 61 72 65 6e 74 66 6c 64 |BSTR(m.p|arentfld|
|000038a0| 2c 31 2c 4c 45 4e 28 54 | 52 49 4d 28 6d 2e 70 61 |,1,LEN(T|RIM(m.pa|
|000038b0| 72 65 6e 74 66 6c 64 29 | 29 2d 33 29 29 0d 0a 45 |rentfld)|)-3))..E|
|000038c0| 4e 44 49 46 0d 0a 49 46 | 20 41 54 28 27 28 27 2c |NDIF..IF| AT('(',|
|000038d0| 6d 2e 63 68 69 6c 64 66 | 6c 64 29 20 3e 20 30 0d |m.childf|ld) > 0.|
|000038e0| 0a 20 20 20 6d 2e 63 68 | 69 6c 64 66 6c 64 20 20 |. m.ch|ildfld |
|000038f0| 3d 20 41 4c 4c 54 52 49 | 4d 28 53 55 42 53 54 52 |= ALLTRI|M(SUBSTR|
|00003900| 28 6d 2e 63 68 69 6c 64 | 66 6c 64 2c 31 2c 4c 45 |(m.child|fld,1,LE|
|00003910| 4e 28 54 52 49 4d 28 6d | 2e 63 68 69 6c 64 66 6c |N(TRIM(m|.childfl|
|00003920| 64 29 29 2d 33 29 29 0d | 0a 45 4e 44 49 46 0d 0a |d))-3)).|.ENDIF..|
|00003930| 0d 0a 44 4f 20 43 41 53 | 45 0d 0a 43 41 53 45 20 |..DO CAS|E..CASE |
|00003940| 6d 2e 6f 6b 63 61 6e 63 | 6c 20 3d 20 31 0d 0a 20 |m.okcanc|l = 1.. |
|00003950| 20 20 2a 20 4d 61 6b 65 | 20 73 75 72 65 20 74 68 | * Make| sure th|
|00003960| 69 73 20 69 73 20 61 20 | 76 61 6c 69 64 20 73 65 |is is a |valid se|
|00003970| 6c 65 63 74 69 6f 6e 20 | 77 69 74 68 20 72 65 73 |lection |with res|
|00003980| 70 65 63 74 20 74 6f 20 | 64 61 74 61 20 74 79 70 |pect to |data typ|
|00003990| 65 0d 0a 20 20 20 44 4f | 20 43 41 53 45 0d 0a 20 |e.. DO| CASE.. |
|000039a0| 20 20 43 41 53 45 20 54 | 59 50 45 28 6d 2e 63 68 | CASE T|YPE(m.ch|
|000039b0| 69 6c 64 66 6c 64 29 20 | 3d 20 27 55 27 0d 0a 20 |ildfld) |= 'U'.. |
|000039c0| 20 20 20 20 20 57 41 49 | 54 20 57 49 4e 44 4f 57 | WAI|T WINDOW|
|000039d0| 20 22 54 68 65 20 63 68 | 69 6c 64 20 64 61 74 61 | "The ch|ild data|
|000039e0| 62 61 73 65 20 63 6f 75 | 6c 64 20 6e 6f 74 20 62 |base cou|ld not b|
|000039f0| 65 20 66 6f 75 6e 64 2e | 22 0d 0a 20 20 20 43 41 |e found.|".. CA|
|00003a00| 53 45 20 54 59 50 45 28 | 6d 2e 70 61 72 65 6e 74 |SE TYPE(|m.parent|
|00003a10| 66 6c 64 29 20 3d 20 27 | 55 27 0d 0a 20 20 20 20 |fld) = '|U'.. |
|00003a20| 20 20 57 41 49 54 20 57 | 49 4e 44 4f 57 20 22 54 | WAIT W|INDOW "T|
|00003a30| 68 65 20 70 61 72 65 6e | 74 20 64 61 74 61 62 61 |he paren|t databa|
|00003a40| 73 65 20 63 6f 75 6c 64 | 20 6e 6f 74 20 62 65 20 |se could| not be |
|00003a50| 66 6f 75 6e 64 2e 22 0d | 0a 20 20 20 43 41 53 45 |found.".|. CASE|
|00003a60| 20 54 59 50 45 28 6d 2e | 63 68 69 6c 64 66 6c 64 | TYPE(m.|childfld|
|00003a70| 29 20 3d 3d 20 54 59 50 | 45 28 6d 2e 70 61 72 65 |) == TYP|E(m.pare|
|00003a80| 6e 74 66 6c 64 29 0d 0a | 20 20 20 20 20 20 6d 2e |ntfld)..| m.|
|00003a90| 64 62 66 70 61 72 74 20 | 20 20 3d 20 53 55 42 53 |dbfpart | = SUBS|
|00003aa0| 54 52 28 6d 2e 63 68 69 | 6c 64 66 6c 64 2c 31 2c |TR(m.chi|ldfld,1,|
|00003ab0| 41 54 28 27 2e 27 2c 6d | 2e 63 68 69 6c 64 66 6c |AT('.',m|.childfl|
|00003ac0| 64 29 2d 31 29 0d 0a 20 | 20 20 20 20 20 6d 2e 72 |d)-1).. | m.r|
|00003ad0| 65 6c 73 74 72 20 20 20 | 20 3d 20 27 53 45 54 20 |elstr | = 'SET |
|00003ae0| 52 45 4c 41 54 49 4f 4e | 20 54 4f 20 27 3b 0d 0a |RELATION| TO ';..|
|00003af0| 20 20 20 20 20 20 20 20 | 20 2b 53 55 42 53 54 52 | | +SUBSTR|
|00003b00| 28 6d 2e 70 61 72 65 6e | 74 66 6c 64 2c 41 54 28 |(m.paren|tfld,AT(|
|00003b10| 27 2e 27 2c 6d 2e 70 61 | 72 65 6e 74 66 6c 64 29 |'.',m.pa|rentfld)|
|00003b20| 2b 31 29 3b 0d 0a 20 20 | 20 20 20 20 20 20 20 2b |+1);.. | +|
|00003b30| 27 20 49 4e 54 4f 20 27 | 2b 6d 2e 64 62 66 70 61 |' INTO '|+m.dbfpa|
|00003b40| 72 74 0d 0a 20 20 20 20 | 20 20 6d 2e 70 61 72 65 |rt.. | m.pare|
|00003b50| 6e 74 64 62 66 20 3d 20 | 53 55 42 53 54 52 28 6d |ntdbf = |SUBSTR(m|
|00003b60| 2e 70 61 72 65 6e 74 66 | 6c 64 2c 31 2c 41 54 28 |.parentf|ld,1,AT(|
|00003b70| 27 2e 27 2c 6d 2e 70 61 | 72 65 6e 74 66 6c 64 29 |'.',m.pa|rentfld)|
|00003b80| 2d 31 29 0d 0a 20 20 20 | 20 20 20 43 4c 45 41 52 |-1).. | CLEAR|
|00003b90| 20 52 45 41 44 0d 0a 20 | 20 20 4f 54 48 45 52 57 | READ.. | OTHERW|
|00003ba0| 49 53 45 0d 0a 20 20 20 | 20 20 20 57 41 49 54 20 |ISE.. | WAIT |
|00003bb0| 57 49 4e 44 4f 57 20 22 | 50 61 72 65 6e 74 20 61 |WINDOW "|Parent a|
|00003bc0| 6e 64 20 63 68 69 6c 64 | 20 68 61 76 65 20 64 69 |nd child| have di|
|00003bd0| 66 66 65 72 65 6e 74 20 | 64 61 74 61 20 74 79 70 |fferent |data typ|
|00003be0| 65 73 2e 22 0d 0a 20 20 | 20 20 20 20 2a 20 52 65 |es.".. | * Re|
|00003bf0| 73 74 6f 72 65 20 66 75 | 6c 6c 20 73 74 72 69 6e |store fu|ll strin|
|00003c00| 67 20 74 6f 20 70 61 72 | 65 6e 74 20 61 6e 64 20 |g to par|ent and |
|00003c10| 63 68 69 6c 64 20 66 69 | 65 6c 64 73 0d 0a 20 20 |child fi|elds.. |
|00003c20| 20 20 20 20 6d 2e 70 61 | 72 65 6e 74 66 6c 64 20 | m.pa|rentfld |
|00003c30| 3d 20 6d 2e 70 66 6c 64 | 0d 0a 20 20 20 20 20 20 |= m.pfld|.. |
|00003c40| 6d 2e 63 68 69 6c 64 66 | 6c 64 20 20 3d 20 6d 2e |m.childf|ld = m.|
|00003c50| 63 66 6c 64 0d 0a 20 20 | 20 45 4e 44 43 41 53 45 |cfld.. | ENDCASE|
|00003c60| 0d 0a 43 41 53 45 20 6d | 2e 6f 6b 63 61 6e 63 6c |..CASE m|.okcancl|
|00003c70| 20 3d 20 32 20 20 20 20 | 20 26 26 20 63 61 6e 63 | = 2 | && canc|
|00003c80| 65 6c 20 74 68 69 73 20 | 72 65 6c 61 74 69 6f 6e |el this |relation|
|00003c90| 73 68 69 70 0d 0a 20 20 | 20 2a 20 57 65 20 6f 70 |ship.. | * We op|
|00003ca0| 65 6e 65 64 20 63 68 69 | 6c 64 73 74 65 6d 20 69 |ened chi|ldstem i|
|00003cb0| 6e 20 74 68 65 20 73 65 | 74 75 70 20 73 6e 69 70 |n the se|tup snip|
|00003cc0| 70 65 74 2e 20 20 43 6c | 6f 73 65 20 69 74 20 6e |pet. Cl|ose it n|
|00003cd0| 6f 77 2e 0d 0a 20 20 20 | 49 46 20 6d 2e 61 64 64 |ow... |IF m.add|
|00003ce0| 6d 6f 64 65 20 41 4e 44 | 20 55 53 45 44 28 6d 2e |mode AND| USED(m.|
|00003cf0| 63 68 69 6c 64 73 74 65 | 6d 29 0d 0a 20 20 20 20 |childste|m).. |
|00003d00| 20 20 53 45 4c 45 43 54 | 20 28 6d 2e 63 68 69 6c | SELECT| (m.chil|
|00003d10| 64 73 74 65 6d 29 0d 0a | 20 20 20 20 20 20 55 53 |dstem)..| US|
|00003d20| 45 0d 0a 20 20 20 45 4e | 44 49 46 0d 0a 20 20 20 |E.. EN|DIF.. |
|00003d30| 6d 2e 64 62 66 70 61 72 | 74 20 20 20 3d 20 27 27 |m.dbfpar|t = ''|
|00003d40| 0d 0a 20 20 20 6d 2e 63 | 68 69 6c 64 66 6c 64 20 |.. m.c|hildfld |
|00003d50| 20 3d 20 27 27 0d 0a 20 | 20 20 6d 2e 63 68 69 6c | = ''.. | m.chil|
|00003d60| 64 64 62 66 20 20 3d 20 | 27 27 0d 0a 20 20 20 6d |ddbf = |''.. m|
|00003d70| 2e 72 65 6c 73 74 72 20 | 20 20 20 3d 20 27 27 0d |.relstr | = ''.|
|00003d80| 0a 20 20 20 6d 2e 70 61 | 72 65 6e 74 64 62 66 20 |. m.pa|rentdbf |
|00003d90| 3d 20 27 27 0d 0a 20 20 | 20 43 4c 45 41 52 20 52 |= ''.. | CLEAR R|
|00003da0| 45 41 44 0d 0a 45 4e 44 | 43 41 53 45 0d 0a 00 00 |EAD..END|CASE....|
|00003db0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003dc0| 00 00 01 00 00 00 04 22 | 4f 4b 22 00 00 00 00 00 |......."|OK".....|
|00003dd0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003de0| 00 00 00 01 00 00 00 08 | 6d 2e 61 64 76 62 75 74 |........|m.advbut|
|00003df0| fd 07 fc f8 01 03 fd 16 | 10 fc fb 00 00 fd fe 19 |........|........|
|00003e00| 00 00 00 00 01 00 00 00 | 14 22 40 2a 48 4e 20 5c |........|."@*HN \|
|00003e10| 3c 41 64 76 61 6e 63 65 | 64 2e 2e 2e 22 00 00 00 |<Advance|d..."...|
|00003e20| 00 00 00 00 00 01 00 00 | 00 3c 44 4f 20 63 61 73 |........|.<DO cas|
|00003e30| 63 64 6c 67 2e 73 70 72 | 20 57 49 54 48 20 64 62 |cdlg.spr| WITH db|
|00003e40| 66 6c 69 73 74 5b 6d 2e | 6e 65 78 74 64 62 66 2c |flist[m.|nextdbf,|
|00003e50| 6d 2e 63 73 74 65 6d 6e | 75 6d 5d 0d 0a 0d 0a 20 |m.cstemn|um].... |
|00003e60| 20 20 0d 0a 0d 0a 00 00 | 00 00 00 00 00 00 00 00 | ......|........|
|00003e70| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003e80| 00 00 00 00 00 00 00 00 | 01 00 00 00 0d 22 41 64 |........|....."Ad|
|00003e90| 76 61 6e 63 65 64 2e 2e | 2e 22 00 00 00 00 00 00 |vanced..|."......|
|00003ea0| 00 00 00 00 00 00 00 00 | 00 01 00 00 00 08 52 45 |........|......RE|
|00003eb0| 4c 53 45 4c 45 43 00 00 | 00 00 00 00 00 00 00 00 |LSELEC..|........|
|00003ec0| 00 00 00 00 00 00 00 00 | 00 00 01 00 00 00 16 22 |........|......."|
|00003ed0| 4f 70 74 69 6f 6e 73 20 | 66 6f 72 20 26 74 68 69 |Options |for &thi|
|00003ee0| 73 64 62 66 22 00 00 00 | 00 00 00 01 00 00 00 06 |sdbf"...|........|
|00003ef0| 47 65 6e 65 76 61 00 00 | 00 00 00 00 00 00 00 00 |Geneva..|........|
|00003f00| 00 00 00 00 00 00 00 00 | 00 00 00 00 01 00 00 00 |........|........|
|00003f10| c5 49 46 20 45 4d 50 54 | 59 28 6d 2e 70 61 72 65 |.IF EMPT|Y(m.pare|
|00003f20| 6e 74 66 6c 64 29 20 3b | 0d 0a 20 20 20 20 20 20 |ntfld) ;|.. |
|00003f30| 4f 52 20 4c 45 46 54 28 | 6d 2e 70 61 72 65 6e 74 |OR LEFT(|m.parent|
|00003f40| 66 6c 64 2c 31 29 20 3d | 20 27 5c 27 20 3b 0d 0a |fld,1) =| '\' ;..|
|00003f50| 20 20 20 20 20 20 4f 52 | 20 28 67 65 74 74 79 70 | OR| (gettyp|
|00003f60| 65 28 6d 2e 70 61 72 65 | 6e 74 66 6c 64 29 20 21 |e(m.pare|ntfld) !|
|00003f70| 3d 20 67 65 74 74 79 70 | 65 28 6d 2e 63 68 69 6c |= gettyp|e(m.chil|
|00003f80| 64 66 6c 64 29 29 0d 0a | 20 20 20 53 48 4f 57 20 |dfld))..| SHOW |
|00003f90| 47 45 54 20 6d 2e 6f 6b | 63 61 6e 63 6c 2c 31 20 |GET m.ok|cancl,1 |
|00003fa0| 44 49 53 41 42 4c 45 0d | 0a 45 4c 53 45 0d 0a 20 |DISABLE.|.ELSE.. |
|00003fb0| 20 20 53 48 4f 57 20 47 | 45 54 20 6d 2e 6f 6b 63 | SHOW G|ET m.okc|
|00003fc0| 61 6e 63 6c 2c 31 20 45 | 4e 41 42 4c 45 0d 0a 45 |ancl,1 E|NABLE..E|
|00003fd0| 4e 44 49 46 0d 0a 00 00 | 00 00 00 00 00 00 00 00 |NDIF....|........|
|00003fe0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003ff0| 00 00 00 01 00 00 06 e7 | 0d 0a 2a 21 2a 2a 2a 2a |........|..*!****|
|00004000| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00004010| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00004020| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00004030| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 0d 0a 2a |********|*****..*|
|00004040| 21 0d 0a 2a 21 20 20 20 | 20 20 20 50 72 6f 63 65 |!..*! | Proce|
|00004050| 64 75 72 65 3a 20 41 44 | 44 54 59 50 45 0d 0a 2a |dure: AD|DTYPE..*|
|00004060| 21 0d 0a 2a 21 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |!..*!***|********|
|00004070| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00004080| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00004090| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|000040a0| 2a 2a 2a 2a 2a 2a 0d 0a | 46 55 4e 43 54 49 4f 4e |******..|FUNCTION|
|000040b0| 20 61 64 64 74 79 70 65 | 0d 0a 2a 20 41 64 64 20 | addtype|..* Add |
|000040c0| 74 68 65 20 64 61 74 61 | 20 74 79 70 65 20 74 6f |the data| type to|
|000040d0| 20 61 20 66 69 65 6c 64 | 20 6e 61 6d 65 0d 0a 50 | a field| name..P|
|000040e0| 41 52 41 4d 45 54 45 52 | 20 66 6c 64 6e 61 6d 65 |ARAMETER| fldname|
|000040f0| 0d 0a 0d 0a 49 46 20 21 | 45 4d 50 54 59 28 6d 2e |....IF !|EMPTY(m.|
|00004100| 66 6c 64 6e 61 6d 65 29 | 0d 0a 20 20 20 52 45 54 |fldname)|.. RET|
|00004110| 55 52 4e 20 50 41 44 52 | 28 6d 2e 66 6c 64 6e 61 |URN PADR|(m.fldna|
|00004120| 6d 65 2c 32 30 29 20 2b | 20 27 28 27 20 2b 20 54 |me,20) +| '(' + T|
|00004130| 59 50 45 28 6d 2e 66 6c | 64 6e 61 6d 65 29 20 2b |YPE(m.fl|dname) +|
|00004140| 20 27 29 27 0d 0a 45 4c | 53 45 0d 0a 20 20 20 52 | ')'..EL|SE.. R|
|00004150| 45 54 55 52 4e 20 27 27 | 0d 0a 45 4e 44 49 46 0d |ETURN ''|..ENDIF.|
|00004160| 0a 0d 0a 0d 0a 2a 21 2a | 2a 2a 2a 2a 2a 2a 2a 2a |.....*!*|********|
|00004170| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00004180| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00004190| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|000041a0| 2a 2a 2a 2a 2a 2a 2a 2a | 0d 0a 2a 21 0d 0a 2a 21 |********|..*!..*!|
|000041b0| 20 20 20 20 20 20 50 72 | 6f 63 65 64 75 72 65 3a | Pr|ocedure:|
|000041c0| 20 47 45 54 54 59 50 45 | 0d 0a 2a 21 0d 0a 2a 21 | GETTYPE|..*!..*!|
|000041d0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|000041e0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|000041f0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00004200| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00004210| 2a 0d 0a 46 55 4e 43 54 | 49 4f 4e 20 67 65 74 74 |*..FUNCT|ION gett|
|00004220| 79 70 65 0d 0a 50 41 52 | 41 4d 45 54 45 52 20 6d |ype..PAR|AMETER m|
|00004230| 2e 66 6c 64 6e 61 6d 65 | 0d 0a 50 52 49 56 41 54 |.fldname|..PRIVAT|
|00004240| 45 20 6d 2e 72 65 74 76 | 61 6c 0d 0a 2a 20 54 68 |E m.retv|al..* Th|
|00004250| 69 73 20 66 75 6e 63 74 | 69 6f 6e 20 65 78 74 72 |is funct|ion extr|
|00004260| 61 63 74 73 20 74 68 65 | 20 64 61 74 61 20 74 79 |acts the| data ty|
|00004270| 70 65 20 66 72 6f 6d 20 | 74 68 65 20 66 6f 72 6d |pe from |the form|
|00004280| 61 74 20 75 73 65 64 20 | 69 6e 0d 0a 2a 20 74 68 |at used |in..* th|
|00004290| 65 20 70 61 72 65 6e 74 | 6c 69 73 74 20 61 6e 64 |e parent|list and|
|000042a0| 20 63 68 69 6c 64 6c 69 | 73 74 20 61 72 72 61 79 | childli|st array|
|000042b0| 73 2e 20 20 54 68 65 20 | 69 6e 63 6f 6d 69 6e 67 |s. The |incoming|
|000042c0| 20 66 6f 72 6d 61 74 20 | 6c 6f 6f 6b 73 0d 0a 2a | format |looks..*|
|000042d0| 20 6c 69 6b 65 3a 0d 0a | 2a 20 20 20 20 20 20 20 | like:..|* |
|000042e0| 20 44 42 46 41 4c 49 41 | 53 2e 46 49 45 4c 44 20 | DBFALIA|S.FIELD |
|000042f0| 20 20 20 20 20 28 43 29 | 0d 0a 2a 0d 0a 2a 20 54 | (C)|..*..* T|
|00004300| 68 65 20 66 75 6e 63 74 | 69 6f 6e 20 72 65 74 75 |he funct|ion retu|
|00004310| 72 6e 73 20 27 43 27 0d | 0a 0d 0a 6d 2e 72 65 74 |rns 'C'.|...m.ret|
|00004320| 76 61 6c 20 3d 20 52 49 | 47 48 54 28 54 52 49 4d |val = RI|GHT(TRIM|
|00004330| 28 6d 2e 66 6c 64 6e 61 | 6d 65 29 2c 33 29 0d 0a |(m.fldna|me),3)..|
|00004340| 6d 2e 72 65 74 76 61 6c | 20 3d 20 55 50 50 45 52 |m.retval| = UPPER|
|00004350| 28 41 4c 4c 54 52 49 4d | 28 6d 2e 72 65 74 76 61 |(ALLTRIM|(m.retva|
|00004360| 6c 29 29 0d 0a 52 45 54 | 55 52 4e 20 43 48 52 54 |l))..RET|URN CHRT|
|00004370| 52 41 4e 28 6d 2e 72 65 | 74 76 61 6c 2c 27 28 29 |RAN(m.re|tval,'()|
|00004380| 27 2c 27 27 29 0d 0a 0d | 0a 2a 21 2a 2a 2a 2a 2a |','')...|.*!*****|
|00004390| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|000043a0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|000043b0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|000043c0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 0d 0a 2a 21 |********|****..*!|
|000043d0| 0d 0a 2a 21 20 20 20 20 | 20 20 50 72 6f 63 65 64 |..*! | Proced|
|000043e0| 75 72 65 3a 20 43 44 49 | 53 4c 49 53 54 0d 0a 2a |ure: CDI|SLIST..*|
|000043f0| 21 0d 0a 2a 21 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |!..*!***|********|
|00004400| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00004410| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00004420| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00004430| 2a 2a 2a 2a 2a 2a 0d 0a | 50 52 4f 43 45 44 55 52 |******..|PROCEDUR|
|00004440| 45 20 63 64 69 73 6c 69 | 73 74 0d 0a 2a 20 54 68 |E cdisli|st..* Th|
|00004450| 69 73 20 70 72 6f 63 65 | 64 75 72 65 20 64 69 73 |is proce|dure dis|
|00004460| 61 62 6c 65 73 20 66 69 | 65 6c 64 73 20 69 6e 20 |ables fi|elds in |
|00004470| 74 68 65 20 70 61 72 65 | 6e 74 20 6c 69 73 74 20 |the pare|nt list |
|00004480| 74 68 61 74 20 68 61 76 | 65 20 61 20 64 69 66 66 |that hav|e a diff|
|00004490| 65 72 65 6e 74 0d 0a 2a | 20 74 79 70 65 20 66 72 |erent..*| type fr|
|000044a0| 6f 6d 20 74 68 65 20 63 | 75 72 72 65 6e 74 20 66 |om the c|urrent f|
|000044b0| 69 65 6c 64 20 69 6e 20 | 74 68 65 20 63 68 69 6c |ield in |the chil|
|000044c0| 64 20 6c 69 73 74 0d 0a | 0d 0a 50 41 52 41 4d 45 |d list..|..PARAME|
|000044d0| 54 45 52 20 63 75 72 69 | 74 65 6d 0d 0a 50 52 49 |TER curi|tem..PRI|
|000044e0| 56 41 54 45 20 6d 2e 63 | 75 72 69 74 65 6d 2c 20 |VATE m.c|uritem, |
|000044f0| 6d 2e 73 6f 75 72 63 65 | 74 79 70 65 2c 20 6d 2e |m.source|type, m.|
|00004500| 74 61 72 67 74 79 70 65 | 2c 20 6d 2e 69 0d 0a 0d |targtype|, m.i...|
|00004510| 0a 49 46 20 6d 2e 63 75 | 72 69 74 65 6d 20 3c 3d |.IF m.cu|ritem <=|
|00004520| 20 30 0d 0a 20 20 20 6d | 2e 63 75 72 69 74 65 6d | 0.. m|.curitem|
|00004530| 20 3d 20 31 0d 0a 45 4e | 44 49 46 0d 0a 0d 0a 6d | = 1..EN|DIF....m|
|00004540| 2e 73 6f 75 72 63 65 74 | 79 70 65 20 3d 20 67 65 |.sourcet|ype = ge|
|00004550| 74 74 79 70 65 28 63 68 | 69 6c 64 6c 69 73 74 5b |ttype(ch|ildlist[|
|00004560| 6d 2e 63 75 72 69 74 65 | 6d 5d 29 0d 0a 0d 0a 46 |m.curite|m])....F|
|00004570| 4f 52 20 6d 2e 69 20 3d | 20 31 20 54 4f 20 41 4c |OR m.i =| 1 TO AL|
|00004580| 45 4e 28 70 61 72 65 6e | 74 6c 69 73 74 29 0d 0a |EN(paren|tlist)..|
|00004590| 20 20 20 6d 2e 74 61 72 | 67 74 79 70 65 20 3d 20 | m.tar|gtype = |
|000045a0| 67 65 74 74 79 70 65 28 | 70 61 72 65 6e 74 6c 69 |gettype(|parentli|
|000045b0| 73 74 5b 6d 2e 69 5d 29 | 0d 0a 20 20 20 49 46 20 |st[m.i])|.. IF |
|000045c0| 6d 2e 73 6f 75 72 63 65 | 74 79 70 65 20 3d 3d 20 |m.source|type == |
|000045d0| 6d 2e 74 61 72 67 74 79 | 70 65 0d 0a 20 20 20 20 |m.targty|pe.. |
|000045e0| 20 20 49 46 20 4c 45 46 | 54 28 70 61 72 65 6e 74 | IF LEF|T(parent|
|000045f0| 6c 69 73 74 5b 6d 2e 69 | 5d 2c 31 29 20 3d 20 27 |list[m.i|],1) = '|
|00004600| 5c 27 0d 0a 20 20 20 20 | 20 20 20 20 20 70 61 72 |\'.. | par|
|00004610| 65 6e 74 6c 69 73 74 5b | 6d 2e 69 5d 20 3d 20 53 |entlist[|m.i] = S|
|00004620| 55 42 53 54 52 28 70 61 | 72 65 6e 74 6c 69 73 74 |UBSTR(pa|rentlist|
|00004630| 5b 6d 2e 69 5d 2c 32 29 | 0d 0a 20 20 20 20 20 20 |[m.i],2)|.. |
|00004640| 45 4e 44 49 46 0d 0a 20 | 20 20 45 4c 53 45 0d 0a |ENDIF.. | ELSE..|
|00004650| 20 20 20 20 20 20 49 46 | 20 4c 45 46 54 28 70 61 | IF| LEFT(pa|
|00004660| 72 65 6e 74 6c 69 73 74 | 5b 6d 2e 69 5d 2c 31 29 |rentlist|[m.i],1)|
|00004670| 20 3c 3e 20 27 5c 27 0d | 0a 20 20 20 20 20 20 20 | <> '\'.|. |
|00004680| 20 20 70 61 72 65 6e 74 | 6c 69 73 74 5b 6d 2e 69 | parent|list[m.i|
|00004690| 5d 20 3d 20 27 5c 27 2b | 70 61 72 65 6e 74 6c 69 |] = '\'+|parentli|
|000046a0| 73 74 5b 6d 2e 69 5d 0d | 0a 20 20 20 20 20 20 45 |st[m.i].|. E|
|000046b0| 4e 44 49 46 0d 0a 20 20 | 20 45 4e 44 49 46 0d 0a |NDIF.. | ENDIF..|
|000046c0| 45 4e 44 46 4f 52 0d 0a | 53 48 4f 57 20 47 45 54 |ENDFOR..|SHOW GET|
|000046d0| 20 70 61 72 65 6e 74 6c | 69 73 74 0d 0a 0d 0a 00 | parentl|ist.....|
|000046e0| 00 00 00 00 00 00 00 00 | 00 01 00 00 0d 44 23 54 |........|.....D#T|
|000046f0| 52 41 4e 20 53 4e 49 50 | 50 45 54 20 4f 4e 4c 59 |RAN SNIP|PET ONLY|
|00004700| 0d 0a 23 53 45 43 54 49 | 4f 4e 20 31 0d 0a 50 41 |..#SECTI|ON 1..PA|
|00004710| 52 41 4d 45 54 45 52 53 | 20 6d 2e 63 68 69 6c 64 |RAMETERS| m.child|
|00004720| 73 74 65 6d 2c 20 6d 2e | 63 68 69 6c 64 64 62 66 |stem, m.|childdbf|
|00004730| 2c 20 6d 2e 63 68 69 6c | 64 66 6c 64 2c 20 6d 2e |, m.chil|dfld, m.|
|00004740| 70 61 72 65 6e 74 66 6c | 64 2c 20 6d 2e 69 67 6e |parentfl|d, m.ign|
|00004750| 63 61 73 65 2c 20 3b 0d | 0a 20 20 20 6d 2e 72 65 |case, ;.|. m.re|
|00004760| 6c 73 74 72 2c 20 6d 2e | 70 61 72 65 6e 74 64 62 |lstr, m.|parentdb|
|00004770| 66 2c 20 6d 2e 61 64 64 | 6d 6f 64 65 0d 0a 0d 0a |f, m.add|mode....|
|00004780| 50 52 49 56 41 54 45 20 | 6d 2e 69 67 6e 63 61 73 |PRIVATE |m.igncas|
|00004790| 65 2c 20 6d 2e 61 64 64 | 6d 6f 64 65 2c 20 6d 2e |e, m.add|mode, m.|
|000047a0| 69 2c 20 6d 2e 6a 2c 20 | 6d 2e 61 6c 5f 6e 61 6d |i, m.j, |m.al_nam|
|000047b0| 65 2c 20 6d 2e 74 68 69 | 73 64 62 66 2c 20 6d 2e |e, m.thi|sdbf, m.|
|000047c0| 64 6f 6e 65 2c 20 6d 2e | 69 6e 5f 61 72 65 61 0d |done, m.|in_area.|
|000047d0| 0a 0d 0a 2a 20 41 73 73 | 65 6d 62 6c 65 20 73 74 |...* Ass|emble st|
|000047e0| 72 69 6e 67 20 66 6f 72 | 20 64 69 61 6c 6f 67 20 |ring for| dialog |
|000047f0| 74 69 74 6c 65 0d 0a 6d | 2e 74 68 69 73 64 62 66 |title..m|.thisdbf|
|00004800| 20 3d 20 6a 75 73 74 66 | 6e 61 6d 65 28 6d 2e 63 | = justf|name(m.c|
|00004810| 68 69 6c 64 64 62 66 29 | 0d 0a 0d 0a 2a 20 61 64 |hilddbf)|....* ad|
|00004820| 64 6d 6f 64 65 20 64 65 | 74 65 72 6d 69 6e 65 73 |dmode de|termines|
|00004830| 20 69 66 20 77 65 20 61 | 72 65 20 61 64 64 69 6e | if we a|re addin|
|00004840| 67 20 61 20 6e 65 77 20 | 72 65 6c 61 74 69 6f 6e |g a new |relation|
|00004850| 73 68 69 70 20 6f 72 20 | 65 64 69 74 69 6e 67 0d |ship or |editing.|
|00004860| 0a 2a 20 61 6e 20 65 78 | 69 73 69 6e 67 20 6f 6e |.* an ex|ising on|
|00004870| 65 0d 0a 0d 0a 2a 20 53 | 74 61 72 74 20 77 69 74 |e....* S|tart wit|
|00004880| 68 20 6e 65 77 20 63 6f | 70 69 65 73 20 6f 66 20 |h new co|pies of |
|00004890| 74 68 65 20 6c 69 73 74 | 20 61 72 72 61 79 73 20 |the list| arrays |
|000048a0| 61 6e 64 20 72 65 6c 65 | 61 73 65 20 61 6e 79 20 |and rele|ase any |
|000048b0| 74 68 61 74 20 0d 0a 2a | 20 61 6c 72 65 61 64 79 |that ..*| already|
|000048c0| 20 65 78 69 73 74 0d 0a | 52 45 4c 45 41 53 45 20 | exist..|RELEASE |
|000048d0| 63 68 69 6c 64 6c 69 73 | 74 2c 20 70 61 72 65 6e |childlis|t, paren|
|000048e0| 74 6c 69 73 74 0d 0a 0d | 0a 23 53 45 43 54 49 4f |tlist...|.#SECTIO|
|000048f0| 4e 20 32 0d 0a 0d 0a 6d | 2e 69 6e 5f 61 72 65 61 |N 2....m|.in_area|
|00004900| 20 3d 20 53 45 4c 45 43 | 54 28 29 0d 0a 0d 0a 2a | = SELEC|T()....*|
|00004910| 20 4d 61 6b 65 20 73 75 | 72 65 20 63 68 69 6c 64 | Make su|re child|
|00004920| 20 64 61 74 61 62 61 73 | 65 20 65 78 69 73 74 73 | databas|e exists|
|00004930| 0d 0a 49 46 20 21 46 49 | 4c 45 28 6d 2e 63 68 69 |..IF !FI|LE(m.chi|
|00004940| 6c 64 64 62 66 29 0d 0a | 20 20 20 6d 2e 63 68 69 |lddbf)..| m.chi|
|00004950| 6c 64 64 62 66 20 3d 20 | 47 45 54 46 49 4c 45 28 |lddbf = |GETFILE(|
|00004960| 27 44 42 46 27 2c 27 50 | 6c 65 61 73 65 20 6c 6f |'DBF','P|lease lo|
|00004970| 63 61 74 65 20 74 68 65 | 20 27 2b 6a 75 73 74 73 |cate the| '+justs|
|00004980| 74 65 6d 28 6d 2e 63 68 | 69 6c 64 64 62 66 29 2b |tem(m.ch|ilddbf)+|
|00004990| 27 20 64 61 74 61 62 61 | 73 65 27 29 0d 0a 45 4e |' databa|se')..EN|
|000049a0| 44 49 46 0d 0a 49 46 20 | 45 4d 50 54 59 28 6d 2e |DIF..IF |EMPTY(m.|
|000049b0| 63 68 69 6c 64 64 62 66 | 29 20 4f 52 20 21 46 49 |childdbf|) OR !FI|
|000049c0| 4c 45 28 6d 2e 63 68 69 | 6c 64 64 62 66 29 0d 0a |LE(m.chi|lddbf)..|
|000049d0| 20 20 20 6d 2e 63 68 69 | 6c 64 64 62 66 20 3d 20 | m.chi|lddbf = |
|000049e0| 27 27 0d 0a 20 20 20 52 | 45 54 55 52 4e 0d 0a 45 |''.. R|ETURN..E|
|000049f0| 4e 44 49 46 0d 0a 0d 0a | 0d 0a 2a 20 46 69 6c 6c |NDIF....|..* Fill|
|00004a00| 20 69 6e 20 74 68 65 20 | 70 61 72 65 6e 74 6c 69 | in the |parentli|
|00004a10| 73 74 20 77 69 74 68 20 | 74 68 65 20 6e 61 6d 65 |st with |the name|
|00004a20| 73 20 6f 66 20 61 6c 6c | 20 66 69 65 6c 64 73 0d |s of all| fields.|
|00004a30| 0a 2a 20 20 20 69 6e 20 | 61 6c 6c 20 6f 70 65 6e |.* in |all open|
|00004a40| 20 64 61 74 61 62 61 73 | 65 73 0d 0a 6d 2e 70 61 | databas|es..m.pa|
|00004a50| 72 65 6e 74 72 6f 77 20 | 3d 20 30 0d 0a 44 49 4d |rentrow |= 0..DIM|
|00004a60| 45 4e 53 49 4f 4e 20 70 | 61 72 65 6e 74 6c 69 73 |ENSION p|arentlis|
|00004a70| 74 5b 31 5d 0d 0a 70 61 | 72 65 6e 74 6c 69 73 74 |t[1]..pa|rentlist|
|00004a80| 5b 31 5d 20 3d 20 22 22 | 0d 0a 46 4f 52 20 6d 2e |[1] = ""|..FOR m.|
|00004a90| 69 20 3d 20 31 20 54 4f | 20 32 35 0d 0a 20 20 20 |i = 1 TO| 25.. |
|00004aa0| 53 45 4c 45 43 54 20 28 | 6d 2e 69 29 0d 0a 20 20 |SELECT (|m.i).. |
|00004ab0| 20 49 46 20 21 45 4d 50 | 54 59 28 44 42 46 28 6d | IF !EMP|TY(DBF(m|
|00004ac0| 2e 69 29 29 20 41 4e 44 | 20 6d 61 6b 65 61 6c 69 |.i)) AND| makeali|
|00004ad0| 61 73 28 6a 75 73 74 73 | 74 65 6d 28 44 42 46 28 |as(justs|tem(DBF(|
|00004ae0| 6d 2e 69 29 29 29 20 3c | 3e 20 6d 61 6b 65 61 6c |m.i))) <|> makeal|
|00004af0| 69 61 73 28 6a 75 73 74 | 73 74 65 6d 28 6d 2e 63 |ias(just|stem(m.c|
|00004b00| 68 69 6c 64 73 74 65 6d | 29 29 0d 0a 20 20 20 20 |hildstem|)).. |
|00004b10| 20 20 46 4f 52 20 6d 2e | 6a 20 3d 20 31 20 54 4f | FOR m.|j = 1 TO|
|00004b20| 20 46 43 4f 55 4e 54 28 | 6d 2e 69 29 0d 0a 20 20 | FCOUNT(|m.i).. |
|00004b30| 20 20 20 20 20 20 20 6d | 2e 70 61 72 65 6e 74 72 | m|.parentr|
|00004b40| 6f 77 20 3d 20 6d 2e 70 | 61 72 65 6e 74 72 6f 77 |ow = m.p|arentrow|
|00004b50| 20 2b 20 31 0d 0a 20 20 | 20 20 20 20 20 20 20 44 | + 1.. | D|
|00004b60| 49 4d 45 4e 53 49 4f 4e | 20 70 61 72 65 6e 74 6c |IMENSION| parentl|
|00004b70| 69 73 74 5b 6d 2e 70 61 | 72 65 6e 74 72 6f 77 5d |ist[m.pa|rentrow]|
|00004b80| 0d 0a 20 20 20 20 20 20 | 20 20 20 70 61 72 65 6e |.. | paren|
|00004b90| 74 6c 69 73 74 5b 6d 2e | 70 61 72 65 6e 74 72 6f |tlist[m.|parentro|
|00004ba0| 77 5d 20 3d 20 61 64 64 | 74 79 70 65 28 41 4c 49 |w] = add|type(ALI|
|00004bb0| 41 53 28 6d 2e 69 29 2b | 27 2e 27 2b 46 49 45 4c |AS(m.i)+|'.'+FIEL|
|00004bc0| 44 28 6d 2e 6a 2c 6d 2e | 69 29 29 0d 0a 20 20 20 |D(m.j,m.|i)).. |
|00004bd0| 20 20 20 45 4e 44 46 4f | 52 0d 0a 20 20 20 45 4e | ENDFO|R.. EN|
|00004be0| 44 49 46 0d 0a 45 4e 44 | 46 4f 52 0d 0a 0d 0a 0d |DIF..END|FOR.....|
|00004bf0| 0a 2a 20 46 69 6c 6c 20 | 69 6e 20 74 68 65 20 63 |.* Fill |in the c|
|00004c00| 68 69 6c 64 6c 69 73 74 | 20 77 69 74 68 20 74 68 |hildlist| with th|
|00004c10| 65 20 6e 61 6d 65 73 20 | 6f 66 20 61 6c 6c 20 66 |e names |of all f|
|00004c20| 69 65 6c 64 73 0d 0a 2a | 20 20 20 69 6e 20 74 68 |ields..*| in th|
|00004c30| 65 20 63 68 69 6c 64 20 | 64 61 74 61 62 61 73 65 |e child |database|
|00004c40| 0d 0a 6d 2e 63 68 69 6c | 64 72 6f 77 20 3d 20 30 |..m.chil|drow = 0|
|00004c50| 0d 0a 44 49 4d 45 4e 53 | 49 4f 4e 20 63 68 69 6c |..DIMENS|ION chil|
|00004c60| 64 6c 69 73 74 5b 31 5d | 0d 0a 63 68 69 6c 64 6c |dlist[1]|..childl|
|00004c70| 69 73 74 28 31 29 20 3d | 20 22 22 0d 0a 49 46 20 |ist(1) =| ""..IF |
|00004c80| 55 53 45 44 28 6d 61 6b | 65 61 6c 69 61 73 28 6d |USED(mak|ealias(m|
|00004c90| 2e 63 68 69 6c 64 73 74 | 65 6d 29 29 0d 0a 20 20 |.childst|em)).. |
|00004ca0| 20 6d 2e 61 6c 5f 6e 61 | 6d 65 20 3d 20 6d 61 6b | m.al_na|me = mak|
|00004cb0| 65 61 6c 69 61 73 28 6d | 2e 63 68 69 6c 64 73 74 |ealias(m|.childst|
|00004cc0| 65 6d 29 0d 0a 20 20 20 | 53 45 4c 45 43 54 20 28 |em).. |SELECT (|
|00004cd0| 6d 2e 61 6c 5f 6e 61 6d | 65 29 0d 0a 45 4c 53 45 |m.al_nam|e)..ELSE|
|00004ce0| 0d 0a 20 20 20 53 45 4c | 45 43 54 20 30 0d 0a 20 |.. SEL|ECT 0.. |
|00004cf0| 20 20 55 53 45 20 28 6d | 2e 63 68 69 6c 64 64 62 | USE (m|.childdb|
|00004d00| 66 29 0d 0a 45 4e 44 49 | 46 0d 0a 46 4f 52 20 6d |f)..ENDI|F..FOR m|
|00004d10| 2e 6a 20 3d 20 31 20 54 | 4f 20 46 43 4f 55 4e 54 |.j = 1 T|O FCOUNT|
|00004d20| 28 29 0d 0a 20 20 20 49 | 46 20 54 59 50 45 28 46 |().. I|F TYPE(F|
|00004d30| 49 45 4c 44 28 6d 2e 6a | 29 29 20 3c 3e 20 22 4d |IELD(m.j|)) <> "M|
|00004d40| 22 0d 0a 20 20 20 20 20 | 20 6d 2e 63 68 69 6c 64 |".. | m.child|
|00004d50| 72 6f 77 20 3d 20 6d 2e | 63 68 69 6c 64 72 6f 77 |row = m.|childrow|
|00004d60| 20 2b 20 31 0d 0a 20 20 | 20 20 20 20 44 49 4d 45 | + 1.. | DIME|
|00004d70| 4e 53 49 4f 4e 20 63 68 | 69 6c 64 6c 69 73 74 5b |NSION ch|ildlist[|
|00004d80| 6d 2e 63 68 69 6c 64 72 | 6f 77 5d 0d 0a 20 20 20 |m.childr|ow].. |
|00004d90| 20 20 20 63 68 69 6c 64 | 6c 69 73 74 5b 6d 2e 63 | child|list[m.c|
|00004da0| 68 69 6c 64 72 6f 77 5d | 20 3d 20 61 64 64 74 79 |hildrow]| = addty|
|00004db0| 70 65 28 41 4c 49 41 53 | 28 29 2b 27 2e 27 2b 46 |pe(ALIAS|()+'.'+F|
|00004dc0| 49 45 4c 44 28 6d 2e 6a | 29 29 0d 0a 20 20 20 45 |IELD(m.j|)).. E|
|00004dd0| 4e 44 49 46 0d 0a 45 4e | 44 46 4f 52 0d 0a 0d 0a |NDIF..EN|DFOR....|
|00004de0| 2a 20 50 6f 73 69 74 69 | 6f 6e 20 73 65 6c 65 63 |* Positi|on selec|
|00004df0| 74 69 6f 6e 20 62 61 72 | 73 20 6f 6e 74 6f 20 69 |tion bar|s onto i|
|00004e00| 6e 74 65 6c 6c 69 67 65 | 6e 74 20 64 65 66 61 75 |ntellige|nt defau|
|00004e10| 6c 74 73 2e 20 20 54 72 | 79 20 74 6f 20 6d 61 74 |lts. Tr|y to mat|
|00004e20| 63 68 0d 0a 2a 20 66 69 | 65 6c 64 20 6e 61 6d 65 |ch..* fi|eld name|
|00004e30| 73 20 62 65 74 77 65 65 | 6e 20 74 68 65 20 70 61 |s betwee|n the pa|
|00004e40| 72 65 6e 74 20 61 6e 64 | 20 63 68 69 6c 64 20 64 |rent and| child d|
|00004e50| 61 74 61 62 61 73 65 73 | 2e 0d 0a 6d 2e 64 6f 6e |atabases|...m.don|
|00004e60| 65 20 3d 20 2e 46 2e 0d | 0a 49 46 20 45 4d 50 54 |e = .F..|.IF EMPT|
|00004e70| 59 28 6d 2e 70 61 72 65 | 6e 74 66 6c 64 29 0d 0a |Y(m.pare|ntfld)..|
|00004e80| 20 20 20 49 46 20 45 4d | 50 54 59 28 6d 2e 63 68 | IF EM|PTY(m.ch|
|00004e90| 69 6c 64 66 6c 64 29 0d | 0a 20 20 20 20 20 20 2a |ildfld).|. *|
|00004ea0| 20 53 65 65 20 69 66 20 | 74 68 65 72 65 20 61 72 | See if |there ar|
|00004eb0| 65 20 61 6e 79 20 66 69 | 65 6c 64 73 20 69 6e 20 |e any fi|elds in |
|00004ec0| 74 68 65 20 70 61 72 65 | 6e 74 20 64 61 74 61 62 |the pare|nt datab|
|00004ed0| 61 73 65 20 77 69 74 68 | 0d 0a 20 20 20 20 20 20 |ase with|.. |
|00004ee0| 2a 20 74 68 65 20 73 61 | 6d 65 20 6e 61 6d 65 20 |* the sa|me name |
|00004ef0| 61 6e 64 20 74 79 70 65 | 20 61 73 20 61 20 66 69 |and type| as a fi|
|00004f00| 65 6c 64 20 69 6e 20 74 | 68 65 20 63 68 69 6c 64 |eld in t|he child|
|00004f10| 20 64 61 74 61 62 61 73 | 65 0d 0a 20 20 20 20 20 | databas|e.. |
|00004f20| 20 6d 2e 69 20 3d 20 31 | 0d 0a 20 20 20 20 20 20 | m.i = 1|.. |
|00004f30| 44 4f 20 57 48 49 4c 45 | 20 21 64 6f 6e 65 20 41 |DO WHILE| !done A|
|00004f40| 4e 44 20 6d 2e 69 20 3c | 3d 20 6d 2e 63 68 69 6c |ND m.i <|= m.chil|
|00004f50| 64 72 6f 77 0d 0a 20 20 | 20 20 20 20 20 20 20 6d |drow.. | m|
|00004f60| 2e 6e 65 77 63 68 69 6c | 64 20 20 3d 20 53 55 42 |.newchil|d = SUB|
|00004f70| 53 54 52 28 63 68 69 6c | 64 6c 69 73 74 5b 6d 2e |STR(chil|dlist[m.|
|00004f80| 69 5d 2c 41 54 28 27 2e | 27 2c 63 68 69 6c 64 6c |i],AT('.|',childl|
|00004f90| 69 73 74 5b 6d 2e 69 5d | 29 2b 31 29 0d 0a 20 20 |ist[m.i]|)+1).. |
|00004fa0| 20 20 20 20 20 20 20 6d | 2e 6e 65 77 63 68 69 6c | m|.newchil|
|00004fb0| 64 20 20 3d 20 43 48 52 | 54 52 41 4e 28 6d 2e 6e |d = CHR|TRAN(m.n|
|00004fc0| 65 77 63 68 69 6c 64 2c | 27 20 27 2c 27 27 29 0d |ewchild,|' ','').|
|00004fd0| 0a 20 20 20 20 20 20 20 | 20 20 6d 2e 6a 20 3d 20 |. | m.j = |
|00004fe0| 31 0d 0a 20 20 20 20 20 | 20 20 20 20 44 4f 20 57 |1.. | DO W|
|00004ff0| 48 49 4c 45 20 21 6d 2e | 64 6f 6e 65 20 41 4e 44 |HILE !m.|done AND|
|00005000| 20 6d 2e 6a 20 3c 3d 20 | 6d 2e 70 61 72 65 6e 74 | m.j <= |m.parent|
|00005010| 72 6f 77 0d 0a 20 20 20 | 20 20 20 20 20 20 20 20 |row.. | |
|00005020| 20 2a 20 41 73 73 65 6d | 62 6c 65 20 61 20 6e 65 | * Assem|ble a ne|
|00005030| 77 20 6e 61 6d 65 20 62 | 61 73 65 64 20 6f 6e 20 |w name b|ased on |
|00005040| 74 68 65 20 66 69 65 6c | 64 20 6e 61 6d 65 20 61 |the fiel|d name a|
|00005050| 6e 64 20 74 68 65 20 66 | 69 65 6c 64 20 74 79 70 |nd the f|ield typ|
|00005060| 65 0d 0a 20 20 20 20 20 | 20 20 20 20 20 20 20 2a |e.. | *|
|00005070| 20 54 68 65 20 70 61 72 | 65 6e 74 6c 69 73 74 20 | The par|entlist |
|00005080| 72 65 63 6f 72 64 73 20 | 6c 6f 6f 6b 20 6c 69 6b |records |look lik|
|00005090| 65 20 74 68 69 73 3a 0d | 0a 20 20 20 20 20 20 20 |e this:.|. |
|000050a0| 20 20 20 20 20 2a 20 20 | 20 20 61 6c 69 61 73 2e | * | alias.|
|000050b0| 66 6c 64 20 20 20 20 20 | 20 20 28 4e 29 0d 0a 20 |fld | (N).. |
|000050c0| 20 20 20 20 20 20 20 20 | 20 20 20 2a 20 22 4e 65 | | * "Ne|
|000050d0| 77 70 61 72 65 6e 74 22 | 20 6e 6f 77 20 6c 6f 6f |wparent"| now loo|
|000050e0| 6b 73 20 6c 69 6b 65 20 | 74 68 69 73 3a 0d 0a 20 |ks like |this:.. |
|000050f0| 20 20 20 20 20 20 20 20 | 20 20 20 2a 20 20 20 20 | | * |
|00005100| 20 66 6c 64 28 4e 29 0d | 0a 20 20 20 20 20 20 20 | fld(N).|. |
|00005110| 20 20 20 20 20 6d 2e 6e | 65 77 70 61 72 65 6e 74 | m.n|ewparent|
|00005120| 20 3d 20 53 55 42 53 54 | 52 28 70 61 72 65 6e 74 | = SUBST|R(parent|
|00005130| 6c 69 73 74 5b 6d 2e 6a | 5d 2c 41 54 28 27 2e 27 |list[m.j|],AT('.'|
|00005140| 2c 70 61 72 65 6e 74 6c | 69 73 74 5b 6d 2e 6a 5d |,parentl|ist[m.j]|
|00005150| 29 2b 31 29 0d 0a 20 20 | 20 20 20 20 20 20 20 20 |)+1).. | |
|00005160| 20 20 6d 2e 6e 65 77 70 | 61 72 65 6e 74 20 3d 20 | m.newp|arent = |
|00005170| 43 48 52 54 52 41 4e 28 | 6e 65 77 70 61 72 65 6e |CHRTRAN(|newparen|
|00005180| 74 2c 27 20 27 2c 27 27 | 29 0d 0a 0d 0a 20 20 20 |t,' ',''|).... |
|00005190| 20 20 20 20 20 20 20 20 | 20 49 46 20 6d 2e 6e 65 | | IF m.ne|
|000051a0| 77 70 61 72 65 6e 74 20 | 3d 3d 20 6d 2e 6e 65 77 |wparent |== m.new|
|000051b0| 63 68 69 6c 64 0d 0a 20 | 20 20 20 20 20 20 20 20 |child.. | |
|000051c0| 20 20 20 20 20 20 6d 2e | 70 61 72 65 6e 74 66 6c | m.|parentfl|
|000051d0| 64 20 3d 20 70 61 72 65 | 6e 74 6c 69 73 74 5b 6d |d = pare|ntlist[m|
|000051e0| 2e 6a 5d 0d 0a 20 20 20 | 20 20 20 20 20 20 20 20 |.j].. | |
|000051f0| 20 20 20 20 6d 2e 63 68 | 69 6c 64 66 6c 64 20 20 | m.ch|ildfld |
|00005200| 3d 20 63 68 69 6c 64 6c | 69 73 74 5b 6d 2e 69 5d |= childl|ist[m.i]|
|00005210| 0d 0a 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |.. | |
|00005220| 20 6d 2e 64 6f 6e 65 20 | 3d 20 2e 54 2e 0d 0a 20 | m.done |= .T... |
|00005230| 20 20 20 20 20 20 20 20 | 20 20 20 45 4e 44 49 46 | | ENDIF|
|00005240| 0d 0a 20 20 20 20 20 20 | 20 20 20 20 20 20 6d 2e |.. | m.|
|00005250| 6a 20 3d 20 6d 2e 6a 20 | 2b 20 31 0d 0a 20 20 20 |j = m.j |+ 1.. |
|00005260| 20 20 20 20 20 20 45 4e | 44 44 4f 0d 0a 20 20 20 | EN|DDO.. |
|00005270| 20 20 20 20 20 20 6d 2e | 69 20 3d 20 6d 2e 69 20 | m.|i = m.i |
|00005280| 2b 20 31 0d 0a 20 20 20 | 20 20 20 45 4e 44 44 4f |+ 1.. | ENDDO|
|00005290| 0d 0a 0d 0a 20 20 20 20 | 20 20 49 46 20 21 6d 2e |.... | IF !m.|
|000052a0| 64 6f 6e 65 20 20 20 20 | 26 26 20 6e 6f 20 6d 61 |done |&& no ma|
|000052b0| 74 63 68 65 73 20 66 6f | 75 6e 64 2e 20 20 44 65 |tches fo|und. De|
|000052c0| 66 61 75 6c 74 20 74 6f | 20 66 69 72 73 74 20 66 |fault to| first f|
|000052d0| 69 65 6c 64 2e 0d 0a 20 | 20 20 20 20 20 20 20 20 |ield... | |
|000052e0| 6d 2e 63 68 69 6c 64 66 | 6c 64 20 20 20 3d 20 63 |m.childf|ld = c|
|000052f0| 68 69 6c 64 6c 69 73 74 | 5b 31 5d 0d 0a 20 20 20 |hildlist|[1].. |
|00005300| 20 20 20 45 4e 44 49 46 | 0d 0a 20 20 20 45 4c 53 | ENDIF|.. ELS|
|00005310| 45 0d 0a 20 20 20 20 20 | 20 2a 20 44 65 66 61 75 |E.. | * Defau|
|00005320| 6c 74 20 74 6f 20 74 68 | 65 20 66 69 72 73 74 20 |lt to th|e first |
|00005330| 66 69 65 6c 64 20 0d 0a | 20 20 20 20 20 20 6d 2e |field ..| m.|
|00005340| 70 61 72 65 6e 74 66 6c | 64 20 20 3d 20 70 61 72 |parentfl|d = par|
|00005350| 65 6e 74 6c 69 73 74 5b | 31 5d 0d 0a 20 20 20 20 |entlist[|1].. |
|00005360| 20 20 6d 2e 63 68 69 6c | 64 66 6c 64 20 20 20 3d | m.chil|dfld =|
|00005370| 20 61 64 64 74 79 70 65 | 28 6d 2e 63 68 69 6c 64 | addtype|(m.child|
|00005380| 66 6c 64 29 0d 0a 20 20 | 20 45 4e 44 49 46 0d 0a |fld).. | ENDIF..|
|00005390| 45 4c 53 45 0d 0a 20 20 | 20 6d 2e 70 61 72 65 6e |ELSE.. | m.paren|
|000053a0| 74 66 6c 64 20 20 3d 20 | 61 64 64 74 79 70 65 28 |tfld = |addtype(|
|000053b0| 6d 2e 70 61 72 65 6e 74 | 66 6c 64 29 0d 0a 20 20 |m.parent|fld).. |
|000053c0| 20 6d 2e 63 68 69 6c 64 | 66 6c 64 20 20 20 3d 20 | m.child|fld = |
|000053d0| 61 64 64 74 79 70 65 28 | 6d 2e 63 68 69 6c 64 66 |addtype(|m.childf|
|000053e0| 6c 64 29 0d 0a 45 4e 44 | 49 46 0d 0a 0d 0a 44 4f |ld)..END|IF....DO|
|000053f0| 20 63 64 69 73 6c 69 73 | 74 20 57 49 54 48 20 41 | cdislis|t WITH A|
|00005400| 53 43 41 4e 28 63 68 69 | 6c 64 6c 69 73 74 2c 6d |SCAN(chi|ldlist,m|
|00005410| 2e 63 68 69 6c 64 66 6c | 64 29 0d 0a 0d 0a 53 45 |.childfl|d)....SE|
|00005420| 4c 45 43 54 20 28 6d 2e | 69 6e 5f 61 72 65 61 29 |LECT (m.|in_area)|
|00005430| 0d 0a 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005440| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005450| 00 01 00 00 00 0b 6d 2e | 70 61 72 65 6e 74 66 6c |......m.|parentfl|
|00005460| 64 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |d.......|........|
|00005470| 00 00 01 00 00 00 0a 70 | 61 72 65 6e 74 6c 69 73 |.......p|arentlis|
|00005480| 74 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |t.......|........|
|00005490| 00 00 00 01 00 00 00 06 | 22 40 5e 33 20 22 00 00 |........|"@^3 "..|
|000054a0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000054b0| 00 00 00 00 01 00 00 00 | 06 47 65 6e 65 76 61 00 |........|.Geneva.|
|000054c0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000054d0| 00 00 00 00 00 01 00 00 | 00 0b 53 48 4f 57 20 47 |........|..SHOW G|
|000054e0| 45 54 53 0d 0a 00 00 00 | 00 00 00 00 00 00 00 00 |ETS.....|........|
|000054f0| 00 00 00 00 00 00 01 00 | 00 00 08 22 45 71 75 61 |........|..."Equa|
|00005500| 6c 73 22 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |ls".....|........|
|00005510| 00 00 00 00 00 00 00 01 | 00 00 00 06 47 65 6e 65 |........|....Gene|
|00005520| 76 61 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |va......|........|
|00005530| 00 00 00 00 00 00 00 00 | 01 00 00 00 0a 6d 2e 63 |........|.....m.c|
|00005540| 68 69 6c 64 66 6c 64 00 | 00 00 00 00 00 00 00 00 |hildfld.|........|
|00005550| 00 00 00 00 00 00 00 00 | 00 01 00 00 00 09 63 68 |........|......ch|
|00005560| 69 6c 64 6c 69 73 74 00 | 00 00 00 00 00 00 00 00 |ildlist.|........|
|00005570| 00 00 00 00 00 00 00 00 | 00 00 01 00 00 00 06 22 |........|......."|
|00005580| 40 5e 33 20 22 00 00 00 | 00 00 00 00 00 00 00 00 |@^3 "...|........|
|00005590| 00 00 00 00 00 00 00 00 | 00 00 00 01 00 00 00 06 |........|........|
|000055a0| 47 65 6e 65 76 61 00 00 | 00 00 00 00 00 00 00 00 |Geneva..|........|
|000055b0| 00 00 00 00 00 00 00 00 | 00 00 00 00 01 00 00 00 |........|........|
|000055c0| 37 44 4f 20 63 64 69 73 | 6c 69 73 74 20 57 49 54 |7DO cdis|list WIT|
|000055d0| 48 20 41 53 43 41 4e 28 | 63 68 69 6c 64 6c 69 73 |H ASCAN(|childlis|
|000055e0| 74 2c 63 68 69 6c 64 66 | 6c 64 29 0d 0a 53 48 4f |t,childf|ld)..SHO|
|000055f0| 57 20 47 45 54 53 0d 0a | 00 00 00 00 00 00 01 00 |W GETS..|........|
|00005600| 00 00 09 6d 2e 6f 6b 63 | 61 6e 63 6c 00 00 00 00 |...m.okc|ancl....|
|00005610| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 01 |........|........|
|00005620| 00 00 00 19 22 40 2a 48 | 4e 33 20 5c 21 5c 3c 4f |...."@*H|N3 \!\<O|
|00005630| 4b 3b 5c 3f 5c 3c 43 61 | 6e 63 65 6c 22 00 00 00 |K;\?\<Ca|ncel"...|
|00005640| 01 00 00 00 06 47 65 6e | 65 76 61 00 00 00 00 00 |.....Gen|eva.....|
|00005650| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005660| 00 01 00 00 05 b4 2a 20 | 53 74 72 69 70 20 6f 66 |......* |Strip of|
|00005670| 66 20 74 68 65 20 74 79 | 70 65 20 64 65 73 69 67 |f the ty|pe desig|
|00005680| 6e 61 74 69 6f 6e 73 20 | 66 72 6f 6d 20 66 69 65 |nations |from fie|
|00005690| 6c 64 20 6e 61 6d 65 73 | 0d 0a 6d 2e 70 66 6c 64 |ld names|..m.pfld|
|000056a0| 20 3d 20 6d 2e 70 61 72 | 65 6e 74 66 6c 64 0d 0a | = m.par|entfld..|
|000056b0| 6d 2e 63 66 6c 64 20 3d | 20 6d 2e 63 68 69 6c 64 |m.cfld =| m.child|
|000056c0| 66 6c 64 0d 0a 49 46 20 | 41 54 28 27 28 27 2c 6d |fld..IF |AT('(',m|
|000056d0| 2e 70 61 72 65 6e 74 66 | 6c 64 29 20 3e 20 30 0d |.parentf|ld) > 0.|
|000056e0| 0a 20 20 20 6d 2e 70 61 | 72 65 6e 74 66 6c 64 20 |. m.pa|rentfld |
|000056f0| 3d 20 41 4c 4c 54 52 49 | 4d 28 53 55 42 53 54 52 |= ALLTRI|M(SUBSTR|
|00005700| 28 6d 2e 70 61 72 65 6e | 74 66 6c 64 2c 31 2c 4c |(m.paren|tfld,1,L|
|00005710| 45 4e 28 54 52 49 4d 28 | 6d 2e 70 61 72 65 6e 74 |EN(TRIM(|m.parent|
|00005720| 66 6c 64 29 29 2d 33 29 | 29 0d 0a 45 4e 44 49 46 |fld))-3)|)..ENDIF|
|00005730| 0d 0a 49 46 20 41 54 28 | 27 28 27 2c 6d 2e 63 68 |..IF AT(|'(',m.ch|
|00005740| 69 6c 64 66 6c 64 29 20 | 3e 20 30 0d 0a 20 20 20 |ildfld) |> 0.. |
|00005750| 6d 2e 63 68 69 6c 64 66 | 6c 64 20 20 3d 20 41 4c |m.childf|ld = AL|
|00005760| 4c 54 52 49 4d 28 53 55 | 42 53 54 52 28 6d 2e 63 |LTRIM(SU|BSTR(m.c|
|00005770| 68 69 6c 64 66 6c 64 2c | 31 2c 4c 45 4e 28 54 52 |hildfld,|1,LEN(TR|
|00005780| 49 4d 28 6d 2e 63 68 69 | 6c 64 66 6c 64 29 29 2d |IM(m.chi|ldfld))-|
|00005790| 33 29 29 0d 0a 45 4e 44 | 49 46 0d 0a 0d 0a 44 4f |3))..END|IF....DO|
|000057a0| 20 43 41 53 45 0d 0a 43 | 41 53 45 20 6d 2e 6f 6b | CASE..C|ASE m.ok|
|000057b0| 63 61 6e 63 6c 20 3d 20 | 31 0d 0a 20 20 20 2a 20 |cancl = |1.. * |
|000057c0| 4d 61 6b 65 20 73 75 72 | 65 20 74 68 69 73 20 69 |Make sur|e this i|
|000057d0| 73 20 61 20 76 61 6c 69 | 64 20 73 65 6c 65 63 74 |s a vali|d select|
|000057e0| 69 6f 6e 20 77 69 74 68 | 20 72 65 73 70 65 63 74 |ion with| respect|
|000057f0| 20 74 6f 20 64 61 74 61 | 20 74 79 70 65 0d 0a 20 | to data| type.. |
|00005800| 20 20 44 4f 20 43 41 53 | 45 0d 0a 20 20 20 43 41 | DO CAS|E.. CA|
|00005810| 53 45 20 54 59 50 45 28 | 6d 2e 63 68 69 6c 64 66 |SE TYPE(|m.childf|
|00005820| 6c 64 29 20 3d 20 27 55 | 27 0d 0a 20 20 20 20 20 |ld) = 'U|'.. |
|00005830| 20 57 41 49 54 20 57 49 | 4e 44 4f 57 20 22 54 68 | WAIT WI|NDOW "Th|
|00005840| 65 20 63 68 69 6c 64 20 | 64 61 74 61 62 61 73 65 |e child |database|
|00005850| 20 63 6f 75 6c 64 20 6e | 6f 74 20 62 65 20 66 6f | could n|ot be fo|
|00005860| 75 6e 64 2e 22 0d 0a 20 | 20 20 43 41 53 45 20 54 |und.".. | CASE T|
|00005870| 59 50 45 28 6d 2e 70 61 | 72 65 6e 74 66 6c 64 29 |YPE(m.pa|rentfld)|
|00005880| 20 3d 20 27 55 27 0d 0a | 20 20 20 20 20 20 57 41 | = 'U'..| WA|
|00005890| 49 54 20 57 49 4e 44 4f | 57 20 22 54 68 65 20 70 |IT WINDO|W "The p|
|000058a0| 61 72 65 6e 74 20 64 61 | 74 61 62 61 73 65 20 63 |arent da|tabase c|
|000058b0| 6f 75 6c 64 20 6e 6f 74 | 20 62 65 20 66 6f 75 6e |ould not| be foun|
|000058c0| 64 2e 22 0d 0a 20 20 20 | 43 41 53 45 20 54 59 50 |d.".. |CASE TYP|
|000058d0| 45 28 6d 2e 63 68 69 6c | 64 66 6c 64 29 20 3d 3d |E(m.chil|dfld) ==|
|000058e0| 20 54 59 50 45 28 6d 2e | 70 61 72 65 6e 74 66 6c | TYPE(m.|parentfl|
|000058f0| 64 29 0d 0a 20 20 20 20 | 20 20 6d 2e 64 62 66 70 |d).. | m.dbfp|
|00005900| 61 72 74 20 20 20 3d 20 | 53 55 42 53 54 52 28 6d |art = |SUBSTR(m|
|00005910| 2e 63 68 69 6c 64 66 6c | 64 2c 31 2c 41 54 28 27 |.childfl|d,1,AT('|
|00005920| 2e 27 2c 6d 2e 63 68 69 | 6c 64 66 6c 64 29 2d 31 |.',m.chi|ldfld)-1|
|00005930| 29 0d 0a 20 20 20 20 20 | 20 6d 2e 72 65 6c 73 74 |).. | m.relst|
|00005940| 72 20 20 20 20 3d 20 27 | 53 45 54 20 52 45 4c 41 |r = '|SET RELA|
|00005950| 54 49 4f 4e 20 54 4f 20 | 27 3b 0d 0a 20 20 20 20 |TION TO |';.. |
|00005960| 20 20 20 20 20 2b 53 55 | 42 53 54 52 28 6d 2e 70 | +SU|BSTR(m.p|
|00005970| 61 72 65 6e 74 66 6c 64 | 2c 41 54 28 27 2e 27 2c |arentfld|,AT('.',|
|00005980| 6d 2e 70 61 72 65 6e 74 | 66 6c 64 29 2b 31 29 3b |m.parent|fld)+1);|
|00005990| 0d 0a 20 20 20 20 20 20 | 20 20 20 2b 27 20 49 4e |.. | +' IN|
|000059a0| 54 4f 20 27 2b 6d 2e 64 | 62 66 70 61 72 74 0d 0a |TO '+m.d|bfpart..|
|000059b0| 20 20 20 20 20 20 6d 2e | 70 61 72 65 6e 74 64 62 | m.|parentdb|
|000059c0| 66 20 3d 20 53 55 42 53 | 54 52 28 6d 2e 70 61 72 |f = SUBS|TR(m.par|
|000059d0| 65 6e 74 66 6c 64 2c 31 | 2c 41 54 28 27 2e 27 2c |entfld,1|,AT('.',|
|000059e0| 6d 2e 70 61 72 65 6e 74 | 66 6c 64 29 2d 31 29 0d |m.parent|fld)-1).|
|000059f0| 0a 20 20 20 20 20 20 43 | 4c 45 41 52 20 52 45 41 |. C|LEAR REA|
|00005a00| 44 0d 0a 20 20 20 4f 54 | 48 45 52 57 49 53 45 0d |D.. OT|HERWISE.|
|00005a10| 0a 20 20 20 20 20 20 57 | 41 49 54 20 57 49 4e 44 |. W|AIT WIND|
|00005a20| 4f 57 20 22 50 61 72 65 | 6e 74 20 61 6e 64 20 63 |OW "Pare|nt and c|
|00005a30| 68 69 6c 64 20 68 61 76 | 65 20 64 69 66 66 65 72 |hild hav|e differ|
|00005a40| 65 6e 74 20 64 61 74 61 | 20 74 79 70 65 73 2e 22 |ent data| types."|
|00005a50| 0d 0a 20 20 20 20 20 20 | 2a 20 52 65 73 74 6f 72 |.. |* Restor|
|00005a60| 65 20 66 75 6c 6c 20 73 | 74 72 69 6e 67 20 74 6f |e full s|tring to|
|00005a70| 20 70 61 72 65 6e 74 20 | 61 6e 64 20 63 68 69 6c | parent |and chil|
|00005a80| 64 20 66 69 65 6c 64 73 | 0d 0a 20 20 20 20 20 20 |d fields|.. |
|00005a90| 6d 2e 70 61 72 65 6e 74 | 66 6c 64 20 3d 20 6d 2e |m.parent|fld = m.|
|00005aa0| 70 66 6c 64 0d 0a 20 20 | 20 20 20 20 6d 2e 63 68 |pfld.. | m.ch|
|00005ab0| 69 6c 64 66 6c 64 20 20 | 3d 20 6d 2e 63 66 6c 64 |ildfld |= m.cfld|
|00005ac0| 0d 0a 20 20 20 45 4e 44 | 43 41 53 45 0d 0a 43 41 |.. END|CASE..CA|
|00005ad0| 53 45 20 6d 2e 6f 6b 63 | 61 6e 63 6c 20 3d 20 32 |SE m.okc|ancl = 2|
|00005ae0| 20 20 20 20 20 26 26 20 | 63 61 6e 63 65 6c 20 74 | && |cancel t|
|00005af0| 68 69 73 20 72 65 6c 61 | 74 69 6f 6e 73 68 69 70 |his rela|tionship|
|00005b00| 0d 0a 20 20 20 2a 20 57 | 65 20 6f 70 65 6e 65 64 |.. * W|e opened|
|00005b10| 20 63 68 69 6c 64 73 74 | 65 6d 20 69 6e 20 74 68 | childst|em in th|
|00005b20| 65 20 73 65 74 75 70 20 | 73 6e 69 70 70 65 74 2e |e setup |snippet.|
|00005b30| 20 20 43 6c 6f 73 65 20 | 69 74 20 6e 6f 77 2e 0d | Close |it now..|
|00005b40| 0a 20 20 20 49 46 20 6d | 2e 61 64 64 6d 6f 64 65 |. IF m|.addmode|
|00005b50| 20 41 4e 44 20 55 53 45 | 44 28 6d 2e 63 68 69 6c | AND USE|D(m.chil|
|00005b60| 64 73 74 65 6d 29 0d 0a | 20 20 20 20 20 20 53 45 |dstem)..| SE|
|00005b70| 4c 45 43 54 20 28 6d 2e | 63 68 69 6c 64 73 74 65 |LECT (m.|childste|
|00005b80| 6d 29 0d 0a 20 20 20 20 | 20 20 55 53 45 0d 0a 20 |m).. | USE.. |
|00005b90| 20 20 45 4e 44 49 46 0d | 0a 20 20 20 6d 2e 64 62 | ENDIF.|. m.db|
|00005ba0| 66 70 61 72 74 20 20 20 | 3d 20 27 27 0d 0a 20 20 |fpart |= ''.. |
|00005bb0| 20 6d 2e 63 68 69 6c 64 | 66 6c 64 20 20 3d 20 27 | m.child|fld = '|
|00005bc0| 27 0d 0a 20 20 20 6d 2e | 63 68 69 6c 64 64 62 66 |'.. m.|childdbf|
|00005bd0| 20 20 3d 20 27 27 0d 0a | 20 20 20 6d 2e 72 65 6c | = ''..| m.rel|
|00005be0| 73 74 72 20 20 20 20 3d | 20 27 27 0d 0a 20 20 20 |str =| ''.. |
|00005bf0| 6d 2e 70 61 72 65 6e 74 | 64 62 66 20 3d 20 27 27 |m.parent|dbf = ''|
|00005c00| 0d 0a 20 20 20 43 4c 45 | 41 52 20 52 45 41 44 0d |.. CLE|AR READ.|
|00005c10| 0a 45 4e 44 43 41 53 45 | 0d 0a 00 00 00 00 00 00 |.ENDCASE|........|
|00005c20| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 01 00 |........|........|
|00005c30| 00 00 04 22 4f 4b 22 00 | 00 00 00 00 00 00 00 00 |..."OK".|........|
|00005c40| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 01 |........|........|
|00005c50| 00 00 00 2d 22 48 6f 77 | 20 69 73 20 54 68 69 73 |...-"How| is This|
|00005c60| 20 54 61 62 6c 65 20 52 | 65 6c 61 74 65 64 20 74 | Table R|elated t|
|00005c70| 6f 20 41 6e 6f 74 68 65 | 72 20 54 61 62 6c 65 3f |o Anothe|r Table?|
|00005c80| 22 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |".......|........|
|00005c90| 00 01 00 00 00 06 47 65 | 6e 65 76 61 00 00 00 00 |......Ge|neva....|
|00005ca0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005cb0| 00 00 01 00 00 00 17 22 | 46 69 65 6c 64 20 69 6e |......."|Field in|
|00005cc0| 20 4f 74 68 65 72 20 54 | 61 62 6c 65 3a 22 00 00 | Other T|able:"..|
|00005cd0| 00 00 00 01 00 00 00 06 | 47 65 6e 65 76 61 00 00 |........|Geneva..|
|00005ce0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005cf0| 00 00 00 00 01 00 00 00 | 16 22 46 69 65 6c 64 20 |........|."Field |
|00005d00| 69 6e 20 54 68 69 73 20 | 54 61 62 6c 65 3a 22 00 |in This |Table:".|
|00005d10| 00 00 00 00 00 01 00 00 | 00 06 47 65 6e 65 76 61 |........|..Geneva|
|00005d20| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005d30| 00 00 00 00 00 00 01 00 | 00 00 08 6d 2e 61 64 76 |........|...m.adv|
|00005d40| 62 75 74 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |but.....|........|
|00005d50| 00 00 00 00 00 00 00 01 | 00 00 00 15 22 40 2a 48 |........|...."@*H|
|00005d60| 4e 33 20 5c 3c 41 64 76 | 61 6e 63 65 64 2e 2e 2e |N3 \<Adv|anced...|
|00005d70| 22 00 00 00 00 00 00 00 | 01 00 00 00 06 47 65 6e |".......|.....Gen|
|00005d80| 65 76 61 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |eva.....|........|
|00005d90| 00 00 00 00 00 00 00 00 | 00 01 00 00 00 3c 44 4f |........|.....<DO|
|00005da0| 20 63 61 73 63 64 6c 67 | 2e 73 70 72 20 57 49 54 | cascdlg|.spr WIT|
|00005db0| 48 20 64 62 66 6c 69 73 | 74 5b 6d 2e 6e 65 78 74 |H dbflis|t[m.next|
|00005dc0| 64 62 66 2c 6d 2e 63 73 | 74 65 6d 6e 75 6d 5d 0d |dbf,m.cs|temnum].|
|00005dd0| 0a 0d 0a 20 20 20 0d 0a | 0d 0a 00 00 00 00 00 00 |... ..|........|
|00005de0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005df0| 00 00 00 00 00 00 00 00 | 00 00 00 00 01 00 00 00 |........|........|
|00005e00| 0d 22 41 64 76 61 6e 63 | 65 64 2e 2e 2e 22 00 00 |."Advanc|ed..."..|
|00005e10| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 01 00 00 |........|........|
|00005e20| 00 06 47 65 6e 65 76 61 | 00 00 00 00 00 00 00 00 |..Geneva|........|
|00005e30| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 01 00 |........|........|
|00005e40| 00 00 06 47 65 6e 65 76 | 61 00 00 00 00 00 00 00 |...Genev|a.......|
|00005e50| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 01 |........|........|
|00005e60| 00 00 00 08 52 45 4c 53 | 45 4c 45 43 00 00 00 00 |....RELS|ELEC....|
|00005e70| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005e80| 01 00 00 00 16 22 4f 70 | 74 69 6f 6e 73 20 66 6f |....."Op|tions fo|
|00005e90| 72 20 26 74 68 69 73 64 | 62 66 22 00 00 00 00 00 |r &thisd|bf".....|
|00005ea0| 00 01 00 00 00 0d 4d 53 | 20 53 61 6e 73 20 53 65 |......MS| Sans Se|
|00005eb0| 72 69 66 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |rif.....|........|
|00005ec0| 00 00 01 00 00 00 c5 49 | 46 20 45 4d 50 54 59 28 |.......I|F EMPTY(|
|00005ed0| 6d 2e 70 61 72 65 6e 74 | 66 6c 64 29 20 3b 0d 0a |m.parent|fld) ;..|
|00005ee0| 20 20 20 20 20 20 4f 52 | 20 4c 45 46 54 28 6d 2e | OR| LEFT(m.|
|00005ef0| 70 61 72 65 6e 74 66 6c | 64 2c 31 29 20 3d 20 27 |parentfl|d,1) = '|
|00005f00| 5c 27 20 3b 0d 0a 20 20 | 20 20 20 20 4f 52 20 28 |\' ;.. | OR (|
|00005f10| 67 65 74 74 79 70 65 28 | 6d 2e 70 61 72 65 6e 74 |gettype(|m.parent|
|00005f20| 66 6c 64 29 20 21 3d 20 | 67 65 74 74 79 70 65 28 |fld) != |gettype(|
|00005f30| 6d 2e 63 68 69 6c 64 66 | 6c 64 29 29 0d 0a 20 20 |m.childf|ld)).. |
|00005f40| 20 53 48 4f 57 20 47 45 | 54 20 6d 2e 6f 6b 63 61 | SHOW GE|T m.okca|
|00005f50| 6e 63 6c 2c 31 20 44 49 | 53 41 42 4c 45 0d 0a 45 |ncl,1 DI|SABLE..E|
|00005f60| 4c 53 45 0d 0a 20 20 20 | 53 48 4f 57 20 47 45 54 |LSE.. |SHOW GET|
|00005f70| 20 6d 2e 6f 6b 63 61 6e | 63 6c 2c 31 20 45 4e 41 | m.okcan|cl,1 ENA|
|00005f80| 42 4c 45 0d 0a 45 4e 44 | 49 46 0d 0a 00 00 00 00 |BLE..END|IF......|
|00005f90| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005fa0| 00 00 00 00 00 00 00 00 | 00 01 00 00 06 e7 0d 0a |........|........|
|00005fb0| 2a 21 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |*!******|********|
|00005fc0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00005fd0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00005fe0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00005ff0| 2a 2a 2a 0d 0a 2a 21 0d | 0a 2a 21 20 20 20 20 20 |***..*!.|.*! |
|00006000| 20 50 72 6f 63 65 64 75 | 72 65 3a 20 41 44 44 54 | Procedu|re: ADDT|
|00006010| 59 50 45 0d 0a 2a 21 0d | 0a 2a 21 2a 2a 2a 2a 2a |YPE..*!.|.*!*****|
|00006020| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00006030| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00006040| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00006050| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 0d 0a 46 55 |********|****..FU|
|00006060| 4e 43 54 49 4f 4e 20 61 | 64 64 74 79 70 65 0d 0a |NCTION a|ddtype..|
|00006070| 2a 20 41 64 64 20 74 68 | 65 20 64 61 74 61 20 74 |* Add th|e data t|
|00006080| 79 70 65 20 74 6f 20 61 | 20 66 69 65 6c 64 20 6e |ype to a| field n|
|00006090| 61 6d 65 0d 0a 50 41 52 | 41 4d 45 54 45 52 20 66 |ame..PAR|AMETER f|
|000060a0| 6c 64 6e 61 6d 65 0d 0a | 0d 0a 49 46 20 21 45 4d |ldname..|..IF !EM|
|000060b0| 50 54 59 28 6d 2e 66 6c | 64 6e 61 6d 65 29 0d 0a |PTY(m.fl|dname)..|
|000060c0| 20 20 20 52 45 54 55 52 | 4e 20 50 41 44 52 28 6d | RETUR|N PADR(m|
|000060d0| 2e 66 6c 64 6e 61 6d 65 | 2c 32 30 29 20 2b 20 27 |.fldname|,20) + '|
|000060e0| 28 27 20 2b 20 54 59 50 | 45 28 6d 2e 66 6c 64 6e |(' + TYP|E(m.fldn|
|000060f0| 61 6d 65 29 20 2b 20 27 | 29 27 0d 0a 45 4c 53 45 |ame) + '|)'..ELSE|
|00006100| 0d 0a 20 20 20 52 45 54 | 55 52 4e 20 27 27 0d 0a |.. RET|URN ''..|
|00006110| 45 4e 44 49 46 0d 0a 0d | 0a 0d 0a 2a 21 2a 2a 2a |ENDIF...|...*!***|
|00006120| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00006130| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00006140| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00006150| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 0d 0a |********|******..|
|00006160| 2a 21 0d 0a 2a 21 20 20 | 20 20 20 20 50 72 6f 63 |*!..*! | Proc|
|00006170| 65 64 75 72 65 3a 20 47 | 45 54 54 59 50 45 0d 0a |edure: G|ETTYPE..|
|00006180| 2a 21 0d 0a 2a 21 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| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|000061b0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|000061c0| 2a 2a 2a 2a 2a 2a 2a 0d | 0a 46 55 4e 43 54 49 4f |*******.|.FUNCTIO|
|000061d0| 4e 20 67 65 74 74 79 70 | 65 0d 0a 50 41 52 41 4d |N gettyp|e..PARAM|
|000061e0| 45 54 45 52 20 6d 2e 66 | 6c 64 6e 61 6d 65 0d 0a |ETER m.f|ldname..|
|000061f0| 50 52 49 56 41 54 45 20 | 6d 2e 72 65 74 76 61 6c |PRIVATE |m.retval|
|00006200| 0d 0a 2a 20 54 68 69 73 | 20 66 75 6e 63 74 69 6f |..* This| functio|
|00006210| 6e 20 65 78 74 72 61 63 | 74 73 20 74 68 65 20 64 |n extrac|ts the d|
|00006220| 61 74 61 20 74 79 70 65 | 20 66 72 6f 6d 20 74 68 |ata type| from th|
|00006230| 65 20 66 6f 72 6d 61 74 | 20 75 73 65 64 20 69 6e |e format| used in|
|00006240| 0d 0a 2a 20 74 68 65 20 | 70 61 72 65 6e 74 6c 69 |..* the |parentli|
|00006250| 73 74 20 61 6e 64 20 63 | 68 69 6c 64 6c 69 73 74 |st and c|hildlist|
|00006260| 20 61 72 72 61 79 73 2e | 20 20 54 68 65 20 69 6e | arrays.| The in|
|00006270| 63 6f 6d 69 6e 67 20 66 | 6f 72 6d 61 74 20 6c 6f |coming f|ormat lo|
|00006280| 6f 6b 73 0d 0a 2a 20 6c | 69 6b 65 3a 0d 0a 2a 20 |oks..* l|ike:..* |
|00006290| 20 20 20 20 20 20 20 44 | 42 46 41 4c 49 41 53 2e | D|BFALIAS.|
|000062a0| 46 49 45 4c 44 20 20 20 | 20 20 20 28 43 29 0d 0a |FIELD | (C)..|
|000062b0| 2a 0d 0a 2a 20 54 68 65 | 20 66 75 6e 63 74 69 6f |*..* The| functio|
|000062c0| 6e 20 72 65 74 75 72 6e | 73 20 27 43 27 0d 0a 0d |n return|s 'C'...|
|000062d0| 0a 6d 2e 72 65 74 76 61 | 6c 20 3d 20 52 49 47 48 |.m.retva|l = RIGH|
|000062e0| 54 28 54 52 49 4d 28 6d | 2e 66 6c 64 6e 61 6d 65 |T(TRIM(m|.fldname|
|000062f0| 29 2c 33 29 0d 0a 6d 2e | 72 65 74 76 61 6c 20 3d |),3)..m.|retval =|
|00006300| 20 55 50 50 45 52 28 41 | 4c 4c 54 52 49 4d 28 6d | UPPER(A|LLTRIM(m|
|00006310| 2e 72 65 74 76 61 6c 29 | 29 0d 0a 52 45 54 55 52 |.retval)|)..RETUR|
|00006320| 4e 20 43 48 52 54 52 41 | 4e 28 6d 2e 72 65 74 76 |N CHRTRA|N(m.retv|
|00006330| 61 6c 2c 27 28 29 27 2c | 27 27 29 0d 0a 0d 0a 2a |al,'()',|'')....*|
|00006340| 21 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 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00006380| 2a 2a 0d 0a 2a 21 0d 0a | 2a 21 20 20 20 20 20 20 |**..*!..|*! |
|00006390| 50 72 6f 63 65 64 75 72 | 65 3a 20 43 44 49 53 4c |Procedur|e: CDISL|
|000063a0| 49 53 54 0d 0a 2a 21 0d | 0a 2a 21 2a 2a 2a 2a 2a |IST..*!.|.*!*****|
|000063b0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|000063c0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|000063d0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|000063e0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 0d 0a 50 52 |********|****..PR|
|000063f0| 4f 43 45 44 55 52 45 20 | 63 64 69 73 6c 69 73 74 |OCEDURE |cdislist|
+--------+-------------------------+-------------------------+--------+--------+
Only 25.0 KB of data is shown above.
