Liren Large Software Subsidy 5

home *** CD-ROM | disk | FTP | other *** search
/ Liren Large Software Subsidy 5 / 05.iso / a / a084 / 2.ddi / CKSAMPLE / HELPDATA.FPT < prev next >
FoxPro Memo File | 1993-05-25 | 69.9 KB
open in:
MacOS 8.1 |
Win98 |
DOS
view JSON data |
view as text

This file was processed as: FoxPro Memo File (other/foxProMemo).
This format is not currently supported by dexvert.
Confidence	Program	Detection	Match Type	Support
`1%`	dexvert	FoxPro Memo File `(other/foxProMemo)`	magic	Unsupported
`100%`	file	Adobe Photoshop Color swatch, version 0, 1119 colors; 1st RGB space (0), w 0x40, x 0, y 0, z 0 ; 2nd RGB space (0), w 0, x 0, y 0, z 0	default (weak)
`99%`	file	FoxPro FPT, blocks size 64, next free block index 1119, field type 1, field length 270, 1st item "To be written"	default
`98%`	file	data	default
`57%`	TrID	Sybase iAnywhere memo files	default
`42%`	TrID	MacBinary 1	default (weak)
`100%`	siegfried	x-fmt/342 Microsoft FoxPro Memo	default (weak)
hex view
+--------+-------------------------+-------------------------+--------+--------+
|00000000| 00 00 04 5f 00 00 00 40 | 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 01 00 00 01 0e | 54 6f 20 62 65 20 77 72 |........|To be wr|
|00000210| 69 74 74 65 6e 0d 0a 54 | 6f 20 62 65 20 77 72 69 |itten..T|o be wri|
|00000220| 74 74 65 6e 0d 0a 54 6f | 20 62 65 20 77 72 69 74 |tten..To| be writ|
|00000230| 74 65 6e 0d 0a 54 6f 20 | 62 65 20 77 72 69 74 74 |ten..To |be writt|
|00000240| 65 6e 0d 0a 54 6f 20 62 | 65 20 77 72 69 74 74 65 |en..To b|e writte|
|00000250| 6e 0d 0a 54 6f 20 62 65 | 20 77 72 69 74 74 65 6e |n..To be| written|
|00000260| 0d 0a 54 6f 20 62 65 20 | 77 72 69 74 74 65 6e 0d |..To be |written.|
|00000270| 0a 54 6f 20 62 65 20 77 | 72 69 74 74 65 6e 0d 0a |.To be w|ritten..|
|00000280| 54 6f 20 62 65 20 77 72 | 69 74 74 65 6e 0d 0a 54 |To be wr|itten..T|
|00000290| 6f 20 62 65 20 77 72 69 | 74 74 65 6e 0d 0a 54 6f |o be wri|tten..To|
|000002a0| 20 62 65 20 77 72 69 74 | 74 65 6e 0d 0a 54 6f 20 | be writ|ten..To |
|000002b0| 62 65 20 77 72 69 74 74 | 65 6e 0d 0a 54 6f 20 62 |be writt|en..To b|
|000002c0| 65 20 77 72 69 74 74 65 | 6e 0d 0a 54 6f 20 62 65 |e writte|n..To be|
|000002d0| 20 77 72 69 74 74 65 6e | 0d 0a 54 6f 20 62 65 20 | written|..To be |
|000002e0| 77 72 69 74 74 65 6e 0d | 0a 54 6f 20 62 65 20 77 |written.|.To be w|
|000002f0| 72 69 74 74 65 6e 0d 0a | 54 6f 20 62 65 20 77 72 |ritten..|To be wr|
|00000300| 69 74 74 65 6e 0d 0a 54 | 6f 20 62 65 20 77 72 69 |itten..T|o be wri|
|00000310| 74 74 65 6e 0d 0a 74 65 | 78 74 0d 0a 54 68 69 73 |tten..te|xt..This|
|00000320| 20 69 73 20 74 68 65 20 | 68 65 6b 70 20 74 65 78 | is the |hekp tex|
|00000330| 74 0d 0a 54 68 69 73 20 | 69 73 20 74 68 65 20 68 |t..This |is the h|
|00000340| 65 6b 70 20 74 65 78 74 | 0d 0a 54 68 69 73 20 69 |ekp text|..This i|
|00000350| 73 20 74 68 65 20 68 65 | 6b 70 20 74 65 78 74 0d |s the he|kp text.|
|00000360| 0a 54 68 69 73 20 69 73 | 20 74 68 65 20 68 65 6b |.This is| the hek|
|00000370| 70 20 74 65 78 74 0d 0a | 54 68 69 73 20 69 73 20 |p text..|This is |
|00000380| 74 68 65 20 68 65 6b 70 | 20 74 65 78 74 0d 0a 54 |the hekp| text..T|
|00000390| 68 69 73 20 69 73 20 74 | 68 65 20 68 65 6b 70 20 |his is t|he hekp |
|000003a0| 74 65 78 74 0d 0a 54 68 | 69 73 20 69 73 20 74 68 |text..Th|is is th|
|000003b0| 65 20 68 65 6b 70 20 74 | 65 78 74 0d 0a 54 68 69 |e hekp t|ext..Thi|
|000003c0| 73 20 69 73 20 74 68 65 | 20 68 65 6b 70 20 74 65 |s is the| hekp te|
|000003d0| 78 74 0d 0a 54 68 69 73 | 20 69 73 20 74 68 65 20 |xt..This| is the |
|000003e0| 68 65 6b 70 20 74 65 78 | 74 0d 0a 54 68 69 73 20 |hekp tex|t..This |
|000003f0| 69 73 20 74 68 65 20 68 | 65 6b 70 20 74 65 78 74 |is the h|ekp text|
|00000400| 0d 0a 54 68 69 73 20 69 | 73 20 74 68 65 20 68 65 |..This i|s the he|
|00000410| 6b 70 20 74 65 78 74 0d | 0a 54 68 69 73 20 69 73 |kp text.|.This is|
|00000420| 20 74 68 65 20 68 65 6b | 70 20 74 65 78 74 0d 0a | the hek|p text..|
|00000430| 54 68 69 73 20 69 73 20 | 74 68 65 20 68 65 6b 70 |This is |the hekp|
|00000440| 20 74 65 78 74 0d 0a 54 | 68 69 73 20 69 73 20 74 | text..T|his is t|
|00000450| 68 65 20 68 65 6b 70 20 | 74 65 78 74 0d 0a 54 68 |he hekp |text..Th|
|00000460| 69 73 20 69 73 20 74 68 | 65 20 68 65 6b 70 20 74 |is is th|e hekp t|
|00000470| 65 78 74 0d 0a 54 68 69 | 73 20 69 73 20 74 68 65 |ext..Thi|s is the|
|00000480| 20 68 65 6b 70 20 74 65 | 78 74 0d 0a 54 68 69 73 | hekp te|xt..This|
|00000490| 20 69 73 20 74 68 65 20 | 68 65 6b 70 20 74 65 78 | is the |hekp tex|
|000004a0| 74 0d 0a 54 68 69 73 20 | 69 73 20 74 68 65 20 68 |t..This |is the h|
|000004b0| 65 6b 70 20 74 65 78 74 | 0d 0a 54 68 69 73 20 69 |ekp text|..This i|
|000004c0| 73 20 74 68 65 20 68 65 | 6b 70 20 74 65 78 74 0d |s the he|kp text.|
|000004d0| 0a 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |.       |        |
|000004e0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |        |        |
|000004f0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |        |        |
|00000500| 00 00 00 01 00 00 25 58 | 0d 0a 54 68 65 20 43 4b |......%X|..The CK|
|00000510| 53 41 4d 50 4c 45 20 61 | 70 70 6c 69 63 61 74 69 |SAMPLE a|pplicati|
|00000520| 6f 6e 20 6c 65 74 73 20 | 79 6f 75 20 71 75 69 63 |on lets |you quic|
|00000530| 6b 6c 79 20 61 6e 64 20 | 65 61 73 69 6c 79 20 70 |kly and |easily p|
|00000540| 65 72 66 6f 72 6d 20 73 | 6f 6d 65 20 6f 66 20 74 |erform s|ome of t|
|00000550| 68 65 20 62 61 73 69 63 | 20 6f 70 65 72 61 74 69 |he basic| operati|
|00000560| 6f 6e 73 20 61 73 73 6f | 63 69 61 74 65 64 20 77 |ons asso|ciated w|
|00000570| 69 74 68 20 61 20 63 6c | 69 65 6e 74 20 66 72 6f |ith a cl|ient fro|
|00000580| 6e 74 20 65 6e 64 2c 20 | 73 75 63 68 20 61 73 20 |nt end, |such as |
|00000590| 63 6f 6e 6e 65 63 74 69 | 6e 67 20 74 6f 20 61 20 |connecti|ng to a |
|000005a0| 64 61 74 61 20 73 6f 75 | 72 63 65 2c 20 75 73 69 |data sou|rce, usi|
|000005b0| 6e 67 20 61 20 64 61 74 | 61 62 61 73 65 20 6f 6e |ng a dat|abase on|
|000005c0| 20 74 68 65 20 64 61 74 | 61 20 73 6f 75 72 63 65 | the dat|a source|
|000005d0| 2c 20 61 6e 64 20 71 75 | 65 72 79 69 6e 67 20 64 |, and qu|erying d|
|000005e0| 61 74 61 2e 20 43 4b 53 | 41 4d 50 4c 45 20 61 6c |ata. CKS|AMPLE al|
|000005f0| 73 6f 20 6c 65 74 73 20 | 79 6f 75 20 73 65 74 20 |so lets |you set |
|00000600| 76 61 72 69 6f 75 73 20 | 6f 70 74 69 6f 6e 73 2c |various |options,|
|00000610| 20 65 64 69 74 20 53 51 | 4c 20 63 6f 6d 6d 61 6e | edit SQ|L comman|
|00000620| 64 73 20 74 6f 20 62 65 | 20 73 65 6e 74 20 74 6f |ds to be| sent to|
|00000630| 20 74 68 65 20 64 61 74 | 61 20 0d 0a 73 6f 75 72 | the dat|a ..sour|
|00000640| 63 65 2c 20 61 6e 64 20 | 63 6f 6e 76 65 72 74 20 |ce, and |convert |
|00000650| 61 20 64 61 74 61 20 73 | 6f 75 72 63 65 20 6d 65 |a data s|ource me|
|00000660| 6d 6f 20 66 69 65 6c 64 | 20 77 69 74 68 20 62 69 |mo field| with bi|
|00000670| 6e 61 72 79 20 64 61 74 | 61 20 74 6f 20 61 20 46 |nary dat|a to a F|
|00000680| 6f 78 50 72 6f 20 67 65 | 6e 65 72 61 6c 20 74 79 |oxPro ge|neral ty|
|00000690| 70 65 20 66 69 65 6c 64 | 2e 0d 0a 0d 0a 20 20 20 |pe field|.....   |
|000006a0| 20 20 2b 3d 3d 3d 3d 3d | 3d 3d 3d 3d 3d 3d 3d 3d |  +=====|========|
|000006b0| 3d 3d 3d 3d 3d 3d 3d 3d | 3d 3d 3d 3d 3d 3d 3d 3d |========|========|
|000006c0| 3d 3d 3d 3d 3d 3d 2b 0d | 0a 20 20 20 20 20 20 7c |======+.|.      ||
|000006d0| 20 20 20 20 20 43 4f 4e | 4e 45 43 54 49 4e 47 20 |     CON|NECTING |
|000006e0| 54 4f 20 41 20 44 41 54 | 41 20 53 4f 55 52 43 45 |TO A DAT|A SOURCE|
|000006f0| 20 20 20 20 20 20 20 20 | 20 20 7c 0d 0a 20 20 20 |        |  |..   |
|00000700| 20 20 2b 3d 3d 3d 3d 3d | 3d 3d 3d 3d 3d 3d 3d 3d |  +=====|========|
|00000710| 3d 3d 3d 3d 3d 3d 3d 3d | 3d 3d 3d 3d 3d 3d 3d 3d |========|========|
|00000720| 3d 3d 3d 3d 3d 3d 2b 0d | 0a 0d 0a 4e 4f 54 45 3a |======+.|...NOTE:|
|00000730| 20 20 42 65 66 6f 72 65 | 20 79 6f 75 20 63 61 6e |  Before| you can|
|00000740| 20 63 6f 6e 6e 65 63 74 | 20 74 6f 20 61 20 64 61 | connect| to a da|
|00000750| 74 61 20 73 6f 75 72 63 | 65 2c 20 74 68 65 20 61 |ta sourc|e, the a|
|00000760| 70 70 72 6f 70 72 69 61 | 74 65 20 64 72 69 76 65 |ppropria|te drive|
|00000770| 72 20 66 6f 72 20 74 68 | 65 20 64 61 74 61 20 73 |r for th|e data s|
|00000780| 6f 75 72 63 65 20 6d 75 | 73 74 20 68 61 76 65 20 |ource mu|st have |
|00000790| 0d 0a 70 72 65 76 69 6f | 75 73 6c 79 20 62 65 65 |..previo|usly bee|
|000007a0| 6e 20 69 6e 73 74 61 6c | 6c 65 64 20 6f 6e 20 79 |n instal|led on y|
|000007b0| 6f 75 72 20 6d 61 63 68 | 69 6e 65 2e 0d 0a 0d 0a |our mach|ine.....|
|000007c0| 57 68 65 6e 20 79 6f 75 | 20 72 75 6e 20 43 4b 53 |When you| run CKS|
|000007d0| 41 4d 50 4c 45 2e 41 50 | 50 2c 20 74 68 65 20 43 |AMPLE.AP|P, the C|
|000007e0| 6f 6e 6e 65 63 74 20 74 | 6f 20 44 61 74 61 20 53 |onnect t|o Data S|
|000007f0| 6f 75 72 63 65 20 64 69 | 61 6c 6f 67 20 6f 70 65 |ource di|alog ope|
|00000800| 6e 73 2e 20 20 54 68 69 | 73 20 64 69 61 6c 6f 67 |ns.  Thi|s dialog|
|00000810| 20 63 6f 6e 74 61 69 6e | 73 20 74 68 65 20 0d 0a | contain|s the ..|
|00000820| 66 6f 6c 6c 6f 77 69 6e | 67 20 6f 62 6a 65 63 74 |followin|g object|
|00000830| 73 3a 0d 0a 0d 0a 09 44 | 61 74 61 20 53 6f 75 72 |s:.....D|ata Sour|
|00000840| 63 65 20 74 65 78 74 20 | 62 6f 78 20 2d 2d 20 74 |ce text |box -- t|
|00000850| 79 70 65 20 74 68 65 20 | 6e 61 6d 65 20 6f 66 20 |ype the |name of |
|00000860| 74 68 65 20 64 61 74 61 | 20 73 6f 75 72 63 65 20 |the data| source |
|00000870| 74 6f 20 77 68 69 63 68 | 20 79 6f 75 20 77 61 6e |to which| you wan|
|00000880| 74 20 74 6f 20 63 6f 6e | 6e 65 63 74 2e 20 54 68 |t to con|nect. Th|
|00000890| 69 73 20 0d 0a 69 6e 66 | 6f 72 6d 61 74 69 6f 6e |is ..inf|ormation|
|000008a0| 20 69 73 20 72 65 71 75 | 69 72 65 64 20 69 6e 20 | is requ|ired in |
|000008b0| 6f 72 64 65 72 20 74 6f | 20 63 6f 6e 6e 65 63 74 |order to| connect|
|000008c0| 20 74 6f 20 61 20 64 61 | 74 61 20 73 6f 75 72 63 | to a da|ta sourc|
|000008d0| 65 2e 0d 0a 0d 0a 09 55 | 73 65 72 20 49 64 65 6e |e......U|ser Iden|
|000008e0| 74 69 66 69 65 72 20 74 | 65 78 74 20 62 6f 78 20 |tifier t|ext box |
|000008f0| 2d 2d 20 74 79 70 65 20 | 74 68 65 20 75 73 65 72 |-- type |the user|
|00000900| 20 69 64 65 6e 74 69 66 | 69 63 61 74 69 6f 6e 20 | identif|ication |
|00000910| 75 6e 64 65 72 20 77 68 | 69 63 68 20 79 6f 75 20 |under wh|ich you |
|00000920| 77 61 6e 74 20 74 6f 20 | 6c 6f 67 20 6f 6e 20 74 |want to |log on t|
|00000930| 6f 20 74 68 65 20 64 61 | 74 61 20 0d 0a 73 6f 75 |o the da|ta ..sou|
|00000940| 72 63 65 2e 20 54 68 69 | 73 20 69 6e 66 6f 72 6d |rce. Thi|s inform|
|00000950| 61 74 69 6f 6e 20 69 73 | 20 72 65 71 75 69 72 65 |ation is| require|
|00000960| 64 20 69 6e 20 6f 72 64 | 65 72 20 74 6f 20 63 6f |d in ord|er to co|
|00000970| 6e 6e 65 63 74 20 74 6f | 20 61 20 64 61 74 61 20 |nnect to| a data |
|00000980| 73 6f 75 72 63 65 2e 0d | 0a 0d 0a 09 50 61 73 73 |source..|....Pass|
|00000990| 77 6f 72 64 20 74 65 78 | 74 20 62 6f 78 20 2d 2d |word tex|t box --|
|000009a0| 20 49 66 20 74 68 65 20 | 64 61 74 61 20 73 6f 75 | If the |data sou|
|000009b0| 72 63 65 20 68 61 73 20 | 70 61 73 73 77 6f 72 64 |rce has |password|
|000009c0| 20 70 72 6f 74 65 63 74 | 69 6f 6e 2c 20 74 79 70 | protect|ion, typ|
|000009d0| 65 20 74 68 65 20 70 61 | 73 73 77 6f 72 64 20 69 |e the pa|ssword i|
|000009e0| 6e 20 74 68 69 73 20 74 | 65 78 74 20 0d 0a 62 6f |n this t|ext ..bo|
|000009f0| 78 2e 20 49 66 20 74 68 | 65 20 64 61 74 61 20 73 |x. If th|e data s|
|00000a00| 6f 75 72 63 65 20 64 6f | 65 73 6e 27 74 20 72 65 |ource do|esn't re|
|00000a10| 71 75 69 72 65 20 61 20 | 70 61 73 73 77 6f 72 64 |quire a |password|
|00000a20| 2c 20 74 68 69 73 20 74 | 65 78 74 20 62 6f 78 20 |, this t|ext box |
|00000a30| 63 61 6e 20 62 65 20 6c | 65 66 74 20 65 6d 70 74 |can be l|eft empt|
|00000a40| 79 2e 0d 0a 0d 0a 09 43 | 6f 6e 6e 65 63 74 20 53 |y......C|onnect S|
|00000a50| 74 72 69 6e 67 20 74 65 | 78 74 20 62 6f 78 20 2d |tring te|xt box -|
|00000a60| 2d 20 49 66 20 74 68 65 | 20 64 61 74 61 20 73 6f |- If the| data so|
|00000a70| 75 72 63 65 20 61 63 63 | 65 70 74 73 20 69 6e 73 |urce acc|epts ins|
|00000a80| 74 72 75 63 74 69 6f 6e | 73 20 6f 72 20 63 6f 6d |truction|s or com|
|00000a90| 6d 61 6e 64 73 20 77 68 | 65 6e 20 61 20 63 6f 6e |mands wh|en a con|
|00000aa0| 6e 65 63 74 69 6f 6e 20 | 0d 0a 69 73 20 6d 61 64 |nection |..is mad|
|00000ab0| 65 2c 20 79 6f 75 20 63 | 61 6e 20 69 6e 63 6c 75 |e, you c|an inclu|
|00000ac0| 64 65 20 74 68 61 74 20 | 69 6e 73 74 72 75 63 74 |de that |instruct|
|00000ad0| 69 6f 6e 20 69 6e 20 74 | 68 65 20 43 6f 6e 6e 65 |ion in t|he Conne|
|00000ae0| 63 74 20 53 74 72 69 6e | 67 20 74 65 78 74 20 62 |ct Strin|g text b|
|00000af0| 6f 78 2e 20 20 49 66 20 | 74 68 65 20 64 61 74 61 |ox.  If |the data|
|00000b00| 20 73 6f 75 72 63 65 20 | 64 6f 65 73 20 6e 6f 74 | source |does not|
|00000b10| 20 61 63 63 65 70 74 20 | 0d 0a 69 6e 73 74 72 75 | accept |..instru|
|00000b20| 63 74 69 6f 6e 73 20 6f | 72 20 63 6f 6d 6d 61 6e |ctions o|r comman|
|00000b30| 64 73 20 61 74 20 74 68 | 65 20 74 69 6d 65 20 6f |ds at th|e time o|
|00000b40| 66 20 63 6f 6e 6e 65 63 | 74 69 6f 6e 2c 20 61 6e |f connec|tion, an|
|00000b50| 79 74 68 69 6e 67 20 74 | 79 70 65 64 20 69 6e 20 |ything t|yped in |
|00000b60| 74 68 65 20 43 6f 6e 6e | 65 63 74 20 53 74 72 69 |the Conn|ect Stri|
|00000b70| 6e 67 20 74 65 78 74 20 | 62 6f 78 20 69 73 20 0d |ng text |box is .|
|00000b80| 0a 69 67 6e 6f 72 65 64 | 2e 20 20 54 68 69 73 20 |.ignored|.  This |
|00000b90| 74 65 78 74 20 62 6f 78 | 20 63 61 6e 20 62 65 20 |text box| can be |
|00000ba0| 6c 65 66 74 20 65 6d 70 | 74 79 2e 0d 0a 0d 0a 09 |left emp|ty......|
|00000bb0| 4f 4b 20 61 6e 64 20 43 | 61 6e 63 65 6c 20 62 75 |OK and C|ancel bu|
|00000bc0| 74 74 6f 6e 73 20 2d 2d | 20 43 68 6f 6f 73 65 20 |ttons --| Choose |
|00000bd0| 4f 4b 20 74 6f 20 61 74 | 74 65 6d 70 74 20 74 68 |OK to at|tempt th|
|00000be0| 65 20 63 6f 6e 6e 65 63 | 74 69 6f 6e 20 73 70 65 |e connec|tion spe|
|00000bf0| 63 69 66 69 65 64 20 69 | 6e 20 74 68 65 20 76 61 |cified i|n the va|
|00000c00| 72 69 6f 75 73 20 74 65 | 78 74 20 0d 0a 62 6f 78 |rious te|xt ..box|
|00000c10| 65 73 20 69 6e 20 74 68 | 69 73 20 64 69 61 6c 6f |es in th|is dialo|
|00000c20| 67 2e 20 49 66 20 74 68 | 65 20 63 6f 6e 6e 65 63 |g. If th|e connec|
|00000c30| 74 69 6f 6e 20 69 73 20 | 73 75 63 63 65 73 73 66 |tion is |successf|
|00000c40| 75 6c 2c 20 61 20 73 75 | 63 63 65 73 73 66 75 6c |ul, a su|ccessful|
|00000c50| 20 63 6f 6e 6e 65 63 74 | 69 6f 6e 20 6d 65 73 73 | connect|ion mess|
|00000c60| 61 67 65 20 69 73 20 64 | 69 73 70 6c 61 79 65 64 |age is d|isplayed|
|00000c70| 20 69 6e 20 61 20 77 61 | 69 74 20 0d 0a 77 69 6e | in a wa|it ..win|
|00000c80| 64 6f 77 20 61 6e 64 20 | 74 68 65 20 6e 61 6d 65 |dow and |the name|
|00000c90| 20 6f 66 20 74 68 65 20 | 64 61 74 61 20 73 6f 75 | of the |data sou|
|00000ca0| 72 63 65 20 69 73 20 64 | 69 73 70 6c 61 79 65 64 |rce is d|isplayed|
|00000cb0| 20 6f 6e 20 74 68 65 20 | 73 74 61 74 75 73 20 62 | on the |status b|
|00000cc0| 61 72 2e 20 49 66 20 79 | 6f 75 20 63 61 6e 6e 6f |ar. If y|ou canno|
|00000cd0| 74 20 63 6f 6e 6e 65 63 | 74 2c 20 61 6e 20 65 72 |t connec|t, an er|
|00000ce0| 72 6f 72 20 0d 0a 6d 65 | 73 73 61 67 65 20 69 73 |ror ..me|ssage is|
|00000cf0| 20 64 69 73 70 6c 61 79 | 65 64 20 61 6e 64 20 79 | display|ed and y|
|00000d00| 6f 75 20 61 72 65 20 72 | 65 74 75 72 6e 65 64 20 |ou are r|eturned |
|00000d10| 74 6f 20 74 68 65 20 64 | 69 61 6c 6f 67 2e 0d 0a |to the d|ialog...|
|00000d20| 0d 0a 09 57 68 65 6e 20 | 79 6f 75 20 72 75 6e 20 |...When |you run |
|00000d30| 43 4b 53 41 4d 50 4c 45 | 2e 41 50 50 2c 20 79 6f |CKSAMPLE|.APP, yo|
|00000d40| 75 20 6d 75 73 74 20 63 | 6f 6e 6e 65 63 74 20 74 |u must c|onnect t|
|00000d50| 6f 20 61 20 64 61 74 61 | 20 73 6f 75 72 63 65 2e |o a data| source.|
|00000d60| 20 20 49 66 20 79 6f 75 | 20 63 68 6f 6f 73 65 20 |  If you| choose |
|00000d70| 43 61 6e 63 65 6c 2c 20 | 0d 0a 43 4b 53 41 4d 50 |Cancel, |..CKSAMP|
|00000d80| 4c 45 2e 41 50 50 20 74 | 65 72 6d 69 6e 61 74 65 |LE.APP t|erminate|
|00000d90| 73 2e 0d 0a 0d 0a 09 54 | 6f 20 63 68 61 6e 67 65 |s......T|o change|
|00000da0| 20 64 61 74 61 20 73 6f | 75 72 63 65 20 63 6f 6e | data so|urce con|
|00000db0| 6e 65 63 74 69 6f 6e 73 | 2c 20 63 68 6f 6f 73 65 |nections|, choose|
|00000dc0| 20 44 69 73 63 6f 6e 6e | 65 63 74 20 66 72 6f 6d | Disconn|ect from|
|00000dd0| 20 74 68 65 20 44 61 74 | 61 62 61 73 65 20 6d 65 | the Dat|abase me|
|00000de0| 6e 75 2c 20 74 68 65 6e | 20 63 68 6f 6f 73 65 20 |nu, then| choose |
|00000df0| 0d 0a 43 6f 6e 6e 65 63 | 74 2e 2e 2e 20 66 72 6f |..Connec|t... fro|
|00000e00| 6d 20 74 68 65 20 44 61 | 74 61 62 61 73 65 20 6d |m the Da|tabase m|
|00000e10| 65 6e 75 2e 20 20 54 68 | 65 20 43 6f 6e 6e 65 63 |enu.  Th|e Connec|
|00000e20| 74 20 74 6f 20 44 61 74 | 61 20 53 6f 75 72 63 65 |t to Dat|a Source|
|00000e30| 20 64 69 61 6c 6f 67 20 | 6f 70 65 6e 73 2e 20 20 | dialog |opens.  |
|00000e40| 41 67 61 69 6e 2c 20 79 | 6f 75 20 6e 65 65 64 20 |Again, y|ou need |
|00000e50| 74 6f 20 0d 0a 69 6e 64 | 69 63 61 74 65 20 61 20 |to ..ind|icate a |
|00000e60| 64 61 74 61 20 73 6f 75 | 72 63 65 20 74 6f 20 63 |data sou|rce to c|
|00000e70| 6f 6e 6e 65 63 74 20 74 | 6f 20 61 6e 64 20 61 20 |onnect t|o and a |
|00000e80| 75 73 65 72 20 69 64 65 | 6e 74 69 66 69 63 61 74 |user ide|ntificat|
|00000e90| 69 6f 6e 2c 20 61 73 20 | 77 65 6c 6c 20 61 73 20 |ion, as |well as |
|00000ea0| 61 20 70 61 73 73 77 6f | 72 64 20 61 6e 64 20 63 |a passwo|rd and c|
|00000eb0| 6f 6e 6e 65 63 74 20 73 | 74 72 69 6e 67 20 69 66 |onnect s|tring if|
|00000ec0| 20 0d 0a 64 65 73 69 72 | 65 64 2c 20 74 68 65 6e | ..desir|ed, then|
|00000ed0| 20 63 68 6f 6f 73 65 20 | 4f 4b 2e 20 20 49 66 20 | choose |OK.  If |
|00000ee0| 79 6f 75 20 63 68 6f 6f | 73 65 20 43 61 6e 63 65 |you choo|se Cance|
|00000ef0| 6c 2c 20 6e 6f 20 61 74 | 74 65 6d 70 74 20 69 73 |l, no at|tempt is|
|00000f00| 20 6d 61 64 65 20 74 6f | 20 63 6f 6e 6e 65 63 74 | made to| connect|
|00000f10| 20 74 6f 20 61 20 64 61 | 74 61 20 73 6f 75 72 63 | to a da|ta sourc|
|00000f20| 65 20 61 6e 64 20 74 68 | 65 20 0d 0a 64 69 61 6c |e and th|e ..dial|
|00000f30| 6f 67 20 69 73 20 63 6c | 6f 73 65 64 2c 20 62 75 |og is cl|osed, bu|
|00000f40| 74 20 43 4b 53 41 4d 50 | 4c 45 2e 41 50 50 20 63 |t CKSAMP|LE.APP c|
|00000f50| 6f 6e 74 69 6e 75 65 73 | 20 74 6f 20 72 75 6e 2e |ontinues| to run.|
|00000f60| 0d 0a 0d 0a 0d 0a 20 20 | 20 20 20 2b 3d 3d 3d 3d |......  |   +====|
|00000f70| 3d 3d 3d 3d 3d 3d 3d 3d | 3d 3d 3d 3d 3d 3d 3d 3d |========|========|
|00000f80| 3d 3d 3d 3d 3d 3d 3d 3d | 3d 3d 3d 3d 3d 3d 3d 2b |========|=======+|
|00000f90| 0d 0a 20 20 20 20 20 20 | 7c 20 20 20 20 20 20 20 |..      ||       |
|00000fa0| 20 20 20 20 20 20 20 20 | 20 20 20 55 53 49 4e 47 |        |   USING|
|00000fb0| 20 41 20 44 41 54 41 42 | 41 53 45 20 20 20 20 20 | A DATAB|ASE     |
|00000fc0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |        |        |
|00000fd0| 20 20 20 7c 0d 0a 20 20 | 20 20 20 2b 3d 3d 3d 3d |   |..  |   +====|
|00000fe0| 3d 3d 3d 3d 3d 3d 3d 3d | 3d 3d 3d 3d 3d 3d 3d 3d |========|========|
|00000ff0| 3d 3d 3d 3d 3d 3d 3d 3d | 3d 3d 3d 3d 3d 3d 3d 2b |========|=======+|
|00001000| 0d 0a 0d 0a 4d 75 6c 74 | 69 70 6c 65 20 64 61 74 |....Mult|iple dat|
|00001010| 61 62 61 73 65 73 20 63 | 61 6e 20 62 65 20 73 74 |abases c|an be st|
|00001020| 6f 72 65 64 20 6f 6e 20 | 61 20 73 69 6e 67 6c 65 |ored on |a single|
|00001030| 20 64 61 74 61 20 73 6f | 75 72 63 65 20 61 6e 64 | data so|urce and|
|00001040| 20 61 20 64 61 74 61 62 | 61 73 65 20 63 61 6e 20 | a datab|ase can |
|00001050| 63 6f 6e 74 61 69 6e 20 | 61 20 6e 75 6d 62 65 72 |contain |a number|
|00001060| 20 6f 66 20 74 61 62 6c | 65 73 2e 20 20 0d 0a 57 | of tabl|es.  ..W|
|00001070| 68 65 6e 20 79 6f 75 20 | 61 72 65 20 63 6f 6e 6e |hen you |are conn|
|00001080| 65 63 74 65 64 20 74 6f | 20 61 20 64 61 74 61 20 |ected to| a data |
|00001090| 73 6f 75 72 63 65 2c 20 | 79 6f 75 20 63 61 6e 20 |source, |you can |
|000010a0| 75 73 65 20 61 20 64 61 | 74 61 62 61 73 65 20 6f |use a da|tabase o|
|000010b0| 6e 20 74 68 61 74 20 73 | 6f 75 72 63 65 2e 20 20 |n that s|ource.  |
|000010c0| 54 6f 20 75 73 65 20 74 | 68 65 20 64 61 74 61 62 |To use t|he datab|
|000010d0| 61 73 65 20 0d 0a 77 68 | 6f 73 65 20 64 61 74 61 |ase ..wh|ose data|
|000010e0| 20 79 6f 75 20 77 61 6e | 74 20 74 6f 20 61 63 63 | you wan|t to acc|
|000010f0| 65 73 73 2c 20 63 68 6f | 6f 73 65 20 55 73 65 20 |ess, cho|ose Use |
|00001100| 44 61 74 61 62 61 73 65 | 2e 2e 2e 20 66 72 6f 6d |Database|... from|
|00001110| 20 74 68 65 20 44 61 74 | 61 62 61 73 65 20 6d 65 | the Dat|abase me|
|00001120| 6e 75 2e 20 54 68 65 20 | 55 73 65 20 44 61 74 61 |nu. The |Use Data|
|00001130| 62 61 73 65 20 64 69 61 | 6c 6f 67 20 0d 0a 6f 70 |base dia|log ..op|
|00001140| 65 6e 73 2e 20 20 54 79 | 70 65 20 74 68 65 20 6e |ens.  Ty|pe the n|
|00001150| 61 6d 65 20 6f 66 20 74 | 68 65 20 64 61 74 61 62 |ame of t|he datab|
|00001160| 61 73 65 20 79 6f 75 20 | 77 61 6e 74 20 74 6f 20 |ase you |want to |
|00001170| 75 73 65 20 69 6e 20 74 | 68 65 20 74 65 78 74 20 |use in t|he text |
|00001180| 62 6f 78 20 61 6e 64 20 | 63 68 6f 6f 73 65 20 4f |box and |choose O|
|00001190| 4b 2e 20 20 54 6f 20 75 | 73 65 20 61 20 64 69 66 |K.  To u|se a dif|
|000011a0| 66 65 72 65 6e 74 20 0d | 0a 64 61 74 61 62 61 73 |ferent .|.databas|
|000011b0| 65 2c 20 66 6f 6c 6c 6f | 77 20 74 68 65 20 73 61 |e, follo|w the sa|
|000011c0| 6d 65 20 73 74 65 70 73 | 2e 20 20 59 6f 75 20 63 |me steps|.  You c|
|000011d0| 61 6e 20 75 73 65 20 6f | 6e 6c 79 20 6f 6e 65 20 |an use o|nly one |
|000011e0| 64 61 74 61 62 61 73 65 | 20 61 74 20 61 20 74 69 |database| at a ti|
|000011f0| 6d 65 2e 20 20 4f 6e 63 | 65 20 79 6f 75 20 75 73 |me.  Onc|e you us|
|00001200| 65 20 61 20 64 61 74 61 | 62 61 73 65 2c 20 74 68 |e a data|base, th|
|00001210| 65 20 0d 0a 6e 61 6d 65 | 20 6f 66 20 74 68 65 20 |e ..name| of the |
|00001220| 64 61 74 61 62 61 73 65 | 20 69 73 20 64 69 73 70 |database| is disp|
|00001230| 6c 61 79 65 64 20 6f 6e | 20 74 68 65 20 73 74 61 |layed on| the sta|
|00001240| 74 75 73 20 62 61 72 20 | 61 6e 64 20 61 6c 6c 20 |tus bar |and all |
|00001250| 74 68 65 20 74 61 62 6c | 65 73 20 69 6e 20 74 68 |the tabl|es in th|
|00001260| 61 74 20 64 61 74 61 62 | 61 73 65 20 61 72 65 20 |at datab|ase are |
|00001270| 61 76 61 69 6c 61 62 6c | 65 20 66 6f 72 20 0d 0a |availabl|e for ..|
|00001280| 71 75 65 72 79 69 6e 67 | 2e 0d 0a 0d 0a 20 20 20 |querying|.....   |
|00001290| 20 20 2b 3d 3d 3d 3d 3d | 3d 3d 3d 3d 3d 3d 3d 3d |  +=====|========|
|000012a0| 3d 3d 3d 3d 3d 3d 3d 3d | 3d 3d 3d 3d 3d 3d 3d 3d |========|========|
|000012b0| 3d 3d 3d 3d 3d 3d 2b 0d | 0a 20 20 20 20 20 7c 20 |======+.|.     | |
|000012c0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |        |        |
|000012d0| 20 43 52 45 41 54 49 4e | 47 20 41 20 51 55 45 52 | CREATIN|G A QUER|
|000012e0| 59 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |Y       |        |
|000012f0| 20 20 20 20 20 20 20 20 | 20 20 20 7c 0d 0a 20 20 |        |   |..  |
|00001300| 20 20 20 2b 3d 3d 3d 3d | 3d 3d 3d 3d 3d 3d 3d 3d |   +====|========|
|00001310| 3d 3d 3d 3d 3d 3d 3d 3d | 3d 3d 3d 3d 3d 3d 3d 3d |========|========|
|00001320| 3d 3d 3d 3d 3d 3d 3d 2b | 0d 0a 0d 0a 59 6f 75 20 |=======+|....You |
|00001330| 63 61 6e 20 61 6c 6c 6f | 77 20 43 4b 53 41 4d 50 |can allo|w CKSAMP|
|00001340| 4c 45 2e 41 50 50 20 74 | 6f 20 62 75 69 6c 64 20 |LE.APP t|o build |
|00001350| 61 20 53 51 4c 20 73 74 | 61 74 65 6d 65 6e 74 20 |a SQL st|atement |
|00001360| 62 61 73 65 64 20 6f 6e | 20 79 6f 75 72 20 63 68 |based on| your ch|
|00001370| 6f 69 63 65 73 20 69 6e | 20 74 68 65 20 42 75 69 |oices in| the Bui|
|00001380| 6c 64 20 51 75 65 72 79 | 20 0d 0a 64 69 61 6c 6f |ld Query| ..dialo|
|00001390| 67 20 6f 72 20 77 72 69 | 74 65 20 79 6f 75 72 20 |g or wri|te your |
|000013a0| 6f 77 6e 20 53 51 4c 20 | 73 74 61 74 65 6d 65 6e |own SQL |statemen|
|000013b0| 74 20 69 6e 20 74 68 65 | 20 45 64 69 74 20 51 75 |t in the| Edit Qu|
|000013c0| 65 72 79 20 64 69 61 6c | 6f 67 2e 20 0d 0a 0d 0a |ery dial|og. ....|
|000013d0| 43 68 6f 6f 73 65 20 42 | 75 69 6c 64 20 51 75 65 |Choose B|uild Que|
|000013e0| 72 79 2e 2e 2e 20 66 72 | 6f 6d 20 74 68 65 20 51 |ry... fr|om the Q|
|000013f0| 75 65 72 79 20 6d 65 6e | 75 20 74 6f 20 6f 70 65 |uery men|u to ope|
|00001400| 6e 20 74 68 65 20 42 75 | 69 6c 64 20 51 75 65 72 |n the Bu|ild Quer|
|00001410| 79 20 64 69 61 6c 6f 67 | 2e 20 20 54 68 69 73 20 |y dialog|.  This |
|00001420| 64 69 61 6c 6f 67 20 63 | 6f 6e 74 61 69 6e 73 20 |dialog c|ontains |
|00001430| 74 68 65 20 0d 0a 66 6f | 6c 6c 6f 77 69 6e 67 20 |the ..fo|llowing |
|00001440| 6f 62 6a 65 63 74 73 3a | 0d 0a 0d 0a 09 46 72 6f |objects:|.....Fro|
|00001450| 6d 2e 2e 2e 20 62 75 74 | 74 6f 6e 20 2d 2d 20 43 |m... but|ton -- C|
|00001460| 68 6f 6f 73 65 20 74 61 | 62 6c 65 73 20 74 6f 20 |hoose ta|bles to |
|00001470| 62 65 20 69 6e 63 6c 75 | 64 65 64 20 69 6e 20 74 |be inclu|ded in t|
|00001480| 68 65 20 71 75 65 72 79 | 2e 0d 0a 43 68 6f 6f 73 |he query|...Choos|
|00001490| 69 6e 67 20 74 68 65 20 | 46 72 6f 6d 2e 2e 2e 20 |ing the |From... |
|000014a0| 62 75 74 74 6f 6e 20 6f | 70 65 6e 73 20 74 68 65 |button o|pens the|
|000014b0| 20 46 72 6f 6d 20 64 69 | 61 6c 6f 67 20 77 69 74 | From di|alog wit|
|000014c0| 68 20 61 20 6c 69 73 74 | 20 6f 66 20 74 68 65 20 |h a list| of the |
|000014d0| 74 61 62 6c 65 73 20 69 | 6e 20 74 68 65 20 64 61 |tables i|n the da|
|000014e0| 74 61 62 61 73 65 20 63 | 75 72 72 65 6e 74 6c 79 |tabase c|urrently|
|000014f0| 20 69 6e 20 75 73 65 20 | 0d 0a 61 6e 64 20 61 20 | in use |..and a |
|00001500| 6c 69 73 74 20 6f 66 20 | 74 61 62 6c 65 73 20 66 |list of |tables f|
|00001510| 72 6f 6d 20 74 68 69 73 | 20 64 61 74 61 62 61 73 |rom this| databas|
|00001520| 65 20 74 6f 20 62 65 20 | 69 6e 63 6c 75 64 65 64 |e to be |included|
|00001530| 20 69 6e 20 74 68 65 20 | 71 75 65 72 79 2e 20 54 | in the |query. T|
|00001540| 6f 20 6d 6f 76 65 20 61 | 20 74 61 62 6c 65 20 66 |o move a| table f|
|00001550| 72 6f 6d 20 74 68 65 20 | 44 61 74 61 62 61 73 65 |rom the |Database|
|00001560| 20 74 61 62 6c 65 73 20 | 0d 0a 6c 69 73 74 20 69 | tables |..list i|
|00001570| 6e 74 6f 20 74 68 65 20 | 51 75 65 72 79 20 74 61 |nto the |Query ta|
|00001580| 62 6c 65 73 20 6c 69 73 | 74 2c 20 64 6f 75 62 6c |bles lis|t, doubl|
|00001590| 65 2d 63 6c 69 63 6b 20 | 69 74 20 6f 72 20 73 65 |e-click |it or se|
|000015a0| 6c 65 63 74 20 69 74 20 | 77 69 74 68 20 74 68 65 |lect it |with the|
|000015b0| 20 6d 6f 75 73 65 20 6f | 72 20 6b 65 79 62 6f 61 | mouse o|r keyboa|
|000015c0| 72 64 20 61 6e 64 20 63 | 68 6f 6f 73 65 20 41 64 |rd and c|hoose Ad|
|000015d0| 64 3e 3e 2e 20 20 0d 0a | 54 6f 20 72 65 6d 6f 76 |d>>.  ..|To remov|
|000015e0| 65 20 61 20 74 61 62 6c | 65 20 66 72 6f 6d 20 74 |e a tabl|e from t|
|000015f0| 68 65 20 51 75 65 72 79 | 20 74 61 62 6c 65 73 20 |he Query| tables |
|00001600| 6c 69 73 74 2c 20 64 6f | 75 62 6c 65 2d 63 6c 69 |list, do|uble-cli|
|00001610| 63 6b 20 69 74 20 6f 72 | 20 73 65 6c 65 63 74 20 |ck it or| select |
|00001620| 69 74 20 77 69 74 68 20 | 74 68 65 20 6d 6f 75 73 |it with |the mous|
|00001630| 65 20 6f 72 20 6b 65 79 | 62 6f 61 72 64 20 61 6e |e or key|board an|
|00001640| 64 20 0d 0a 63 68 6f 6f | 73 65 20 3c 3c 52 65 6d |d ..choo|se <<Rem|
|00001650| 6f 76 65 2e 20 20 57 68 | 65 6e 20 74 68 65 20 64 |ove.  Wh|en the d|
|00001660| 65 73 69 72 65 64 20 74 | 61 62 6c 65 73 20 61 72 |esired t|ables ar|
|00001670| 65 20 69 6e 20 74 68 65 | 20 51 75 65 72 79 20 74 |e in the| Query t|
|00001680| 61 62 6c 65 73 20 6c 69 | 73 74 2c 20 63 68 6f 6f |ables li|st, choo|
|00001690| 73 65 20 4f 4b 2e 20 20 | 54 68 65 20 63 68 6f 73 |se OK.  |The chos|
|000016a0| 65 6e 20 74 61 62 6c 65 | 73 20 61 72 65 20 0d 0a |en table|s are ..|
|000016b0| 64 69 73 70 6c 61 79 65 | 64 20 69 6e 20 74 68 65 |displaye|d in the|
|000016c0| 20 42 75 69 6c 64 20 51 | 75 65 72 79 20 64 69 61 | Build Q|uery dia|
|000016d0| 6c 6f 67 2e 0d 0a 0d 0a | 09 53 65 6c 65 63 74 2e |log.....|.Select.|
|000016e0| 2e 2e 20 62 75 74 74 6f | 6e 20 2d 2d 20 43 68 6f |.. butto|n -- Cho|
|000016f0| 6f 73 65 20 63 6f 6c 75 | 6d 6e 73 20 28 66 69 65 |ose colu|mns (fie|
|00001700| 6c 64 73 29 20 66 72 6f | 6d 20 74 68 65 20 74 61 |lds) fro|m the ta|
|00001710| 62 6c 65 73 20 74 6f 20 | 62 65 20 69 6e 63 6c 75 |bles to |be inclu|
|00001720| 64 65 64 20 69 6e 20 74 | 68 65 20 71 75 65 72 79 |ded in t|he query|
|00001730| 2e 0d 0a 43 68 6f 6f 73 | 65 20 74 68 65 20 53 65 |...Choos|e the Se|
|00001740| 6c 65 63 74 2e 2e 2e 20 | 62 75 74 74 6f 6e 20 74 |lect... |button t|
|00001750| 6f 20 6f 70 65 6e 20 74 | 68 65 20 53 65 6c 65 63 |o open t|he Selec|
|00001760| 74 20 64 69 61 6c 6f 67 | 20 77 69 74 68 20 61 20 |t dialog| with a |
|00001770| 6c 69 73 74 20 6f 66 20 | 74 68 65 20 63 6f 6c 75 |list of |the colu|
|00001780| 6d 6e 73 20 69 6e 20 74 | 68 65 20 74 61 62 6c 65 |mns in t|he table|
|00001790| 73 20 73 65 6c 65 63 74 | 65 64 20 69 6e 20 74 68 |s select|ed in th|
|000017a0| 65 20 0d 0a 46 72 6f 6d | 20 64 69 61 6c 6f 67 20 |e ..From| dialog |
|000017b0| 61 6e 64 20 61 20 6c 69 | 73 74 20 6f 66 20 63 6f |and a li|st of co|
|000017c0| 6c 75 6d 6e 73 20 66 72 | 6f 6d 20 74 68 65 73 65 |lumns fr|om these|
|000017d0| 20 74 61 62 6c 65 73 20 | 74 6f 20 62 65 20 69 6e | tables |to be in|
|000017e0| 63 6c 75 64 65 64 20 69 | 6e 20 74 68 65 20 71 75 |cluded i|n the qu|
|000017f0| 65 72 79 2e 20 54 6f 20 | 6d 6f 76 65 20 61 20 74 |ery. To |move a t|
|00001800| 61 62 6c 65 20 66 72 6f | 6d 20 74 68 65 20 0d 0a |able fro|m the ..|
|00001810| 44 61 74 61 62 61 73 65 | 20 74 61 62 6c 65 73 20 |Database| tables |
|00001820| 6c 69 73 74 20 69 6e 74 | 6f 20 74 68 65 20 51 75 |list int|o the Qu|
|00001830| 65 72 79 20 74 61 62 6c | 65 73 20 6c 69 73 74 2c |ery tabl|es list,|
|00001840| 20 64 6f 75 62 6c 65 2d | 63 6c 69 63 6b 20 69 74 | double-|click it|
|00001850| 20 6f 72 20 73 65 6c 65 | 63 74 20 69 74 20 77 69 | or sele|ct it wi|
|00001860| 74 68 20 74 68 65 20 6d | 6f 75 73 65 20 6f 72 20 |th the m|ouse or |
|00001870| 6b 65 79 62 6f 61 72 64 | 20 61 6e 64 20 0d 0a 63 |keyboard| and ..c|
|00001880| 68 6f 6f 73 65 20 41 64 | 64 3e 3e 2e 20 20 54 6f |hoose Ad|d>>.  To|
|00001890| 20 72 65 6d 6f 76 65 20 | 61 20 74 61 62 6c 65 20 | remove |a table |
|000018a0| 66 72 6f 6d 20 74 68 65 | 20 51 75 65 72 79 20 74 |from the| Query t|
|000018b0| 61 62 6c 65 73 20 6c 69 | 73 74 2c 20 64 6f 75 62 |ables li|st, doub|
|000018c0| 6c 65 2d 63 6c 69 63 6b | 20 69 74 20 6f 72 20 73 |le-click| it or s|
|000018d0| 65 6c 65 63 74 20 69 74 | 20 77 69 74 68 20 74 68 |elect it| with th|
|000018e0| 65 20 6d 6f 75 73 65 20 | 6f 72 20 0d 0a 6b 65 79 |e mouse |or ..key|
|000018f0| 62 6f 61 72 64 20 61 6e | 64 20 63 68 6f 6f 73 65 |board an|d choose|
|00001900| 20 3c 3c 52 65 6d 6f 76 | 65 2e 20 20 57 68 65 6e | <<Remov|e.  When|
|00001910| 20 74 68 65 20 64 65 73 | 69 72 65 64 20 74 61 62 | the des|ired tab|
|00001920| 6c 65 73 20 61 72 65 20 | 69 6e 20 74 68 65 20 51 |les are |in the Q|
|00001930| 75 65 72 79 20 74 61 62 | 6c 65 73 20 6c 69 73 74 |uery tab|les list|
|00001940| 2c 20 63 68 6f 6f 73 65 | 20 4f 4b 2e 20 20 54 68 |, choose| OK.  Th|
|00001950| 65 20 0d 0a 63 68 6f 73 | 65 6e 20 74 61 62 6c 65 |e ..chos|en table|
|00001960| 73 20 61 72 65 20 64 69 | 73 70 6c 61 79 65 64 20 |s are di|splayed |
|00001970| 69 6e 20 74 68 65 20 42 | 75 69 6c 64 20 51 75 65 |in the B|uild Que|
|00001980| 72 79 20 64 69 61 6c 6f | 67 2e 0d 0a 0d 0a 09 4a |ry dialo|g......J|
|00001990| 6f 69 6e 2e 2e 2e 20 62 | 75 74 74 6f 6e 20 2d 2d |oin... b|utton --|
|000019a0| 20 53 70 65 63 69 66 79 | 20 6a 6f 69 6e 20 63 6f | Specify| join co|
|000019b0| 6e 64 69 74 69 6f 6e 73 | 20 66 6f 72 20 74 68 65 |nditions| for the|
|000019c0| 20 74 61 62 6c 65 73 20 | 69 6e 20 74 68 65 20 71 | tables |in the q|
|000019d0| 75 65 72 79 2e 0d 0a 43 | 68 6f 6f 73 65 20 74 68 |uery...C|hoose th|
|000019e0| 65 20 4a 6f 69 6e 2e 2e | 2e 20 62 75 74 74 6f 6e |e Join..|. button|
|000019f0| 20 74 6f 20 6f 70 65 6e | 20 74 68 65 20 4a 6f 69 | to open| the Joi|
|00001a00| 6e 20 64 69 61 6c 6f 67 | 2e 20 20 53 65 6c 65 63 |n dialog|.  Selec|
|00001a10| 74 20 74 68 65 20 63 6f | 6c 75 6d 6e 73 20 74 6f |t the co|lumns to|
|00001a20| 20 62 65 20 6a 6f 69 6e | 65 64 20 66 72 6f 6d 20 | be join|ed from |
|00001a30| 74 68 65 20 70 6f 70 75 | 70 73 20 6f 6e 20 74 68 |the popu|ps on th|
|00001a40| 65 20 0d 0a 6c 65 66 74 | 20 61 6e 64 20 72 69 67 |e ..left| and rig|
|00001a50| 68 74 20 73 69 64 65 73 | 20 6f 66 20 74 68 65 20 |ht sides| of the |
|00001a60| 64 69 61 6c 6f 67 20 61 | 6e 64 20 74 68 65 20 63 |dialog a|nd the c|
|00001a70| 6f 6e 64 69 74 69 6f 6e | 20 6f 66 20 74 68 65 20 |ondition| of the |
|00001a80| 6a 6f 69 6e 20 66 72 6f | 6d 20 74 68 65 20 63 65 |join fro|m the ce|
|00001a90| 6e 74 65 72 20 70 6f 70 | 75 70 2e 20 20 41 20 63 |nter pop|up.  A c|
|00001aa0| 6f 6e 64 69 74 69 6f 6e | 20 63 61 6e 20 62 65 20 |ondition| can be |
|00001ab0| 0d 0a 72 65 76 65 72 73 | 65 64 20 62 79 20 63 68 |..revers|ed by ch|
|00001ac0| 65 63 6b 69 6e 67 20 74 | 68 65 20 4e 4f 54 20 63 |ecking t|he NOT c|
|00001ad0| 68 65 63 6b 20 62 6f 78 | 2e 20 20 43 68 6f 6f 73 |heck box|.  Choos|
|00001ae0| 65 20 4f 4b 20 74 6f 20 | 63 6f 6d 70 6c 65 74 65 |e OK to |complete|
|00001af0| 20 74 68 65 20 6a 6f 69 | 6e 20 6f 72 20 43 61 6e | the joi|n or Can|
|00001b00| 63 65 6c 20 74 6f 20 6c | 65 61 76 65 20 74 68 65 |cel to l|eave the|
|00001b10| 20 64 69 61 6c 6f 67 20 | 0d 0a 77 69 74 68 6f 75 | dialog |..withou|
|00001b20| 74 20 73 65 74 74 69 6e | 67 20 61 20 6a 6f 69 6e |t settin|g a join|
|00001b30| 20 63 6f 6e 64 69 74 69 | 6f 6e 2e 20 49 66 20 79 | conditi|on. If y|
|00001b40| 6f 75 20 69 6e 63 6c 75 | 64 65 20 6d 6f 72 65 20 |ou inclu|de more |
|00001b50| 74 68 61 6e 20 6f 6e 65 | 20 74 61 62 6c 65 20 69 |than one| table i|
|00001b60| 6e 20 61 20 71 75 65 72 | 79 2c 20 79 6f 75 20 73 |n a quer|y, you s|
|00001b70| 68 6f 75 6c 64 20 73 70 | 65 63 69 66 79 20 61 20 |hould sp|ecify a |
|00001b80| 6a 6f 69 6e 20 0d 0a 63 | 6f 6e 64 69 74 69 6f 6e |join ..c|ondition|
|00001b90| 20 66 6f 72 20 65 76 65 | 72 79 20 74 61 62 6c 65 | for eve|ry table|
|00001ba0| 2e 20 20 54 6f 20 73 70 | 65 63 69 66 79 20 61 64 |.  To sp|ecify ad|
|00001bb0| 64 69 74 69 6f 6e 61 6c | 20 6a 6f 69 6e 20 63 6f |ditional| join co|
|00001bc0| 6e 64 69 74 69 6f 6e 73 | 2c 20 72 65 70 65 61 74 |nditions|, repeat|
|00001bd0| 20 74 68 65 20 61 62 6f | 76 65 20 73 74 65 70 73 | the abo|ve steps|
|00001be0| 2e 0d 0a 0d 0a 09 57 68 | 65 72 65 2e 2e 2e 20 62 |......Wh|ere... b|
|00001bf0| 75 74 74 6f 6e 20 2d 2d | 20 53 70 65 63 69 66 79 |utton --| Specify|
|00001c00| 20 66 69 6c 74 65 72 20 | 63 6f 6e 64 69 74 69 6f | filter |conditio|
|00001c10| 6e 73 20 66 6f 72 20 74 | 68 65 20 71 75 65 72 79 |ns for t|he query|
|00001c20| 2e 0d 0a 43 68 6f 6f 73 | 65 20 74 68 65 20 57 68 |...Choos|e the Wh|
|00001c30| 65 72 65 2e 2e 2e 20 62 | 75 74 74 6f 6e 20 74 6f |ere... b|utton to|
|00001c40| 20 6f 70 65 6e 20 74 68 | 65 20 57 68 65 72 65 20 | open th|e Where |
|00001c50| 64 69 61 6c 6f 67 2e 20 | 20 53 65 6c 65 63 74 20 |dialog. | Select |
|00001c60| 74 68 65 20 63 6f 6c 75 | 6d 6e 20 74 6f 20 62 65 |the colu|mn to be|
|00001c70| 20 66 69 6c 74 65 72 65 | 64 20 66 72 6f 6d 20 74 | filtere|d from t|
|00001c80| 68 65 20 70 6f 70 75 70 | 20 6f 6e 20 0d 0a 74 68 |he popup| on ..th|
|00001c90| 65 20 6c 65 66 74 20 73 | 69 64 65 20 6f 66 20 74 |e left s|ide of t|
|00001ca0| 68 65 20 64 69 61 6c 6f | 67 20 61 6e 64 20 74 68 |he dialo|g and th|
|00001cb0| 65 20 63 6f 6e 64 69 74 | 69 6f 6e 20 6f 66 20 74 |e condit|ion of t|
|00001cc0| 68 65 20 66 69 6c 74 65 | 72 20 66 72 6f 6d 20 74 |he filte|r from t|
|00001cd0| 68 65 20 63 65 6e 74 65 | 72 20 70 6f 70 75 70 2e |he cente|r popup.|
|00001ce0| 20 54 79 70 65 20 74 68 | 65 20 63 6f 6d 70 61 72 | Type th|e compar|
|00001cf0| 69 73 6f 6e 20 0d 0a 6e | 75 6d 62 65 72 20 6f 72 |ison ..n|umber or|
|00001d00| 20 73 74 72 69 6e 67 20 | 69 6e 20 74 68 65 20 74 | string |in the t|
|00001d10| 65 78 74 20 62 6f 78 20 | 6f 6e 20 74 68 65 20 72 |ext box |on the r|
|00001d20| 69 67 68 74 20 73 69 64 | 65 20 6f 66 20 74 68 65 |ight sid|e of the|
|00001d30| 20 64 69 61 6c 6f 67 2e | 2e 20 20 41 20 63 6f 6e | dialog.|.  A con|
|00001d40| 64 69 74 69 6f 6e 20 63 | 61 6e 20 62 65 20 72 65 |dition c|an be re|
|00001d50| 76 65 72 73 65 64 20 62 | 79 20 63 68 65 63 6b 69 |versed b|y checki|
|00001d60| 6e 67 20 0d 0a 74 68 65 | 20 4e 4f 54 20 63 68 65 |ng ..the| NOT che|
|00001d70| 63 6b 20 62 6f 78 2e 20 | 20 43 68 6f 6f 73 65 20 |ck box. | Choose |
|00001d80| 4f 4b 20 74 6f 20 73 65 | 74 20 74 68 65 20 66 69 |OK to se|t the fi|
|00001d90| 6c 74 65 72 20 6f 72 20 | 43 61 6e 63 65 6c 20 74 |lter or |Cancel t|
|00001da0| 6f 20 6c 65 61 76 65 20 | 74 68 65 20 64 69 61 6c |o leave |the dial|
|00001db0| 6f 67 20 77 69 74 68 6f | 75 74 20 73 65 74 74 69 |og witho|ut setti|
|00001dc0| 6e 67 20 61 20 66 69 6c | 74 65 72 20 0d 0a 63 6f |ng a fil|ter ..co|
|00001dd0| 6e 64 69 74 69 6f 6e 2e | 0d 0a 0d 0a 09 45 78 65 |ndition.|.....Exe|
|00001de0| 63 75 74 65 20 62 75 74 | 74 6f 6e 20 2d 2d 20 45 |cute but|ton -- E|
|00001df0| 78 65 63 75 74 65 20 74 | 68 65 20 71 75 65 72 79 |xecute t|he query|
|00001e00| 2e 0d 0a 0d 0a 09 45 64 | 69 74 2e 2e 2e 20 62 75 |......Ed|it... bu|
|00001e10| 74 74 6f 6e 20 2d 2d 20 | 45 64 69 74 20 74 68 65 |tton -- |Edit the|
|00001e20| 20 53 51 4c 20 73 74 61 | 74 65 6d 65 6e 74 20 62 | SQL sta|tement b|
|00001e30| 75 69 6c 74 20 69 6e 20 | 74 68 65 20 42 75 69 6c |uilt in |the Buil|
|00001e40| 64 20 51 75 65 72 79 20 | 64 69 61 6c 6f 67 2e 0d |d Query |dialog..|
|00001e50| 0a 43 68 6f 6f 73 65 20 | 74 68 65 20 45 64 69 74 |.Choose |the Edit|
|00001e60| 2e 2e 2e 20 62 75 74 74 | 6f 6e 20 74 6f 20 6f 70 |... butt|on to op|
|00001e70| 65 6e 20 74 68 65 20 45 | 64 69 74 20 64 69 61 6c |en the E|dit dial|
|00001e80| 6f 67 2e 20 20 54 68 65 | 20 53 51 4c 20 73 74 61 |og.  The| SQL sta|
|00001e90| 74 65 6d 65 6e 74 20 62 | 75 69 6c 74 20 69 6e 20 |tement b|uilt in |
|00001ea0| 74 68 65 20 42 75 69 6c | 64 20 51 75 65 72 79 20 |the Buil|d Query |
|00001eb0| 64 69 61 6c 6f 67 20 69 | 73 20 0d 0a 64 69 73 70 |dialog i|s ..disp|
|00001ec0| 6c 61 79 65 64 20 69 6e | 20 61 20 74 65 78 74 20 |layed in| a text |
|00001ed0| 65 64 69 74 69 6e 67 20 | 77 69 6e 64 6f 77 20 73 |editing |window s|
|00001ee0| 6f 20 74 68 61 74 20 79 | 6f 75 20 63 61 6e 20 63 |o that y|ou can c|
|00001ef0| 75 73 74 6f 6d 69 7a 65 | 20 74 68 65 20 71 75 65 |ustomize| the que|
|00001f00| 72 79 2e 20 20 43 68 6f | 6f 73 65 20 74 68 65 20 |ry.  Cho|ose the |
|00001f10| 45 78 65 63 75 74 65 20 | 62 75 74 74 6f 6e 20 69 |Execute |button i|
|00001f20| 6e 20 74 68 65 20 0d 0a | 45 64 69 74 20 64 69 61 |n the ..|Edit dia|
|00001f30| 6c 6f 67 20 74 6f 20 65 | 78 65 63 75 74 65 20 74 |log to e|xecute t|
|00001f40| 68 65 20 53 51 4c 20 73 | 74 61 74 65 6d 65 6e 74 |he SQL s|tatement|
|00001f50| 2e 20 20 49 66 20 79 6f | 75 20 63 68 6f 6f 73 65 |.  If yo|u choose|
|00001f60| 20 43 61 6e 63 65 6c 2c | 20 74 68 65 20 45 64 69 | Cancel,| the Edi|
|00001f70| 74 20 64 69 61 6c 6f 67 | 20 63 6c 6f 73 65 73 20 |t dialog| closes |
|00001f80| 61 6e 64 20 74 68 65 20 | 71 75 65 72 79 20 69 73 |and the |query is|
|00001f90| 20 6e 6f 74 20 0d 0a 65 | 78 65 63 75 74 65 64 2e | not ..e|xecuted.|
|00001fa0| 0d 0a 0d 0a 09 43 6c 65 | 61 72 20 62 75 74 74 6f |.....Cle|ar butto|
|00001fb0| 6e 20 2d 2d 20 52 65 6d | 6f 76 65 20 61 6c 6c 20 |n -- Rem|ove all |
|00001fc0| 74 61 62 6c 65 73 2c 20 | 63 6f 6c 75 6d 6e 73 2c |tables, |columns,|
|00001fd0| 20 6a 6f 69 6e 20 63 6f | 6e 64 69 74 69 6f 6e 73 | join co|nditions|
|00001fe0| 2c 20 61 6e 64 20 66 69 | 6c 74 65 72 20 63 6f 6e |, and fi|lter con|
|00001ff0| 64 69 74 69 6f 6e 73 20 | 66 72 6f 6d 20 74 68 65 |ditions |from the|
|00002000| 20 71 75 65 72 79 20 0d | 0a 62 65 69 6e 67 20 62 | query .|.being b|
|00002010| 75 69 6c 74 2e 0d 0a 0d | 0a 09 43 6c 6f 73 65 20 |uilt....|..Close |
|00002020| 62 75 74 74 6f 6e 20 2d | 2d 20 43 6c 6f 73 65 20 |button -|- Close |
|00002030| 74 68 65 20 42 75 69 6c | 64 20 51 75 65 72 79 20 |the Buil|d Query |
|00002040| 64 69 61 6c 6f 67 2e 0d | 0a 0d 0a 59 6f 75 20 63 |dialog..|...You c|
|00002050| 61 6e 20 64 69 72 65 63 | 74 6c 79 20 65 64 69 74 |an direc|tly edit|
|00002060| 20 61 20 53 51 4c 20 73 | 74 61 74 65 6d 65 6e 74 | a SQL s|tatement|
|00002070| 20 62 79 20 63 68 6f 6f | 73 69 6e 67 20 45 64 69 | by choo|sing Edi|
|00002080| 74 20 51 75 65 72 79 2e | 2e 2e 20 66 72 6f 6d 20 |t Query.|.. from |
|00002090| 74 68 65 20 51 75 65 72 | 79 20 6d 65 6e 75 2e 20 |the Quer|y menu. |
|000020a0| 20 54 68 69 73 20 6f 70 | 65 6e 73 20 74 68 65 20 | This op|ens the |
|000020b0| 0d 0a 45 64 69 74 20 64 | 69 61 6c 6f 67 20 64 65 |..Edit d|ialog de|
|000020c0| 73 63 72 69 62 65 64 20 | 61 62 6f 76 65 2e 0d 0a |scribed |above...|
|000020d0| 0d 0a 54 6f 20 65 78 65 | 63 75 74 65 20 61 20 71 |..To exe|cute a q|
|000020e0| 75 65 72 79 20 61 6c 72 | 65 61 64 79 20 62 75 69 |uery alr|eady bui|
|000020f0| 6c 74 2c 20 63 68 6f 6f | 73 65 20 45 78 65 63 75 |lt, choo|se Execu|
|00002100| 74 65 20 51 75 65 72 79 | 20 66 72 6f 6d 20 74 68 |te Query| from th|
|00002110| 65 20 51 75 65 72 79 20 | 6d 65 6e 75 0d 0a 0d 0a |e Query |menu....|
|00002120| 0d 0a 20 20 20 20 20 2b | 3d 3d 3d 3d 3d 3d 3d 3d |..     +|========|
|00002130| 3d 3d 3d 3d 3d 3d 3d 3d | 3d 3d 3d 3d 3d 3d 3d 3d |========|========|
|00002140| 3d 3d 3d 3d 3d 3d 3d 3d | 3d 3d 3d 2b 0d 0a 20 20 |========|===+..  |
|00002150| 20 20 20 20 7c 20 20 20 | 20 20 20 20 20 20 20 20 |    |   |        |
|00002160| 20 20 20 20 20 20 20 20 | 53 45 54 54 49 4e 47 20 |        |SETTING |
|00002170| 4f 50 54 49 4f 4e 53 20 | 20 20 20 20 20 20 20 20 |OPTIONS |        |
|00002180| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |        |        |
|00002190| 20 20 7c 0d 0a 20 20 20 | 20 20 2b 3d 3d 3d 3d 3d |  |..   |  +=====|
|000021a0| 3d 3d 3d 3d 3d 3d 3d 3d | 3d 3d 3d 3d 3d 3d 3d 3d |========|========|
|000021b0| 3d 3d 3d 3d 3d 3d 3d 3d | 3d 3d 3d 3d 3d 3d 2b 0d |========|======+.|
|000021c0| 0a 0d 0a 54 6f 20 73 65 | 74 20 76 61 72 69 6f 75 |...To se|t variou|
|000021d0| 73 20 6f 70 74 69 6f 6e | 73 20 74 68 61 74 20 61 |s option|s that a|
|000021e0| 66 66 65 63 74 20 74 68 | 65 20 63 6f 6e 6e 65 63 |ffect th|e connec|
|000021f0| 74 69 6f 6e 20 74 6f 20 | 74 68 65 20 64 61 74 61 |tion to |the data|
|00002200| 20 73 6f 75 72 63 65 20 | 61 6e 64 20 74 68 65 20 | source |and the |
|00002210| 77 61 79 20 69 6e 20 77 | 68 69 63 68 20 72 65 73 |way in w|hich res|
|00002220| 75 6c 74 20 73 65 74 73 | 20 61 72 65 20 0d 0a 70 |ult sets| are ..p|
|00002230| 72 6f 63 65 73 73 65 64 | 2c 20 63 68 6f 6f 73 65 |rocessed|, choose|
|00002240| 20 4f 70 74 69 6f 6e 73 | 2e 2e 2e 20 66 72 6f 6d | Options|... from|
|00002250| 20 74 68 65 20 44 61 74 | 61 62 61 73 65 20 6d 65 | the Dat|abase me|
|00002260| 6e 75 2e 20 20 54 68 65 | 20 4f 70 74 69 6f 6e 73 |nu.  The| Options|
|00002270| 20 64 69 61 6c 6f 67 20 | 6f 70 65 6e 73 20 77 69 | dialog |opens wi|
|00002280| 74 68 20 74 68 65 20 66 | 6f 6c 6c 6f 77 69 6e 67 |th the f|ollowing|
|00002290| 20 0d 0a 6f 62 6a 65 63 | 74 73 3a 0d 0a 0d 0a 52 | ..objec|ts:....R|
|000022a0| 65 73 75 6c 74 20 53 65 | 74 20 2d 2d 20 44 65 74 |esult Se|t -- Det|
|000022b0| 65 72 6d 69 6e 65 20 77 | 68 65 74 68 65 72 20 72 |ermine w|hether r|
|000022c0| 65 73 75 6c 74 73 20 61 | 72 65 20 72 65 74 75 72 |esults a|re retur|
|000022d0| 6e 65 64 20 69 6e 20 63 | 75 72 73 6f 72 73 20 6f |ned in c|ursors o|
|000022e0| 72 20 74 61 62 6c 65 73 | 2e 0d 0a 0d 0a 45 78 65 |r tables|.....Exe|
|000022f0| 63 75 74 69 6f 6e 20 4d | 6f 64 65 20 2d 2d 20 44 |cution M|ode -- D|
|00002300| 65 74 65 72 6d 69 6e 65 | 20 77 68 65 74 68 65 72 |etermine| whether|
|00002310| 20 6f 70 65 72 61 74 69 | 6f 6e 73 20 6f 76 65 72 | operati|ons over|
|00002320| 20 74 68 65 20 64 61 74 | 61 20 73 6f 75 72 63 65 | the dat|a source|
|00002330| 20 63 6f 6e 6e 65 63 74 | 69 6f 6e 20 61 72 65 20 | connect|ion are |
|00002340| 70 72 6f 63 65 73 73 65 | 64 20 0d 0a 73 79 6e 63 |processe|d ..sync|
|00002350| 68 72 6f 6e 6f 75 73 6c | 79 2c 20 73 6f 20 74 68 |hronousl|y, so th|
|00002360| 61 74 20 74 68 65 20 65 | 6e 74 69 72 65 20 70 72 |at the e|ntire pr|
|00002370| 6f 63 65 64 75 72 65 20 | 69 73 20 70 65 72 66 6f |ocedure |is perfo|
|00002380| 72 6d 65 64 20 62 65 66 | 6f 72 65 20 63 6f 6e 74 |rmed bef|ore cont|
|00002390| 72 6f 6c 20 69 73 20 72 | 65 74 75 72 6e 65 64 20 |rol is r|eturned |
|000023a0| 74 6f 20 43 4b 53 41 4d | 50 4c 45 2e 41 50 50 2c |to CKSAM|PLE.APP,|
|000023b0| 20 6f 72 20 0d 0a 61 73 | 79 6e 63 68 72 6f 6e 6f | or ..as|ynchrono|
|000023c0| 75 73 6c 79 2c 20 73 6f | 20 74 68 61 74 20 63 6f |usly, so| that co|
|000023d0| 6e 74 72 6f 6c 20 69 73 | 20 70 65 72 69 6f 64 69 |ntrol is| periodi|
|000023e0| 63 61 6c 6c 79 20 72 65 | 74 75 72 6e 65 64 20 74 |cally re|turned t|
|000023f0| 6f 20 43 4b 53 41 4d 50 | 4c 45 2e 41 50 50 2e 0d |o CKSAMP|LE.APP..|
|00002400| 0a 0d 0a 54 69 6d 65 6f | 75 74 20 28 69 6e 20 73 |...Timeo|ut (in s|
|00002410| 65 63 6f 6e 64 73 29 20 | 2d 2d 20 44 65 74 65 72 |econds) |-- Deter|
|00002420| 6d 69 6e 65 20 74 68 65 | 20 6c 65 6e 67 74 68 20 |mine the| length |
|00002430| 6f 66 20 74 69 6d 65 20 | 69 6e 20 73 65 63 6f 6e |of time |in secon|
|00002440| 64 73 20 46 6f 78 50 72 | 6f 20 77 69 6c 6c 20 77 |ds FoxPr|o will w|
|00002450| 61 69 74 20 62 65 66 6f | 72 65 20 74 69 6d 69 6e |ait befo|re timin|
|00002460| 67 20 6f 75 74 20 66 6f | 72 20 61 20 0d 0a 63 6f |g out fo|r a ..co|
|00002470| 6e 6e 65 63 74 69 6f 6e | 20 74 6f 20 62 65 20 6d |nnection| to be m|
|00002480| 61 64 65 20 6f 72 20 66 | 6f 72 20 61 20 63 6f 6e |ade or f|or a con|
|00002490| 6e 65 63 74 69 6f 6e 20 | 61 6c 72 65 61 64 79 20 |nection |already |
|000024a0| 6d 61 64 65 20 74 6f 20 | 72 65 73 70 6f 6e 64 2e |made to |respond.|
|000024b0| 0d 0a 0d 0a 4d 65 6d 6f | 20 63 75 74 6f 66 66 20 |....Memo| cutoff |
|000024c0| 2d 2d 20 44 65 74 65 72 | 6d 69 6e 65 20 74 68 65 |-- Deter|mine the|
|000024d0| 20 6d 69 6e 69 6d 75 6d | 20 6c 65 6e 67 74 68 20 | minimum| length |
|000024e0| 6f 66 20 61 20 63 6f 6c | 75 6d 6e 20 66 6f 72 20 |of a col|umn for |
|000024f0| 69 74 20 74 6f 20 73 74 | 6f 72 65 64 20 69 6e 20 |it to st|ored in |
|00002500| 61 20 46 6f 78 50 72 6f | 20 74 61 62 6c 65 20 6f |a FoxPro| table o|
|00002510| 72 20 63 75 72 73 6f 72 | 20 61 73 20 61 20 0d 0a |r cursor| as a ..|
|00002520| 6d 65 6d 6f 20 66 69 65 | 6c 64 2e 20 20 43 6f 6c |memo fie|ld.  Col|
|00002530| 75 6d 6e 73 20 73 68 6f | 72 74 65 72 20 74 68 61 |umns sho|rter tha|
|00002540| 6e 20 74 68 65 20 63 75 | 74 6f 66 66 20 61 72 65 |n the cu|toff are|
|00002550| 20 73 74 6f 72 65 64 20 | 61 73 20 6e 6f 72 6d 61 | stored |as norma|
|00002560| 6c 20 66 69 65 6c 64 73 | 20 69 6e 20 61 20 46 6f |l fields| in a Fo|
|00002570| 78 50 72 6f 20 74 61 62 | 6c 65 20 6f 72 20 63 75 |xPro tab|le or cu|
|00002580| 72 73 6f 72 2e 0d 0a 0d | 0a 44 69 73 70 6c 61 79 |rsor....|.Display|
|00002590| 20 56 69 65 77 20 77 69 | 6e 64 6f 77 20 2d 2d 20 | View wi|ndow -- |
|000025a0| 44 69 73 70 6c 61 79 73 | 20 74 68 65 20 56 69 65 |Displays| the Vie|
|000025b0| 77 20 77 69 6e 64 6f 77 | 2e 20 20 54 68 65 20 56 |w window|.  The V|
|000025c0| 69 65 77 20 77 69 6e 64 | 6f 77 20 6d 75 73 74 20 |iew wind|ow must |
|000025d0| 62 65 20 6f 70 65 6e 20 | 74 6f 20 43 6f 6e 76 65 |be open |to Conve|
|000025e0| 72 74 20 61 20 6d 65 6d | 6f 2c 20 0d 0a 77 68 69 |rt a mem|o, ..whi|
|000025f0| 63 68 20 69 73 20 64 65 | 73 63 72 69 62 65 64 20 |ch is de|scribed |
|00002600| 69 6e 20 74 68 65 20 66 | 6f 6c 6c 6f 77 69 6e 67 |in the f|ollowing|
|00002610| 20 73 65 63 74 69 6f 6e | 2e 0d 0a 0d 0a 0d 0a 20 | section|....... |
|00002620| 20 20 20 20 2b 3d 3d 3d | 3d 3d 3d 3d 3d 3d 3d 3d |    +===|========|
|00002630| 3d 3d 3d 3d 3d 3d 3d 3d | 3d 3d 3d 3d 3d 3d 3d 3d |========|========|
|00002640| 3d 3d 3d 3d 3d 3d 3d 3d | 2b 0d 0a 20 20 20 20 20 |========|+..     |
|00002650| 20 7c 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | |      |        |
|00002660| 20 20 43 4f 56 45 52 54 | 49 4e 47 20 41 20 4d 45 |  COVERT|ING A ME|
|00002670| 4d 4f 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |MO      |        |
|00002680| 20 20 20 20 20 20 20 20 | 20 20 7c 0d 0a 20 20 20 |        |  |..   |
|00002690| 20 20 2b 3d 3d 3d 3d 3d | 3d 3d 3d 3d 3d 3d 3d 3d |  +=====|========|
|000026a0| 3d 3d 3d 3d 3d 3d 3d 3d | 3d 3d 3d 3d 3d 3d 3d 3d |========|========|
|000026b0| 3d 3d 3d 3d 3d 3d 2b 0d | 0a 0d 0a 44 61 74 61 20 |======+.|...Data |
|000026c0| 73 6f 75 72 63 65 20 6d | 65 6d 6f 20 63 6f 6c 75 |source m|emo colu|
|000026d0| 6d 6e 73 20 63 61 6e 20 | 6f 66 74 65 6e 20 63 6f |mns can |often co|
|000026e0| 6e 74 61 69 6e 20 62 69 | 6e 61 72 79 20 69 6e 66 |ntain bi|nary inf|
|000026f0| 6f 72 6d 61 74 69 6f 6e | 20 61 73 20 77 65 6c 6c |ormation| as well|
|00002700| 20 61 73 20 74 65 78 74 | 2e 20 20 42 69 6e 61 72 | as text|.  Binar|
|00002710| 79 20 64 61 74 61 20 69 | 73 20 73 74 6f 72 65 64 |y data i|s stored|
|00002720| 20 69 6e 20 0d 0a 67 65 | 6e 65 72 61 6c 20 66 69 | in ..ge|neral fi|
|00002730| 65 6c 64 73 20 69 6e 20 | 46 6f 78 50 72 6f 20 74 |elds in |FoxPro t|
|00002740| 61 62 6c 65 73 2e 20 20 | 54 6f 20 63 6f 6e 76 65 |ables.  |To conve|
|00002750| 72 74 20 62 69 6e 61 72 | 79 20 69 6e 66 6f 72 6d |rt binar|y inform|
|00002760| 61 74 69 6f 6e 20 66 72 | 6f 6d 20 61 20 64 61 74 |ation fr|om a dat|
|00002770| 61 20 73 6f 75 72 63 65 | 20 71 75 65 72 79 20 77 |a source| query w|
|00002780| 68 69 63 68 20 68 61 73 | 20 62 65 65 6e 20 0d 0a |hich has| been ..|
|00002790| 73 74 6f 72 65 64 20 74 | 6f 20 61 20 6d 65 6d 6f |stored t|o a memo|
|000027a0| 20 66 69 65 6c 64 20 69 | 6e 20 61 20 46 6f 78 50 | field i|n a FoxP|
|000027b0| 72 6f 20 74 61 62 6c 65 | 20 69 6e 74 6f 20 61 20 |ro table| into a |
|000027c0| 67 65 6e 65 72 61 6c 20 | 74 79 70 65 3a 0d 0a 0d |general |type:...|
|000027d0| 0a 09 31 2e 20 20 4d 61 | 6b 65 20 73 75 72 65 20 |..1.  Ma|ke sure |
|000027e0| 74 68 65 20 56 69 65 77 | 20 57 69 6e 64 6f 77 20 |the View| Window |
|000027f0| 69 73 20 6f 70 65 6e 2e | 20 20 59 6f 75 20 63 61 |is open.|  You ca|
|00002800| 6e 20 6f 70 65 6e 20 74 | 68 65 20 56 69 65 77 20 |n open t|he View |
|00002810| 77 69 6e 64 6f 77 20 62 | 79 20 63 68 6f 6f 73 69 |window b|y choosi|
|00002820| 6e 67 20 4f 70 74 69 6f | 6e 73 2e 2e 2e 20 0d 0a |ng Optio|ns... ..|
|00002830| 66 72 6f 6d 20 74 68 65 | 20 44 61 74 61 62 61 73 |from the| Databas|
|00002840| 65 20 6d 65 6e 75 20 61 | 6e 64 20 63 68 6f 6f 73 |e menu a|nd choos|
|00002850| 69 6e 67 20 74 68 65 20 | 44 69 73 70 6c 61 79 20 |ing the |Display |
|00002860| 56 69 65 77 20 57 69 6e | 64 6f 77 20 63 68 65 63 |View Win|dow chec|
|00002870| 6b 20 62 6f 78 20 69 6e | 20 74 68 65 20 4f 70 74 |k box in| the Opt|
|00002880| 69 6f 6e 73 20 64 69 61 | 6c 6f 67 2e 0d 0a 0d 0a |ions dia|log.....|
|00002890| 09 32 2e 20 20 4d 61 6b | 65 20 73 75 72 65 20 74 |.2.  Mak|e sure t|
|000028a0| 68 61 74 20 72 65 73 75 | 6c 74 20 73 65 74 73 20 |hat resu|lt sets |
|000028b0| 61 72 65 20 72 65 74 75 | 72 6e 65 64 20 69 6e 20 |are retu|rned in |
|000028c0| 74 61 62 6c 65 73 2e 20 | 20 49 66 20 72 65 73 75 |tables. | If resu|
|000028d0| 6c 74 20 73 65 74 73 20 | 61 72 65 20 72 65 74 75 |lt sets |are retu|
|000028e0| 72 6e 65 64 20 69 6e 20 | 63 75 72 73 6f 72 73 2c |rned in |cursors,|
|000028f0| 20 79 6f 75 20 0d 0a 63 | 61 6e 6e 6f 74 20 63 6f | you ..c|annot co|
|00002900| 6e 76 65 72 74 20 6d 65 | 6d 6f 20 66 69 65 6c 64 |nvert me|mo field|
|00002910| 73 20 74 6f 20 67 65 6e | 65 72 61 6c 20 66 69 65 |s to gen|eral fie|
|00002920| 6c 64 73 2e 0d 0a 0d 0a | 09 33 2e 20 20 45 78 65 |lds.....|.3.  Exe|
|00002930| 63 75 74 65 20 61 20 53 | 51 4c 20 71 75 65 72 79 |cute a S|QL query|
|00002940| 20 74 68 61 74 20 63 72 | 65 61 74 65 73 20 61 20 | that cr|eates a |
|00002950| 74 61 62 6c 65 20 6f 72 | 20 63 75 72 73 6f 72 20 |table or| cursor |
|00002960| 77 69 74 68 20 61 20 6d | 65 6d 6f 20 66 69 65 6c |with a m|emo fiel|
|00002970| 64 2e 20 20 46 6f 72 20 | 69 6e 66 6f 72 6d 61 74 |d.  For |informat|
|00002980| 69 6f 6e 20 61 62 6f 75 | 74 20 0d 0a 65 78 65 63 |ion abou|t ..exec|
|00002990| 75 74 69 6e 67 20 61 20 | 71 75 65 72 79 2c 20 73 |uting a |query, s|
|000029a0| 65 65 20 74 68 65 20 73 | 65 63 74 69 6f 6e 20 74 |ee the s|ection t|
|000029b0| 69 74 6c 65 64 20 43 52 | 45 41 54 49 4e 47 20 41 |itled CR|EATING A|
|000029c0| 20 51 55 45 52 59 20 61 | 62 6f 76 65 2e 0d 0a 0d | QUERY a|bove....|
|000029d0| 0a 09 34 2e 20 20 43 68 | 6f 6f 73 65 20 43 6f 6e |..4.  Ch|oose Con|
|000029e0| 76 65 72 74 20 4d 65 6d | 6f 2e 2e 2e 20 66 72 6f |vert Mem|o... fro|
|000029f0| 6d 20 74 68 65 20 44 61 | 74 61 62 61 73 65 20 6d |m the Da|tabase m|
|00002a00| 65 6e 75 2e 0d 0a 0d 0a | 09 35 2e 20 20 53 65 6c |enu.....|.5.  Sel|
|00002a10| 65 63 74 20 74 68 65 20 | 6d 65 6d 6f 20 74 6f 20 |ect the |memo to |
|00002a20| 63 6f 6e 76 65 72 74 20 | 69 6e 20 74 68 65 20 43 |convert |in the C|
|00002a30| 6f 6e 76 65 72 74 20 4d | 65 6d 6f 20 64 69 61 6c |onvert M|emo dial|
|00002a40| 6f 67 20 61 6e 64 20 63 | 68 6f 6f 73 65 20 4f 4b |og and c|hoose OK|
|00002a50| 2e 0d 0a 20 20 20 20 20 | 20 20 0d 0a 0d 0a 0d 0a |...     |  ......|
|00002a60| 0d 0a 0d 0a 6c 39 d4 ca | 4a 0e ad 5a d6 2e e3 49 |....l9..|J..Z...I|
|00002a70| c1 75 75 0c 75 d0 cc 08 | 54 06 1e 1a eb 39 eb 0c |.uu.u...|T....9..|
|00002a80| 00 00 00 01 00 00 25 9f | 0d 0a 54 68 65 20 43 4b |......%.|..The CK|
|00002a90| 53 41 4d 50 4c 45 20 61 | 70 70 6c 69 63 61 74 69 |SAMPLE a|pplicati|
|00002aa0| 6f 6e 20 6c 65 74 73 20 | 79 6f 75 20 71 75 69 63 |on lets |you quic|
|00002ab0| 6b 6c 79 20 61 6e 64 20 | 65 61 73 69 6c 79 20 70 |kly and |easily p|
|00002ac0| 65 72 66 6f 72 6d 20 73 | 6f 6d 65 20 6f 66 20 74 |erform s|ome of t|
|00002ad0| 68 65 20 62 61 73 69 63 | 20 6f 70 65 72 61 74 69 |he basic| operati|
|00002ae0| 6f 6e 73 20 61 73 73 6f | 63 69 61 74 65 64 20 77 |ons asso|ciated w|
|00002af0| 69 74 68 20 61 20 63 6c | 69 65 6e 74 20 66 72 6f |ith a cl|ient fro|
|00002b00| 6e 74 20 65 6e 64 2c 20 | 73 75 63 68 20 61 73 20 |nt end, |such as |
|00002b10| 63 6f 6e 6e 65 63 74 69 | 6e 67 20 74 6f 20 61 20 |connecti|ng to a |
|00002b20| 64 61 74 61 20 73 6f 75 | 72 63 65 2c 20 75 73 69 |data sou|rce, usi|
|00002b30| 6e 67 20 61 20 64 61 74 | 61 62 61 73 65 20 6f 6e |ng a dat|abase on|
|00002b40| 20 74 68 65 20 64 61 74 | 61 20 73 6f 75 72 63 65 | the dat|a source|
|00002b50| 2c 20 61 6e 64 20 71 75 | 65 72 79 69 6e 67 20 64 |, and qu|erying d|
|00002b60| 61 74 61 2e 20 43 4b 53 | 41 4d 50 4c 45 20 61 6c |ata. CKS|AMPLE al|
|00002b70| 73 6f 20 6c 65 74 73 20 | 79 6f 75 20 73 65 74 20 |so lets |you set |
|00002b80| 76 61 72 69 6f 75 73 20 | 6f 70 74 69 6f 6e 73 2c |various |options,|
|00002b90| 20 65 64 69 74 20 53 51 | 4c 20 63 6f 6d 6d 61 6e | edit SQ|L comman|
|00002ba0| 64 73 20 74 6f 20 62 65 | 20 73 65 6e 74 20 74 6f |ds to be| sent to|
|00002bb0| 20 74 68 65 20 64 61 74 | 61 20 0d 0a 73 6f 75 72 | the dat|a ..sour|
|00002bc0| 63 65 2c 20 61 6e 64 20 | 63 6f 6e 76 65 72 74 20 |ce, and |convert |
|00002bd0| 61 20 64 61 74 61 20 73 | 6f 75 72 63 65 20 6d 65 |a data s|ource me|
|00002be0| 6d 6f 20 66 69 65 6c 64 | 20 77 69 74 68 20 62 69 |mo field| with bi|
|00002bf0| 6e 61 72 79 20 64 61 74 | 61 20 74 6f 20 61 20 46 |nary dat|a to a F|
|00002c00| 6f 78 50 72 6f 20 67 65 | 6e 65 72 61 6c 20 74 79 |oxPro ge|neral ty|
|00002c10| 70 65 20 66 69 65 6c 64 | 2e 0d 0a 0d 0a d6 c4 c4 |pe field|........|
|00002c20| c4 c4 c4 c4 c4 c4 c4 c4 | c4 c4 c4 c4 c4 c4 c4 c4 |........|........|
|00002c30| c4 c4 c4 c4 c4 c4 c4 c4 | c4 c4 c4 c4 c4 c4 c4 b7 |........|........|
|00002c40| 0d 0a ba 20 20 43 6f 6e | 6e 65 63 74 69 6e 67 20 |...  Con|necting |
|00002c50| 74 6f 20 61 20 44 61 74 | 61 20 53 6f 75 72 63 65 |to a Dat|a Source|
|00002c60| 20 20 20 20 ba 0d 0a d3 | c4 c4 c4 c4 c4 c4 c4 c4 |    ....|........|
|00002c70| c4 c4 c4 c4 c4 c4 c4 c4 | c4 c4 c4 c4 c4 c4 c4 c4 |........|........|
|00002c80| c4 c4 c4 c4 c4 c4 c4 c4 | c4 bd 0d 0a 0d 0a 4e 4f |........|......NO|
|00002c90| 54 45 3a 20 20 42 65 66 | 6f 72 65 20 79 6f 75 20 |TE:  Bef|ore you |
|00002ca0| 63 61 6e 20 63 6f 6e 6e | 65 63 74 20 74 6f 20 61 |can conn|ect to a|
|00002cb0| 20 64 61 74 61 20 73 6f | 75 72 63 65 2c 20 74 68 | data so|urce, th|
|00002cc0| 65 20 61 70 70 72 6f 70 | 72 69 61 74 65 20 64 72 |e approp|riate dr|
|00002cd0| 69 76 65 72 20 66 6f 72 | 20 74 68 65 20 64 61 74 |iver for| the dat|
|00002ce0| 61 20 73 6f 75 72 63 65 | 20 6d 75 73 74 20 68 61 |a source| must ha|
|00002cf0| 76 65 20 70 72 65 76 69 | 6f 75 73 6c 79 20 62 65 |ve previ|ously be|
|00002d00| 65 6e 20 69 6e 73 74 61 | 6c 6c 65 64 20 6f 6e 20 |en insta|lled on |
|00002d10| 79 6f 75 72 20 6d 61 63 | 68 69 6e 65 2e 0d 0a 0d |your mac|hine....|
|00002d20| 0a 57 68 65 6e 20 79 6f | 75 20 72 75 6e 20 43 4b |.When yo|u run CK|
|00002d30| 53 41 4d 50 4c 45 2e 41 | 50 50 2c 20 74 68 65 20 |SAMPLE.A|PP, the |
|00002d40| 43 6f 6e 6e 65 63 74 20 | 74 6f 20 44 61 74 61 20 |Connect |to Data |
|00002d50| 53 6f 75 72 63 65 20 64 | 69 61 6c 6f 67 20 6f 70 |Source d|ialog op|
|00002d60| 65 6e 73 2e 20 20 54 68 | 69 73 20 64 69 61 6c 6f |ens.  Th|is dialo|
|00002d70| 67 20 63 6f 6e 74 61 69 | 6e 73 20 74 68 65 20 66 |g contai|ns the f|
|00002d80| 6f 6c 6c 6f 77 69 6e 67 | 20 6f 62 6a 65 63 74 73 |ollowing| objects|
|00002d90| 3a 0d 0a 0d 0a 09 44 61 | 74 61 20 53 6f 75 72 63 |:.....Da|ta Sourc|
|00002da0| 65 20 74 65 78 74 20 62 | 6f 78 20 2d 2d 20 74 79 |e text b|ox -- ty|
|00002db0| 70 65 20 74 68 65 20 6e | 61 6d 65 20 6f 66 20 74 |pe the n|ame of t|
|00002dc0| 68 65 20 64 61 74 61 20 | 73 6f 75 72 63 65 20 74 |he data |source t|
|00002dd0| 6f 20 77 68 69 63 68 20 | 79 6f 75 20 77 61 6e 74 |o which |you want|
|00002de0| 20 74 6f 20 63 6f 6e 6e | 65 63 74 2e 20 54 68 69 | to conn|ect. Thi|
|00002df0| 73 20 69 6e 66 6f 72 6d | 61 74 69 6f 6e 20 69 73 |s inform|ation is|
|00002e00| 20 72 65 71 75 69 72 65 | 64 20 69 6e 20 6f 72 64 | require|d in ord|
|00002e10| 65 72 20 74 6f 20 63 6f | 6e 6e 65 63 74 20 74 6f |er to co|nnect to|
|00002e20| 20 61 20 64 61 74 61 20 | 73 6f 75 72 63 65 2e 0d | a data |source..|
|00002e30| 0a 0d 0a 09 55 73 65 72 | 20 49 64 65 6e 74 69 66 |....User| Identif|
|00002e40| 69 65 72 20 74 65 78 74 | 20 62 6f 78 20 2d 2d 20 |ier text| box -- |
|00002e50| 74 79 70 65 20 74 68 65 | 20 75 73 65 72 20 69 64 |type the| user id|
|00002e60| 65 6e 74 69 66 69 63 61 | 74 69 6f 6e 20 75 6e 64 |entifica|tion und|
|00002e70| 65 72 20 77 68 69 63 68 | 20 79 6f 75 20 77 61 6e |er which| you wan|
|00002e80| 74 20 74 6f 20 6c 6f 67 | 20 6f 6e 20 74 6f 20 74 |t to log| on to t|
|00002e90| 68 65 20 64 61 74 61 20 | 73 6f 75 72 63 65 2e 20 |he data |source. |
|00002ea0| 54 68 69 73 20 69 6e 66 | 6f 72 6d 61 74 69 6f 6e |This inf|ormation|
|00002eb0| 20 69 73 20 72 65 71 75 | 69 72 65 64 20 69 6e 20 | is requ|ired in |
|00002ec0| 6f 72 64 65 72 20 74 6f | 20 63 6f 6e 6e 65 63 74 |order to| connect|
|00002ed0| 20 74 6f 20 61 20 64 61 | 74 61 20 73 6f 75 72 63 | to a da|ta sourc|
|00002ee0| 65 2e 0d 0a 0d 0a 09 50 | 61 73 73 77 6f 72 64 20 |e......P|assword |
|00002ef0| 74 65 78 74 20 62 6f 78 | 20 2d 2d 20 49 66 20 74 |text box| -- If t|
|00002f00| 68 65 20 64 61 74 61 20 | 73 6f 75 72 63 65 20 68 |he data |source h|
|00002f10| 61 73 20 70 61 73 73 77 | 6f 72 64 20 70 72 6f 74 |as passw|ord prot|
|00002f20| 65 63 74 69 6f 6e 2c 20 | 74 79 70 65 20 74 68 65 |ection, |type the|
|00002f30| 20 70 61 73 73 77 6f 72 | 64 20 69 6e 20 74 68 69 | passwor|d in thi|
|00002f40| 73 20 74 65 78 74 20 62 | 6f 78 2e 20 49 66 20 74 |s text b|ox. If t|
|00002f50| 68 65 20 64 61 74 61 20 | 73 6f 75 72 63 65 20 64 |he data |source d|
|00002f60| 6f 65 73 6e 27 74 20 72 | 65 71 75 69 72 65 20 61 |oesn't r|equire a|
|00002f70| 20 70 61 73 73 77 6f 72 | 64 2c 20 74 68 69 73 20 | passwor|d, this |
|00002f80| 74 65 78 74 20 62 6f 78 | 20 63 61 6e 20 62 65 20 |text box| can be |
|00002f90| 6c 65 66 74 20 65 6d 70 | 74 79 2e 0d 0a 0d 0a 09 |left emp|ty......|
|00002fa0| 43 6f 6e 6e 65 63 74 20 | 53 74 72 69 6e 67 20 74 |Connect |String t|
|00002fb0| 65 78 74 20 62 6f 78 20 | 2d 2d 20 49 66 20 74 68 |ext box |-- If th|
|00002fc0| 65 20 64 61 74 61 20 73 | 6f 75 72 63 65 20 61 63 |e data s|ource ac|
|00002fd0| 63 65 70 74 73 20 69 6e | 73 74 72 75 63 74 69 6f |cepts in|structio|
|00002fe0| 6e 73 20 6f 72 20 63 6f | 6d 6d 61 6e 64 73 20 77 |ns or co|mmands w|
|00002ff0| 68 65 6e 20 61 20 63 6f | 6e 6e 65 63 74 69 6f 6e |hen a co|nnection|
|00003000| 20 69 73 20 6d 61 64 65 | 2c 20 79 6f 75 20 63 61 | is made|, you ca|
|00003010| 6e 20 69 6e 63 6c 75 64 | 65 20 74 68 61 74 20 69 |n includ|e that i|
|00003020| 6e 73 74 72 75 63 74 69 | 6f 6e 20 69 6e 20 74 68 |nstructi|on in th|
|00003030| 65 20 43 6f 6e 6e 65 63 | 74 20 53 74 72 69 6e 67 |e Connec|t String|
|00003040| 20 74 65 78 74 20 62 6f | 78 2e 20 20 49 66 20 74 | text bo|x.  If t|
|00003050| 68 65 20 64 61 74 61 20 | 73 6f 75 72 63 65 20 64 |he data |source d|
|00003060| 6f 65 73 20 6e 6f 74 20 | 61 63 63 65 70 74 20 69 |oes not |accept i|
|00003070| 6e 73 74 72 75 63 74 69 | 6f 6e 73 20 6f 72 20 63 |nstructi|ons or c|
|00003080| 6f 6d 6d 61 6e 64 73 20 | 61 74 20 74 68 65 20 74 |ommands |at the t|
|00003090| 69 6d 65 20 6f 66 20 63 | 6f 6e 6e 65 63 74 69 6f |ime of c|onnectio|
|000030a0| 6e 2c 20 61 6e 79 74 68 | 69 6e 67 20 74 79 70 65 |n, anyth|ing type|
|000030b0| 64 20 69 6e 20 74 68 65 | 20 43 6f 6e 6e 65 63 74 |d in the| Connect|
|000030c0| 20 53 74 72 69 6e 67 20 | 74 65 78 74 20 62 6f 78 | String |text box|
|000030d0| 20 69 73 20 69 67 6e 6f | 72 65 64 2e 20 20 54 68 | is igno|red.  Th|
|000030e0| 69 73 20 74 65 78 74 20 | 62 6f 78 20 63 61 6e 20 |is text |box can |
|000030f0| 62 65 20 6c 65 66 74 20 | 65 6d 70 74 79 2e 0d 0a |be left |empty...|
|00003100| 0d 0a 09 4f 4b 20 61 6e | 64 20 43 61 6e 63 65 6c |...OK an|d Cancel|
|00003110| 20 62 75 74 74 6f 6e 73 | 20 2d 2d 20 43 68 6f 6f | buttons| -- Choo|
|00003120| 73 65 20 4f 4b 20 74 6f | 20 61 74 74 65 6d 70 74 |se OK to| attempt|
|00003130| 20 74 68 65 20 63 6f 6e | 6e 65 63 74 69 6f 6e 20 | the con|nection |
|00003140| 73 70 65 63 69 66 69 65 | 64 20 69 6e 20 74 68 65 |specifie|d in the|
|00003150| 20 76 61 72 69 6f 75 73 | 20 74 65 78 74 20 62 6f | various| text bo|
|00003160| 78 65 73 20 69 6e 20 74 | 68 69 73 20 64 69 61 6c |xes in t|his dial|
|00003170| 6f 67 2e 20 49 66 20 74 | 68 65 20 63 6f 6e 6e 65 |og. If t|he conne|
|00003180| 63 74 69 6f 6e 20 69 73 | 20 73 75 63 63 65 73 73 |ction is| success|
|00003190| 66 75 6c 2c 20 61 20 73 | 75 63 63 65 73 73 66 75 |ful, a s|uccessfu|
|000031a0| 6c 20 63 6f 6e 6e 65 63 | 74 69 6f 6e 20 6d 65 73 |l connec|tion mes|
|000031b0| 73 61 67 65 20 69 73 20 | 64 69 73 70 6c 61 79 65 |sage is |displaye|
|000031c0| 64 20 69 6e 20 61 20 77 | 61 69 74 20 77 69 6e 64 |d in a w|ait wind|
|000031d0| 6f 77 20 61 6e 64 20 74 | 68 65 20 6e 61 6d 65 20 |ow and t|he name |
|000031e0| 6f 66 20 74 68 65 20 64 | 61 74 61 20 73 6f 75 72 |of the d|ata sour|
|000031f0| 63 65 20 69 73 20 64 69 | 73 70 6c 61 79 65 64 20 |ce is di|splayed |
|00003200| 6f 6e 20 74 68 65 20 73 | 74 61 74 75 73 20 62 61 |on the s|tatus ba|
|00003210| 72 2e 20 49 66 20 79 6f | 75 20 63 61 6e 6e 6f 74 |r. If yo|u cannot|
|00003220| 20 63 6f 6e 6e 65 63 74 | 2c 20 61 6e 20 65 72 72 | connect|, an err|
|00003230| 6f 72 20 6d 65 73 73 61 | 67 65 20 69 73 20 64 69 |or messa|ge is di|
|00003240| 73 70 6c 61 79 65 64 20 | 61 6e 64 20 79 6f 75 20 |splayed |and you |
|00003250| 61 72 65 20 72 65 74 75 | 72 6e 65 64 20 74 6f 20 |are retu|rned to |
|00003260| 74 68 65 20 64 69 61 6c | 6f 67 2e 0d 0a 0d 0a 09 |the dial|og......|
|00003270| 57 68 65 6e 20 79 6f 75 | 20 72 75 6e 20 43 4b 53 |When you| run CKS|
|00003280| 41 4d 50 4c 45 2e 41 50 | 50 2c 20 79 6f 75 20 6d |AMPLE.AP|P, you m|
|00003290| 75 73 74 20 63 6f 6e 6e | 65 63 74 20 74 6f 20 61 |ust conn|ect to a|
|000032a0| 20 64 61 74 61 20 73 6f | 75 72 63 65 2e 20 20 49 | data so|urce.  I|
|000032b0| 66 20 79 6f 75 20 63 68 | 6f 6f 73 65 20 43 61 6e |f you ch|oose Can|
|000032c0| 63 65 6c 2c 20 43 4b 53 | 41 4d 50 4c 45 2e 41 50 |cel, CKS|AMPLE.AP|
|000032d0| 50 20 74 65 72 6d 69 6e | 61 74 65 73 2e 0d 0a 0d |P termin|ates....|
|000032e0| 0a 09 54 6f 20 63 68 61 | 6e 67 65 20 64 61 74 61 |..To cha|nge data|
|000032f0| 20 73 6f 75 72 63 65 20 | 63 6f 6e 6e 65 63 74 69 | source |connecti|
|00003300| 6f 6e 73 2c 20 63 68 6f | 6f 73 65 20 44 69 73 63 |ons, cho|ose Disc|
|00003310| 6f 6e 6e 65 63 74 20 66 | 72 6f 6d 20 74 68 65 20 |onnect f|rom the |
|00003320| 44 61 74 61 62 61 73 65 | 20 6d 65 6e 75 2c 20 74 |Database| menu, t|
|00003330| 68 65 6e 20 63 68 6f 6f | 73 65 20 43 6f 6e 6e 65 |hen choo|se Conne|
|00003340| 63 74 2e 2e 2e 20 66 72 | 6f 6d 20 74 68 65 20 44 |ct... fr|om the D|
|00003350| 61 74 61 62 61 73 65 20 | 6d 65 6e 75 2e 20 20 54 |atabase |menu.  T|
|00003360| 68 65 20 43 6f 6e 6e 65 | 63 74 20 74 6f 20 44 61 |he Conne|ct to Da|
|00003370| 74 61 20 53 6f 75 72 63 | 65 20 64 69 61 6c 6f 67 |ta Sourc|e dialog|
|00003380| 20 6f 70 65 6e 73 2e 20 | 20 41 67 61 69 6e 2c 20 | opens. | Again, |
|00003390| 79 6f 75 20 6e 65 65 64 | 20 74 6f 20 69 6e 64 69 |you need| to indi|
|000033a0| 63 61 74 65 20 61 20 64 | 61 74 61 20 73 6f 75 72 |cate a d|ata sour|
|000033b0| 63 65 20 74 6f 20 63 6f | 6e 6e 65 63 74 20 74 6f |ce to co|nnect to|
|000033c0| 20 61 6e 64 20 61 20 75 | 73 65 72 20 69 64 65 6e | and a u|ser iden|
|000033d0| 74 69 66 69 63 61 74 69 | 6f 6e 2c 20 61 73 20 77 |tificati|on, as w|
|000033e0| 65 6c 6c 20 61 73 20 61 | 20 70 61 73 73 77 6f 72 |ell as a| passwor|
|000033f0| 64 20 61 6e 64 20 63 6f | 6e 6e 65 63 74 20 73 74 |d and co|nnect st|
|00003400| 72 69 6e 67 20 69 66 20 | 0d 0a 64 65 73 69 72 65 |ring if |..desire|
|00003410| 64 2c 20 74 68 65 6e 20 | 63 68 6f 6f 73 65 20 4f |d, then |choose O|
|00003420| 4b 2e 20 20 49 66 20 79 | 6f 75 20 63 68 6f 6f 73 |K.  If y|ou choos|
|00003430| 65 20 43 61 6e 63 65 6c | 2c 20 6e 6f 20 61 74 74 |e Cancel|, no att|
|00003440| 65 6d 70 74 20 69 73 20 | 6d 61 64 65 20 74 6f 20 |empt is |made to |
|00003450| 63 6f 6e 6e 65 63 74 20 | 74 6f 20 61 20 64 61 74 |connect |to a dat|
|00003460| 61 20 73 6f 75 72 63 65 | 20 61 6e 64 20 74 68 65 |a source| and the|
|00003470| 20 64 69 61 6c 6f 67 20 | 69 73 20 63 6c 6f 73 65 | dialog |is close|
|00003480| 64 2c 20 62 75 74 20 43 | 4b 53 41 4d 50 4c 45 2e |d, but C|KSAMPLE.|
|00003490| 41 50 50 20 63 6f 6e 74 | 69 6e 75 65 73 20 74 6f |APP cont|inues to|
|000034a0| 20 72 75 6e 2e 0d 0a 0d | 0a 0d 0a d6 c4 c4 c4 c4 | run....|........|
|000034b0| c4 c4 c4 c4 c4 c4 c4 c4 | c4 c4 c4 c4 c4 c4 c4 c4 |........|........|
|000034c0| c4 c4 c4 c4 c4 c4 c4 c4 | c4 c4 c4 c4 c4 b7 0d 0a |........|........|
|000034d0| ba 20 20 20 20 20 20 20 | 20 20 55 73 69 6e 67 20 |.       |  Using |
|000034e0| 61 20 44 61 74 61 62 61 | 73 65 20 20 20 20 20 20 |a Databa|se      |
|000034f0| 20 20 ba 0d 0a d3 c4 c4 | c4 c4 c4 c4 c4 c4 c4 c4 |  ......|........|
|00003500| c4 c4 c4 c4 c4 c4 c4 c4 | c4 c4 c4 c4 c4 c4 c4 c4 |........|........|
|00003510| c4 c4 c4 c4 c4 c4 c4 bd | 0d 0a 0d 0a 4d 75 6c 74 |........|....Mult|
|00003520| 69 70 6c 65 20 64 61 74 | 61 62 61 73 65 73 20 63 |iple dat|abases c|
|00003530| 61 6e 20 62 65 20 73 74 | 6f 72 65 64 20 6f 6e 20 |an be st|ored on |
|00003540| 61 20 73 69 6e 67 6c 65 | 20 64 61 74 61 20 73 6f |a single| data so|
|00003550| 75 72 63 65 20 61 6e 64 | 20 61 20 64 61 74 61 62 |urce and| a datab|
|00003560| 61 73 65 20 63 61 6e 20 | 63 6f 6e 74 61 69 6e 20 |ase can |contain |
|00003570| 61 20 6e 75 6d 62 65 72 | 20 6f 66 20 74 61 62 6c |a number| of tabl|
|00003580| 65 73 2e 20 20 57 68 65 | 6e 20 79 6f 75 20 61 72 |es.  Whe|n you ar|
|00003590| 65 20 63 6f 6e 6e 65 63 | 74 65 64 20 74 6f 20 61 |e connec|ted to a|
|000035a0| 20 64 61 74 61 20 73 6f | 75 72 63 65 2c 20 79 6f | data so|urce, yo|
|000035b0| 75 20 63 61 6e 20 75 73 | 65 20 61 20 64 61 74 61 |u can us|e a data|
|000035c0| 62 61 73 65 20 6f 6e 20 | 74 68 61 74 20 73 6f 75 |base on |that sou|
|000035d0| 72 63 65 2e 20 20 54 6f | 20 75 73 65 20 74 68 65 |rce.  To| use the|
|000035e0| 20 64 61 74 61 62 61 73 | 65 20 77 68 6f 73 65 20 | databas|e whose |
|000035f0| 64 61 74 61 20 79 6f 75 | 20 77 61 6e 74 20 74 6f |data you| want to|
|00003600| 20 61 63 63 65 73 73 2c | 20 63 68 6f 6f 73 65 20 | access,| choose |
|00003610| 55 73 65 20 44 61 74 61 | 62 61 73 65 2e 2e 2e 20 |Use Data|base... |
|00003620| 66 72 6f 6d 20 74 68 65 | 20 44 61 74 61 62 61 73 |from the| Databas|
|00003630| 65 20 6d 65 6e 75 2e 20 | 54 68 65 20 55 73 65 20 |e menu. |The Use |
|00003640| 44 61 74 61 62 61 73 65 | 20 64 69 61 6c 6f 67 20 |Database| dialog |
|00003650| 0d 0a 6f 70 65 6e 73 2e | 20 20 54 79 70 65 20 74 |..opens.|  Type t|
|00003660| 68 65 20 6e 61 6d 65 20 | 6f 66 20 74 68 65 20 64 |he name |of the d|
|00003670| 61 74 61 62 61 73 65 20 | 79 6f 75 20 77 61 6e 74 |atabase |you want|
|00003680| 20 74 6f 20 75 73 65 20 | 69 6e 20 74 68 65 20 74 | to use |in the t|
|00003690| 65 78 74 20 62 6f 78 20 | 61 6e 64 20 63 68 6f 6f |ext box |and choo|
|000036a0| 73 65 20 4f 4b 2e 20 20 | 54 6f 20 75 73 65 20 61 |se OK.  |To use a|
|000036b0| 20 64 69 66 66 65 72 65 | 6e 74 20 64 61 74 61 62 | differe|nt datab|
|000036c0| 61 73 65 2c 20 66 6f 6c | 6c 6f 77 20 74 68 65 20 |ase, fol|low the |
|000036d0| 73 61 6d 65 20 73 74 65 | 70 73 2e 20 20 59 6f 75 |same ste|ps.  You|
|000036e0| 20 63 61 6e 20 75 73 65 | 20 6f 6e 6c 79 20 6f 6e | can use| only on|
|000036f0| 65 20 64 61 74 61 62 61 | 73 65 20 61 74 20 61 20 |e databa|se at a |
|00003700| 74 69 6d 65 2e 20 20 4f | 6e 63 65 20 79 6f 75 20 |time.  O|nce you |
|00003710| 75 73 65 20 61 20 64 61 | 74 61 62 61 73 65 2c 20 |use a da|tabase, |
|00003720| 74 68 65 20 6e 61 6d 65 | 20 6f 66 20 74 68 65 20 |the name| of the |
|00003730| 64 61 74 61 62 61 73 65 | 20 69 73 20 64 69 73 70 |database| is disp|
|00003740| 6c 61 79 65 64 20 6f 6e | 20 74 68 65 20 73 74 61 |layed on| the sta|
|00003750| 74 75 73 20 62 61 72 20 | 61 6e 64 20 61 6c 6c 20 |tus bar |and all |
|00003760| 74 68 65 20 74 61 62 6c | 65 73 20 69 6e 20 74 68 |the tabl|es in th|
|00003770| 61 74 20 64 61 74 61 62 | 61 73 65 20 61 72 65 20 |at datab|ase are |
|00003780| 61 76 61 69 6c 61 62 6c | 65 20 66 6f 72 20 71 75 |availabl|e for qu|
|00003790| 65 72 79 69 6e 67 2e 0d | 0a 0d 0a d6 c4 c4 c4 c4 |erying..|........|
|000037a0| c4 c4 c4 c4 c4 c4 c4 c4 | c4 c4 c4 c4 c4 c4 c4 c4 |........|........|
|000037b0| c4 c4 c4 c4 c4 c4 c4 c4 | c4 c4 c4 c4 c4 b7 0d 0a |........|........|
|000037c0| ba 20 20 20 20 20 20 20 | 20 43 72 65 61 74 69 6e |.       | Creatin|
|000037d0| 67 20 61 20 51 75 65 72 | 79 20 20 20 20 20 20 20 |g a Quer|y       |
|000037e0| 20 20 ba 0d 0a d3 c4 c4 | c4 c4 c4 c4 c4 c4 c4 c4 |  ......|........|
|000037f0| c4 c4 c4 c4 c4 c4 c4 c4 | c4 c4 c4 c4 c4 c4 c4 c4 |........|........|
|00003800| c4 c4 c4 c4 c4 c4 c4 bd | 0d 0a 0d 0a 59 6f 75 20 |........|....You |
|00003810| 63 61 6e 20 61 6c 6c 6f | 77 20 43 4b 53 41 4d 50 |can allo|w CKSAMP|
|00003820| 4c 45 2e 41 50 50 20 74 | 6f 20 62 75 69 6c 64 20 |LE.APP t|o build |
|00003830| 61 20 53 51 4c 20 73 74 | 61 74 65 6d 65 6e 74 20 |a SQL st|atement |
|00003840| 62 61 73 65 64 20 6f 6e | 20 79 6f 75 72 20 63 68 |based on| your ch|
|00003850| 6f 69 63 65 73 20 69 6e | 20 74 68 65 20 42 75 69 |oices in| the Bui|
|00003860| 6c 64 20 51 75 65 72 79 | 20 64 69 61 6c 6f 67 20 |ld Query| dialog |
|00003870| 6f 72 20 77 72 69 74 65 | 20 79 6f 75 72 20 6f 77 |or write| your ow|
|00003880| 6e 20 53 51 4c 20 73 74 | 61 74 65 6d 65 6e 74 20 |n SQL st|atement |
|00003890| 69 6e 20 74 68 65 20 45 | 64 69 74 20 51 75 65 72 |in the E|dit Quer|
|000038a0| 79 20 64 69 61 6c 6f 67 | 2e 20 0d 0a 0d 0a 43 68 |y dialog|. ....Ch|
|000038b0| 6f 6f 73 65 20 42 75 69 | 6c 64 20 51 75 65 72 79 |oose Bui|ld Query|
|000038c0| 2e 2e 2e 20 66 72 6f 6d | 20 74 68 65 20 51 75 65 |... from| the Que|
|000038d0| 72 79 20 6d 65 6e 75 20 | 74 6f 20 6f 70 65 6e 20 |ry menu |to open |
|000038e0| 74 68 65 20 42 75 69 6c | 64 20 51 75 65 72 79 20 |the Buil|d Query |
|000038f0| 64 69 61 6c 6f 67 2e 20 | 20 54 68 69 73 20 64 69 |dialog. | This di|
|00003900| 61 6c 6f 67 20 63 6f 6e | 74 61 69 6e 73 20 74 68 |alog con|tains th|
|00003910| 65 20 66 6f 6c 6c 6f 77 | 69 6e 67 20 6f 62 6a 65 |e follow|ing obje|
|00003920| 63 74 73 3a 0d 0a 0d 0a | 09 46 72 6f 6d 2e 2e 2e |cts:....|.From...|
|00003930| 20 62 75 74 74 6f 6e 20 | 2d 2d 20 43 68 6f 6f 73 | button |-- Choos|
|00003940| 65 20 74 61 62 6c 65 73 | 20 74 6f 20 62 65 20 69 |e tables| to be i|
|00003950| 6e 63 6c 75 64 65 64 20 | 69 6e 20 74 68 65 20 71 |ncluded |in the q|
|00003960| 75 65 72 79 2e 0d 0a 43 | 68 6f 6f 73 69 6e 67 20 |uery...C|hoosing |
|00003970| 74 68 65 20 46 72 6f 6d | 2e 2e 2e 20 62 75 74 74 |the From|... butt|
|00003980| 6f 6e 20 6f 70 65 6e 73 | 20 74 68 65 20 46 72 6f |on opens| the Fro|
|00003990| 6d 20 64 69 61 6c 6f 67 | 20 77 69 74 68 20 61 20 |m dialog| with a |
|000039a0| 6c 69 73 74 20 6f 66 20 | 74 68 65 20 74 61 62 6c |list of |the tabl|
|000039b0| 65 73 20 69 6e 20 74 68 | 65 20 64 61 74 61 62 61 |es in th|e databa|
|000039c0| 73 65 20 63 75 72 72 65 | 6e 74 6c 79 20 69 6e 20 |se curre|ntly in |
|000039d0| 75 73 65 20 61 6e 64 20 | 61 20 6c 69 73 74 20 6f |use and |a list o|
|000039e0| 66 20 74 61 62 6c 65 73 | 20 66 72 6f 6d 20 74 68 |f tables| from th|
|000039f0| 69 73 20 64 61 74 61 62 | 61 73 65 20 74 6f 20 62 |is datab|ase to b|
|00003a00| 65 20 69 6e 63 6c 75 64 | 65 64 20 69 6e 20 74 68 |e includ|ed in th|
|00003a10| 65 20 71 75 65 72 79 2e | 20 54 6f 20 6d 6f 76 65 |e query.| To move|
|00003a20| 20 61 20 74 61 62 6c 65 | 20 66 72 6f 6d 20 74 68 | a table| from th|
|00003a30| 65 20 44 61 74 61 62 61 | 73 65 20 74 61 62 6c 65 |e Databa|se table|
|00003a40| 73 20 0d 0a 6c 69 73 74 | 20 69 6e 74 6f 20 74 68 |s ..list| into th|
|00003a50| 65 20 51 75 65 72 79 20 | 74 61 62 6c 65 73 20 6c |e Query |tables l|
|00003a60| 69 73 74 2c 20 64 6f 75 | 62 6c 65 2d 63 6c 69 63 |ist, dou|ble-clic|
|00003a70| 6b 20 69 74 20 6f 72 20 | 73 65 6c 65 63 74 20 69 |k it or |select i|
|00003a80| 74 20 77 69 74 68 20 74 | 68 65 20 6d 6f 75 73 65 |t with t|he mouse|
|00003a90| 20 6f 72 20 6b 65 79 62 | 6f 61 72 64 20 61 6e 64 | or keyb|oard and|
|00003aa0| 20 63 68 6f 6f 73 65 20 | 41 64 64 3e 3e 2e 20 20 | choose |Add>>.  |
|00003ab0| 54 6f 20 72 65 6d 6f 76 | 65 20 61 20 74 61 62 6c |To remov|e a tabl|
|00003ac0| 65 20 66 72 6f 6d 20 74 | 68 65 20 51 75 65 72 79 |e from t|he Query|
|00003ad0| 20 74 61 62 6c 65 73 20 | 6c 69 73 74 2c 20 64 6f | tables |list, do|
|00003ae0| 75 62 6c 65 2d 63 6c 69 | 63 6b 20 69 74 20 6f 72 |uble-cli|ck it or|
|00003af0| 20 73 65 6c 65 63 74 20 | 69 74 20 77 69 74 68 20 | select |it with |
|00003b00| 74 68 65 20 6d 6f 75 73 | 65 20 6f 72 20 6b 65 79 |the mous|e or key|
|00003b10| 62 6f 61 72 64 20 61 6e | 64 20 63 68 6f 6f 73 65 |board an|d choose|
|00003b20| 20 3c 3c 52 65 6d 6f 76 | 65 2e 20 20 57 68 65 6e | <<Remov|e.  When|
|00003b30| 20 74 68 65 20 64 65 73 | 69 72 65 64 20 74 61 62 | the des|ired tab|
|00003b40| 6c 65 73 20 61 72 65 20 | 69 6e 20 74 68 65 20 51 |les are |in the Q|
|00003b50| 75 65 72 79 20 74 61 62 | 6c 65 73 20 6c 69 73 74 |uery tab|les list|
|00003b60| 2c 20 63 68 6f 6f 73 65 | 20 4f 4b 2e 20 20 54 68 |, choose| OK.  Th|
|00003b70| 65 20 63 68 6f 73 65 6e | 20 74 61 62 6c 65 73 20 |e chosen| tables |
|00003b80| 61 72 65 20 64 69 73 70 | 6c 61 79 65 64 20 69 6e |are disp|layed in|
|00003b90| 20 74 68 65 20 42 75 69 | 6c 64 20 51 75 65 72 79 | the Bui|ld Query|
|00003ba0| 20 64 69 61 6c 6f 67 2e | 0d 0a 0d 0a 09 53 65 6c | dialog.|.....Sel|
|00003bb0| 65 63 74 2e 2e 2e 20 62 | 75 74 74 6f 6e 20 2d 2d |ect... b|utton --|
|00003bc0| 20 43 68 6f 6f 73 65 20 | 63 6f 6c 75 6d 6e 73 20 | Choose |columns |
|00003bd0| 28 66 69 65 6c 64 73 29 | 20 66 72 6f 6d 20 74 68 |(fields)| from th|
|00003be0| 65 20 74 61 62 6c 65 73 | 20 74 6f 20 62 65 20 69 |e tables| to be i|
|00003bf0| 6e 63 6c 75 64 65 64 20 | 69 6e 20 74 68 65 20 71 |ncluded |in the q|
|00003c00| 75 65 72 79 2e 0d 0a 43 | 68 6f 6f 73 65 20 74 68 |uery...C|hoose th|
|00003c10| 65 20 53 65 6c 65 63 74 | 2e 2e 2e 20 62 75 74 74 |e Select|... butt|
|00003c20| 6f 6e 20 74 6f 20 6f 70 | 65 6e 20 74 68 65 20 53 |on to op|en the S|
|00003c30| 65 6c 65 63 74 20 64 69 | 61 6c 6f 67 20 77 69 74 |elect di|alog wit|
|00003c40| 68 20 61 20 6c 69 73 74 | 20 6f 66 20 74 68 65 20 |h a list| of the |
|00003c50| 63 6f 6c 75 6d 6e 73 20 | 69 6e 20 74 68 65 20 74 |columns |in the t|
|00003c60| 61 62 6c 65 73 20 73 65 | 6c 65 63 74 65 64 20 69 |ables se|lected i|
|00003c70| 6e 20 74 68 65 20 46 72 | 6f 6d 20 64 69 61 6c 6f |n the Fr|om dialo|
|00003c80| 67 20 61 6e 64 20 61 20 | 6c 69 73 74 20 6f 66 20 |g and a |list of |
|00003c90| 63 6f 6c 75 6d 6e 73 20 | 66 72 6f 6d 20 74 68 65 |columns |from the|
|00003ca0| 73 65 20 74 61 62 6c 65 | 73 20 74 6f 20 62 65 20 |se table|s to be |
|00003cb0| 69 6e 63 6c 75 64 65 64 | 20 69 6e 20 74 68 65 20 |included| in the |
|00003cc0| 71 75 65 72 79 2e 20 54 | 6f 20 6d 6f 76 65 20 61 |query. T|o move a|
|00003cd0| 20 74 61 62 6c 65 20 66 | 72 6f 6d 20 74 68 65 20 | table f|rom the |
|00003ce0| 44 61 74 61 62 61 73 65 | 20 74 61 62 6c 65 73 20 |Database| tables |
|00003cf0| 6c 69 73 74 20 69 6e 74 | 6f 20 74 68 65 20 51 75 |list int|o the Qu|
|00003d00| 65 72 79 20 74 61 62 6c | 65 73 20 6c 69 73 74 2c |ery tabl|es list,|
|00003d10| 20 64 6f 75 62 6c 65 2d | 63 6c 69 63 6b 20 69 74 | double-|click it|
|00003d20| 20 6f 72 20 73 65 6c 65 | 63 74 20 69 74 20 77 69 | or sele|ct it wi|
|00003d30| 74 68 20 74 68 65 20 6d | 6f 75 73 65 20 6f 72 20 |th the m|ouse or |
|00003d40| 6b 65 79 62 6f 61 72 64 | 20 61 6e 64 20 63 68 6f |keyboard| and cho|
|00003d50| 6f 73 65 20 41 64 64 3e | 3e 2e 20 20 54 6f 20 72 |ose Add>|>.  To r|
|00003d60| 65 6d 6f 76 65 20 61 20 | 74 61 62 6c 65 20 66 72 |emove a |table fr|
|00003d70| 6f 6d 20 74 68 65 20 51 | 75 65 72 79 20 74 61 62 |om the Q|uery tab|
|00003d80| 6c 65 73 20 6c 69 73 74 | 2c 20 64 6f 75 62 6c 65 |les list|, double|
|00003d90| 2d 63 6c 69 63 6b 20 69 | 74 20 6f 72 20 73 65 6c |-click i|t or sel|
|00003da0| 65 63 74 20 69 74 20 77 | 69 74 68 20 74 68 65 20 |ect it w|ith the |
|00003db0| 6d 6f 75 73 65 20 6f 72 | 20 6b 65 79 62 6f 61 72 |mouse or| keyboar|
|00003dc0| 64 20 61 6e 64 20 63 68 | 6f 6f 73 65 20 3c 3c 52 |d and ch|oose <<R|
|00003dd0| 65 6d 6f 76 65 2e 20 20 | 57 68 65 6e 20 74 68 65 |emove.  |When the|
|00003de0| 20 64 65 73 69 72 65 64 | 20 74 61 62 6c 65 73 20 | desired| tables |
|00003df0| 61 72 65 20 69 6e 20 74 | 68 65 20 51 75 65 72 79 |are in t|he Query|
|00003e00| 20 74 61 62 6c 65 73 20 | 6c 69 73 74 2c 20 63 68 | tables |list, ch|
|00003e10| 6f 6f 73 65 20 4f 4b 2e | 20 20 54 68 65 20 0d 0a |oose OK.|  The ..|
|00003e20| 63 68 6f 73 65 6e 20 74 | 61 62 6c 65 73 20 61 72 |chosen t|ables ar|
|00003e30| 65 20 64 69 73 70 6c 61 | 79 65 64 20 69 6e 20 74 |e displa|yed in t|
|00003e40| 68 65 20 42 75 69 6c 64 | 20 51 75 65 72 79 20 64 |he Build| Query d|
|00003e50| 69 61 6c 6f 67 2e 0d 0a | 0d 0a 09 4a 6f 69 6e 2e |ialog...|...Join.|
|00003e60| 2e 2e 20 62 75 74 74 6f | 6e 20 2d 2d 20 53 70 65 |.. butto|n -- Spe|
|00003e70| 63 69 66 79 20 6a 6f 69 | 6e 20 63 6f 6e 64 69 74 |cify joi|n condit|
|00003e80| 69 6f 6e 73 20 66 6f 72 | 20 74 68 65 20 74 61 62 |ions for| the tab|
|00003e90| 6c 65 73 20 69 6e 20 74 | 68 65 20 71 75 65 72 79 |les in t|he query|
|00003ea0| 2e 0d 0a 43 68 6f 6f 73 | 65 20 74 68 65 20 4a 6f |...Choos|e the Jo|
|00003eb0| 69 6e 2e 2e 2e 20 62 75 | 74 74 6f 6e 20 74 6f 20 |in... bu|tton to |
|00003ec0| 6f 70 65 6e 20 74 68 65 | 20 4a 6f 69 6e 20 64 69 |open the| Join di|
|00003ed0| 61 6c 6f 67 2e 20 20 53 | 65 6c 65 63 74 20 74 68 |alog.  S|elect th|
|00003ee0| 65 20 63 6f 6c 75 6d 6e | 73 20 74 6f 20 62 65 20 |e column|s to be |
|00003ef0| 6a 6f 69 6e 65 64 20 66 | 72 6f 6d 20 74 68 65 20 |joined f|rom the |
|00003f00| 70 6f 70 75 70 73 20 6f | 6e 20 74 68 65 20 6c 65 |popups o|n the le|
|00003f10| 66 74 20 61 6e 64 20 72 | 69 67 68 74 20 73 69 64 |ft and r|ight sid|
|00003f20| 65 73 20 6f 66 20 74 68 | 65 20 64 69 61 6c 6f 67 |es of th|e dialog|
|00003f30| 20 61 6e 64 20 74 68 65 | 20 63 6f 6e 64 69 74 69 | and the| conditi|
|00003f40| 6f 6e 20 6f 66 20 74 68 | 65 20 6a 6f 69 6e 20 66 |on of th|e join f|
|00003f50| 72 6f 6d 20 74 68 65 20 | 63 65 6e 74 65 72 20 70 |rom the |center p|
|00003f60| 6f 70 75 70 2e 20 20 41 | 20 63 6f 6e 64 69 74 69 |opup.  A| conditi|
|00003f70| 6f 6e 20 63 61 6e 20 62 | 65 20 0d 0a 72 65 76 65 |on can b|e ..reve|
|00003f80| 72 73 65 64 20 62 79 20 | 63 68 65 63 6b 69 6e 67 |rsed by |checking|
|00003f90| 20 74 68 65 20 4e 4f 54 | 20 63 68 65 63 6b 20 62 | the NOT| check b|
|00003fa0| 6f 78 2e 20 20 43 68 6f | 6f 73 65 20 4f 4b 20 74 |ox.  Cho|ose OK t|
|00003fb0| 6f 20 63 6f 6d 70 6c 65 | 74 65 20 74 68 65 20 6a |o comple|te the j|
|00003fc0| 6f 69 6e 20 6f 72 20 43 | 61 6e 63 65 6c 20 74 6f |oin or C|ancel to|
|00003fd0| 20 6c 65 61 76 65 20 74 | 68 65 20 64 69 61 6c 6f | leave t|he dialo|
|00003fe0| 67 20 77 69 74 68 6f 75 | 74 20 73 65 74 74 69 6e |g withou|t settin|
|00003ff0| 67 20 61 20 6a 6f 69 6e | 20 63 6f 6e 64 69 74 69 |g a join| conditi|
|00004000| 6f 6e 2e 20 49 66 20 79 | 6f 75 20 69 6e 63 6c 75 |on. If y|ou inclu|
|00004010| 64 65 20 6d 6f 72 65 20 | 74 68 61 6e 20 6f 6e 65 |de more |than one|
|00004020| 20 74 61 62 6c 65 20 69 | 6e 20 61 20 71 75 65 72 | table i|n a quer|
|00004030| 79 2c 20 79 6f 75 20 73 | 68 6f 75 6c 64 20 73 70 |y, you s|hould sp|
|00004040| 65 63 69 66 79 20 61 20 | 6a 6f 69 6e 20 63 6f 6e |ecify a |join con|
|00004050| 64 69 74 69 6f 6e 20 66 | 6f 72 20 65 76 65 72 79 |dition f|or every|
|00004060| 20 74 61 62 6c 65 2e 20 | 20 54 6f 20 73 70 65 63 | table. | To spec|
|00004070| 69 66 79 20 61 64 64 69 | 74 69 6f 6e 61 6c 20 6a |ify addi|tional j|
|00004080| 6f 69 6e 20 63 6f 6e 64 | 69 74 69 6f 6e 73 2c 20 |oin cond|itions, |
|00004090| 72 65 70 65 61 74 20 74 | 68 65 20 61 62 6f 76 65 |repeat t|he above|
|000040a0| 20 73 74 65 70 73 2e 0d | 0a 0d 0a 09 57 68 65 72 | steps..|....Wher|
|000040b0| 65 2e 2e 2e 20 62 75 74 | 74 6f 6e 20 2d 2d 20 53 |e... but|ton -- S|
|000040c0| 70 65 63 69 66 79 20 66 | 69 6c 74 65 72 20 63 6f |pecify f|ilter co|
|000040d0| 6e 64 69 74 69 6f 6e 73 | 20 66 6f 72 20 74 68 65 |nditions| for the|
|000040e0| 20 71 75 65 72 79 2e 0d | 0a 43 68 6f 6f 73 65 20 | query..|.Choose |
|000040f0| 74 68 65 20 57 68 65 72 | 65 2e 2e 2e 20 62 75 74 |the Wher|e... but|
|00004100| 74 6f 6e 20 74 6f 20 6f | 70 65 6e 20 74 68 65 20 |ton to o|pen the |
|00004110| 57 68 65 72 65 20 64 69 | 61 6c 6f 67 2e 20 20 53 |Where di|alog.  S|
|00004120| 65 6c 65 63 74 20 74 68 | 65 20 63 6f 6c 75 6d 6e |elect th|e column|
|00004130| 20 74 6f 20 62 65 20 66 | 69 6c 74 65 72 65 64 20 | to be f|iltered |
|00004140| 66 72 6f 6d 20 74 68 65 | 20 70 6f 70 75 70 20 6f |from the| popup o|
|00004150| 6e 20 74 68 65 20 6c 65 | 66 74 20 73 69 64 65 20 |n the le|ft side |
|00004160| 6f 66 20 74 68 65 20 64 | 69 61 6c 6f 67 20 61 6e |of the d|ialog an|
|00004170| 64 20 74 68 65 20 63 6f | 6e 64 69 74 69 6f 6e 20 |d the co|ndition |
|00004180| 6f 66 20 74 68 65 20 66 | 69 6c 74 65 72 20 66 72 |of the f|ilter fr|
|00004190| 6f 6d 20 74 68 65 20 63 | 65 6e 74 65 72 20 70 6f |om the c|enter po|
|000041a0| 70 75 70 2e 20 54 79 70 | 65 20 74 68 65 20 63 6f |pup. Typ|e the co|
|000041b0| 6d 70 61 72 69 73 6f 6e | 20 6e 75 6d 62 65 72 20 |mparison| number |
|000041c0| 6f 72 20 73 74 72 69 6e | 67 20 69 6e 20 74 68 65 |or strin|g in the|
|000041d0| 20 74 65 78 74 20 62 6f | 78 20 6f 6e 20 74 68 65 | text bo|x on the|
|000041e0| 20 72 69 67 68 74 20 73 | 69 64 65 20 6f 66 20 74 | right s|ide of t|
|000041f0| 68 65 20 64 69 61 6c 6f | 67 2e 2e 20 20 41 20 63 |he dialo|g..  A c|
|00004200| 6f 6e 64 69 74 69 6f 6e | 20 63 61 6e 20 62 65 20 |ondition| can be |
|00004210| 72 65 76 65 72 73 65 64 | 20 62 79 20 63 68 65 63 |reversed| by chec|
|00004220| 6b 69 6e 67 20 0d 0a 74 | 68 65 20 4e 4f 54 20 63 |king ..t|he NOT c|
|00004230| 68 65 63 6b 20 62 6f 78 | 2e 20 20 43 68 6f 6f 73 |heck box|.  Choos|
|00004240| 65 20 4f 4b 20 74 6f 20 | 73 65 74 20 74 68 65 20 |e OK to |set the |
|00004250| 66 69 6c 74 65 72 20 6f | 72 20 43 61 6e 63 65 6c |filter o|r Cancel|
|00004260| 20 74 6f 20 6c 65 61 76 | 65 20 74 68 65 20 64 69 | to leav|e the di|
|00004270| 61 6c 6f 67 20 77 69 74 | 68 6f 75 74 20 73 65 74 |alog wit|hout set|
|00004280| 74 69 6e 67 20 61 20 66 | 69 6c 74 65 72 20 63 6f |ting a f|ilter co|
|00004290| 6e 64 69 74 69 6f 6e 2e | 0d 0a 0d 0a 09 45 78 65 |ndition.|.....Exe|
|000042a0| 63 75 74 65 20 62 75 74 | 74 6f 6e 20 2d 2d 20 45 |cute but|ton -- E|
|000042b0| 78 65 63 75 74 65 20 74 | 68 65 20 71 75 65 72 79 |xecute t|he query|
|000042c0| 2e 0d 0a 0d 0a 09 45 64 | 69 74 2e 2e 2e 20 62 75 |......Ed|it... bu|
|000042d0| 74 74 6f 6e 20 2d 2d 20 | 45 64 69 74 20 74 68 65 |tton -- |Edit the|
|000042e0| 20 53 51 4c 20 73 74 61 | 74 65 6d 65 6e 74 20 62 | SQL sta|tement b|
|000042f0| 75 69 6c 74 20 69 6e 20 | 74 68 65 20 42 75 69 6c |uilt in |the Buil|
|00004300| 64 20 51 75 65 72 79 20 | 64 69 61 6c 6f 67 2e 0d |d Query |dialog..|
|00004310| 0a 43 68 6f 6f 73 65 20 | 74 68 65 20 45 64 69 74 |.Choose |the Edit|
|00004320| 2e 2e 2e 20 62 75 74 74 | 6f 6e 20 74 6f 20 6f 70 |... butt|on to op|
|00004330| 65 6e 20 74 68 65 20 45 | 64 69 74 20 64 69 61 6c |en the E|dit dial|
|00004340| 6f 67 2e 20 20 54 68 65 | 20 53 51 4c 20 73 74 61 |og.  The| SQL sta|
|00004350| 74 65 6d 65 6e 74 20 62 | 75 69 6c 74 20 69 6e 20 |tement b|uilt in |
|00004360| 74 68 65 20 42 75 69 6c | 64 20 51 75 65 72 79 20 |the Buil|d Query |
|00004370| 64 69 61 6c 6f 67 20 69 | 73 20 64 69 73 70 6c 61 |dialog i|s displa|
|00004380| 79 65 64 20 69 6e 20 61 | 20 74 65 78 74 20 65 64 |yed in a| text ed|
|00004390| 69 74 69 6e 67 20 77 69 | 6e 64 6f 77 20 73 6f 20 |iting wi|ndow so |
|000043a0| 74 68 61 74 20 79 6f 75 | 20 63 61 6e 20 63 75 73 |that you| can cus|
|000043b0| 74 6f 6d 69 7a 65 20 74 | 68 65 20 71 75 65 72 79 |tomize t|he query|
|000043c0| 2e 20 20 43 68 6f 6f 73 | 65 20 74 68 65 20 45 78 |.  Choos|e the Ex|
|000043d0| 65 63 75 74 65 20 62 75 | 74 74 6f 6e 20 69 6e 20 |ecute bu|tton in |
|000043e0| 74 68 65 20 45 64 69 74 | 20 64 69 61 6c 6f 67 20 |the Edit| dialog |
|000043f0| 74 6f 20 65 78 65 63 75 | 74 65 20 74 68 65 20 53 |to execu|te the S|
|00004400| 51 4c 20 73 74 61 74 65 | 6d 65 6e 74 2e 20 20 49 |QL state|ment.  I|
|00004410| 66 20 79 6f 75 20 63 68 | 6f 6f 73 65 20 43 61 6e |f you ch|oose Can|
|00004420| 63 65 6c 2c 20 74 68 65 | 20 45 64 69 74 20 64 69 |cel, the| Edit di|
|00004430| 61 6c 6f 67 20 63 6c 6f | 73 65 73 20 61 6e 64 20 |alog clo|ses and |
|00004440| 74 68 65 20 71 75 65 72 | 79 20 69 73 20 6e 6f 74 |the quer|y is not|
|00004450| 20 65 78 65 63 75 74 65 | 64 2e 0d 0a 0d 0a 09 43 | execute|d......C|
|00004460| 6c 65 61 72 20 62 75 74 | 74 6f 6e 20 2d 2d 20 52 |lear but|ton -- R|
|00004470| 65 6d 6f 76 65 20 61 6c | 6c 20 74 61 62 6c 65 73 |emove al|l tables|
|00004480| 2c 20 63 6f 6c 75 6d 6e | 73 2c 20 6a 6f 69 6e 20 |, column|s, join |
|00004490| 63 6f 6e 64 69 74 69 6f | 6e 73 2c 20 61 6e 64 20 |conditio|ns, and |
|000044a0| 66 69 6c 74 65 72 20 63 | 6f 6e 64 69 74 69 6f 6e |filter c|ondition|
|000044b0| 73 20 66 72 6f 6d 20 74 | 68 65 20 71 75 65 72 79 |s from t|he query|
|000044c0| 20 62 65 69 6e 67 20 62 | 75 69 6c 74 2e 0d 0a 0d | being b|uilt....|
|000044d0| 0a 09 43 6c 6f 73 65 20 | 62 75 74 74 6f 6e 20 2d |..Close |button -|
|000044e0| 2d 20 43 6c 6f 73 65 20 | 74 68 65 20 42 75 69 6c |- Close |the Buil|
|000044f0| 64 20 51 75 65 72 79 20 | 64 69 61 6c 6f 67 2e 0d |d Query |dialog..|
|00004500| 0a 0d 0a 59 6f 75 20 63 | 61 6e 20 64 69 72 65 63 |...You c|an direc|
|00004510| 74 6c 79 20 65 64 69 74 | 20 61 20 53 51 4c 20 73 |tly edit| a SQL s|
|00004520| 74 61 74 65 6d 65 6e 74 | 20 62 79 20 63 68 6f 6f |tatement| by choo|
|00004530| 73 69 6e 67 20 45 64 69 | 74 20 51 75 65 72 79 2e |sing Edi|t Query.|
|00004540| 2e 2e 20 66 72 6f 6d 20 | 74 68 65 20 51 75 65 72 |.. from |the Quer|
|00004550| 79 20 6d 65 6e 75 2e 20 | 20 54 68 69 73 20 6f 70 |y menu. | This op|
|00004560| 65 6e 73 20 74 68 65 20 | 45 64 69 74 20 64 69 61 |ens the |Edit dia|
|00004570| 6c 6f 67 20 64 65 73 63 | 72 69 62 65 64 20 61 62 |log desc|ribed ab|
|00004580| 6f 76 65 2e 0d 0a 0d 0a | 54 6f 20 65 78 65 63 75 |ove.....|To execu|
|00004590| 74 65 20 61 20 71 75 65 | 72 79 20 61 6c 72 65 61 |te a que|ry alrea|
|000045a0| 64 79 20 62 75 69 6c 74 | 2c 20 63 68 6f 6f 73 65 |dy built|, choose|
|000045b0| 20 45 78 65 63 75 74 65 | 20 51 75 65 72 79 20 66 | Execute| Query f|
|000045c0| 72 6f 6d 20 74 68 65 20 | 51 75 65 72 79 20 6d 65 |rom the |Query me|
|000045d0| 6e 75 0d 0a 0d 0a 0d 0a | d6 c4 c4 c4 c4 c4 c4 c4 |nu......|........|
|000045e0| c4 c4 c4 c4 c4 c4 c4 c4 | c4 c4 c4 c4 c4 c4 c4 c4 |........|........|
|000045f0| c4 c4 c4 c4 c4 c4 c4 c4 | c4 c4 b7 0d 0a ba 20 20 |........|......  |
|00004600| 20 20 20 20 20 20 20 53 | 65 74 74 69 6e 67 20 4f |       S|etting O|
|00004610| 70 74 69 6f 6e 73 20 20 | 20 20 20 20 20 20 20 ba |ptions  |       .|
|00004620| 0d 0a d3 c4 c4 c4 c4 c4 | c4 c4 c4 c4 c4 c4 c4 c4 |........|........|
|00004630| c4 c4 c4 c4 c4 c4 c4 c4 | c4 c4 c4 c4 c4 c4 c4 c4 |........|........|
|00004640| c4 c4 c4 c4 bd 0d 0a 0d | 0a 54 6f 20 73 65 74 20 |........|.To set |
|00004650| 76 61 72 69 6f 75 73 20 | 6f 70 74 69 6f 6e 73 20 |various |options |
|00004660| 74 68 61 74 20 61 66 66 | 65 63 74 20 74 68 65 20 |that aff|ect the |
|00004670| 63 6f 6e 6e 65 63 74 69 | 6f 6e 20 74 6f 20 74 68 |connecti|on to th|
|00004680| 65 20 64 61 74 61 20 73 | 6f 75 72 63 65 20 61 6e |e data s|ource an|
|00004690| 64 20 74 68 65 20 77 61 | 79 20 69 6e 20 77 68 69 |d the wa|y in whi|
|000046a0| 63 68 20 72 65 73 75 6c | 74 20 73 65 74 73 20 61 |ch resul|t sets a|
|000046b0| 72 65 20 70 72 6f 63 65 | 73 73 65 64 2c 20 63 68 |re proce|ssed, ch|
|000046c0| 6f 6f 73 65 20 4f 70 74 | 69 6f 6e 73 2e 2e 2e 20 |oose Opt|ions... |
|000046d0| 66 72 6f 6d 20 74 68 65 | 20 44 61 74 61 62 61 73 |from the| Databas|
|000046e0| 65 20 6d 65 6e 75 2e 20 | 20 54 68 65 20 4f 70 74 |e menu. | The Opt|
|000046f0| 69 6f 6e 73 20 64 69 61 | 6c 6f 67 20 6f 70 65 6e |ions dia|log open|
|00004700| 73 20 77 69 74 68 20 74 | 68 65 20 66 6f 6c 6c 6f |s with t|he follo|
|00004710| 77 69 6e 67 20 0d 0a 6f | 62 6a 65 63 74 73 3a 0d |wing ..o|bjects:.|
|00004720| 0a 0d 0a 09 52 65 73 75 | 6c 74 20 53 65 74 20 2d |....Resu|lt Set -|
|00004730| 2d 20 44 65 74 65 72 6d | 69 6e 65 20 77 68 65 74 |- Determ|ine whet|
|00004740| 68 65 72 20 72 65 73 75 | 6c 74 73 20 61 72 65 20 |her resu|lts are |
|00004750| 72 65 74 75 72 6e 65 64 | 20 69 6e 20 63 75 72 73 |returned| in curs|
|00004760| 6f 72 73 20 6f 72 20 74 | 61 62 6c 65 73 2e 0d 0a |ors or t|ables...|
|00004770| 0d 0a 09 45 78 65 63 75 | 74 69 6f 6e 20 4d 6f 64 |...Execu|tion Mod|
|00004780| 65 20 2d 2d 20 44 65 74 | 65 72 6d 69 6e 65 20 77 |e -- Det|ermine w|
|00004790| 68 65 74 68 65 72 20 6f | 70 65 72 61 74 69 6f 6e |hether o|peration|
|000047a0| 73 20 6f 76 65 72 20 74 | 68 65 20 64 61 74 61 20 |s over t|he data |
|000047b0| 73 6f 75 72 63 65 20 63 | 6f 6e 6e 65 63 74 69 6f |source c|onnectio|
|000047c0| 6e 20 61 72 65 20 70 72 | 6f 63 65 73 73 65 64 20 |n are pr|ocessed |
|000047d0| 73 79 6e 63 68 72 6f 6e | 6f 75 73 6c 79 2c 20 73 |synchron|ously, s|
|000047e0| 6f 20 74 68 61 74 20 74 | 68 65 20 65 6e 74 69 72 |o that t|he entir|
|000047f0| 65 20 70 72 6f 63 65 64 | 75 72 65 20 69 73 20 70 |e proced|ure is p|
|00004800| 65 72 66 6f 72 6d 65 64 | 20 62 65 66 6f 72 65 20 |erformed| before |
|00004810| 63 6f 6e 74 72 6f 6c 20 | 69 73 20 72 65 74 75 72 |control |is retur|
|00004820| 6e 65 64 20 74 6f 20 43 | 4b 53 41 4d 50 4c 45 2e |ned to C|KSAMPLE.|
|00004830| 41 50 50 2c 20 6f 72 20 | 61 73 79 6e 63 68 72 6f |APP, or |asynchro|
|00004840| 6e 6f 75 73 6c 79 2c 20 | 73 6f 20 74 68 61 74 20 |nously, |so that |
|00004850| 63 6f 6e 74 72 6f 6c 20 | 69 73 20 70 65 72 69 6f |control |is perio|
|00004860| 64 69 63 61 6c 6c 79 20 | 72 65 74 75 72 6e 65 64 |dically |returned|
|00004870| 20 74 6f 20 43 4b 53 41 | 4d 50 4c 45 2e 41 50 50 | to CKSA|MPLE.APP|
|00004880| 2e 0d 0a 0d 0a 09 54 69 | 6d 65 6f 75 74 20 28 69 |......Ti|meout (i|
|00004890| 6e 20 73 65 63 6f 6e 64 | 73 29 20 2d 2d 20 44 65 |n second|s) -- De|
|000048a0| 74 65 72 6d 69 6e 65 20 | 74 68 65 20 6c 65 6e 67 |termine |the leng|
|000048b0| 74 68 20 6f 66 20 74 69 | 6d 65 20 69 6e 20 73 65 |th of ti|me in se|
|000048c0| 63 6f 6e 64 73 20 46 6f | 78 50 72 6f 20 77 69 6c |conds Fo|xPro wil|
|000048d0| 6c 20 77 61 69 74 20 62 | 65 66 6f 72 65 20 74 69 |l wait b|efore ti|
|000048e0| 6d 69 6e 67 20 6f 75 74 | 20 66 6f 72 20 61 20 63 |ming out| for a c|
|000048f0| 6f 6e 6e 65 63 74 69 6f | 6e 20 74 6f 20 62 65 20 |onnectio|n to be |
|00004900| 6d 61 64 65 20 6f 72 20 | 66 6f 72 20 61 20 63 6f |made or |for a co|
|00004910| 6e 6e 65 63 74 69 6f 6e | 20 61 6c 72 65 61 64 79 |nnection| already|
|00004920| 20 6d 61 64 65 20 74 6f | 20 72 65 73 70 6f 6e 64 | made to| respond|
|00004930| 2e 0d 0a 0d 0a 09 4d 65 | 6d 6f 20 63 75 74 6f 66 |......Me|mo cutof|
|00004940| 66 20 2d 2d 20 44 65 74 | 65 72 6d 69 6e 65 20 74 |f -- Det|ermine t|
|00004950| 68 65 20 6d 69 6e 69 6d | 75 6d 20 6c 65 6e 67 74 |he minim|um lengt|
|00004960| 68 20 6f 66 20 61 20 64 | 61 74 61 20 73 6f 75 72 |h of a d|ata sour|
|00004970| 63 65 20 63 6f 6c 75 6d | 6e 20 66 6f 72 20 69 74 |ce colum|n for it|
|00004980| 20 74 6f 20 73 74 6f 72 | 65 64 20 69 6e 20 61 20 | to stor|ed in a |
|00004990| 46 6f 78 50 72 6f 20 74 | 61 62 6c 65 20 6f 72 20 |FoxPro t|able or |
|000049a0| 63 75 72 73 6f 72 20 61 | 73 20 61 20 6d 65 6d 6f |cursor a|s a memo|
|000049b0| 20 66 69 65 6c 64 2e 20 | 20 43 6f 6c 75 6d 6e 73 | field. | Columns|
|000049c0| 20 73 68 6f 72 74 65 72 | 20 74 68 61 6e 20 74 68 | shorter| than th|
|000049d0| 65 20 63 75 74 6f 66 66 | 20 61 72 65 20 73 74 6f |e cutoff| are sto|
|000049e0| 72 65 64 20 61 73 20 6e | 6f 72 6d 61 6c 20 66 69 |red as n|ormal fi|
|000049f0| 65 6c 64 73 20 69 6e 20 | 61 20 46 6f 78 50 72 6f |elds in |a FoxPro|
|00004a00| 20 74 61 62 6c 65 20 6f | 72 20 63 75 72 73 6f 72 | table o|r cursor|
|00004a10| 2e 0d 0a 0d 0a 09 44 69 | 73 70 6c 61 79 20 56 69 |......Di|splay Vi|
|00004a20| 65 77 20 77 69 6e 64 6f | 77 20 2d 2d 20 44 69 73 |ew windo|w -- Dis|
|00004a30| 70 6c 61 79 73 20 74 68 | 65 20 56 69 65 77 20 77 |plays th|e View w|
|00004a40| 69 6e 64 6f 77 2e 20 20 | 54 68 65 20 56 69 65 77 |indow.  |The View|
|00004a50| 20 77 69 6e 64 6f 77 20 | 6d 75 73 74 20 62 65 20 | window |must be |
|00004a60| 6f 70 65 6e 20 74 6f 20 | 43 6f 6e 76 65 72 74 20 |open to |Convert |
|00004a70| 61 20 6d 65 6d 6f 2c 20 | 77 68 69 63 68 20 69 73 |a memo, |which is|
|00004a80| 20 64 65 73 63 72 69 62 | 65 64 20 69 6e 20 74 68 | describ|ed in th|
|00004a90| 65 20 66 6f 6c 6c 6f 77 | 69 6e 67 20 73 65 63 74 |e follow|ing sect|
|00004aa0| 69 6f 6e 2e 0d 0a 0d 0a | 0d 0a d6 c4 c4 c4 c4 c4 |ion.....|........|
|00004ab0| c4 c4 c4 c4 c4 c4 c4 c4 | c4 c4 c4 c4 c4 c4 c4 c4 |........|........|
|00004ac0| c4 c4 c4 c4 c4 c4 c4 c4 | c4 c4 c4 c4 b7 0d 0a ba |........|........|
|00004ad0| 20 20 20 20 20 20 20 20 | 43 6f 6e 76 65 72 74 69 |        |Converti|
|00004ae0| 6e 67 20 61 20 4d 65 6d | 6f 20 20 20 20 20 20 20 |ng a Mem|o       |
|00004af0| 20 ba 0d 0a d3 c4 c4 c4 | c4 c4 c4 c4 c4 c4 c4 c4 | .......|........|
|00004b00| c4 c4 c4 c4 c4 c4 c4 c4 | c4 c4 c4 c4 c4 c4 c4 c4 |........|........|
|00004b10| c4 c4 c4 c4 c4 c4 bd 0d | 0a 0d 0a 44 61 74 61 20 |........|...Data |
|00004b20| 73 6f 75 72 63 65 20 6d | 65 6d 6f 20 63 6f 6c 75 |source m|emo colu|
|00004b30| 6d 6e 73 20 63 61 6e 20 | 6f 66 74 65 6e 20 63 6f |mns can |often co|
|00004b40| 6e 74 61 69 6e 20 62 69 | 6e 61 72 79 20 69 6e 66 |ntain bi|nary inf|
|00004b50| 6f 72 6d 61 74 69 6f 6e | 20 61 73 20 77 65 6c 6c |ormation| as well|
|00004b60| 20 61 73 20 74 65 78 74 | 2e 20 20 42 69 6e 61 72 | as text|.  Binar|
|00004b70| 79 20 64 61 74 61 20 69 | 73 20 73 74 6f 72 65 64 |y data i|s stored|
|00004b80| 20 69 6e 20 67 65 6e 65 | 72 61 6c 20 66 69 65 6c | in gene|ral fiel|
|00004b90| 64 73 20 69 6e 20 46 6f | 78 50 72 6f 20 74 61 62 |ds in Fo|xPro tab|
|00004ba0| 6c 65 73 2e 20 20 54 6f | 20 63 6f 6e 76 65 72 74 |les.  To| convert|
|00004bb0| 20 62 69 6e 61 72 79 20 | 69 6e 66 6f 72 6d 61 74 | binary |informat|
|00004bc0| 69 6f 6e 20 66 72 6f 6d | 20 61 20 64 61 74 61 20 |ion from| a data |
|00004bd0| 73 6f 75 72 63 65 20 71 | 75 65 72 79 20 77 68 69 |source q|uery whi|
|00004be0| 63 68 20 68 61 73 20 62 | 65 65 6e 20 73 74 6f 72 |ch has b|een stor|
|00004bf0| 65 64 20 74 6f 20 61 20 | 6d 65 6d 6f 20 66 69 65 |ed to a |memo fie|
|00004c00| 6c 64 20 69 6e 20 61 20 | 46 6f 78 50 72 6f 20 74 |ld in a |FoxPro t|
|00004c10| 61 62 6c 65 20 69 6e 74 | 6f 20 61 20 67 65 6e 65 |able int|o a gene|
|00004c20| 72 61 6c 20 74 79 70 65 | 3a 0d 0a 0d 0a 09 31 2e |ral type|:.....1.|
|00004c30| 20 20 4d 61 6b 65 20 73 | 75 72 65 20 74 68 65 20 |  Make s|ure the |
|00004c40| 56 69 65 77 20 57 69 6e | 64 6f 77 20 69 73 20 6f |View Win|dow is o|
|00004c50| 70 65 6e 2e 20 20 59 6f | 75 20 63 61 6e 20 6f 70 |pen.  Yo|u can op|
|00004c60| 65 6e 20 74 68 65 20 56 | 69 65 77 20 77 69 6e 64 |en the V|iew wind|
|00004c70| 6f 77 20 62 79 20 63 68 | 6f 6f 73 69 6e 67 20 4f |ow by ch|oosing O|
|00004c80| 70 74 69 6f 6e 73 2e 2e | 2e 20 66 72 6f 6d 20 74 |ptions..|. from t|
|00004c90| 68 65 20 44 61 74 61 62 | 61 73 65 20 6d 65 6e 75 |he Datab|ase menu|
|00004ca0| 20 61 6e 64 20 63 68 6f | 6f 73 69 6e 67 20 74 68 | and cho|osing th|
|00004cb0| 65 20 44 69 73 70 6c 61 | 79 20 56 69 65 77 20 57 |e Displa|y View W|
|00004cc0| 69 6e 64 6f 77 20 63 68 | 65 63 6b 20 62 6f 78 20 |indow ch|eck box |
|00004cd0| 69 6e 20 74 68 65 20 4f | 70 74 69 6f 6e 73 20 64 |in the O|ptions d|
|00004ce0| 69 61 6c 6f 67 2e 0d 0a | 0d 0a 09 32 2e 20 20 4d |ialog...|...2.  M|
|00004cf0| 61 6b 65 20 73 75 72 65 | 20 74 68 61 74 20 72 65 |ake sure| that re|
|00004d00| 73 75 6c 74 20 73 65 74 | 73 20 61 72 65 20 72 65 |sult set|s are re|
|00004d10| 74 75 72 6e 65 64 20 69 | 6e 20 74 61 62 6c 65 73 |turned i|n tables|
|00004d20| 2e 20 20 49 66 20 72 65 | 73 75 6c 74 20 73 65 74 |.  If re|sult set|
|00004d30| 73 20 61 72 65 20 72 65 | 74 75 72 6e 65 64 20 69 |s are re|turned i|
|00004d40| 6e 20 63 75 72 73 6f 72 | 73 2c 20 79 6f 75 20 63 |n cursor|s, you c|
|00004d50| 61 6e 6e 6f 74 20 63 6f | 6e 76 65 72 74 20 6d 65 |annot co|nvert me|
|00004d60| 6d 6f 20 66 69 65 6c 64 | 73 20 74 6f 20 67 65 6e |mo field|s to gen|
|00004d70| 65 72 61 6c 20 66 69 65 | 6c 64 73 2e 0d 0a 0d 0a |eral fie|lds.....|
|00004d80| 09 33 2e 20 20 45 78 65 | 63 75 74 65 20 61 20 53 |.3.  Exe|cute a S|
|00004d90| 51 4c 20 71 75 65 72 79 | 20 74 68 61 74 20 63 72 |QL query| that cr|
|00004da0| 65 61 74 65 73 20 61 20 | 74 61 62 6c 65 20 6f 72 |eates a |table or|
|00004db0| 20 63 75 72 73 6f 72 20 | 77 69 74 68 20 61 20 6d | cursor |with a m|
|00004dc0| 65 6d 6f 20 66 69 65 6c | 64 2e 20 20 46 6f 72 20 |emo fiel|d.  For |
|00004dd0| 69 6e 66 6f 72 6d 61 74 | 69 6f 6e 20 61 62 6f 75 |informat|ion abou|
|00004de0| 74 20 65 78 65 63 75 74 | 69 6e 67 20 61 20 71 75 |t execut|ing a qu|
|00004df0| 65 72 79 2c 20 73 65 65 | 20 74 68 65 20 73 65 63 |ery, see| the sec|
|00004e00| 74 69 6f 6e 20 74 69 74 | 6c 65 64 20 43 52 45 41 |tion tit|led CREA|
|00004e10| 54 49 4e 47 20 41 20 51 | 55 45 52 59 20 61 62 6f |TING A Q|UERY abo|
|00004e20| 76 65 2e 0d 0a 0d 0a 09 | 34 2e 20 20 43 68 6f 6f |ve......|4.  Choo|
|00004e30| 73 65 20 43 6f 6e 76 65 | 72 74 20 4d 65 6d 6f 2e |se Conve|rt Memo.|
|00004e40| 2e 2e 20 66 72 6f 6d 20 | 74 68 65 20 44 61 74 61 |.. from |the Data|
|00004e50| 62 61 73 65 20 6d 65 6e | 75 2e 0d 0a 0d 0a 09 35 |base men|u......5|
|00004e60| 2e 20 20 53 65 6c 65 63 | 74 20 74 68 65 20 6d 65 |.  Selec|t the me|
|00004e70| 6d 6f 20 74 6f 20 63 6f | 6e 76 65 72 74 20 69 6e |mo to co|nvert in|
|00004e80| 20 74 68 65 20 43 6f 6e | 76 65 72 74 20 4d 65 6d | the Con|vert Mem|
|00004e90| 6f 20 64 69 61 6c 6f 67 | 20 61 6e 64 20 63 68 6f |o dialog| and cho|
|00004ea0| 6f 73 65 20 4f 4b 2e 0d | 0a 09 0d 0a 09 0d 0a d6 |ose OK..|........|
|00004eb0| c4 c4 c4 c4 c4 c4 c4 c4 | c4 c4 c4 c4 c4 c4 c4 c4 |........|........|
|00004ec0| c4 c4 c4 c4 c4 c4 c4 c4 | c4 c4 c4 c4 c4 c4 c4 c4 |........|........|
|00004ed0| c4 b7 0d 0a ba 20 20 20 | 20 20 45 78 69 74 69 6e |.....   |  Exitin|
|00004ee0| 67 20 43 4b 53 41 4d 50 | 4c 45 2e 41 50 50 20 20 |g CKSAMP|LE.APP  |
|00004ef0| 20 20 20 20 20 20 ba 0d | 0a d3 c4 c4 c4 c4 c4 c4 |      ..|........|
|00004f00| c4 c4 c4 c4 c4 c4 c4 c4 | c4 c4 c4 c4 c4 c4 c4 c4 |........|........|
|00004f10| c4 c4 c4 c4 c4 c4 c4 c4 | c4 c4 c4 bd 0d 0a 20 20 |........|......  |
|00004f20| 20 20 20 20 20 0d 0a 54 | 6f 20 45 78 69 74 20 43 |     ..T|o Exit C|
|00004f30| 4b 53 41 4d 50 4c 45 2e | 41 50 50 2c 20 63 68 6f |KSAMPLE.|APP, cho|
|00004f40| 6f 73 65 20 45 78 69 74 | 20 66 72 6f 6d 20 74 68 |ose Exit| from th|
|00004f50| 65 20 44 61 74 61 62 61 | 73 65 20 6d 65 6e 75 2e |e Databa|se menu.|
|00004f60| 20 20 41 20 64 69 61 6c | 6f 67 20 77 69 74 68 20 |  A dial|og with |
|00004f70| 74 68 65 20 66 6f 6c 6c | 6f 77 69 6e 67 20 6f 62 |the foll|owing ob|
|00004f80| 6a 65 63 74 73 20 6f 70 | 65 6e 73 20 74 6f 20 63 |jects op|ens to c|
|00004f90| 6f 6e 66 69 72 6d 20 74 | 68 61 74 20 79 6f 75 20 |onfirm t|hat you |
|00004fa0| 77 61 6e 74 20 74 6f 20 | 65 78 69 74 3a 0d 0a 0d |want to |exit:...|
|00004fb0| 0a 09 59 65 73 20 62 75 | 74 74 6f 6e 20 2d 2d 20 |..Yes bu|tton -- |
|00004fc0| 20 20 43 68 6f 6f 73 65 | 20 74 6f 20 65 78 69 74 |  Choose| to exit|
|00004fd0| 2e 0d 0a 09 0d 0a 09 4e | 6f 20 62 75 74 74 6f 6e |.......N|o button|
|00004fe0| 20 2d 2d 20 52 65 74 75 | 72 6e 20 74 6f 20 43 4b | -- Retu|rn to CK|
|00004ff0| 53 41 4d 50 4c 45 2e 41 | 50 50 2e 0d 0a 09 0d 0a |SAMPLE.A|PP......|
|00005000| 09 43 6c 6f 73 65 20 54 | 61 62 6c 65 73 20 6f 6e |.Close T|ables on|
|00005010| 20 45 78 69 74 20 63 68 | 65 63 6b 20 62 6f 78 20 | Exit ch|eck box |
|00005020| 2d 2d 20 0d 0a 0d 0a f2 | a0 73 d6 05 89 b1 78 01 |-- .....|.s....x.|
|00005030| 1e 50 55 e3 fb 57 56 66 | ad 2d 12 c2 a8 75 c0 ba |.PU..WVf|.-...u..|
|00005040| 00 00 00 01 00 00 27 86 | 0d 0a 54 68 65 20 43 4b |......'.|..The CK|
|00005050| 53 41 4d 50 4c 45 20 61 | 70 70 6c 69 63 61 74 69 |SAMPLE a|pplicati|
|00005060| 6f 6e 20 6c 65 74 73 20 | 79 6f 75 20 71 75 69 63 |on lets |you quic|
|00005070| 6b 6c 79 20 61 6e 64 20 | 65 61 73 69 6c 79 20 70 |kly and |easily p|
|00005080| 65 72 66 6f 72 6d 20 73 | 6f 6d 65 20 6f 66 20 74 |erform s|ome of t|
|00005090| 68 65 20 62 61 73 69 63 | 20 6f 70 65 72 61 74 69 |he basic| operati|
|000050a0| 6f 6e 73 20 61 73 73 6f | 63 69 61 74 65 64 20 77 |ons asso|ciated w|
|000050b0| 69 74 68 20 61 20 63 6c | 69 65 6e 74 20 66 72 6f |ith a cl|ient fro|
|000050c0| 6e 74 20 65 6e 64 2c 20 | 73 75 63 68 20 61 73 20 |nt end, |such as |
|000050d0| 63 6f 6e 6e 65 63 74 69 | 6e 67 20 74 6f 20 61 20 |connecti|ng to a |
|000050e0| 64 61 74 61 20 73 6f 75 | 72 63 65 2c 20 75 73 69 |data sou|rce, usi|
|000050f0| 6e 67 20 61 20 64 61 74 | 61 62 61 73 65 20 6f 6e |ng a dat|abase on|
|00005100| 20 74 68 65 20 64 61 74 | 61 20 73 6f 75 72 63 65 | the dat|a source|
|00005110| 2c 20 61 6e 64 20 71 75 | 65 72 79 69 6e 67 20 64 |, and qu|erying d|
|00005120| 61 74 61 2e 20 43 4b 53 | 41 4d 50 4c 45 20 61 6c |ata. CKS|AMPLE al|
|00005130| 73 6f 20 6c 65 74 73 20 | 79 6f 75 20 73 65 74 20 |so lets |you set |
|00005140| 76 61 72 69 6f 75 73 20 | 6f 70 74 69 6f 6e 73 2c |various |options,|
|00005150| 20 65 64 69 74 20 53 51 | 4c 20 63 6f 6d 6d 61 6e | edit SQ|L comman|
|00005160| 64 73 20 74 6f 20 62 65 | 20 73 65 6e 74 20 74 6f |ds to be| sent to|
|00005170| 20 74 68 65 20 64 61 74 | 61 20 0d 0a 73 6f 75 72 | the dat|a ..sour|
|00005180| 63 65 2c 20 61 6e 64 20 | 63 6f 6e 76 65 72 74 20 |ce, and |convert |
|00005190| 61 20 64 61 74 61 20 73 | 6f 75 72 63 65 20 6d 65 |a data s|ource me|
|000051a0| 6d 6f 20 66 69 65 6c 64 | 20 77 69 74 68 20 62 69 |mo field| with bi|
|000051b0| 6e 61 72 79 20 64 61 74 | 61 20 74 6f 20 61 20 46 |nary dat|a to a F|
|000051c0| 6f 78 50 72 6f 20 67 65 | 6e 65 72 61 6c 20 74 79 |oxPro ge|neral ty|
|000051d0| 70 65 20 66 69 65 6c 64 | 2e 0d 0a 0d 0a d6 c4 c4 |pe field|........|
|000051e0| c4 c4 c4 c4 c4 c4 c4 c4 | c4 c4 c4 c4 c4 c4 c4 c4 |........|........|
|000051f0| c4 c4 c4 c4 c4 c4 c4 c4 | c4 c4 c4 c4 c4 c4 c4 b7 |........|........|
|00005200| 0d 0a ba 20 20 43 6f 6e | 6e 65 63 74 69 6e 67 20 |...  Con|necting |
|00005210| 74 6f 20 61 20 44 61 74 | 61 20 53 6f 75 72 63 65 |to a Dat|a Source|
|00005220| 20 20 20 20 ba 0d 0a d3 | c4 c4 c4 c4 c4 c4 c4 c4 |    ....|........|
|00005230| c4 c4 c4 c4 c4 c4 c4 c4 | c4 c4 c4 c4 c4 c4 c4 c4 |........|........|
|00005240| c4 c4 c4 c4 c4 c4 c4 c4 | c4 bd 0d 0a 0d 0a 4e 4f |........|......NO|
|00005250| 54 45 3a 20 20 42 65 66 | 6f 72 65 20 79 6f 75 20 |TE:  Bef|ore you |
|00005260| 63 61 6e 20 63 6f 6e 6e | 65 63 74 20 74 6f 20 61 |can conn|ect to a|
|00005270| 20 64 61 74 61 20 73 6f | 75 72 63 65 2c 20 74 68 | data so|urce, th|
|00005280| 65 20 61 70 70 72 6f 70 | 72 69 61 74 65 20 64 72 |e approp|riate dr|
|00005290| 69 76 65 72 20 66 6f 72 | 20 74 68 65 20 64 61 74 |iver for| the dat|
|000052a0| 61 20 73 6f 75 72 63 65 | 20 6d 75 73 74 20 68 61 |a source| must ha|
|000052b0| 76 65 20 70 72 65 76 69 | 6f 75 73 6c 79 20 62 65 |ve previ|ously be|
|000052c0| 65 6e 20 69 6e 73 74 61 | 6c 6c 65 64 20 6f 6e 20 |en insta|lled on |
|000052d0| 79 6f 75 72 20 6d 61 63 | 68 69 6e 65 2e 0d 0a 0d |your mac|hine....|
|000052e0| 0a 57 68 65 6e 20 79 6f | 75 20 72 75 6e 20 43 4b |.When yo|u run CK|
|000052f0| 53 41 4d 50 4c 45 2e 41 | 50 50 2c 20 74 68 65 20 |SAMPLE.A|PP, the |
|00005300| 43 6f 6e 6e 65 63 74 20 | 74 6f 20 44 61 74 61 20 |Connect |to Data |
|00005310| 53 6f 75 72 63 65 20 64 | 69 61 6c 6f 67 20 6f 70 |Source d|ialog op|
|00005320| 65 6e 73 2e 20 20 54 68 | 69 73 20 64 69 61 6c 6f |ens.  Th|is dialo|
|00005330| 67 20 63 6f 6e 74 61 69 | 6e 73 20 74 68 65 20 66 |g contai|ns the f|
|00005340| 6f 6c 6c 6f 77 69 6e 67 | 20 6f 62 6a 65 63 74 73 |ollowing| objects|
|00005350| 3a 0d 0a 0d 0a 09 44 61 | 74 61 20 53 6f 75 72 63 |:.....Da|ta Sourc|
|00005360| 65 20 74 65 78 74 20 62 | 6f 78 20 2d 2d 20 74 79 |e text b|ox -- ty|
|00005370| 70 65 20 74 68 65 20 6e | 61 6d 65 20 6f 66 20 74 |pe the n|ame of t|
|00005380| 68 65 20 64 61 74 61 20 | 73 6f 75 72 63 65 20 74 |he data |source t|
|00005390| 6f 20 77 68 69 63 68 20 | 79 6f 75 20 77 61 6e 74 |o which |you want|
|000053a0| 20 74 6f 20 63 6f 6e 6e | 65 63 74 2e 20 54 68 69 | to conn|ect. Thi|
|000053b0| 73 20 69 6e 66 6f 72 6d | 61 74 69 6f 6e 20 69 73 |s inform|ation is|
|000053c0| 20 72 65 71 75 69 72 65 | 64 20 69 6e 20 6f 72 64 | require|d in ord|
|000053d0| 65 72 20 74 6f 20 63 6f | 6e 6e 65 63 74 20 74 6f |er to co|nnect to|
|000053e0| 20 61 20 64 61 74 61 20 | 73 6f 75 72 63 65 2e 0d | a data |source..|
|000053f0| 0a 0d 0a 09 55 73 65 72 | 20 49 64 65 6e 74 69 66 |....User| Identif|
|00005400| 69 65 72 20 74 65 78 74 | 20 62 6f 78 20 2d 2d 20 |ier text| box -- |
|00005410| 74 79 70 65 20 74 68 65 | 20 75 73 65 72 20 69 64 |type the| user id|
|00005420| 65 6e 74 69 66 69 63 61 | 74 69 6f 6e 20 75 6e 64 |entifica|tion und|
|00005430| 65 72 20 77 68 69 63 68 | 20 79 6f 75 20 77 61 6e |er which| you wan|
|00005440| 74 20 74 6f 20 6c 6f 67 | 20 6f 6e 20 74 6f 20 74 |t to log| on to t|
|00005450| 68 65 20 64 61 74 61 20 | 73 6f 75 72 63 65 2e 20 |he data |source. |
|00005460| 54 68 69 73 20 69 6e 66 | 6f 72 6d 61 74 69 6f 6e |This inf|ormation|
|00005470| 20 69 73 20 72 65 71 75 | 69 72 65 64 20 69 6e 20 | is requ|ired in |
|00005480| 6f 72 64 65 72 20 74 6f | 20 63 6f 6e 6e 65 63 74 |order to| connect|
|00005490| 20 74 6f 20 61 20 64 61 | 74 61 20 73 6f 75 72 63 | to a da|ta sourc|
|000054a0| 65 2e 0d 0a 0d 0a 09 50 | 61 73 73 77 6f 72 64 20 |e......P|assword |
|000054b0| 74 65 78 74 20 62 6f 78 | 20 2d 2d 20 49 66 20 74 |text box| -- If t|
|000054c0| 68 65 20 64 61 74 61 20 | 73 6f 75 72 63 65 20 68 |he data |source h|
|000054d0| 61 73 20 70 61 73 73 77 | 6f 72 64 20 70 72 6f 74 |as passw|ord prot|
|000054e0| 65 63 74 69 6f 6e 2c 20 | 74 79 70 65 20 74 68 65 |ection, |type the|
|000054f0| 20 70 61 73 73 77 6f 72 | 64 20 69 6e 20 74 68 69 | passwor|d in thi|
|00005500| 73 20 74 65 78 74 20 62 | 6f 78 2e 20 49 66 20 74 |s text b|ox. If t|
|00005510| 68 65 20 64 61 74 61 20 | 73 6f 75 72 63 65 20 64 |he data |source d|
|00005520| 6f 65 73 6e 27 74 20 72 | 65 71 75 69 72 65 20 61 |oesn't r|equire a|
|00005530| 20 70 61 73 73 77 6f 72 | 64 2c 20 74 68 69 73 20 | passwor|d, this |
|00005540| 74 65 78 74 20 62 6f 78 | 20 63 61 6e 20 62 65 20 |text box| can be |
|00005550| 6c 65 66 74 20 65 6d 70 | 74 79 2e 0d 0a 0d 0a 09 |left emp|ty......|
|00005560| 43 6f 6e 6e 65 63 74 20 | 53 74 72 69 6e 67 20 74 |Connect |String t|
|00005570| 65 78 74 20 62 6f 78 20 | 2d 2d 20 49 66 20 74 68 |ext box |-- If th|
|00005580| 65 20 64 61 74 61 20 73 | 6f 75 72 63 65 20 61 63 |e data s|ource ac|
|00005590| 63 65 70 74 73 20 69 6e | 73 74 72 75 63 74 69 6f |cepts in|structio|
|000055a0| 6e 73 20 6f 72 20 63 6f | 6d 6d 61 6e 64 73 20 77 |ns or co|mmands w|
|000055b0| 68 65 6e 20 61 20 63 6f | 6e 6e 65 63 74 69 6f 6e |hen a co|nnection|
|000055c0| 20 69 73 20 6d 61 64 65 | 2c 20 79 6f 75 20 63 61 | is made|, you ca|
|000055d0| 6e 20 69 6e 63 6c 75 64 | 65 20 74 68 61 74 20 69 |n includ|e that i|
|000055e0| 6e 73 74 72 75 63 74 69 | 6f 6e 20 69 6e 20 74 68 |nstructi|on in th|
|000055f0| 65 20 43 6f 6e 6e 65 63 | 74 20 53 74 72 69 6e 67 |e Connec|t String|
|00005600| 20 74 65 78 74 20 62 6f | 78 2e 20 20 49 66 20 74 | text bo|x.  If t|
|00005610| 68 65 20 64 61 74 61 20 | 73 6f 75 72 63 65 20 64 |he data |source d|
|00005620| 6f 65 73 20 6e 6f 74 20 | 61 63 63 65 70 74 20 69 |oes not |accept i|
|00005630| 6e 73 74 72 75 63 74 69 | 6f 6e 73 20 6f 72 20 63 |nstructi|ons or c|
|00005640| 6f 6d 6d 61 6e 64 73 20 | 61 74 20 74 68 65 20 74 |ommands |at the t|
|00005650| 69 6d 65 20 6f 66 20 63 | 6f 6e 6e 65 63 74 69 6f |ime of c|onnectio|
|00005660| 6e 2c 20 61 6e 79 74 68 | 69 6e 67 20 74 79 70 65 |n, anyth|ing type|
|00005670| 64 20 69 6e 20 74 68 65 | 20 43 6f 6e 6e 65 63 74 |d in the| Connect|
|00005680| 20 53 74 72 69 6e 67 20 | 74 65 78 74 20 62 6f 78 | String |text box|
|00005690| 20 69 73 20 69 67 6e 6f | 72 65 64 2e 20 20 54 68 | is igno|red.  Th|
|000056a0| 69 73 20 74 65 78 74 20 | 62 6f 78 20 63 61 6e 20 |is text |box can |
|000056b0| 62 65 20 6c 65 66 74 20 | 65 6d 70 74 79 2e 0d 0a |be left |empty...|
|000056c0| 0d 0a 09 4f 4b 20 61 6e | 64 20 43 61 6e 63 65 6c |...OK an|d Cancel|
|000056d0| 20 62 75 74 74 6f 6e 73 | 20 2d 2d 20 43 68 6f 6f | buttons| -- Choo|
|000056e0| 73 65 20 4f 4b 20 74 6f | 20 61 74 74 65 6d 70 74 |se OK to| attempt|
|000056f0| 20 74 68 65 20 63 6f 6e | 6e 65 63 74 69 6f 6e 20 | the con|nection |
|00005700| 73 70 65 63 69 66 69 65 | 64 20 69 6e 20 74 68 65 |specifie|d in the|
|00005710| 20 76 61 72 69 6f 75 73 | 20 74 65 78 74 20 62 6f | various| text bo|
|00005720| 78 65 73 20 69 6e 20 74 | 68 69 73 20 64 69 61 6c |xes in t|his dial|
|00005730| 6f 67 2e 20 49 66 20 74 | 68 65 20 63 6f 6e 6e 65 |og. If t|he conne|
|00005740| 63 74 69 6f 6e 20 69 73 | 20 73 75 63 63 65 73 73 |ction is| success|
|00005750| 66 75 6c 2c 20 61 20 73 | 75 63 63 65 73 73 66 75 |ful, a s|uccessfu|
|00005760| 6c 20 63 6f 6e 6e 65 63 | 74 69 6f 6e 20 6d 65 73 |l connec|tion mes|
|00005770| 73 61 67 65 20 69 73 20 | 64 69 73 70 6c 61 79 65 |sage is |displaye|
|00005780| 64 20 69 6e 20 61 20 77 | 61 69 74 20 77 69 6e 64 |d in a w|ait wind|
|00005790| 6f 77 20 61 6e 64 20 74 | 68 65 20 6e 61 6d 65 20 |ow and t|he name |
|000057a0| 6f 66 20 74 68 65 20 64 | 61 74 61 20 73 6f 75 72 |of the d|ata sour|
|000057b0| 63 65 20 69 73 20 64 69 | 73 70 6c 61 79 65 64 20 |ce is di|splayed |
|000057c0| 6f 6e 20 74 68 65 20 73 | 74 61 74 75 73 20 62 61 |on the s|tatus ba|
|000057d0| 72 2e 20 49 66 20 79 6f | 75 20 63 61 6e 6e 6f 74 |r. If yo|u cannot|
|000057e0| 20 63 6f 6e 6e 65 63 74 | 2c 20 61 6e 20 65 72 72 | connect|, an err|
|000057f0| 6f 72 20 6d 65 73 73 61 | 67 65 20 69 73 20 64 69 |or messa|ge is di|
|00005800| 73 70 6c 61 79 65 64 20 | 61 6e 64 20 79 6f 75 20 |splayed |and you |
|00005810| 61 72 65 20 72 65 74 75 | 72 6e 65 64 20 74 6f 20 |are retu|rned to |
|00005820| 74 68 65 20 64 69 61 6c | 6f 67 2e 0d 0a 0d 0a 09 |the dial|og......|
|00005830| 57 68 65 6e 20 79 6f 75 | 20 72 75 6e 20 43 4b 53 |When you| run CKS|
|00005840| 41 4d 50 4c 45 2e 41 50 | 50 2c 20 79 6f 75 20 6d |AMPLE.AP|P, you m|
|00005850| 75 73 74 20 63 6f 6e 6e | 65 63 74 20 74 6f 20 61 |ust conn|ect to a|
|00005860| 20 64 61 74 61 20 73 6f | 75 72 63 65 2e 20 20 49 | data so|urce.  I|
|00005870| 66 20 79 6f 75 20 63 68 | 6f 6f 73 65 20 43 61 6e |f you ch|oose Can|
|00005880| 63 65 6c 2c 20 43 4b 53 | 41 4d 50 4c 45 2e 41 50 |cel, CKS|AMPLE.AP|
|00005890| 50 20 74 65 72 6d 69 6e | 61 74 65 73 2e 0d 0a 0d |P termin|ates....|
|000058a0| 0a 09 54 6f 20 63 68 61 | 6e 67 65 20 64 61 74 61 |..To cha|nge data|
|000058b0| 20 73 6f 75 72 63 65 20 | 63 6f 6e 6e 65 63 74 69 | source |connecti|
|000058c0| 6f 6e 73 2c 20 63 68 6f | 6f 73 65 20 44 69 73 63 |ons, cho|ose Disc|
|000058d0| 6f 6e 6e 65 63 74 20 66 | 72 6f 6d 20 74 68 65 20 |onnect f|rom the |
|000058e0| 44 61 74 61 62 61 73 65 | 20 6d 65 6e 75 2c 20 74 |Database| menu, t|
|000058f0| 68 65 6e 20 63 68 6f 6f | 73 65 20 43 6f 6e 6e 65 |hen choo|se Conne|
|00005900| 63 74 2e 2e 2e 20 66 72 | 6f 6d 20 74 68 65 20 44 |ct... fr|om the D|
|00005910| 61 74 61 62 61 73 65 20 | 6d 65 6e 75 2e 20 20 54 |atabase |menu.  T|
|00005920| 68 65 20 43 6f 6e 6e 65 | 63 74 20 74 6f 20 44 61 |he Conne|ct to Da|
|00005930| 74 61 20 53 6f 75 72 63 | 65 20 64 69 61 6c 6f 67 |ta Sourc|e dialog|
|00005940| 20 6f 70 65 6e 73 2e 20 | 20 41 67 61 69 6e 2c 20 | opens. | Again, |
|00005950| 79 6f 75 20 6e 65 65 64 | 20 74 6f 20 69 6e 64 69 |you need| to indi|
|00005960| 63 61 74 65 20 61 20 64 | 61 74 61 20 73 6f 75 72 |cate a d|ata sour|
|00005970| 63 65 20 74 6f 20 63 6f | 6e 6e 65 63 74 20 74 6f |ce to co|nnect to|
|00005980| 20 61 6e 64 20 61 20 75 | 73 65 72 20 69 64 65 6e | and a u|ser iden|
|00005990| 74 69 66 69 63 61 74 69 | 6f 6e 2c 20 61 73 20 77 |tificati|on, as w|
|000059a0| 65 6c 6c 20 61 73 20 61 | 20 70 61 73 73 77 6f 72 |ell as a| passwor|
|000059b0| 64 20 61 6e 64 20 63 6f | 6e 6e 65 63 74 20 73 74 |d and co|nnect st|
|000059c0| 72 69 6e 67 20 69 66 20 | 0d 0a 64 65 73 69 72 65 |ring if |..desire|
|000059d0| 64 2c 20 74 68 65 6e 20 | 63 68 6f 6f 73 65 20 4f |d, then |choose O|
|000059e0| 4b 2e 20 20 49 66 20 79 | 6f 75 20 63 68 6f 6f 73 |K.  If y|ou choos|
|000059f0| 65 20 43 61 6e 63 65 6c | 2c 20 6e 6f 20 61 74 74 |e Cancel|, no att|
|00005a00| 65 6d 70 74 20 69 73 20 | 6d 61 64 65 20 74 6f 20 |empt is |made to |
|00005a10| 63 6f 6e 6e 65 63 74 20 | 74 6f 20 61 20 64 61 74 |connect |to a dat|
|00005a20| 61 20 73 6f 75 72 63 65 | 20 61 6e 64 20 74 68 65 |a source| and the|
|00005a30| 20 64 69 61 6c 6f 67 20 | 69 73 20 63 6c 6f 73 65 | dialog |is close|
|00005a40| 64 2c 20 62 75 74 20 43 | 4b 53 41 4d 50 4c 45 2e |d, but C|KSAMPLE.|
|00005a50| 41 50 50 20 63 6f 6e 74 | 69 6e 75 65 73 20 74 6f |APP cont|inues to|
|00005a60| 20 72 75 6e 2e 0d 0a 0d | 0a 0d 0a d6 c4 c4 c4 c4 | run....|........|
|00005a70| c4 c4 c4 c4 c4 c4 c4 c4 | c4 c4 c4 c4 c4 c4 c4 c4 |........|........|
|00005a80| c4 c4 c4 c4 c4 c4 c4 c4 | c4 c4 c4 c4 c4 b7 0d 0a |........|........|
|00005a90| ba 20 20 20 20 20 20 20 | 20 20 55 73 69 6e 67 20 |.       |  Using |
|00005aa0| 61 20 44 61 74 61 62 61 | 73 65 20 20 20 20 20 20 |a Databa|se      |
|00005ab0| 20 20 ba 0d 0a d3 c4 c4 | c4 c4 c4 c4 c4 c4 c4 c4 |  ......|........|
|00005ac0| c4 c4 c4 c4 c4 c4 c4 c4 | c4 c4 c4 c4 c4 c4 c4 c4 |........|........|
|00005ad0| c4 c4 c4 c4 c4 c4 c4 bd | 0d 0a 0d 0a 4d 75 6c 74 |........|....Mult|
|00005ae0| 69 70 6c 65 20 64 61 74 | 61 62 61 73 65 73 20 63 |iple dat|abases c|
|00005af0| 61 6e 20 62 65 20 73 74 | 6f 72 65 64 20 6f 6e 20 |an be st|ored on |
|00005b00| 61 20 73 69 6e 67 6c 65 | 20 64 61 74 61 20 73 6f |a single| data so|
|00005b10| 75 72 63 65 20 61 6e 64 | 20 61 20 64 61 74 61 62 |urce and| a datab|
|00005b20| 61 73 65 20 63 61 6e 20 | 63 6f 6e 74 61 69 6e 20 |ase can |contain |
|00005b30| 61 20 6e 75 6d 62 65 72 | 20 6f 66 20 74 61 62 6c |a number| of tabl|
|00005b40| 65 73 2e 20 20 57 68 65 | 6e 20 79 6f 75 20 61 72 |es.  Whe|n you ar|
|00005b50| 65 20 63 6f 6e 6e 65 63 | 74 65 64 20 74 6f 20 61 |e connec|ted to a|
|00005b60| 20 64 61 74 61 20 73 6f | 75 72 63 65 2c 20 79 6f | data so|urce, yo|
|00005b70| 75 20 63 61 6e 20 75 73 | 65 20 61 20 64 61 74 61 |u can us|e a data|
|00005b80| 62 61 73 65 20 6f 6e 20 | 74 68 61 74 20 73 6f 75 |base on |that sou|
|00005b90| 72 63 65 2e 20 20 54 6f | 20 75 73 65 20 74 68 65 |rce.  To| use the|
|00005ba0| 20 64 61 74 61 62 61 73 | 65 20 77 68 6f 73 65 20 | databas|e whose |
|00005bb0| 64 61 74 61 20 79 6f 75 | 20 77 61 6e 74 20 74 6f |data you| want to|
|00005bc0| 20 61 63 63 65 73 73 2c | 20 63 68 6f 6f 73 65 20 | access,| choose |
|00005bd0| 55 73 65 20 44 61 74 61 | 62 61 73 65 2e 2e 2e 20 |Use Data|base... |
|00005be0| 66 72 6f 6d 20 74 68 65 | 20 44 61 74 61 62 61 73 |from the| Databas|
|00005bf0| 65 20 6d 65 6e 75 2e 20 | 54 68 65 20 55 73 65 20 |e menu. |The Use |
|00005c00| 44 61 74 61 62 61 73 65 | 20 64 69 61 6c 6f 67 20 |Database| dialog |
|00005c10| 0d 0a 6f 70 65 6e 73 2e | 20 20 54 79 70 65 20 74 |..opens.|  Type t|
|00005c20| 68 65 20 6e 61 6d 65 20 | 6f 66 20 74 68 65 20 64 |he name |of the d|
|00005c30| 61 74 61 62 61 73 65 20 | 79 6f 75 20 77 61 6e 74 |atabase |you want|
|00005c40| 20 74 6f 20 75 73 65 20 | 69 6e 20 74 68 65 20 74 | to use |in the t|
|00005c50| 65 78 74 20 62 6f 78 20 | 61 6e 64 20 63 68 6f 6f |ext box |and choo|
|00005c60| 73 65 20 4f 4b 2e 20 20 | 54 6f 20 75 73 65 20 61 |se OK.  |To use a|
|00005c70| 20 64 69 66 66 65 72 65 | 6e 74 20 64 61 74 61 62 | differe|nt datab|
|00005c80| 61 73 65 2c 20 66 6f 6c | 6c 6f 77 20 74 68 65 20 |ase, fol|low the |
|00005c90| 73 61 6d 65 20 73 74 65 | 70 73 2e 20 20 59 6f 75 |same ste|ps.  You|
|00005ca0| 20 63 61 6e 20 75 73 65 | 20 6f 6e 6c 79 20 6f 6e | can use| only on|
|00005cb0| 65 20 64 61 74 61 62 61 | 73 65 20 61 74 20 61 20 |e databa|se at a |
|00005cc0| 74 69 6d 65 2e 20 20 4f | 6e 63 65 20 79 6f 75 20 |time.  O|nce you |
|00005cd0| 75 73 65 20 61 20 64 61 | 74 61 62 61 73 65 2c 20 |use a da|tabase, |
|00005ce0| 74 68 65 20 6e 61 6d 65 | 20 6f 66 20 74 68 65 20 |the name| of the |
|00005cf0| 64 61 74 61 62 61 73 65 | 20 69 73 20 64 69 73 70 |database| is disp|
|00005d00| 6c 61 79 65 64 20 6f 6e | 20 74 68 65 20 73 74 61 |layed on| the sta|
|00005d10| 74 75 73 20 62 61 72 20 | 61 6e 64 20 61 6c 6c 20 |tus bar |and all |
|00005d20| 74 68 65 20 74 61 62 6c | 65 73 20 69 6e 20 74 68 |the tabl|es in th|
|00005d30| 61 74 20 64 61 74 61 62 | 61 73 65 20 61 72 65 20 |at datab|ase are |
|00005d40| 61 76 61 69 6c 61 62 6c | 65 20 66 6f 72 20 71 75 |availabl|e for qu|
|00005d50| 65 72 79 69 6e 67 2e 0d | 0a 0d 0a d6 c4 c4 c4 c4 |erying..|........|
|00005d60| c4 c4 c4 c4 c4 c4 c4 c4 | c4 c4 c4 c4 c4 c4 c4 c4 |........|........|
|00005d70| c4 c4 c4 c4 c4 c4 c4 c4 | c4 c4 c4 c4 c4 b7 0d 0a |........|........|
|00005d80| ba 20 20 20 20 20 20 20 | 20 43 72 65 61 74 69 6e |.       | Creatin|
|00005d90| 67 20 61 20 51 75 65 72 | 79 20 20 20 20 20 20 20 |g a Quer|y       |
|00005da0| 20 20 ba 0d 0a d3 c4 c4 | c4 c4 c4 c4 c4 c4 c4 c4 |  ......|........|
|00005db0| c4 c4 c4 c4 c4 c4 c4 c4 | c4 c4 c4 c4 c4 c4 c4 c4 |........|........|
|00005dc0| c4 c4 c4 c4 c4 c4 c4 bd | 0d 0a 0d 0a 59 6f 75 20 |........|....You |
|00005dd0| 63 61 6e 20 61 6c 6c 6f | 77 20 43 4b 53 41 4d 50 |can allo|w CKSAMP|
|00005de0| 4c 45 2e 41 50 50 20 74 | 6f 20 62 75 69 6c 64 20 |LE.APP t|o build |
|00005df0| 61 20 53 51 4c 20 73 74 | 61 74 65 6d 65 6e 74 20 |a SQL st|atement |
|00005e00| 62 61 73 65 64 20 6f 6e | 20 79 6f 75 72 20 63 68 |based on| your ch|
|00005e10| 6f 69 63 65 73 20 69 6e | 20 74 68 65 20 42 75 69 |oices in| the Bui|
|00005e20| 6c 64 20 51 75 65 72 79 | 20 64 69 61 6c 6f 67 20 |ld Query| dialog |
|00005e30| 6f 72 20 77 72 69 74 65 | 20 79 6f 75 72 20 6f 77 |or write| your ow|
|00005e40| 6e 20 53 51 4c 20 73 74 | 61 74 65 6d 65 6e 74 20 |n SQL st|atement |
|00005e50| 69 6e 20 74 68 65 20 45 | 64 69 74 20 51 75 65 72 |in the E|dit Quer|
|00005e60| 79 20 64 69 61 6c 6f 67 | 2e 20 0d 0a 0d 0a 43 68 |y dialog|. ....Ch|
|00005e70| 6f 6f 73 65 20 42 75 69 | 6c 64 20 51 75 65 72 79 |oose Bui|ld Query|
|00005e80| 2e 2e 2e 20 66 72 6f 6d | 20 74 68 65 20 51 75 65 |... from| the Que|
|00005e90| 72 79 20 6d 65 6e 75 20 | 74 6f 20 6f 70 65 6e 20 |ry menu |to open |
|00005ea0| 74 68 65 20 42 75 69 6c | 64 20 51 75 65 72 79 20 |the Buil|d Query |
|00005eb0| 64 69 61 6c 6f 67 2e 20 | 20 54 68 69 73 20 64 69 |dialog. | This di|
|00005ec0| 61 6c 6f 67 20 63 6f 6e | 74 61 69 6e 73 20 74 68 |alog con|tains th|
|00005ed0| 65 20 66 6f 6c 6c 6f 77 | 69 6e 67 20 6f 62 6a 65 |e follow|ing obje|
|00005ee0| 63 74 73 3a 0d 0a 0d 0a | 09 46 72 6f 6d 2e 2e 2e |cts:....|.From...|
|00005ef0| 20 62 75 74 74 6f 6e 20 | 2d 2d 20 43 68 6f 6f 73 | button |-- Choos|
|00005f00| 65 20 74 61 62 6c 65 73 | 20 74 6f 20 62 65 20 69 |e tables| to be i|
|00005f10| 6e 63 6c 75 64 65 64 20 | 69 6e 20 74 68 65 20 71 |ncluded |in the q|
|00005f20| 75 65 72 79 2e 0d 0a 43 | 68 6f 6f 73 69 6e 67 20 |uery...C|hoosing |
|00005f30| 74 68 65 20 46 72 6f 6d | 2e 2e 2e 20 62 75 74 74 |the From|... butt|
|00005f40| 6f 6e 20 6f 70 65 6e 73 | 20 74 68 65 20 46 72 6f |on opens| the Fro|
|00005f50| 6d 20 64 69 61 6c 6f 67 | 20 77 69 74 68 20 61 20 |m dialog| with a |
|00005f60| 6c 69 73 74 20 6f 66 20 | 74 68 65 20 74 61 62 6c |list of |the tabl|
|00005f70| 65 73 20 69 6e 20 74 68 | 65 20 64 61 74 61 62 61 |es in th|e databa|
|00005f80| 73 65 20 63 75 72 72 65 | 6e 74 6c 79 20 69 6e 20 |se curre|ntly in |
|00005f90| 75 73 65 20 61 6e 64 20 | 61 20 6c 69 73 74 20 6f |use and |a list o|
|00005fa0| 66 20 74 61 62 6c 65 73 | 20 66 72 6f 6d 20 74 68 |f tables| from th|
|00005fb0| 69 73 20 64 61 74 61 62 | 61 73 65 20 74 6f 20 62 |is datab|ase to b|
|00005fc0| 65 20 69 6e 63 6c 75 64 | 65 64 20 69 6e 20 74 68 |e includ|ed in th|
|00005fd0| 65 20 71 75 65 72 79 2e | 20 54 6f 20 6d 6f 76 65 |e query.| To move|
|00005fe0| 20 61 20 74 61 62 6c 65 | 20 66 72 6f 6d 20 74 68 | a table| from th|
|00005ff0| 65 20 44 61 74 61 62 61 | 73 65 20 74 61 62 6c 65 |e Databa|se table|
|00006000| 73 20 0d 0a 6c 69 73 74 | 20 69 6e 74 6f 20 74 68 |s ..list| into th|
|00006010| 65 20 51 75 65 72 79 20 | 74 61 62 6c 65 73 20 6c |e Query |tables l|
|00006020| 69 73 74 2c 20 64 6f 75 | 62 6c 65 2d 63 6c 69 63 |ist, dou|ble-clic|
|00006030| 6b 20 69 74 20 6f 72 20 | 73 65 6c 65 63 74 20 69 |k it or |select i|
|00006040| 74 20 77 69 74 68 20 74 | 68 65 20 6d 6f 75 73 65 |t with t|he mouse|
|00006050| 20 6f 72 20 6b 65 79 62 | 6f 61 72 64 20 61 6e 64 | or keyb|oard and|
|00006060| 20 63 68 6f 6f 73 65 20 | 41 64 64 3e 3e 2e 20 20 | choose |Add>>.  |
|00006070| 54 6f 20 72 65 6d 6f 76 | 65 20 61 20 74 61 62 6c |To remov|e a tabl|
|00006080| 65 20 66 72 6f 6d 20 74 | 68 65 20 51 75 65 72 79 |e from t|he Query|
|00006090| 20 74 61 62 6c 65 73 20 | 6c 69 73 74 2c 20 64 6f | tables |list, do|
|000060a0| 75 62 6c 65 2d 63 6c 69 | 63 6b 20 69 74 20 6f 72 |uble-cli|ck it or|
|000060b0| 20 73 65 6c 65 63 74 20 | 69 74 20 77 69 74 68 20 | select |it with |
|000060c0| 74 68 65 20 6d 6f 75 73 | 65 20 6f 72 20 6b 65 79 |the mous|e or key|
|000060d0| 62 6f 61 72 64 20 61 6e | 64 20 63 68 6f 6f 73 65 |board an|d choose|
|000060e0| 20 3c 3c 52 65 6d 6f 76 | 65 2e 20 20 57 68 65 6e | <<Remov|e.  When|
|000060f0| 20 74 68 65 20 64 65 73 | 69 72 65 64 20 74 61 62 | the des|ired tab|
|00006100| 6c 65 73 20 61 72 65 20 | 69 6e 20 74 68 65 20 51 |les are |in the Q|
|00006110| 75 65 72 79 20 74 61 62 | 6c 65 73 20 6c 69 73 74 |uery tab|les list|
|00006120| 2c 20 63 68 6f 6f 73 65 | 20 4f 4b 2e 20 20 54 68 |, choose| OK.  Th|
|00006130| 65 20 63 68 6f 73 65 6e | 20 74 61 62 6c 65 73 20 |e chosen| tables |
|00006140| 61 72 65 20 64 69 73 70 | 6c 61 79 65 64 20 69 6e |are disp|layed in|
|00006150| 20 74 68 65 20 42 75 69 | 6c 64 20 51 75 65 72 79 | the Bui|ld Query|
|00006160| 20 64 69 61 6c 6f 67 2e | 0d 0a 0d 0a 09 53 65 6c | dialog.|.....Sel|
|00006170| 65 63 74 2e 2e 2e 20 62 | 75 74 74 6f 6e 20 2d 2d |ect... b|utton --|
|00006180| 20 43 68 6f 6f 73 65 20 | 63 6f 6c 75 6d 6e 73 20 | Choose |columns |
|00006190| 28 66 69 65 6c 64 73 29 | 20 66 72 6f 6d 20 74 68 |(fields)| from th|
|000061a0| 65 20 74 61 62 6c 65 73 | 20 74 6f 20 62 65 20 69 |e tables| to be i|
|000061b0| 6e 63 6c 75 64 65 64 20 | 69 6e 20 74 68 65 20 71 |ncluded |in the q|
|000061c0| 75 65 72 79 2e 0d 0a 43 | 68 6f 6f 73 65 20 74 68 |uery...C|hoose th|
|000061d0| 65 20 53 65 6c 65 63 74 | 2e 2e 2e 20 62 75 74 74 |e Select|... butt|
|000061e0| 6f 6e 20 74 6f 20 6f 70 | 65 6e 20 74 68 65 20 53 |on to op|en the S|
|000061f0| 65 6c 65 63 74 20 64 69 | 61 6c 6f 67 20 77 69 74 |elect di|alog wit|
|00006200| 68 20 61 20 6c 69 73 74 | 20 6f 66 20 74 68 65 20 |h a list| of the |
|00006210| 63 6f 6c 75 6d 6e 73 20 | 69 6e 20 74 68 65 20 74 |columns |in the t|
|00006220| 61 62 6c 65 73 20 73 65 | 6c 65 63 74 65 64 20 69 |ables se|lected i|
|00006230| 6e 20 74 68 65 20 46 72 | 6f 6d 20 64 69 61 6c 6f |n the Fr|om dialo|
|00006240| 67 20 61 6e 64 20 61 20 | 6c 69 73 74 20 6f 66 20 |g and a |list of |
|00006250| 63 6f 6c 75 6d 6e 73 20 | 66 72 6f 6d 20 74 68 65 |columns |from the|
|00006260| 73 65 20 74 61 62 6c 65 | 73 20 74 6f 20 62 65 20 |se table|s to be |
|00006270| 69 6e 63 6c 75 64 65 64 | 20 69 6e 20 74 68 65 20 |included| in the |
|00006280| 71 75 65 72 79 2e 20 54 | 6f 20 6d 6f 76 65 20 61 |query. T|o move a|
|00006290| 20 74 61 62 6c 65 20 66 | 72 6f 6d 20 74 68 65 20 | table f|rom the |
|000062a0| 44 61 74 61 62 61 73 65 | 20 74 61 62 6c 65 73 20 |Database| tables |
|000062b0| 6c 69 73 74 20 69 6e 74 | 6f 20 74 68 65 20 51 75 |list int|o the Qu|
|000062c0| 65 72 79 20 74 61 62 6c | 65 73 20 6c 69 73 74 2c |ery tabl|es list,|
|000062d0| 20 64 6f 75 62 6c 65 2d | 63 6c 69 63 6b 20 69 74 | double-|click it|
|000062e0| 20 6f 72 20 73 65 6c 65 | 63 74 20 69 74 20 77 69 | or sele|ct it wi|
|000062f0| 74 68 20 74 68 65 20 6d | 6f 75 73 65 20 6f 72 20 |th the m|ouse or |
|00006300| 6b 65 79 62 6f 61 72 64 | 20 61 6e 64 20 63 68 6f |keyboard| and cho|
|00006310| 6f 73 65 20 41 64 64 3e | 3e 2e 20 20 54 6f 20 72 |ose Add>|>.  To r|
|00006320| 65 6d 6f 76 65 20 61 20 | 74 61 62 6c 65 20 66 72 |emove a |table fr|
|00006330| 6f 6d 20 74 68 65 20 51 | 75 65 72 79 20 74 61 62 |om the Q|uery tab|
|00006340| 6c 65 73 20 6c 69 73 74 | 2c 20 64 6f 75 62 6c 65 |les list|, double|
|00006350| 2d 63 6c 69 63 6b 20 69 | 74 20 6f 72 20 73 65 6c |-click i|t or sel|
|00006360| 65 63 74 20 69 74 20 77 | 69 74 68 20 74 68 65 20 |ect it w|ith the |
|00006370| 6d 6f 75 73 65 20 6f 72 | 20 6b 65 79 62 6f 61 72 |mouse or| keyboar|
|00006380| 64 20 61 6e 64 20 63 68 | 6f 6f 73 65 20 3c 3c 52 |d and ch|oose <<R|
|00006390| 65 6d 6f 76 65 2e 20 20 | 57 68 65 6e 20 74 68 65 |emove.  |When the|
|000063a0| 20 64 65 73 69 72 65 64 | 20 74 61 62 6c 65 73 20 | desired| tables |
|000063b0| 61 72 65 20 69 6e 20 74 | 68 65 20 51 75 65 72 79 |are in t|he Query|
|000063c0| 20 74 61 62 6c 65 73 20 | 6c 69 73 74 2c 20 63 68 | tables |list, ch|
|000063d0| 6f 6f 73 65 20 4f 4b 2e | 20 20 54 68 65 20 0d 0a |oose OK.|  The ..|
|000063e0| 63 68 6f 73 65 6e 20 74 | 61 62 6c 65 73 20 61 72 |chosen t|ables ar|
|000063f0| 65 20 64 69 73 70 6c 61 | 79 65 64 20 69 6e 20 74 |e displa|yed in t|
+--------+-------------------------+-------------------------+--------+--------+
Only 25.0 KB of data is shown above.