/ PC World Komputer 1998 October A / Pcwk10a98.iso / Lotus / LOTUS / 123 / CLASSEN.DLL / 303 / 53

< prev

next >

view JSON data

view as text

open on a Mac

open on a PC

+--------+-------------------------+-------------------------+--------+--------+
|00000000| 0c 00 02 00 00 01 01 00 | 00 00 0b 00 2c 01 00 00 |........|....,...|
|00000010| 5b 01 00 00 b8 01 00 00 | 61 02 00 00 a6 02 00 00 |[.......|a.......|
|00000020| f8 02 00 00 24 03 00 00 | 7c 03 00 00 e2 03 00 00 |....$...||.......|
|00000030| 0d 04 00 00 4c 04 00 00 | b5 04 00 00 fe 04 00 00 |....L...|........|
|00000040| 28 05 00 00 52 05 00 00 | af 05 00 00 da 05 00 00 |(...R...|........|
|00000050| eb 05 00 00 13 06 00 00 | 41 06 00 00 97 06 00 00 |........|A.......|
|00000060| fa 06 00 00 1b 07 00 00 | 61 07 00 00 94 07 00 00 |........|a.......|
|00000070| d5 07 00 00 11 08 00 00 | 53 08 00 00 83 08 00 00 |........|S.......|
|00000080| a7 08 00 00 12 09 00 00 | 61 09 00 00 9d 09 00 00 |........|a.......|
|00000090| fb 09 00 00 3d 0a 00 00 | 66 0a 00 00 d7 0a 00 00 |....=...|f.......|
|000000a0| 13 0b 00 00 67 0b 00 00 | b0 0b 00 00 11 0c 00 00 |....g...|........|
|000000b0| 54 0c 00 00 9e 0c 00 00 | d8 0c 00 00 2b 0d 00 00 |T.......|....+...|
|000000c0| 7a 0d 00 00 06 0e 00 00 | 3f 0e 00 00 99 0e 00 00 |z.......|?.......|
|000000d0| e7 0e 00 00 29 0f 00 00 | 66 0f 00 00 d4 0f 00 00 |....)...|f.......|
|000000e0| 47 10 00 00 77 10 00 00 | 04 11 00 00 4b 11 00 00 |G...w...|....K...|
|000000f0| e0 11 00 00 34 12 00 00 | aa 12 00 00 19 13 00 00 |....4...|........|
|00000100| 77 13 00 00 d5 13 00 00 | 11 14 00 00 52 14 00 00 |w.......|....R...|
|00000110| a4 14 00 00 da 14 00 00 | fd 14 00 00 b6 15 00 00 |........|........|
|00000120| 05 16 00 00 38 16 00 00 | 55 16 00 00 41 73 73 69 |....8...|U...Assi|
|00000130| 67 6e 73 20 61 6c 6c 20 | 64 61 74 61 20 72 61 6e |gns all |data ran|
|00000140| 67 65 73 20 66 6f 72 20 | 74 68 65 20 63 75 72 72 |ges for |the curr|
|00000150| 65 6e 74 20 63 68 61 72 | 74 2e 00 43 68 61 6e 67 |ent char|t..Chang|
|00000160| 65 73 20 74 68 65 20 69 | 6e 74 65 72 76 61 6c 73 |es the i|ntervals|
|00000170| 20 62 65 74 77 65 65 6e | 20 58 2d 61 78 69 73 2c | between| X-axis,|
|00000180| 20 59 2d 61 78 69 73 2c | 20 6f 72 20 32 6e 64 20 | Y-axis,| or 2nd |
|00000190| 59 2d 61 78 69 73 20 74 | 69 63 6b 20 6d 61 72 6b |Y-axis t|ick mark|
|000001a0| 73 20 69 6e 20 74 68 65 | 20 63 75 72 72 65 6e 74 |s in the| current|
|000001b0| 20 63 68 61 72 74 2e 00 | 43 72 65 61 74 65 73 2c | chart..|Creates,|
|000001c0| 20 66 6f 72 20 74 68 65 | 20 63 75 72 72 65 6e 74 | for the| current|
|000001d0| 20 63 68 61 72 74 2c 20 | 61 20 73 63 61 6c 65 20 | chart, |a scale |
|000001e0| 66 6f 72 20 74 68 65 20 | 58 2d 61 78 69 73 2c 20 |for the |X-axis, |
|000001f0| 59 2d 61 78 69 73 2c 20 | 6f 72 20 32 6e 64 20 59 |Y-axis, |or 2nd Y|
|00000200| 2d 61 78 69 73 20 74 68 | 61 74 20 64 69 73 70 6c |-axis th|at displ|
|00000210| 61 79 73 20 6f 6e 6c 79 | 20 74 68 65 20 64 61 74 |ays only| the dat|
|00000220| 61 20 74 68 61 74 20 66 | 61 6c 6c 73 20 62 65 74 |a that f|alls bet|
|00000230| 77 65 65 6e 20 28 61 6e | 64 20 69 6e 63 6c 75 64 |ween (an|d includ|
|00000240| 65 73 29 20 75 70 70 65 | 72 5f 6c 69 6d 69 74 20 |es) uppe|r_limit |
|00000250| 61 6e 64 20 6c 6f 77 65 | 72 5f 6c 69 6d 69 74 2e |and lowe|r_limit.|
|00000260| 00 53 70 65 63 69 66 69 | 65 73 20 74 68 65 20 74 |.Specifi|es the t|
|00000270| 79 70 65 20 6f 66 20 73 | 63 61 6c 65 20 74 6f 20 |ype of s|cale to |
|00000280| 75 73 65 20 66 6f 72 20 | 61 6e 20 61 78 69 73 20 |use for |an axis |
|00000290| 69 6e 20 74 68 65 20 63 | 75 72 72 65 6e 74 20 63 |in the c|urrent c|
|000002a0| 68 61 72 74 2e 00 49 73 | 20 75 73 65 64 20 74 6f |hart..Is| used to|
|000002b0| 20 73 70 65 63 69 66 79 | 20 6d 61 6a 6f 72 20 61 | specify| major a|
|000002c0| 6e 64 20 6d 69 6e 6f 72 | 20 74 69 63 6b 20 6d 61 |nd minor| tick ma|
|000002d0| 72 6b 73 20 66 6f 72 20 | 61 6e 20 61 78 69 73 20 |rks for |an axis |
|000002e0| 69 6e 20 74 68 65 20 73 | 70 65 63 69 66 69 65 64 |in the s|pecified|
|000002f0| 20 63 68 61 72 74 2e 00 | 43 68 61 6e 67 65 73 20 | chart..|Changes |
|00000300| 61 6e 20 61 78 69 73 20 | 74 69 74 6c 65 20 69 6e |an axis |title in|
|00000310| 20 74 68 65 20 63 75 72 | 72 65 6e 74 20 63 68 61 | the cur|rent cha|
|00000320| 72 74 2e 00 43 68 61 6e | 67 65 73 20 74 68 65 20 |rt..Chan|ges the |
|00000330| 6d 61 67 6e 69 74 75 64 | 65 20 6f 66 20 74 68 65 |magnitud|e of the|
|00000340| 20 61 78 69 73 20 75 6e | 69 74 73 20 61 6e 64 20 | axis un|its and |
|00000350| 74 68 65 20 61 78 69 73 | 2d 75 6e 69 74 20 74 69 |the axis|-unit ti|
|00000360| 74 6c 65 73 20 66 6f 72 | 20 74 68 65 20 63 75 72 |tles for| the cur|
|00000370| 72 65 6e 74 20 63 68 61 | 72 74 2e 00 43 72 65 61 |rent cha|rt..Crea|
|00000380| 74 65 73 20 6c 61 62 65 | 6c 73 20 66 6f 72 20 64 |tes labe|ls for d|
|00000390| 61 74 61 20 70 6f 69 6e | 74 73 20 6f 72 20 62 61 |ata poin|ts or ba|
|000003a0| 72 73 20 69 6e 20 74 68 | 65 20 63 75 72 72 65 6e |rs in th|e curren|
|000003b0| 74 20 63 68 61 72 74 2c | 20 75 73 69 6e 67 20 64 |t chart,| using d|
|000003c0| 61 74 61 20 69 6e 20 6c | 61 62 65 6c 5f 72 61 6e |ata in l|abel_ran|
|000003d0| 67 65 20 61 73 20 74 68 | 65 20 6c 61 62 65 6c 73 |ge as th|e labels|
|000003e0| 2e 00 41 64 64 73 20 63 | 68 61 72 74 20 66 6f 6f |..Adds c|hart foo|
|000003f0| 74 6e 6f 74 65 73 20 74 | 6f 20 74 68 65 20 63 75 |tnotes t|o the cu|
|00000400| 72 72 65 6e 74 20 63 68 | 61 72 74 2e 00 44 69 73 |rrent ch|art..Dis|
|00000410| 70 6c 61 79 73 20 6f 72 | 20 68 69 64 65 73 20 67 |plays or| hides g|
|00000420| 72 69 64 20 6c 69 6e 65 | 73 20 66 6f 72 20 61 6e |rid line|s for an|
|00000430| 20 61 78 69 73 20 69 6e | 20 74 68 65 20 63 75 72 | axis in| the cur|
|00000440| 72 65 6e 74 20 63 68 61 | 72 74 2e 00 43 72 65 61 |rent cha|rt..Crea|
|00000450| 74 65 73 20 6c 65 67 65 | 6e 64 20 6c 61 62 65 6c |tes lege|nd label|
|00000460| 73 20 74 68 61 74 20 69 | 64 65 6e 74 69 66 79 20 |s that i|dentify |
|00000470| 74 68 65 20 63 6f 6c 6f | 72 73 2c 20 73 79 6d 62 |the colo|rs, symb|
|00000480| 6f 6c 73 2c 20 6f 72 20 | 70 61 74 74 65 72 6e 73 |ols, or |patterns|
|00000490| 20 6f 66 20 74 68 65 20 | 63 75 72 72 65 6e 74 20 | of the |current |
|000004a0| 63 68 61 72 74 27 73 20 | 64 61 74 61 20 73 65 72 |chart's |data ser|
|000004b0| 69 65 73 2e 00 44 72 61 | 77 73 20 61 20 63 68 61 |ies..Dra|ws a cha|
|000004c0| 72 74 20 61 74 20 6c 6f | 63 61 74 69 6f 6e 2c 20 |rt at lo|cation, |
|000004d0| 75 73 69 6e 67 20 64 61 | 74 61 20 66 72 6f 6d 20 |using da|ta from |
|000004e0| 74 68 65 20 63 75 72 72 | 65 6e 74 6c 79 20 73 65 |the curr|ently se|
|000004f0| 6c 65 63 74 65 64 20 72 | 61 6e 67 65 2e 00 43 72 |lected r|ange..Cr|
|00000500| 65 61 74 65 73 20 6c 61 | 62 65 6c 73 20 66 6f 72 |eates la|bels for|
|00000510| 20 74 68 65 20 63 75 72 | 72 65 6e 74 20 70 69 65 | the cur|rent pie|
|00000520| 20 63 68 61 72 74 2e 00 | 45 78 70 6c 6f 64 65 73 | chart..|Explodes|
|00000530| 20 73 6c 69 63 65 73 20 | 69 6e 20 74 68 65 20 63 | slices |in the c|
|00000540| 75 72 72 65 6e 74 20 70 | 69 65 20 63 68 61 72 74 |urrent p|ie chart|
|00000550| 2e 00 53 65 74 73 20 74 | 68 65 20 64 61 74 61 20 |..Sets t|he data |
|00000560| 72 61 6e 67 65 2c 20 73 | 65 72 69 65 73 20 74 79 |range, s|eries ty|
|00000570| 70 65 20 61 6e 64 20 32 | 6e 64 20 59 20 61 78 69 |pe and 2|nd Y axi|
|00000580| 73 20 66 6c 61 67 20 66 | 6f 72 20 61 20 64 61 74 |s flag f|or a dat|
|00000590| 61 20 73 65 72 69 65 73 | 20 69 6e 20 74 68 65 20 |a series| in the |
|000005a0| 63 75 72 72 65 6e 74 20 | 63 68 61 72 74 2e 00 44 |current |chart..D|
|000005b0| 65 6c 65 74 65 73 20 74 | 68 65 20 73 65 72 69 65 |eletes t|he serie|
|000005c0| 73 20 66 72 6f 6d 20 74 | 68 65 20 63 75 72 72 65 |s from t|he curre|
|000005d0| 6e 74 20 63 68 61 72 74 | 2e 00 52 65 6e 61 6d 65 |nt chart|..Rename|
|000005e0| 73 20 61 20 63 68 61 72 | 74 2e 00 41 64 64 73 20 |s a char|t..Adds |
|000005f0| 63 68 61 72 74 20 74 69 | 74 6c 65 73 20 74 6f 20 |chart ti|tles to |
|00000600| 74 68 65 20 63 75 72 72 | 65 6e 74 20 63 68 61 72 |the curr|ent char|
|00000610| 74 2e 00 53 65 74 73 20 | 74 68 65 20 74 79 70 65 |t..Sets |the type|
|00000620| 20 6f 66 20 63 68 61 72 | 74 20 66 6f 72 20 74 68 | of char|t for th|
|00000630| 65 20 63 75 72 72 65 6e | 74 20 63 68 61 72 74 2e |e curren|t chart.|
|00000640| 00 43 6f 70 69 65 73 20 | 74 68 65 20 63 6f 6e 74 |.Copies |the cont|
|00000650| 65 6e 74 73 20 6f 66 20 | 73 6f 75 72 63 65 5f 6c |ents of |source_l|
|00000660| 6f 63 61 74 69 6f 6e 20 | 74 6f 20 74 68 65 20 72 |ocation |to the r|
|00000670| 6f 77 73 20 69 6d 6d 65 | 64 69 61 74 65 6c 79 20 |ows imme|diately |
|00000680| 62 65 6c 6f 77 20 74 61 | 72 67 65 74 5f 6c 6f 63 |below ta|rget_loc|
|00000690| 61 74 69 6f 6e 2e 00 43 | 6f 70 69 65 73 20 74 68 |ation..C|opies th|
|000006a0| 65 20 63 6f 6e 74 65 6e | 74 73 20 6f 66 20 73 6f |e conten|ts of so|
|000006b0| 75 72 63 65 5f 6c 6f 63 | 61 74 69 6f 6e 20 74 6f |urce_loc|ation to|
|000006c0| 20 74 68 65 20 63 6f 6c | 75 6d 6e 73 20 69 6d 6d | the col|umns imm|
|000006d0| 65 64 69 61 74 65 6c 79 | 20 74 6f 20 74 68 65 20 |ediately| to the |
|000006e0| 72 69 67 68 74 20 6f 66 | 20 74 61 72 67 65 74 5f |right of| target_|
|000006f0| 6c 6f 63 61 74 69 6f 6e | 2e 00 45 72 61 73 65 73 |location|..Erases|
|00000700| 20 74 68 65 20 63 6f 6e | 74 65 6e 74 73 20 6f 66 | the con|tents of|
|00000710| 20 6c 6f 63 61 74 69 6f | 6e 2e 00 43 6f 70 69 65 | locatio|n..Copie|
|00000720| 73 20 74 68 65 20 63 6f | 6e 74 65 6e 74 73 20 6f |s the co|ntents o|
|00000730| 66 20 73 6f 75 72 63 65 | 5f 6c 6f 63 61 74 69 6f |f source|_locatio|
|00000740| 6e 20 74 6f 20 74 61 72 | 67 65 74 5f 6c 6f 63 61 |n to tar|get_loca|
|00000750| 74 69 6f 6e 20 61 73 20 | 61 20 6c 61 62 65 6c 2e |tion as |a label.|
|00000760| 00 45 6e 74 65 72 73 20 | 61 20 6e 75 6d 62 65 72 |.Enters |a number|
|00000770| 20 6f 72 20 6c 65 66 74 | 2d 61 6c 69 67 6e 65 64 | or left|-aligned|
|00000780| 20 6c 61 62 65 6c 20 69 | 6e 20 6c 6f 63 61 74 69 | label i|n locati|
|00000790| 6f 6e 2e 00 45 6e 74 65 | 72 73 20 61 20 6e 75 6d |on..Ente|rs a num|
|000007a0| 62 65 72 20 6f 72 20 6c | 65 66 74 2d 61 6c 69 67 |ber or l|eft-alig|
|000007b0| 6e 65 64 20 6c 61 62 65 | 6c 20 69 6e 20 61 20 63 |ned labe|l in a c|
|000007c0| 65 6c 6c 20 77 69 74 68 | 69 6e 20 6c 6f 63 61 74 |ell with|in locat|
|000007d0| 69 6f 6e 2e 00 52 65 63 | 61 6c 63 75 6c 61 74 65 |ion..Rec|alculate|
|000007e0| 73 20 74 68 65 20 76 61 | 6c 75 65 73 20 69 6e 20 |s the va|lues in |
|000007f0| 6c 6f 63 61 74 69 6f 6e | 2c 20 70 72 6f 63 65 65 |location|, procee|
|00000800| 64 69 6e 67 20 72 6f 77 | 20 62 79 20 72 6f 77 2e |ding row| by row.|
|00000810| 00 52 65 63 61 6c 63 75 | 6c 61 74 65 73 20 74 68 |.Recalcu|lates th|
|00000820| 65 20 76 61 6c 75 65 73 | 20 69 6e 20 6c 6f 63 61 |e values| in loca|
|00000830| 74 69 6f 6e 2c 20 70 72 | 6f 63 65 65 64 69 6e 67 |tion, pr|oceeding|
|00000840| 20 63 6f 6c 75 6d 6e 20 | 62 79 20 63 6f 6c 75 6d | column |by colum|
|00000850| 6e 2e 00 43 6f 6d 6d 69 | 74 73 20 70 65 6e 64 69 |n..Commi|ts pendi|
|00000860| 6e 67 20 65 78 74 65 72 | 6e 61 6c 20 64 61 74 61 |ng exter|nal data|
|00000870| 62 61 73 65 20 74 72 61 | 6e 73 61 63 74 69 6f 6e |base tra|nsaction|
|00000880| 73 2e 00 41 64 64 73 20 | 6e 65 77 20 72 65 63 6f |s..Adds |new reco|
|00000890| 72 64 73 20 74 6f 20 64 | 61 74 61 62 61 73 65 5f |rds to d|atabase_|
|000008a0| 74 61 62 6c 65 2e 00 45 | 73 74 61 62 6c 69 73 68 |table..E|stablish|
|000008b0| 65 73 20 61 20 63 6f 6e | 6e 65 63 74 69 6f 6e 20 |es a con|nection |
|000008c0| 74 6f 20 61 6e 20 65 78 | 74 65 72 6e 61 6c 20 64 |to an ex|ternal d|
|000008d0| 61 74 61 62 61 73 65 20 | 74 61 62 6c 65 20 73 6f |atabase |table so|
|000008e0| 20 79 6f 75 20 63 61 6e | 20 75 73 65 20 74 68 65 | you can| use the|
|000008f0| 20 74 61 62 6c 65 20 77 | 69 74 68 20 6f 74 68 65 | table w|ith othe|
|00000900| 72 20 31 2d 32 2d 33 20 | 63 6f 6d 6d 61 6e 64 73 |r 1-2-3 |commands|
|00000910| 2e 00 53 65 74 73 20 75 | 70 20 74 68 65 20 73 74 |..Sets u|p the st|
|00000920| 72 75 63 74 75 72 65 20 | 66 6f 72 20 61 6e 64 20 |ructure |for and |
|00000930| 63 6f 6e 6e 65 63 74 73 | 20 74 6f 20 61 20 6e 65 |connects| to a ne|
|00000940| 77 20 74 61 62 6c 65 20 | 69 6e 20 61 6e 20 65 78 |w table |in an ex|
|00000950| 74 65 72 6e 61 6c 20 64 | 61 74 61 62 61 73 65 2e |ternal d|atabase.|
|00000960| 00 44 65 6c 65 74 65 73 | 20 74 68 65 20 72 65 63 |.Deletes| the rec|
|00000970| 6f 72 64 73 20 66 72 6f | 6d 20 64 61 74 61 62 61 |ords fro|m databa|
|00000980| 73 65 2d 74 61 62 6c 65 | 20 74 68 61 74 20 6d 65 |se-table| that me|
|00000990| 65 74 20 63 72 69 74 65 | 72 69 61 2e 00 44 69 73 |et crite|ria..Dis|
|000009a0| 63 6f 6e 6e 65 63 74 73 | 20 61 6e 20 65 78 74 65 |connects| an exte|
|000009b0| 72 6e 61 6c 20 74 61 62 | 6c 65 2c 20 65 6e 64 69 |rnal tab|le, endi|
|000009c0| 6e 67 20 61 6c 6c 20 64 | 61 74 61 20 65 78 63 68 |ng all d|ata exch|
|000009d0| 61 6e 67 65 20 62 65 74 | 77 65 65 6e 20 31 2d 32 |ange bet|ween 1-2|
|000009e0| 2d 33 20 61 6e 64 20 74 | 68 65 20 65 78 74 65 72 |-3 and t|he exter|
|000009f0| 6e 61 6c 20 74 61 62 6c | 65 2e 00 4c 6f 63 61 74 |nal tabl|e..Locat|
|00000a00| 65 73 20 61 6e 64 20 73 | 65 6c 65 63 74 73 20 72 |es and s|elects r|
|00000a10| 65 63 6f 72 64 73 20 69 | 6e 20 64 61 74 61 62 61 |ecords i|n databa|
|00000a20| 73 65 5f 74 61 62 6c 65 | 20 74 68 61 74 20 6d 65 |se_table| that me|
|00000a30| 65 74 20 63 72 69 74 65 | 72 69 61 2e 00 53 65 6e |et crite|ria..Sen|
|00000a40| 64 73 20 61 20 63 6f 6d | 6d 61 6e 64 20 74 6f 20 |ds a com|mand to |
|00000a50| 61 6e 20 65 78 74 65 72 | 6e 61 6c 20 64 61 74 61 |an exter|nal data|
|00000a60| 62 61 73 65 2e 00 41 64 | 64 73 20 61 20 66 69 65 |base..Ad|ds a fie|
|00000a70| 6c 64 20 74 6f 20 74 68 | 65 20 63 75 72 72 65 6e |ld to th|e curren|
|00000a80| 74 6c 79 20 73 65 6c 65 | 63 74 65 64 20 71 75 65 |tly sele|cted que|
|00000a90| 72 79 20 74 61 62 6c 65 | 2e 20 54 68 65 20 66 69 |ry table|. The fi|
|00000aa0| 65 6c 64 20 69 73 20 64 | 69 73 70 6c 61 79 65 64 |eld is d|isplayed|
|00000ab0| 20 61 73 20 74 68 65 20 | 6c 61 73 74 20 66 69 65 | as the |last fie|
|00000ac0| 6c 64 20 69 6e 20 74 68 | 65 20 71 75 65 72 79 20 |ld in th|e query |
|00000ad0| 74 61 62 6c 65 2e 00 50 | 65 72 66 6f 72 6d 73 20 |table..P|erforms |
|00000ae0| 63 61 6c 63 75 6c 61 74 | 69 6f 6e 73 20 6f 6e 20 |calculat|ions on |
|00000af0| 67 72 6f 75 70 73 20 6f | 66 20 64 61 74 61 20 66 |groups o|f data f|
|00000b00| 72 6f 6d 20 61 20 71 75 | 65 72 79 20 74 61 62 6c |rom a qu|ery tabl|
|00000b10| 65 2e 00 53 70 65 63 69 | 66 69 65 73 20 74 68 65 |e..Speci|fies the|
|00000b20| 20 66 69 65 6c 64 73 20 | 74 68 61 74 20 79 6f 75 | fields |that you|
|00000b30| 20 77 61 6e 74 20 74 6f | 20 61 70 70 65 61 72 20 | want to| appear |
|00000b40| 69 6e 20 74 68 65 20 63 | 75 72 72 65 6e 74 6c 79 |in the c|urrently|
|00000b50| 20 73 65 6c 65 63 74 65 | 64 20 71 75 65 72 79 20 | selecte|d query |
|00000b60| 74 61 62 6c 65 2e 00 43 | 6f 70 69 65 73 20 74 6f |table..C|opies to|
|00000b70| 20 74 68 65 20 43 6c 69 | 70 62 6f 61 72 64 20 74 | the Cli|pboard t|
|00000b80| 68 65 20 53 51 4c 20 63 | 6f 6d 6d 61 6e 64 20 65 |he SQL c|ommand e|
|00000b90| 71 75 69 76 61 6c 65 6e | 74 20 74 6f 20 74 68 65 |quivalen|t to the|
|00000ba0| 20 63 75 72 72 65 6e 74 | 20 71 75 65 72 79 2e 00 | current| query..|
|00000bb0| 53 70 65 63 69 66 69 65 | 73 20 63 72 69 74 65 72 |Specifie|s criter|
|00000bc0| 69 61 20 74 6f 20 64 65 | 74 65 72 6d 69 6e 65 20 |ia to de|termine |
|00000bd0| 77 68 69 63 68 20 72 65 | 63 6f 72 64 73 20 61 70 |which re|cords ap|
|00000be0| 70 65 61 72 20 69 6e 20 | 61 20 6e 65 77 20 6f 72 |pear in |a new or|
|00000bf0| 20 63 75 72 72 65 6e 74 | 6c 79 20 73 65 6c 65 63 | current|ly selec|
|00000c00| 74 65 64 20 71 75 65 72 | 79 20 74 61 62 6c 65 2e |ted quer|y table.|
|00000c10| 00 43 68 61 6e 67 65 73 | 20 74 68 65 20 64 61 74 |.Changes| the dat|
|00000c20| 61 62 61 73 65 20 74 61 | 62 6c 65 20 66 6f 72 20 |abase ta|ble for |
|00000c30| 74 68 65 20 63 75 72 72 | 65 6e 74 6c 79 20 73 65 |the curr|ently se|
|00000c40| 6c 65 63 74 65 64 20 71 | 75 65 72 79 20 74 61 62 |lected q|uery tab|
|00000c50| 6c 65 2e 00 41 6c 6c 6f | 77 73 20 79 6f 75 20 74 |le..Allo|ws you t|
|00000c60| 6f 20 71 75 65 72 79 20 | 6d 75 6c 74 69 70 6c 65 |o query |multiple|
|00000c70| 20 64 61 74 61 62 61 73 | 65 20 74 61 62 6c 65 73 | databas|e tables|
|00000c80| 20 74 68 61 74 20 63 6f | 6e 74 61 69 6e 20 61 20 | that co|ntain a |
|00000c90| 63 6f 6d 6d 6f 6e 20 66 | 69 65 6c 64 2e 00 41 73 |common f|ield..As|
|00000ca0| 73 69 67 6e 73 20 61 20 | 6e 65 77 20 6e 61 6d 65 |signs a |new name|
|00000cb0| 20 74 6f 20 74 68 65 20 | 63 75 72 72 65 6e 74 6c | to the |currentl|
|00000cc0| 79 20 73 65 6c 65 63 74 | 65 64 20 71 75 65 72 79 |y select|ed query|
|00000cd0| 20 74 61 62 6c 65 2e 00 | 43 72 65 61 74 65 73 20 | table..|Creates |
|00000ce0| 61 20 71 75 65 72 79 20 | 74 61 62 6c 65 20 74 68 |a query |table th|
|00000cf0| 61 74 20 63 6f 6e 74 61 | 69 6e 73 20 74 68 65 20 |at conta|ins the |
|00000d00| 72 65 63 6f 72 64 73 20 | 79 6f 75 20 65 78 74 72 |records |you extr|
|00000d10| 61 63 74 20 66 72 6f 6d | 20 61 20 64 61 74 61 62 |act from| a datab|
|00000d20| 61 73 65 20 74 61 62 6c | 65 2e 00 53 70 65 63 69 |ase tabl|e..Speci|
|00000d30| 66 69 65 73 20 6f 70 74 | 69 6f 6e 73 20 66 6f 72 |fies opt|ions for|
|00000d40| 20 6d 61 6e 69 70 75 6c | 61 74 69 6e 67 20 64 61 | manipul|ating da|
|00000d50| 74 61 20 69 6e 20 74 68 | 65 20 63 75 72 72 65 6e |ta in th|e curren|
|00000d60| 74 6c 79 20 73 65 6c 65 | 63 74 65 64 20 71 75 65 |tly sele|cted que|
|00000d70| 72 79 20 74 61 62 6c 65 | 2e 00 55 70 64 61 74 65 |ry table|..Update|
|00000d80| 73 20 72 65 63 6f 72 64 | 73 20 69 6e 20 74 68 65 |s record|s in the|
|00000d90| 20 63 75 72 72 65 6e 74 | 6c 79 20 73 65 6c 65 63 | current|ly selec|
|00000da0| 74 65 64 20 71 75 65 72 | 79 20 74 61 62 6c 65 20 |ted quer|y table |
|00000db0| 74 6f 20 72 65 66 6c 65 | 63 74 20 63 68 61 6e 67 |to refle|ct chang|
|00000dc0| 65 73 20 6d 61 64 65 20 | 74 6f 20 74 68 65 20 64 |es made |to the d|
|00000dd0| 61 74 61 62 61 73 65 20 | 74 61 62 6c 65 2c 20 71 |atabase |table, q|
|00000de0| 75 65 72 79 20 6f 70 74 | 69 6f 6e 73 2c 20 63 72 |uery opt|ions, cr|
|00000df0| 69 74 65 72 69 61 2c 20 | 6f 72 20 61 67 67 72 65 |iteria, |or aggre|
|00000e00| 67 61 74 65 2e 00 52 65 | 6d 6f 76 65 73 20 61 20 |gate..Re|moves a |
|00000e10| 66 69 65 6c 64 20 66 72 | 6f 6d 20 74 68 65 20 63 |field fr|om the c|
|00000e20| 75 72 72 65 6e 74 6c 79 | 20 73 65 6c 65 63 74 65 |urrently| selecte|
|00000e30| 64 20 71 75 65 72 79 20 | 74 61 62 6c 65 2e 00 53 |d query |table..S|
|00000e40| 70 65 63 69 66 69 65 73 | 20 61 6e 20 61 6c 69 61 |pecifies| an alia|
|00000e50| 73 20 66 69 65 6c 64 20 | 6e 61 6d 65 20 66 6f 72 |s field |name for|
|00000e60| 20 66 69 65 6c 64 20 74 | 6f 20 64 69 73 70 6c 61 | field t|o displa|
|00000e70| 79 20 69 6e 20 74 68 65 | 20 63 75 72 72 65 6e 74 |y in the| current|
|00000e80| 6c 79 20 73 65 6c 65 63 | 74 65 64 20 71 75 65 72 |ly selec|ted quer|
|00000e90| 79 20 74 61 62 6c 65 2e | 00 41 72 72 61 6e 67 65 |y table.|.Arrange|
|00000ea0| 73 20 64 61 74 61 20 69 | 6e 20 74 68 65 20 63 75 |s data i|n the cu|
|00000eb0| 72 72 65 6e 74 6c 79 20 | 73 65 6c 65 63 74 65 64 |rrently |selected|
|00000ec0| 20 71 75 65 72 79 20 74 | 61 62 6c 65 20 69 6e 20 | query t|able in |
|00000ed0| 74 68 65 20 6f 72 64 65 | 72 20 79 6f 75 20 73 70 |the orde|r you sp|
|00000ee0| 65 63 69 66 79 2e 00 44 | 65 66 69 6e 65 73 20 61 |ecify..D|efines a|
|00000ef0| 20 73 6f 72 74 20 6b 65 | 79 20 74 6f 20 62 65 20 | sort ke|y to be |
|00000f00| 75 73 65 64 20 62 79 20 | 61 20 73 75 62 73 65 71 |used by |a subseq|
|00000f10| 75 65 6e 74 20 51 55 45 | 52 59 2d 53 4f 52 54 20 |uent QUE|RY-SORT |
|00000f20| 63 6f 6d 6d 61 6e 64 2e | 00 43 6c 65 61 72 73 20 |command.|.Clears |
|00000f30| 61 6c 6c 20 73 6f 72 74 | 20 6b 65 79 73 20 66 6f |all sort| keys fo|
|00000f40| 72 20 74 68 65 20 63 75 | 72 72 65 6e 74 6c 79 20 |r the cu|rrently |
|00000f50| 73 65 6c 65 63 74 65 64 | 20 71 75 65 72 79 20 74 |selected| query t|
|00000f60| 61 62 6c 65 2e 00 55 70 | 67 72 61 64 65 73 20 61 |able..Up|grades a|
|00000f70| 20 71 75 65 72 79 20 66 | 72 6f 6d 20 61 20 70 72 | query f|rom a pr|
|00000f80| 65 76 69 6f 75 73 20 76 | 65 72 73 69 6f 6e 20 6f |evious v|ersion o|
|00000f90| 66 20 31 2d 32 2d 33 20 | 73 6f 20 74 68 61 74 20 |f 1-2-3 |so that |
|00000fa0| 69 74 20 77 6f 72 6b 73 | 20 77 69 74 68 20 74 68 |it works| with th|
|00000fb0| 65 20 51 75 65 72 79 20 | 63 6f 6d 6d 61 6e 64 73 |e Query |commands|
|00000fc0| 20 69 6e 20 31 2d 32 2d | 33 20 52 65 6c 65 61 73 | in 1-2-|3 Releas|
|00000fd0| 65 20 35 00 41 70 70 6c | 69 65 73 20 61 6e 79 20 |e 5.Appl|ies any |
|00000fe0| 63 68 61 6e 67 65 73 20 | 79 6f 75 20 6d 61 6b 65 |changes |you make|
|00000ff0| 20 74 6f 20 72 65 63 6f | 72 64 73 20 69 6e 20 74 | to reco|rds in t|
|00001000| 68 65 20 63 75 72 72 65 | 6e 74 6c 79 20 73 65 6c |he curre|ntly sel|
|00001010| 65 63 74 65 64 20 71 75 | 65 72 79 20 74 61 62 6c |ected qu|ery tabl|
|00001020| 65 20 74 6f 20 74 68 65 | 20 63 6f 72 72 65 73 70 |e to the| corresp|
|00001030| 6f 6e 64 69 6e 67 20 64 | 61 74 61 62 61 73 65 20 |onding d|atabase |
|00001040| 74 61 62 6c 65 2e 00 43 | 61 6e 63 65 6c 73 20 70 |table..C|ancels p|
|00001050| 65 6e 64 69 6e 67 20 65 | 78 74 65 72 6e 61 6c 20 |ending e|xternal |
|00001060| 64 61 74 61 62 61 73 65 | 20 74 72 61 6e 73 61 63 |database| transac|
|00001070| 74 69 6f 6e 73 2e 00 53 | 65 6e 64 73 20 61 6e 20 |tions..S|ends an |
|00001080| 53 51 4c 20 73 79 6e 74 | 61 78 20 63 6f 6d 6d 61 |SQL synt|ax comma|
|00001090| 6e 64 20 73 74 72 69 6e | 67 20 74 6f 20 61 6e 20 |nd strin|g to an |
|000010a0| 65 78 74 65 72 6e 61 6c | 20 64 61 74 61 62 61 73 |external| databas|
|000010b0| 65 20 64 72 69 76 65 72 | 2c 20 61 67 61 69 6e 73 |e driver|, agains|
|000010c0| 74 20 74 68 65 20 64 61 | 74 61 62 61 73 65 20 74 |t the da|tabase t|
|000010d0| 68 61 74 20 63 6f 6e 74 | 61 69 6e 73 20 74 68 65 |hat cont|ains the|
|000010e0| 20 73 70 65 63 69 66 69 | 65 64 20 65 78 74 65 72 | specifi|ed exter|
|000010f0| 6e 61 6c 20 64 61 74 61 | 62 61 73 65 20 74 61 62 |nal data|base tab|
|00001100| 6c 65 2e 00 53 70 65 63 | 69 66 69 65 73 20 61 20 |le..Spec|ifies a |
|00001110| 72 61 6e 67 65 20 74 6f | 20 6d 61 6b 65 20 61 6e |range to| make an|
|00001120| 20 4f 4c 45 20 6f 72 20 | 44 44 45 20 6c 69 6e 6b | OLE or |DDE link|
|00001130| 20 74 6f 20 28 61 20 64 | 65 73 74 69 6e 61 74 69 | to (a d|estinati|
|00001140| 6f 6e 20 72 61 6e 67 65 | 29 2e 00 57 69 74 68 6f |on range|)..Witho|
|00001150| 75 74 20 75 73 69 6e 67 | 20 74 68 65 20 43 6c 69 |ut using| the Cli|
|00001160| 70 62 6f 61 72 64 2c 20 | 63 72 65 61 74 65 73 20 |pboard, |creates |
|00001170| 61 20 6c 69 6e 6b 20 62 | 65 74 77 65 65 6e 20 74 |a link b|etween t|
|00001180| 68 65 20 63 75 72 72 65 | 6e 74 20 77 6f 72 6b 73 |he curre|nt works|
|00001190| 68 65 65 74 20 66 69 6c | 65 20 61 6e 64 20 61 6e |heet fil|e and an|
|000011a0| 6f 74 68 65 72 20 57 69 | 6e 64 6f 77 73 20 61 70 |other Wi|ndows ap|
|000011b0| 70 6c 69 63 61 74 69 6f | 6e 20 74 68 61 74 20 73 |plicatio|n that s|
|000011c0| 75 70 70 6f 72 74 73 20 | 44 44 45 20 6f 72 20 4f |upports |DDE or O|
|000011d0| 4c 45 20 61 73 20 61 20 | 73 65 72 76 65 72 2e 00 |LE as a |server..|
|000011e0| 44 65 61 63 74 69 76 61 | 74 65 73 20 61 20 44 44 |Deactiva|tes a DD|
|000011f0| 45 20 6f 72 20 4f 4c 45 | 20 6c 69 6e 6b 20 69 6e |E or OLE| link in|
|00001200| 20 74 68 65 20 63 75 72 | 72 65 6e 74 20 77 6f 72 | the cur|rent wor|
|00001210| 6b 73 68 65 65 74 2c 20 | 62 75 74 20 6c 65 61 76 |ksheet, |but leav|
|00001220| 65 73 20 74 68 65 20 6c | 69 6e 6b 20 69 6e 74 61 |es the l|ink inta|
|00001230| 63 74 2e 00 44 65 6c 65 | 74 65 73 20 61 20 44 44 |ct..Dele|tes a DD|
|00001240| 45 20 6f 72 20 4f 4c 45 | 20 6c 69 6e 6b 20 69 6e |E or OLE| link in|
|00001250| 20 74 68 65 20 63 75 72 | 72 65 6e 74 20 77 6f 72 | the cur|rent wor|
|00001260| 6b 73 68 65 65 74 2c 20 | 62 75 74 20 6c 65 61 76 |ksheet, |but leav|
|00001270| 65 73 20 74 68 65 20 76 | 61 6c 75 65 73 20 6f 62 |es the v|alues ob|
|00001280| 74 61 69 6e 65 64 20 74 | 68 72 6f 75 67 68 20 74 |tained t|hrough t|
|00001290| 68 65 20 6c 69 6e 6b 20 | 69 6e 20 74 68 65 20 77 |he link |in the w|
|000012a0| 6f 72 6b 73 68 65 65 74 | 2e 00 52 65 6d 6f 76 65 |orksheet|..Remove|
|000012b0| 73 20 74 68 65 20 63 75 | 72 72 65 6e 74 6c 79 20 |s the cu|rrently |
|000012c0| 75 73 65 64 20 64 65 73 | 74 69 6e 61 74 69 6f 6e |used des|tination|
|000012d0| 20 72 61 6e 67 65 20 66 | 6f 72 20 61 20 44 44 45 | range f|or a DDE|
|000012e0| 20 6f 72 20 4f 4c 45 20 | 6c 69 6e 6b 2c 20 62 75 | or OLE |link, bu|
|000012f0| 74 20 64 6f 65 73 20 6e | 6f 74 20 64 65 6c 65 74 |t does n|ot delet|
|00001300| 65 20 74 68 65 20 64 61 | 74 61 20 69 6e 20 74 68 |e the da|ta in th|
|00001310| 65 20 72 61 6e 67 65 2e | 00 55 70 64 61 74 65 73 |e range.|.Updates|
|00001320| 20 44 44 45 20 61 6e 64 | 20 4f 4c 45 20 6c 69 6e | DDE and| OLE lin|
|00001330| 6b 73 2c 20 6f 72 20 61 | 63 74 69 76 61 74 65 73 |ks, or a|ctivates|
|00001340| 20 61 6e 64 20 75 70 64 | 61 74 65 73 20 6c 69 6e | and upd|ates lin|
|00001350| 6b 73 20 64 65 61 63 74 | 69 76 61 74 65 64 20 77 |ks deact|ivated w|
|00001360| 69 74 68 20 7b 4c 49 4e | 4b 2d 44 45 41 43 54 49 |ith {LIN|K-DEACTI|
|00001370| 56 41 54 45 7d 2e 00 45 | 78 65 63 75 74 65 73 20 |VATE}..E|xecutes |
|00001380| 65 69 74 68 65 72 20 74 | 68 65 20 70 72 69 6d 61 |either t|he prima|
|00001390| 72 79 20 6f 72 20 73 65 | 63 6f 6e 64 61 72 79 20 |ry or se|condary |
|000013a0| 76 65 72 62 20 66 6f 72 | 20 74 68 65 20 63 75 72 |verb for| the cur|
|000013b0| 72 65 6e 74 6c 79 20 73 | 65 6c 65 63 74 65 64 20 |rently s|elected |
|000013c0| 4f 4c 45 20 65 6d 62 65 | 64 64 65 64 20 6f 62 6a |OLE embe|dded obj|
|000013d0| 65 63 74 2e 00 43 72 65 | 61 74 65 73 20 61 6e 64 |ect..Cre|ates and|
|000013e0| 20 70 6c 61 63 65 73 20 | 69 6e 20 74 68 65 20 77 | places |in the w|
|000013f0| 6f 72 6b 73 68 65 65 74 | 20 61 6e 20 4f 4c 45 20 |orksheet| an OLE |
|00001400| 65 6d 62 65 64 64 65 64 | 20 6f 62 6a 65 63 74 2e |embedded| object.|
|00001410| 00 55 70 64 61 74 65 73 | 20 61 20 31 2d 32 2d 33 |.Updates| a 1-2-3|
|00001420| 20 4f 4c 45 20 6f 62 6a | 65 63 74 20 65 6d 62 65 | OLE obj|ect embe|
|00001430| 64 64 65 64 20 69 6e 20 | 61 6e 6f 74 68 65 72 20 |dded in |another |
|00001440| 61 70 70 6c 69 63 61 74 | 69 6f 6e 20 66 69 6c 65 |applicat|ion file|
|00001450| 2e 00 53 70 65 63 69 66 | 69 65 73 20 74 68 65 20 |..Specif|ies the |
|00001460| 6d 61 63 72 6f 20 74 68 | 61 74 20 69 73 20 65 78 |macro th|at is ex|
|00001470| 65 63 75 74 65 64 20 77 | 68 65 6e 20 64 61 74 61 |ecuted w|hen data|
|00001480| 20 63 68 61 6e 67 65 73 | 20 69 6e 20 74 68 65 20 | changes| in the |
|00001490| 73 65 72 76 65 72 20 61 | 70 70 6c 69 63 61 74 69 |server a|pplicati|
|000014a0| 6f 6e 2e 00 54 65 72 6d | 69 6e 61 74 65 73 20 61 |on..Term|inates a|
|000014b0| 20 63 6f 6e 76 65 72 73 | 61 74 69 6f 6e 20 77 69 | convers|ation wi|
|000014c0| 74 68 20 61 20 57 69 6e | 64 6f 77 73 20 61 70 70 |th a Win|dows app|
|000014d0| 6c 69 63 61 74 69 6f 6e | 2e 00 53 65 6e 64 73 20 |lication|..Sends |
|000014e0| 61 20 63 6f 6d 6d 61 6e | 64 20 74 6f 20 61 6e 20 |a comman|d to an |
|000014f0| 61 70 70 6c 69 63 61 74 | 69 6f 6e 2e 00 49 6e 69 |applicat|ion..Ini|
|00001500| 74 69 61 74 65 73 20 61 | 20 63 6f 6e 76 65 72 73 |tiates a| convers|
|00001510| 61 74 69 6f 6e 20 77 69 | 74 68 20 61 20 57 69 6e |ation wi|th a Win|
|00001520| 64 6f 77 73 20 61 70 70 | 6c 69 63 61 74 69 6f 6e |dows app|lication|
|00001530| 2c 20 6d 61 6b 69 6e 67 | 20 74 68 61 74 20 74 68 |, making| that th|
|00001540| 65 20 63 75 72 72 65 6e | 74 20 63 6f 6e 76 65 72 |e curren|t conver|
|00001550| 73 61 74 69 6f 6e 3b 20 | 6f 70 74 69 6f 6e 61 6c |sation; |optional|
|00001560| 6c 79 2c 20 65 6e 74 65 | 72 73 20 69 6e 20 6c 6f |ly, ente|rs in lo|
|00001570| 63 61 74 69 6f 6e 20 74 | 68 65 20 75 6e 69 71 75 |cation t|he uniqu|
|00001580| 65 20 64 65 63 69 6d 61 | 6c 20 6e 75 6d 62 65 72 |e decima|l number|
|00001590| 20 57 69 6e 64 6f 77 73 | 20 61 73 73 69 67 6e 73 | Windows| assigns|
|000015a0| 20 74 6f 20 74 68 65 20 | 63 6f 6e 76 65 72 73 61 | to the |conversa|
|000015b0| 74 69 6f 6e 2e 00 53 65 | 6e 64 73 20 61 20 72 61 |tion..Se|nds a ra|
|000015c0| 6e 67 65 20 6f 66 20 64 | 61 74 61 20 74 6f 20 61 |nge of d|ata to a|
|000015d0| 20 73 65 72 76 65 72 20 | 61 70 70 6c 69 63 61 74 | server |applicat|
|000015e0| 69 6f 6e 20 64 75 72 69 | 6e 67 20 74 68 65 20 63 |ion duri|ng the c|
|000015f0| 75 72 72 65 6e 74 20 63 | 6f 6e 76 65 72 73 61 74 |urrent c|onversat|
|00001600| 69 6f 6e 2e 00 54 72 61 | 6e 73 66 65 72 73 20 64 |ion..Tra|nsfers d|
|00001610| 61 74 61 20 66 72 6f 6d | 20 61 20 57 69 6e 64 6f |ata from| a Windo|
|00001620| 77 73 20 61 70 70 6c 69 | 63 61 74 6f 6e 20 74 6f |ws appli|caton to|
|00001630| 20 31 2d 32 2d 33 2e 00 | 45 6e 64 73 20 61 20 7b | 1-2-3..|Ends a {|
|00001640| 44 44 45 2d 41 44 56 49 | 53 45 7d 20 63 6f 6d 6d |DDE-ADVI|SE} comm|
|00001650| 61 6e 64 2e 00 4d 61 6b | 65 73 20 74 68 65 20 63 |and..Mak|es the c|
|00001660| 6f 6e 76 65 72 73 61 74 | 69 6f 6e 20 73 70 65 63 |onversat|ion spec|
|00001670| 69 66 69 65 64 20 62 79 | 20 63 6f 6e 76 65 72 73 |ified by| convers|
|00001680| 61 74 69 6f 6e 2d 6e 75 | 6d 62 65 72 20 74 68 65 |ation-nu|mber the|
|00001690| 20 63 75 72 72 65 6e 74 | 20 63 6f 6e 76 65 72 73 | current| convers|
|000016a0| 61 74 69 6f 6e 2e 00    |                         |ation.. |        |
+--------+-------------------------+-------------------------+--------+--------+