/ PD ROM 1 / PD ROM Volume I - Macintosh Software from BMUG (1988).iso / Programming / Complete Applications / 4D Programming / Samples.1 / Samples.index3

< prev

next >

MacOS 8.1

Win98

DOS

view JSON data

view as text

+--------+-------------------------+-------------------------+--------+--------+
|00000000| 00 00 00 01 00 00 00 00 | ff ff ff ff 00 14 00 08 |........|........|
|00000010| ff ff ff ff 00 00 00 04 | ff ff ff ff 0a 43 75 6e |........|.....Cun|
|00000020| 6e 69 6e 67 68 61 6d 4e | 00 0e 5f 2e 00 0e 5f 2e |ninghamN|.._..._.|
|00000030| 00 00 00 00 00 06 ff ff | ff ff 0a 43 75 6e 6e 69 |........|...Cunni|
|00000040| 6e 67 68 61 6d 4e 00 0e | 5f 2e 00 0e 5f 2e 00 00 |nghamN..|_..._...|
|00000050| 00 00 00 01 ff ff ff ff | 03 44 6f 65 65 68 00 00 |........|.Doeeh..|
|00000060| 00 02 9a 4e 00 0e 5f 2e | 00 0e 5f 2e 00 00 00 00 |...N.._.|.._.....|
|00000070| 00 05 ff ff ff ff 08 45 | 64 65 6e 62 65 72 67 61 |.......E|denberga|
|00000080| 6d 4e 00 0e 5f 2e 00 0e | 5f 2e 00 00 00 00 00 07 |mN.._...|_.......|
|00000090| ff ff ff ff 08 48 61 72 | 72 69 73 6f 6e 61 6d 4e |.....Har|risonamN|
|000000a0| 00 0e 5f 2e 00 0e 5f 2e | 00 00 00 00 00 02 ff ff |.._..._.|........|
|000000b0| ff ff 07 4a 6f 68 6e 73 | 6f 6e 00 02 9a 4e 00 0e |...Johns|on...N..|
|000000c0| 5f 2e 00 0e 5f 2e 00 00 | 00 00 00 00 ff ff ff ff |_..._...|........|
|000000d0| 05 53 6d 69 74 68 00 00 | 00 02 9a 4e 00 0e 5f 2e |.Smith..|...N.._.|
|000000e0| 00 0e 5f 2e 00 00 00 00 | 00 03 ff ff ff ff 05 54 |.._.....|.......T|
|000000f0| 65 72 72 79 61 6e 00 02 | 9a 4e 00 0e 5f 2e 00 0e |erryan..|.N.._...|
|00000100| 5f 2e 00 00 14 54 72 79 | 20 69 74 20 79 6f 75 27 |_....Try| it you'|
|00000110| 6c 6c 20 6c 69 6b 65 20 | 69 00 f6 88 60 32 0c 6d |ll like |i...`2.m|
|00000120| 08 00 00 00 00 1e 00 00 | 1b 26 54 72 79 20 69 74 |........|.&Try it|
|00000130| 20 79 6f 75 27 6c 6c 20 | 6c 69 02 1c 00 02 97 8e | you'll |li......|
|00000140| 00 00 00 4c 00 00 1b 2a | 00 01 ff ff ff ff ff ff |...L...*|........|
|00000150| ff ff 00 01 14 49 20 68 | 65 61 72 64 00 00 02 24 |.....I h|eard...$|
|00000160| 00 00 1a ea 54 68 69 73 | 20 69 73 20 61 6e 20 65 |....This| is an e|
|00000170| 78 61 6d 70 6c 65 20 6f | 66 20 61 20 73 63 72 6f |xample o|f a scro|
|00000180| 6c 6c 61 62 6c 65 20 61 | 72 65 61 2e 20 20 45 61 |llable a|rea.  Ea|
|00000190| 63 68 20 65 6c 65 6d 65 | 6e 74 20 69 6e 20 74 68 |ch eleme|nt in th|
|000001a0| 65 20 61 72 72 61 79 20 | 72 65 70 72 65 73 65 6e |e array |represen|
|000001b0| 74 73 20 6f 6e 65 20 72 | 65 63 6f 72 64 20 69 6e |ts one r|ecord in|
|000001c0| 20 74 68 65 20 66 69 6c | 65 20 5b 51 75 6f 74 65 | the fil|e [Quote|
|000001d0| 73 5d 2e 20 20 54 68 65 | 20 66 69 72 73 74 20 74 |s].  The| first t|
|000001e0| 77 65 6e 74 79 20 63 68 | 61 72 61 63 74 65 72 73 |wenty ch|aracters|
|000001f0| 20 6f 66 20 65 61 63 68 | 20 71 75 6f 74 65 20 61 | of each| quote a|
|00000200| 72 65 20 64 75 70 6c 69 | 63 61 74 65 64 20 69 6e |re dupli|cated in|
|00000210| 20 61 20 73 65 63 6f 6e | 64 20 66 69 65 6c 64 20 | a secon|d field |
|00000220| 22 46 6f 72 53 6f 72 74 | 22 20 77 68 69 63 68 20 |"ForSort|" which |
|00000230| 69 73 20 69 6e 64 65 78 | 65 64 20 66 6f 72 20 66 |is index|ed for f|
|00000240| 61 73 74 20 73 65 61 72 | 63 68 65 73 20 61 6e 64 |ast sear|ches and|
|00000250| 20 73 6f 72 74 73 2e 20 | 20 53 69 6e 63 65 20 74 | sorts. | Since t|
|00000260| 68 65 20 66 69 65 6c 64 | 20 22 51 75 6f 74 65 22 |he field| "Quote"|
|00000270| 20 69 73 20 61 20 74 65 | 78 74 20 66 69 65 6c 64 | is a te|xt field|
|00000280| 2c 20 61 6c 6d 6f 73 74 | 20 61 6e 79 20 61 6d 6f |, almost| any amo|
|00000290| 75 6e 74 20 6f 66 20 74 | 65 78 74 20 63 61 6e 20 |unt of t|ext can |
|000002a0| 62 65 20 65 6e 74 65 72 | 65 64 2e 20 20 54 68 69 |be enter|ed.  Thi|
|000002b0| 73 20 65 78 61 6d 70 6c | 65 20 69 73 20 6e 6f 74 |s exampl|e is not|
|000002c0| 20 6d 65 61 6e 74 20 66 | 6f 72 20 61 20 6c 61 72 | meant f|or a lar|
|000002d0| 67 65 20 61 6d 6f 75 6e | 74 20 6f 66 20 72 65 63 |ge amoun|t of rec|
|000002e0| 6f 72 64 73 20 62 75 74 | 20 63 61 6e 20 62 65 20 |ords but| can be |
|000002f0| 75 73 65 64 20 77 68 65 | 6e 20 61 20 66 69 6e 69 |used whe|n a fini|
|00000300| 74 65 20 73 65 74 20 6f | 66 20 69 6e 66 6f 72 6d |te set o|f inform|
|00000310| 61 74 69 6f 6e 20 69 73 | 20 6e 65 65 64 65 64 20 |ation is| needed |
|00000320| 69 6e 20 61 6e 6f 74 68 | 65 72 20 70 61 72 74 20 |in anoth|er part |
|00000330| 6f 66 20 74 68 65 20 64 | 61 74 61 62 61 73 65 2e |of the d|atabase.|
|00000340| 0d 0d 0d 0d 52 65 66 2e | 20 50 72 6f 63 73 3a 20 |....Ref.| Procs: |
|00000350| 20 47 6c 6f 62 61 6c 2d | 4f 70 65 6e 20 51 75 6f | Global-|Open Quo|
|00000360| 74 65 20 20 20 4c 61 79 | 6f 75 74 2d 5b 51 75 6f |te   Lay|out-[Quo|
|00000370| 74 65 73 5d 22 44 69 61 | 6c 20 51 75 6f 74 65 22 |tes]"Dia|l Quote"|
|00000380| 00 00 02 8c 00 00 1b 1a | ff ff ff ff 00 01 00 06 |........|........|
|00000390| 04 02 75 07 00 02 54 68 | 69 73 20 65 78 61 6d 70 |..u...Th|is examp|
|000003a0| 6c 65 20 73 68 6f 77 73 | 20 61 20 73 63 72 6f 6c |le shows| a scrol|
|000003b0| 6c 61 62 6c 65 20 61 72 | 65 61 20 75 73 65 64 20 |lable ar|ea used |
|000003c0| 74 6f 20 74 72 61 63 6b | 20 73 75 62 72 65 63 6f |to track| subreco|
|000003d0| 72 64 73 2e 20 20 45 61 | 63 68 20 73 75 62 72 65 |rds.  Ea|ch subre|
|000003e0| 63 6f 72 64 20 68 61 73 | 20 61 20 75 6e 69 71 75 |cord has| a uniqu|
|000003f0| 65 20 76 61 6c 75 65 20 | 69 6e 20 74 68 65 20 22 |e value |in the "|
|00000400| 53 65 71 22 20 66 69 65 | 6c 64 2e 20 20 54 68 69 |Seq" fie|ld.  Thi|
|00000410| 73 20 66 69 65 6c 64 20 | 69 73 20 75 73 65 64 20 |s field |is used |
|00000420| 74 6f 20 66 69 6e 64 20 | 61 6e 64 20 63 68 61 6e |to find |and chan|
|00000430| 67 65 20 74 68 65 20 61 | 70 70 72 6f 70 72 69 61 |ge the a|ppropria|
|00000440| 74 65 20 73 75 62 72 65 | 63 6f 72 64 2e 20 20 54 |te subre|cord.  T|
|00000450| 68 65 20 69 6e 63 6c 75 | 64 65 64 20 6c 61 79 6f |he inclu|ded layo|
|00000460| 75 74 20 77 61 73 20 61 | 64 64 65 64 20 74 6f 20 |ut was a|dded to |
|00000470| 69 6c 6c 75 73 74 72 61 | 74 65 20 77 68 61 74 20 |illustra|te what |
|00000480| 69 73 20 68 61 70 70 70 | 65 6e 69 6e 67 20 74 6f |is happp|ening to|
|00000490| 20 74 68 65 20 73 75 62 | 72 65 63 6f 72 64 73 20 | the sub|records |
|000004a0| 74 68 65 6d 73 65 6c 76 | 65 73 2c 20 6e 6f 72 6d |themselv|es, norm|
|000004b0| 61 6c 6c 79 20 69 74 20 | 77 6f 75 6c 64 20 6e 6f |ally it |would no|
|000004c0| 74 20 62 65 20 69 6e 63 | 6c 75 64 65 64 2e 20 20 |t be inc|luded.  |
|000004d0| 22 49 6e 73 65 72 74 20 | 63 68 69 6c 64 22 20 70 |"Insert |child" p|
|000004e0| 75 74 73 20 61 20 6e 65 | 77 20 65 6c 65 6d 65 6e |uts a ne|w elemen|
|000004f0| 74 20 69 6e 20 74 68 65 | 20 61 72 72 61 79 20 6f |t in the| array o|
|00000500| 6e 65 20 61 62 6f 76 65 | 20 74 68 65 20 73 65 6c |ne above| the sel|
|00000510| 65 63 74 65 64 20 65 6c | 65 6d 65 6e 74 2e 20 20 |ected el|ement.  |
|00000520| 42 6f 74 68 20 22 49 6e | 73 65 72 74 20 63 68 69 |Both "In|sert chi|
|00000530| 6c 64 22 20 61 6e 64 20 | 22 44 65 6c 65 74 65 20 |ld" and |"Delete |
|00000540| 63 68 69 6c 64 22 20 6d | 75 73 74 20 72 65 2d 6e |child" m|ust re-n|
|00000550| 75 6d 62 65 72 20 62 6f | 74 68 20 74 68 65 20 65 |umber bo|th the e|
|00000560| 6c 65 6d 65 6e 74 73 20 | 69 6e 20 74 68 65 20 61 |lements |in the a|
|00000570| 72 72 61 79 20 61 6e 64 | 20 74 68 65 20 73 75 62 |rray and| the sub|
|00000580| 72 65 63 6f 72 64 73 2e | 20 20 53 69 6e 63 65 20 |records.|  Since |
|00000590| 61 6c 6c 20 73 75 62 72 | 65 63 6f 72 64 73 20 61 |all subr|ecords a|
|000005a0| 72 65 20 69 6e 20 6d 65 | 6d 6f 72 79 20 74 68 69 |re in me|mory thi|
|000005b0| 73 20 69 73 20 61 20 66 | 61 69 72 6c 79 20 66 61 |s is a f|airly fa|
|000005c0| 73 74 20 6f 70 65 72 61 | 74 69 6f 6e 2e 0d 0d 0d |st opera|tion....|
|000005d0| 52 65 66 2e 20 50 72 6f | 63 73 3a 20 20 47 6c 6f |Ref. Pro|cs:  Glo|
|000005e0| 62 61 6c 2d 4f 70 65 6e | 20 53 63 72 6f 6c 6c 32 |bal-Open| Scroll2|
|000005f0| 20 20 20 4c 61 79 6f 75 | 74 2d 5b 50 61 72 65 6e |   Layou|t-[Paren|
|00000600| 74 5d 22 53 63 72 6f 6c | 6c 32 22 74 00 00 00 0e |t]"Scrol|l2"t....|
|00000610| 00 00 1a ea 04 02 75 07 | 00 02 00 00 00 b2 00 00 |......u.|........|
|00000620| 1b 4e 00 00 00 00 00 00 | 00 00 60 6f 6f 70 65 72 |.N......|..`ooper|
|00000630| 61 74 69 6f 6e 20 77 69 | 74 68 20 74 68 65 20 46 |ation wi|th the F|
|00000640| 43 43 20 61 6e 64 20 6f | 74 68 65 72 20 61 75 74 |CC and o|ther aut|
|00000650| 68 6f 72 69 74 69 65 73 | 20 68 61 76 65 20 64 65 |horities| have de|
|00000660| 76 65 6c 6f 70 65 64 20 | 74 68 69 73 20 73 79 73 |veloped |this sys|
|00000670| 74 65 6d 20 74 6f 20 6b | 65 65 70 20 79 6f 75 20 |tem to k|eep you |
|00000680| 69 6e 66 6f 72 6d 65 64 | 20 69 6e 20 74 68 65 20 |informed| in the |
|00000690| 65 76 65 6e 74 20 6f 66 | 20 61 6e 20 65 6d 65 72 |event of| an emer|
|000006a0| 67 65 6e 63 79 2e 20 20 | 48 61 02 75 00 02 97 ca |gency.  |Ha.u....|
|000006b0| 20 62 65 65 6e 20 61 6e | 00 02 ff ff ff ff ff ff | been an|........|
|000006c0| ff ff 00 02 67 65 6e 63 | 79 20 79 6f 00 00 02 7e |....genc|y yo...~|
|000006d0| 00 00 1b 26 54 68 69 73 | 20 65 78 61 6d 70 6c 65 |...&This| example|
|000006e0| 20 73 68 6f 77 73 20 61 | 20 73 63 72 6f 6c 6c 61 | shows a| scrolla|
|000006f0| 62 6c 65 20 61 72 65 61 | 20 75 73 65 64 20 74 6f |ble area| used to|
|00000700| 20 74 72 61 63 6b 20 73 | 75 62 72 65 63 6f 72 64 | track s|ubrecord|
|00000710| 73 2e 20 20 45 61 63 68 | 20 73 75 62 72 65 63 6f |s.  Each| subreco|
|00000720| 72 64 20 68 61 73 20 61 | 20 75 6e 69 71 75 65 20 |rd has a| unique |
|00000730| 76 61 6c 75 65 20 69 6e | 20 74 68 65 20 22 53 65 |value in| the "Se|
|00000740| 71 22 20 66 69 65 6c 64 | 2e 20 20 54 68 69 73 20 |q" field|.  This |
|00000750| 66 69 65 6c 64 20 69 73 | 20 75 73 65 64 20 74 6f |field is| used to|
|00000760| 20 66 69 6e 64 20 61 6e | 64 20 63 68 61 6e 67 65 | find an|d change|
|00000770| 20 74 68 65 20 61 70 70 | 72 6f 70 72 69 61 74 65 | the app|ropriate|
|00000780| 20 73 75 62 72 65 63 6f | 72 64 2e 20 20 54 68 65 | subreco|rd.  The|
|00000790| 20 69 6e 63 00 00 00 00 |                         | inc....|        |
+--------+-------------------------+-------------------------+--------+--------+