/ Tools / WinSN5.0Ver.iso / VFP50 / SAMPLES / SOLUTION / REPORTS / PERCENT.FRT

< prev

next >

MacOS 8.1

Win98

DOS

view JSON data

view as text

+--------+-------------------------+-------------------------+--------+--------+
|00000000| 00 00 00 a3 00 00 00 21 | 00 00 00 00 00 00 00 00 |.......!|........|
|00000010| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000020| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000030| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000040| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000050| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000060| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000070| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000080| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000090| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000000a0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000000b0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000000c0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000000d0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000000e0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000000f0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000100| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000110| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000120| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000130| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000140| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000150| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000160| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000170| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000180| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000190| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000001a0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000001b0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000001c0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000001d0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000001e0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000001f0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000200| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000210| 00 00 00 01 00 00 00 0b | 43 6f 75 72 69 65 72 20 |........|Courier |
|00000220| 4e 65 77 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |New.....|........|
|00000230| 00 00 00 00 01 00 00 00 | 4d 08 00 11 00 37 00 01 |........|M....7..|
|00000240| 00 77 69 6e 73 70 6f 6f | 6c 00 5c 5c 4d 53 50 52 |.winspoo|l.\\MSPR|
|00000250| 49 4e 54 33 32 5c 32 2f | 31 4d 43 20 50 52 49 56 |INT32\2/|1MC PRIV|
|00000260| 4a 20 31 35 37 2e 35 36 | 2e 33 32 2e 32 34 32 00 |J 157.56|.32.242.|
|00000270| 4e 65 30 32 3a 00 00 00 | 00 00 00 00 00 00 00 00 |Ne02:...|........|
|00000280| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000290| 00 00 00 00 00 00 00 01 | 00 00 01 0c 5c 5c 4d 53 |........|....\\MS|
|000002a0| 50 52 49 4e 54 33 32 5c | 32 2f 31 4d 43 20 50 52 |PRINT32\|2/1MC PR|
|000002b0| 49 56 4a 20 31 35 37 2e | 35 36 2e 00 01 04 01 03 |IVJ 157.|56......|
|000002c0| 9c 00 70 00 03 53 01 00 | 01 00 01 00 00 00 00 00 |..p..S..|........|
|000002d0| 00 00 01 00 09 01 00 00 | 02 00 01 00 00 00 02 00 |........|........|
|000002e0| 00 00 4c 65 74 74 65 72 | 00 00 00 00 00 00 00 00 |..Letter|........|
|000002f0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000300| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000310| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000320| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000330| 00 00 00 00 00 00 00 00 | 20 00 ff ff ff ff 22 03 |........| .....".|
|00000340| 00 00 00 00 00 00 ff ff | ff ff ff ff ff ff 00 00 |........|........|
|00000350| 04 00 04 00 11 00 ff ff | 00 00 00 00 00 00 01 00 |........|........|
|00000360| ff ff 01 00 01 00 00 00 | ff ff 01 00 02 00 ff ff |........|........|
|00000370| ff ff ff ff ff ff ff ff | ff ff ff ff ff ff ff ff |........|........|
|00000380| ff ff ff ff ff ff ff ff | ff ff ff ff 00 00 00 00 |........|........|
|00000390| 18 00 00 00 00 00 10 27 | 10 27 10 27 00 00 10 27 |.......'|.'.'...'|
|000003a0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000003b0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000003c0| 01 00 00 00 9c 44 52 49 | 56 45 52 3d 77 69 6e 73 |.....DRI|VER=wins|
|000003d0| 70 6f 6f 6c 0d 0a 44 45 | 56 49 43 45 3d 5c 5c 4d |pool..DE|VICE=\\M|
|000003e0| 53 50 52 49 4e 54 33 32 | 5c 32 2f 31 4d 43 20 50 |SPRINT32|\2/1MC P|
|000003f0| 52 49 56 4a 20 31 35 37 | 2e 35 36 2e 33 32 2e 32 |RIVJ 157|.56.32.2|
|00000400| 34 32 0d 0a 4f 55 54 50 | 55 54 3d 4e 65 30 32 3a |42..OUTP|UT=Ne02:|
|00000410| 0d 0a 4f 52 49 45 4e 54 | 41 54 49 4f 4e 3d 30 0d |..ORIENT|ATION=0.|
|00000420| 0a 50 41 50 45 52 53 49 | 5a 45 3d 31 0d 0a 43 4f |.PAPERSI|ZE=1..CO|
|00000430| 50 49 45 53 3d 31 0d 0a | 44 45 46 41 55 4c 54 53 |PIES=1..|DEFAULTS|
|00000440| 4f 55 52 43 45 3d 32 36 | 35 0d 0a 44 55 50 4c 45 |OURCE=26|5..DUPLE|
|00000450| 58 3d 31 0d 0a 54 54 4f | 50 54 49 4f 4e 3d 32 0d |X=1..TTO|PTION=2.|
|00000460| 0a 00 00 00 00 01 00 00 | 00 0f 65 6d 70 6c 6f 79 |........|..employ|
|00000470| 65 65 2e 65 6d 70 5f 69 | 64 00 00 00 00 00 00 00 |ee.emp_i|d.......|
|00000480| 00 00 00 00 00 00 01 00 | 00 00 41 41 4c 4c 54 52 |........|..AALLTR|
|00000490| 49 4d 28 65 6d 70 6c 6f | 79 65 65 2e 66 69 72 73 |IM(emplo|yee.firs|
|000004a0| 74 5f 6e 61 6d 65 29 20 | 2b 20 22 20 22 20 2b 20 |t_name) |+ " " + |
|000004b0| 20 41 4c 4c 54 52 49 4d | 28 65 6d 70 6c 6f 79 65 | ALLTRIM|(employe|
|000004c0| 65 2e 6c 61 73 74 5f 6e | 61 6d 65 29 00 00 00 00 |e.last_n|ame)....|
|000004d0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000004e0| 00 00 00 00 00 00 00 00 | 00 01 00 00 00 01 20 00 |........|...... .|
|000004f0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000500| 00 00 00 00 00 00 00 00 | 00 00 01 00 00 00 05 41 |........|.......A|
|00000510| 72 69 61 6c 00 00 00 00 | 00 00 00 00 00 00 00 00 |rial....|........|
|00000520| 00 00 00 00 00 00 00 00 | 00 00 00 01 00 00 00 10 |........|........|
|00000530| 6f 72 64 65 72 73 2e 6f | 72 64 65 72 5f 61 6d 74 |orders.o|rder_amt|
|00000540| 00 00 00 00 00 00 00 00 | 00 00 00 00 01 00 00 00 |........|........|
|00000550| 01 20 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |. ......|........|
|00000560| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 01 00 00 |........|........|
|00000570| 00 0b 43 6f 75 72 69 65 | 72 20 4e 65 77 00 00 00 |..Courie|r New...|
|00000580| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 01 00 |........|........|
|00000590| 00 00 0c 22 24 24 39 39 | 39 39 39 2e 39 39 22 00 |..."$$99|999.99".|
|000005a0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 01 |........|........|
|000005b0| 00 00 00 10 6f 72 64 65 | 72 73 2e 6f 72 64 65 72 |....orde|rs.order|
|000005c0| 5f 61 6d 74 00 00 00 00 | 00 00 00 00 00 00 00 00 |_amt....|........|
|000005d0| 01 00 00 00 01 20 00 00 | 00 00 00 00 00 00 00 00 |..... ..|........|
|000005e0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000005f0| 00 01 00 00 00 0b 43 6f | 75 72 69 65 72 20 4e 65 |......Co|urier Ne|
|00000600| 77 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |w.......|........|
|00000610| 00 00 01 00 00 00 0e 22 | 24 24 39 39 39 39 39 39 |......."|$$999999|
|00000620| 39 2e 39 39 22 00 00 00 | 00 00 00 00 00 00 00 00 |9.99"...|........|
|00000630| 00 00 00 01 00 00 00 05 | 41 72 69 61 6c 00 00 00 |........|Arial...|
|00000640| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000650| 00 00 00 00 01 00 00 00 | 15 22 4f 76 65 72 61 6c |........|."Overal|
|00000660| 6c 20 53 61 6c 65 73 20 | 54 6f 74 61 6c 22 00 00 |l Sales |Total"..|
|00000670| 00 00 00 00 00 01 00 00 | 00 33 53 54 52 28 49 4e |........|.3STR(IN|
|00000680| 54 28 28 65 6d 70 5f 74 | 6f 74 61 6c 20 2f 20 6e |T((emp_t|otal / n|
|00000690| 54 6f 74 61 6c 53 61 6c | 65 73 29 2a 31 30 30 29 |TotalSal|es)*100)|
|000006a0| 29 20 2b 20 22 20 22 20 | 2b 20 22 25 22 00 00 00 |) + " " |+ "%"...|
|000006b0| 00 00 00 00 00 00 00 01 | 00 00 00 01 20 00 00 00 |........|.... ...|
|000006c0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000006d0| 00 00 00 00 00 00 00 00 | 01 00 00 00 0b 43 6f 75 |........|.....Cou|
|000006e0| 72 69 65 72 20 4e 65 77 | 00 00 00 00 00 00 00 00 |rier New|........|
|000006f0| 00 00 00 00 00 00 00 00 | 00 01 00 00 00 04 22 40 |........|......"@|
|00000700| 49 22 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |I"......|........|
|00000710| 00 00 00 00 00 00 00 00 | 00 00 01 00 00 00 05 41 |........|.......A|
|00000720| 72 69 61 6c 00 00 00 00 | 00 00 00 00 00 00 00 00 |rial....|........|
|00000730| 00 00 00 00 00 00 00 00 | 00 00 00 01 00 00 00 1a |........|........|
|00000740| 22 54 6f 74 61 6c 20 53 | 61 6c 65 73 20 62 79 20 |"Total S|ales by |
|00000750| 45 6d 70 6c 6f 79 65 65 | 73 22 00 00 00 00 00 00 |Employee|s"......|
|00000760| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000770| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 01 00 00 |........|........|
|00000780| 00 05 41 72 69 61 6c 00 | 00 00 00 00 00 00 00 00 |..Arial.|........|
|00000790| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 01 00 |........|........|
|000007a0| 00 00 0a 22 45 6d 70 6c | 6f 79 65 65 22 00 00 00 |..."Empl|oyee"...|
|000007b0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 01 |........|........|
|000007c0| 00 00 00 05 41 72 69 61 | 6c 00 00 00 00 00 00 00 |....Aria|l.......|
|000007d0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000007e0| 01 00 00 00 0d 22 54 6f | 74 61 6c 20 53 61 6c 65 |....."To|tal Sale|
|000007f0| 73 22 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |s"......|........|
|00000800| 00 01 00 00 00 05 41 72 | 69 61 6c 00 00 00 00 00 |......Ar|ial.....|
|00000810| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000820| 00 00 01 00 00 00 14 22 | 25 20 6f 66 20 4f 76 65 |......."|% of Ove|
|00000830| 72 61 6c 6c 20 53 61 6c | 65 73 22 00 00 00 00 00 |rall Sal|es".....|
|00000840| 00 00 00 01 00 00 00 35 | 53 54 52 28 49 4e 54 28 |.......5|STR(INT(|
|00000850| 28 6e 54 6f 74 61 6c 53 | 61 6c 65 73 20 2f 20 6e |(nTotalS|ales / n|
|00000860| 54 6f 74 61 6c 53 61 6c | 65 73 29 2a 31 30 30 29 |TotalSal|es)*100)|
|00000870| 29 20 2b 20 22 20 22 20 | 2b 20 22 25 22 00 00 00 |) + " " |+ "%"...|
|00000880| 00 00 00 00 00 01 00 00 | 00 01 20 00 00 00 00 00 |........|.. .....|
|00000890| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000008a0| 00 00 00 00 00 00 01 00 | 00 00 0b 43 6f 75 72 69 |........|...Couri|
|000008b0| 65 72 20 4e 65 77 00 00 | 00 00 00 00 00 00 00 00 |er New..|........|
|000008c0| 00 00 00 00 00 00 00 01 | 00 00 00 0f 65 6d 70 6c |........|....empl|
|000008d0| 6f 79 65 65 2e 65 6d 70 | 5f 69 64 00 00 00 00 00 |oyee.emp|_id.....|
|000008e0| 00 00 00 00 00 00 00 00 | 01 00 00 00 01 20 00 00 |........|..... ..|
|000008f0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000900| 00 00 00 00 00 00 00 00 | 00 01 00 00 00 05 41 72 |........|......Ar|
|00000910| 69 61 6c 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |ial.....|........|
|00000920| 00 00 00 00 00 00 00 00 | 00 00 01 00 00 00 0f 54 |........|.......T|
|00000930| 69 6d 65 73 20 4e 65 77 | 20 52 6f 6d 61 6e 00 00 |imes New| Roman..|
|00000940| 00 00 00 00 00 00 00 00 | 00 00 00 01 00 00 00 2f |........|......./|
|00000950| 22 56 69 73 75 61 6c 20 | 46 6f 78 50 72 6f 20 35 |"Visual |FoxPro 5|
|00000960| 2e 30 20 52 65 70 6f 72 | 74 20 53 61 6d 70 6c 65 |.0 Repor|t Sample|
|00000970| 20 2d 20 50 65 72 63 65 | 6e 74 2e 66 72 78 22 00 | - Perce|nt.frx".|
|00000980| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 01 00 00 |........|........|
|00000990| 00 1f 22 50 61 67 65 20 | 22 20 2b 20 41 4c 4c 54 |.."Page |" + ALLT|
|000009a0| 52 49 4d 28 53 54 52 28 | 5f 70 61 67 65 6e 6f 29 |RIM(STR(|_pageno)|
|000009b0| 29 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |).......|........|
|000009c0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 01 |........|........|
|000009d0| 00 00 00 01 20 00 00 00 | 00 00 00 00 00 00 00 00 |.... ...|........|
|000009e0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000009f0| 01 00 00 00 0f 54 69 6d | 65 73 20 4e 65 77 20 52 |.....Tim|es New R|
|00000a00| 6f 6d 61 6e 00 00 00 00 | 00 00 00 00 00 00 00 00 |oman....|........|
|00000a10| 00 01 00 00 00 0f 54 69 | 6d 65 73 20 4e 65 77 20 |......Ti|mes New |
|00000a20| 52 6f 6d 61 6e 00 00 00 | 00 00 00 00 00 00 00 00 |Roman...|........|
|00000a30| 00 00 01 00 00 00 0d 22 | 44 65 73 63 72 69 70 74 |......."|Descript|
|00000a40| 69 6f 6e 22 00 00 00 00 | 00 00 00 00 00 00 00 00 |ion"....|........|
|00000a50| 00 00 00 01 00 00 00 0f | 54 69 6d 65 73 20 4e 65 |........|Times Ne|
|00000a60| 77 20 52 6f 6d 61 6e 00 | 00 00 00 00 00 00 00 00 |w Roman.|........|
|00000a70| 00 00 00 00 01 00 00 00 | 7a 22 59 6f 75 20 63 61 |........|z"You ca|
|00000a80| 6e 20 61 74 74 61 74 63 | 68 20 63 6f 64 65 20 74 |n attatc|h code t|
|00000a90| 6f 20 74 68 65 20 64 61 | 74 61 20 65 6e 76 69 72 |o the da|ta envir|
|00000aa0| 6f 6e 6d 65 6e 74 20 74 | 6f 20 63 61 6c 63 75 6c |onment t|o calcul|
|00000ab0| 61 74 65 20 61 20 76 61 | 6c 75 65 20 74 6f 20 62 |ate a va|lue to b|
|00000ac0| 65 20 75 73 65 64 20 77 | 69 74 68 69 6e 20 74 68 |e used w|ithin th|
|00000ad0| 65 20 72 65 70 6f 72 74 | 2e 20 20 49 6e 20 74 68 |e report|.  In th|
|00000ae0| 69 73 20 63 61 73 65 2c | 20 74 68 65 20 74 6f 74 |is case,| the tot|
|00000af0| 61 6c 22 00 00 00 00 00 | 01 00 00 00 0f 54 69 6d |al".....|.....Tim|
|00000b00| 65 73 20 4e 65 77 20 52 | 6f 6d 61 6e 00 00 00 00 |es New R|oman....|
|00000b10| 00 00 00 00 00 00 00 00 | 00 01 00 00 00 7d 22 73 |........|.....}"s|
|00000b20| 61 6c 65 73 20 6f 66 20 | 61 6c 6c 20 65 6d 70 6c |ales of |all empl|
|00000b30| 6f 79 65 65 73 20 69 73 | 20 63 61 6c 63 75 6c 61 |oyees is| calcula|
|00000b40| 74 65 64 20 62 65 66 6f | 72 65 20 74 68 65 20 72 |ted befo|re the r|
|00000b50| 65 70 6f 72 74 20 69 73 | 20 72 75 6e 2e 20 20 54 |eport is| run.  T|
|00000b60| 68 65 6e 20 74 68 69 73 | 20 76 61 6c 75 65 20 69 |hen this| value i|
|00000b70| 73 20 75 73 65 64 20 74 | 6f 20 70 72 69 6e 74 20 |s used t|o print |
|00000b80| 6f 75 74 20 74 68 65 20 | 70 65 72 63 65 6e 74 20 |out the |percent |
|00000b90| 6f 66 20 6f 76 65 72 61 | 6c 6c 22 00 00 00 00 00 |of overa|ll".....|
|00000ba0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000bb0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 01 00 |........|........|
|00000bc0| 00 00 0f 54 69 6d 65 73 | 20 4e 65 77 20 52 6f 6d |...Times| New Rom|
|00000bd0| 61 6e 00 00 00 00 00 00 | 00 00 00 00 00 00 00 01 |an......|........|
|00000be0| 00 00 00 53 22 73 61 6c | 65 73 20 70 65 72 20 65 |...S"sal|es per e|
|00000bf0| 6d 70 6c 6f 79 65 65 20 | 28 77 68 69 63 68 20 69 |mployee |(which i|
|00000c00| 73 20 62 61 73 65 64 20 | 6f 6e 20 74 68 65 20 65 |s based |on the e|
|00000c10| 6d 70 6c 6f 79 65 65 20 | 73 61 6c 65 73 20 64 69 |mployee |sales di|
|00000c20| 76 69 64 65 64 20 62 79 | 20 74 6f 74 61 6c 20 73 |vided by| total s|
|00000c30| 61 6c 65 73 29 2e 22 00 | 00 00 00 00 00 00 00 00 |ales).".|........|
|00000c40| 00 00 01 00 00 00 09 65 | 6d 70 5f 74 6f 74 61 6c |.......e|mp_total|
|00000c50| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000c60| 00 00 00 01 00 00 00 10 | 6f 72 64 65 72 73 2e 6f |........|orders.o|
|00000c70| 72 64 65 72 5f 61 6d 74 | 00 00 00 00 00 00 00 00 |rder_amt|........|
|00000c80| 00 00 00 00 01 00 00 00 | 01 30 00 00 00 00 00 00 |........|.0......|
|00000c90| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000ca0| 00 00 00 00 00 01 00 00 | 00 0b 43 6f 75 72 69 65 |........|..Courie|
|00000cb0| 72 20 4e 65 77 00 00 00 | 00 00 00 00 00 00 00 00 |r New...|........|
|00000cc0| 00 00 00 00 00 00 01 00 | 00 00 05 41 72 69 61 6c |........|...Arial|
|00000cd0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000ce0| 00 00 00 00 00 00 00 01 | 00 00 00 05 41 72 69 61 |........|....Aria|
|00000cf0| 6c 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |l.......|........|
|00000d00| 00 00 00 00 00 00 00 00 | 01 00 00 00 0f 54 69 6d |........|.....Tim|
|00000d10| 65 73 20 4e 65 77 20 52 | 6f 6d 61 6e 00 00 00 00 |es New R|oman....|
|00000d20| 00 00 00 00 00 00 00 00 | 00 01 00 00 00 0f 54 69 |........|......Ti|
|00000d30| 6d 65 73 20 4e 65 77 20 | 52 6f 6d 61 6e 00 00 00 |mes New |Roman...|
|00000d40| 00 00 00 00 00 00 00 00 | 00 00 01 00 00 00 0f 54 |........|.......T|
|00000d50| 69 6d 65 73 20 4e 65 77 | 20 52 6f 6d 61 6e 00 00 |imes New| Roman..|
|00000d60| 00 00 00 00 00 00 00 00 | 00 00 00 01 00 00 00 0f |........|........|
|00000d70| 64 61 74 61 65 6e 76 69 | 72 6f 6e 6d 65 6e 74 00 |dataenvi|ronment.|
|00000d80| 00 00 00 00 00 00 00 00 | 00 00 00 00 01 00 00 00 |........|........|
|00000d90| 4b 4c 65 66 74 20 3d 20 | 38 33 0d 0a 54 6f 70 20 |KLeft = |83..Top |
|00000da0| 3d 20 33 35 39 0d 0a 57 | 69 64 74 68 20 3d 20 35 |= 359..W|idth = 5|
|00000db0| 31 32 0d 0a 48 65 69 67 | 68 74 20 3d 20 31 35 39 |12..Heig|ht = 159|
|00000dc0| 0d 0a 4e 61 6d 65 20 3d | 20 22 44 61 74 61 65 6e |..Name =| "Dataen|
|00000dd0| 76 69 72 6f 6e 6d 65 6e | 74 22 0d 0a 00 00 00 00 |vironmen|t"......|
|00000de0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 01 |........|........|
|00000df0| 00 00 00 06 63 75 72 73 | 6f 72 00 00 00 00 00 00 |....curs|or......|
|00000e00| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000e10| 01 00 00 00 a6 4c 65 66 | 74 20 3d 20 32 30 0d 0a |.....Lef|t = 20..|
|00000e20| 54 6f 70 20 3d 20 31 30 | 0d 0a 57 69 64 74 68 20 |Top = 10|..Width |
|00000e30| 3d 20 31 31 38 0d 0a 48 | 65 69 67 68 74 20 3d 20 |= 118..H|eight = |
|00000e40| 39 30 0d 0a 41 6c 69 61 | 73 20 3d 20 22 65 6d 70 |90..Alia|s = "emp|
|00000e50| 6c 6f 79 65 65 22 0d 0a | 4f 72 64 65 72 20 3d 20 |loyee"..|Order = |
|00000e60| 22 65 6d 70 5f 69 64 22 | 0d 0a 44 61 74 61 62 61 |"emp_id"|..Databa|
|00000e70| 73 65 20 3d 20 2e 2e 5c | 2e 2e 5c 64 61 74 61 5c |se = ..\|..\data\|
|00000e80| 74 65 73 74 64 61 74 61 | 2e 64 62 63 0d 0a 43 75 |testdata|.dbc..Cu|
|00000e90| 72 73 6f 72 53 6f 75 72 | 63 65 20 3d 20 22 65 6d |rsorSour|ce = "em|
|00000ea0| 70 6c 6f 79 65 65 22 0d | 0a 4e 61 6d 65 20 3d 20 |ployee".|.Name = |
|00000eb0| 22 43 75 72 73 6f 72 31 | 22 0d 0a 00 00 00 00 00 |"Cursor1|".......|
|00000ec0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000ed0| 00 00 00 00 00 00 01 00 | 00 00 06 63 75 72 73 6f |........|...curso|
|00000ee0| 72 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |r.......|........|
|00000ef0| 00 00 00 00 00 00 00 01 | 00 00 00 91 4c 65 66 74 |........|....Left|
|00000f00| 20 3d 20 31 36 30 0d 0a | 54 6f 70 20 3d 20 31 30 | = 160..|Top = 10|
|00000f10| 0d 0a 57 69 64 74 68 20 | 3d 20 31 31 38 0d 0a 48 |..Width |= 118..H|
|00000f20| 65 69 67 68 74 20 3d 20 | 39 30 0d 0a 41 6c 69 61 |eight = |90..Alia|
|00000f30| 73 20 3d 20 22 6f 72 64 | 65 72 73 22 0d 0a 44 61 |s = "ord|ers"..Da|
|00000f40| 74 61 62 61 73 65 20 3d | 20 2e 2e 5c 2e 2e 5c 64 |tabase =| ..\..\d|
|00000f50| 61 74 61 5c 74 65 73 74 | 64 61 74 61 2e 64 62 63 |ata\test|data.dbc|
|00000f60| 0d 0a 43 75 72 73 6f 72 | 53 6f 75 72 63 65 20 3d |..Cursor|Source =|
|00000f70| 20 22 6f 72 64 65 72 73 | 22 0d 0a 4e 61 6d 65 20 | "orders|"..Name |
|00000f80| 3d 20 22 43 75 72 73 6f | 72 32 22 0d 0a 00 00 00 |= "Curso|r2".....|
|00000f90| 00 00 00 00 00 00 00 00 | 00 00 00 00 01 00 00 01 |........|........|
|00000fa0| 92 50 52 4f 43 45 44 55 | 52 45 20 49 6e 69 74 0d |.PROCEDU|RE Init.|
|00000fb0| 0a 50 55 42 4c 49 43 20 | 6e 54 6f 74 61 6c 53 61 |.PUBLIC |nTotalSa|
|00000fc0| 6c 65 73 0d 0a 0d 0a 2a | 20 4d 61 6b 65 20 73 75 |les....*| Make su|
|00000fd0| 72 65 20 54 41 4c 4b 20 | 69 73 20 6f 66 66 2c 20 |re TALK |is off, |
|00000fe0| 73 6f 20 43 41 4c 43 20 | 72 65 73 75 6c 74 73 20 |so CALC |results |
|00000ff0| 74 6f 20 6e 6f 74 0d 0a | 2a 20 64 69 73 70 6c 61 |to not..|* displa|
|00001000| 79 20 6f 6e 20 73 63 72 | 65 65 6e 0d 0a 63 4f 6c |y on scr|een..cOl|
|00001010| 64 54 61 6c 6b 20 3d 20 | 53 59 53 28 31 30 33 29 |dTalk = |SYS(103)|
|00001020| 0d 0a 0d 0a 53 45 54 20 | 54 41 4c 4b 20 4f 46 46 |....SET |TALK OFF|
|00001030| 0d 0a 0d 0a 2a 20 43 41 | 4c 43 20 73 61 6c 65 73 |....* CA|LC sales|
|00001040| 20 74 6f 74 61 6c 20 66 | 6f 72 20 61 6c 6c 20 65 | total f|or all e|
|00001050| 6d 70 6c 6f 79 65 65 73 | 0d 0a 43 41 4c 43 55 4c |mployees|..CALCUL|
|00001060| 41 54 45 20 53 55 4d 28 | 6f 72 64 65 72 73 2e 6f |ATE SUM(|orders.o|
|00001070| 72 64 65 72 5f 61 6d 74 | 29 20 54 4f 20 6e 54 6f |rder_amt|) TO nTo|
|00001080| 74 61 6c 53 61 6c 65 73 | 0d 0a 0d 0a 2a 20 52 65 |talSales|....* Re|
|00001090| 74 75 72 6e 20 54 41 4c | 4b 20 73 65 74 74 69 6e |turn TAL|K settin|
|000010a0| 67 20 74 6f 20 70 72 65 | 76 69 6f 75 73 20 73 65 |g to pre|vious se|
|000010b0| 74 74 69 6e 67 0d 0a 53 | 45 54 20 54 41 4c 4b 20 |tting..S|ET TALK |
|000010c0| 26 63 4f 6c 64 54 61 6c | 6b 0d 0a 0d 0a 45 4e 44 |&cOldTal|k....END|
|000010d0| 50 52 4f 43 0d 0a 50 52 | 4f 43 45 44 55 52 45 20 |PROC..PR|OCEDURE |
|000010e0| 44 65 73 74 72 6f 79 0d | 0a 0d 0a 2a 20 52 65 6d |Destroy.|...* Rem|
|000010f0| 6f 76 65 20 74 68 65 20 | 50 55 42 4c 49 43 20 76 |ove the |PUBLIC v|
|00001100| 61 72 69 61 62 6c 65 20 | 66 72 6f 6d 20 6d 65 6d |ariable |from mem|
|00001110| 6f 72 79 0d 0a 52 45 4c | 45 41 53 45 20 6e 54 6f |ory..REL|EASE nTo|
|00001120| 74 61 6c 53 61 6c 65 73 | 0d 0a 45 4e 44 50 52 4f |talSales|..ENDPRO|
|00001130| 43 0d 0a 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |C.......|........|
|00001140| 00 00 00 00 00 00 00 00 | 00 01 00 00 01 60 fe f2 |........|.....`..|
|00001150| ff 1f 02 01 00 00 00 47 | 01 00 00 47 01 00 00 00 |.......G|...G....|
|00001160| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001170| 00 00 00 00 00 6d 21 02 | 00 00 00 25 00 00 00 bd |.....m!.|...%....|
|00001180| 00 00 00 00 00 00 00 ee | 00 00 00 09 00 00 00 dc |........|........|
|00001190| 00 00 00 00 00 00 00 00 | 00 00 00 fc 03 00 03 00 |........|........|
|000011a0| 55 00 00 48 00 07 00 37 | f7 00 00 fe 0f 00 54 f7 |U..H...7|......T.|
|000011b0| 01 00 10 fc 43 f8 03 67 | 5d fd fe 06 00 47 32 1f |....C..g|]....G2.|
|000011c0| fe 13 00 7d 28 f7 00 00 | c2 02 fc f4 02 00 f7 03 |...}(...|........|
|000011d0| 00 fd 03 fe 16 00 01 53 | 45 54 20 54 41 4c 4b 20 |.......S|ET TALK |
|000011e0| 26 63 4f 6c 64 54 61 6c | 6b 0a 03 00 55 04 00 0b |&cOldTal|k...U...|
|000011f0| 00 4e 54 4f 54 41 4c 53 | 41 4c 45 53 08 00 43 4f |.NTOTALS|ALES..CO|
|00001200| 4c 44 54 41 4c 4b 06 00 | 4f 52 44 45 52 53 09 00 |LDTALK..|ORDERS..|
|00001210| 4f 52 44 45 52 5f 41 4d | 54 0a 00 07 00 3c f7 00 |ORDER_AM|T....<..|
|00001220| 00 fe 03 00 55 01 00 0b | 00 4e 54 4f 54 41 4c 53 |....U...|.NTOTALS|
|00001230| 41 4c 45 53 04 00 49 6e | 69 74 2c 00 00 00 00 00 |ALES..In|it,.....|
|00001240| ff ff 07 00 44 65 73 74 | 72 6f 79 a2 00 00 00 00 |....Dest|roy.....|
|00001250| 00 ff ff 31 00 71 00 f4 | 00 62 00 33 01 63 01 33 |...1.q..|.b.3.c.3|
|00001260| 00 73 00 31 00 00 00 00 | 00 00 00 00 00 00 00 00 |.s.1....|........|
|00001270| 00 00 00 00 00 01 00 00 | 00 10 00 00 00 2a 01 00 |........|.....*..|
|00001280| 00 01 00 00 00 07 00 00 | 00 48 01 00 00 87 01 00 |........|.H......|
|00001290| 00 11 00 00 00 00 29 00 | 00 00 47 01 00 00 00 00 |......).|..G.....|
|000012a0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000012b0| 00 00 00 00 01 00 00 00 | 08 72 65 6c 61 74 69 6f |........|.relatio|
|000012c0| 6e 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |n.......|........|
|000012d0| 00 00 00 00 00 01 00 00 | 02 09 50 61 72 65 6e 74 |........|..Parent|
|000012e0| 41 6c 69 61 73 20 3d 20 | 22 65 6d 70 6c 6f 79 65 |Alias = |"employe|
|000012f0| 65 22 0d 0a 52 65 6c 61 | 74 69 6f 6e 61 6c 45 78 |e"..Rela|tionalEx|
|00001300| 70 72 20 3d 20 22 65 6d | 70 5f 69 64 22 0d 0a 43 |pr = "em|p_id"..C|
|00001310| 68 69 6c 64 41 6c 69 61 | 73 20 3d 20 22 6f 72 64 |hildAlia|s = "ord|
|00001320| 65 72 73 22 0d 0a 43 68 | 69 6c 64 4f 72 64 65 72 |ers"..Ch|ildOrder|
|00001330| 20 3d 20 22 65 6d 70 5f | 69 64 22 0d 0a 4e 61 6d | = "emp_|id"..Nam|
|00001340| 65 20 3d 20 22 52 65 6c | 61 74 69 6f 6e 31 22 0d |e = "Rel|ation1".|
|00001350| 0a 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001360| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001370| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001380| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001390| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000013a0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000013b0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000013c0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000013d0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000013e0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000013f0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001400| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001410| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001420| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001430| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001440| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001450| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001460| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001470| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001480| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001490| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000014a0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000014b0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000014c0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000014d0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000014e0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000014f0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001500| 00 00 00                |                         |...     |        |
+--------+-------------------------+-------------------------+--------+--------+