home *** CD-ROM | disk | FTP | other *** search
open in: 
MacOS 8.1
|
Win98
|
DOS
view JSON data
|
view as text
This file was processed as: SHell self-extracting ARchive
(archive/shar).
You can browse this item here: 4124
| Confidence | Program | Detection | Match Type | Support
|
|---|
| 100%
| dexvert
| SHell self-extracting ARchive (archive/shar)
| magic
| Supported |
| 1%
| dexvert
| Text File (text/txt)
| fallback
| Supported |
| 100%
| file
| ASCII text
| default
| |
| 100%
| checkBytes
| Printable ASCII
| default
| |
| 100%
| perlTextCheck
| Likely Text (Perl)
| default
| |
| 100%
| siegfried
| fmt/329 Shell Archive Format
| default
| |
| 100%
| detectItEasy
| Format: plain text[LF]
| default (weak)
|
|
hex view+--------+-------------------------+-------------------------+--------+--------+
|00000000| 4e 65 77 73 67 72 6f 75 | 70 73 3a 20 63 6f 6d 70 |Newsgrou|ps: comp|
|00000010| 2e 73 6f 75 72 63 65 73 | 2e 6d 69 73 63 0a 50 61 |.sources|.misc.Pa|
|00000020| 74 68 3a 20 73 70 61 72 | 6b 79 21 6b 65 6e 74 0a |th: spar|ky!kent.|
|00000030| 46 72 6f 6d 3a 20 72 69 | 63 68 69 64 40 6f 77 6c |From: ri|chid@owl|
|00000040| 6e 65 74 2e 72 69 63 65 | 2e 65 64 75 20 28 52 69 |net.rice|.edu (Ri|
|00000050| 63 68 61 72 64 20 50 61 | 72 76 69 6e 20 4a 65 72 |chard Pa|rvin Jer|
|00000060| 6e 69 67 61 6e 29 0a 53 | 75 62 6a 65 63 74 3a 20 |nigan).S|ubject: |
|00000070| 20 76 33 33 69 31 31 39 | 3a 20 20 6d 62 61 73 65 | v33i119|: mbase|
|00000080| 20 2d 20 4d 65 74 61 6c | 42 61 73 65 20 35 2e 30 | - Metal|Base 5.0|
|00000090| 2c 20 50 6f 72 74 61 62 | 6c 65 20 64 61 74 61 62 |, Portab|le datab|
|000000a0| 61 73 65 20 65 6e 67 69 | 6e 65 2c 20 50 61 72 74 |ase engi|ne, Part|
|000000b0| 30 31 2f 30 38 0a 4d 65 | 73 73 61 67 65 2d 49 44 |01/08.Me|ssage-ID|
|000000c0| 3a 20 3c 63 73 6d 2d 76 | 33 33 69 31 31 39 3d 6d |: <csm-v|33i119=m|
|000000d0| 62 61 73 65 2e 31 36 35 | 36 31 33 40 73 70 61 72 |base.165|613@spar|
|000000e0| 6b 79 2e 49 4d 44 2e 53 | 74 65 72 6c 69 6e 67 2e |ky.IMD.S|terling.|
|000000f0| 43 4f 4d 3e 0a 46 6f 6c | 6c 6f 77 75 70 2d 54 6f |COM>.Fol|lowup-To|
|00000100| 3a 20 63 6f 6d 70 2e 73 | 6f 75 72 63 65 73 2e 64 |: comp.s|ources.d|
|00000110| 0a 58 2d 4d 64 34 2d 53 | 69 67 6e 61 74 75 72 65 |.X-Md4-S|ignature|
|00000120| 3a 20 34 65 31 36 30 62 | 32 38 39 31 32 66 62 62 |: 4e160b|28912fbb|
|00000130| 63 38 35 36 34 66 34 30 | 66 37 35 30 38 61 64 64 |c8564f40|f7508add|
|00000140| 61 64 0a 4b 65 79 77 6f | 72 64 73 3a 20 70 6f 72 |ad.Keywo|rds: por|
|00000150| 74 61 62 6c 65 20 64 61 | 74 61 62 61 73 65 0a 53 |table da|tabase.S|
|00000160| 65 6e 64 65 72 3a 20 6b | 65 6e 74 40 73 70 61 72 |ender: k|ent@spar|
|00000170| 6b 79 2e 69 6d 64 2e 73 | 74 65 72 6c 69 6e 67 2e |ky.imd.s|terling.|
|00000180| 63 6f 6d 20 28 4b 65 6e | 74 20 4c 61 6e 64 66 69 |com (Ken|t Landfi|
|00000190| 65 6c 64 29 0a 4f 72 67 | 61 6e 69 7a 61 74 69 6f |eld).Org|anizatio|
|000001a0| 6e 3a 20 53 74 65 72 6c | 69 6e 67 20 53 6f 66 74 |n: Sterl|ing Soft|
|000001b0| 77 61 72 65 0a 44 61 74 | 65 3a 20 4d 6f 6e 2c 20 |ware.Dat|e: Mon, |
|000001c0| 32 33 20 4e 6f 76 20 31 | 39 39 32 20 32 32 3a 35 |23 Nov 1|992 22:5|
|000001d0| 37 3a 31 33 20 47 4d 54 | 0a 41 70 70 72 6f 76 65 |7:13 GMT|.Approve|
|000001e0| 64 3a 20 6b 65 6e 74 40 | 73 70 61 72 6b 79 2e 69 |d: kent@|sparky.i|
|000001f0| 6d 64 2e 73 74 65 72 6c | 69 6e 67 2e 63 6f 6d 0a |md.sterl|ing.com.|
|00000200| 4c 69 6e 65 73 3a 20 31 | 33 31 34 0a 0a 53 75 62 |Lines: 1|314..Sub|
|00000210| 6d 69 74 74 65 64 2d 62 | 79 3a 20 72 69 63 68 69 |mitted-b|y: richi|
|00000220| 64 40 6f 77 6c 6e 65 74 | 2e 72 69 63 65 2e 65 64 |d@owlnet|.rice.ed|
|00000230| 75 20 28 52 69 63 68 61 | 72 64 20 50 61 72 76 69 |u (Richa|rd Parvi|
|00000240| 6e 20 4a 65 72 6e 69 67 | 61 6e 29 0a 50 6f 73 74 |n Jernig|an).Post|
|00000250| 69 6e 67 2d 6e 75 6d 62 | 65 72 3a 20 56 6f 6c 75 |ing-numb|er: Volu|
|00000260| 6d 65 20 33 33 2c 20 49 | 73 73 75 65 20 31 31 39 |me 33, I|ssue 119|
|00000270| 0a 41 72 63 68 69 76 65 | 2d 6e 61 6d 65 3a 20 6d |.Archive|-name: m|
|00000280| 62 61 73 65 2f 70 61 72 | 74 30 31 0a 45 6e 76 69 |base/par|t01.Envi|
|00000290| 72 6f 6e 6d 65 6e 74 3a | 20 41 4d 49 47 41 2c 20 |ronment:| AMIGA, |
|000002a0| 4d 53 2d 44 4f 53 2c 20 | 48 50 2d 55 58 2c 20 58 |MS-DOS, |HP-UX, X|
|000002b0| 45 4e 49 58 2c 20 55 4e | 49 58 2c 20 55 4c 54 52 |ENIX, UN|IX, ULTR|
|000002c0| 49 58 2c 20 53 47 49 2c | 20 53 55 2c 20 43 75 72 |IX, SGI,| SU, Cur|
|000002d0| 73 65 73 0a 53 75 70 65 | 72 73 65 64 65 73 3a 20 |ses.Supe|rsedes: |
|000002e0| 6d 62 61 73 65 3a 20 56 | 6f 6c 75 6d 65 20 32 38 |mbase: V|olume 28|
|000002f0| 2c 20 49 73 73 75 65 20 | 34 30 2d 34 34 0a 0a 5b |, Issue |40-44..[|
|00000300| 20 54 68 69 73 20 76 65 | 72 73 69 6f 6e 20 6f 66 | This ve|rsion of|
|00000310| 20 6d 62 61 73 65 20 68 | 61 73 20 62 65 65 6e 20 | mbase h|as been |
|00000320| 72 65 6c 65 61 73 65 64 | 20 61 73 20 64 6f 6e 61 |released| as dona|
|00000330| 74 65 77 61 72 65 2e 20 | 20 44 6f 6e 61 74 65 20 |teware. | Donate |
|00000340| 69 66 20 79 6f 75 20 77 | 69 73 68 20 5d 0a 5b 20 |if you w|ish ].[ |
|00000350| 62 75 74 20 79 6f 75 20 | 61 72 65 20 6e 6f 74 20 |but you |are not |
|00000360| 72 65 71 75 69 72 65 64 | 20 74 6f 2e 20 20 53 65 |required| to. Se|
|00000370| 65 20 74 68 65 20 66 69 | 6c 65 20 72 65 61 64 6d |e the fi|le readm|
|00000380| 65 2e 74 6f 6f 20 66 6f | 72 20 6d 6f 72 65 20 73 |e.too fo|r more s|
|00000390| 70 65 63 69 66 69 63 73 | 2e 20 20 5d 0a 5b 20 46 |pecifics|. ].[ F|
|000003a0| 6f 72 20 61 72 63 68 69 | 76 69 6e 67 20 70 75 72 |or archi|ving pur|
|000003b0| 70 6f 73 65 73 2c 20 49 | 20 64 6f 20 6e 6f 74 20 |poses, I| do not |
|000003c0| 63 6f 6e 73 69 64 65 72 | 20 74 68 69 73 20 73 68 |consider| this sh|
|000003d0| 61 72 65 77 61 72 65 2e | 20 20 20 20 20 20 2d 4b |areware.| -K|
|000003e0| 65 6e 74 2b 20 20 20 20 | 20 20 5d 0a 0a 4d 65 74 |ent+ | ]..Met|
|000003f0| 61 6c 42 61 73 65 20 35 | 2e 30 20 69 73 20 61 20 |alBase 5|.0 is a |
|00000400| 73 69 6d 70 6c 65 20 64 | 61 74 61 62 61 73 65 20 |simple d|atabase |
|00000410| 65 6e 67 69 6e 65 2c 20 | 64 65 73 69 67 6e 65 64 |engine, |designed|
|00000420| 20 74 6f 20 62 65 20 70 | 6f 72 74 61 62 6c 65 20 | to be p|ortable |
|00000430| 62 65 74 77 65 65 6e 0a | 61 6c 6d 6f 73 74 20 61 |between.|almost a|
|00000440| 6e 79 20 70 6c 61 74 66 | 6f 72 6d 3b 20 55 6e 69 |ny platf|orm; Uni|
|00000450| 78 2c 20 4d 53 2d 44 4f | 53 2c 20 48 50 2c 20 4d |x, MS-DO|S, HP, M|
|00000460| 61 63 20 50 57 2c 20 4e | 65 58 54 2c 20 73 67 69 |ac PW, N|eXT, sgi|
|00000470| 2c 20 61 6e 64 20 6d 61 | 6e 79 20 6d 6f 72 65 2c |, and ma|ny more,|
|00000480| 20 73 6d 61 6c 6c 2d 0a | 6d 6f 64 65 6c 20 61 6e | small-.|model an|
|00000490| 64 20 75 70 2e 20 20 54 | 68 69 73 20 6c 61 74 65 |d up. T|his late|
|000004a0| 73 74 20 72 65 6c 65 61 | 73 65 20 68 61 73 20 6d |st relea|se has m|
|000004b0| 6f 72 65 20 66 69 65 6c | 64 20 74 79 70 65 73 2c |ore fiel|d types,|
|000004c0| 20 74 68 72 65 65 2d 70 | 68 61 73 65 20 6c 6f 63 | three-p|hase loc|
|000004d0| 6b 69 6e 67 0a 74 6f 20 | 65 6e 73 75 72 65 20 6d |king.to |ensure m|
|000004e0| 75 6c 74 69 2d 75 73 65 | 72 20 61 63 63 65 73 73 |ulti-use|r access|
|000004f0| 20 77 69 74 68 6f 75 74 | 20 61 6e 79 20 73 79 73 | without| any sys|
|00000500| 74 65 6d 2d 62 61 73 65 | 64 20 49 50 43 2c 20 61 |tem-base|d IPC, a|
|00000510| 6e 64 20 69 6e 74 65 72 | 6e 61 6c 20 63 61 63 68 |nd inter|nal cach|
|00000520| 69 6e 67 0a 74 6f 20 70 | 72 6f 76 69 64 65 20 74 |ing.to p|rovide t|
|00000530| 77 69 63 65 20 74 68 65 | 20 73 70 65 65 64 20 61 |wice the| speed a|
|00000540| 6e 64 20 75 70 20 66 6f | 72 20 72 65 62 61 6c 61 |nd up fo|r rebala|
|00000550| 6e 63 69 6e 67 20 69 6e | 64 69 63 65 73 2e 20 20 |ncing in|dices. |
|00000560| 41 20 63 6f 6e 76 65 72 | 73 69 6f 6e 0a 75 74 69 |A conver|sion.uti|
|00000570| 6c 69 74 79 20 66 6f 72 | 20 4d 65 74 61 6c 42 61 |lity for| MetalBa|
|00000580| 73 65 20 34 2e 30 20 61 | 6e 64 20 34 2e 31 61 20 |se 4.0 a|nd 4.1a |
|00000590| 72 65 6c 61 74 69 6f 6e | 73 20 69 73 20 70 72 6f |relation|s is pro|
|000005a0| 76 69 64 65 64 2e 20 20 | 4f 74 68 65 72 20 66 65 |vided. |Other fe|
|000005b0| 61 74 75 72 65 73 0a 69 | 6e 63 6c 75 64 65 20 72 |atures.i|nclude r|
|000005c0| 75 6e 2d 74 69 6d 65 20 | 65 6e 63 72 79 70 74 69 |un-time |encrypti|
|000005d0| 6f 6e 20 6f 6e 20 61 6c | 6c 20 70 6c 61 74 66 6f |on on al|l platfo|
|000005e0| 72 6d 73 2c 20 63 72 65 | 61 74 69 6f 6e 20 6f 66 |rms, cre|ation of|
|000005f0| 20 72 65 6c 61 74 69 6f | 6e 73 20 6f 6e 2d 74 68 | relatio|ns on-th|
|00000600| 65 2d 66 6c 79 0a 61 6e | 64 20 61 20 66 6c 65 78 |e-fly.an|d a flex|
|00000610| 69 62 6c 65 20 72 65 70 | 6f 72 74 20 77 72 69 74 |ible rep|ort writ|
|00000620| 65 72 2e 0a 0a 52 69 63 | 68 69 64 0a 2d 2d 2d 2d |er...Ric|hid.----|
|00000630| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 2d 2d 2d 2d 2d 2d 2d |--------|--------|
|00000640| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 2d 2d 2d 2d 2d 2d 2d |--------|--------|
|00000650| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 2d 2d 2d 2d 2d 2d 2d |--------|--------|
|00000660| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 2d 2d 2d 2d 2d 2d 2d |--------|--------|
|00000670| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 2d 2d 0a 23 21 20 2f |--------|---.#! /|
|00000680| 62 69 6e 2f 73 68 0a 23 | 20 54 68 69 73 20 69 73 |bin/sh.#| This is|
|00000690| 20 61 20 73 68 65 6c 6c | 20 61 72 63 68 69 76 65 | a shell| archive|
|000006a0| 2e 20 20 52 65 6d 6f 76 | 65 20 61 6e 79 74 68 69 |. Remov|e anythi|
|000006b0| 6e 67 20 62 65 66 6f 72 | 65 20 74 68 69 73 20 6c |ng befor|e this l|
|000006c0| 69 6e 65 2c 20 74 68 65 | 6e 20 66 65 65 64 20 69 |ine, the|n feed i|
|000006d0| 74 0a 23 20 69 6e 74 6f | 20 61 20 73 68 65 6c 6c |t.# into| a shell|
|000006e0| 20 76 69 61 20 22 73 68 | 20 66 69 6c 65 22 20 6f | via "sh| file" o|
|000006f0| 72 20 73 69 6d 69 6c 61 | 72 2e 20 20 54 6f 20 6f |r simila|r. To o|
|00000700| 76 65 72 77 72 69 74 65 | 20 65 78 69 73 74 69 6e |verwrite| existin|
|00000710| 67 20 66 69 6c 65 73 2c | 0a 23 20 74 79 70 65 20 |g files,|.# type |
|00000720| 22 73 68 20 66 69 6c 65 | 20 2d 63 22 2e 0a 23 20 |"sh file| -c"..# |
|00000730| 43 6f 6e 74 65 6e 74 73 | 3a 20 20 61 64 76 65 72 |Contents|: adver|
|00000740| 74 20 64 6f 78 20 64 6f | 78 2f 6d 62 61 73 65 2e |t dox do|x/mbase.|
|00000750| 64 6f 78 20 73 61 6d 70 | 6c 65 20 73 72 63 20 73 |dox samp|le src s|
|00000760| 72 63 2f 75 74 69 6c 31 | 2e 63 0a 23 20 57 72 61 |rc/util1|.c.# Wra|
|00000770| 70 70 65 64 20 62 79 20 | 6b 65 6e 74 40 73 70 61 |pped by |kent@spa|
|00000780| 72 6b 79 20 6f 6e 20 4d | 6f 6e 20 4e 6f 76 20 32 |rky on M|on Nov 2|
|00000790| 33 20 31 36 3a 33 33 3a | 31 31 20 31 39 39 32 0a |3 16:33:|11 1992.|
|000007a0| 50 41 54 48 3d 2f 62 69 | 6e 3a 2f 75 73 72 2f 62 |PATH=/bi|n:/usr/b|
|000007b0| 69 6e 3a 2f 75 73 72 2f | 75 63 62 3a 2f 75 73 72 |in:/usr/|ucb:/usr|
|000007c0| 2f 6c 6f 63 61 6c 2f 62 | 69 6e 3a 2f 75 73 72 2f |/local/b|in:/usr/|
|000007d0| 6c 62 69 6e 20 3b 20 65 | 78 70 6f 72 74 20 50 41 |lbin ; e|xport PA|
|000007e0| 54 48 0a 65 63 68 6f 20 | 49 66 20 74 68 69 73 20 |TH.echo |If this |
|000007f0| 61 72 63 68 69 76 65 20 | 69 73 20 63 6f 6d 70 6c |archive |is compl|
|00000800| 65 74 65 2c 20 79 6f 75 | 20 77 69 6c 6c 20 73 65 |ete, you| will se|
|00000810| 65 20 74 68 65 20 66 6f | 6c 6c 6f 77 69 6e 67 20 |e the fo|llowing |
|00000820| 6d 65 73 73 61 67 65 3a | 0a 65 63 68 6f 20 27 20 |message:|.echo ' |
|00000830| 20 20 20 20 20 20 20 20 | 20 22 73 68 61 72 3a 20 | | "shar: |
|00000840| 45 6e 64 20 6f 66 20 61 | 72 63 68 69 76 65 20 31 |End of a|rchive 1|
|00000850| 20 28 6f 66 20 38 29 2e | 22 27 0a 69 66 20 74 65 | (of 8).|"'.if te|
|00000860| 73 74 20 2d 66 20 27 61 | 64 76 65 72 74 27 20 2d |st -f 'a|dvert' -|
|00000870| 61 20 22 24 7b 31 7d 22 | 20 21 3d 20 22 2d 63 22 |a "${1}"| != "-c"|
|00000880| 20 3b 20 74 68 65 6e 20 | 0a 20 20 65 63 68 6f 20 | ; then |. echo |
|00000890| 73 68 61 72 3a 20 57 69 | 6c 6c 20 6e 6f 74 20 63 |shar: Wi|ll not c|
|000008a0| 6c 6f 62 62 65 72 20 65 | 78 69 73 74 69 6e 67 20 |lobber e|xisting |
|000008b0| 66 69 6c 65 20 5c 22 27 | 61 64 76 65 72 74 27 5c |file \"'|advert'\|
|000008c0| 22 0a 65 6c 73 65 0a 20 | 20 65 63 68 6f 20 73 68 |".else. | echo sh|
|000008d0| 61 72 3a 20 45 78 74 72 | 61 63 74 69 6e 67 20 5c |ar: Extr|acting \|
|000008e0| 22 27 61 64 76 65 72 74 | 27 5c 22 20 5c 28 31 33 |"'advert|'\" \(13|
|000008f0| 39 37 20 63 68 61 72 61 | 63 74 65 72 73 5c 29 0a |97 chara|cters\).|
|00000900| 20 20 73 65 64 20 22 73 | 2f 5e 58 2f 2f 22 20 3e | sed "s|/^X//" >|
|00000910| 27 61 64 76 65 72 74 27 | 20 3c 3c 27 45 4e 44 5f |'advert'| <<'END_|
|00000920| 4f 46 5f 46 49 4c 45 27 | 0a 58 41 64 76 65 72 74 |OF_FILE'|.XAdvert|
|00000930| 69 73 65 6d 65 6e 74 20 | 3a 29 20 20 20 20 20 20 |isement |:) |
|00000940| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00000950| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00000960| 20 20 20 20 20 20 20 20 | 20 20 20 20 4d 65 74 61 | | Meta|
|00000970| 6c 42 61 73 65 20 35 2e | 30 0a 58 2d 2d 2d 2d 2d |lBase 5.|0.X-----|
|00000980| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 2d 2d 2d 2d 2d 2d 2d |--------|--------|
|00000990| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 2d 2d 2d 2d 2d 2d 2d |--------|--------|
|000009a0| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 2d 2d 2d 2d 2d 2d 2d |--------|--------|
|000009b0| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 2d 2d 2d 2d 2d 2d 2d |--------|--------|
|000009c0| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 2d 0a 58 0a 58 49 27 |--------|--.X.XI'|
|000009d0| 6d 20 6c 6f 6f 6b 69 6e | 67 20 66 6f 72 20 65 69 |m lookin|g for ei|
|000009e0| 74 68 65 72 20 6f 66 20 | 74 77 6f 20 74 68 69 6e |ther of |two thin|
|000009f0| 67 73 3a 0a 58 0a 58 20 | 20 20 2d 20 41 6e 20 69 |gs:.X.X | - An i|
|00000a00| 6e 74 65 72 6e 65 74 20 | 6e 65 77 73 66 65 65 64 |nternet |newsfeed|
|00000a10| 20 28 41 4e 59 20 66 65 | 65 64 2c 20 73 74 61 62 | (ANY fe|ed, stab|
|00000a20| 6c 65 20 6f 72 20 6e 6f | 74 29 20 6c 6f 63 61 6c |le or no|t) local|
|00000a30| 20 74 6f 20 63 65 6e 74 | 72 61 6c 20 49 6f 77 61 | to cent|ral Iowa|
|00000a40| 2c 0a 58 20 20 20 20 20 | 61 72 6f 75 6e 64 20 41 |,.X |around A|
|00000a50| 6d 65 73 2f 44 65 73 20 | 4d 6f 69 6e 65 73 20 70 |mes/Des |Moines p|
|00000a60| 72 65 66 65 72 61 62 6c | 79 2e 0a 58 0a 58 20 20 |referabl|y..X.X |
|00000a70| 20 2d 20 41 20 6a 6f 62 | 20 6c 6f 63 61 74 65 64 | - A job| located|
|00000a80| 20 73 6f 6d 65 77 68 65 | 72 65 20 69 6e 20 49 6f | somewhe|re in Io|
|00000a90| 77 61 2c 20 61 67 61 69 | 6e 2c 20 70 72 65 66 65 |wa, agai|n, prefe|
|00000aa0| 72 61 62 6c 79 20 6e 65 | 61 72 20 44 65 73 20 4d |rably ne|ar Des M|
|00000ab0| 6f 69 6e 65 73 2e 20 20 | 49 0a 58 20 20 20 20 20 |oines. |I.X |
|00000ac0| 6b 6e 6f 77 2c 20 49 20 | 6b 6e 6f 77 2d 2d 22 49 |know, I |know--"I|
|00000ad0| 6f 77 61 3f 3f 3f 22 20 | 20 54 68 61 74 27 73 20 |owa???" | That's |
|00000ae0| 77 68 61 74 20 65 76 65 | 72 79 6f 6e 65 20 73 61 |what eve|ryone sa|
|00000af0| 79 73 2e 20 20 42 75 74 | 20 6d 79 20 53 4f 20 69 |ys. But| my SO i|
|00000b00| 73 20 73 74 61 72 74 69 | 6e 67 0a 58 20 20 20 20 |s starti|ng.X |
|00000b10| 20 73 63 68 6f 6f 6c 20 | 61 74 20 47 72 69 6e 6e | school |at Grinn|
|00000b20| 65 6c 6c 20 74 68 69 73 | 20 66 61 6c 6c 2c 20 61 |ell this| fall, a|
|00000b30| 6e 64 20 49 20 77 61 6e | 6e 61 20 62 65 20 61 72 |nd I wan|na be ar|
|00000b40| 6f 75 6e 64 20 66 6f 72 | 20 69 74 2e 0a 58 0a 58 |ound for| it..X.X|
|00000b50| 20 20 20 20 20 4d 69 63 | 72 6f 73 6f 66 74 27 73 | Mic|rosoft's|
|00000b60| 20 62 65 69 6e 67 20 6e | 69 63 65 20 74 6f 20 6d | being n|ice to m|
|00000b70| 65 2c 20 62 75 74 20 6d | 79 20 69 6e 74 65 72 6e |e, but m|y intern|
|00000b80| 73 68 69 70 20 77 69 6c | 6c 20 62 65 20 6f 76 65 |ship wil|l be ove|
|00000b90| 72 20 61 72 6f 75 6e 64 | 0a 58 20 20 20 20 20 4a |r around|.X J|
|00000ba0| 61 6e 75 61 72 79 20 6f | 66 20 31 39 39 33 3b 20 |anuary o|f 1993; |
|00000bb0| 61 6e 64 20 27 63 61 75 | 73 65 20 6f 66 20 72 65 |and 'cau|se of re|
|00000bc0| 67 75 6c 61 74 69 6f 6e | 73 2c 20 74 68 65 79 20 |gulation|s, they |
|00000bd0| 63 61 6e 27 74 20 68 69 | 72 65 20 61 6e 20 69 6e |can't hi|re an in|
|00000be0| 74 65 72 6e 0a 58 20 20 | 20 20 20 61 67 61 69 6e |tern.X | again|
|00000bf0| 20 75 6e 74 69 6c 20 58 | 20 6d 6f 6e 74 68 73 20 | until X| months |
|00000c00| 61 66 74 65 72 20 74 68 | 65 20 6c 61 73 74 20 69 |after th|e last i|
|00000c10| 6e 74 65 72 6e 73 68 69 | 70 20 65 6e 64 65 64 2e |nternshi|p ended.|
|00000c20| 20 20 53 6f 20 49 27 76 | 65 20 67 6f 74 74 61 20 | So I'v|e gotta |
|00000c30| 66 69 6e 64 0a 58 20 20 | 20 20 20 73 6f 6d 65 62 |find.X | someb|
|00000c40| 6f 64 79 20 65 6c 73 65 | 20 69 6e 73 74 65 61 64 |ody else| instead|
|00000c50| 2e 2e 2e 0a 58 0a 58 20 | 20 20 20 20 49 66 20 79 |....X.X | If y|
|00000c60| 6f 75 72 20 63 6f 6d 70 | 61 6e 79 20 69 73 20 69 |our comp|any is i|
|00000c70| 6e 20 6e 65 65 64 20 6f | 66 20 61 20 76 65 72 79 |n need o|f a very|
|00000c80| 20 65 78 70 65 72 69 65 | 6e 63 65 64 20 55 6e 69 | experie|nced Uni|
|00000c90| 78 2f 4d 53 44 4f 53 2f | 56 4d 53 0a 58 20 20 20 |x/MSDOS/|VMS.X |
|00000ca0| 20 20 43 2f 43 2b 2b 2f | 50 61 73 63 61 6c 2f 46 | C/C++/|Pascal/F|
|00000cb0| 4f 52 54 52 41 4e 2f 36 | 38 30 78 30 2f 38 30 78 |ORTRAN/6|80x0/80x|
|00000cc0| 38 36 2f 36 35 30 32 20 | 70 72 6f 67 72 61 6d 6d |86/6502 |programm|
|00000cd0| 65 72 2c 20 6c 65 74 20 | 6d 65 20 6b 6e 6f 77 20 |er, let |me know |
|00000ce0| 61 6e 64 20 49 27 6c 6c | 0a 58 20 20 20 20 20 66 |and I'll|.X f|
|00000cf0| 6c 6f 61 74 20 79 6f 75 | 20 61 20 72 65 73 75 6d |loat you| a resum|
|00000d00| 65 2e 20 20 49 27 6d 20 | 75 6e 73 75 72 65 20 6f |e. I'm |unsure o|
|00000d10| 66 20 6d 79 20 69 6e 74 | 65 72 6e 65 74 20 63 6f |f my int|ernet co|
|00000d20| 6e 6e 65 63 74 69 6f 6e | 20 66 6f 72 20 61 20 77 |nnection| for a w|
|00000d30| 68 69 6c 65 2c 20 73 6f | 0a 58 20 20 20 20 20 63 |hile, so|.X c|
|00000d40| 6f 6e 74 61 63 74 20 6d | 65 20 74 68 72 6f 75 67 |ontact m|e throug|
|00000d50| 68 3a 0a 58 20 20 20 20 | 20 20 20 20 20 20 20 52 |h:.X | R|
|00000d60| 69 63 68 61 72 64 20 50 | 20 4a 65 72 6e 69 67 61 |ichard P| Jerniga|
|00000d70| 6e 20 49 56 0a 58 20 20 | 20 20 20 20 20 20 20 20 |n IV.X | |
|00000d80| 20 50 4f 20 42 6f 78 20 | 38 32 37 0a 58 20 20 20 | PO Box |827.X |
|00000d90| 20 20 20 20 20 20 20 20 | 4e 6f 72 72 69 73 2c 20 | |Norris, |
|00000da0| 54 4e 20 20 33 37 38 32 | 38 0a 58 20 20 20 20 20 |TN 3782|8.X |
|00000db0| 20 20 20 20 20 20 20 20 | 36 31 35 2d 34 39 34 2d | |615-494-|
|00000dc0| 30 34 34 35 0a 58 20 20 | 20 20 20 4f 6b 61 79 2e |0445.X | Okay.|
|00000dd0| 20 20 53 6f 20 77 68 61 | 74 20 61 72 65 20 74 68 | So wha|t are th|
|00000de0| 65 20 6f 64 64 73 20 49 | 27 6c 6c 20 67 65 74 20 |e odds I|'ll get |
|00000df0| 61 20 72 65 73 70 6f 6e | 73 65 20 74 6f 20 74 68 |a respon|se to th|
|00000e00| 61 74 3f 20 20 3a 29 0a | 58 0a 58 50 6f 73 74 53 |at? :).|X.XPostS|
|00000e10| 63 72 69 70 74 3a 20 20 | 49 20 61 63 74 75 61 6c |cript: |I actual|
|00000e20| 6c 79 20 44 49 44 20 67 | 65 74 20 61 20 72 65 73 |ly DID g|et a res|
|00000e30| 70 6f 6e 73 65 21 20 20 | 44 69 64 6e 27 74 20 74 |ponse! |Didn't t|
|00000e40| 61 6b 65 20 27 65 6d 20 | 75 70 20 27 63 61 75 73 |ake 'em |up 'caus|
|00000e50| 65 0a 58 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |e.X | |
|00000e60| 49 27 6d 20 64 6f 69 6e | 20 74 68 61 74 20 73 75 |I'm doin| that su|
|00000e70| 6d 6d 65 72 20 74 68 61 | 6e 67 20 61 74 20 4d 69 |mmer tha|ng at Mi|
|00000e80| 63 72 6f 73 6f 66 74 2e | 20 20 42 75 74 20 61 73 |crosoft.| But as|
|00000e90| 20 49 20 73 61 69 64 2c | 20 74 68 61 74 27 73 0a | I said,| that's.|
|00000ea0| 58 20 20 20 20 20 20 20 | 20 20 20 20 20 20 61 6c |X | al|
|00000eb0| 6d 6f 73 74 20 6f 76 65 | 72 2e 0a 58 0a 45 4e 44 |most ove|r..X.END|
|00000ec0| 5f 4f 46 5f 46 49 4c 45 | 0a 20 20 69 66 20 74 65 |_OF_FILE|. if te|
|00000ed0| 73 74 20 31 33 39 37 20 | 2d 6e 65 20 60 77 63 20 |st 1397 |-ne `wc |
|00000ee0| 2d 63 20 3c 27 61 64 76 | 65 72 74 27 60 3b 20 74 |-c <'adv|ert'`; t|
|00000ef0| 68 65 6e 0a 20 20 20 20 | 65 63 68 6f 20 73 68 61 |hen. |echo sha|
|00000f00| 72 3a 20 5c 22 27 61 64 | 76 65 72 74 27 5c 22 20 |r: \"'ad|vert'\" |
|00000f10| 75 6e 70 61 63 6b 65 64 | 20 77 69 74 68 20 77 72 |unpacked| with wr|
|00000f20| 6f 6e 67 20 73 69 7a 65 | 21 0a 20 20 66 69 0a 20 |ong size|!. fi. |
|00000f30| 20 23 20 65 6e 64 20 6f | 66 20 27 61 64 76 65 72 | # end o|f 'adver|
|00000f40| 74 27 0a 66 69 0a 69 66 | 20 74 65 73 74 20 21 20 |t'.fi.if| test ! |
|00000f50| 2d 64 20 27 64 6f 78 27 | 20 3b 20 74 68 65 6e 0a |-d 'dox'| ; then.|
|00000f60| 20 20 20 20 65 63 68 6f | 20 73 68 61 72 3a 20 43 | echo| shar: C|
|00000f70| 72 65 61 74 69 6e 67 20 | 64 69 72 65 63 74 6f 72 |reating |director|
|00000f80| 79 20 5c 22 27 64 6f 78 | 27 5c 22 0a 20 20 20 20 |y \"'dox|'\". |
|00000f90| 6d 6b 64 69 72 20 27 64 | 6f 78 27 0a 66 69 0a 69 |mkdir 'd|ox'.fi.i|
|00000fa0| 66 20 74 65 73 74 20 2d | 66 20 27 64 6f 78 2f 6d |f test -|f 'dox/m|
|00000fb0| 62 61 73 65 2e 64 6f 78 | 27 20 2d 61 20 22 24 7b |base.dox|' -a "${|
|00000fc0| 31 7d 22 20 21 3d 20 22 | 2d 63 22 20 3b 20 74 68 |1}" != "|-c" ; th|
|00000fd0| 65 6e 20 0a 20 20 65 63 | 68 6f 20 73 68 61 72 3a |en . ec|ho shar:|
|00000fe0| 20 57 69 6c 6c 20 6e 6f | 74 20 63 6c 6f 62 62 65 | Will no|t clobbe|
|00000ff0| 72 20 65 78 69 73 74 69 | 6e 67 20 66 69 6c 65 20 |r existi|ng file |
|00001000| 5c 22 27 64 6f 78 2f 6d | 62 61 73 65 2e 64 6f 78 |\"'dox/m|base.dox|
|00001010| 27 5c 22 0a 65 6c 73 65 | 0a 20 20 65 63 68 6f 20 |'\".else|. echo |
|00001020| 73 68 61 72 3a 20 45 78 | 74 72 61 63 74 69 6e 67 |shar: Ex|tracting|
|00001030| 20 5c 22 27 64 6f 78 2f | 6d 62 61 73 65 2e 64 6f | \"'dox/|mbase.do|
|00001040| 78 27 5c 22 20 5c 28 33 | 33 30 33 32 20 63 68 61 |x'\" \(3|3032 cha|
|00001050| 72 61 63 74 65 72 73 5c | 29 0a 20 20 73 65 64 20 |racters\|). sed |
|00001060| 22 73 2f 5e 58 2f 2f 22 | 20 3e 27 64 6f 78 2f 6d |"s/^X//"| >'dox/m|
|00001070| 62 61 73 65 2e 64 6f 78 | 27 20 3c 3c 27 45 4e 44 |base.dox|' <<'END|
|00001080| 5f 4f 46 5f 46 49 4c 45 | 27 0a 58 20 20 20 20 2f |_OF_FILE|'.X /|
|00001090| 5c 0a 58 20 20 20 2f 20 | 20 5c 0a 58 2e 2e 2f 20 |\.X / | \.X../ |
|000010a0| 20 20 20 5c 2e 2e 2e 2e | 4d 45 54 41 4c 42 41 53 | \....|METALBAS|
|000010b0| 45 20 56 65 72 73 69 6f | 6e 20 35 2e 30 2e 2e 2e |E Versio|n 5.0...|
|000010c0| 2e 2e 2e 2e 2e 2e 2e 2e | 2e 2e 2e 2e 2e 2e 2e 2e |........|........|
|000010d0| 2e 2e 2e 2e 2e 2e 2e 2e | 2e 2e 2e 2e 2e 2e 2e 2e |........|........|
|000010e0| 2e 2e 2e 2e 2e 2e 2e 2e | 2e 2e 2e 0a 58 20 2f 20 |........|....X / |
|000010f0| 20 20 20 20 20 5c 0a 58 | 2f 20 20 20 20 20 20 20 | \.X|/ |
|00001100| 20 5c 20 20 57 72 69 74 | 74 65 6e 20 46 72 6f 6d | \ Writ|ten From|
|00001110| 20 4f 63 74 6f 62 65 72 | 20 31 39 39 30 20 62 79 | October| 1990 by|
|00001120| 20 48 75 61 6e 2d 54 69 | 0a 58 5c 20 20 20 20 20 | Huan-Ti|.X\ |
|00001130| 20 20 20 2f 0a 58 20 5c | 20 20 20 20 20 20 2f 20 | /.X \| / |
|00001140| 20 20 52 65 76 69 73 69 | 6f 6e 20 33 2e 31 20 72 | Revisi|on 3.1 r|
|00001150| 65 6c 65 61 73 65 64 20 | 44 65 63 65 6d 62 65 72 |eleased |December|
|00001160| 20 31 30 74 68 20 31 39 | 39 30 0a 58 20 20 5c 20 | 10th 19|90.X \ |
|00001170| 20 20 20 2f 20 20 20 20 | 52 65 76 69 73 69 6f 6e | / |Revision|
|00001180| 20 33 2e 32 20 72 65 6c | 65 61 73 65 64 20 44 65 | 3.2 rel|eased De|
|00001190| 63 65 6d 62 65 72 20 31 | 30 74 68 20 31 39 39 31 |cember 1|0th 1991|
|000011a0| 0a 58 20 20 20 5c 20 20 | 2f 20 20 20 20 20 52 65 |.X \ |/ Re|
|000011b0| 76 69 73 69 6f 6e 20 34 | 2e 30 20 72 65 6c 65 61 |vision 4|.0 relea|
|000011c0| 73 65 64 20 46 65 62 75 | 61 72 79 20 31 34 74 68 |sed Febu|ary 14th|
|000011d0| 20 31 39 39 32 0a 58 20 | 20 20 20 5c 2f 20 20 20 | 1992.X | \/ |
|000011e0| 20 20 20 52 65 76 69 73 | 69 6f 6e 20 34 2e 31 20 | Revis|ion 4.1 |
|000011f0| 72 65 6c 65 61 73 65 64 | 20 41 70 72 69 6c 20 31 |released| April 1|
|00001200| 73 74 20 31 39 39 32 0a | 58 20 20 20 20 20 20 20 |st 1992.|X |
|00001210| 20 20 20 20 20 52 65 76 | 69 73 69 6f 6e 20 34 2e | Rev|ision 4.|
|00001220| 31 61 20 72 65 6c 65 61 | 73 65 64 20 4d 61 79 20 |1a relea|sed May |
|00001230| 31 30 74 68 20 31 39 39 | 32 0a 58 20 20 20 20 20 |10th 199|2.X |
|00001240| 20 20 20 20 20 20 20 52 | 65 76 69 73 69 6f 6e 20 | R|evision |
|00001250| 35 2e 30 20 72 65 6c 65 | 61 73 65 64 20 4f 63 74 |5.0 rele|ased Oct|
|00001260| 6f 62 65 72 20 31 73 74 | 20 31 39 39 32 0a 58 0a |ober 1st| 1992.X.|
|00001270| 58 0a 58 0a 58 0a 58 0a | 58 0a 58 20 20 20 20 20 |X.X.X.X.|X.X |
|00001280| 20 20 22 41 6e 64 20 43 | 61 6c 76 69 6e 20 61 74 | "And C|alvin at|
|00001290| 65 2e 20 20 41 6e 64 20 | 46 6f 6f 64 20 4c 69 6f |e. And |Food Lio|
|000012a0| 6e 20 77 65 6e 74 20 6f | 75 74 20 6f 66 20 62 75 |n went o|ut of bu|
|000012b0| 73 69 6e 65 73 73 2e 20 | 20 41 6d 65 6e 2e 22 0a |siness. | Amen.".|
|000012c0| 58 0a 58 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |X.X | |
|000012d0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|000012e0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|000012f0| 20 20 20 20 20 20 2d 2d | 31 73 74 20 43 61 6c 76 | --|1st Calv|
|00001300| 69 6e 20 34 3a 38 0a 58 | 0a 58 0a 58 57 48 59 5f |in 4:8.X|.X.XWHY_|
|00001310| 4d 45 54 41 4c 42 41 53 | 45 5f 3f 5f 5f 5f 5f 5f |METALBAS|E_?_____|
|00001320| 5f 5f 5f 5f 5f 5f 5f 5f | 5f 5f 5f 5f 5f 5f 5f 5f |________|________|
|00001330| 5f 5f 5f 5f 5f 5f 5f 5f | 5f 5f 5f 5f 5f 5f 5f 5f |________|________|
|00001340| 5f 5f 5f 5f 5f 5f 5f 5f | 5f 5f 5f 5f 5f 5f 5f 5f |________|________|
|00001350| 5f 5f 5f 5f 5f 5f 5f 5f | 5f 5f 5f 0a 58 0a 58 20 |________|___.X.X |
|00001360| 20 20 20 54 68 65 20 41 | 6d 69 67 61 20 35 30 30 | The A|miga 500|
|00001370| 20 6d 75 6c 74 69 2d 74 | 61 73 6b 73 2e 20 20 57 | multi-t|asks. W|
|00001380| 6f 77 2e 20 20 49 74 20 | 68 61 73 20 67 72 65 61 |ow. It |has grea|
|00001390| 74 20 67 72 61 70 68 69 | 63 73 2e 20 20 59 65 61 |t graphi|cs. Yea|
|000013a0| 68 2e 20 20 50 68 65 6e | 6f 6d 65 6e 61 6c 0a 58 |h. Phen|omenal.X|
|000013b0| 73 6f 75 6e 64 2e 20 20 | 59 69 70 70 65 65 2e 20 |sound. |Yippee. |
|000013c0| 20 49 74 20 63 6f 73 74 | 73 20 24 35 30 30 2e 20 | It cost|s $500. |
|000013d0| 20 49 20 62 6f 75 67 68 | 74 20 6f 6e 65 2e 0a 58 | I bough|t one..X|
|000013e0| 20 20 20 20 41 20 44 42 | 61 73 65 20 70 61 63 6b | A DB|ase pack|
|000013f0| 61 67 65 20 63 6f 73 74 | 73 20 6d 6f 72 65 20 74 |age cost|s more t|
|00001400| 68 61 6e 20 74 68 65 20 | 63 6f 6d 70 75 74 65 72 |han the |computer|
|00001410| 2e 20 20 53 6f 20 64 6f | 65 73 20 50 61 72 61 64 |. So do|es Parad|
|00001420| 6f 78 2e 20 20 41 6e 64 | 0a 58 49 6e 66 6f 72 6d |ox. And|.XInform|
|00001430| 69 78 2e 20 20 41 6e 64 | 20 61 6c 6d 6f 73 74 20 |ix. And| almost |
|00001440| 65 76 65 72 79 20 6f 74 | 68 65 72 20 64 61 74 61 |every ot|her data|
|00001450| 62 61 73 65 20 70 61 63 | 6b 61 67 65 20 6f 6e 20 |base pac|kage on |
|00001460| 74 68 65 20 6d 61 72 6b | 65 74 2e 20 20 49 20 64 |the mark|et. I d|
|00001470| 69 64 6e 27 74 0a 58 62 | 75 79 20 6f 6e 65 2e 0a |idn't.Xb|uy one..|
|00001480| 58 20 20 20 20 42 75 74 | 20 49 20 6e 65 65 64 65 |X But| I neede|
|00001490| 64 20 61 20 64 61 74 61 | 62 61 73 65 20 66 6f 72 |d a data|base for|
|000014a0| 20 6d 79 20 73 79 73 74 | 65 6d 2d 2d 61 6e 79 62 | my syst|em--anyb|
|000014b0| 6f 64 79 20 77 68 6f 27 | 73 20 65 76 65 72 20 77 |ody who'|s ever w|
|000014c0| 6f 72 6b 65 64 20 77 69 | 74 68 20 61 0a 58 64 61 |orked wi|th a.Xda|
|000014d0| 74 61 62 61 73 65 20 6b | 6e 6f 77 73 20 74 68 65 |tabase k|nows the|
|000014e0| 79 27 72 65 20 61 64 64 | 69 63 74 69 76 65 3b 20 |y're add|ictive; |
|000014f0| 63 6f 64 65 20 74 68 61 | 74 27 73 20 77 72 69 74 |code tha|t's writ|
|00001500| 74 65 6e 20 77 69 74 68 | 6f 75 74 20 61 20 66 6c |ten with|out a fl|
|00001510| 65 78 69 62 6c 65 0a 58 | 64 61 74 61 62 61 73 65 |exible.X|database|
|00001520| 20 62 61 63 6b 69 6e 67 | 20 69 74 20 75 70 20 6c | backing| it up l|
|00001530| 61 63 6b 73 20 73 6f 6d | 65 74 68 69 6e 67 2e 20 |acks som|ething. |
|00001540| 20 41 6e 64 20 44 42 61 | 73 65 20 77 61 6e 74 73 | And DBa|se wants|
|00001550| 20 24 36 30 30 20 74 6f | 20 70 75 74 20 74 68 61 | $600 to| put tha|
|00001560| 74 0a 58 73 6f 6d 65 74 | 68 69 6e 67 20 62 61 63 |t.Xsomet|hing bac|
|00001570| 6b 20 69 6e 74 6f 20 70 | 72 6f 67 72 61 6d 73 2e |k into p|rograms.|
|00001580| 20 20 4e 6f 20 74 68 61 | 6e 6b 73 2e 0a 58 20 20 | No tha|nks..X |
|00001590| 20 20 54 68 61 74 27 73 | 20 77 68 79 20 4d 65 74 | That's| why Met|
|000015a0| 61 6c 42 61 73 65 20 77 | 61 73 20 77 72 69 74 74 |alBase w|as writt|
|000015b0| 65 6e 2e 2e 2e 20 69 74 | 73 20 66 6f 72 65 72 75 |en... it|s foreru|
|000015c0| 6e 6e 65 72 73 20 28 76 | 65 72 73 69 6f 6e 73 20 |nners (v|ersions |
|000015d0| 31 2e 30 20 61 6e 64 0a | 58 32 2e 30 2c 20 6e 6f |1.0 and.|X2.0, no|
|000015e0| 74 20 61 76 61 69 6c 61 | 62 6c 65 29 20 77 65 72 |t availa|ble) wer|
|000015f0| 65 20 64 65 73 69 67 6e | 65 64 20 62 79 20 74 68 |e design|ed by th|
|00001600| 65 20 73 61 6d 65 20 61 | 75 74 68 6f 72 20 77 69 |e same a|uthor wi|
|00001610| 74 68 20 74 68 65 20 41 | 6d 69 67 61 20 6c 69 6e |th the A|miga lin|
|00001620| 65 27 73 0a 58 6e 65 65 | 64 73 20 73 70 65 63 69 |e's.Xnee|ds speci|
|00001630| 66 69 63 61 6c 6c 79 20 | 69 6e 20 6d 69 6e 64 3a |fically |in mind:|
|00001640| 20 20 72 65 6c 61 74 69 | 76 65 6c 79 20 73 6c 6f | relati|vely slo|
|00001650| 77 20 66 6c 6f 70 70 79 | 20 64 72 69 76 65 73 20 |w floppy| drives |
|00001660| 28 43 6f 6d 70 61 72 65 | 64 20 74 6f 20 68 61 72 |(Compare|d to har|
|00001670| 64 0a 58 64 72 69 76 65 | 73 29 2c 20 73 6f 20 73 |d.Xdrive|s), so s|
|00001680| 70 61 72 73 65 20 72 65 | 61 64 2d 68 65 61 64 20 |parse re|ad-head |
|00001690| 6d 61 6e 65 75 76 65 72 | 69 6e 67 20 77 61 73 20 |maneuver|ing was |
|000016a0| 65 73 73 65 6e 74 69 61 | 6c 2e 20 20 52 65 6c 61 |essentia|l. Rela|
|000016b0| 74 69 76 65 6c 79 20 73 | 6d 61 6c 6c 0a 58 6d 65 |tively s|mall.Xme|
|000016c0| 6d 6f 72 79 2c 20 77 68 | 65 6e 20 63 6f 6d 70 61 |mory, wh|en compa|
|000016d0| 72 65 64 20 77 69 74 68 | 20 74 68 65 20 61 6d 6f |red with| the amo|
|000016e0| 75 6e 74 73 20 6f 66 20 | 6d 65 6d 6f 72 79 20 72 |unts of |memory r|
|000016f0| 65 71 75 69 72 65 64 20 | 62 79 20 6d 6f 73 74 20 |equired |by most |
|00001700| 43 20 63 6f 6d 70 69 6c | 65 72 73 0a 58 28 4c 61 |C compil|ers.X(La|
|00001710| 74 74 69 63 65 20 6e 65 | 65 64 73 20 72 6f 75 67 |ttice ne|eds roug|
|00001720| 68 6c 79 20 33 30 30 6b | 20 6a 75 73 74 20 74 6f |hly 300k| just to|
|00001730| 20 72 75 6e 2c 20 66 6f | 72 20 65 78 61 6d 70 6c | run, fo|r exampl|
|00001740| 65 29 2c 20 73 6f 20 74 | 68 65 20 63 6f 64 65 20 |e), so t|he code |
|00001750| 68 61 64 20 74 6f 20 62 | 65 0a 58 63 6f 6e 73 69 |had to b|e.Xconsi|
|00001760| 73 65 2c 20 70 75 72 65 | 2c 20 61 6e 64 20 75 73 |se, pure|, and us|
|00001770| 65 20 66 65 77 20 76 61 | 72 69 61 62 6c 65 73 2e |e few va|riables.|
|00001780| 20 20 45 78 70 61 6e 73 | 69 6f 6e 20 77 61 73 20 | Expans|ion was |
|00001790| 61 6c 77 61 79 73 20 61 | 76 61 69 6c 61 62 6c 65 |always a|vailable|
|000017a0| 3b 20 68 61 72 64 0a 58 | 64 72 69 76 65 73 2c 20 |; hard.X|drives, |
|000017b0| 68 75 67 65 20 6d 65 6d | 6f 72 79 20 63 61 70 61 |huge mem|ory capa|
|000017c0| 63 69 74 69 65 73 2c 20 | 65 78 74 72 61 20 70 72 |cities, |extra pr|
|000017d0| 6f 63 65 73 73 6f 72 73 | 2c 20 72 61 6d 20 64 72 |ocessors|, ram dr|
|000017e0| 69 76 65 73 20 2d 2d 20 | 73 6f 20 74 68 65 20 73 |ives -- |so the s|
|000017f0| 79 73 74 65 6d 0a 58 68 | 61 64 20 74 6f 20 62 65 |ystem.Xh|ad to be|
|00001800| 20 72 65 61 64 69 6c 79 | 20 65 78 70 61 6e 64 69 | readily| expandi|
|00001810| 62 6c 65 20 61 6e 64 20 | 66 6c 65 78 69 62 6c 65 |ble and |flexible|
|00001820| 20 65 6e 6f 75 67 68 20 | 74 6f 20 6d 65 65 74 20 | enough |to meet |
|00001830| 74 68 65 20 72 65 71 75 | 69 72 65 6d 65 6e 74 73 |the requ|irements|
|00001840| 20 6f 66 0a 58 62 6f 74 | 68 20 61 20 35 31 32 6b | of.Xbot|h a 512k|
|00001850| 2c 20 31 2d 64 72 69 76 | 65 20 6d 61 63 68 69 6e |, 1-driv|e machin|
|00001860| 65 20 61 6e 64 20 61 20 | 33 32 2d 6d 65 67 61 62 |e and a |32-megab|
|00001870| 79 74 65 2c 20 32 30 30 | 2d 6d 65 67 20 68 61 72 |yte, 200|-meg har|
|00001880| 64 20 64 72 69 76 65 2d | 64 72 69 76 65 6e 0a 58 |d drive-|driven.X|
|00001890| 73 65 74 75 70 2e 20 20 | 41 6e 64 20 74 68 65 79 |setup. |And they|
|000018a0| 20 77 65 72 65 2e 0a 58 | 20 20 20 20 54 68 65 20 | were..X| The |
|000018b0| 70 72 6f 62 6c 65 6d 20 | 77 61 73 2c 20 41 6d 69 |problem |was, Ami|
|000018c0| 67 61 73 20 63 61 6e 20 | 6d 75 6c 74 69 2d 74 61 |gas can |multi-ta|
|000018d0| 73 6b 2e 20 20 53 6f 20 | 77 68 61 74 20 69 73 20 |sk. So |what is |
|000018e0| 74 68 65 20 72 65 73 74 | 20 6f 66 20 74 68 65 0a |the rest| of the.|
|000018f0| 58 63 6f 6d 70 75 74 65 | 72 20 64 6f 69 6e 67 20 |Xcompute|r doing |
|00001900| 77 68 69 6c 65 20 61 20 | 64 61 74 61 62 61 73 65 |while a |database|
|00001910| 20 72 75 6e 73 20 61 72 | 6f 75 6e 64 20 6c 6f 6f | runs ar|ound loo|
|00001920| 6b 69 6e 67 20 75 70 20 | 72 65 63 6f 72 64 73 20 |king up |records |
|00001930| 6f 6e 20 6f 6e 65 20 64 | 72 69 76 65 3f 0a 58 4e |on one d|rive?.XN|
|00001940| 6f 74 68 69 6e 67 2e 20 | 20 57 68 79 20 6e 6f 74 |othing. | Why not|
|00001950| 20 6c 65 74 20 69 74 20 | 6c 6f 6f 6b 20 75 70 20 | let it |look up |
|00001960| 72 65 63 6f 72 64 73 20 | 6f 6e 20 61 6e 6f 74 68 |records |on anoth|
|00001970| 65 72 20 64 72 69 76 65 | 3f 20 20 46 69 6e 65 2e |er drive|? Fine.|
|00001980| 2e 2e 20 74 68 61 74 20 | 77 6f 72 6b 73 2e 0a 58 |.. that |works..X|
|00001990| 57 68 61 74 20 61 62 6f | 75 74 20 6f 6e 20 74 68 |What abo|ut on th|
|000019a0| 65 20 73 61 6d 65 20 64 | 72 69 76 65 2e 2e 2e 20 |e same d|rive... |
|000019b0| 75 73 69 6e 67 2c 20 73 | 61 79 2c 20 61 20 72 61 |using, s|ay, a ra|
|000019c0| 6d 20 64 69 73 6b 2c 20 | 73 6f 20 74 68 65 72 65 |m disk, |so there|
|000019d0| 20 61 72 65 20 6e 6f 20 | 72 65 61 6c 0a 58 72 65 | are no |real.Xre|
|000019e0| 61 64 2d 68 65 61 64 73 | 20 74 6f 20 77 6f 72 72 |ad-heads| to worr|
|000019f0| 79 20 61 62 6f 75 74 20 | 70 6f 73 69 74 69 6f 6e |y about |position|
|00001a00| 69 6e 67 3f 20 20 54 68 | 61 74 20 77 6f 75 6c 64 |ing? Th|at would|
|00001a10| 20 6d 65 61 6e 20 65 61 | 63 68 20 72 65 6c 61 74 | mean ea|ch relat|
|00001a20| 69 6f 6e 20 77 6f 75 6c | 64 0a 58 68 61 76 65 20 |ion woul|d.Xhave |
|00001a30| 74 6f 20 73 75 70 70 6f | 72 74 20 6d 75 6c 74 69 |to suppo|rt multi|
|00001a40| 2d 75 73 65 72 20 61 63 | 63 65 73 73 2e 2e 2e 20 |-user ac|cess... |
|00001a50| 61 20 72 65 71 75 69 72 | 65 6d 65 6e 74 20 61 72 |a requir|ement ar|
|00001a60| 6f 75 6e 64 20 77 68 69 | 63 68 20 4d 65 74 61 6c |ound whi|ch Metal|
|00001a70| 42 61 73 65 0a 58 76 65 | 72 73 69 6f 6e 73 20 33 |Base.Xve|rsions 3|
|00001a80| 2e 30 20 61 6e 64 20 75 | 70 20 66 6f 63 75 73 2e |.0 and u|p focus.|
|00001a90| 20 20 4e 6f 74 20 6f 6e | 6c 79 20 63 61 6e 20 61 | Not on|ly can a|
|00001aa0| 6e 79 20 67 69 76 65 6e | 20 74 65 72 6d 69 6e 61 |ny given| termina|
|00001ab0| 6c 20 61 63 63 65 73 73 | 20 6d 61 6e 79 20 66 69 |l access| many fi|
|00001ac0| 6c 65 73 0a 58 61 74 20 | 6f 6e 63 65 2c 20 62 75 |les.Xat |once, bu|
|00001ad0| 74 20 6f 6e 20 6d 75 6c | 74 69 2d 74 65 72 6d 69 |t on mul|ti-termi|
|00001ae0| 6e 61 6c 20 73 79 73 74 | 65 6d 73 2c 20 65 61 63 |nal syst|ems, eac|
|00001af0| 68 20 74 65 72 6d 69 6e | 61 6c 20 63 61 6e 20 77 |h termin|al can w|
|00001b00| 6f 72 6b 20 73 69 6d 75 | 6c 74 61 6e 65 6f 75 73 |ork simu|ltaneous|
|00001b10| 6c 79 0a 58 6f 6e 20 61 | 6e 79 20 67 69 76 65 6e |ly.Xon a|ny given|
|00001b20| 20 66 69 6c 65 2e 20 20 | 54 65 72 6d 69 6e 61 6c | file. |Terminal|
|00001b30| 73 20 63 61 6e 20 65 61 | 63 68 20 75 73 65 20 61 |s can ea|ch use a|
|00001b40| 73 20 6d 61 6e 79 20 72 | 65 6c 61 74 69 6f 6e 73 |s many r|elations|
|00001b50| 20 61 73 20 61 20 73 79 | 73 74 65 6d 20 77 69 6c | as a sy|stem wil|
|00001b60| 6c 0a 58 61 6c 6c 6f 77 | 2c 20 61 6e 64 20 65 61 |l.Xallow|, and ea|
|00001b70| 63 68 20 72 65 6c 61 74 | 69 6f 6e 20 63 61 6e 20 |ch relat|ion can |
|00001b80| 62 65 20 75 73 65 64 20 | 62 79 20 73 6f 6d 65 20 |be used |by some |
|00001b90| 73 69 78 74 79 2d 66 6f | 75 72 20 75 73 65 72 73 |sixty-fo|ur users|
|00001ba0| 20 61 74 20 6f 6e 63 65 | 2e 20 20 54 68 65 0a 58 | at once|. The.X|
|00001bb0| 63 6f 64 65 20 75 73 65 | 64 20 74 6f 20 63 72 65 |code use|d to cre|
|00001bc0| 61 74 65 20 4d 65 74 61 | 6c 42 61 73 65 20 33 2e |ate Meta|lBase 3.|
|00001bd0| 58 20 61 6e 64 20 75 70 | 20 69 73 20 63 6f 6d 70 |X and up| is comp|
|00001be0| 6c 65 74 65 6c 79 20 63 | 6f 6d 70 61 74 69 62 6c |letely c|ompatibl|
|00001bf0| 65 20 77 69 74 68 20 74 | 68 65 0a 58 55 6e 69 78 |e with t|he.XUnix|
|00001c00| 20 6f 70 65 72 61 74 69 | 6e 67 20 73 79 73 74 65 | operati|ng syste|
|00001c10| 6d 20 61 6e 64 20 61 6c | 6c 20 6f 66 20 69 74 73 |m and al|l of its|
|00001c20| 20 64 65 72 69 76 61 74 | 69 76 65 73 2c 20 73 6f | derivat|ives, so|
|00001c30| 20 69 74 73 20 69 6e 68 | 65 72 65 6e 74 20 6d 75 | its inh|erent mu|
|00001c40| 6c 74 69 2d 75 73 65 72 | 0a 58 61 62 69 6c 69 74 |lti-user|.Xabilit|
|00001c50| 79 20 70 6c 61 63 65 73 | 20 69 74 20 69 6e 20 66 |y places| it in f|
|00001c60| 69 72 6d 20 77 6f 72 6b | 69 6e 67 20 66 6f 6f 74 |irm work|ing foot|
|00001c70| 69 6e 67 20 6f 6e 20 74 | 68 65 20 6d 6f 73 74 20 |ing on t|he most |
|00001c80| 61 64 76 61 6e 63 65 64 | 20 73 79 73 74 65 6d 73 |advanced| systems|
|00001c90| 20 6f 6e 20 74 68 65 0a | 58 6d 61 72 6b 65 74 2e | on the.|Xmarket.|
|00001ca0| 0a 58 20 20 20 20 42 75 | 74 20 74 68 65 20 49 42 |.X Bu|t the IB|
|00001cb0| 4d 20 75 73 65 72 73 20 | 63 6f 6d 70 6c 61 69 6e |M users |complain|
|00001cc0| 65 64 2e 20 20 41 6e 64 | 20 74 68 65 20 75 6e 69 |ed. And| the uni|
|00001cd0| 78 20 75 73 65 72 73 20 | 63 6f 6d 70 6c 61 69 6e |x users |complain|
|00001ce0| 65 64 2e 20 20 41 6e 64 | 20 6c 6f 2c 0a 58 65 76 |ed. And| lo,.Xev|
|00001cf0| 65 6e 20 74 68 65 20 41 | 6d 69 67 61 20 70 65 6f |en the A|miga peo|
|00001d00| 70 6c 65 20 63 6f 6d 70 | 6c 61 69 6e 65 64 2d 2d |ple comp|lained--|
|00001d10| 74 68 65 20 63 6f 64 65 | 20 64 69 64 6e 27 74 20 |the code| didn't |
|00001d20| 77 6f 72 6b 20 61 6c 6c | 20 74 68 65 20 74 69 6d |work all| the tim|
|00001d30| 65 2c 20 61 6e 64 0a 58 | 77 61 73 20 67 65 6e 65 |e, and.X|was gene|
|00001d40| 72 61 6c 6c 79 20 63 72 | 75 64 65 2e 20 20 53 6f |rally cr|ude. So|
|00001d50| 20 4d 65 74 61 6c 42 61 | 73 65 20 34 2e 30 20 73 | MetalBa|se 4.0 s|
|00001d60| 6f 6c 76 65 64 20 74 68 | 65 73 65 20 74 72 6f 75 |olved th|ese trou|
|00001d70| 62 6c 65 73 20 61 6e 64 | 20 6d 6f 72 65 2d 2d 61 |bles and| more--a|
|00001d80| 0a 58 63 6f 6d 70 6c 65 | 74 65 20 72 65 77 72 69 |.Xcomple|te rewri|
|00001d90| 74 65 20 6f 66 20 74 68 | 65 20 65 6e 67 69 6e 65 |te of th|e engine|
|00001da0| 20 68 61 73 20 70 72 6f | 76 69 64 65 64 20 65 76 | has pro|vided ev|
|00001db0| 65 6e 20 66 61 73 74 65 | 72 20 61 6e 64 20 6d 6f |en faste|r and mo|
|00001dc0| 72 65 20 65 66 66 69 63 | 69 65 6e 74 0a 58 61 6c |re effic|ient.Xal|
|00001dd0| 67 6f 72 69 74 68 6d 73 | 2c 20 77 68 69 63 68 20 |gorithms|, which |
|00001de0| 6b 65 65 70 20 4d 65 74 | 61 6c 42 61 73 65 20 69 |keep Met|alBase i|
|00001df0| 6e 64 69 63 65 73 20 69 | 6e 20 41 56 4c 20 62 61 |ndices i|n AVL ba|
|00001e00| 6c 61 6e 63 65 20 61 74 | 20 61 6c 6c 20 74 69 6d |lance at| all tim|
|00001e10| 65 73 2e 20 20 4d 6f 72 | 65 0a 58 63 6f 6e 76 65 |es. Mor|e.Xconve|
|00001e20| 6e 69 65 6e 74 20 66 75 | 6e 63 74 69 6f 6e 73 20 |nient fu|nctions |
|00001e30| 61 6e 64 20 6f 70 65 72 | 61 74 69 6f 6e 73 20 28 |and oper|ations (|
|00001e40| 73 75 63 68 20 61 73 20 | 62 75 69 6c 64 27 73 20 |such as |build's |
|00001e50| 61 62 69 6c 69 74 79 20 | 74 6f 20 63 72 65 61 74 |ability |to creat|
|00001e60| 65 20 68 65 61 64 65 72 | 0a 58 66 69 6c 65 73 20 |e header|.Xfiles |
|00001e70| 66 6f 72 20 79 6f 75 72 | 20 63 6f 64 65 20 77 68 |for your| code wh|
|00001e80| 69 63 68 20 72 65 66 6c | 65 63 74 20 61 20 73 63 |ich refl|ect a sc|
|00001e90| 68 65 6d 61 27 73 20 73 | 74 72 75 63 74 75 72 65 |hema's s|tructure|
|00001ea0| 29 20 68 61 76 65 20 62 | 65 65 6e 20 61 64 64 65 |) have b|een adde|
|00001eb0| 64 2c 0a 58 61 6c 6f 6e | 67 20 77 69 74 68 20 73 |d,.Xalon|g with s|
|00001ec0| 65 76 65 72 61 6c 20 75 | 74 69 6c 69 74 79 20 70 |everal u|tility p|
|00001ed0| 72 6f 67 72 61 6d 73 20 | 66 6f 72 20 6d 61 69 6e |rograms |for main|
|00001ee0| 74 61 69 6e 69 6e 67 20 | 79 6f 75 72 20 64 61 74 |taining |your dat|
|00001ef0| 61 62 61 73 65 2e 0a 58 | 20 20 20 20 52 65 6c 61 |abase..X| Rela|
|00001f00| 74 69 6f 6e 73 20 61 72 | 65 20 64 65 73 69 67 6e |tions ar|e design|
|00001f10| 65 64 20 62 79 20 61 20 | 75 73 65 72 20 74 6f 20 |ed by a |user to |
|00001f20| 6d 61 74 63 68 20 68 69 | 73 2f 68 65 72 20 65 78 |match hi|s/her ex|
|00001f30| 61 63 74 20 72 65 71 75 | 69 72 65 6d 65 6e 74 73 |act requ|irements|
|00001f40| 2c 0a 58 69 6e 64 69 63 | 65 73 20 70 6c 61 63 65 |,.Xindic|es place|
|00001f50| 64 20 61 73 20 6e 65 65 | 64 65 64 20 6f 6e 20 73 |d as nee|ded on s|
|00001f60| 69 6e 67 6c 65 20 6f 72 | 20 63 6f 6d 70 6f 73 69 |ingle or| composi|
|00001f70| 74 65 20 66 69 65 6c 64 | 73 2c 20 61 6e 64 20 72 |te field|s, and r|
|00001f80| 65 63 6f 72 64 73 20 63 | 61 6e 20 62 65 0a 58 61 |ecords c|an be.Xa|
|00001f90| 64 64 65 64 2c 20 72 65 | 74 72 69 65 76 65 64 2c |dded, re|trieved,|
|00001fa0| 20 63 68 61 6e 67 65 64 | 2c 20 61 6e 64 20 64 65 | changed|, and de|
|00001fb0| 6c 65 74 65 64 20 61 73 | 20 61 6e 79 20 43 20 70 |leted as| any C p|
|00001fc0| 72 6f 67 72 61 6d 6d 65 | 72 20 73 6f 20 64 65 73 |rogramme|r so des|
|00001fd0| 69 72 65 73 2e 20 20 54 | 68 65 0a 58 69 6e 74 65 |ires. T|he.Xinte|
|00001fe0| 72 66 61 63 65 20 69 73 | 20 61 73 20 73 69 6d 70 |rface is| as simp|
|00001ff0| 6c 65 20 61 73 20 70 6f | 73 73 69 62 6c 65 2c 20 |le as po|ssible, |
|00002000| 76 65 72 79 20 66 61 73 | 74 20 69 6e 20 65 78 65 |very fas|t in exe|
|00002010| 63 75 74 69 6f 6e 2c 20 | 61 6e 64 20 70 72 6f 76 |cution, |and prov|
|00002020| 69 64 65 73 20 61 20 77 | 69 64 65 0a 58 72 61 6e |ides a w|ide.Xran|
|00002030| 67 65 20 6f 66 20 65 72 | 72 6f 72 20 74 79 70 65 |ge of er|ror type|
|00002040| 73 20 66 6f 72 20 65 78 | 61 63 74 20 73 70 65 63 |s for ex|act spec|
|00002050| 69 66 69 63 61 74 69 6f | 6e 20 6f 66 20 70 72 6f |ificatio|n of pro|
|00002060| 62 6c 65 6d 73 2e 20 20 | 41 20 75 73 65 72 20 6f |blems. |A user o|
|00002070| 6e 20 61 6e 79 0a 58 74 | 65 72 6d 69 6e 61 6c 20 |n any.Xt|erminal |
|00002080| 63 61 6e 20 63 68 6f 6f | 73 65 20 74 6f 20 6c 6f |can choo|se to lo|
|00002090| 63 6b 20 6f 75 74 20 6f | 74 68 65 72 20 75 73 65 |ck out o|ther use|
|000020a0| 72 73 20 66 72 6f 6d 20 | 61 6e 79 20 6e 75 6d 62 |rs from |any numb|
|000020b0| 65 72 20 6f 66 20 72 65 | 6c 61 74 69 6f 6e 73 2c |er of re|lations,|
|000020c0| 20 73 6f 0a 58 73 77 65 | 65 70 69 6e 67 20 63 68 | so.Xswe|eping ch|
|000020d0| 61 6e 67 65 73 20 69 6e | 20 64 61 74 61 20 77 69 |anges in| data wi|
|000020e0| 6c 6c 20 6e 6f 74 20 62 | 65 20 72 65 61 64 20 62 |ll not b|e read b|
|000020f0| 79 20 6f 74 68 65 72 73 | 20 62 65 66 6f 72 65 20 |y others| before |
|00002100| 74 68 65 79 20 63 61 6e | 20 74 61 6b 65 0a 58 70 |they can| take.Xp|
|00002110| 6c 61 63 65 2e 20 20 41 | 75 74 6f 6d 61 74 69 63 |lace. A|utomatic|
|00002120| 20 74 65 6d 70 6f 72 61 | 72 79 20 6c 6f 63 6b 73 | tempora|ry locks|
|00002130| 20 61 72 65 20 70 6c 61 | 63 65 64 20 6f 6e 20 61 | are pla|ced on a|
|00002140| 20 72 65 6c 61 74 69 6f | 6e 20 77 68 69 63 68 20 | relatio|n which |
|00002150| 69 73 20 61 62 6f 75 74 | 0a 58 74 6f 20 75 6e 64 |is about|.Xto und|
|00002160| 65 72 67 6f 20 61 20 64 | 65 6c 65 74 69 6f 6e 20 |ergo a d|eletion |
|00002170| 6f 72 20 61 64 64 69 74 | 69 6f 6e 2c 20 73 74 72 |or addit|ion, str|
|00002180| 61 74 65 67 69 63 61 6c | 6c 79 20 64 65 6c 61 79 |ategical|ly delay|
|00002190| 69 6e 67 20 6f 74 68 65 | 72 20 75 73 65 72 73 27 |ing othe|r users'|
|000021a0| 20 61 63 63 65 73 73 0a | 58 74 6f 20 66 69 6c 65 | access.|Xto file|
|000021b0| 73 20 66 6f 72 20 6c 65 | 73 73 20 74 68 61 6e 20 |s for le|ss than |
|000021c0| 73 65 63 6f 6e 64 73 2c | 20 73 6f 20 74 68 61 74 |seconds,| so that|
|000021d0| 20 6e 6f 20 64 61 74 61 | 20 77 69 6c 6c 20 62 65 | no data| will be|
|000021e0| 20 72 65 61 64 20 75 6e | 74 69 6c 20 61 6c 6c 20 | read un|til all |
|000021f0| 69 6e 64 69 63 65 73 0a | 58 68 61 76 65 20 62 65 |indices.|Xhave be|
|00002200| 65 6e 20 75 70 64 61 74 | 65 64 20 63 6f 72 72 65 |en updat|ed corre|
|00002210| 63 74 6c 79 2e 20 20 54 | 68 69 73 20 70 72 6f 63 |ctly. T|his proc|
|00002220| 65 73 73 20 69 73 20 65 | 6e 74 69 72 65 6c 79 20 |ess is e|ntirely |
|00002230| 73 79 73 74 65 6d 2d 64 | 72 69 76 65 6e 3b 20 75 |system-d|riven; u|
|00002240| 73 65 72 73 0a 58 6e 65 | 76 65 72 20 6e 65 65 64 |sers.Xne|ver need|
|00002250| 20 77 6f 72 72 79 20 61 | 62 6f 75 74 20 69 74 20 | worry a|bout it |
|00002260| 61 74 20 61 6c 6c 2e 20 | 20 49 66 20 6f 6e 65 20 |at all. | If one |
|00002270| 75 73 65 72 20 69 73 20 | 61 64 64 69 6e 67 20 61 |user is |adding a|
|00002280| 20 72 65 63 6f 72 64 20 | 74 6f 20 61 0a 58 72 65 | record |to a.Xre|
|00002290| 6c 61 74 69 6f 6e 2c 20 | 61 6e 79 20 74 65 72 6d |lation, |any term|
|000022a0| 69 6e 61 6c 20 72 65 71 | 75 65 73 74 69 6e 67 20 |inal req|uesting |
|000022b0| 61 20 72 65 63 6f 72 64 | 20 6c 6f 6f 6b 75 70 20 |a record| lookup |
|000022c0| 77 69 6c 6c 20 73 69 6d | 70 6c 79 20 77 61 69 74 |will sim|ply wait|
|000022d0| 20 75 6e 74 69 6c 20 74 | 68 65 0a 58 61 64 64 69 | until t|he.Xaddi|
|000022e0| 74 69 6f 6e 20 69 73 20 | 63 6f 6d 70 6c 65 74 65 |tion is |complete|
|000022f0| 20 62 65 66 6f 72 65 20 | 70 72 6f 63 65 65 64 69 | before |proceedi|
|00002300| 6e 67 2e 20 20 41 73 20 | 72 65 63 6f 72 64 73 20 |ng. As |records |
|00002310| 61 72 65 20 64 65 6c 65 | 74 65 64 20 61 6e 64 20 |are dele|ted and |
|00002320| 61 64 64 65 64 0a 58 74 | 68 72 6f 75 67 68 20 6e |added.Xt|hrough n|
|00002330| 6f 72 6d 61 6c 20 75 73 | 65 2c 20 74 68 65 20 61 |ormal us|e, the a|
|00002340| 6c 67 6f 72 69 74 68 6d | 73 20 75 73 65 64 20 74 |lgorithm|s used t|
|00002350| 6f 20 75 70 64 61 74 65 | 20 69 6e 64 69 63 65 73 |o update| indices|
|00002360| 20 61 75 74 6f 6d 61 74 | 69 63 61 6c 6c 79 20 6b | automat|ically k|
|00002370| 65 65 70 0a 58 74 68 65 | 6d 20 61 74 20 74 6f 70 |eep.Xthe|m at top|
|00002380| 20 6f 70 65 72 61 74 69 | 6e 67 20 73 70 65 65 64 | operati|ng speed|
|00002390| 73 2c 20 73 6f 20 61 6e | 79 20 67 69 76 65 6e 20 |s, so an|y given |
|000023a0| 72 65 6c 61 74 69 6f 6e | 27 73 20 6e 75 6d 62 65 |relation|'s numbe|
|000023b0| 72 20 6f 66 20 72 65 63 | 6f 72 64 73 20 63 61 6e |r of rec|ords can|
|000023c0| 0a 58 67 72 6f 77 20 65 | 78 70 6f 6e 65 6e 74 69 |.Xgrow e|xponenti|
|000023d0| 61 6c 6c 79 20 77 68 69 | 6c 65 20 63 61 75 73 69 |ally whi|le causi|
|000023e0| 6e 67 20 6f 6e 6c 79 20 | 61 20 6c 69 6e 65 61 72 |ng only |a linear|
|000023f0| 20 69 6e 63 72 65 61 73 | 65 20 69 6e 20 6c 6f 6f | increas|e in loo|
|00002400| 6b 2d 75 70 20 74 69 6d | 65 2e 20 20 41 6e 79 0a |k-up tim|e. Any.|
|00002410| 58 72 65 6c 61 74 69 6f | 6e 20 63 61 6e 20 63 6f |Xrelatio|n can co|
|00002420| 6e 74 61 69 6e 20 6f 76 | 65 72 20 66 6f 75 72 20 |ntain ov|er four |
|00002430| 62 69 6c 6c 69 6f 6e 20 | 72 65 63 6f 72 64 73 20 |billion |records |
|00002440| 28 4e 65 61 72 6c 79 20 | 66 6f 75 72 20 62 69 6c |(Nearly |four bil|
|00002450| 6c 69 6f 6e 20 6d 6f 72 | 65 20 74 68 61 6e 0a 58 |lion mor|e than.X|
|00002460| 6d 6f 73 74 20 73 79 73 | 74 65 6d 73 20 77 69 6c |most sys|tems wil|
|00002470| 6c 20 65 76 65 72 20 6e | 65 65 64 29 2c 20 61 6e |l ever n|eed), an|
|00002480| 64 20 65 61 63 68 20 72 | 65 63 6f 72 64 27 73 20 |d each r|ecord's |
|00002490| 6c 65 6e 67 74 68 20 63 | 61 6e 20 62 65 20 61 73 |length c|an be as|
|000024a0| 20 6c 61 72 67 65 20 61 | 73 20 69 74 73 0a 58 73 | large a|s its.Xs|
|000024b0| 79 73 74 65 6d 27 73 20 | 6d 65 6d 6f 72 79 20 63 |ystem's |memory c|
|000024c0| 61 6e 20 68 61 6e 64 6c | 65 2e 20 20 49 6e 20 70 |an handl|e. In p|
|000024d0| 65 72 73 70 65 63 74 69 | 76 65 2c 20 4d 65 74 61 |erspecti|ve, Meta|
|000024e0| 6c 42 61 73 65 20 69 73 | 20 69 6e 66 69 6e 69 74 |lBase is| infinit|
|000024f0| 65 6c 79 0a 58 65 78 70 | 61 6e 64 69 62 6c 65 2c |ely.Xexp|andible,|
|00002500| 20 77 68 69 6c 65 20 72 | 65 71 75 69 72 69 6e 67 | while r|equiring|
|00002510| 20 76 65 72 79 20 6c 69 | 74 74 6c 65 20 6f 66 20 | very li|ttle of |
|00002520| 74 68 65 20 73 79 73 74 | 65 6d 20 6f 6e 20 77 68 |the syst|em on wh|
|00002530| 69 63 68 20 69 74 20 6f | 70 65 72 61 74 65 73 2e |ich it o|perates.|
|00002540| 0a 58 0a 58 5b 20 54 68 | 65 20 61 63 74 75 61 6c |.X.X[ Th|e actual|
|00002550| 20 6e 75 6d 62 65 72 20 | 6f 66 20 72 65 63 6f 72 | number |of recor|
|00002560| 64 73 20 61 6c 6c 6f 77 | 61 62 6c 65 20 69 73 20 |ds allow|able is |
|00002570| 34 2c 32 39 34 2c 39 36 | 37 2c 32 39 36 2e 2e 2e |4,294,96|7,296...|
|00002580| 20 69 66 20 79 6f 75 20 | 77 65 72 65 20 74 6f 0a | if you |were to.|
|00002590| 58 20 20 61 64 64 20 6f | 6e 65 20 72 65 63 6f 72 |X add o|ne recor|
|000025a0| 64 20 61 20 73 65 63 6f | 6e 64 2c 20 69 74 20 77 |d a seco|nd, it w|
|000025b0| 6f 75 6c 64 20 74 61 6b | 65 20 6f 76 65 72 20 31 |ould tak|e over 1|
|000025c0| 33 36 20 79 65 61 72 73 | 20 74 6f 20 72 65 61 63 |36 years| to reac|
|000025d0| 68 20 74 68 69 73 20 6c | 69 6d 69 74 20 5d 0a 58 |h this l|imit ].X|
|000025e0| 0a 58 52 45 4c 41 54 49 | 4f 4e 5f 44 45 53 49 47 |.XRELATI|ON_DESIG|
|000025f0| 4e 5f 5f 5f 5f 5f 5f 5f | 5f 5f 5f 5f 5f 5f 5f 5f |N_______|________|
|00002600| 5f 5f 5f 5f 5f 5f 5f 5f | 5f 5f 5f 5f 5f 5f 5f 5f |________|________|
|00002610| 5f 5f 5f 5f 5f 5f 5f 5f | 5f 5f 5f 5f 5f 5f 5f 5f |________|________|
|00002620| 5f 5f 5f 5f 5f 5f 5f 5f | 5f 5f 5f 5f 5f 5f 5f 5f |________|________|
|00002630| 5f 0a 58 0a 58 20 20 20 | 20 20 20 20 20 41 20 73 |_.X.X | A s|
|00002640| 61 6d 70 6c 65 20 72 65 | 6c 61 74 69 6f 6e 2e 20 |ample re|lation. |
|00002650| 20 44 61 74 61 20 20 20 | 20 20 20 46 69 65 6c 64 | Data | Field|
|00002660| 20 23 20 2d 3e 20 20 31 | 20 20 20 20 32 20 20 20 | # -> 1| 2 |
|00002670| 33 20 20 20 20 34 20 20 | 20 20 20 20 20 35 0a 58 |3 4 | 5.X|
|00002680| 20 20 20 20 20 20 20 20 | 69 73 20 72 65 61 64 20 | |is read |
|00002690| 62 79 20 73 65 6c 65 63 | 74 69 6e 67 20 6f 6e 65 |by selec|ting one|
|000026a0| 20 20 20 20 20 52 65 63 | 6f 72 64 20 23 20 20 20 | Rec|ord # |
|000026b0| 5f 5f 5f 5f 5f 20 5f 5f | 5f 20 5f 5f 5f 5f 20 5f |_____ __|_ ____ _|
|000026c0| 5f 5f 20 5f 5f 5f 5f 5f | 5f 5f 5f 5f 5f 5f 0a 58 |__ _____|______.X|
|000026d0| 20 20 20 20 20 20 20 20 | 72 65 63 6f 72 64 20 66 | |record f|
|000026e0| 72 6f 6d 20 74 68 65 20 | 6f 74 68 65 72 73 20 62 |rom the |others b|
|000026f0| 79 20 20 20 20 20 20 20 | 20 20 20 31 20 20 20 7c |y | 1 ||
|00002700| 5f 5f 5f 5f 5f 7c 5f 5f | 5f 7c 5f 5f 5f 5f 7c 5f |_____|__|_|____|_|
|00002710| 5f 5f 7c 5f 5f 5f 5f 5f | 5f 5f 5f 5f 5f 5f 7c 0a |__|_____|______|.|
|00002720| 58 20 20 20 20 20 20 20 | 20 76 61 72 69 6f 75 73 |X | various|
|00002730| 20 63 72 69 74 65 72 69 | 61 2c 20 61 6e 64 20 20 | criteri|a, and |
|00002740| 20 20 20 20 20 20 20 20 | 20 20 20 20 32 20 20 20 | | 2 |
|00002750| 7c 5f 5f 5f 5f 5f 7c 5f | 5f 5f 7c 5f 5f 5f 5f 7c ||_____|_|__|____||
|00002760| 5f 5f 5f 7c 5f 5f 5f 5f | 5f 5f 5f 5f 5f 5f 5f 7c |___|____|_______||
|00002770| 0a 58 20 20 20 20 20 20 | 20 20 72 65 74 75 72 6e |.X | return|
|00002780| 69 6e 67 20 69 74 20 74 | 6f 20 74 68 65 20 75 73 |ing it t|o the us|
|00002790| 65 72 2e 20 20 20 20 20 | 20 20 20 20 20 33 20 20 |er. | 3 |
|000027a0| 20 7c 53 6d 69 74 68 7c | 20 31 32 7c 20 31 31 34 | |Smith|| 12| 114|
|000027b0| 7c 20 41 32 7c 48 6f 75 | 73 74 6f 6e 2c 20 54 58 || A2|Hou|ston, TX|
|000027c0| 7c 0a 58 20 20 20 20 20 | 20 20 20 52 65 63 6f 72 ||.X | Recor|
|000027d0| 64 20 33 20 28 49 6e 20 | 74 68 69 73 20 65 78 61 |d 3 (In |this exa|
|000027e0| 6d 70 6c 65 2d 2d 20 20 | 20 20 20 20 20 20 34 20 |mple-- | 4 |
|000027f0| 20 20 7c 2d 2d 2d 2d 2d | 7c 2d 2d 2d 7c 2d 2d 2d | |-----||---|---|
|00002800| 2d 7c 2d 2d 2d 7c 2d 2d | 2d 2d 2d 2d 2d 2d 2d 2d |-|---|--|--------|
|00002810| 2d 7c 0a 58 20 20 20 20 | 20 20 20 20 61 63 74 75 |-|.X | actu|
|00002820| 61 6c 20 4d 65 74 61 6c | 42 61 73 65 20 72 65 63 |al Metal|Base rec|
|00002830| 6f 72 64 73 20 6e 65 65 | 64 0a 58 20 20 20 20 20 |ords nee|d.X |
|00002840| 20 20 20 6e 6f 20 73 75 | 63 68 20 6e 75 6d 62 65 | no su|ch numbe|
|00002850| 72 69 6e 67 20 73 79 73 | 74 65 6d 29 2c 20 69 66 |ring sys|tem), if|
|00002860| 20 72 65 74 75 72 6e 65 | 64 2c 20 77 6f 75 6c 64 | returne|d, would|
|00002870| 20 62 65 20 70 6c 61 63 | 65 64 20 69 6e 20 61 20 | be plac|ed in a |
|00002880| 73 74 72 75 63 74 75 72 | 65 0a 58 20 20 20 20 20 |structur|e.X |
|00002890| 20 20 20 63 6f 6e 74 61 | 69 6e 69 6e 67 20 53 6d | conta|ining Sm|
|000028a0| 69 74 68 2c 31 32 2c 31 | 31 34 2c 41 32 2c 20 61 |ith,12,1|14,A2, a|
|000028b0| 6e 64 20 48 6f 75 73 74 | 6f 6e 2c 54 58 20 69 6e |nd Houst|on,TX in|
|000028c0| 20 74 68 65 20 61 70 70 | 72 6f 70 72 69 61 74 65 | the app|ropriate|
|000028d0| 20 65 6c 65 6d 65 6e 74 | 73 2e 0a 58 0a 58 20 20 | element|s..X.X |
|000028e0| 20 20 41 20 72 65 6c 61 | 74 69 6f 6e 20 69 73 20 | A rela|tion is |
|000028f0| 61 20 63 6f 6c 6c 65 63 | 74 69 6f 6e 20 6f 66 20 |a collec|tion of |
|00002900| 72 65 63 6f 72 64 73 2c | 20 65 61 63 68 20 72 65 |records,| each re|
|00002910| 63 6f 72 64 20 63 6f 6e | 73 69 73 74 69 6e 67 20 |cord con|sisting |
|00002920| 6f 66 20 74 68 65 20 73 | 61 6d 65 0a 58 6e 75 6d |of the s|ame.Xnum|
|00002930| 62 65 72 20 6f 66 20 66 | 69 65 6c 64 73 2d 2d 62 |ber of f|ields--b|
|00002940| 6c 6f 63 6b 73 20 6f 66 | 20 64 61 74 61 20 77 68 |locks of| data wh|
|00002950| 6f 73 65 20 69 6e 64 69 | 76 69 64 75 61 6c 20 6c |ose indi|vidual l|
|00002960| 65 6e 67 74 68 73 20 72 | 65 6d 61 69 6e 20 63 6f |engths r|emain co|
|00002970| 6e 73 74 61 6e 74 20 66 | 72 6f 6d 0a 58 72 65 63 |nstant f|rom.Xrec|
|00002980| 6f 72 64 20 74 6f 20 72 | 65 63 6f 72 64 2e 20 20 |ord to r|ecord. |
|00002990| 45 61 63 68 20 66 69 65 | 6c 64 20 6e 65 65 64 20 |Each fie|ld need |
|000029a0| 6e 6f 74 20 68 61 76 65 | 20 74 68 65 20 73 61 6d |not have| the sam|
|000029b0| 65 20 6c 65 6e 67 74 68 | 20 61 73 20 74 68 65 20 |e length| as the |
|000029c0| 6f 74 68 65 72 73 20 69 | 6e 0a 58 61 6e 79 20 67 |others i|n.Xany g|
|000029d0| 69 76 65 6e 20 72 65 63 | 6f 72 64 2c 20 62 75 74 |iven rec|ord, but|
|000029e0| 20 66 72 6f 6d 20 72 65 | 63 6f 72 64 20 74 6f 20 | from re|cord to |
|000029f0| 72 65 63 6f 72 64 2c 20 | 61 20 66 69 65 6c 64 27 |record, |a field'|
|00002a00| 73 20 6c 65 6e 67 74 68 | 20 77 69 6c 6c 20 72 65 |s length| will re|
|00002a10| 6d 61 69 6e 20 74 68 65 | 0a 58 73 61 6d 65 2e 20 |main the|.Xsame. |
|00002a20| 54 68 65 20 64 61 74 61 | 20 74 68 65 20 66 69 65 |The data| the fie|
|00002a30| 6c 64 73 20 63 6f 6e 74 | 61 69 6e 20 69 73 2c 20 |lds cont|ain is, |
|00002a40| 6f 66 20 63 6f 75 72 73 | 65 2c 20 74 68 65 20 6d |of cours|e, the m|
|00002a50| 61 69 6e 20 70 75 72 70 | 6f 73 65 20 6f 66 20 61 |ain purp|ose of a|
|00002a60| 0a 58 64 61 74 61 62 61 | 73 65 2d 2d 77 68 65 6e |.Xdataba|se--when|
|00002a70| 20 74 68 6f 75 73 61 6e | 64 73 20 6f 66 20 72 65 | thousan|ds of re|
|00002a80| 63 6f 72 64 73 20 65 78 | 69 73 74 2c 20 61 20 73 |cords ex|ist, a s|
|00002a90| 79 73 74 65 6d 20 77 69 | 74 68 6f 75 74 20 61 20 |ystem wi|thout a |
|00002aa0| 64 61 74 61 62 61 73 65 | 20 77 6f 75 6c 64 0a 58 |database| would.X|
|00002ab0| 6e 65 65 64 20 76 61 73 | 74 20 61 6d 6f 75 6e 74 |need vas|t amount|
|00002ac0| 73 20 6f 66 20 74 69 6d | 65 20 74 6f 20 66 69 6e |s of tim|e to fin|
|00002ad0| 64 20 61 6e 79 20 67 69 | 76 65 6e 20 72 65 63 6f |d any gi|ven reco|
|00002ae0| 72 64 2e 20 20 44 61 74 | 61 62 61 73 65 73 20 64 |rd. Dat|abases d|
|00002af0| 65 63 72 65 61 73 65 0a | 58 64 72 61 6d 61 74 69 |ecrease.|Xdramati|
|00002b00| 63 61 6c 6c 79 20 72 65 | 63 6f 72 64 20 72 65 74 |cally re|cord ret|
|00002b10| 72 69 65 76 61 6c 20 74 | 69 6d 65 2c 20 77 68 69 |rieval t|ime, whi|
|00002b20| 6c 65 20 72 65 71 75 69 | 72 69 6e 67 20 61 73 20 |le requi|ring as |
|00002b30| 6c 69 74 74 6c 65 20 61 | 64 64 69 74 69 6f 6e 61 |little a|dditiona|
|00002b40| 6c 20 74 69 6d 65 0a 58 | 74 6f 20 61 64 64 20 6e |l time.X|to add n|
|00002b50| 65 77 20 61 6e 64 20 63 | 68 61 6e 67 65 20 6f 6c |ew and c|hange ol|
|00002b60| 64 20 72 65 63 6f 72 64 | 73 20 61 73 20 70 6f 73 |d record|s as pos|
|00002b70| 73 69 62 6c 65 2e 0a 58 | 20 20 20 20 54 68 65 20 |sible..X| The |
|00002b80| 6b 65 79 20 74 6f 20 61 | 20 64 61 74 61 62 61 73 |key to a| databas|
|00002b90| 65 20 69 73 20 69 74 73 | 20 69 6e 64 69 63 65 73 |e is its| indices|
|00002ba0| 2d 2d 70 6f 69 6e 74 65 | 72 73 20 61 72 72 61 6e |--pointe|rs arran|
|00002bb0| 67 65 64 20 69 6e 20 73 | 75 63 68 20 61 20 66 61 |ged in s|uch a fa|
|00002bc0| 73 68 69 6f 6e 0a 58 61 | 73 20 74 6f 20 73 68 6f |shion.Xa|s to sho|
|00002bd0| 77 20 74 68 65 20 73 79 | 73 74 65 6d 20 77 68 65 |w the sy|stem whe|
|00002be0| 72 65 20 74 6f 20 6c 6f | 6f 6b 20 66 6f 72 20 74 |re to lo|ok for t|
|00002bf0| 68 65 20 72 65 63 6f 72 | 64 20 66 6f 72 20 77 68 |he recor|d for wh|
|00002c00| 69 63 68 20 69 74 20 69 | 73 20 73 65 61 72 63 68 |ich it i|s search|
|00002c10| 69 6e 67 2e 0a 58 54 68 | 65 20 6d 6f 72 65 20 6f |ing..XTh|e more o|
|00002c20| 66 20 74 68 65 73 65 20 | 63 6f 6c 6c 65 63 74 69 |f these |collecti|
|00002c30| 6f 6e 73 20 6f 66 20 70 | 6f 69 6e 74 65 72 73 2c |ons of p|ointers,|
|00002c40| 20 6f 72 20 69 6e 64 69 | 63 65 73 2c 20 61 20 64 | or indi|ces, a d|
|00002c50| 61 74 61 62 61 73 65 20 | 68 61 73 2c 20 74 68 65 |atabase |has, the|
|00002c60| 0a 58 67 72 65 61 74 65 | 72 20 74 68 65 20 6e 75 |.Xgreate|r the nu|
|00002c70| 6d 62 65 72 20 6f 66 20 | 64 69 66 66 65 72 65 6e |mber of |differen|
|00002c80| 74 20 66 69 65 6c 64 73 | 20 61 20 73 79 73 74 65 |t fields| a syste|
|00002c90| 6d 20 63 61 6e 20 73 65 | 61 72 63 68 20 74 68 72 |m can se|arch thr|
|00002ca0| 6f 75 67 68 20 69 6e 20 | 6f 72 64 65 72 20 74 6f |ough in |order to|
|00002cb0| 0a 58 66 69 6e 64 20 61 | 20 72 65 63 6f 72 64 20 |.Xfind a| record |
|00002cc0| 6d 65 65 74 69 6e 67 20 | 63 65 72 74 61 69 6e 20 |meeting |certain |
|00002cd0| 63 72 69 74 65 72 69 61 | 20 66 6f 72 20 61 20 66 |criteria| for a f|
|00002ce0| 69 65 6c 64 20 28 4f 72 | 20 66 69 65 6c 64 73 2e |ield (Or| fields.|
|00002cf0| 2e 2e 20 61 20 73 69 6e | 67 6c 65 20 69 6e 64 65 |.. a sin|gle inde|
|00002d00| 78 0a 58 63 61 6e 20 62 | 65 20 75 73 65 64 20 74 |x.Xcan b|e used t|
|00002d10| 6f 20 66 69 72 73 74 20 | 73 6f 72 74 20 72 65 63 |o first |sort rec|
|00002d20| 6f 72 64 73 20 62 79 20 | 6f 6e 65 20 66 69 65 6c |ords by |one fiel|
|00002d30| 64 2c 20 61 6e 64 20 61 | 6c 73 6f 20 73 6f 72 74 |d, and a|lso sort|
|00002d40| 20 64 75 70 6c 69 63 61 | 74 65 73 20 77 69 74 68 | duplica|tes with|
|00002d50| 0a 58 72 65 73 70 65 63 | 74 20 74 6f 20 61 20 73 |.Xrespec|t to a s|
|00002d60| 65 63 6f 6e 64 20 66 69 | 65 6c 64 2c 20 65 74 63 |econd fi|eld, etc|
|00002d70| 2e 20 20 4d 65 74 61 6c | 42 61 73 65 20 61 6c 6c |. Metal|Base all|
|00002d80| 6f 77 73 20 74 68 65 73 | 65 20 63 6f 6d 70 6f 73 |ows thes|e compos|
|00002d90| 69 74 65 20 69 6e 64 69 | 63 65 73 20 74 6f 0a 58 |ite indi|ces to.X|
|00002da0| 6b 65 79 20 6f 66 66 20 | 6f 66 20 61 73 20 6d 61 |key off |of as ma|
|00002db0| 6e 79 20 61 73 20 39 39 | 39 20 64 69 66 66 65 72 |ny as 99|9 differ|
|00002dc0| 65 6e 74 20 66 69 65 6c | 64 73 29 2e 20 20 48 6f |ent fiel|ds). Ho|
|00002dd0| 77 65 76 65 72 2c 20 64 | 61 74 61 62 61 73 65 73 |wever, d|atabases|
|00002de0| 20 72 65 71 75 69 72 65 | 20 74 69 6d 65 0a 58 74 | require| time.Xt|
|00002df0| 6f 20 75 70 64 61 74 65 | 20 65 61 63 68 20 69 6e |o update| each in|
|00002e00| 64 65 78 20 65 76 65 72 | 79 20 74 69 6d 65 20 79 |dex ever|y time y|
|00002e10| 6f 75 20 61 64 64 2c 20 | 64 65 6c 65 74 65 2c 20 |ou add, |delete, |
|00002e20| 6f 72 20 63 68 61 6e 67 | 65 20 61 20 66 69 65 6c |or chang|e a fiel|
|00002e30| 64 20 77 68 69 63 68 20 | 68 61 73 20 61 6e 0a 58 |d which |has an.X|
|00002e40| 69 6e 64 65 78 20 70 6c | 61 63 65 64 20 75 70 6f |index pl|aced upo|
|00002e50| 6e 20 69 74 2e 20 20 53 | 6f 20 61 6c 74 68 6f 75 |n it. S|o althou|
|00002e60| 67 68 20 72 65 74 72 69 | 65 76 61 6c 20 63 72 69 |gh retri|eval cri|
|00002e70| 74 65 72 69 61 20 70 6f | 73 73 69 62 69 6c 69 74 |teria po|ssibilit|
|00002e80| 65 73 20 61 72 65 20 65 | 78 70 61 6e 64 65 64 0a |es are e|xpanded.|
|00002e90| 58 62 79 20 75 73 69 6e | 67 20 6d 61 6e 79 20 69 |Xby usin|g many i|
|00002ea0| 6e 64 69 63 65 73 2c 20 | 74 68 65 20 61 6d 6f 75 |ndices, |the amou|
|00002eb0| 6e 74 20 6f 66 20 74 69 | 6d 65 20 72 65 71 75 69 |nt of ti|me requi|
|00002ec0| 72 65 64 20 74 6f 20 63 | 68 61 6e 67 65 20 74 68 |red to c|hange th|
|00002ed0| 65 20 65 78 69 73 74 69 | 6e 67 0a 58 72 65 63 6f |e existi|ng.Xreco|
|00002ee0| 72 64 73 20 69 6e 20 61 | 20 64 61 74 61 62 61 73 |rds in a| databas|
|00002ef0| 65 20 77 69 6c 6c 20 61 | 6c 73 6f 20 69 6e 63 72 |e will a|lso incr|
|00002f00| 65 61 73 65 2e 20 20 46 | 6f 72 20 74 68 69 73 20 |ease. F|or this |
|00002f10| 72 65 61 73 6f 6e 2c 20 | 74 68 65 20 6e 75 6d 62 |reason, |the numb|
|00002f20| 65 72 20 6f 66 0a 58 69 | 6e 64 69 63 65 73 20 61 |er of.Xi|ndices a|
|00002f30| 20 72 65 6c 61 74 69 6f | 6e 20 77 69 6c 6c 20 68 | relatio|n will h|
|00002f40| 61 76 65 20 73 68 6f 75 | 6c 64 20 62 65 20 63 6f |ave shou|ld be co|
|00002f50| 6e 73 69 64 65 72 65 64 | 20 63 61 72 65 66 75 6c |nsidered| careful|
|00002f60| 6c 79 2d 2d 75 73 65 20 | 77 68 61 74 20 69 73 0a |ly--use |what is.|
|00002f70| 58 6e 65 65 64 65 64 2c | 20 62 75 74 20 6e 6f 20 |Xneeded,| but no |
|00002f80| 6d 6f 72 65 2e 0a 58 0a | 58 20 20 20 20 52 65 6c |more..X.|X Rel|
|00002f90| 61 74 69 6f 6e 73 20 61 | 72 65 20 62 75 69 6c 74 |ations a|re built|
|00002fa0| 20 66 72 6f 6d 20 73 63 | 68 65 6d 61 20 66 69 6c | from sc|hema fil|
|00002fb0| 65 73 2c 20 77 68 69 63 | 68 20 64 65 63 72 69 62 |es, whic|h decrib|
|00002fc0| 65 20 74 68 65 20 72 65 | 6c 61 74 69 6f 6e 20 69 |e the re|lation i|
|00002fd0| 6e 20 61 0a 58 6d 6f 72 | 65 20 68 75 6d 61 6e 2d |n a.Xmor|e human-|
|00002fe0| 66 72 69 65 6e 64 6c 79 | 20 73 79 6e 74 61 78 2e |friendly| syntax.|
|00002ff0| 20 20 53 65 65 20 62 75 | 69 6c 64 2e 64 6f 78 20 | See bu|ild.dox |
|00003000| 66 6f 72 20 61 20 6d 6f | 72 65 20 63 6f 6d 70 6c |for a mo|re compl|
|00003010| 65 74 65 20 64 65 73 63 | 72 69 70 74 69 6f 6e 20 |ete desc|ription |
|00003020| 6f 66 0a 58 74 68 69 73 | 20 70 72 6f 63 65 73 73 |of.Xthis| process|
|00003030| 2e 0a 58 0a 58 49 4d 50 | 4c 45 4d 45 4e 54 41 49 |..X.XIMP|LEMENTAI|
|00003040| 4f 4e 5f 5f 5f 5f 5f 5f | 5f 5f 5f 5f 5f 5f 5f 5f |ON______|________|
|00003050| 5f 5f 5f 5f 5f 5f 5f 5f | 5f 5f 5f 5f 5f 5f 5f 5f |________|________|
|00003060| 5f 5f 5f 5f 5f 5f 5f 5f | 5f 5f 5f 5f 5f 5f 5f 5f |________|________|
|00003070| 5f 5f 5f 5f 5f 5f 5f 5f | 5f 5f 5f 5f 5f 5f 5f 5f |________|________|
|00003080| 5f 5f 5f 5f 0a 58 0a 58 | 20 20 20 20 41 20 73 61 |____.X.X| A sa|
|00003090| 6d 70 6c 65 20 70 72 6f | 67 72 61 6d 20 69 6d 70 |mple pro|gram imp|
|000030a0| 6c 65 6d 65 6e 74 69 6e | 67 20 4d 65 74 61 6c 42 |lementin|g MetalB|
|000030b0| 61 73 65 20 66 6f 6c 6c | 6f 77 73 3a 0a 58 0a 58 |ase foll|ows:.X.X|
|000030c0| 20 20 20 20 20 23 69 6e | 63 6c 75 64 65 20 3c 6d | #in|clude <m|
|000030d0| 62 61 73 65 2e 68 3e 0a | 58 20 20 20 20 20 23 69 |base.h>.|X #i|
|000030e0| 6e 63 6c 75 64 65 20 22 | 65 71 75 69 70 6d 65 6e |nclude "|equipmen|
|000030f0| 74 2e 68 22 0a 58 0a 58 | 20 20 20 20 20 6d 61 69 |t.h".X.X| mai|
|00003100| 6e 20 28 29 0a 58 20 20 | 20 20 20 7b 0a 58 20 20 |n ().X | {.X |
|00003110| 20 20 20 20 20 20 72 65 | 6c 61 74 69 6f 6e 20 2a | re|lation *|
|00003120| 72 65 6c 3b 0a 58 0a 58 | 20 20 20 20 20 20 20 20 |rel;.X.X| |
|00003130| 69 66 20 28 28 72 65 6c | 20 3d 20 6d 62 5f 69 6e |if ((rel| = mb_in|
|00003140| 63 20 28 22 2f 75 73 72 | 2f 6a 6f 65 2f 65 71 75 |c ("/usr|/joe/equ|
|00003150| 69 70 6d 65 6e 74 22 2c | 20 73 74 72 74 6f 6b 65 |ipment",| strtoke|
|00003160| 79 28 22 6b 65 79 22 29 | 29 29 20 3d 3d 20 52 4e |y("key")|)) == RN|
|00003170| 55 4c 4c 29 20 7b 0a 58 | 20 20 20 20 20 20 20 20 |ULL) {.X| |
|00003180| 20 20 20 70 72 69 6e 74 | 66 20 28 22 43 61 6e 27 | print|f ("Can'|
|00003190| 74 20 6f 70 65 6e 20 64 | 61 74 61 62 61 73 65 20 |t open d|atabase |
|000031a0| 2d 20 25 73 2e 5c 6e 22 | 2c 20 6d 62 5f 65 72 72 |- %s.\n"|, mb_err|
|000031b0| 6f 72 29 3b 0a 58 20 20 | 20 20 20 20 20 20 20 20 |or);.X | |
|000031c0| 20 6d 62 5f 65 78 69 74 | 20 28 31 29 3b 0a 58 20 | mb_exit| (1);.X |
|000031d0| 20 20 20 20 20 20 20 7d | 0a 58 0a 58 20 20 20 20 | }|.X.X |
|000031e0| 20 20 20 20 65 71 75 69 | 70 6d 65 6e 74 5f 72 65 | equi|pment_re|
|000031f0| 63 2e 70 72 69 63 65 5f | 63 6f 64 65 20 3d 20 31 |c.price_|code = 1|
|00003200| 31 34 2e 32 30 3b 20 20 | 20 20 20 20 20 2f 2a 20 |14.20; | /* |
|00003210| 53 65 74 20 75 70 20 69 | 6e 69 74 69 61 6c 20 76 |Set up i|nitial v|
|00003220| 61 6c 75 65 73 20 2a 2f | 0a 58 20 20 20 20 20 20 |alues */|.X |
|00003230| 20 20 73 74 72 63 70 79 | 20 28 65 71 75 69 70 6d | strcpy| (equipm|
|00003240| 65 6e 74 5f 72 65 63 2e | 70 61 72 74 5f 6e 75 6d |ent_rec.|part_num|
|00003250| 62 2c 20 22 31 31 37 22 | 29 3b 20 2f 2a 20 74 6f |b, "117"|); /* to|
|00003260| 20 73 65 61 72 63 68 20 | 66 6f 72 2e 2e 2e 20 20 | search |for... |
|00003270| 20 20 20 20 2a 2f 0a 58 | 0a 58 20 20 20 20 20 20 | */.X|.X |
|00003280| 20 20 69 66 20 28 6d 62 | 5f 73 65 6c 20 28 72 65 | if (mb|_sel (re|
|00003290| 6c 2c 20 30 2c 20 26 65 | 71 75 69 70 6d 65 6e 74 |l, 0, &e|quipment|
|000032a0| 5f 72 65 63 2c 20 45 51 | 55 41 4c 2c 20 4e 55 4c |_rec, EQ|UAL, NUL|
|000032b0| 4c 29 20 21 3d 20 30 29 | 20 7b 0a 58 20 20 20 20 |L) != 0)| {.X |
|000032c0| 20 20 20 20 20 20 20 70 | 72 69 6e 74 66 20 20 28 | p|rintf (|
|000032d0| 22 25 73 2e 5c 6e 22 2c | 20 6d 62 5f 65 72 72 6f |"%s.\n",| mb_erro|
|000032e0| 72 29 3b 0a 58 20 20 20 | 20 20 20 20 20 20 20 20 |r);.X | |
|000032f0| 6d 62 5f 65 78 69 74 20 | 28 31 29 3b 0a 58 20 20 |mb_exit |(1);.X |
|00003300| 20 20 20 20 20 20 7d 0a | 58 0a 58 20 20 20 20 20 | }.|X.X |
|00003310| 20 20 20 2f 2a 20 4e 6f | 77 20 74 68 61 74 20 77 | /* No|w that w|
|00003320| 65 27 76 65 20 66 6f 75 | 6e 64 20 61 20 72 65 63 |e've fou|nd a rec|
|00003330| 6f 72 64 2c 20 63 68 61 | 6e 67 65 20 69 74 20 74 |ord, cha|nge it t|
|00003340| 6f 20 73 6f 6d 65 74 68 | 69 6e 67 20 65 6c 73 65 |o someth|ing else|
|00003350| 2e 2e 2e 20 2a 2f 0a 58 | 0a 58 20 20 20 20 20 20 |... */.X|.X |
|00003360| 20 20 65 71 75 69 70 6d | 65 6e 74 5f 72 65 63 2e | equipm|ent_rec.|
|00003370| 6e 75 6d 5f 70 75 72 63 | 68 20 3d 20 31 34 3b 0a |num_purc|h = 14;.|
|00003380| 58 20 20 20 20 20 20 20 | 20 73 74 72 63 70 79 20 |X | strcpy |
|00003390| 28 65 71 75 69 70 6d 65 | 6e 74 5f 72 65 63 2e 63 |(equipme|nt_rec.c|
|000033a0| 75 73 74 6f 6d 65 72 2c | 20 20 22 53 75 22 29 3b |ustomer,| "Su");|
|000033b0| 0a 58 20 20 20 20 20 20 | 20 20 73 74 72 63 70 79 |.X | strcpy|
|000033c0| 20 28 65 71 75 69 70 6d | 65 6e 74 5f 72 65 63 2e | (equipm|ent_rec.|
|000033d0| 70 61 72 74 5f 6e 75 6d | 62 2c 20 22 31 31 32 22 |part_num|b, "112"|
|000033e0| 29 3b 0a 58 20 20 20 20 | 20 20 20 20 73 74 72 63 |);.X | strc|
|000033f0| 70 79 20 28 65 71 75 69 | 70 6d 65 6e 74 5f 72 65 |py (equi|pment_re|
|00003400| 63 2e 73 68 6f 70 5f 61 | 64 64 72 2c 20 22 44 61 |c.shop_a|ddr, "Da|
|00003410| 6c 6c 61 73 2c 20 54 58 | 22 29 3b 0a 58 20 20 20 |llas, TX|");.X |
|00003420| 20 20 20 20 20 65 71 75 | 69 70 6d 65 6e 74 5f 72 | equ|ipment_r|
|00003430| 65 63 2e 70 72 69 63 65 | 5f 63 6f 64 65 20 3d 20 |ec.price|_code = |
|00003440| 31 32 3b 0a 58 0a 58 20 | 20 20 20 20 20 20 20 6d |12;.X.X | m|
|00003450| 62 5f 75 70 64 20 28 72 | 65 6c 2c 20 26 65 71 75 |b_upd (r|el, &equ|
|00003460| 69 70 6d 65 6e 74 5f 72 | 65 63 29 3b 20 20 2f 2a |ipment_r|ec); /*|
|00003470| 20 55 70 64 61 74 65 20 | 74 68 65 20 63 75 72 72 | Update |the curr|
|00003480| 65 6e 74 20 73 65 6c 65 | 63 74 69 6f 6e 20 2a 2f |ent sele|ction */|
|00003490| 0a 58 0a 58 20 20 20 20 | 20 20 20 20 6d 62 5f 72 |.X.X | mb_r|
|000034a0| 6d 76 20 28 72 65 6c 29 | 3b 20 2f 2f 20 55 6e 6e |mv (rel)|; // Unn|
|000034b0| 65 63 65 73 73 61 72 79 | 20 62 65 66 6f 72 65 20 |ecessary| before |
|000034c0| 6d 62 5f 65 78 69 74 28 | 29 2c 20 62 75 74 20 67 |mb_exit(|), but g|
|000034d0| 6f 6f 64 20 70 72 61 63 | 74 69 63 65 2e 0a 58 20 |ood prac|tice..X |
|000034e0| 20 20 20 20 20 20 20 6d | 62 5f 65 78 69 74 20 28 | m|b_exit (|
|000034f0| 30 29 3b 20 20 2f 2f 20 | 41 6c 77 61 79 73 20 61 |0); // |Always a|
|00003500| 20 67 6f 6f 64 20 69 64 | 65 61 20 74 6f 20 75 73 | good id|ea to us|
|00003510| 65 20 6d 62 5f 65 78 69 | 74 28 29 20 77 69 74 68 |e mb_exi|t() with|
|00003520| 20 4d 65 74 61 6c 42 61 | 73 65 2e 0a 58 20 20 20 | MetalBa|se..X |
|00003530| 20 20 7d 0a 58 0a 58 20 | 20 20 20 4d 61 6e 69 70 | }.X.X | Manip|
|00003540| 75 6c 61 74 69 6f 6e 20 | 6f 66 20 72 65 6c 61 74 |ulation |of relat|
|00003550| 69 6f 6e 73 20 75 73 69 | 6e 67 20 4d 65 74 61 6c |ions usi|ng Metal|
|00003560| 42 61 73 65 20 69 73 20 | 73 69 6d 70 6c 65 2e 2e |Base is |simple..|
|00003570| 2e 20 62 79 20 69 6e 63 | 6c 75 64 69 6e 67 20 74 |. by inc|luding t|
|00003580| 68 65 0a 58 4d 65 74 61 | 6c 42 61 73 65 20 68 65 |he.XMeta|lBase he|
|00003590| 61 64 65 72 20 66 69 6c | 65 20 69 6e 20 79 6f 75 |ader fil|e in you|
|000035a0| 72 20 70 72 6f 67 72 61 | 6d 73 20 61 6e 64 20 63 |r progra|ms and c|
|000035b0| 6f 6d 70 69 6c 69 6e 67 | 20 75 73 69 6e 67 20 74 |ompiling| using t|
|000035c0| 68 65 20 6f 70 74 69 6f | 6e 20 22 2d 6c 6d 62 22 |he optio|n "-lmb"|
|000035d0| 0a 58 28 4f 72 20 22 6c | 69 62 72 61 72 79 20 2e |.X(Or "l|ibrary .|
|000035e0| 2e 2e 2c 20 6d 62 61 73 | 65 2e 6c 69 62 3b 22 2c |.., mbas|e.lib;",|
|000035f0| 20 64 65 70 65 6e 64 69 | 6e 67 20 6f 6e 20 79 6f | dependi|ng on yo|
|00003600| 75 72 20 63 6f 6d 70 69 | 6c 65 72 29 2c 20 79 6f |ur compi|ler), yo|
|00003610| 75 20 61 64 64 20 65 78 | 74 72 61 0a 58 63 6f 6d |u add ex|tra.Xcom|
|00003620| 6d 61 6e 64 73 20 74 6f | 20 43 2e 20 20 41 20 73 |mands to| C. A s|
|00003630| 75 6d 6d 61 72 79 20 6f | 66 20 74 68 65 73 65 20 |ummary o|f these |
|00003640| 66 6f 6c 6c 6f 77 73 3a | 0a 58 0a 58 20 2d 20 6d |follows:|.X.X - m|
|00003650| 62 5f 69 6e 63 20 28 66 | 69 6c 65 6e 61 6d 65 2c |b_inc (f|ilename,|
|00003660| 20 69 6e 74 29 20 2d 2d | 20 74 68 69 73 20 63 6f | int) --| this co|
|00003670| 6d 6d 61 6e 64 20 69 6e | 63 6c 75 64 65 73 20 61 |mmand in|cludes a|
|00003680| 20 72 65 6c 61 74 69 6f | 6e 20 6f 6e 20 79 6f 75 | relatio|n on you|
|00003690| 72 20 64 65 73 6b 74 6f | 70 2c 0a 58 20 20 20 20 |r deskto|p,.X |
|000036a0| 20 20 20 20 73 6f 20 74 | 68 61 74 20 69 74 20 62 | so t|hat it b|
|000036b0| 65 63 6f 6d 65 73 20 61 | 63 63 65 73 73 61 62 6c |ecomes a|ccessabl|
|000036c0| 65 2e 20 20 41 6e 79 20 | 72 65 6c 61 74 69 6f 6e |e. Any |relation|
|000036d0| 20 79 6f 75 20 77 69 73 | 68 20 74 6f 20 77 6f 72 | you wis|h to wor|
|000036e0| 6b 20 77 69 74 68 0a 58 | 20 20 20 20 20 20 20 20 |k with.X| |
|000036f0| 6d 75 73 74 20 62 65 20 | 69 6e 63 6c 75 64 65 64 |must be |included|
|00003700| 20 75 73 69 6e 67 20 74 | 68 69 73 20 63 61 6c 6c | using t|his call|
|00003710| 2e 20 20 49 66 20 6d 62 | 5f 69 6e 63 20 72 65 74 |. If mb|_inc ret|
|00003720| 75 72 6e 73 20 52 4e 55 | 4c 4c 20 28 20 64 65 66 |urns RNU|LL ( def|
|00003730| 69 6e 65 64 0a 58 20 20 | 20 20 20 20 20 20 61 73 |ined.X | as|
|00003740| 20 28 72 65 6c 61 74 69 | 6f 6e 20 2a 29 30 20 29 | (relati|on *)0 )|
|00003750| 2c 20 61 6e 20 65 72 72 | 6f 72 20 68 61 73 20 6f |, an err|or has o|
|00003760| 63 63 75 72 72 65 64 20 | 28 54 68 65 20 6d 6f 73 |ccurred |(The mos|
|00003770| 74 20 6c 69 6b 65 6c 79 | 20 6f 6e 65 20 69 73 20 |t likely| one is |
|00003780| 74 68 61 74 0a 58 20 20 | 20 20 20 20 20 20 74 68 |that.X | th|
|00003790| 65 20 72 65 6c 61 74 69 | 6f 6e 20 63 61 6e 6e 6f |e relati|on canno|
|000037a0| 74 20 62 65 20 66 6f 75 | 6e 64 20 75 6e 64 65 72 |t be fou|nd under|
|000037b0| 20 74 68 65 20 67 69 76 | 65 6e 20 64 69 72 65 63 | the giv|en direc|
|000037c0| 74 6f 72 79 2d 2d 6d 62 | 5f 65 72 72 6e 6f 20 77 |tory--mb|_errno w|
|000037d0| 69 6c 6c 0a 58 20 20 20 | 20 20 20 20 20 62 65 20 |ill.X | be |
|000037e0| 73 65 74 20 74 6f 20 61 | 6e 20 65 72 72 6f 72 20 |set to a|n error |
|000037f0| 6e 75 6d 62 65 72 2c 20 | 61 6e 64 20 6d 62 5f 65 |number, |and mb_e|
|00003800| 72 72 6f 72 20 28 67 6c | 6f 62 61 6c 20 63 68 61 |rror (gl|obal cha|
|00003810| 72 2a 29 20 77 69 6c 6c | 20 63 6f 6e 74 61 69 6e |r*) will| contain|
|00003820| 0a 58 20 20 20 20 20 20 | 20 20 74 65 78 74 20 72 |.X | text r|
|00003830| 65 67 61 72 64 69 6e 67 | 20 74 68 65 20 70 72 6f |egarding| the pro|
|00003840| 62 6c 65 6d 29 2e 20 20 | 4e 6f 74 65 20 74 68 61 |blem). |Note tha|
|00003850| 74 20 22 66 69 6c 65 6e | 61 6d 65 22 20 64 6f 65 |t "filen|ame" doe|
|00003860| 73 20 4e 4f 54 20 69 6e | 63 6c 75 64 65 20 74 68 |s NOT in|clude th|
|00003870| 65 0a 58 20 20 20 20 20 | 20 20 20 22 2e 72 65 6c |e.X | ".rel|
|00003880| 22 20 73 75 66 66 69 78 | 2e 20 20 42 55 49 4c 44 |" suffix|. BUILD|
|00003890| 2c 20 69 6e 20 61 6e 61 | 6c 6f 67 2c 20 64 6f 65 |, in ana|log, doe|
|000038a0| 73 20 6e 6f 74 20 72 65 | 71 75 69 72 65 20 74 68 |s not re|quire th|
|000038b0| 61 74 20 79 6f 75 20 69 | 6e 63 6c 75 64 65 20 74 |at you i|nclude t|
|000038c0| 68 65 0a 58 20 20 20 20 | 20 20 20 20 22 2e 73 22 |he.X | ".s"|
|000038d0| 20 73 75 66 66 69 78 20 | 6f 6e 20 74 68 65 20 6e | suffix |on the n|
|000038e0| 61 6d 65 20 6f 66 20 74 | 68 65 20 73 63 68 65 6d |ame of t|he schem|
|000038f0| 61 20 79 6f 75 20 61 72 | 65 20 77 6f 72 6b 69 6e |a you ar|e workin|
|00003900| 67 20 77 69 74 68 2c 20 | 62 75 74 20 74 68 65 0a |g with, |but the.|
|00003910| 58 20 20 20 20 20 20 20 | 20 73 63 68 65 6d 61 20 |X | schema |
|00003920| 66 69 6c 65 20 69 74 73 | 65 6c 66 20 6d 75 73 74 |file its|elf must|
|00003930| 20 65 6e 64 20 69 6e 20 | 22 2e 73 22 2c 20 61 73 | end in |".s", as|
|00003940| 20 72 65 6c 61 74 69 6f | 6e 73 20 6d 75 73 74 20 | relatio|ns must |
|00003950| 65 6e 64 20 69 6e 20 22 | 2e 72 65 6c 22 2c 0a 58 |end in "|.rel",.X|
|00003960| 20 20 20 20 20 20 20 20 | 66 6f 72 6d 73 20 69 6e | |forms in|
|00003970| 20 22 2e 66 72 6d 22 20 | 61 6e 64 20 72 65 70 6f | ".frm" |and repo|
|00003980| 72 74 73 20 69 6e 20 22 | 2e 72 70 74 22 2e 0a 58 |rts in "|.rpt"..X|
|00003990| 0a 58 20 20 20 20 20 20 | 20 20 54 68 65 20 69 6e |.X | The in|
|000039a0| 74 65 67 65 72 20 70 61 | 73 73 65 64 20 69 6e 20 |teger pa|ssed in |
|000039b0| 69 73 20 74 68 65 20 65 | 6e 63 72 79 70 74 69 6f |is the e|ncryptio|
|000039c0| 6e 20 6b 65 79 20 66 6f | 72 20 74 68 65 20 72 65 |n key fo|r the re|
|000039d0| 6c 61 74 69 6f 6e 2d 2d | 73 65 65 20 74 68 65 0a |lation--|see the.|
|000039e0| 58 20 20 20 20 20 20 20 | 20 73 65 63 74 69 6f 6e |X | section|
|000039f0| 20 6f 6e 20 65 6e 63 72 | 79 70 74 69 6f 6e 20 66 | on encr|yption f|
|00003a00| 6f 72 20 6d 6f 72 65 20 | 69 6e 66 6f 72 6d 61 74 |or more |informat|
|00003a10| 69 6f 6e 2e 20 20 4e 6f | 74 65 20 74 68 61 74 20 |ion. No|te that |
|00003a20| 4d 65 74 61 6c 42 61 73 | 65 20 33 2e 30 2c 0a 58 |MetalBas|e 3.0,.X|
|00003a30| 20 20 20 20 20 20 20 20 | 61 73 20 69 74 20 64 6f | |as it do|
|00003a40| 65 73 20 6e 6f 74 20 73 | 75 70 70 6f 72 74 20 65 |es not s|upport e|
|00003a50| 6e 63 72 79 70 74 69 6f | 6e 2c 20 64 6f 65 73 20 |ncryptio|n, does |
|00003a60| 6e 6f 74 20 72 65 71 75 | 69 72 65 20 74 68 69 73 |not requ|ire this|
|00003a70| 20 69 6e 74 65 67 65 72 | 3b 20 61 6c 6c 0a 58 20 | integer|; all.X |
|00003a80| 20 20 20 20 20 20 20 76 | 65 72 73 69 6f 6e 73 20 | v|ersions |
|00003a90| 33 2e 31 20 61 6e 64 20 | 75 70 20 64 6f 2e 20 20 |3.1 and |up do. |
|00003aa0| 53 6f 72 72 79 20 66 6f | 72 20 74 68 65 20 69 6e |Sorry fo|r the in|
|00003ab0| 63 6f 6e 76 65 6e 69 65 | 6e 63 65 2e 0a 58 0a 58 |convenie|nce..X.X|
|00003ac0| 20 20 20 20 20 20 20 20 | 49 20 61 6c 73 6f 20 53 | |I also S|
|00003ad0| 54 52 4f 4e 47 4c 59 20 | 72 65 63 6f 6d 6d 65 6e |TRONGLY |recommen|
|00003ae0| 64 20 74 68 65 20 75 73 | 65 20 6f 66 20 74 68 65 |d the us|e of the|
|00003af0| 20 66 75 6e 63 74 69 6f | 6e 20 73 74 72 74 6f 6b | functio|n strtok|
|00003b00| 65 79 28 29 20 74 6f 0a | 58 20 20 20 20 20 20 20 |ey() to.|X |
|00003b10| 20 6f 62 74 61 69 6e 20 | 74 68 69 73 20 69 6e 74 | obtain |this int|
|00003b20| 65 67 65 72 20 66 72 6f | 6d 20 61 6e 20 61 73 63 |eger fro|m an asc|
|00003b30| 69 69 20 73 74 72 69 6e | 67 2e 2e 2e 20 61 6c 6c |ii strin|g... all|
|00003b40| 20 75 74 69 6c 69 74 79 | 20 70 72 6f 67 72 61 6d | utility| program|
|00003b50| 73 0a 58 20 20 20 20 20 | 20 20 20 73 68 69 70 70 |s.X | shipp|
|00003b60| 65 64 20 77 69 74 68 20 | 4d 65 74 61 6c 42 61 73 |ed with |MetalBas|
|00003b70| 65 20 61 73 6b 20 66 6f | 72 20 22 45 6e 63 72 79 |e ask fo|r "Encry|
|00003b80| 70 74 69 6f 6e 20 4b 65 | 79 22 73 2c 20 61 6e 64 |ption Ke|y"s, and|
|00003b90| 20 74 68 65 79 20 65 78 | 70 65 63 74 0a 58 20 20 | they ex|pect.X |
|00003ba0| 20 20 20 20 20 20 61 20 | 73 74 72 69 6e 67 20 74 | a |string t|
|00003bb0| 6f 20 68 61 73 68 20 75 | 70 20 77 69 74 68 20 73 |o hash u|p with s|
|00003bc0| 74 72 74 6f 6b 65 79 28 | 29 2e 20 20 53 6f 20 69 |trtokey(|). So i|
|00003bd0| 66 20 79 6f 75 20 75 73 | 65 20 65 6e 63 72 79 70 |f you us|e encryp|
|00003be0| 74 69 6f 6e 20 62 75 74 | 0a 58 20 20 20 20 20 20 |tion but|.X |
|00003bf0| 20 20 6e 6f 74 20 74 68 | 69 73 20 6d 65 74 68 6f | not th|is metho|
|00003c00| 64 20 6f 66 20 67 65 74 | 74 69 6e 67 20 74 68 65 |d of get|ting the|
|00003c10| 20 69 6e 74 65 67 65 72 | 2c 20 79 6f 75 27 72 65 | integer|, you're|
|00003c20| 20 53 4f 4c 20 77 68 65 | 6e 20 74 72 79 69 6e 67 | SOL whe|n trying|
|00003c30| 20 74 6f 0a 58 20 20 20 | 20 20 20 20 20 75 73 65 | to.X | use|
|00003c40| 20 76 72 20 6f 72 20 72 | 65 70 6f 72 74 2e 20 20 | vr or r|eport. |
|00003c50| 49 6e 20 66 61 63 74 2c | 20 49 20 65 6e 63 6f 75 |In fact,| I encou|
|00003c60| 72 61 67 65 20 74 68 69 | 73 20 73 6f 20 73 74 72 |rage thi|s so str|
|00003c70| 6f 6e 67 6c 79 20 74 68 | 61 74 2c 20 69 6e 0a 58 |ongly th|at, in.X|
|00003c80| 20 20 20 20 20 20 20 20 | 66 75 74 75 72 65 20 72 | |future r|
|00003c90| 65 6c 65 61 73 65 73 2c | 20 49 20 6d 61 79 20 72 |eleases,| I may r|
|00003ca0| 65 70 6c 61 63 65 20 74 | 68 65 20 69 6e 74 65 67 |eplace t|he integ|
|00003cb0| 65 72 20 61 72 67 75 6d | 65 6e 74 20 77 69 74 68 |er argum|ent with|
|00003cc0| 20 61 20 73 74 72 69 6e | 67 0a 58 20 20 20 20 20 | a strin|g.X |
|00003cd0| 20 20 20 61 72 67 75 6d | 65 6e 74 20 61 6e 64 20 | argum|ent and |
|00003ce0| 64 6f 20 61 77 61 79 20 | 77 69 74 68 20 73 74 72 |do away |with str|
|00003cf0| 74 6f 6b 65 79 28 29 20 | 65 6e 74 69 72 65 6c 79 |tokey() |entirely|
|00003d00| 2e 0a 58 0a 58 20 2d 20 | 6d 62 5f 74 73 74 20 28 |..X.X - |mb_tst (|
|00003d10| 66 69 6c 65 6e 61 6d 65 | 29 20 2d 2d 20 54 68 69 |filename|) -- Thi|
|00003d20| 73 20 66 75 6e 63 74 69 | 6f 6e 20 67 6f 65 73 20 |s functi|on goes |
|00003d30| 74 68 72 6f 75 67 68 20 | 61 6c 6c 20 74 68 65 20 |through |all the |
|00003d40| 73 74 65 70 73 20 6e 65 | 65 64 65 64 20 74 6f 0a |steps ne|eded to.|
|00003d50| 58 20 20 20 20 20 20 20 | 20 6d 61 6b 65 20 73 75 |X | make su|
|00003d60| 72 65 20 61 20 67 69 76 | 65 6e 20 72 65 6c 61 74 |re a giv|en relat|
|00003d70| 69 6f 6e 20 63 61 6e 20 | 62 65 20 6f 70 65 6e 65 |ion can |be opene|
|00003d80| 64 2c 20 62 75 74 20 64 | 6f 65 73 6e 27 74 20 6f |d, but d|oesn't o|
|00003d90| 70 65 6e 20 69 74 20 28 | 74 68 75 73 0a 58 20 20 |pen it (|thus.X |
|00003da0| 20 20 20 20 20 20 69 74 | 20 64 6f 65 73 6e 27 74 | it| doesn't|
|00003db0| 20 6e 65 65 64 20 61 6e | 20 65 6e 63 72 79 70 74 | need an| encrypt|
|00003dc0| 69 6f 6e 20 6b 65 79 29 | 2e 20 20 76 72 20 75 73 |ion key)|. vr us|
|00003dd0| 65 73 20 74 68 69 73 20 | 6f 6e 65 20 74 6f 20 6d |es this |one to m|
|00003de0| 61 6b 65 20 73 75 72 65 | 0a 58 20 20 20 20 20 20 |ake sure|.X |
|00003df0| 20 20 69 74 20 63 61 6e | 20 6f 70 65 6e 20 61 20 | it can| open a |
|00003e00| 72 65 6c 61 74 69 6f 6e | 20 62 65 66 6f 72 65 20 |relation| before |
|00003e10| 61 73 6b 69 6e 67 20 66 | 6f 72 20 61 20 6b 65 79 |asking f|or a key|
|00003e20| 3b 20 74 68 61 74 27 73 | 20 70 72 65 74 74 79 20 |; that's| pretty |
|00003e30| 6d 75 63 68 0a 58 20 20 | 20 20 20 20 20 20 69 74 |much.X | it|
|00003e40| 73 20 6f 6e 6c 79 20 75 | 73 65 2e 0a 58 0a 58 20 |s only u|se..X.X |
|00003e50| 2d 20 6d 62 5f 73 65 6c | 20 28 66 69 6c 65 2c 20 |- mb_sel| (file, |
|00003e60| 69 6e 64 65 78 2c 20 62 | 75 66 66 65 72 2c 20 61 |index, b|uffer, a|
|00003e70| 63 74 69 6f 6e 2c 20 63 | 6f 6d 70 61 72 69 73 6f |ction, c|ompariso|
|00003e80| 6e 5f 62 75 66 66 65 72 | 29 20 2d 2d 20 74 68 69 |n_buffer|) -- thi|
|00003e90| 73 20 63 6f 6d 6d 61 6e | 64 0a 58 20 20 20 20 20 |s comman|d.X |
|00003ea0| 20 20 20 73 65 61 72 63 | 68 65 73 20 61 20 67 69 | searc|hes a gi|
|00003eb0| 76 65 6e 20 72 65 6c 61 | 74 69 6f 6e 20 66 6f 72 |ven rela|tion for|
|00003ec0| 20 74 68 65 20 72 65 63 | 6f 72 64 20 79 6f 75 20 | the rec|ord you |
|00003ed0| 64 65 73 69 72 65 2c 20 | 64 65 73 63 72 69 62 65 |desire, |describe|
|00003ee0| 64 20 62 79 0a 58 20 20 | 20 20 20 20 20 20 22 61 |d by.X | "a|
|00003ef0| 63 74 69 6f 6e 22 20 61 | 6e 64 20 22 63 6f 6d 70 |ction" a|nd "comp|
|00003f00| 61 72 69 73 6f 6e 5f 76 | 61 6c 75 65 22 2e 20 20 |arison_v|alue". |
|00003f10| 22 66 69 6c 65 22 20 69 | 73 20 61 20 70 6f 69 6e |"file" i|s a poin|
|00003f20| 74 65 72 20 74 6f 20 74 | 68 65 20 73 74 72 75 63 |ter to t|he struc|
|00003f30| 74 75 72 65 0a 58 20 20 | 20 20 20 20 20 20 72 65 |ture.X | re|
|00003f40| 74 75 72 6e 65 64 20 62 | 79 20 6d 62 5f 69 6e 63 |turned b|y mb_inc|
|00003f50| 2e 2e 2e 20 74 68 69 73 | 20 73 74 72 75 63 74 75 |... this| structu|
|00003f60| 72 65 20 69 73 20 75 73 | 65 64 20 69 6e 20 61 6c |re is us|ed in al|
|00003f70| 6c 20 6f 74 68 65 72 20 | 66 75 6e 63 74 69 6f 6e |l other |function|
|00003f80| 73 20 74 6f 0a 58 20 20 | 20 20 20 20 20 20 69 6e |s to.X | in|
|00003f90| 64 69 63 61 74 65 20 77 | 68 69 63 68 20 72 65 6c |dicate w|hich rel|
|00003fa0| 61 74 69 6f 6e 20 79 6f | 75 20 69 6e 74 65 6e 64 |ation yo|u intend|
|00003fb0| 20 74 6f 20 77 6f 72 6b | 20 77 69 74 68 2e 20 20 | to work| with. |
|00003fc0| 22 69 6e 64 65 78 22 20 | 69 73 20 74 68 65 20 69 |"index" |is the i|
|00003fd0| 6e 64 65 78 0a 58 20 20 | 20 20 20 20 20 20 6e 75 |ndex.X | nu|
|00003fe0| 6d 62 65 72 20 62 79 20 | 77 68 69 63 68 20 79 6f |mber by |which yo|
|00003ff0| 75 20 77 69 73 68 20 74 | 6f 20 73 65 61 72 63 68 |u wish t|o search|
|00004000| 2e 2e 2e 20 6e 75 6d 62 | 65 72 65 64 20 73 65 71 |... numb|ered seq|
|00004010| 75 65 6e 74 69 61 6c 6c | 79 20 62 79 20 74 68 65 |uentiall|y by the|
|00004020| 0a 58 20 20 20 20 20 20 | 20 20 6f 72 64 65 72 20 |.X | order |
|00004030| 69 6e 20 77 68 69 63 68 | 20 74 68 65 79 20 77 65 |in which| they we|
|00004040| 72 65 20 64 65 66 69 6e | 65 64 20 69 6e 20 74 68 |re defin|ed in th|
|00004050| 65 20 73 63 68 65 6d 61 | 2c 20 73 74 61 72 74 69 |e schema|, starti|
|00004060| 6e 67 20 77 69 74 68 20 | 74 68 65 0a 58 20 20 20 |ng with |the.X |
|00004070| 20 20 20 20 20 6e 75 6d | 62 65 72 20 30 2e 20 20 | num|ber 0. |
|00004080| 54 6f 20 73 61 76 65 20 | 74 72 6f 75 62 6c 65 20 |To save |trouble |
|00004090| 77 68 65 6e 20 63 68 61 | 6e 67 69 6e 67 20 73 63 |when cha|nging sc|
|000040a0| 68 65 6d 61 2c 20 69 74 | 20 69 73 20 72 65 63 6f |hema, it| is reco|
|000040b0| 6d 6d 65 6e 64 65 64 20 | 79 6f 75 0a 58 20 20 20 |mmended |you.X |
|000040c0| 20 20 20 20 20 75 73 65 | 20 74 68 65 20 72 6f 75 | use| the rou|
|000040d0| 74 69 6e 65 20 69 64 78 | 6e 75 6d 28 29 20 74 6f |tine idx|num() to|
|000040e0| 20 6c 6f 6f 6b 20 75 70 | 20 61 6e 20 69 6e 64 65 | look up| an inde|
|000040f0| 78 20 6e 75 6d 62 65 72 | 20 62 79 20 6e 61 6d 65 |x number| by name|
|00004100| 2e 20 20 22 62 75 66 66 | 65 72 22 0a 58 20 20 20 |. "buff|er".X |
|00004110| 20 20 20 20 20 69 73 20 | 6d 65 72 65 6c 79 20 61 | is |merely a|
|00004120| 20 73 74 72 75 63 74 75 | 72 65 20 28 6c 69 6b 65 | structu|re (like|
|00004130| 20 26 65 71 75 69 70 6d | 65 6e 74 5f 72 65 63 20 | &equipm|ent_rec |
|00004140| 61 62 6f 76 65 29 20 69 | 6e 74 6f 20 77 68 69 63 |above) i|nto whic|
|00004150| 68 20 4d 65 74 61 6c 42 | 61 73 65 0a 58 20 20 20 |h MetalB|ase.X |
|00004160| 20 20 20 20 20 63 61 6e | 20 72 65 74 75 72 6e 20 | can| return |
|00004170| 74 68 65 20 72 65 63 6f | 72 64 2c 20 77 68 65 6e |the reco|rd, when|
|00004180| 20 66 6f 75 6e 64 2e 20 | 20 41 20 6c 69 73 74 20 | found. | A list |
|00004190| 6f 66 20 76 61 6c 69 64 | 20 61 63 74 69 6f 6e 73 |of valid| actions|
|000041a0| 20 66 6f 6c 6c 6f 77 73 | 3a 0a 58 20 20 20 20 20 | follows|:.X |
|000041b0| 20 20 20 20 20 20 46 49 | 52 53 54 20 28 6f 72 20 | FI|RST (or |
|000041c0| 46 52 53 54 29 20 2d 2d | 20 73 65 61 72 63 68 65 |FRST) --| searche|
|000041d0| 73 20 66 6f 72 20 74 68 | 65 20 66 69 72 73 74 20 |s for th|e first |
|000041e0| 72 65 63 6f 72 64 20 61 | 6c 70 68 61 62 65 74 69 |record a|lphabeti|
|000041f0| 63 61 6c 6c 79 2e 0a 58 | 20 20 20 20 20 20 20 20 |cally..X| |
|00004200| 20 20 20 4c 41 53 54 20 | 2d 2d 20 73 69 6d 69 6c | LAST |-- simil|
|00004210| 61 72 6c 79 2c 20 73 65 | 65 6b 73 20 74 68 65 20 |arly, se|eks the |
|00004220| 6c 61 73 74 20 72 65 63 | 6f 72 64 20 61 6c 70 68 |last rec|ord alph|
|00004230| 61 62 65 74 69 63 61 6c | 6c 79 2e 0a 58 20 20 20 |abetical|ly..X |
|00004240| 20 20 20 20 20 20 20 20 | 4e 45 58 54 20 2d 2d 20 | |NEXT -- |
|00004250| 73 65 61 72 63 68 65 73 | 20 66 6f 72 20 74 68 65 |searches| for the|
|00004260| 20 6e 65 78 74 20 73 65 | 71 75 65 6e 74 69 61 6c | next se|quential|
|00004270| 20 72 65 63 6f 72 64 20 | 61 6c 70 68 61 62 65 74 | record |alphabet|
|00004280| 69 63 61 6c 6c 79 2e 0a | 58 20 20 20 20 20 20 20 |ically..|X |
|00004290| 20 20 20 20 50 52 45 56 | 49 4f 55 53 20 28 50 52 | PREV|IOUS (PR|
|000042a0| 45 56 29 20 2d 2d 20 61 | 73 20 4e 45 58 54 2c 20 |EV) -- a|s NEXT, |
|000042b0| 73 65 61 72 63 68 65 73 | 20 66 6f 72 20 74 68 65 |searches| for the|
|000042c0| 20 70 72 65 76 69 6f 75 | 73 20 72 65 63 6f 72 64 | previou|s record|
|000042d0| 2e 0a 58 20 20 20 20 20 | 20 20 20 20 20 20 45 51 |..X | EQ|
|000042e0| 55 41 4c 20 28 45 51 55 | 4c 29 20 2d 2d 20 73 65 |UAL (EQU|L) -- se|
|000042f0| 65 6b 73 20 61 20 72 65 | 63 6f 72 64 20 63 6f 6e |eks a re|cord con|
|00004300| 74 61 69 6e 69 6e 67 20 | 66 69 65 6c 64 73 20 65 |taining |fields e|
|00004310| 78 61 63 74 6c 79 20 74 | 68 6f 73 65 20 69 6e 0a |xactly t|hose in.|
|00004320| 58 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |X | |
|00004330| 20 22 63 6f 6d 70 61 72 | 69 73 6f 6e 5f 62 75 66 | "compar|ison_buf|
|00004340| 66 65 72 22 2e 20 20 49 | 66 20 74 68 65 20 69 6e |fer". I|f the in|
|00004350| 64 65 78 20 75 73 65 64 | 20 61 6c 6c 6f 77 73 20 |dex used| allows |
|00004360| 64 75 70 6c 69 63 61 74 | 65 73 20 61 6e 64 0a 58 |duplicat|es and.X|
|00004370| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00004380| 73 6f 6d 65 20 65 78 69 | 73 74 2c 20 45 51 55 41 |some exi|st, EQUA|
|00004390| 4c 20 72 65 74 75 72 6e | 73 20 74 68 65 20 66 69 |L return|s the fi|
|000043a0| 72 73 74 20 6f 66 20 74 | 68 65 73 65 3a 20 61 6c |rst of t|hese: al|
|000043b0| 6c 20 64 75 70 6c 69 63 | 61 74 65 73 0a 58 20 20 |l duplic|ates.X |
|000043c0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 63 61 | | ca|
|000043d0| 6e 20 62 65 20 66 6f 75 | 6e 64 20 62 79 20 73 75 |n be fou|nd by su|
|000043e0| 62 73 65 71 75 65 6e 74 | 20 22 4e 45 58 54 22 20 |bsequent| "NEXT" |
|000043f0| 73 65 61 72 63 68 65 73 | 2e 20 20 4e 6f 74 65 20 |searches|. Note |
|00004400| 74 68 61 74 20 74 68 65 | 0a 58 20 20 20 20 20 20 |that the|.X |
|00004410| 20 20 20 20 20 20 20 20 | 20 20 63 6f 6d 70 61 72 | | compar|
|00004420| 69 73 6f 6e 5f 62 75 66 | 66 65 72 20 61 6e 64 20 |ison_buf|fer and |
|00004430| 74 68 65 20 72 65 74 75 | 72 6e 20 62 75 66 66 65 |the retu|rn buffe|
|00004440| 72 20 6e 65 65 64 20 6e | 6f 74 20 62 65 20 74 68 |r need n|ot be th|
|00004450| 65 20 73 61 6d 65 0a 58 | 20 20 20 20 20 20 20 20 |e same.X| |
|00004460| 20 20 20 20 20 20 20 20 | 73 70 61 63 65 2c 20 61 | |space, a|
|00004470| 6c 74 68 6f 75 67 68 20 | 74 68 65 79 20 6d 61 79 |lthough |they may|
|00004480| 2e 0a 58 20 20 20 20 20 | 20 20 20 20 20 20 47 54 |..X | GT|
|00004490| 45 51 20 2d 2d 20 45 51 | 55 41 4c 20 72 65 74 75 |EQ -- EQ|UAL retu|
|000044a0| 72 6e 73 20 61 20 4e 4f | 54 5f 46 4f 55 4e 44 20 |rns a NO|T_FOUND |
|000044b0| 65 72 72 6f 72 20 69 66 | 20 61 20 72 65 63 6f 72 |error if| a recor|
|000044c0| 64 20 63 61 6e 6e 6f 74 | 20 62 65 20 66 6f 75 6e |d cannot| be foun|
|000044d0| 64 0a 58 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |d.X | |
|000044e0| 20 20 20 74 6f 20 70 72 | 65 63 69 73 65 6c 79 20 | to pr|ecisely |
|000044f0| 6d 61 74 63 68 20 74 68 | 65 20 63 6f 6d 70 61 72 |match th|e compar|
|00004500| 69 73 6f 6e 2e 20 20 47 | 54 45 51 20 61 63 74 73 |ison. G|TEQ acts|
|00004510| 20 61 73 20 45 51 55 41 | 4c 20 69 6e 20 61 6c 6c | as EQUA|L in all|
|00004520| 0a 58 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |.X | |
|00004530| 20 20 72 65 73 70 65 63 | 74 73 20 62 75 74 20 74 | respec|ts but t|
|00004540| 68 69 73 3b 20 20 47 54 | 45 51 20 77 69 6c 6c 20 |his; GT|EQ will |
|00004550| 66 69 6e 64 20 74 68 65 | 20 72 65 63 6f 72 64 20 |find the| record |
|00004560| 67 72 65 61 74 65 72 0a | 58 20 20 20 20 20 20 20 |greater.|X |
|00004570| 20 20 20 20 20 20 20 20 | 20 61 6c 70 68 61 62 65 | | alphabe|
|00004580| 74 69 63 61 6c 6c 79 2c | 20 6f 72 20 70 72 65 63 |tically,| or prec|
|00004590| 69 73 65 6c 79 20 65 71 | 75 61 6c 20 74 6f 20 28 |isely eq|ual to (|
|000045a0| 69 66 20 6f 6e 65 20 65 | 78 69 73 74 73 29 2c 20 |if one e|xists), |
|000045b0| 74 68 65 0a 58 20 20 20 | 20 20 20 20 20 20 20 20 |the.X | |
|000045c0| 20 20 20 20 20 63 6f 6d | 70 61 72 69 73 6f 6e 2e | com|parison.|
|000045d0| 20 20 49 6e 20 74 68 65 | 20 65 76 65 6e 74 20 74 | In the| event t|
|000045e0| 68 61 74 20 64 75 70 6c | 69 63 61 74 65 73 20 6f |hat dupl|icates o|
|000045f0| 66 20 74 68 65 20 72 65 | 63 6f 72 64 20 65 78 69 |f the re|cord exi|
|00004600| 73 74 0a 58 20 20 20 20 | 20 20 20 20 20 20 20 20 |st.X | |
|00004610| 20 20 20 20 28 22 44 75 | 70 6c 69 63 61 74 65 22 | ("Du|plicate"|
|00004620| 20 62 65 69 6e 67 20 64 | 65 66 69 6e 65 64 20 6c | being d|efined l|
|00004630| 6f 67 69 63 61 6c 6c 79 | 20 61 73 20 61 20 72 65 |ogically| as a re|
|00004640| 63 6f 72 64 20 77 68 6f | 73 65 20 66 69 65 6c 64 |cord who|se field|
|00004650| 73 0a 58 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |s.X | |
|00004660| 20 20 20 75 73 65 64 20 | 62 79 20 74 68 65 20 63 | used |by the c|
|00004670| 75 72 72 65 6e 74 20 69 | 6e 64 65 78 20 61 72 65 |urrent i|ndex are|
|00004680| 20 70 72 65 63 69 73 65 | 6c 79 20 65 71 75 61 6c | precise|ly equal|
|00004690| 20 74 6f 20 61 6e 6f 74 | 68 65 72 20 73 75 63 68 | to anot|her such|
|000046a0| 0a 58 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |.X | |
|000046b0| 20 20 72 65 63 6f 72 64 | 27 73 20 66 69 65 6c 64 | record|'s field|
|000046c0| 73 20 66 6f 72 20 74 68 | 65 20 73 61 6d 65 20 69 |s for th|e same i|
|000046d0| 6e 64 65 78 29 2c 20 47 | 54 45 51 20 72 65 74 75 |ndex), G|TEQ retu|
|000046e0| 72 6e 73 20 74 68 65 20 | 66 69 72 73 74 0a 58 20 |rns the |first.X |
|000046f0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 6f | | o|
|00004700| 66 20 74 68 65 73 65 3a | 20 61 6c 6c 20 64 75 70 |f these:| all dup|
|00004710| 6c 69 63 61 74 65 73 20 | 63 61 6e 20 62 65 20 66 |licates |can be f|
|00004720| 6f 75 6e 64 20 62 79 20 | 73 75 62 73 65 71 75 65 |ound by |subseque|
|00004730| 6e 74 20 22 4e 45 58 54 | 22 0a 58 20 20 20 20 20 |nt "NEXT|".X |
|00004740| 20 20 20 20 20 20 20 20 | 20 20 20 73 65 61 72 63 | | searc|
|00004750| 68 65 73 2e 0a 58 20 20 | 20 20 20 20 20 20 20 20 |hes..X | |
|00004760| 20 47 54 48 41 4e 20 28 | 47 54 48 4e 29 20 2d 2d | GTHAN (|GTHN) --|
|00004770| 20 41 63 74 73 20 61 73 | 20 47 54 45 51 2c 20 65 | Acts as| GTEQ, e|
|00004780| 78 63 65 70 74 20 47 54 | 48 41 4e 20 77 69 6c 6c |xcept GT|HAN will|
|00004790| 20 69 67 6e 6f 72 65 20 | 70 72 65 63 69 73 65 0a | ignore |precise.|
|000047a0| 58 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |X | |
|000047b0| 20 6d 61 74 63 68 65 73 | 2e 20 20 55 73 65 66 75 | matches|. Usefu|
|000047c0| 6c 20 69 66 20 79 6f 75 | 20 77 69 73 68 20 74 6f |l if you| wish to|
|000047d0| 20 62 65 67 69 6e 20 73 | 65 61 72 63 68 69 6e 67 | begin s|earching|
|000047e0| 20 6e 61 6d 65 73 2c 20 | 73 61 79 2c 0a 58 20 20 | names, |say,.X |
|000047f0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 61 66 | | af|
|00004800| 74 65 72 20 74 68 65 20 | 22 53 6d 69 74 68 22 27 |ter the |"Smith"'|
|00004810| 73 2e 20 20 41 6e 6f 74 | 68 65 72 20 77 61 79 20 |s. Anot|her way |
|00004820| 74 6f 20 61 63 63 6f 6d | 70 6c 69 73 68 20 74 68 |to accom|plish th|
|00004830| 69 73 20 77 6f 75 6c 64 | 20 62 65 0a 58 20 20 20 |is would| be.X |
|00004840| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 74 6f 20 | | to |
|00004850| 75 73 65 20 4c 54 45 51 | 20 2b 20 22 53 6d 69 74 |use LTEQ| + "Smit|
|00004860| 68 22 2c 20 66 6f 6c 6c | 6f 77 65 64 20 62 79 20 |h", foll|owed by |
|00004870| 61 20 4e 45 58 54 2e 2e | 2e 0a 58 20 20 20 20 20 |a NEXT..|..X |
|00004880| 20 20 20 20 20 20 4c 54 | 45 51 20 2d 2d 20 53 65 | LT|EQ -- Se|
|00004890| 61 72 63 68 65 73 20 66 | 6f 72 20 61 20 72 65 63 |arches f|or a rec|
|000048a0| 6f 72 64 20 6c 65 73 73 | 20 61 6c 70 68 61 62 65 |ord less| alphabe|
|000048b0| 74 69 63 61 6c 6c 79 2c | 20 6f 72 20 65 71 75 61 |tically,| or equa|
|000048c0| 6c 20 74 6f 20 28 69 66 | 0a 58 20 20 20 20 20 20 |l to (if|.X |
|000048d0| 20 20 20 20 20 20 20 20 | 20 20 6f 6e 65 20 65 78 | | one ex|
|000048e0| 69 73 74 73 29 2c 20 74 | 68 65 20 63 6f 6d 70 61 |ists), t|he compa|
|000048f0| 72 69 73 6f 6e 2e 20 20 | 49 6e 20 74 68 65 20 65 |rison. |In the e|
|00004900| 76 65 6e 74 20 74 68 61 | 74 20 64 75 70 6c 69 63 |vent tha|t duplic|
|00004910| 61 74 65 73 20 6f 66 0a | 58 20 20 20 20 20 20 20 |ates of.|X |
|00004920| 20 20 20 20 20 20 20 20 | 20 74 68 65 20 72 65 63 | | the rec|
|00004930| 6f 72 64 20 61 62 6f 75 | 74 20 74 6f 20 62 65 20 |ord abou|t to be |
|00004940| 72 65 74 75 72 6e 65 64 | 20 65 78 69 73 74 2c 20 |returned| exist, |
|00004950| 4c 54 45 51 20 72 65 74 | 75 72 6e 73 20 74 68 65 |LTEQ ret|urns the|
|00004960| 20 6c 61 73 74 20 6f 66 | 0a 58 20 20 20 20 20 20 | last of|.X |
|00004970| 20 20 20 20 20 20 20 20 | 20 20 74 68 65 73 65 3a | | these:|
|00004980| 20 61 6c 6c 20 64 75 70 | 6c 69 63 61 74 65 73 20 | all dup|licates |
|00004990| 63 61 6e 20 62 65 20 66 | 6f 75 6e 64 20 62 79 20 |can be f|ound by |
|000049a0| 73 75 62 73 65 71 75 65 | 6e 74 20 22 50 52 45 56 |subseque|nt "PREV|
|000049b0| 49 4f 55 53 22 0a 58 20 | 20 20 20 20 20 20 20 20 |IOUS".X | |
|000049c0| 20 20 20 20 20 20 20 73 | 65 61 72 63 68 65 73 2e | s|earches.|
|000049d0| 0a 58 20 20 20 20 20 20 | 20 20 20 20 20 4c 54 48 |.X | LTH|
|000049e0| 4e 20 28 4c 54 48 41 4e | 29 20 2d 2d 20 53 69 6d |N (LTHAN|) -- Sim|
|000049f0| 69 6c 61 72 20 74 6f 20 | 4c 54 45 51 20 69 6e 20 |ilar to |LTEQ in |
|00004a00| 61 6c 6c 20 62 75 74 20 | 6f 6e 65 20 72 65 67 61 |all but |one rega|
|00004a10| 72 64 3a 20 4c 54 48 41 | 4e 20 77 69 6c 6c 0a 58 |rd: LTHA|N will.X|
|00004a20| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00004a30| 6e 6f 74 20 72 65 74 75 | 72 6e 20 61 20 70 72 65 |not retu|rn a pre|
|00004a40| 63 69 73 65 20 64 75 70 | 6c 69 63 61 74 65 2c 20 |cise dup|licate, |
|00004a50| 69 6e 73 74 65 61 64 20 | 73 65 61 72 63 68 69 6e |instead |searchin|
|00004a60| 67 20 74 6f 20 69 74 73 | 0a 58 20 20 20 20 20 20 |g to its|.X |
|00004a70| 20 20 20 20 20 20 20 20 | 20 20 6c 65 66 74 20 66 | | left f|
|00004a80| 6f 72 20 74 68 65 20 72 | 65 63 6f 72 64 20 62 65 |or the r|ecord be|
|00004a90| 66 6f 72 65 20 69 74 2e | 0a 58 20 20 20 20 20 20 |fore it.|.X |
|00004aa0| 20 20 20 20 20 43 55 52 | 52 20 28 43 55 52 52 45 | CUR|R (CURRE|
|00004ab0| 4e 54 29 20 2d 2d 20 41 | 66 74 65 72 20 61 20 72 |NT) -- A|fter a r|
|00004ac0| 65 63 6f 72 64 20 69 73 | 20 66 6f 75 6e 64 20 62 |ecord is| found b|
|00004ad0| 79 20 61 20 73 65 61 72 | 63 68 2c 20 4d 65 74 61 |y a sear|ch, Meta|
|00004ae0| 6c 42 61 73 65 0a 58 20 | 20 20 20 20 20 20 20 20 |lBase.X | |
|00004af0| 20 20 20 20 20 20 20 72 | 65 6d 65 6d 62 65 72 73 | r|emembers|
|00004b00| 20 74 68 65 20 6c 6f 63 | 61 74 69 6f 6e 20 6f 66 | the loc|ation of|
|00004b10| 20 74 68 65 20 72 65 63 | 6f 72 64 2e 20 20 53 65 | the rec|ord. Se|
|00004b20| 61 72 63 68 69 6e 67 20 | 77 69 74 68 20 74 68 65 |arching |with the|
|00004b30| 0a 58 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |.X | |
|00004b40| 20 20 61 63 74 69 6f 6e | 20 43 55 52 52 45 4e 54 | action| CURRENT|
|00004b50| 20 72 65 2d 72 65 61 64 | 73 20 74 68 69 73 20 6d | re-read|s this m|
|00004b60| 6f 73 74 20 72 65 63 65 | 6e 74 20 72 65 63 6f 72 |ost rece|nt recor|
|00004b70| 64 2c 20 61 6e 64 20 72 | 65 74 75 72 6e 73 0a 58 |d, and r|eturns.X|
|00004b80| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00004b90| 69 74 20 69 6e 20 69 74 | 73 20 65 6e 74 69 72 65 |it in it|s entire|
|00004ba0| 74 79 2e 20 20 41 73 20 | 77 69 74 68 20 46 49 52 |ty. As |with FIR|
|00004bb0| 53 54 2c 20 4c 41 53 54 | 2c 20 4e 45 58 54 20 61 |ST, LAST|, NEXT a|
|00004bc0| 6e 64 20 50 52 45 56 49 | 4f 55 53 2c 0a 58 20 20 |nd PREVI|OUS,.X |
|00004bd0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 74 68 | | th|
|00004be0| 65 20 76 61 6c 75 65 20 | 6f 66 20 22 63 6f 6d 70 |e value |of "comp|
|00004bf0| 61 72 69 73 6f 6e 5f 76 | 61 6c 75 65 22 20 69 73 |arison_v|alue" is|
|00004c00| 20 69 72 72 65 6c 65 76 | 61 6e 74 20 69 6e 20 43 | irrelev|ant in C|
|00004c10| 55 52 52 45 4e 54 20 2d | 2d 0a 58 20 20 20 20 20 |URRENT -|-.X |
|00004c20| 20 20 20 20 20 20 20 20 | 20 20 20 68 6f 77 65 76 | | howev|
|00004c30| 65 72 2c 20 43 55 52 52 | 45 4e 54 20 69 73 20 61 |er, CURR|ENT is a|
|00004c40| 6c 73 6f 20 6f 62 6c 69 | 76 69 6f 75 73 20 74 6f |lso obli|vious to|
|00004c50| 20 69 6e 64 65 78 20 75 | 73 65 64 20 28 41 73 20 | index u|sed (As |
|00004c60| 6e 6f 0a 58 20 20 20 20 | 20 20 20 20 20 20 20 20 |no.X | |
|00004c70| 20 20 20 20 61 63 74 75 | 61 6c 20 73 65 61 72 63 | actu|al searc|
|00004c80| 68 69 6e 67 20 74 61 6b | 65 73 20 70 6c 61 63 65 |hing tak|es place|
|00004c90| 2e 2e 2e 20 4d 65 74 61 | 6c 42 61 73 65 20 6d 65 |... Meta|lBase me|
|00004ca0| 72 65 6c 79 20 72 65 63 | 61 6c 6c 73 20 61 0a 58 |rely rec|alls a.X|
|00004cb0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00004cc0| 6b 6e 6f 77 6e 20 72 65 | 63 6f 72 64 29 2e 0a 58 |known re|cord)..X|
|00004cd0| 20 20 20 20 20 20 20 20 | 50 6c 65 61 73 65 20 6e | |Please n|
|00004ce0| 6f 74 65 20 74 68 61 74 | 20 74 68 65 20 61 62 6f |ote that| the abo|
|00004cf0| 76 65 2d 64 65 73 63 72 | 69 62 65 64 20 61 63 74 |ve-descr|ibed act|
|00004d00| 69 6f 6e 20 6e 61 6d 65 | 73 20 6d 65 72 65 6c 79 |ion name|s merely|
|00004d10| 20 73 74 61 6e 64 20 66 | 6f 72 0a 58 20 20 20 20 | stand f|or.X |
|00004d20| 20 20 20 20 69 6e 74 65 | 67 65 72 73 2c 20 61 6e | inte|gers, an|
|00004d30| 64 20 4d 65 74 61 6c 42 | 61 73 65 20 77 69 6c 6c |d MetalB|ase will|
|00004d40| 20 6e 6f 74 20 75 6e 64 | 65 72 73 74 61 6e 64 20 | not und|erstand |
|00004d50| 69 66 20 79 6f 75 20 75 | 73 65 20 71 75 6f 74 65 |if you u|se quote|
|00004d60| 73 20 61 72 6f 75 6e 64 | 0a 58 20 20 20 20 20 20 |s around|.X |
|00004d70| 20 20 74 68 65 20 6e 61 | 6d 65 73 2e 20 20 54 68 | the na|mes. Th|
|00004d80| 65 73 65 20 61 63 74 69 | 6f 6e 73 20 6d 75 73 74 |ese acti|ons must|
|00004d90| 20 61 6c 73 6f 20 62 65 | 20 77 72 69 74 74 65 6e | also be| written|
|00004da0| 20 69 6e 20 75 70 70 65 | 72 2d 63 61 73 65 2e 0a | in uppe|r-case..|
|00004db0| 58 20 20 20 20 20 20 20 | 20 22 63 6f 6d 70 61 72 |X | "compar|
|00004dc0| 69 73 6f 6e 5f 62 75 66 | 66 65 72 22 20 69 73 20 |ison_buf|fer" is |
|00004dd0| 61 20 73 74 72 75 63 74 | 75 72 65 20 69 64 65 6e |a struct|ure iden|
|00004de0| 74 69 63 61 6c 20 74 6f | 20 22 62 75 66 66 65 72 |tical to| "buffer|
|00004df0| 22 2c 20 62 75 74 20 61 | 6e 79 0a 58 20 20 20 20 |", but a|ny.X |
|00004e00| 20 20 20 20 64 61 74 61 | 20 69 6e 20 61 6e 79 20 | data| in any |
|00004e10| 6f 66 20 74 68 65 20 66 | 69 65 6c 64 73 20 69 73 |of the f|ields is|
|00004e20| 20 75 73 65 64 20 66 6f | 72 20 63 6f 6d 70 61 72 | used fo|r compar|
|00004e30| 69 73 6f 6e 20 77 68 65 | 6e 20 73 65 61 72 63 68 |ison whe|n search|
|00004e40| 69 6e 67 20 66 6f 72 0a | 58 20 20 20 20 20 20 20 |ing for.|X |
|00004e50| 20 45 51 55 41 4c 2c 20 | 47 54 45 51 2c 20 4c 54 | EQUAL, |GTEQ, LT|
|00004e60| 45 51 2c 20 47 54 48 41 | 4e 20 6f 72 20 4c 54 48 |EQ, GTHA|N or LTH|
|00004e70| 41 4e 2e 20 20 54 68 65 | 72 65 20 61 72 65 20 74 |AN. The|re are t|
|00004e80| 68 72 65 65 20 77 61 79 | 73 20 74 6f 20 75 73 65 |hree way|s to use|
|00004e90| 20 74 68 61 74 2d 2d 0a | 58 20 20 20 20 20 20 20 | that--.|X |
|00004ea0| 20 67 69 76 65 20 69 74 | 20 61 20 6e 65 77 20 72 | give it| a new r|
|00004eb0| 65 63 6f 72 64 2e 2e 2e | 0a 58 20 20 20 20 20 20 |ecord...|.X |
|00004ec0| 20 20 20 20 20 20 73 61 | 6d 70 6c 65 5f 73 74 72 | sa|mple_str|
|00004ed0| 20 20 20 73 61 6d 70 6c | 65 5f 72 65 63 2c 20 74 | sampl|e_rec, t|
|00004ee0| 61 72 67 65 74 5f 72 65 | 63 3b 0a 58 20 20 20 20 |arget_re|c;.X |
|00004ef0| 20 20 20 20 20 20 20 20 | 74 61 72 67 65 74 5f 72 | |target_r|
|00004f00| 65 63 2e 6e 75 6d 20 3d | 20 31 35 3b 0a 58 20 20 |ec.num =| 15;.X |
|00004f10| 20 20 20 20 20 20 20 20 | 20 20 6d 62 5f 73 65 6c | | mb_sel|
|00004f20| 20 28 72 65 6c 2c 20 69 | 64 78 6e 75 6d 28 22 69 | (rel, i|dxnum("i|
|00004f30| 78 5f 6e 75 6d 22 29 2c | 20 26 73 61 6d 70 6c 65 |x_num"),| &sample|
|00004f40| 5f 72 65 63 2c 20 45 51 | 55 41 4c 2c 20 26 74 61 |_rec, EQ|UAL, &ta|
|00004f50| 72 67 65 74 5f 72 65 63 | 29 0a 58 20 20 20 20 20 |rget_rec|).X |
|00004f60| 20 20 20 6f 72 2c 20 74 | 68 65 20 73 61 6d 65 20 | or, t|he same |
|00004f70| 6f 6e 65 20 74 77 69 63 | 65 2e 2e 2e 0a 58 20 20 |one twic|e....X |
|00004f80| 20 20 20 20 20 20 20 20 | 20 20 73 61 6d 70 6c 65 | | sample|
|00004f90| 5f 73 74 72 20 20 20 73 | 61 6d 70 6c 65 5f 72 65 |_str s|ample_re|
|00004fa0| 63 3b 0a 58 20 20 20 20 | 20 20 20 20 20 20 20 20 |c;.X | |
|00004fb0| 73 61 6d 70 6c 65 5f 72 | 65 63 2e 6e 75 6d 20 3d |sample_r|ec.num =|
|00004fc0| 20 31 35 3b 0a 58 20 20 | 20 20 20 20 20 20 20 20 | 15;.X | |
|00004fd0| 20 20 6d 62 5f 73 65 6c | 20 28 72 65 6c 2c 20 69 | mb_sel| (rel, i|
|00004fe0| 64 78 6e 75 6d 28 22 69 | 78 5f 6e 75 6d 22 29 2c |dxnum("i|x_num"),|
|00004ff0| 20 26 73 61 6d 70 6c 65 | 5f 72 65 63 2c 20 45 51 | &sample|_rec, EQ|
|00005000| 55 41 4c 2c 20 26 73 61 | 6d 70 6c 65 5f 72 65 63 |UAL, &sa|mple_rec|
|00005010| 29 0a 58 20 20 20 20 20 | 20 20 20 6f 72 2c 20 77 |).X | or, w|
|00005020| 68 61 74 20 49 20 64 6f | 20 6d 6f 73 74 2c 20 70 |hat I do| most, p|
|00005030| 61 73 73 20 69 6e 20 4e | 55 4c 4c 20 61 73 20 74 |ass in N|ULL as t|
|00005040| 68 65 20 63 6f 6d 70 61 | 72 69 73 6f 6e 20 28 77 |he compa|rison (w|
|00005050| 6f 72 6b 73 20 6a 75 73 | 74 20 6c 69 6b 65 0a 58 |orks jus|t like.X|
|00005060| 20 20 20 20 20 20 20 20 | 74 68 65 20 6f 6e 65 20 | |the one |
|00005070| 61 62 6f 76 65 29 3a 0a | 58 20 20 20 20 20 20 20 |above):.|X |
|00005080| 20 20 20 20 20 73 61 6d | 70 6c 65 5f 73 74 72 20 | sam|ple_str |
|00005090| 20 20 73 61 6d 70 6c 65 | 5f 72 65 63 3b 0a 58 20 | sample|_rec;.X |
|000050a0| 20 20 20 20 20 20 20 20 | 20 20 20 73 61 6d 70 6c | | sampl|
|000050b0| 65 5f 72 65 63 2e 6e 75 | 6d 20 3d 20 31 35 3b 0a |e_rec.nu|m = 15;.|
|000050c0| 58 20 20 20 20 20 20 20 | 20 20 20 20 20 6d 62 5f |X | mb_|
|000050d0| 73 65 6c 20 28 72 65 6c | 2c 20 69 64 78 6e 75 6d |sel (rel|, idxnum|
|000050e0| 28 22 69 78 5f 6e 75 6d | 22 29 2c 20 26 73 61 6d |("ix_num|"), &sam|
|000050f0| 70 6c 65 5f 72 65 63 2c | 20 45 51 55 41 4c 2c 20 |ple_rec,| EQUAL, |
|00005100| 4e 55 4c 4c 29 0a 58 20 | 20 20 20 20 20 20 20 41 |NULL).X | A|
|00005110| 6c 6c 20 74 68 72 65 65 | 20 6f 66 20 74 68 65 73 |ll three| of thes|
|00005120| 65 20 77 6f 75 6c 64 20 | 68 61 76 65 20 74 68 65 |e would |have the|
|00005130| 20 73 61 6d 65 20 65 66 | 66 65 63 74 2e 0a 58 0a | same ef|fect..X.|
|00005140| 58 20 2d 20 6d 62 5f 75 | 70 64 20 28 66 69 6c 65 |X - mb_u|pd (file|
|00005150| 2c 20 6e 65 77 5f 72 65 | 63 29 20 2d 2d 20 41 66 |, new_re|c) -- Af|
|00005160| 74 65 72 20 61 20 72 65 | 63 6f 72 64 20 69 73 20 |ter a re|cord is |
|00005170| 66 6f 75 6e 64 2c 20 69 | 74 20 6d 61 79 20 62 65 |found, i|t may be|
|00005180| 20 75 70 64 61 74 65 64 | 0a 58 20 20 20 20 20 20 | updated|.X |
|00005190| 20 20 74 68 72 6f 75 67 | 68 20 6d 62 5f 75 70 64 | throug|h mb_upd|
|000051a0| 2e 20 20 4d 65 74 61 6c | 42 61 73 65 20 73 69 6d |. Metal|Base sim|
|000051b0| 70 6c 79 20 72 65 70 6c | 61 63 65 73 20 74 68 65 |ply repl|aces the|
|000051c0| 20 6f 6c 64 20 72 65 63 | 6f 72 64 27 73 20 66 69 | old rec|ord's fi|
|000051d0| 65 6c 64 73 20 77 69 74 | 68 0a 58 20 20 20 20 20 |elds wit|h.X |
|000051e0| 20 20 20 74 68 6f 73 65 | 20 69 6e 64 69 63 61 74 | those| indicat|
|000051f0| 65 64 20 69 6e 20 22 6e | 65 77 5f 72 65 63 22 2e |ed in "n|ew_rec".|
|00005200| 20 20 54 68 69 73 20 70 | 72 6f 63 65 73 73 20 75 | This p|rocess u|
|00005210| 73 75 61 6c 6c 79 20 72 | 65 71 75 69 72 65 73 20 |sually r|equires |
|00005220| 6d 6f 72 65 20 74 69 6d | 65 0a 58 20 20 20 20 20 |more tim|e.X |
|00005230| 20 20 20 74 68 61 6e 20 | 61 6e 79 20 6f 74 68 65 | than |any othe|
|00005240| 72 2c 20 61 73 20 74 68 | 65 20 72 65 63 6f 72 64 |r, as th|e record|
|00005250| 20 6d 75 73 74 20 62 65 | 20 64 69 73 63 6f 6e 6e | must be| disconn|
|00005260| 65 63 74 65 64 20 66 72 | 6f 6d 20 65 61 63 68 20 |ected fr|om each |
|00005270| 69 6e 64 65 78 20 69 6e | 0a 58 20 20 20 20 20 20 |index in|.X |
|00005280| 20 20 74 75 72 6e 2c 20 | 63 68 61 6e 67 65 64 2c | turn, |changed,|
|00005290| 20 61 6e 64 20 72 65 63 | 6f 6e 6e 65 63 74 65 64 | and rec|onnected|
|000052a0| 2e 20 20 4f 63 63 61 73 | 69 6f 6e 61 6c 6c 79 2c |. Occas|ionally,|
|000052b0| 20 63 68 61 6e 67 69 6e | 67 20 61 20 72 65 63 6f | changin|g a reco|
|000052c0| 72 64 20 77 69 6c 6c 0a | 58 20 20 20 20 20 20 20 |rd will.|X |
|000052d0| 20 6e 6f 74 20 63 68 61 | 6e 67 65 20 63 65 72 74 | not cha|nge cert|
|000052e0| 61 69 6e 20 69 6e 64 69 | 63 65 73 2d 2d 77 68 65 |ain indi|ces--whe|
|000052f0| 6e 20 74 68 69 73 20 6f | 63 63 75 72 73 2c 20 74 |n this o|ccurs, t|
|00005300| 68 65 20 69 6e 64 65 78 | 20 69 73 20 73 69 6d 70 |he index| is simp|
|00005310| 6c 79 0a 58 20 20 20 20 | 20 20 20 20 73 6b 69 70 |ly.X | skip|
|00005320| 70 65 64 2e 20 20 41 6e | 20 75 70 64 61 74 65 2c |ped. An| update,|
|00005330| 20 6c 69 6b 65 20 61 6e | 20 61 64 64 2c 20 77 69 | like an| add, wi|
|00005340| 6c 6c 20 62 65 20 61 62 | 6f 72 74 65 64 20 69 66 |ll be ab|orted if|
|00005350| 20 74 68 65 20 63 68 61 | 6e 67 65 73 20 77 6f 75 | the cha|nges wou|
|00005360| 6c 64 0a 58 20 20 20 20 | 20 20 20 20 76 69 6f 6c |ld.X | viol|
|00005370| 61 74 65 20 61 20 6e 6f | 2d 64 75 70 6c 69 63 61 |ate a no|-duplica|
|00005380| 74 65 73 2d 61 6c 6c 6f | 77 65 64 20 69 6e 64 65 |tes-allo|wed inde|
|00005390| 78 2e 0a 58 0a 58 20 2d | 20 6d 62 5f 64 65 6c 20 |x..X.X -| mb_del |
|000053a0| 28 66 69 6c 65 29 20 2d | 2d 20 41 66 74 65 72 20 |(file) -|- After |
|000053b0| 61 20 72 65 63 6f 72 64 | 20 69 73 20 66 6f 75 6e |a record| is foun|
|000053c0| 64 2c 20 69 74 20 6d 61 | 79 20 62 65 20 72 65 6d |d, it ma|y be rem|
|000053d0| 6f 76 65 64 20 63 6f 6d | 70 6c 65 74 65 6c 79 20 |oved com|pletely |
|000053e0| 62 79 0a 58 20 20 20 20 | 20 20 20 20 75 73 65 20 |by.X | use |
|000053f0| 6f 66 20 6d 62 5f 64 65 | 6c 2e 20 20 4f 6e 63 65 |of mb_de|l. Once|
|00005400| 20 61 20 72 65 63 6f 72 | 64 20 69 73 20 64 65 6c | a recor|d is del|
|00005410| 65 74 65 64 20 74 68 75 | 73 2c 20 69 74 20 43 41 |eted thu|s, it CA|
|00005420| 4e 4e 4f 54 20 62 65 20 | 72 65 74 72 69 65 76 65 |NNOT be |retrieve|
|00005430| 64 2e 0a 58 20 20 20 20 | 20 20 20 20 50 72 65 2d |d..X | Pre-|
|00005440| 35 2e 30 20 76 65 72 73 | 69 6f 6e 73 20 6f 66 20 |5.0 vers|ions of |
|00005450| 4d 65 74 61 6c 42 61 73 | 65 20 75 73 65 64 20 61 |MetalBas|e used a|
|00005460| 20 73 65 63 6f 6e 64 20 | 61 72 67 75 6d 65 6e 74 | second |argument|
|00005470| 20 66 6f 72 20 74 72 61 | 63 6b 69 6e 67 20 74 68 | for tra|cking th|
|00005480| 65 0a 58 20 20 20 20 20 | 20 20 20 63 75 72 72 65 |e.X | curre|
|00005490| 6e 74 20 70 6f 69 6e 74 | 65 72 3b 20 74 68 69 73 |nt point|er; this|
|000054a0| 20 63 6f 64 65 20 77 61 | 73 20 62 72 6f 6b 65 6e | code wa|s broken|
|000054b0| 20 61 6e 64 20 49 20 72 | 65 6d 6f 76 65 64 20 69 | and I r|emoved i|
|000054c0| 74 2e 20 20 3a 29 20 20 | 53 6f 20 6e 6f 77 0a 58 |t. :) |So now.X|
|000054d0| 20 20 20 20 20 20 20 20 | 74 68 65 72 65 27 73 20 | |there's |
|000054e0| 6e 6f 20 73 65 63 6f 6e | 64 20 61 72 67 75 6d 65 |no secon|d argume|
|000054f0| 6e 74 2d 2d 61 67 61 69 | 6e 2c 20 73 6f 72 72 79 |nt--agai|n, sorry|
|00005500| 20 66 6f 72 20 63 68 61 | 6e 67 69 6e 67 20 74 68 | for cha|nging th|
|00005510| 69 6e 67 73 20 6f 6e 20 | 79 61 2e 0a 58 0a 58 20 |ings on |ya..X.X |
|00005520| 2d 20 6d 62 5f 61 64 64 | 20 28 66 69 6c 65 2c 20 |- mb_add| (file, |
|00005530| 6e 65 77 5f 72 65 63 29 | 20 2d 2d 20 54 68 69 73 |new_rec)| -- This|
|00005540| 20 63 6f 6d 6d 61 6e 64 | 20 61 64 64 73 20 61 20 | command| adds a |
|00005550| 6e 65 77 20 72 65 63 6f | 72 64 20 74 6f 20 61 20 |new reco|rd to a |
|00005560| 72 65 6c 61 74 69 6f 6e | 2e 20 20 49 66 0a 58 20 |relation|. If.X |
|00005570| 20 20 20 20 20 20 20 61 | 64 64 69 6e 67 20 74 68 | a|dding th|
|00005580| 65 20 72 65 63 6f 72 64 | 20 64 65 73 63 72 69 62 |e record| describ|
|00005590| 65 64 20 62 79 20 22 6e | 65 77 5f 72 65 63 22 20 |ed by "n|ew_rec" |
|000055a0| 77 6f 75 6c 64 20 76 69 | 6f 6c 61 74 65 20 61 20 |would vi|olate a |
|000055b0| 6e 6f 6e 2d 64 75 70 6c | 69 63 61 74 65 0a 58 20 |non-dupl|icate.X |
|000055c0| 20 20 20 20 20 20 20 69 | 6e 64 65 78 2c 20 74 68 | i|ndex, th|
|000055d0| 65 20 61 64 64 69 74 69 | 6f 6e 20 74 6f 20 74 68 |e additi|on to th|
|000055e0| 65 20 72 65 6c 61 74 69 | 6f 6e 20 77 69 6c 6c 20 |e relati|on will |
|000055f0| 62 65 20 61 62 6f 72 74 | 65 64 20 61 6e 64 20 61 |be abort|ed and a|
|00005600| 6e 20 65 72 72 6f 72 0a | 58 20 20 20 20 20 20 20 |n error.|X |
|00005610| 20 72 65 74 75 72 6e 65 | 64 20 28 53 65 65 20 74 | returne|d (See t|
|00005620| 68 65 20 73 65 63 74 69 | 6f 6e 20 6f 6e 20 45 72 |he secti|on on Er|
|00005630| 72 6f 72 73 2c 20 62 65 | 6c 6f 77 29 2e 0a 58 0a |rors, be|low)..X.|
|00005640| 58 20 2d 20 6d 62 5f 6c | 63 6b 20 28 66 69 6c 65 |X - mb_l|ck (file|
|00005650| 29 20 2d 2d 20 49 66 2c | 20 61 73 20 61 6e 20 65 |) -- If,| as an e|
|00005660| 78 61 6d 70 6c 65 2c 20 | 61 20 70 72 6f 67 72 61 |xample, |a progra|
|00005670| 6d 20 72 65 61 64 73 20 | 61 20 72 65 63 6f 72 64 |m reads |a record|
|00005680| 20 66 72 6f 6d 20 61 20 | 72 65 6c 61 74 69 6f 6e | from a |relation|
|00005690| 0a 58 20 20 20 20 20 20 | 20 20 75 73 65 64 20 62 |.X | used b|
|000056a0| 79 20 6d 61 6e 79 20 74 | 65 72 6d 69 6e 61 6c 73 |y many t|erminals|
|000056b0| 20 73 69 6d 75 6c 61 6e | 65 6f 75 73 6c 79 2c 20 | simulan|eously, |
|000056c0| 77 61 69 74 73 20 66 6f | 72 20 61 20 75 73 65 72 |waits fo|r a user|
|000056d0| 20 74 6f 20 65 6e 74 65 | 72 20 61 20 6e 65 77 0a | to ente|r a new.|
|000056e0| 58 20 20 20 20 20 20 20 | 20 76 61 6c 75 65 20 66 |X | value f|
|000056f0| 6f 72 20 6f 6e 65 20 6f | 66 20 69 74 73 20 66 69 |or one o|f its fi|
|00005700| 65 6c 64 73 2c 20 61 6e | 64 20 75 70 64 61 74 65 |elds, an|d update|
|00005710| 73 20 74 68 65 20 72 65 | 63 6f 72 64 2c 20 69 74 |s the re|cord, it|
|00005720| 20 63 6f 75 6c 64 20 70 | 72 6f 76 65 0a 58 20 20 | could p|rove.X |
|00005730| 20 20 20 20 20 20 64 69 | 73 61 73 74 72 6f 75 73 | di|sastrous|
|00005740| 20 69 66 20 74 68 65 20 | 72 65 63 6f 72 64 20 77 | if the |record w|
|00005750| 61 73 20 72 65 61 64 20 | 62 79 20 6f 6e 65 20 74 |as read |by one t|
|00005760| 65 72 6d 69 6e 61 6c 2c | 20 74 68 65 6e 20 61 6e |erminal,| then an|
|00005770| 6f 74 68 65 72 2e 2e 2e | 0a 58 20 20 20 20 20 20 |other...|.X |
|00005780| 20 20 75 70 64 61 74 65 | 64 20 6f 6e 20 6f 6e 65 | update|d on one|
|00005790| 20 26 20 72 65 2d 77 72 | 69 74 74 65 6e 2c 20 61 | & re-wr|itten, a|
|000057a0| 6e 64 20 72 65 2d 75 70 | 64 61 74 65 64 20 62 79 |nd re-up|dated by|
|000057b0| 20 74 68 65 20 73 65 63 | 6f 6e 64 20 74 65 72 6d | the sec|ond term|
|000057c0| 69 6e 61 6c 2e 20 20 54 | 6f 0a 58 20 20 20 20 20 |inal. T|o.X |
|000057d0| 20 20 20 70 72 65 76 65 | 6e 74 20 74 68 69 73 20 | preve|nt this |
|000057e0| 74 79 70 65 20 6f 66 20 | 73 63 65 6e 61 72 69 6f |type of |scenario|
|000057f0| 2c 20 6d 62 5f 6c 63 6b | 2c 20 77 68 65 6e 20 75 |, mb_lck|, when u|
|00005800| 73 65 64 2c 20 65 78 63 | 6c 75 64 65 73 20 6f 74 |sed, exc|ludes ot|
|00005810| 68 65 72 20 75 73 65 72 | 73 0a 58 20 20 20 20 20 |her user|s.X |
|00005820| 20 20 20 66 72 6f 6d 20 | 72 65 61 64 69 6e 67 20 | from |reading |
|00005830| 6f 72 20 77 72 69 74 69 | 6e 67 20 74 6f 20 61 20 |or writi|ng to a |
|00005840| 72 65 6c 61 74 69 6f 6e | 2e 20 20 45 76 65 72 79 |relation|. Every|
|00005850| 20 6f 70 65 72 61 74 69 | 6f 6e 20 74 68 65 79 20 | operati|on they |
|00005860| 74 72 79 0a 58 20 20 20 | 20 20 20 20 20 28 69 6e |try.X | (in|
|00005870| 63 6c 75 64 69 6e 67 20 | 6d 62 5f 69 6e 63 28 29 |cluding |mb_inc()|
|00005880| 29 20 77 69 6c 6c 20 72 | 65 74 75 72 6e 20 4d 42 |) will r|eturn MB|
|00005890| 5f 4c 4f 43 4b 45 44 20 | 75 6e 74 69 6c 20 74 68 |_LOCKED |until th|
|000058a0| 65 20 70 72 6f 63 65 73 | 73 20 77 68 69 63 68 0a |e proces|s which.|
|000058b0| 58 20 20 20 20 20 20 20 | 20 63 61 6c 6c 65 64 20 |X | called |
|000058c0| 6d 62 5f 6c 63 6b 28 29 | 20 63 61 6c 6c 73 20 6d |mb_lck()| calls m|
|000058d0| 62 5f 75 6e 6c 28 29 2e | 0a 58 0a 58 20 2d 20 6d |b_unl().|.X.X - m|
|000058e0| 62 5f 75 6e 6c 20 28 66 | 69 6c 65 29 20 2d 2d 20 |b_unl (f|ile) -- |
|000058f0| 52 65 6d 6f 76 65 73 20 | 61 20 6c 6f 63 6b 20 70 |Removes |a lock p|
|00005900| 6c 61 63 65 64 20 6f 6e | 20 61 20 72 65 6c 61 74 |laced on| a relat|
|00005910| 69 6f 6e 20 62 79 20 6d | 76 5f 6c 63 6b 2e 0a 58 |ion by m|v_lck..X|
|00005920| 0a 58 20 2d 20 6d 62 5f | 72 6d 76 20 28 66 69 6c |.X - mb_|rmv (fil|
|00005930| 65 29 20 2d 2d 20 54 68 | 69 73 20 63 6f 6d 6d 61 |e) -- Th|is comma|
|00005940| 6e 64 20 72 65 6d 6f 76 | 65 73 20 61 20 72 65 6c |nd remov|es a rel|
|00005950| 61 74 69 6f 6e 20 66 72 | 6f 6d 20 79 6f 75 72 20 |ation fr|om your |
|00005960| 64 65 73 6b 74 6f 70 2e | 20 20 49 66 20 74 68 65 |desktop.| If the|
|00005970| 0a 58 20 20 20 20 20 20 | 20 20 66 69 6c 65 20 68 |.X | file h|
|00005980| 61 73 20 62 65 65 6e 20 | 6c 6f 63 6b 65 64 20 70 |as been |locked p|
|00005990| 72 65 76 69 6f 75 73 6c | 79 20 28 76 69 61 20 6d |reviousl|y (via m|
|000059a0| 62 5f 6c 63 6b 29 2c 20 | 74 68 65 20 6c 6f 63 6b |b_lck), |the lock|
|000059b0| 20 69 73 20 72 65 6d 6f | 76 65 64 2e 0a 58 0a 58 | is remo|ved..X.X|
|000059c0| 20 2d 20 6d 62 5f 64 69 | 65 20 28 29 20 2d 2d 20 | - mb_di|e () -- |
|000059d0| 54 68 69 73 20 63 6f 6d | 6d 61 6e 64 20 72 65 6d |This com|mand rem|
|000059e0| 6f 76 65 73 20 61 6c 6c | 20 6f 70 65 6e 20 72 65 |oves all| open re|
|000059f0| 6c 61 74 69 6f 6e 73 20 | 66 72 6f 6d 20 79 6f 75 |lations |from you|
|00005a00| 72 20 64 65 73 6b 74 6f | 70 2c 20 61 73 0a 58 20 |r deskto|p, as.X |
|00005a10| 20 20 20 20 20 20 20 69 | 66 20 79 6f 75 27 64 20 | i|f you'd |
|00005a20| 63 61 6c 6c 65 64 20 65 | 61 63 68 20 6f 6e 65 20 |called e|ach one |
|00005a30| 69 6e 20 74 75 72 6e 20 | 77 69 74 68 20 6d 62 5f |in turn |with mb_|
|00005a40| 72 6d 76 28 66 69 6c 65 | 29 2e 0a 58 0a 58 20 2d |rmv(file|)..X.X -|
|00005a50| 20 6d 62 5f 65 78 69 74 | 20 28 72 65 74 5f 63 6f | mb_exit| (ret_co|
|00005a60| 64 65 29 20 2d 2d 20 43 | 61 6c 6c 73 20 6d 62 5f |de) -- C|alls mb_|
|00005a70| 64 69 65 28 29 2c 20 66 | 6f 6c 6c 6f 77 65 64 20 |die(), f|ollowed |
|00005a80| 62 79 20 65 78 69 74 28 | 72 65 74 5f 63 6f 64 65 |by exit(|ret_code|
|00005a90| 29 2e 0a 58 0a 58 20 2d | 20 6d 62 5f 6e 75 6d 20 |)..X.X -| mb_num |
|00005aa0| 28 66 69 6c 65 29 20 2d | 2d 20 52 65 74 75 72 6e |(file) -|- Return|
|00005ab0| 73 20 74 68 65 20 6e 75 | 6d 62 65 72 20 6f 66 20 |s the nu|mber of |
|00005ac0| 72 65 63 6f 72 64 73 20 | 69 6e 20 61 20 72 65 6c |records |in a rel|
|00005ad0| 61 74 69 6f 6e 2e 20 20 | 57 68 65 65 65 65 2e 2e |ation. |Wheeee..|
|00005ae0| 2e 0a 58 0a 58 0a 58 45 | 52 52 4f 52 53 5f 5f 5f |..X.X.XE|RRORS___|
|00005af0| 5f 5f 5f 5f 5f 5f 5f 5f | 5f 5f 5f 5f 5f 5f 5f 5f |________|________|
|00005b00| 5f 5f 5f 5f 5f 5f 5f 5f | 5f 5f 5f 5f 5f 5f 5f 5f |________|________|
|00005b10| 5f 5f 5f 5f 5f 5f 5f 5f | 5f 5f 5f 5f 5f 5f 5f 5f |________|________|
|00005b20| 5f 5f 5f 5f 5f 5f 5f 5f | 5f 5f 5f 5f 5f 5f 5f 5f |________|________|
|00005b30| 5f 5f 5f 5f 5f 5f 0a 58 | 0a 58 49 6e 20 61 64 64 |______.X|.XIn add|
|00005b40| 69 74 69 6f 6e 2c 20 73 | 65 65 20 74 68 65 20 73 |ition, s|ee the s|
|00005b50| 65 70 61 72 61 74 65 20 | 64 6f 63 75 6d 65 6e 74 |eparate |document|
|00005b60| 61 74 69 6f 6e 20 6f 6e | 20 74 72 6f 75 62 6c 65 |ation on| trouble|
|00005b70| 73 68 6f 6f 74 69 6e 67 | 2c 20 75 6e 64 65 72 20 |shooting|, under |
|00005b80| 74 68 65 20 6e 61 6d 65 | 0a 58 74 72 6f 75 62 6c |the name|.Xtroubl|
|00005b90| 65 2e 64 6f 78 2e 20 20 | 54 68 65 72 65 27 73 20 |e.dox. |There's |
|00005ba0| 6e 6f 74 20 6d 75 63 68 | 2c 20 62 75 74 20 49 20 |not much|, but I |
|00005bb0| 74 72 69 65 64 2e 2e 2e | 0a 58 0a 58 42 75 69 6c |tried...|.X.XBuil|
|00005bc0| 64 20 2f 20 45 72 72 6f | 72 73 20 3a 0a 58 0a 58 |d / Erro|rs :.X.X|
|00005bd0| 20 20 20 20 20 20 43 61 | 6e 6e 6f 74 20 6f 70 65 | Ca|nnot ope|
|00005be0| 6e 20 3c 66 69 6c 65 2e | 73 3e 2e 2e 2e 2e 2e 2e |n <file.|s>......|
|00005bf0| 2e 2e 2e 2e 2e 2e 54 68 | 65 20 73 63 68 65 6d 61 |......Th|e schema|
|00005c00| 20 69 6e 64 69 63 61 74 | 65 64 20 74 6f 20 42 75 | indicat|ed to Bu|
|00005c10| 69 6c 64 20 63 61 6e 6e | 6f 74 0a 58 20 20 20 20 |ild cann|ot.X |
|00005c20| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00005c30| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00005c40| 20 20 20 20 62 65 20 66 | 6f 75 6e 64 2e 0a 58 20 | be f|ound..X |
|00005c50| 20 20 20 20 20 46 69 6c | 65 20 3c 66 69 6c 65 2e | Fil|e <file.|
|00005c60| 73 3e 20 68 6f 6c 64 73 | 20 6e 6f 20 73 63 68 65 |s> holds| no sche|
|00005c70| 6d 61 2e 2e 2e 54 68 65 | 20 73 63 68 65 6d 61 20 |ma...The| schema |
|00005c80| 69 6e 64 69 63 61 74 65 | 64 20 63 61 6e 6e 6f 74 |indicate|d cannot|
|00005c90| 20 62 65 20 75 73 65 64 | 0a 58 20 20 20 20 20 20 | be used|.X |
|00005ca0| 20 20 64 65 66 69 6e 69 | 74 69 6f 6e 20 20 20 20 | defini|tion |
|00005cb0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00005cc0| 20 20 61 73 20 61 20 64 | 65 66 69 6e 69 74 69 6f | as a d|efinitio|
|00005cd0| 6e 20 6f 66 20 61 20 72 | 65 6c 61 74 69 6f 6e 2e |n of a r|elation.|
|00005ce0| 20 20 54 68 65 0a 58 20 | 20 20 20 20 20 20 20 20 | The.X | |
|00005cf0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00005d00| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 6d | | m|
|00005d10| 6f 73 74 20 6c 69 6b 65 | 6c 79 20 63 61 75 73 65 |ost like|ly cause|
|00005d20| 20 69 73 20 74 68 61 74 | 20 74 68 65 20 66 69 6c | is that| the fil|
|00005d30| 65 20 69 73 0a 58 20 20 | 20 20 20 20 20 20 20 20 |e is.X | |
|00005d40| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00005d50| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 65 6d | | em|
|00005d60| 70 74 79 2e 0a 58 20 20 | 20 20 20 20 46 69 65 6c |pty..X | Fiel|
|00005d70| 64 20 3c 66 69 65 6c 64 | 3e 20 64 65 63 6c 61 72 |d <field|> declar|
|00005d80| 65 64 20 61 66 74 65 72 | 2e 2e 2e 2e 41 6c 6c 20 |ed after|....All |
|00005d90| 66 69 65 6c 64 73 20 6d | 75 73 74 20 62 65 20 64 |fields m|ust be d|
|00005da0| 65 63 6c 61 72 65 64 20 | 62 65 66 6f 72 65 20 61 |eclared |before a|
|00005db0| 6e 79 0a 58 20 20 20 20 | 20 20 20 20 69 6e 64 69 |ny.X | indi|
|00005dc0| 63 65 73 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |ces | |
|00005dd0| 20 20 20 20 20 20 20 20 | 20 20 20 69 6e 64 69 63 | | indic|
|00005de0| 65 73 20 61 72 65 20 64 | 65 63 6c 61 72 65 64 2e |es are d|eclared.|
|00005df0| 0a 58 20 20 20 20 20 20 | 46 69 65 6c 64 20 3c 66 |.X |Field <f|
|00005e00| 69 65 6c 64 3e 20 64 65 | 63 6c 61 72 65 64 20 74 |ield> de|clared t|
|00005e10| 77 69 63 65 2e 2e 2e 2e | 46 69 65 6c 64 20 6e 61 |wice....|Field na|
|00005e20| 6d 65 73 20 6d 75 73 74 | 20 62 65 20 75 6e 69 71 |mes must| be uniq|
|00005e30| 75 65 2e 20 20 53 70 61 | 63 65 73 20 61 72 65 0a |ue. Spa|ces are.|
|00005e40| 58 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |X | |
|00005e50| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00005e60| 20 20 20 20 20 20 20 20 | 20 6e 6f 74 20 61 6c 6c | | not all|
|00005e70| 6f 77 65 64 20 69 6e 20 | 66 69 65 6c 64 20 6e 61 |owed in |field na|
|00005e80| 6d 65 73 2e 0a 58 20 20 | 20 20 20 20 4e 6f 20 66 |mes..X | No f|
|00005e90| 69 65 6c 64 73 20 64 65 | 63 6c 61 72 65 64 20 62 |ields de|clared b|
|00005ea0| 65 66 6f 72 65 2e 2e 2e | 2e 2e 2e 2e 41 20 72 65 |efore...|....A re|
|00005eb0| 6c 61 74 69 6f 6e 20 6d | 75 73 74 20 63 6f 6e 74 |lation m|ust cont|
|00005ec0| 61 69 6e 20 66 69 65 6c | 64 73 2c 20 61 6e 64 20 |ain fiel|ds, and |
|00005ed0| 74 68 65 73 65 0a 58 20 | 20 20 20 20 20 20 20 65 |these.X | e|
|00005ee0| 6e 64 20 72 65 61 63 68 | 65 64 20 20 20 20 20 20 |nd reach|ed |
|00005ef0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 6d | | m|
|00005f00| 75 73 74 20 62 65 20 64 | 65 63 6c 61 72 65 64 20 |ust be d|eclared |
|00005f10| 62 65 66 6f 72 65 20 61 | 6e 79 20 69 6e 64 69 63 |before a|ny indic|
|00005f20| 65 73 2e 0a 58 20 20 20 | 20 20 20 49 6e 63 6f 72 |es..X | Incor|
|00005f30| 72 65 63 74 20 73 79 6e | 74 61 78 2e 2e 2e 2e 2e |rect syn|tax.....|
|00005f40| 2e 2e 2e 2e 2e 2e 2e 2e | 2e 2e 2e 54 68 65 20 64 |........|...The d|
|00005f50| 65 66 69 6e 69 74 69 6f | 6e 20 6f 66 20 61 20 66 |efinitio|n of a f|
|00005f60| 69 65 6c 64 27 73 20 6c | 65 6e 67 74 68 20 68 61 |ield's l|ength ha|
|00005f70| 73 0a 58 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |s.X | |
|00005f80| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00005f90| 20 20 20 20 20 20 20 20 | 20 20 20 62 65 65 6e 20 | | been |
|00005fa0| 65 6e 74 65 72 65 64 20 | 69 6e 63 6f 72 72 65 63 |entered |incorrec|
|00005fb0| 74 6c 79 2e 0a 58 20 20 | 20 20 20 20 46 69 65 6c |tly..X | Fiel|
|00005fc0| 64 20 3c 66 69 65 6c 64 | 3e 20 75 6e 64 65 66 69 |d <field|> undefi|
|00005fd0| 6e 65 64 2e 2e 2e 2e 2e | 2e 2e 2e 2e 41 6e 20 69 |ned.....|....An i|
|00005fe0| 6e 64 65 78 20 68 61 73 | 20 62 65 65 6e 20 70 6c |ndex has| been pl|
|00005ff0| 61 63 65 64 20 6f 6e 20 | 61 20 6e 6f 6e 2d 0a 58 |aced on |a non-.X|
|00006000| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00006010| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00006020| 20 20 20 20 20 20 20 20 | 65 78 69 73 74 61 6e 74 | |existant|
|00006030| 20 66 69 65 6c 64 2e 20 | 20 43 68 65 63 6b 20 73 | field. | Check s|
|00006040| 70 65 6c 6c 69 6e 67 2e | 0a 58 20 20 20 20 20 20 |pelling.|.X |
|00006050| 4e 6f 20 66 69 65 6c 64 | 73 20 64 65 63 6c 61 72 |No field|s declar|
|00006060| 65 64 20 62 65 66 6f 72 | 65 20 65 6e 64 2e 2e 2e |ed befor|e end...|
|00006070| 54 68 65 20 73 63 68 65 | 6d 61 20 64 65 66 69 6e |The sche|ma defin|
|00006080| 69 74 69 6f 6e 20 69 73 | 20 69 6e 63 6f 6d 70 6c |ition is| incompl|
|00006090| 65 74 65 3a 20 69 74 0a | 58 20 20 20 20 20 20 20 |ete: it.|X |
|000060a0| 20 72 65 61 63 68 65 64 | 20 20 20 20 20 20 20 20 | reached| |
|000060b0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|000060c0| 20 6d 75 73 74 20 63 6f | 6e 74 61 69 6e 20 61 74 | must co|ntain at|
|000060d0| 20 6c 65 61 73 74 20 6f | 6e 65 20 66 69 65 6c 64 | least o|ne field|
|000060e0| 20 61 6e 64 0a 58 20 20 | 20 20 20 20 20 20 20 20 | and.X | |
|000060f0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00006100| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 6f 6e | | on|
|00006110| 65 20 69 6e 64 65 78 2e | 0a 58 20 20 20 20 20 20 |e index.|.X |
|00006120| 4e 6f 20 69 6e 64 69 63 | 65 73 20 64 65 63 6c 61 |No indic|es decla|
|00006130| 72 65 64 20 62 65 66 6f | 72 65 2e 2e 2e 2e 2e 53 |red befo|re.....S|
|00006140| 65 65 20 74 68 65 20 61 | 62 6f 76 65 20 65 72 72 |ee the a|bove err|
|00006150| 6f 72 20 64 65 73 63 72 | 69 70 74 69 6f 6e 2e 0a |or descr|iption..|
|00006160| 58 20 20 20 20 20 20 20 | 20 65 6e 64 20 72 65 61 |X | end rea|
|00006170| 63 68 65 64 0a 58 20 20 | 20 20 20 20 49 64 65 6e |ched.X | Iden|
|00006180| 74 69 66 69 65 72 20 3c | 3f 3e 20 6e 6f 74 20 72 |tifier <|?> not r|
|00006190| 65 63 6f 67 6e 69 7a 65 | 64 2e 2e 2e 54 68 65 20 |ecognize|d...The |
|000061a0| 6f 6e 6c 79 20 76 61 6c | 69 64 20 77 6f 72 64 73 |only val|id words|
|000061b0| 20 66 6f 72 20 74 68 65 | 20 62 65 67 69 6e 6e 69 | for the| beginni|
|000061c0| 6e 67 0a 58 20 20 20 20 | 20 20 20 20 20 20 20 20 |ng.X | |
|000061d0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|000061e0| 20 20 20 20 20 20 20 20 | 20 20 20 20 6f 66 20 61 | | of a|
|000061f0| 20 6c 69 6e 65 20 61 72 | 65 20 22 72 65 6c 61 74 | line ar|e "relat|
|00006200| 69 6f 6e 22 20 6f 72 20 | 61 20 72 65 6c 61 74 69 |ion" or |a relati|
|00006210| 6f 6e 2d 0a 58 20 20 20 | 20 20 20 20 20 20 20 20 |on-.X | |
|00006220| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00006230| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 6e 61 6d | | nam|
|00006240| 65 20 28 61 73 20 74 68 | 65 20 66 69 72 73 74 20 |e (as th|e first |
|00006250| 6c 69 6e 65 29 2c 20 22 | 66 69 65 6c 64 22 2c 0a |line), "|field",.|
|00006260| 58 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |X | |
|00006270| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00006280| 20 20 20 20 20 20 20 20 | 20 22 69 6e 64 65 78 22 | | "index"|
|00006290| 2c 20 61 6e 64 20 28 6f | 70 74 69 6f 6e 61 6c 6c |, and (o|ptionall|
|000062a0| 79 29 20 22 65 6e 64 22 | 2e 0a 58 20 20 20 20 20 |y) "end"|..X |
|000062b0| 20 43 61 6e 6e 6f 74 20 | 6f 70 65 6e 20 72 65 6c | Cannot |open rel|
|000062c0| 61 74 69 6f 6e 2e 2e 2e | 2e 2e 2e 2e 2e 2e 2e 2e |ation...|........|
|000062d0| 2e 54 68 65 20 66 69 6c | 65 20 3c 66 69 6c 65 2e |.The fil|e <file.|
|000062e0| 72 65 6c 3e 20 63 61 6e | 6e 6f 74 20 62 65 20 77 |rel> can|not be w|
|000062f0| 72 69 74 74 65 6e 2e 2e | 2e 0a 58 20 20 20 20 20 |ritten..|..X |
|00006300| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00006310| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00006320| 20 20 20 70 6f 73 73 69 | 62 6c 65 20 63 61 75 73 | possi|ble caus|
|00006330| 65 73 20 61 72 65 20 61 | 20 6d 65 64 69 61 20 65 |es are a| media e|
|00006340| 72 72 6f 72 20 6f 72 0a | 58 20 20 20 20 20 20 20 |rror or.|X |
|00006350| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00006360| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00006370| 20 77 72 69 74 65 2d 70 | 72 6f 74 65 63 74 69 6f | write-p|rotectio|
|00006380| 6e 20 6f 6e 20 74 68 65 | 20 66 69 6c 65 2e 0a 58 |n on the| file..X|
|00006390| 20 20 20 20 20 20 52 65 | 6c 61 74 69 6f 6e 20 69 | Re|lation i|
|000063a0| 73 20 62 75 73 79 2e 2e | 2e 2e 2e 2e 2e 2e 2e 2e |s busy..|........|
|000063b0| 2e 2e 2e 2e 2e 2e 52 65 | 6c 61 74 69 6f 6e 73 20 |......Re|lations |
|000063c0| 63 61 6e 6e 6f 74 20 62 | 65 20 72 65 2d 62 75 69 |cannot b|e re-bui|
|000063d0| 6c 74 20 75 6e 74 69 6c | 20 69 74 20 69 73 0a 58 |lt until| it is.X|
|000063e0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|000063f0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
+--------+-------------------------+-------------------------+--------+--------+
Only 25.0 KB of data is shown above.
