home *** CD-ROM | disk | FTP | other *** search
| Unknown | 1998-08-31 | 2.3 KB |
view JSON data
|
view as text
|
open on a Mac
|
open on a PC
This file was not able to be converted.
This format is not currently supported by dexvert.
| Confidence | Program | Detection | Match Type | Support
|
|---|
| 100%
| file
| SIMH tape data
| default (weak)
| |
| 99%
| file
| data
| default
|
|
hex view+--------+-------------------------+-------------------------+--------+--------+
|00000000| 01 00 00 01 00 00 01 00 | 00 01 00 00 01 00 00 01 |........|........|
|00000010| 00 00 f3 01 7c 39 20 63 | 61 6e 27 74 20 63 72 65 |....|9 c|an't cre|
|00000020| 61 74 65 20 74 68 69 73 | 20 72 65 6c 61 74 69 6f |ate this| relatio|
|00000030| 6e 73 68 69 70 20 61 6e | 64 20 65 6e 66 6f 72 63 |nship an|d enforc|
|00000040| 65 20 72 65 66 65 72 65 | 6e 74 69 61 6c 20 69 6e |e refere|ntial in|
|00000050| 74 65 67 72 69 74 79 2e | 40 44 61 74 61 20 69 6e |tegrity.|@Data in|
|00000060| 20 74 68 65 20 74 61 62 | 6c 65 20 27 7c 27 20 76 | the tab|le '|' v|
|00000070| 69 6f 6c 61 74 65 73 20 | 72 65 66 65 72 65 6e 74 |iolates |referent|
|00000080| 69 61 6c 20 69 6e 74 65 | 67 72 69 74 79 20 72 75 |ial inte|grity ru|
|00000090| 6c 65 73 2e 0a 46 6f 72 | 20 65 78 61 6d 70 6c 65 |les..For| example|
|000000a0| 2c 20 74 68 65 72 65 20 | 6d 61 79 20 62 65 20 72 |, there |may be r|
|000000b0| 65 63 6f 72 64 73 20 72 | 65 6c 61 74 69 6e 67 20 |ecords r|elating |
|000000c0| 74 6f 20 61 6e 20 65 6d | 70 6c 6f 79 65 65 20 69 |to an em|ployee i|
|000000d0| 6e 20 74 68 65 20 72 65 | 6c 61 74 65 64 20 74 61 |n the re|lated ta|
|000000e0| 62 6c 65 2c 20 62 75 74 | 20 6e 6f 20 72 65 63 6f |ble, but| no reco|
|000000f0| 72 64 20 66 6f 72 20 74 | 68 65 20 65 6d 70 6c 6f |rd for t|he emplo|
|00000100| 79 65 65 20 69 6e 20 74 | 68 65 20 70 72 69 6d 61 |yee in t|he prima|
|00000110| 72 79 20 74 61 62 6c 65 | 2e 40 45 64 69 74 20 74 |ry table|.@Edit t|
|00000120| 68 65 20 64 61 74 61 20 | 73 6f 20 74 68 61 74 20 |he data |so that |
|00000130| 72 65 63 6f 72 64 73 20 | 69 6e 20 74 68 65 20 70 |records |in the p|
|00000140| 72 69 6d 61 72 79 20 74 | 61 62 6c 65 20 65 78 69 |rimary t|able exi|
|00000150| 73 74 20 66 6f 72 20 61 | 6c 6c 20 72 65 6c 61 74 |st for a|ll relat|
|00000160| 65 64 20 72 65 63 6f 72 | 64 73 2e 0a 49 66 20 79 |ed recor|ds..If y|
|00000170| 6f 75 20 77 61 6e 74 20 | 74 6f 20 63 72 65 61 74 |ou want |to creat|
|00000180| 65 20 74 68 65 20 72 65 | 6c 61 74 69 6f 6e 73 68 |e the re|lationsh|
|00000190| 69 70 20 77 69 74 68 6f | 75 74 20 66 6f 6c 6c 6f |ip witho|ut follo|
|000001a0| 77 69 6e 67 20 74 68 65 | 20 72 75 6c 65 73 20 6f |wing the| rules o|
|000001b0| 66 20 72 65 66 65 72 65 | 6e 74 69 61 6c 20 69 6e |f refere|ntial in|
|000001c0| 74 65 67 72 69 74 79 2c | 20 63 6c 65 61 72 20 74 |tegrity,| clear t|
|000001d0| 68 65 20 45 6e 66 6f 72 | 63 65 20 52 65 66 65 72 |he Enfor|ce Refer|
|000001e0| 65 6e 74 69 61 6c 20 49 | 6e 74 65 67 72 69 74 79 |ential I|ntegrity|
|000001f0| 20 63 68 65 63 6b 20 62 | 6f 78 2e 40 31 40 32 30 | check b|ox.@1@20|
|00000200| 39 30 38 36 40 31 00 01 | 00 00 c0 01 7c 39 20 63 |9086@1..|....|9 c|
|00000210| 72 65 61 74 65 64 20 61 | 20 6f 6e 65 2d 74 6f 2d |reated a| one-to-|
|00000220| 6f 6e 65 20 72 65 6c 61 | 74 69 6f 6e 73 68 69 70 |one rela|tionship|
|00000230| 20 69 6e 73 74 65 61 64 | 20 6f 66 20 61 20 6f 6e | instead| of a on|
|00000240| 65 2d 74 6f 2d 6d 61 6e | 79 20 72 65 6c 61 74 69 |e-to-man|y relati|
|00000250| 6f 6e 73 68 69 70 20 62 | 65 63 61 75 73 65 20 74 |onship b|ecause t|
|00000260| 68 65 72 65 20 69 73 20 | 61 20 75 6e 69 71 75 65 |here is |a unique|
|00000270| 20 69 6e 64 65 78 20 6f | 6e 20 74 68 65 20 66 69 | index o|n the fi|
|00000280| 65 6c 64 28 73 29 20 73 | 70 65 63 69 66 69 65 64 |eld(s) s|pecified|
|00000290| 20 66 6f 72 20 74 68 65 | 20 72 65 6c 61 74 65 64 | for the| related|
|000002a0| 20 74 61 62 6c 65 2e 40 | 49 66 20 79 6f 75 20 77 | table.@|If you w|
|000002b0| 61 6e 74 20 74 6f 20 64 | 65 66 69 6e 65 20 61 20 |ant to d|efine a |
|000002c0| 6f 6e 65 2d 74 6f 2d 6d | 61 6e 79 20 72 65 6c 61 |one-to-m|any rela|
|000002d0| 74 69 6f 6e 73 68 69 70 | 20 62 65 74 77 65 65 6e |tionship| between|
|000002e0| 20 74 68 65 73 65 20 74 | 61 62 6c 65 73 2c 20 74 | these t|ables, t|
|000002f0| 72 79 20 6f 6e 65 20 6f | 66 20 74 68 65 20 66 6f |ry one o|f the fo|
|00000300| 6c 6c 6f 77 69 6e 67 3a | 0a 2a 20 44 65 6c 65 74 |llowing:|.* Delet|
|00000310| 65 20 74 68 65 20 6f 6e | 65 2d 74 6f 2d 6f 6e 65 |e the on|e-to-one|
|00000320| 20 72 65 6c 61 74 69 6f | 6e 73 68 69 70 2c 20 61 | relatio|nship, a|
|00000330| 6e 64 20 74 68 65 6e 20 | 63 68 61 6e 67 65 20 74 |nd then |change t|
|00000340| 68 65 20 73 65 74 74 69 | 6e 67 20 6f 66 20 74 68 |he setti|ng of th|
|00000350| 65 20 49 6e 64 65 78 65 | 64 20 70 72 6f 70 65 72 |e Indexe|d proper|
|00000360| 74 79 20 66 6f 72 20 74 | 68 65 20 66 6f 72 65 69 |ty for t|he forei|
|00000370| 67 6e 20 6b 65 79 20 66 | 69 65 6c 64 20 66 72 6f |gn key f|ield fro|
|00000380| 6d 20 4e 6f 20 44 75 70 | 6c 69 63 61 74 65 73 20 |m No Dup|licates |
|00000390| 74 6f 20 44 75 70 6c 69 | 63 61 74 65 73 20 4f 4b |to Dupli|cates OK|
|000003a0| 2e 0a 2a 20 43 68 6f 6f | 73 65 20 64 69 66 66 65 |..* Choo|se diffe|
|000003b0| 72 65 6e 74 20 6d 61 74 | 63 68 69 6e 67 20 66 69 |rent mat|ching fi|
|000003c0| 65 6c 64 73 2e 40 40 31 | 40 40 31 00 5e 01 7c 39 |elds.@@1|@@1.^.|9|
|000003d0| 20 63 61 6e 27 74 20 65 | 6e 66 6f 72 63 65 20 72 | can't e|nforce r|
|000003e0| 65 66 65 72 65 6e 74 69 | 61 6c 20 69 6e 74 65 67 |eferenti|al integ|
|000003f0| 72 69 74 79 20 66 6f 72 | 20 74 68 69 73 20 72 65 |rity for| this re|
|00000400| 6c 61 74 69 6f 6e 73 68 | 69 70 2e 40 4d 61 6b 65 |lationsh|ip.@Make|
|00000410| 20 73 75 72 65 20 74 68 | 65 20 66 69 65 6c 64 73 | sure th|e fields|
|00000420| 20 79 6f 75 20 64 72 61 | 67 20 61 72 65 20 70 72 | you dra|g are pr|
|00000430| 69 6d 61 72 79 20 6b 65 | 79 20 66 69 65 6c 64 73 |imary ke|y fields|
|00000440| 20 6f 72 20 75 6e 69 71 | 75 65 6c 79 20 69 6e 64 | or uniq|uely ind|
|00000450| 65 78 65 64 20 61 6e 64 | 20 74 68 61 74 20 74 68 |exed and| that th|
|00000460| 65 20 75 6e 69 71 75 65 | 20 69 6e 64 65 78 20 6f |e unique| index o|
|00000470| 72 20 70 72 69 6d 61 72 | 79 20 6b 65 79 20 69 73 |r primar|y key is|
|00000480| 20 63 6f 72 72 65 63 74 | 6c 79 20 73 65 74 2e 0a | correct|ly set..|
|00000490| 49 66 20 79 6f 75 20 77 | 61 6e 74 20 74 6f 20 63 |If you w|ant to c|
|000004a0| 72 65 61 74 65 20 74 68 | 65 20 72 65 6c 61 74 69 |reate th|e relati|
|000004b0| 6f 6e 73 68 69 70 20 77 | 69 74 68 6f 75 74 20 66 |onship w|ithout f|
|000004c0| 6f 6c 6c 6f 77 69 6e 67 | 20 74 68 65 20 72 75 6c |ollowing| the rul|
|000004d0| 65 73 20 6f 66 20 72 65 | 66 65 72 65 6e 74 69 61 |es of re|ferentia|
|000004e0| 6c 20 69 6e 74 65 67 72 | 69 74 79 2c 20 63 6c 65 |l integr|ity, cle|
|000004f0| 61 72 20 74 68 65 20 45 | 6e 66 6f 72 63 65 20 52 |ar the E|nforce R|
|00000500| 65 66 65 72 65 6e 74 69 | 61 6c 20 49 6e 74 65 67 |eferenti|al Integ|
|00000510| 72 69 74 79 20 63 68 65 | 63 6b 20 62 6f 78 2e 40 |rity che|ck box.@|
|00000520| 40 31 40 32 30 39 30 38 | 36 40 31 00 17 02 7c 39 |@1@20908|6@1...|9|
|00000530| 20 63 61 6e 27 74 20 63 | 72 65 61 74 65 20 74 68 | can't c|reate th|
|00000540| 69 73 20 72 65 6c 61 74 | 69 6f 6e 73 68 69 70 20 |is relat|ionship |
|00000550| 61 6e 64 20 65 6e 66 6f | 72 63 65 20 72 65 66 65 |and enfo|rce refe|
|00000560| 72 65 6e 74 69 61 6c 20 | 69 6e 74 65 67 72 69 74 |rential |integrit|
|00000570| 79 2e 40 2a 20 54 68 65 | 20 66 69 65 6c 64 73 20 |y.@* The| fields |
|00000580| 79 6f 75 20 63 68 6f 73 | 65 20 6d 61 79 20 68 61 |you chos|e may ha|
|00000590| 76 65 20 64 69 66 66 65 | 72 65 6e 74 20 64 61 74 |ve diffe|rent dat|
|000005a0| 61 20 74 79 70 65 73 2e | 0a 2a 20 54 68 65 20 66 |a types.|.* The f|
|000005b0| 69 65 6c 64 73 20 6d 61 | 79 20 68 61 76 65 20 74 |ields ma|y have t|
|000005c0| 68 65 20 4e 75 6d 62 65 | 72 20 64 61 74 61 20 74 |he Numbe|r data t|
|000005d0| 79 70 65 20 62 75 74 20 | 6e 6f 74 20 74 68 65 20 |ype but |not the |
|000005e0| 73 61 6d 65 20 46 69 65 | 6c 64 53 69 7a 65 20 70 |same Fie|ldSize p|
|000005f0| 72 6f 70 65 72 74 79 20 | 73 65 74 74 69 6e 67 2e |roperty |setting.|
|00000600| 40 54 72 79 20 6f 6e 65 | 20 6f 66 20 74 68 65 20 |@Try one| of the |
|00000610| 66 6f 6c 6c 6f 77 69 6e | 67 3a 0a 2a 20 53 65 6c |followin|g:.* Sel|
|00000620| 65 63 74 20 66 69 65 6c | 64 73 20 77 69 74 68 20 |ect fiel|ds with |
|00000630| 74 68 65 20 73 61 6d 65 | 20 64 61 74 61 20 74 79 |the same| data ty|
|00000640| 70 65 2e 0a 2a 20 4f 70 | 65 6e 20 74 68 65 20 74 |pe..* Op|en the t|
|00000650| 61 62 6c 65 73 20 69 6e | 20 44 65 73 69 67 6e 20 |ables in| Design |
|00000660| 76 69 65 77 2c 20 61 6e | 64 20 63 68 61 6e 67 65 |view, an|d change|
|00000670| 20 74 68 65 20 64 61 74 | 61 20 74 79 70 65 73 20 | the dat|a types |
|00000680| 61 6e 64 20 66 69 65 6c | 64 20 73 69 7a 65 73 20 |and fiel|d sizes |
|00000690| 73 6f 20 74 68 61 74 20 | 74 68 65 20 66 69 65 6c |so that |the fiel|
|000006a0| 64 73 20 6d 61 74 63 68 | 2e 0a 49 66 20 79 6f 75 |ds match|..If you|
|000006b0| 20 77 61 6e 74 20 74 6f | 20 63 72 65 61 74 65 20 | want to| create |
|000006c0| 74 68 65 20 72 65 6c 61 | 74 69 6f 6e 73 68 69 70 |the rela|tionship|
|000006d0| 20 77 69 74 68 6f 75 74 | 20 66 6f 6c 6c 6f 77 69 | without| followi|
|000006e0| 6e 67 20 74 68 65 20 72 | 75 6c 65 73 20 6f 66 20 |ng the r|ules of |
|000006f0| 72 65 66 65 72 65 6e 74 | 69 61 6c 20 69 6e 74 65 |referent|ial inte|
|00000700| 67 72 69 74 79 2c 20 63 | 6c 65 61 72 20 74 68 65 |grity, c|lear the|
|00000710| 20 45 6e 66 6f 72 63 65 | 20 52 65 66 65 72 65 6e | Enforce| Referen|
|00000720| 74 69 61 6c 20 49 6e 74 | 65 67 72 69 74 79 20 63 |tial Int|egrity c|
|00000730| 68 65 63 6b 20 62 6f 78 | 2e 40 32 40 32 30 39 30 |heck box|.@2@2090|
|00000740| 38 36 40 31 00 86 01 59 | 6f 75 20 63 61 6e 27 74 |86@1...Y|ou can't|
|00000750| 20 63 72 65 61 74 65 20 | 61 20 72 65 6c 61 74 69 | create |a relati|
|00000760| 6f 6e 73 68 69 70 20 62 | 65 74 77 65 65 6e 20 66 |onship b|etween f|
|00000770| 69 65 6c 64 73 20 77 69 | 74 68 20 74 68 65 20 4d |ields wi|th the M|
|00000780| 65 6d 6f 2c 20 4f 4c 45 | 20 4f 62 6a 65 63 74 2c |emo, OLE| Object,|
|00000790| 20 59 65 73 2f 4e 6f 2c | 20 6f 72 20 48 79 70 65 | Yes/No,| or Hype|
|000007a0| 72 6c 69 6e 6b 20 64 61 | 74 61 20 74 79 70 65 2e |rlink da|ta type.|
|000007b0| 40 59 6f 75 20 74 72 69 | 65 64 20 74 6f 20 65 6e |@You tri|ed to en|
|000007c0| 66 6f 72 63 65 20 72 65 | 66 65 72 65 6e 74 69 61 |force re|ferentia|
|000007d0| 6c 20 69 6e 74 65 67 72 | 69 74 79 20 66 6f 72 20 |l integr|ity for |
|000007e0| 61 20 72 65 6c 61 74 69 | 6f 6e 73 68 69 70 2c 20 |a relati|onship, |
|000007f0| 62 75 74 20 6f 6e 65 20 | 6f 72 20 6d 6f 72 65 20 |but one |or more |
|00000800| 6f 66 20 74 68 65 20 66 | 69 65 6c 64 73 20 79 6f |of the f|ields yo|
|00000810| 75 20 63 68 6f 73 65 20 | 68 61 76 65 20 74 68 65 |u chose |have the|
|00000820| 20 4d 65 6d 6f 2c 20 4f | 4c 45 20 4f 62 6a 65 63 | Memo, O|LE Objec|
|00000830| 74 2c 20 59 65 73 2f 4e | 6f 2c 20 6f 72 20 48 79 |t, Yes/N|o, or Hy|
|00000840| 70 65 72 6c 69 6e 6b 20 | 64 61 74 61 20 74 79 70 |perlink |data typ|
|00000850| 65 2e 40 53 65 6c 65 63 | 74 20 66 69 65 6c 64 73 |e.@Selec|t fields|
|00000860| 20 69 6e 20 74 68 65 20 | 67 72 69 64 20 74 68 61 | in the |grid tha|
|00000870| 74 20 64 6f 6e 27 74 20 | 68 61 76 65 20 74 68 65 |t don't |have the|
|00000880| 73 65 20 64 61 74 61 20 | 74 79 70 65 73 2c 20 6f |se data |types, o|
|00000890| 72 20 6f 70 65 6e 20 74 | 68 65 20 74 61 62 6c 65 |r open t|he table|
|000008a0| 73 20 69 6e 20 44 65 73 | 69 67 6e 20 76 69 65 77 |s in Des|ign view|
|000008b0| 20 61 6e 64 20 63 68 61 | 6e 67 65 20 64 61 74 61 | and cha|nge data|
|000008c0| 20 74 79 70 65 73 2e 40 | 31 40 40 31 00 49 00 59 | types.@|1@@1.I.Y|
|000008d0| 6f 75 20 63 61 6e 27 74 | 20 64 65 6c 65 74 65 20 |ou can't| delete |
|000008e0| 61 20 72 65 6c 61 74 69 | 6f 6e 73 68 69 70 20 69 |a relati|onship i|
|000008f0| 6e 68 65 72 69 74 65 64 | 20 66 72 6f 6d 20 61 20 |nherited| from a |
|00000900| 6c 69 6e 6b 65 64 20 64 | 61 74 61 62 61 73 65 2e |linked d|atabase.|
|00000910| 40 40 40 31 40 40 31 00 | 01 00 00 01 00 00 01 00 |@@@1@@1.|........|
|00000920| 00 | |. | |
+--------+-------------------------+-------------------------+--------+--------+
