/ PC Plus SuperCD (UK) 1995 September / Image.iso / paradox / newpal.pak / NEWPAL.MB

< prev

next >

MacOS 8.1

Win98

DOS

view JSON data

view as text

+--------+-------------------------+-------------------------+--------+--------+
|00000000| 00 01 00 ad 02 82 73 02 | 00 29 00 00 10 00 10 00 |......s.|.)......|
|00000010| 10 40 00 00 08 00 00 00 | 00 00 00 00 00 00 00 00 |.@......|........|
|00000020| 00 00 00 00 00 00 00 00 | 00 a1 02 00 00 00 00 00 |........|........|
|00000030| 00 00 00 00 00 00 00 00 | 02 f0 00 00 04 00 03 40 |........|.......@|
|00000040| 02 00 01 00 02 60 00 00 | 06 00 02 b0 00 00 05 00 |.....`..|........|
|00000050| 02 70 01 00 0a 00 02 d0 | 01 00 08 00 02 a0 00 00 |.p......|........|
|00000060| 19 00 02 00 01 00 03 00 | 02 10 01 00 08 00 02 70 |........|.......p|
|00000070| 00 00 07 00 02 10 00 00 | 02 00 02 50 01 00 0d 00 |........|...P....|
|00000080| 03 b0 02 00 02 00 02 a0 | 01 00 07 00 02 c0 01 00 |........|........|
|00000090| 08 00 02 e0 01 00 1c 00 | 02 60 02 00 0a 00 02 10 |........|.`......|
|000000a0| 02 00 17 00 01 d0 02 00 | 02 00 02 c0 00 00 36 00 |........|......6.|
|000000b0| 02 90 00 00 2d 00 03 40 | 01 00 01 00 03 60 01 00 |....-..@|.....`..|
|000000c0| 01 00 02 30 01 00 10 00 | 03 b0 01 00 01 00 02 70 |...0....|.......p|
|000000d0| 02 00 35 00 02 e0 00 00 | 0d 00 02 80 00 00 1f 00 |..5.....|........|
|000000e0| 02 50 00 00 26 00 01 90 | 02 00 02 00 02 90 01 00 |.P..&...|........|
|000000f0| 15 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000100| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000110| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000120| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000130| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000140| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000150| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000160| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000170| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000180| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000190| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000001a0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000001b0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000001c0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000001d0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000001e0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000001f0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000200| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000210| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000220| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000230| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000240| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000250| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000260| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000270| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000280| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000290| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000002a0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000002b0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000002c0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000002d0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000002e0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000002f0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000300| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000310| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000320| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000330| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000340| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000350| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000360| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000370| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000380| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000390| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000003a0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000003b0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000003c0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000003d0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000003e0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000003f0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000400| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000410| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000420| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000430| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000440| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000450| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000460| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000470| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000480| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000490| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000004a0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000004b0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000004c0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000004d0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000004e0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000004f0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000500| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000510| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000520| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000530| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000540| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000550| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000560| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000570| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000580| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000590| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000005a0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000005b0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000005c0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000005d0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000005e0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000005f0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000600| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000610| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000620| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000630| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000640| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000650| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000660| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000670| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000680| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000690| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000006a0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000006b0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000006c0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000006d0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000006e0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000006f0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000700| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000710| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000720| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000730| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000740| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000750| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000760| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000770| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000780| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000790| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000007a0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000007b0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000007c0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000007d0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000007e0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000007f0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000800| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000810| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000820| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000830| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000840| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000850| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000860| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000870| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000880| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000890| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000008a0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000008b0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000008c0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000008d0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000008e0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000008f0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000900| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000910| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000920| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000930| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000940| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000950| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000960| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000970| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000980| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000990| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000009a0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000009b0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000009c0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000009d0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000009e0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000009f0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000a00| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000a10| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000a20| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000a30| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000a40| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000a50| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000a60| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000a70| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000a80| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000a90| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000aa0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000ab0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000ac0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000ad0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000ae0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000af0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000b00| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000b10| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000b20| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000b30| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000b40| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000b50| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000b60| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000b70| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000b80| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000b90| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000ba0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000bb0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000bc0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000bd0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000be0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000bf0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000c00| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000c10| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000c20| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000c30| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000c40| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000c50| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000c60| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000c70| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000c80| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000c90| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000ca0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000cb0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000cc0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000cd0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000ce0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000cf0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000d00| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000d10| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000d20| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000d30| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000d40| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000d50| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000d60| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000d70| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000d80| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000d90| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000da0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000db0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000dc0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000dd0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000de0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000df0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000e00| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000e10| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000e20| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000e30| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000e40| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000e50| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000e60| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000e70| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000e80| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000e90| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000ea0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000eb0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000ec0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000ed0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000ee0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000ef0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000f00| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000f10| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000f20| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000f30| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000f40| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000f50| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000f60| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000f70| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000f80| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000f90| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000fa0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000fb0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000fc0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000fd0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000fe0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000ff0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001000| 03 01 00 4c 76 8e 69 35 | 2a 15 df 00 00 00 00 00 |...Lv.i5|*.......|
|00001010| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001020| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001030| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001040| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001050| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001060| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001070| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001080| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001090| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000010a0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000010b0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000010c0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000010d0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000010e0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000010f0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001100| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001110| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001120| 0d 00 00 02 00 29 00 00 | 01 00 0d 00 00 0d 00 23 |.....)..|.......#|
|00001130| 00 00 0e 75 31 6a 02 02 | 57 1e 41 02 03 a6 2b 86 |...u1j..|W.A...+.|
|00001140| 02 03 d1 2d 87 02 10 15 | 42 f1 01 10 00 00 00 00 |...-....|B.......|
|00001150| 07 00 00 00 21 03 00 00 | 0a 00 11 00 00 00 03 00 |....!...|........|
|00001160| 08 00 00 00 02 00 0c 00 | 00 00 04 00 10 00 00 00 |........|........|
|00001170| 06 00 6c 00 00 00 07 00 | 2c 00 00 00 54 68 65 20 |..l.....|,...The |
|00001180| 66 6f 6c 6c 6f 77 69 6e | 67 20 63 6f 64 65 20 63 |followin|g code c|
|00001190| 61 6c 6c 73 20 69 73 45 | 78 65 63 75 74 65 51 42 |alls isE|xecuteQB|
|000011a0| 45 46 69 6c 65 4c 6f 63 | 61 6c 20 74 6f 20 66 69 |EFileLoc|al to fi|
|000011b0| 6e 64 20 6f 75 74 20 77 | 68 65 72 65 20 61 20 51 |nd out w|here a Q|
|000011c0| 42 45 20 71 75 65 72 79 | 20 77 69 6c 6c 20 65 78 |BE query| will ex|
|000011d0| 65 63 75 74 65 2e 20 49 | 66 20 74 68 65 20 71 75 |ecute. I|f the qu|
|000011e0| 65 72 79 20 77 69 6c 6c | 20 65 78 65 63 75 74 65 |ery will| execute|
|000011f0| 20 6f 6e 20 74 68 65 20 | 73 65 72 76 65 72 2c 20 | on the |server, |
|00001200| 74 68 65 20 63 6f 64 65 | 20 61 73 6b 73 20 74 68 |the code| asks th|
|00001210| 65 20 75 73 65 72 20 77 | 68 65 74 68 65 72 20 6f |e user w|hether o|
|00001220| 72 20 6e 6f 74 20 74 6f | 20 63 6f 6e 74 69 6e 75 |r not to| continu|
|00001230| 65 2e 0d 0a 0d 0a 6d 65 | 74 68 6f 64 20 70 75 73 |e.....me|thod pus|
|00001240| 68 42 75 74 74 6f 6e 20 | 28 76 61 72 20 65 76 65 |hButton |(var eve|
|00001250| 6e 74 49 6e 66 6f 20 45 | 76 65 6e 74 29 0d 0a 20 |ntInfo E|vent).. |
|00001260| 20 20 76 61 72 0d 0a 20 | 20 20 20 20 20 71 62 65 |  var.. |     qbe|
|00001270| 46 69 6c 65 4e 61 6d 65 | 2c 0d 0a 20 20 20 20 20 |FileName|,..     |
|00001280| 20 64 6c 67 54 69 74 6c | 65 54 65 78 74 2c 20 0d | dlgTitl|eText, .|
|00001290| 0a 20 20 20 20 20 20 64 | 6c 67 42 6f 64 79 54 65 |.      d|lgBodyTe|
|000012a0| 78 74 2c 0d 0a 20 20 20 | 20 20 20 64 6f 51 42 45 |xt,..   |   doQBE|
|000012b0| 09 09 53 74 72 69 6e 67 | 0d 0a 20 20 20 65 6e 64 |..String|..   end|
|000012c0| 56 61 72 0d 0a 0d 0a 20 | 20 20 71 62 65 46 69 6c |Var.... |  qbeFil|
|000012d0| 65 4e 61 6d 65 20 20 3d | 20 22 3a 50 52 49 56 3a |eName  =| ":PRIV:|
|000012e0| 67 65 74 43 75 73 74 2e | 71 62 65 22 0d 0a 20 20 |getCust.|qbe"..  |
|000012f0| 20 64 6c 67 54 69 74 6c | 65 54 65 78 74 20 3d 20 | dlgTitl|eText = |
|00001300| 22 52 65 6d 6f 74 65 20 | 71 75 65 72 79 22 0d 0a |"Remote |query"..|
|00001310| 20 20 20 64 6c 67 42 6f | 64 79 54 65 78 74 20 20 |   dlgBo|dyText  |
|00001320| 3d 20 22 54 68 69 73 20 | 71 75 65 72 79 20 6d 61 |= "This |query ma|
|00001330| 79 20 74 61 6b 65 20 61 | 20 6c 6f 6e 67 20 74 69 |y take a| long ti|
|00001340| 6d 65 2e 20 5c 6e 22 20 | 2b 0d 0a 20 20 20 20 20 |me. \n" |+..     |
|00001350| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 22 44 6f |        |     "Do|
|00001360| 20 79 6f 75 20 77 61 6e | 74 20 74 6f 20 63 6f 6e | you wan|t to con|
|00001370| 74 69 6e 75 65 3f 22 0d | 0a 0d 0a 20 20 20 69 66 |tinue?".|...   if|
|00001380| 20 69 73 45 78 65 63 75 | 74 65 51 42 45 46 69 6c | isExecu|teQBEFil|
|00001390| 65 4c 6f 63 61 6c 28 71 | 62 65 46 69 6c 65 4e 61 |eLocal(q|beFileNa|
|000013a0| 6d 65 29 20 74 68 65 6e | 0d 0a 20 20 20 20 20 20 |me) then|..      |
|000013b0| 64 6f 51 42 45 20 3d 20 | 6d 73 67 51 75 65 73 74 |doQBE = |msgQuest|
|000013c0| 69 6f 6e 28 64 6c 67 54 | 69 74 6c 65 54 65 78 74 |ion(dlgT|itleText|
|000013d0| 2c 20 64 6c 67 42 6f 64 | 79 54 65 78 74 29 0d 0a |, dlgBod|yText)..|
|000013e0| 0d 0a 20 20 20 20 20 20 | 69 66 20 64 6f 51 42 45 |..      |if doQBE|
|000013f0| 20 3d 20 22 59 65 73 22 | 20 74 68 65 6e 0d 0a 20 | = "Yes"| then.. |
|00001400| 20 20 20 20 20 20 20 20 | 65 78 65 63 75 74 65 51 |        |executeQ|
|00001410| 42 45 46 69 6c 65 28 71 | 62 65 46 69 6c 65 4e 61 |BEFile(q|beFileNa|
|00001420| 6d 65 29 0d 0a 20 20 20 | 20 20 20 65 6c 73 65 0d |me)..   |   else.|
|00001430| 0a 20 20 20 20 20 20 20 | 20 20 6d 73 67 49 6e 66 |.       |  msgInf|
|00001440| 6f 28 64 6c 67 54 69 74 | 6c 65 54 65 78 74 2c 20 |o(dlgTit|leText, |
|00001450| 22 51 75 65 72 79 20 63 | 61 6e 63 65 6c 65 64 22 |"Query c|anceled"|
|00001460| 29 0d 0a 20 20 20 20 20 | 20 20 20 20 72 65 74 75 |)..     |    retu|
|00001470| 72 6e 0d 0a 20 20 20 20 | 20 20 65 6e 64 49 66 0d |rn..    |  endIf.|
|00001480| 0a 0d 0a 20 20 20 65 6e | 64 49 66 0d 0a 0d 0a 65 |...   en|dIf....e|
|00001490| 6e 64 4d 65 74 68 6f 64 | 0d 0a 20 20 00 02 00 01 |ndMethod|..  ....|
|000014a0| 00 d8 36 24 00 00 02 00 | 02 00 01 00 01 00 00 00 |..6$....|........|
|000014b0| 00 00 00 00 00 00 00 00 | 00 00 01 80 ba 00 00 00 |........|........|
|000014c0| 02 80 00 00 00 00 01 80 | 00 00 1e 03 00 00 02 80 |........|........|
|000014d0| 00 00 02 00 c8 00 00 00 | 00 00 90 01 00 00 00 00 |........|........|
|000014e0| 00 00 00 00 00 00 01 22 | 00 06 41 72 69 61 6c 00 |......."|..Arial.|
|000014f0| 67 1b 40 02 67 2f 05 00 | 05 00 c3 05 67 1b 06 14 |g.@.g/..|....g...|
|00001500| 54 24 19 00 14 00 c6 89 | 79 07 c8 00 00 00 00 00 |T$......|y.......|
|00001510| 90 01 00 00 00 00 00 00 | 00 00 00 00 01 31 00 04 |........|.....1..|
|00001520| 43 6f 75 72 69 65 72 20 | 4e 65 77 00 05 00 05 00 |Courier |New.....|
|00001530| c3 05 67 1b 06 14 54 24 | 19 00 14 00 c6 89 79 07 |..g...T$|......y.|
|00001540| 02 00 00 00 00 00 00 00 | 00 00 00 00 00 00 98 0f |........|........|
|00001550| bf 08 d0 02 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001560| 00 00 00 00 98 0f 8f 09 | d0 02 00 00 00 00 00 00 |........|........|
|00001570| 07 00 00 00 b0 00 00 00 | 0a 00 11 00 00 00 03 00 |........|........|
|00001580| 08 00 00 00 02 00 4e 00 | 00 00 04 00 08 00 00 00 |......N.|........|
|00001590| 06 00 6c 00 00 00 07 00 | 16 00 00 00 65 78 70 6f |..l.....|....expo|
|000015a0| 72 74 41 53 43 49 49 56 | 61 72 28 09 63 6f 6e 73 |rtASCIIV|ar(.cons|
|000015b0| 74 20 74 61 62 6c 65 4e | 61 6d 65 20 53 74 72 69 |t tableN|ame Stri|
|000015c0| 6e 67 2c 20 63 6f 6e 73 | 74 20 66 69 6c 65 4e 61 |ng, cons|t fileNa|
|000015d0| 6d 65 20 53 74 72 69 6e | 67 2c 0d 0a 09 09 63 6f |me Strin|g,....co|
|000015e0| 6e 73 74 20 73 65 70 61 | 72 61 74 6f 72 20 53 74 |nst sepa|rator St|
|000015f0| 72 69 6e 67 20 5b 2c 20 | 63 6f 6e 73 74 20 64 65 |ring [, |const de|
|00001600| 6c 69 6d 69 74 65 72 20 | 53 74 72 69 6e 67 2c 0d |limiter |String,.|
|00001610| 0a 09 09 63 6f 6e 73 74 | 20 61 6c 6c 46 69 65 6c |...const| allFiel|
|00001620| 64 73 44 65 6c 69 6d 69 | 74 65 64 20 53 74 72 69 |dsDelimi|ted Stri|
|00001630| 6e 67 2c 20 63 6f 6e 73 | 74 20 41 4e 53 49 20 4c |ng, cons|t ANSI L|
|00001640| 6f 67 69 63 61 6c 5d 20 | 29 0d 0a 00 02 00 01 00 |ogical] |).......|
|00001650| d8 36 24 00 00 02 00 02 | 00 01 00 01 00 00 00 00 |.6$.....|........|
|00001660| 00 00 00 00 00 00 00 00 | 00 01 80 16 00 00 00 02 |........|........|
|00001670| 80 1f 00 00 00 01 80 2e | 00 00 00 02 80 36 00 00 |........|.....6..|
|00001680| 00 01 80 48 00 00 00 02 | 80 51 00 00 00 01 80 62 |...H....|.Q.....b|
|00001690| 00 00 00 02 80 6b 00 00 | 00 01 80 7d 00 00 00 02 |.....k..|...}....|
|000016a0| 80 8f 00 00 00 01 80 9e | 00 00 00 02 80 a2 00 00 |........|........|
|000016b0| 00 01 80 00 00 00 00 01 | 80 00 00 02 00 c8 00 00 |........|........|
|000016c0| 00 00 00 90 01 00 00 00 | 00 00 00 00 00 00 00 01 |........|........|
|000016d0| 22 00 06 41 72 69 61 6c | 00 67 1b 40 02 67 2f 05 |"..Arial|.g.@.g/.|
|000016e0| 00 05 00 c3 05 67 1b 06 | 14 54 24 19 00 14 00 c6 |.....g..|.T$.....|
|000016f0| 89 79 07 c8 00 00 00 00 | 00 90 01 00 00 00 00 00 |.y......|........|
|00001700| 00 00 00 00 00 04 22 00 | 06 41 72 69 61 6c 00 7f |......".|.Arial..|
|00001710| 08 40 02 6f 1a 2f 00 05 | 00 c3 05 7f 08 66 1d 58 |.@.o./..|.....f.X|
|00001720| 2a eb 00 e6 00 c6 89 79 | 07 01 00 00 00 00 00 00 |*......y|........|
|00001730| 00 00 00 00 00 00 00 98 | 0f bf 08 d0 02 00 00 00 |........|........|
|00001740| 00 00 00 00 90 01 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001750| 07 00 00 00 21 02 00 00 | 0a 00 11 00 00 00 03 00 |....!...|........|
|00001760| 08 00 00 00 02 00 0c 00 | 00 00 04 00 08 00 00 00 |........|........|
|00001770| 06 00 6c 00 00 00 07 00 | 16 00 00 00 54 68 69 73 |..l.....|....This|
|00001780| 20 65 78 61 6d 70 6c 65 | 20 75 73 65 73 20 66 6f | example| uses fo|
|00001790| 72 63 65 52 65 66 72 65 | 73 68 20 69 6e 20 63 6f |rceRefre|sh in co|
|000017a0| 64 65 20 61 74 74 61 63 | 68 65 64 20 74 6f 20 61 |de attac|hed to a|
|000017b0| 20 62 75 74 74 6f 6e 27 | 73 20 62 75 69 6c 74 2d | button'|s built-|
|000017c0| 69 6e 20 70 75 73 68 42 | 75 74 74 6f 6e 20 6d 65 |in pushB|utton me|
|000017d0| 74 68 6f 64 20 74 6f 20 | 6c 65 74 20 74 68 65 20 |thod to |let the |
|000017e0| 75 73 65 72 20 63 6f 6e | 74 72 6f 6c 20 77 68 65 |user con|trol whe|
|000017f0| 6e 20 74 68 65 20 64 61 | 74 61 20 69 6e 20 74 68 |n the da|ta in th|
|00001800| 65 20 55 49 4f 62 6a 65 | 63 74 20 6e 61 6d 65 64 |e UIObje|ct named|
|00001810| 20 50 61 72 74 73 20 69 | 73 20 72 65 66 72 65 73 | Parts i|s refres|
|00001820| 68 65 64 2e 20 49 66 2c | 20 66 6f 72 20 65 78 61 |hed. If,| for exa|
|00001830| 6d 70 6c 65 2c 20 46 69 | 6c 65 7c 53 79 73 74 65 |mple, Fi|le|Syste|
|00001840| 6d 20 53 65 74 74 69 6e | 67 73 7c 41 75 74 6f 20 |m Settin|gs|Auto |
|00001850| 52 65 66 72 65 73 68 20 | 69 73 20 73 65 74 20 74 |Refresh |is set t|
|00001860| 6f 20 61 20 6c 61 72 67 | 65 20 76 61 6c 75 65 20 |o a larg|e value |
|00001870| 28 73 75 63 68 20 61 73 | 20 33 2c 36 30 30 20 73 |(such as| 3,600 s|
|00001880| 65 63 6f 6e 64 73 29 20 | 69 6e 20 74 68 65 20 4e |econds) |in the N|
|00001890| 65 74 77 6f 72 6b 20 52 | 65 66 72 65 73 68 20 52 |etwork R|efresh R|
|000018a0| 61 74 65 20 64 69 61 6c | 6f 67 20 62 6f 78 2c 20 |ate dial|og box, |
|000018b0| 74 68 69 73 20 62 75 74 | 74 6f 6e 20 6c 65 74 73 |this but|ton lets|
|000018c0| 20 79 6f 75 20 72 65 66 | 72 65 73 68 20 74 68 65 | you ref|resh the|
|000018d0| 20 50 61 72 74 73 20 6f | 62 6a 65 63 74 20 6d 6f | Parts o|bject mo|
|000018e0| 72 65 20 66 72 65 71 75 | 65 6e 74 6c 79 20 74 68 |re frequ|ently th|
|000018f0| 61 6e 20 6f 74 68 65 72 | 20 6f 62 6a 65 63 74 73 |an other| objects|
|00001900| 20 6f 6e 20 74 68 65 20 | 66 6f 72 6d 2d 2d 65 6c | on the |form--el|
|00001910| 69 6d 69 6e 61 74 69 6e | 67 20 74 68 65 20 6e 65 |iminatin|g the ne|
|00001920| 65 64 20 74 6f 20 61 64 | 6a 75 73 74 20 74 68 65 |ed to ad|just the|
|00001930| 20 6e 65 74 77 6f 72 6b | 20 72 65 66 72 65 73 68 | network| refresh|
|00001940| 20 72 61 74 65 2e 0d 0a | 0d 0a 20 20 6d 65 74 68 | rate...|..  meth|
|00001950| 6f 64 20 70 75 73 68 42 | 75 74 74 6f 6e 28 76 61 |od pushB|utton(va|
|00001960| 72 20 65 76 65 6e 74 49 | 6e 66 6f 20 45 76 65 6e |r eventI|nfo Even|
|00001970| 74 29 0d 0a 20 20 20 20 | 20 50 61 72 74 73 2e 66 |t)..    | Parts.f|
|00001980| 6f 72 63 65 52 65 66 72 | 65 73 68 28 29 0d 0a 20 |orceRefr|esh().. |
|00001990| 20 65 6e 64 4d 65 74 68 | 6f 64 0d 0a 00 02 00 01 | endMeth|od......|
|000019a0| 00 d8 13 29 00 00 02 00 | 02 00 01 00 01 00 00 00 |...)....|........|
|000019b0| 00 00 00 00 00 00 00 00 | 00 00 01 80 ce 01 00 00 |........|........|
|000019c0| 02 80 00 00 00 00 01 80 | 00 00 02 00 c8 00 00 00 |........|........|
|000019d0| 00 00 90 01 00 00 00 00 | 00 00 00 00 00 00 01 22 |........|......."|
|000019e0| 00 06 41 72 69 61 6c 00 | 97 27 40 02 27 24 2f 00 |..Arial.|.'@.'$/.|
|000019f0| 05 00 c3 05 97 27 56 25 | 84 26 eb 00 e6 00 f6 89 |.....'V%|.&......|
|00001a00| 79 07 c8 00 00 00 00 00 | 90 01 00 00 00 00 00 00 |y.......|........|
|00001a10| 00 00 00 00 01 31 00 04 | 43 6f 75 72 69 65 72 20 |.....1..|Courier |
|00001a20| 4e 65 77 00 05 00 05 00 | c3 05 67 1b 06 14 54 24 |New.....|..g...T$|
|00001a30| 19 00 14 00 c6 89 79 07 | 01 00 00 00 00 00 00 00 |......y.|........|
|00001a40| 00 00 00 00 00 00 98 0f | bf 08 d0 02 00 00 00 00 |........|........|
|00001a50| 00 00 60 07 01 00 00 00 | 00 00 00 00 00 00 00 00 |..`.....|........|
|00001a60| 07 00 00 00 44 01 00 00 | 0a 00 11 00 00 00 03 00 |....D...|........|
|00001a70| 08 00 00 00 02 00 8a 00 | 00 00 04 00 08 00 00 00 |........|........|
|00001a80| 06 00 6c 00 00 00 07 00 | 16 00 00 00 31 2e 20 65 |..l.....|....1. e|
|00001a90| 78 65 63 75 74 65 53 51 | 4c 46 69 6c 65 28 63 6f |xecuteSQ|LFile(co|
|00001aa0| 6e 73 74 20 64 62 20 44 | 61 74 61 62 61 73 65 2c |nst db D|atabase,|
|00001ab0| 20 63 6f 6e 73 74 20 66 | 69 6c 65 4e 61 6d 65 20 | const f|ileName |
|00001ac0| 53 51 4c 29 20 4c 6f 67 | 69 63 61 6c 0d 0a 20 20 |SQL) Log|ical..  |
|00001ad0| 0d 0a 32 2e 20 65 78 65 | 63 75 74 65 53 51 4c 46 |..2. exe|cuteSQLF|
|00001ae0| 69 6c 65 28 63 6f 6e 73 | 74 20 64 62 20 44 61 74 |ile(cons|t db Dat|
|00001af0| 61 62 61 73 65 2c 20 63 | 6f 6e 73 74 20 66 69 6c |abase, c|onst fil|
|00001b00| 65 4e 61 6d 65 20 53 51 | 4c 2c 20 61 6e 73 54 62 |eName SQ|L, ansTb|
|00001b10| 6c 20 53 74 72 69 6e 67 | 29 20 4c 6f 67 69 63 61 |l String|) Logica|
|00001b20| 6c 0d 0a 20 20 0d 0a 33 | 2e 20 65 78 65 63 75 74 |l..  ..3|. execut|
|00001b30| 65 53 51 4c 46 69 6c 65 | 28 63 6f 6e 73 74 20 64 |eSQLFile|(const d|
|00001b40| 62 20 44 61 74 61 62 61 | 73 65 2c 20 63 6f 6e 73 |b Databa|se, cons|
|00001b50| 74 20 66 69 6c 65 4e 61 | 6d 65 20 53 51 4c 2c 20 |t fileNa|me SQL, |
|00001b60| 61 6e 73 54 62 6c 20 54 | 61 62 6c 65 29 20 4c 6f |ansTbl T|able) Lo|
|00001b70| 67 69 63 61 6c 0d 0a 20 | 20 0d 0a 34 2e 20 65 78 |gical.. | ..4. ex|
|00001b80| 65 63 75 74 65 53 51 4c | 46 69 6c 65 28 63 6f 6e |ecuteSQL|File(con|
|00001b90| 73 74 20 64 62 20 44 61 | 74 61 62 61 73 65 2c 20 |st db Da|tabase, |
|00001ba0| 63 6f 6e 73 74 20 66 69 | 6c 65 4e 61 6d 65 20 53 |const fi|leName S|
|00001bb0| 51 4c 2c 20 61 6e 73 54 | 62 6c 20 54 43 75 72 73 |QL, ansT|bl TCurs|
|00001bc0| 6f 72 29 20 4c 6f 67 69 | 63 61 6c 0d 0a 20 20 00 |or) Logi|cal..  .|
|00001bd0| 02 00 01 00 d8 36 24 00 | 00 02 00 02 00 01 00 01 |.....6$.|........|
|00001be0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 01 80 18 |........|........|
|00001bf0| 00 00 00 02 80 1a 00 00 | 00 01 80 2b 00 00 00 02 |........|...+....|
|00001c00| 80 33 00 00 00 01 80 5e | 00 00 00 02 80 60 00 00 |.3.....^|.....`..|
|00001c10| 00 01 80 71 00 00 00 02 | 80 79 00 00 00 01 80 7f |...q....|.y......|
|00001c20| 00 00 00 02 80 85 00 00 | 00 01 80 b3 00 00 00 02 |........|........|
|00001c30| 80 b5 00 00 00 01 80 c6 | 00 00 00 02 80 ce 00 00 |........|........|
|00001c40| 00 01 80 d4 00 00 00 02 | 80 da 00 00 00 01 80 07 |........|........|
|00001c50| 01 00 00 02 80 09 01 00 | 00 01 80 1a 01 00 00 02 |........|........|
|00001c60| 80 22 01 00 00 01 80 28 | 01 00 00 02 80 2e 01 00 |.".....(|........|
|00001c70| 00 01 80 00 00 00 00 01 | 80 00 00 02 00 c8 00 00 |........|........|
|00001c80| 00 00 00 90 01 00 00 00 | 00 00 00 00 00 00 00 01 |........|........|
|00001c90| 22 00 06 41 72 69 61 6c | 00 c7 37 40 02 1f 35 1b |"..Arial|..7@..5.|
|00001ca0| 00 05 00 c3 05 c7 37 ee | 37 1c 37 87 00 82 00 f6 |......7.|7.7.....|
|00001cb0| 89 79 07 c8 00 00 00 00 | 00 90 01 00 00 00 00 00 |.y......|........|
|00001cc0| 00 00 00 00 00 04 22 00 | 06 41 72 69 61 6c 00 7f |......".|.Arial..|
|00001cd0| 08 40 02 6f 1a 2f 00 05 | 00 c3 05 7f 08 66 1d 58 |.@.o./..|.....f.X|
|00001ce0| 2a eb 00 e6 00 c6 89 79 | 07 01 00 00 00 00 00 00 |*......y|........|
|00001cf0| 00 00 00 00 00 00 00 98 | 0f 8f 09 d0 02 00 00 00 |........|........|
|00001d00| 00 00 00 00 c6 89 79 07 | 01 00 00 00 00 00 00 00 |......y.|........|
|00001d10| 07 00 00 00 71 01 00 00 | 0a 00 11 00 00 00 03 00 |....q...|........|
|00001d20| 08 00 00 00 02 00 8a 00 | 00 00 04 00 08 00 00 00 |........|........|
|00001d30| 06 00 6c 00 00 00 07 00 | 16 00 00 00 31 2e 20 65 |..l.....|....1. e|
|00001d40| 78 65 63 75 74 65 53 51 | 4c 53 74 72 69 6e 67 28 |xecuteSQ|LString(|
|00001d50| 63 6f 6e 73 74 20 64 62 | 20 44 61 74 61 62 61 73 |const db| Databas|
|00001d60| 65 2c 20 63 6f 6e 73 74 | 20 73 71 6c 53 74 72 69 |e, const| sqlStri|
|00001d70| 6e 67 20 53 51 4c 29 20 | 4c 6f 67 69 63 61 6c 0d |ng SQL) |Logical.|
|00001d80| 0a 20 20 0d 0a 32 2e 20 | 65 78 65 63 75 74 65 53 |.  ..2. |executeS|
|00001d90| 51 4c 53 74 72 69 6e 67 | 28 63 6f 6e 73 74 20 64 |QLString|(const d|
|00001da0| 62 20 44 61 74 61 62 61 | 73 65 2c 20 63 6f 6e 73 |b Databa|se, cons|
|00001db0| 74 20 73 71 6c 53 74 72 | 69 6e 67 20 53 51 4c 2c |t sqlStr|ing SQL,|
|00001dc0| 0d 0a 09 09 20 20 20 20 | 20 20 20 20 61 6e 73 54 |....    |    ansT|
|00001dd0| 62 6c 20 53 74 72 69 6e | 67 29 20 4c 6f 67 69 63 |bl Strin|g) Logic|
|00001de0| 61 6c 0d 0a 20 20 0d 0a | 33 2e 20 65 78 65 63 75 |al..  ..|3. execu|
|00001df0| 74 65 53 51 4c 53 74 72 | 69 6e 67 28 63 6f 6e 73 |teSQLStr|ing(cons|
|00001e00| 74 20 64 62 20 44 61 74 | 61 62 61 73 65 2c 20 63 |t db Dat|abase, c|
|00001e10| 6f 6e 73 74 20 73 71 6c | 53 74 72 69 6e 67 20 53 |onst sql|String S|
|00001e20| 51 4c 2c 0d 0a 09 09 20 | 20 20 20 20 20 20 20 61 |QL,.... |       a|
|00001e30| 6e 73 54 62 6c 20 54 61 | 62 6c 65 29 20 4c 6f 67 |nsTbl Ta|ble) Log|
|00001e40| 69 63 61 6c 0d 0a 20 20 | 0d 0a 34 2e 20 65 78 65 |ical..  |..4. exe|
|00001e50| 63 75 74 65 53 51 4c 53 | 74 72 69 6e 67 28 63 6f |cuteSQLS|tring(co|
|00001e60| 6e 73 74 20 64 62 20 44 | 61 74 61 62 61 73 65 2c |nst db D|atabase,|
|00001e70| 20 63 6f 6e 73 74 20 73 | 71 6c 53 74 72 69 6e 67 | const s|qlString|
|00001e80| 20 53 51 4c 2c 0d 0a 09 | 09 20 20 20 20 20 20 20 | SQL,...|.       |
|00001e90| 20 61 6e 73 54 62 6c 20 | 54 43 75 72 73 6f 72 29 | ansTbl |TCursor)|
|00001ea0| 20 4c 6f 67 69 63 61 6c | 0d 0a 20 20 00 02 00 01 | Logical|..  ....|
|00001eb0| 00 d8 36 24 00 00 02 00 | 02 00 01 00 01 00 00 00 |..6$....|........|
|00001ec0| 00 00 00 00 00 00 00 00 | 00 00 01 80 1a 00 00 00 |........|........|
|00001ed0| 02 80 1c 00 00 00 01 80 | 2d 00 00 00 02 80 36 00 |........|-.....6.|
|00001ee0| 00 00 01 80 63 00 00 00 | 02 80 65 00 00 00 01 80 |....c...|..e.....|
|00001ef0| 76 00 00 00 02 80 7f 00 | 00 00 01 80 90 00 00 00 |v.......|........|
|00001f00| 02 80 96 00 00 00 01 80 | c6 00 00 00 02 80 c8 00 |........|........|
|00001f10| 00 00 01 80 d9 00 00 00 | 02 80 e2 00 00 00 01 80 |........|........|
|00001f20| f3 00 00 00 02 80 f9 00 | 00 00 01 80 28 01 00 00 |........|....(...|
|00001f30| 02 80 2a 01 00 00 01 80 | 3b 01 00 00 02 80 44 01 |..*.....|;.....D.|
|00001f40| 00 00 01 80 55 01 00 00 | 02 80 5b 01 00 00 01 80 |....U...|..[.....|
|00001f50| 00 00 00 00 01 80 00 00 | 02 00 c8 00 00 00 00 00 |........|........|
|00001f60| 90 01 00 00 00 00 00 00 | 00 00 00 00 01 22 00 06 |........|....."..|
|00001f70| 41 72 69 61 6c 00 c7 37 | 40 02 1f 35 1b 00 05 00 |Arial..7|@..5....|
|00001f80| c3 05 c7 37 ee 37 1c 37 | 87 00 82 00 f6 89 79 07 |...7.7.7|......y.|
|00001f90| c8 00 00 00 00 00 90 01 | 00 00 00 00 00 00 00 00 |........|........|
|00001fa0| 00 00 04 22 00 06 41 72 | 69 61 6c 00 7f 08 40 02 |..."..Ar|ial...@.|
|00001fb0| 6f 1a 2f 00 05 00 c3 05 | 7f 08 66 1d 58 2a eb 00 |o./.....|..f.X*..|
|00001fc0| e6 00 c6 89 79 07 01 00 | 00 00 00 00 00 00 00 00 |....y...|........|
|00001fd0| 00 00 00 00 98 0f 8f 09 | d0 02 00 00 00 00 00 00 |........|........|
|00001fe0| 00 00 98 0f 0f 0a d0 02 | 00 00 00 00 00 00 00 00 |........|........|
|00001ff0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002000| 02 01 00 a8 09 00 00 93 | 02 07 00 00 00 b5 08 00 |........|........|
|00002010| 00 0a 00 11 00 00 00 03 | 00 08 00 00 00 02 00 1e |........|........|
|00002020| 00 00 00 04 00 08 00 00 | 00 06 00 6c 00 00 00 07 |........|...l....|
|00002030| 00 16 00 00 00 64 6d 47 | 65 74 50 72 6f 70 65 72 |.....dmG|etProper|
|00002040| 74 79 20 72 65 74 75 72 | 6e 73 20 74 68 65 20 76 |ty retur|ns the v|
|00002050| 61 6c 75 65 20 6f 66 20 | 61 20 70 72 6f 70 65 72 |alue of |a proper|
|00002060| 74 79 2c 20 73 70 65 63 | 69 66 69 65 64 20 62 79 |ty, spec|ified by|
|00002070| 20 70 72 6f 70 65 72 74 | 79 4e 61 6d 65 2c 20 6f | propert|yName, o|
|00002080| 66 20 74 68 65 20 74 61 | 62 6c 65 20 66 6f 75 6e |f the ta|ble foun|
|00002090| 64 20 69 6e 20 74 68 65 | 20 66 6f 72 6d 27 73 20 |d in the| form's |
|000020a0| 64 61 74 61 20 6d 6f 64 | 65 6c 2e 20 70 72 6f 70 |data mod|el. prop|
|000020b0| 65 72 74 79 4e 61 6d 65 | 20 69 73 20 6f 6e 65 20 |ertyName| is one |
|000020c0| 6f 66 20 74 68 65 20 66 | 6f 6c 6c 6f 77 69 6e 67 |of the f|ollowing|
|000020d0| 20 70 72 6f 70 65 72 74 | 69 65 73 3a 0d 0a 0d 0a | propert|ies:....|
|000020e0| 20 20 20 22 52 65 61 64 | 4f 6e 6c 79 22 0d 0a 52 |   "Read|Only"..R|
|000020f0| 65 74 75 72 6e 73 20 54 | 72 75 65 20 69 66 20 52 |eturns T|rue if R|
|00002100| 45 41 44 4f 4e 4c 59 20 | 69 73 20 73 65 74 20 74 |EADONLY |is set t|
|00002110| 6f 20 54 72 75 65 20 66 | 6f 72 20 74 68 65 20 74 |o True f|or the t|
|00002120| 61 62 6c 65 2e 20 4f 74 | 68 65 72 77 69 73 65 2c |able. Ot|herwise,|
|00002130| 20 72 65 74 75 72 6e 73 | 20 46 61 6c 73 65 2e 0d | returns| False..|
|00002140| 0a 0d 0a 20 20 20 22 53 | 74 72 69 63 74 54 72 61 |...   "S|trictTra|
|00002150| 6e 73 6c 61 74 69 6f 6e | 22 0d 0a 52 65 74 75 72 |nslation|"..Retur|
|00002160| 6e 73 20 54 72 75 65 20 | 69 66 20 53 54 52 49 43 |ns True |if STRIC|
|00002170| 54 20 54 52 41 4e 53 4c | 41 54 49 4f 4e 20 69 73 |T TRANSL|ATION is|
|00002180| 20 73 65 74 20 74 6f 20 | 54 72 75 65 20 66 6f 72 | set to |True for|
|00002190| 20 74 68 65 20 74 61 62 | 6c 65 2e 20 20 4f 74 68 | the tab|le.  Oth|
|000021a0| 65 72 77 69 73 65 2c 20 | 72 65 74 75 72 6e 73 20 |erwise, |returns |
|000021b0| 46 61 6c 73 65 2e 0d 0a | 0d 0a 20 20 20 22 41 75 |False...|..   "Au|
|000021c0| 74 6f 41 70 70 65 6e 64 | 22 0d 0a 52 65 74 75 72 |toAppend|"..Retur|
|000021d0| 6e 73 20 54 72 75 65 20 | 69 66 20 41 55 54 4f 20 |ns True |if AUTO |
|000021e0| 41 50 50 45 4e 44 20 69 | 73 20 73 65 74 20 74 6f |APPEND i|s set to|
|000021f0| 20 54 72 75 65 20 66 6f | 72 20 74 68 65 20 74 61 | True fo|r the ta|
|00002200| 62 6c 65 2e 20 20 4f 74 | 68 65 72 77 69 73 65 2c |ble.  Ot|herwise,|
|00002210| 20 72 65 74 75 72 6e 73 | 20 46 61 6c 73 65 2e 0d | returns| False..|
|00002220| 0a 0d 0a 20 20 20 22 50 | 61 72 65 6e 74 22 0d 0a |...   "P|arent"..|
|00002230| 52 65 74 75 72 6e 73 20 | 74 68 65 20 74 61 62 6c |Returns |the tabl|
|00002240| 65 20 6e 61 6d 65 20 28 | 61 73 20 61 20 73 74 72 |e name (|as a str|
|00002250| 69 6e 67 29 20 6f 66 20 | 74 68 69 73 20 74 61 62 |ing) of |this tab|
|00002260| 6c 65 27 73 20 6d 61 73 | 74 65 72 20 69 6e 20 74 |le's mas|ter in t|
|00002270| 68 65 20 64 61 74 61 20 | 6d 6f 64 65 6c 2e 20 46 |he data |model. F|
|00002280| 6f 72 20 65 78 61 6d 70 | 6c 65 2c 20 69 6e 20 61 |or examp|le, in a|
|00002290| 20 43 55 53 54 4f 4d 45 | 52 2d 3e 3e 42 4f 4f 4b | CUSTOME|R->>BOOK|
|000022a0| 4f 52 44 20 66 6f 72 6d | 2c 20 64 6d 47 65 74 50 |ORD form|, dmGetP|
|000022b0| 72 6f 70 65 72 74 79 28 | 22 42 4f 4f 4b 4f 52 44 |roperty(|"BOOKORD|
|000022c0| 22 2c 22 50 41 52 45 4e | 54 22 29 20 3d 20 22 43 |","PAREN|T") = "C|
|000022d0| 55 53 54 4f 4d 45 52 2e | 44 42 22 2e 20 49 66 20 |USTOMER.|DB". If |
|000022e0| 74 68 65 20 74 61 62 6c | 65 20 68 61 73 20 6e 6f |the tabl|e has no|
|000022f0| 20 6d 61 73 74 65 72 2c | 20 61 6e 20 65 6d 70 74 | master,| an empt|
|00002300| 79 20 73 74 72 69 6e 67 | 20 69 73 20 72 65 74 75 |y string| is retu|
|00002310| 72 6e 65 64 2e 0d 0a 0d | 0a 20 20 20 22 49 6e 64 |rned....|.   "Ind|
|00002320| 65 78 22 0d 0a 52 65 74 | 75 72 6e 73 20 74 68 65 |ex"..Ret|urns the|
|00002330| 20 6e 61 6d 65 20 6f 66 | 20 74 68 65 20 69 6e 64 | name of| the ind|
|00002340| 65 78 20 28 61 73 20 61 | 20 73 74 72 69 6e 67 29 |ex (as a| string)|
|00002350| 20 74 68 61 74 20 69 73 | 20 63 75 72 72 65 6e 74 | that is| current|
|00002360| 6c 79 20 75 73 65 64 20 | 74 6f 20 76 69 65 77 20 |ly used |to view |
|00002370| 74 68 65 20 74 61 62 6c | 65 2e 20 46 6f 72 20 61 |the tabl|e. For a|
|00002380| 20 63 68 69 6c 64 20 74 | 61 62 6c 65 2c 20 69 74 | child t|able, it|
|00002390| 20 72 65 74 75 72 6e 73 | 20 74 68 65 20 6e 61 6d | returns| the nam|
|000023a0| 65 20 6f 66 20 74 68 65 | 20 69 6e 64 65 78 20 63 |e of the| index c|
|000023b0| 68 6f 73 65 6e 20 69 6e | 20 74 68 65 20 6c 69 6e |hosen in| the lin|
|000023c0| 6b 20 64 69 61 67 72 61 | 6d 2e 20 46 6f 72 20 61 |k diagra|m. For a|
|000023d0| 20 6d 61 73 74 65 72 20 | 74 61 62 6c 65 20 6f 72 | master |table or|
|000023e0| 20 75 6e 6c 69 6e 6b 65 | 64 20 74 61 62 6c 65 2c | unlinke|d table,|
|000023f0| 20 69 74 20 72 65 74 75 | 72 6e 73 20 74 68 65 20 | it retu|rns the |
|00002400| 73 65 74 74 69 6e 67 20 | 6f 66 20 4f 52 44 45 52 |setting |of ORDER|
|00002410| 2f 52 41 4e 47 45 2e 20 | 49 74 20 72 65 74 75 72 |/RANGE. |It retur|
|00002420| 6e 73 20 61 6e 20 65 6d | 70 74 79 20 73 74 72 69 |ns an em|pty stri|
|00002430| 6e 67 20 77 68 65 6e 20 | 74 68 65 20 70 72 69 6d |ng when |the prim|
|00002440| 61 72 79 20 6b 65 79 20 | 69 73 20 75 73 65 64 2e |ary key |is used.|
|00002450| 0d 0a 0d 0a 20 20 20 22 | 54 61 67 6e 61 6d 65 22 |....   "|Tagname"|
|00002460| 0d 0a 52 65 74 75 72 6e | 73 20 74 68 65 20 74 61 |..Return|s the ta|
|00002470| 67 20 6e 61 6d 65 20 28 | 61 73 20 61 20 73 74 72 |g name (|as a str|
|00002480| 69 6e 67 29 20 66 6f 72 | 20 74 68 65 20 63 75 72 |ing) for| the cur|
|00002490| 72 65 6e 74 20 64 42 41 | 53 45 20 69 6e 64 65 78 |rent dBA|SE index|
|000024a0| 20 28 69 66 20 61 6e 79 | 29 2e 20 4f 74 68 65 72 | (if any|). Other|
|000024b0| 77 69 73 65 2c 20 69 74 | 20 72 65 74 75 72 6e 73 |wise, it| returns|
|000024c0| 20 61 6e 20 65 6d 70 74 | 79 20 73 74 72 69 6e 67 | an empt|y string|
|000024d0| 2e 0d 0a 0d 0a 20 20 20 | 22 4c 69 6e 6b 54 79 70 |.....   |"LinkTyp|
|000024e0| 65 22 0d 0a 52 65 74 75 | 72 6e 73 20 61 20 73 74 |e"..Retu|rns a st|
|000024f0| 72 69 6e 67 20 64 65 73 | 63 72 69 62 69 6e 67 20 |ring des|cribing |
|00002500| 74 68 65 20 77 61 79 20 | 74 68 65 20 74 61 62 6c |the way |the tabl|
|00002510| 65 20 72 65 6c 61 74 65 | 73 20 74 6f 20 69 74 73 |e relate|s to its|
|00002520| 20 6d 61 73 74 65 72 3a | 20 22 4e 6f 6e 65 22 2c | master:| "None",|
|00002530| 20 22 4f 6e 65 2d 74 6f | 2d 6f 6e 65 22 2c 20 6f | "One-to|-one", o|
|00002540| 72 20 22 4f 6e 65 2d 74 | 6f 2d 6d 61 6e 79 22 2e |r "One-t|o-many".|
|00002550| 0d 0a 0d 0a 20 20 20 22 | 54 6f 75 63 68 65 64 22 |....   "|Touched"|
|00002560| 0d 0a 52 65 74 75 72 6e | 73 20 54 72 75 65 20 77 |..Return|s True w|
|00002570| 68 65 6e 20 74 68 65 20 | 75 73 65 72 20 68 61 73 |hen the |user has|
|00002580| 20 6d 61 64 65 20 63 68 | 61 6e 67 65 73 20 6e 6f | made ch|anges no|
|00002590| 74 20 79 65 74 20 63 6f | 6d 6d 69 74 74 65 64 2e |t yet co|mmitted.|
|000025a0| 0d 0a 0d 0a 20 20 20 22 | 4c 6f 63 6b 65 64 22 0d |....   "|Locked".|
|000025b0| 0a 52 65 74 75 72 6e 73 | 20 54 72 75 65 20 77 68 |.Returns| True wh|
|000025c0| 65 6e 20 74 68 65 20 74 | 61 62 6c 65 20 62 6f 75 |en the t|able bou|
|000025d0| 6e 64 20 74 6f 20 61 20 | 64 65 73 69 67 6e 20 6f |nd to a |design o|
|000025e0| 62 6a 65 63 74 20 69 73 | 20 6c 6f 63 6b 65 64 2e |bject is| locked.|
|000025f0| 20 4f 74 68 65 72 77 69 | 73 65 2c 20 72 65 74 75 | Otherwi|se, retu|
|00002600| 72 6e 73 20 46 61 6c 73 | 65 2e 0d 0a 0d 0a 20 20 |rns Fals|e.....  |
|00002610| 20 22 49 6e 73 65 72 74 | 69 6e 67 22 0d 0a 52 65 | "Insert|ing"..Re|
|00002620| 74 75 72 6e 73 20 54 72 | 75 65 20 77 68 65 6e 20 |turns Tr|ue when |
|00002630| 61 20 72 65 63 6f 72 64 | 20 69 73 20 62 65 69 6e |a record| is bein|
|00002640| 67 20 69 6e 73 65 72 74 | 65 64 20 61 6e 79 77 68 |g insert|ed anywh|
|00002650| 65 72 65 20 69 6e 20 61 | 20 66 6f 72 6d 2e 20 4f |ere in a| form. O|
|00002660| 74 68 65 72 77 69 73 65 | 2c 20 72 65 74 75 72 6e |therwise|, return|
|00002670| 73 20 46 61 6c 73 65 2e | 0d 0a 0d 0a 20 20 20 22 |s False.|....   "|
|00002680| 45 64 69 74 69 6e 67 22 | 0d 0a 52 65 74 75 72 6e |Editing"|..Return|
|00002690| 73 20 54 72 75 65 20 77 | 68 65 6e 20 61 20 66 6f |s True w|hen a fo|
|000026a0| 72 6d 20 69 73 20 69 6e | 20 45 64 69 74 20 6d 6f |rm is in| Edit mo|
|000026b0| 64 65 2c 20 6f 72 20 61 | 20 66 69 65 6c 64 20 6f |de, or a| field o|
|000026c0| 62 6a 65 63 74 20 69 73 | 20 61 63 74 69 76 65 20 |bject is| active |
|000026d0| 61 6e 64 20 62 65 69 6e | 67 20 65 64 69 74 65 64 |and bein|g edited|
|000026e0| 2e 20 4f 74 68 65 72 77 | 69 73 65 2c 20 72 65 74 |. Otherw|ise, ret|
|000026f0| 75 72 6e 73 20 46 61 6c | 73 65 2e 0d 0a 0d 0a 20 |urns Fal|se..... |
|00002700| 20 20 22 46 6c 79 61 77 | 61 79 22 0d 0a 52 65 74 |  "Flyaw|ay"..Ret|
|00002710| 75 72 6e 73 20 74 72 75 | 65 20 77 68 65 6e 20 61 |urns tru|e when a|
|00002720| 20 72 65 63 6f 72 64 20 | 68 61 73 20 6d 6f 76 65 | record |has move|
|00002730| 64 20 74 6f 20 69 74 73 | 20 73 6f 72 74 65 64 20 |d to its| sorted |
|00002740| 70 6f 73 69 74 69 6f 6e | 20 69 6e 20 61 20 74 61 |position| in a ta|
|00002750| 62 6c 65 2e 20 4f 74 68 | 65 72 77 69 73 65 2c 20 |ble. Oth|erwise, |
|00002760| 72 65 74 75 72 6e 73 20 | 46 61 6c 73 65 2e 0d 0a |returns |False...|
|00002770| 0d 0a 20 20 20 22 52 65 | 66 72 65 73 68 22 0d 0a |..   "Re|fresh"..|
|00002780| 52 65 74 75 72 6e 73 20 | 54 72 75 65 20 77 68 65 |Returns |True whe|
|00002790| 6e 20 64 61 74 61 20 64 | 69 73 70 6c 61 79 65 64 |n data d|isplayed|
|000027a0| 20 6f 6e 73 63 72 65 65 | 6e 20 69 73 20 62 65 69 | onscree|n is bei|
|000027b0| 6e 67 20 63 68 61 6e 67 | 65 64 2c 20 65 69 74 68 |ng chang|ed, eith|
|000027c0| 65 72 20 61 63 72 6f 73 | 73 20 61 20 6e 65 74 77 |er acros|s a netw|
|000027d0| 6f 72 6b 2c 20 62 79 20 | 61 6e 20 4f 62 6a 65 63 |ork, by |an Objec|
|000027e0| 74 50 41 4c 20 73 74 61 | 74 65 6d 65 6e 74 2c 20 |tPAL sta|tement, |
|000027f0| 6f 72 20 75 73 65 72 20 | 61 63 74 69 6f 6e 2e 20 |or user |action. |
|00002800| 4f 74 68 65 72 77 69 73 | 65 2c 20 72 65 74 75 72 |Otherwis|e, retur|
|00002810| 6e 73 20 46 61 6c 73 65 | 2e 0d 0a 0d 0a 20 20 20 |ns False|.....   |
|00002820| 22 4e 65 78 74 22 0d 0a | 52 65 74 75 72 6e 73 20 |"Next"..|Returns |
|00002830| 74 68 65 20 6e 61 6d 65 | 20 28 61 73 20 61 20 73 |the name| (as a s|
|00002840| 74 72 69 6e 67 29 20 6f | 66 20 74 68 65 20 6e 65 |tring) o|f the ne|
|00002850| 78 74 20 6f 62 6a 65 63 | 74 20 69 6e 20 74 68 65 |xt objec|t in the|
|00002860| 20 73 61 6d 65 20 63 6f | 6e 74 61 69 6e 65 72 2e | same co|ntainer.|
|00002870| 0d 0a 0d 0a 20 20 20 22 | 4f 6e 65 2d 74 6f 2d 6d |....   "|One-to-m|
|00002880| 61 6e 79 22 0d 0a 52 65 | 74 75 72 6e 73 20 54 72 |any"..Re|turns Tr|
|00002890| 75 65 20 69 66 20 69 6e | 76 6f 6c 76 65 64 20 69 |ue if in|volved i|
|000028a0| 6e 20 61 20 31 3a 4d 20 | 6c 69 6e 6b 2e 0d 0a 0d |n a 1:M |link....|
|000028b0| 0a 20 20 20 22 4f 6e 65 | 2d 74 6f 2d 6f 6e 65 22 |.   "One|-to-one"|
|000028c0| 0d 0a 52 65 74 75 72 6e | 73 20 54 72 75 65 20 69 |..Return|s True i|
|000028d0| 66 20 69 6e 76 6f 6c 76 | 65 64 20 69 6e 20 61 20 |f involv|ed in a |
|000028e0| 31 3a 31 20 6c 69 6e 6b | 2e 00 02 00 01 00 d8 36 |1:1 link|.......6|
|000028f0| 24 00 00 02 00 02 00 01 | 00 01 00 00 00 00 00 00 |$.......|........|
|00002900| 00 00 00 00 00 00 00 01 | 80 3c 00 00 00 02 80 48 |........|.<.....H|
|00002910| 00 00 00 01 80 77 00 00 | 00 02 80 83 00 00 00 01 |.....w..|........|
|00002920| 80 00 00 00 00 01 80 00 | 00 02 00 c8 00 00 00 00 |........|........|
|00002930| 00 90 01 00 00 00 00 00 | 00 00 00 00 00 01 22 00 |........|......".|
|00002940| 06 41 72 69 61 6c 00 87 | 4d fc 01 cf 38 27 00 05 |.Arial..|M...8'..|
|00002950| 00 c3 05 87 4d 06 4d e0 | 48 c3 00 be 00 f6 89 79 |....M.M.|H......y|
|00002960| 07 c8 00 00 00 00 00 90 | 01 00 00 00 00 00 00 00 |........|........|
|00002970| 00 00 00 04 22 00 06 41 | 72 69 61 6c 00 7f 08 40 |...."..A|rial...@|
|00002980| 02 6f 1a 2f 00 05 00 c3 | 05 7f 08 66 1d 58 2a eb |.o./....|...f.X*.|
|00002990| 00 e6 00 c6 89 79 07 01 | 00 00 00 00 00 00 00 00 |.....y..|........|
|000029a0| 00 00 00 00 00 98 0f bf | 08 d0 02 00 00 00 00 00 |........|........|
|000029b0| 00 65 6e 09 09 3b 20 4d | 61 6b 65 20 73 75 72 65 |.en..; M|ake sure|
|000029c0| 20 65 76 65 72 79 74 68 | 69 6e 67 20 69 73 20 4f | everyth|ing is O|
|000029d0| 4b 0d 0a 20 20 20 20 20 | 20 20 20 6d 73 67 49 6e |K..     |   msgIn|
|000029e0| 66 6f 28 22 54 72 61 6e | 73 61 63 74 69 6f 6e 20 |fo("Tran|saction |
|000029f0| 53 74 61 74 75 73 22 2c | 20 22 49 6e 20 61 20 54 |Status",| "In a T|
|00002a00| 72 61 6e 73 61 63 74 69 | 6f 6e 22 29 0d 0a 20 20 |ransacti|on")..  |
|00002a10| 20 20 20 65 6c 73 65 0d | 0a 20 20 20 20 20 20 20 |   else.|.       |
|00002a20| 20 65 72 72 6f 72 53 68 | 6f 77 28 22 4e 4f 54 20 | errorSh|ow("NOT |
|00002a30| 69 6e 20 61 20 54 72 61 | 6e 73 61 63 74 69 6f 6e |in a Tra|nsaction|
|00002a40| 22 29 0d 0a 20 20 20 20 | 20 20 20 20 72 65 74 75 |")..    |    retu|
|00002a50| 72 6e 20 0d 0a 20 20 20 | 20 20 65 6e 64 69 66 0d |rn ..   |  endif.|
|00002a60| 0a 20 20 0d 0a 20 20 20 | 20 20 6f 70 52 65 73 75 |.  ..   |  opResu|
|00002a70| 6c 74 5b 22 44 69 73 70 | 65 6e 73 65 20 63 61 73 |lt["Disp|ense cas|
|00002a80| 68 22 5d 20 3d 20 64 69 | 73 70 65 6e 73 65 43 61 |h"] = di|spenseCa|
|00002a90| 73 68 28 78 41 6d 6f 75 | 6e 74 29 20 0d 0a 20 20 |sh(xAmou|nt) ..  |
|00002aa0| 20 20 20 41 6c 6c 5f 4f | 4b 20 3d 20 54 72 75 65 |   All_O|K = True|
|00002ab0| 09 09 09 09 3b 20 49 6e | 69 74 69 61 6c 69 7a 65 |....; In|itialize|
|00002ac0| 20 74 6f 20 54 72 75 65 | 0d 0a 20 20 0d 0a 20 20 | to True|..  ..  |
|00002ad0| 20 20 20 66 6f 72 45 61 | 63 68 20 65 6c 65 6d 65 |   forEa|ch eleme|
|00002ae0| 6e 74 20 69 6e 20 6f 70 | 52 65 73 75 6c 74 09 09 |nt in op|Result..|
|00002af0| 3b 20 43 68 65 63 6b 20 | 6f 70 65 72 61 74 69 6f |; Check |operatio|
|00002b00| 6e 20 72 65 73 75 6c 74 | 73 0d 0a 20 20 20 20 20 |n result|s..     |
|00002b10| 20 20 20 69 66 20 6f 70 | 52 65 73 75 6c 74 5b 65 |   if op|Result[e|
|00002b20| 6c 65 6d 65 6e 74 5d 20 | 3d 20 46 61 6c 73 65 20 |lement] |= False |
|00002b30| 74 68 65 6e 20 0d 0a 20 | 20 20 20 20 20 20 20 20 |then .. |        |
|00002b40| 20 20 41 6c 6c 5f 4f 4b | 20 3d 20 46 61 6c 73 65 |  All_OK| = False|
|00002b50| 0d 0a 20 20 20 20 20 20 | 20 20 20 20 20 71 75 69 |..      |     qui|
|00002b60| 74 4c 6f 6f 70 20 0d 0a | 20 20 20 20 20 20 20 20 |tLoop ..|        |
|00002b70| 65 6e 64 49 66 0d 0a 20 | 20 20 20 20 65 6e 64 46 |endIf.. |    endF|
|00002b80| 6f 72 45 61 63 68 0d 0a | 20 20 0d 0a 20 20 20 20 |orEach..|  ..    |
|00002b90| 20 3b 20 49 6e 66 6f 72 | 6d 20 75 73 65 72 20 6f | ; Infor|m user o|
|00002ba0| 66 20 74 72 61 6e 73 61 | 63 74 69 6f 6e 20 73 74 |f transa|ction st|
|00002bb0| 61 74 75 73 0d 0a 20 20 | 0d 0a 20 20 20 20 20 69 |atus..  |..     i|
|00002bc0| 66 20 41 6c 6c 5f 4f 4b | 20 74 68 65 6e 0d 0a 20 |f All_OK| then.. |
|00002bd0| 20 20 20 20 20 20 20 69 | 66 20 64 62 2e 63 6f 6d |       i|f db.com|
|00002be0| 6d 69 74 54 72 61 6e 73 | 61 63 74 69 6f 6e 28 29 |mitTrans|action()|
|00002bf0| 20 74 68 65 6e 0d 0a 20 | 20 20 20 20 20 20 20 20 | then.. |        |
|00002c00| 20 20 6d 73 67 49 6e 66 | 6f 28 22 54 72 61 6e 73 |  msgInf|o("Trans|
|00002c10| 61 63 74 69 6f 6e 20 53 | 74 61 74 75 73 22 2c 22 |action S|tatus","|
|00002c20| 54 72 61 6e 73 61 63 74 | 69 6f 6e 20 63 6f 6d 6d |Transact|ion comm|
|00002c30| 69 74 74 65 64 2e 22 29 | 0d 0a 20 20 20 20 20 20 |itted.")|..      |
|00002c40| 20 20 65 6c 73 65 0d 0a | 20 20 20 20 20 20 20 20 |  else..|        |
|00002c50| 20 20 20 65 72 72 6f 72 | 53 68 6f 77 28 22 54 72 |   error|Show("Tr|
|00002c60| 61 6e 73 61 63 74 69 6f | 6e 20 4e 4f 54 20 63 6f |ansactio|n NOT co|
|00002c70| 6d 6d 69 74 74 65 64 22 | 29 0d 0a 20 20 20 20 20 |mmitted"|)..     |
|00002c80| 20 20 20 65 6e 64 49 66 | 0d 0a 20 20 20 20 20 65 |   endIf|..     e|
|00002c90| 6c 73 65 0d 0a 20 20 20 | 20 20 20 20 20 20 69 66 |lse..   |      if|
|00002ca0| 20 6d 73 67 51 75 65 73 | 74 69 6f 6e 28 22 54 72 | msgQues|tion("Tr|
|00002cb0| 61 6e 73 61 63 74 69 6f | 6e 20 66 61 69 6c 65 64 |ansactio|n failed|
|00002cc0| 22 2c 20 22 56 69 65 77 | 20 72 65 73 75 6c 74 73 |", "View| results|
|00002cd0| 3f 22 29 20 3d 20 22 59 | 65 73 22 20 74 68 65 6e |?") = "Y|es" then|
|00002ce0| 0d 0a 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |..      |        |
|00002cf0| 6f 70 52 65 73 75 6c 74 | 2e 76 69 65 77 28 22 4f |opResult|.view("O|
|00002d00| 70 65 72 61 74 69 6f 6e | 20 72 65 73 75 6c 74 73 |peration| results|
|00002d10| 22 29 0d 0a 20 20 20 20 | 20 20 20 20 20 65 6e 64 |")..    |     end|
|00002d20| 49 66 20 0d 0a 20 20 0d | 0a 20 20 20 20 20 20 20 |If ..  .|.       |
|00002d30| 20 20 69 66 20 64 62 2e | 72 6f 6c 6c 62 61 63 6b |  if db.|rollback|
|00002d40| 54 72 61 6e 73 61 63 74 | 69 6f 6e 28 29 20 74 68 |Transact|ion() th|
|00002d50| 65 6e 0d 0a 20 20 20 20 | 20 20 20 20 20 20 20 20 |en..    |        |
|00002d60| 20 20 6d 73 67 49 6e 66 | 6f 28 22 54 72 61 6e 73 |  msgInf|o("Trans|
|00002d70| 61 63 74 69 6f 6e 20 53 | 74 61 74 75 73 22 2c 20 |action S|tatus", |
|00002d80| 22 54 72 61 6e 73 61 63 | 74 69 6f 6e 20 72 6f 6c |"Transac|tion rol|
|00002d90| 6c 65 64 20 62 61 63 6b | 2e 22 29 0d 0a 20 20 20 |led back|.")..   |
|00002da0| 20 20 20 20 20 20 65 6c | 73 65 0d 0a 20 20 20 20 |      el|se..    |
|00002db0| 20 20 20 20 20 20 20 20 | 20 20 65 72 72 6f 72 53 |        |  errorS|
|00002dc0| 68 6f 77 28 22 54 72 61 | 6e 73 61 63 74 69 6f 6e |how("Tra|nsaction|
|00002dd0| 20 4e 4f 54 20 72 6f 6c | 6c 65 64 20 62 61 63 6b | NOT rol|led back|
|00002de0| 2e 22 29 0d 0a 20 20 20 | 20 20 20 20 20 20 65 6e |.")..   |      en|
|00002df0| 64 49 66 0d 0a 20 20 20 | 20 20 65 6e 64 64 69 66 |dIf..   |  enddif|
|00002e00| 0d 0a 20 20 0d 0a 20 20 | 65 6e 64 6d 65 74 68 6f |..  ..  |endmetho|
|00002e10| 64 0d 0a 20 20 00 02 00 | 01 00 d8 36 24 00 00 02 |d..  ...|...6$...|
|00002e20| 00 02 00 01 00 01 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002e30| 00 00 00 01 80 71 02 00 | 00 02 80 00 00 00 00 01 |.....q..|........|
|00002e40| 80 00 00 02 00 c8 00 00 | 00 00 00 90 01 00 00 00 |........|........|
|00002e50| 00 00 00 00 00 00 00 01 | 22 00 06 41 72 69 61 6c |........|"..Arial|
|00002e60| 00 67 1b 40 02 67 2f 05 | 00 05 00 c3 05 67 1b 06 |.g.@.g/.|.....g..|
|00002e70| 14 54 24 19 00 14 00 c6 | 89 79 07 c8 00 00 00 00 |.T$.....|.y......|
|00002e80| 00 90 01 00 00 00 00 00 | 00 00 00 00 00 01 31 00 |........|......1.|
|00002e90| 04 43 6f 75 72 69 65 72 | 20 4e 65 77 00 05 00 05 |.Courier| New....|
|00002ea0| 00 c3 05 67 1b 06 14 54 | 24 19 00 14 00 c6 89 79 |...g...T|$......y|
|00002eb0| 07 01 00 00 00 00 00 00 | 00 00 00 00 00 00 00 98 |........|........|
|00002ec0| 0f 8f 09 d0 02 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002ed0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002ee0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002ef0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002f00| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002f10| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002f20| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002f30| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002f40| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002f50| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002f60| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002f70| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002f80| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002f90| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002fa0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002fb0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002fc0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002fd0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002fe0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002ff0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003000| 02 01 00 94 08 00 00 4a | 02 07 00 00 00 65 07 00 |.......J|.....e..|
|00003010| 00 0a 00 11 00 00 00 03 | 00 08 00 00 00 02 00 5a |........|.......Z|
|00003020| 00 00 00 04 00 08 00 00 | 00 06 00 6c 00 00 00 07 |........|...l....|
|00003030| 00 16 00 00 00 49 6d 70 | 6f 72 74 73 20 64 61 74 |.....Imp|orts dat|
|00003040| 61 20 66 72 6f 6d 20 61 | 20 64 65 6c 69 6d 69 74 |a from a| delimit|
|00003050| 65 64 20 41 53 43 49 49 | 20 28 74 65 78 74 29 20 |ed ASCII| (text) |
|00003060| 66 69 6c 65 20 69 6e 20 | 77 68 69 63 68 20 74 68 |file in |which th|
|00003070| 65 20 66 69 65 6c 64 20 | 76 61 6c 75 65 73 20 61 |e field |values a|
|00003080| 72 65 20 64 65 6c 69 6d | 69 74 65 64 20 62 79 20 |re delim|ited by |
|00003090| 61 20 73 70 65 63 69 66 | 69 65 64 20 63 68 61 72 |a specif|ied char|
|000030a0| 61 63 74 65 72 2e 20 55 | 73 69 6e 67 20 74 68 69 |acter. U|sing thi|
|000030b0| 73 20 70 72 6f 63 65 64 | 75 72 65 2c 20 79 6f 75 |s proced|ure, you|
|000030c0| 20 63 61 6e 20 77 72 69 | 74 65 20 4f 62 6a 65 63 | can wri|te Objec|
|000030d0| 74 50 41 4c 20 63 6f 64 | 65 20 74 6f 20 64 75 70 |tPAL cod|e to dup|
|000030e0| 6c 69 63 61 74 65 20 74 | 68 65 20 66 75 6e 63 74 |licate t|he funct|
|000030f0| 69 6f 6e 61 6c 69 74 79 | 20 6f 66 20 74 68 65 20 |ionality| of the |
|00003100| 44 65 6c 69 6d 69 74 65 | 64 20 41 53 43 49 49 20 |Delimite|d ASCII |
|00003110| 49 6d 70 6f 72 74 20 64 | 69 61 6c 6f 67 20 62 6f |Import d|ialog bo|
|00003120| 78 2e 0d 0a 0d 0a 54 68 | 65 20 66 69 6c 65 4e 61 |x.....Th|e fileNa|
|00003130| 6d 65 20 61 72 67 75 6d | 65 6e 74 20 73 70 65 63 |me argum|ent spec|
|00003140| 69 66 69 65 73 20 74 68 | 65 20 66 69 6c 65 20 74 |ifies th|e file t|
|00003150| 6f 20 69 6d 70 6f 72 74 | 20 66 72 6f 6d 2c 20 61 |o import| from, a|
|00003160| 6e 64 20 74 68 65 20 74 | 61 62 6c 65 4e 61 6d 65 |nd the t|ableName|
|00003170| 20 61 72 67 75 6d 65 6e | 74 20 73 70 65 63 69 66 | argumen|t specif|
|00003180| 69 65 73 20 74 68 65 20 | 74 61 62 6c 65 20 74 6f |ies the |table to|
|00003190| 20 69 6d 70 6f 72 74 20 | 74 6f 2e 0d 0a 0d 0a 49 | import |to.....I|
|000031a0| 6d 70 6f 72 74 61 6e 74 | 3a 20 54 68 65 20 65 78 |mportant|: The ex|
|000031b0| 74 65 6e 73 69 6f 6e 20 | 79 6f 75 20 73 75 70 70 |tension |you supp|
|000031c0| 6c 79 20 61 73 20 70 61 | 72 74 20 6f 66 20 74 68 |ly as pa|rt of th|
|000031d0| 65 20 74 61 62 6c 65 4e | 61 6d 65 20 61 72 67 75 |e tableN|ame argu|
|000031e0| 6d 65 6e 74 20 73 70 65 | 63 69 66 69 65 73 20 74 |ment spe|cifies t|
|000031f0| 68 65 20 74 61 62 6c 65 | 20 74 79 70 65 2e 20 55 |he table| type. U|
|00003200| 73 65 20 2e 44 42 20 74 | 6f 20 73 70 65 63 69 66 |se .DB t|o specif|
|00003210| 79 20 61 20 50 61 72 61 | 64 6f 78 20 74 61 62 6c |y a Para|dox tabl|
|00003220| 65 2c 20 75 73 65 20 2e | 44 42 46 20 74 6f 20 73 |e, use .|DBF to s|
|00003230| 70 65 63 69 66 79 20 61 | 20 64 42 41 53 45 20 74 |pecify a| dBASE t|
|00003240| 61 62 6c 65 2e 20 49 66 | 20 79 6f 75 20 6f 6d 69 |able. If| you omi|
|00003250| 74 20 74 68 65 20 65 78 | 74 65 6e 73 69 6f 6e 2c |t the ex|tension,|
|00003260| 20 74 68 65 20 64 61 74 | 61 20 69 73 20 69 6d 70 | the dat|a is imp|
|00003270| 6f 72 74 65 64 20 74 6f | 20 61 20 50 61 72 61 64 |orted to| a Parad|
|00003280| 6f 78 20 74 61 62 6c 65 | 20 62 79 20 64 65 66 61 |ox table| by defa|
|00003290| 75 6c 74 2e 0d 0a 0d 0a | 55 73 65 20 74 68 65 20 |ult.....|Use the |
|000032a0| 73 65 70 61 72 61 74 6f | 72 20 61 72 67 75 6d 65 |separato|r argume|
|000032b0| 6e 74 20 74 6f 20 73 70 | 65 63 69 66 79 20 74 68 |nt to sp|ecify th|
|000032c0| 65 20 63 68 61 72 61 63 | 74 65 72 20 74 68 61 74 |e charac|ter that|
|000032d0| 20 73 65 70 61 72 61 74 | 65 73 20 66 69 65 6c 64 | separat|es field|
|000032e0| 20 76 61 6c 75 65 73 20 | 69 6e 20 74 68 65 20 74 | values |in the t|
|000032f0| 65 78 74 20 66 69 6c 65 | 2e 20 59 6f 75 20 63 61 |ext file|. You ca|
|00003300| 6e 20 63 68 6f 6f 73 65 | 20 61 20 63 6f 6d 6d 61 |n choose| a comma|
|00003310| 20 6f 72 20 61 6e 79 20 | 6f 74 68 65 72 20 73 69 | or any |other si|
|00003320| 6e 67 6c 65 20 63 68 61 | 72 61 63 74 65 72 2c 20 |ngle cha|racter, |
|00003330| 69 6e 63 6c 75 64 69 6e | 67 20 73 70 65 63 69 61 |includin|g specia|
|00003340| 6c 20 63 68 61 72 61 63 | 74 65 72 73 20 73 75 63 |l charac|ters suc|
|00003350| 68 20 61 73 20 74 61 62 | 73 2e 20 55 73 65 20 74 |h as tab|s. Use t|
|00003360| 68 65 20 64 65 6c 69 6d | 69 74 65 72 20 61 72 67 |he delim|iter arg|
|00003370| 75 6d 65 6e 74 20 74 6f | 20 73 70 65 63 69 66 79 |ument to| specify|
|00003380| 20 74 68 65 20 63 68 61 | 72 61 63 74 65 72 73 20 | the cha|racters |
|00003390| 74 68 61 74 20 73 75 72 | 72 6f 75 6e 64 20 76 61 |that sur|round va|
|000033a0| 6c 75 65 73 20 69 6e 20 | 74 68 65 20 65 78 70 6f |lues in |the expo|
|000033b0| 72 74 65 64 20 66 69 6c | 65 2e 20 59 6f 75 20 63 |rted fil|e. You c|
|000033c0| 61 6e 20 73 70 65 63 69 | 66 79 20 74 68 65 20 65 |an speci|fy the e|
|000033d0| 6d 70 74 79 20 73 74 72 | 69 6e 67 20 69 66 20 79 |mpty str|ing if y|
|000033e0| 6f 75 20 64 6f 20 6e 6f | 74 20 77 61 6e 74 20 61 |ou do no|t want a|
|000033f0| 6e 79 20 63 68 61 72 61 | 63 74 65 72 73 20 74 6f |ny chara|cters to|
|00003400| 20 65 6e 63 6c 6f 73 65 | 20 74 68 65 20 76 61 6c | enclose| the val|
|00003410| 75 65 73 2e 20 55 73 65 | 20 74 68 65 20 61 6c 6c |ues. Use| the all|
|00003420| 46 69 65 6c 64 73 44 65 | 6c 69 6d 69 74 65 64 20 |FieldsDe|limited |
|00003430| 61 72 67 75 6d 65 6e 74 | 20 74 6f 20 73 70 65 63 |argument| to spec|
|00003440| 69 66 79 20 77 68 65 74 | 68 65 72 20 74 6f 20 73 |ify whet|her to s|
|00003450| 75 72 72 6f 75 6e 64 20 | 64 61 74 61 20 66 72 6f |urround |data fro|
|00003460| 6d 20 61 6c 6c 20 66 69 | 65 6c 64 20 74 79 70 65 |m all fi|eld type|
|00003470| 73 20 28 54 72 75 65 29 | 20 6f 72 20 6f 6e 6c 79 |s (True)| or only|
|00003480| 20 66 72 6f 6d 20 74 65 | 78 74 20 66 69 65 6c 64 | from te|xt field|
|00003490| 20 74 79 70 65 73 20 28 | 61 6c 70 68 61 6e 75 6d | types (|alphanum|
|000034a0| 65 72 69 63 20 6f 72 20 | 63 68 61 72 61 63 74 65 |eric or |characte|
|000034b0| 72 29 20 77 69 74 68 20 | 74 68 65 20 73 70 65 63 |r) with |the spec|
|000034c0| 69 66 69 65 64 20 64 65 | 6c 69 6d 69 74 65 72 20 |ified de|limiter |
|000034d0| 63 68 61 72 61 63 74 65 | 72 20 28 46 61 6c 73 65 |characte|r (False|
|000034e0| 29 2e 20 54 68 65 73 65 | 20 61 72 65 20 74 68 65 |). These| are the|
|000034f0| 20 64 65 66 61 75 6c 74 | 20 73 65 74 74 69 6e 67 | default| setting|
|00003500| 73 3a 20 66 69 65 6c 64 | 73 20 61 72 65 20 73 65 |s: field|s are se|
|00003510| 70 61 72 61 74 65 64 20 | 62 79 20 63 6f 6d 6d 61 |parated |by comma|
|00003520| 73 2c 20 66 69 65 6c 64 | 73 20 61 72 65 20 64 65 |s, field|s are de|
|00003530| 6c 69 6d 69 74 65 64 20 | 62 79 20 71 75 6f 74 65 |limited |by quote|
|00003540| 73 2c 20 6f 6e 6c 79 20 | 74 65 78 74 20 66 69 65 |s, only |text fie|
|00003550| 6c 64 73 20 61 72 65 20 | 64 65 6c 69 6d 69 74 65 |lds are |delimite|
|00003560| 64 2c 20 61 6e 64 20 74 | 68 65 20 4f 45 4d 20 63 |d, and t|he OEM c|
|00003570| 68 61 72 61 63 74 65 72 | 20 73 65 74 20 69 73 20 |haracter| set is |
|00003580| 75 73 65 64 2e 0d 0a 0d | 0a 4e 6f 74 65 3a 20 50 |used....|.Note: P|
|00003590| 61 72 61 64 6f 78 20 74 | 72 69 6d 73 20 73 74 72 |aradox t|rims str|
|000035a0| 69 6e 67 73 20 6c 6f 6e | 67 65 72 20 74 68 61 6e |ings lon|ger than|
|000035b0| 20 32 35 35 20 63 68 61 | 72 61 63 74 65 72 73 20 | 255 cha|racters |
|000035c0| 77 68 65 6e 20 69 74 20 | 69 6d 70 6f 72 74 73 20 |when it |imports |
|000035d0| 74 68 65 6d 2e 0d 0a 0d | 0a 54 68 65 20 41 4e 53 |them....|.The ANS|
|000035e0| 49 20 61 72 67 75 6d 65 | 6e 74 20 73 70 65 63 69 |I argume|nt speci|
|000035f0| 66 69 65 73 20 77 68 65 | 74 68 65 72 20 74 6f 20 |fies whe|ther to |
|00003600| 75 73 65 20 74 68 65 20 | 41 4e 53 49 20 6f 72 20 |use the |ANSI or |
|00003610| 4f 45 4d 20 63 68 61 72 | 61 63 74 65 72 20 73 65 |OEM char|acter se|
|00003620| 74 3a 20 73 65 74 20 41 | 4e 53 49 20 74 6f 20 54 |t: set A|NSI to T|
|00003630| 72 75 65 20 74 6f 20 75 | 73 65 20 74 68 65 20 41 |rue to u|se the A|
|00003640| 4e 53 49 20 63 68 61 72 | 61 63 74 65 72 20 73 65 |NSI char|acter se|
|00003650| 74 2c 20 6f 72 20 74 6f | 20 46 61 6c 73 65 20 74 |t, or to| False t|
|00003660| 6f 20 75 73 65 20 74 68 | 65 20 4f 45 4d 20 63 68 |o use th|e OEM ch|
|00003670| 61 72 61 63 74 65 72 20 | 73 65 74 2e 20 20 49 66 |aracter |set.  If|
|00003680| 20 79 6f 75 20 6f 6d 69 | 74 20 74 68 69 73 20 61 | you omi|t this a|
|00003690| 72 67 75 6d 65 6e 74 2c | 20 50 61 72 61 64 6f 78 |rgument,| Paradox|
|000036a0| 20 75 73 65 73 20 74 68 | 65 20 4f 45 4d 20 63 68 | uses th|e OEM ch|
|000036b0| 61 72 61 63 74 65 72 20 | 73 65 74 20 62 79 20 64 |aracter |set by d|
|000036c0| 65 66 61 75 6c 74 2e 28 | 4f 45 4d 20 73 74 61 6e |efault.(|OEM stan|
|000036d0| 64 73 20 66 6f 72 20 4f | 72 69 67 69 6e 61 6c 20 |ds for O|riginal |
|000036e0| 45 71 75 69 70 6d 65 6e | 74 20 4d 61 6e 75 66 61 |Equipmen|t Manufa|
|000036f0| 63 74 75 72 65 72 20 61 | 6e 64 20 72 65 66 65 72 |cturer a|nd refer|
|00003700| 73 20 74 6f 20 74 68 65 | 20 63 68 61 72 61 63 74 |s to the| charact|
|00003710| 65 72 20 73 65 74 20 79 | 6f 75 72 20 63 6f 6d 70 |er set y|our comp|
|00003720| 75 74 65 72 20 75 73 65 | 73 3b 20 41 4e 53 49 20 |uter use|s; ANSI |
|00003730| 73 74 61 6e 64 73 20 66 | 6f 72 20 41 6d 65 72 69 |stands f|or Ameri|
|00003740| 63 61 6e 20 4e 61 74 69 | 6f 6e 61 6c 20 53 74 61 |can Nati|onal Sta|
|00003750| 6e 64 61 72 64 73 20 49 | 6e 73 74 69 74 75 74 65 |ndards I|nstitute|
|00003760| 20 61 6e 64 20 72 65 66 | 65 72 73 20 74 6f 20 74 | and ref|ers to t|
|00003770| 68 65 20 63 68 61 72 61 | 63 74 65 72 20 73 65 74 |he chara|cter set|
|00003780| 20 73 75 70 70 6f 72 74 | 65 64 20 62 79 20 57 69 | support|ed by Wi|
|00003790| 6e 64 6f 77 73 2e 29 0d | 0a 00 02 00 01 00 d8 36 |ndows.).|.......6|
|000037a0| 24 00 00 02 00 02 00 01 | 00 01 00 00 00 00 00 00 |$.......|........|
|000037b0| 00 00 00 00 00 00 00 01 | 80 f5 00 00 00 02 80 fd |........|........|
|000037c0| 00 00 00 01 80 32 01 00 | 00 02 80 3b 01 00 00 01 |.....2..|...;....|
|000037d0| 80 9d 01 00 00 02 80 a6 | 01 00 00 01 80 6b 02 00 |........|.....k..|
|000037e0| 00 02 80 74 02 00 00 01 | 80 e8 03 00 00 02 80 fa |...t....|........|
|000037f0| 03 00 00 01 80 a8 05 00 | 00 02 80 ac 05 00 00 01 |........|........|
|00003800| 80 f2 05 00 00 02 80 f6 | 05 00 00 01 80 00 00 00 |........|........|
|00003810| 00 01 80 00 00 02 00 c8 | 00 00 00 00 00 90 01 00 |........|........|
|00003820| 00 00 00 00 00 00 00 00 | 00 01 22 00 06 41 72 69 |........|.."..Ari|
|00003830| 61 6c 00 67 1b 40 02 67 | 2f 05 00 05 00 c3 05 67 |al.g.@.g|/......g|
|00003840| 1b 06 14 54 24 19 00 14 | 00 c6 89 79 07 c8 00 00 |...T$...|...y....|
|00003850| 00 00 00 90 01 00 00 00 | 00 00 00 00 00 00 00 04 |........|........|
|00003860| 22 00 06 41 72 69 61 6c | 00 7f 08 40 02 6f 1a 2f |"..Arial|...@.o./|
|00003870| 00 05 00 c3 05 7f 08 66 | 1d 58 2a eb 00 e6 00 c6 |.......f|.X*.....|
|00003880| 89 79 07 01 00 00 00 00 | 00 00 00 00 00 00 00 00 |.y......|........|
|00003890| 00 98 0f bf 08 d0 02 00 | 00 00 00 00 00 6a 65 63 |........|.....jec|
|000038a0| 74 73 20 69 6e 20 74 68 | 65 20 66 6f 72 6d 0d 0a |ts in th|e form..|
|000038b0| 0d 0a 20 20 20 20 20 20 | 20 20 78 20 3d 20 31 30 |..      |  x = 10|
|000038c0| 30 0d 0a 20 20 20 20 20 | 20 20 20 79 20 3d 20 31 |0..     |   y = 1|
|000038d0| 30 30 0d 0a 20 20 20 20 | 20 20 20 20 77 20 3d 20 |00..    |    w = |
|000038e0| 32 38 38 30 0d 0a 20 20 | 20 20 20 20 20 20 68 20 |2880..  |      h |
|000038f0| 3d 20 33 36 30 0d 0a 20 | 20 20 20 20 20 20 20 6f |= 360.. |       o|
|00003900| 66 66 73 65 74 20 3d 20 | 31 30 0d 0a 0d 0a 20 20 |ffset = |10....  |
|00003910| 20 20 20 3b 20 63 72 65 | 61 74 65 20 66 69 65 6c |   ; cre|ate fiel|
|00003920| 64 20 6f 62 6a 65 63 74 | 73 20 62 6f 75 6e 64 20 |d object|s bound |
|00003930| 74 6f 20 6d 61 73 74 65 | 72 20 74 61 62 6c 65 0d |to maste|r table.|
|00003940| 0a 20 20 20 20 20 20 20 | 20 66 6f 72 20 69 20 66 |.       | for i f|
|00003950| 72 6f 6d 20 31 20 74 6f | 20 6d 61 73 74 65 72 46 |rom 1 to| masterF|
|00003960| 69 65 6c 64 73 41 72 2e | 73 69 7a 65 28 29 0d 0a |ieldsAr.|size()..|
|00003970| 20 20 20 20 20 20 20 20 | 20 20 20 6e 65 77 46 69 |        |   newFi|
|00003980| 65 6c 64 2e 63 72 65 61 | 74 65 28 46 69 65 6c 64 |eld.crea|te(Field|
|00003990| 54 6f 6f 6c 2c 20 78 2c | 20 79 2c 20 77 2c 20 68 |Tool, x,| y, w, h|
|000039a0| 2c 20 6e 65 77 46 6f 72 | 6d 29 0d 0a 20 20 20 20 |, newFor|m)..    |
|000039b0| 20 20 20 20 20 20 20 79 | 20 3d 20 79 20 2b 20 68 |       y| = y + h|
|000039c0| 20 2b 20 6f 66 66 73 65 | 74 0d 0a 20 20 20 20 20 | + offse|t..     |
|000039d0| 20 20 20 20 20 20 6e 65 | 77 46 69 65 6c 64 2e 54 |      ne|wField.T|
|000039e0| 61 62 6c 65 4e 61 6d 65 | 20 3d 20 6d 61 73 74 65 |ableName| = maste|
|000039f0| 72 4e 61 6d 65 0d 0a 20 | 20 20 20 20 20 20 20 20 |rName.. |        |
|00003a00| 20 20 6e 65 77 46 69 65 | 6c 64 2e 46 69 65 6c 64 |  newFie|ld.Field|
|00003a10| 4e 61 6d 65 20 3d 20 6d | 61 73 74 65 72 46 69 65 |Name = m|asterFie|
|00003a20| 6c 64 73 41 72 5b 69 5d | 0d 0a 20 20 20 20 20 20 |ldsAr[i]|..      |
|00003a30| 20 20 20 20 20 6e 65 77 | 46 69 65 6c 64 2e 56 69 |     new|Field.Vi|
|00003a40| 73 69 62 6c 65 20 3d 20 | 59 65 73 0d 0a 20 20 20 |sible = |Yes..   |
|00003a50| 20 20 20 20 20 65 6e 64 | 46 6f 72 0d 0a 0d 0a 20 |     end|For.... |
|00003a60| 20 20 20 20 3b 20 63 72 | 65 61 74 65 20 61 20 74 |    ; cr|eate a t|
|00003a70| 61 62 6c 65 20 66 72 61 | 6d 65 20 62 6f 75 6e 64 |able fra|me bound|
|00003a80| 20 74 6f 20 64 65 74 61 | 69 6c 20 74 61 62 6c 65 | to deta|il table|
|00003a90| 0d 0a 20 20 20 20 20 20 | 20 20 6e 65 77 54 46 72 |..      |  newTFr|
|00003aa0| 61 6d 65 2e 63 72 65 61 | 74 65 28 54 61 62 6c 65 |ame.crea|te(Table|
|00003ab0| 46 72 61 6d 65 54 6f 6f | 6c 2c 20 78 2c 20 79 2c |FrameToo|l, x, y,|
|00003ac0| 20 77 2c 20 38 20 2a 20 | 68 2c 20 6e 65 77 46 6f | w, 8 * |h, newFo|
|00003ad0| 72 6d 29 0d 0a 20 20 20 | 20 20 20 20 20 6e 65 77 |rm)..   |     new|
|00003ae0| 54 46 72 61 6d 65 2e 54 | 61 62 6c 65 4e 61 6d 65 |TFrame.T|ableName|
|00003af0| 20 3d 20 64 65 74 61 69 | 6c 4e 61 6d 65 0d 0a 20 | = detai|lName.. |
|00003b00| 20 20 20 20 20 20 20 6e | 65 77 54 46 72 61 6d 65 |       n|ewTFrame|
|00003b10| 2e 56 69 73 69 62 6c 65 | 20 3d 20 59 65 73 0d 0a |.Visible| = Yes..|
|00003b20| 0d 0a 20 20 20 20 20 3b | 20 73 61 76 65 20 74 68 |..     ;| save th|
|00003b30| 65 20 66 6f 72 6d 20 61 | 6e 64 20 72 75 6e 20 69 |e form a|nd run i|
|00003b40| 74 0d 0a 20 20 20 20 20 | 20 20 20 6e 65 77 46 6f |t..     |   newFo|
|00003b50| 72 6d 2e 73 61 76 65 28 | 6e 65 77 46 6f 72 6d 4e |rm.save(|newFormN|
|00003b60| 61 6d 65 29 0d 0a 20 20 | 20 20 20 20 20 20 6e 65 |ame)..  |      ne|
|00003b70| 77 46 6f 72 6d 2e 72 75 | 6e 28 29 0d 0a 0d 0a 20 |wForm.ru|n().... |
|00003b80| 20 20 20 20 65 6c 73 65 | 0d 0a 0d 0a 20 20 20 20 |    else|....    |
|00003b90| 20 20 20 20 65 72 72 6f | 72 53 68 6f 77 28 22 4c |    erro|rShow("L|
|00003ba0| 69 6e 6b 20 66 61 69 6c | 65 64 22 29 0d 0a 20 20 |ink fail|ed")..  |
|00003bb0| 20 20 20 65 6e 64 49 66 | 0d 0a 0d 0a 20 20 65 6e |   endIf|....  en|
|00003bc0| 64 4d 65 74 68 6f 64 0d | 0a 0d 0a 0d 0a 54 68 65 |dMethod.|.....The|
|00003bd0| 20 6e 65 78 74 20 65 78 | 61 6d 70 6c 65 20 73 68 | next ex|ample sh|
|00003be0| 6f 77 73 20 68 6f 77 20 | 74 6f 20 75 73 65 20 64 |ows how |to use d|
|00003bf0| 6d 4c 69 6e 6b 54 6f 46 | 69 65 6c 64 73 20 74 6f |mLinkToF|ields to|
|00003c00| 20 6c 69 6e 6b 20 74 68 | 72 65 65 20 74 61 62 6c | link th|ree tabl|
|00003c10| 65 73 20 31 3a 4d 3a 4d | 2e 20 4c 69 6b 65 20 74 |es 1:M:M|. Like t|
|00003c20| 68 65 20 70 72 65 76 69 | 6f 75 73 20 65 78 61 6d |he previ|ous exam|
|00003c30| 70 6c 65 2c 20 74 68 69 | 73 20 63 6f 64 65 20 73 |ple, thi|s code s|
|00003c40| 70 65 63 69 66 69 65 73 | 20 77 68 69 63 68 20 66 |pecifies| which f|
|00003c50| 69 65 6c 64 73 20 74 6f | 20 6c 69 6e 6b 2e 0d 0a |ields to| link...|
|00003c60| 0d 0a 20 20 6d 65 74 68 | 6f 64 20 70 75 73 68 42 |..  meth|od pushB|
|00003c70| 75 74 74 6f 6e 28 76 61 | 72 20 65 76 65 6e 74 49 |utton(va|r eventI|
|00003c80| 6e 66 6f 20 45 76 65 6e | 74 29 0d 0a 20 20 20 20 |nfo Even|t)..    |
|00003c90| 20 76 61 72 0d 0a 20 20 | 20 20 20 20 20 20 66 69 | var..  |      fi|
|00003ca0| 72 73 74 54 61 62 6c 65 | 2c 0d 0a 20 20 20 20 20 |rstTable|,..     |
|00003cb0| 20 20 20 73 65 63 6f 6e | 64 54 61 62 6c 65 2c 0d |   secon|dTable,.|
|00003cc0| 0a 20 20 20 20 20 20 20 | 20 74 68 69 72 64 54 61 |.       | thirdTa|
|00003cd0| 62 6c 65 09 09 53 74 72 | 69 6e 67 0d 0a 0d 0a 20 |ble..Str|ing.... |
|00003ce0| 20 20 20 20 20 20 20 66 | 69 72 73 74 4b 65 79 41 |       f|irstKeyA|
|00003cf0| 72 2c 0d 0a 20 20 20 20 | 20 20 20 20 73 65 63 6f |r,..    |    seco|
|00003d00| 6e 64 4b 65 79 41 72 2c | 0d 0a 20 20 20 20 20 20 |ndKeyAr,|..      |
|00003d10| 20 20 74 68 69 72 64 4b | 65 79 41 72 09 09 41 72 |  thirdK|eyAr..Ar|
|00003d20| 72 61 79 5b 5d 20 53 74 | 72 69 6e 67 0d 0a 0d 0a |ray[] St|ring....|
|00003d30| 20 20 20 20 20 20 20 20 | 6e 65 77 46 6f 72 6d 09 |        |newForm.|
|00003d40| 09 46 6f 72 6d 0d 0a 20 | 20 20 20 20 65 6e 64 56 |.Form.. |    endV|
|00003d50| 61 72 0d 0a 0d 0a 20 20 | 20 20 20 3b 20 69 6e 69 |ar....  |   ; ini|
|00003d60| 74 69 61 6c 69 7a 65 20 | 76 61 72 69 61 62 6c 65 |tialize |variable|
|00003d70| 73 0d 0a 20 20 20 20 20 | 66 69 72 73 74 54 61 62 |s..     |firstTab|
|00003d80| 6c 65 20 3d 20 22 63 75 | 73 74 6f 6d 65 72 2e 64 |le = "cu|stomer.d|
|00003d90| 62 22 0d 0a 20 20 20 20 | 20 73 65 63 6f 6e 64 54 |b"..    | secondT|
|00003da0| 61 62 6c 65 20 3d 20 22 | 6f 72 64 65 72 73 2e 64 |able = "|orders.d|
|00003db0| 62 22 0d 0a 20 20 20 20 | 20 74 68 69 72 64 54 61 |b"..    | thirdTa|
|00003dc0| 62 6c 65 20 3d 20 22 6c | 69 6e 65 69 74 65 6d 2e |ble = "l|ineitem.|
|00003dd0| 64 62 22 0d 0a 0d 0a 20 | 20 20 20 20 66 69 72 73 |db".... |    firs|
|00003de0| 74 4b 65 79 41 72 2e 67 | 72 6f 77 28 31 29 0d 0a |tKeyAr.g|row(1)..|
|00003df0| 20 20 20 20 20 66 69 72 | 73 74 4b 65 79 41 72 5b |     fir|stKeyAr[|
|00003e00| 31 5d 20 3d 20 22 43 75 | 73 74 6f 6d 65 72 20 4e |1] = "Cu|stomer N|
|00003e10| 6f 22 0d 0a 20 20 20 20 | 20 73 65 63 6f 6e 64 4b |o"..    | secondK|
|00003e20| 65 79 41 72 2e 67 72 6f | 77 28 31 29 0d 0a 20 20 |eyAr.gro|w(1)..  |
|00003e30| 20 20 20 73 65 63 6f 6e | 64 4b 65 79 41 72 5b 31 |   secon|dKeyAr[1|
|00003e40| 5d 20 3d 20 22 43 75 73 | 74 6f 6d 65 72 20 4e 6f |] = "Cus|tomer No|
|00003e50| 22 0d 0a 20 20 20 20 20 | 3b 20 74 68 69 72 64 4b |"..     |; thirdK|
|00003e60| 65 79 41 72 20 69 73 20 | 69 6e 69 74 69 61 6c 69 |eyAr is |initiali|
|00003e70| 7a 65 64 20 62 65 6c 6f | 77 2c 20 61 66 74 65 72 |zed belo|w, after|
|00003e80| 20 66 69 72 73 74 20 6c | 69 6e 6b 0d 0a 0d 0a 20 | first l|ink.... |
|00003e90| 20 20 20 20 3b 20 63 72 | 65 61 74 65 20 74 68 65 |    ; cr|eate the|
|00003ea0| 20 66 6f 72 6d 0d 0a 20 | 20 20 20 20 6e 65 77 46 | form.. |    newF|
|00003eb0| 6f 72 6d 2e 63 72 65 61 | 74 65 28 29 0d 0a 0d 0a |orm.crea|te()....|
|00003ec0| 20 20 20 20 20 6e 65 77 | 46 6f 72 6d 2e 64 6d 41 |     new|Form.dmA|
|00003ed0| 64 64 54 61 62 6c 65 28 | 66 69 72 73 74 54 61 62 |ddTable(|firstTab|
|00003ee0| 6c 65 29 0d 0a 20 20 20 | 20 20 6e 65 77 46 6f 72 |le)..   |  newFor|
|00003ef0| 6d 2e 64 6d 41 64 64 54 | 61 62 6c 65 28 73 65 63 |m.dmAddT|able(sec|
|00003f00| 6f 6e 64 54 61 62 6c 65 | 29 0d 0a 20 20 20 20 20 |ondTable|)..     |
|00003f10| 6e 65 77 46 6f 72 6d 2e | 64 6d 41 64 64 54 61 62 |newForm.|dmAddTab|
|00003f20| 6c 65 28 74 68 69 72 64 | 54 61 62 6c 65 29 0d 0a |le(third|Table)..|
|00003f30| 0d 0a 20 20 20 20 20 3b | 20 66 69 72 73 74 20 6c |..     ;| first l|
|00003f40| 69 6e 6b 0d 0a 20 20 20 | 20 20 69 66 20 6e 65 77 |ink..   |  if new|
|00003f50| 46 6f 72 6d 2e 64 6d 4c | 69 6e 6b 54 6f 46 69 65 |Form.dmL|inkToFie|
|00003f60| 6c 64 73 28 66 69 72 73 | 74 54 61 62 6c 65 2c 20 |lds(firs|tTable, |
|00003f70| 66 69 72 73 74 4b 65 79 | 41 72 2c 0d 0a 20 20 20 |firstKey|Ar,..   |
|00003f80| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |        |        |
|00003f90| 20 20 20 20 20 20 20 20 | 20 73 65 63 6f 6e 64 54 |        | secondT|
|00003fa0| 61 62 6c 65 2c 20 73 65 | 63 6f 6e 64 4b 65 79 41 |able, se|condKeyA|
|00003fb0| 72 29 20 74 68 65 6e 0d | 0a 0d 0a 20 20 20 20 20 |r) then.|...     |
|00003fc0| 20 20 20 3b 20 69 6e 69 | 74 69 61 6c 69 7a 65 20 |   ; ini|tialize |
|00003fd0| 61 72 72 61 79 73 20 66 | 6f 72 20 73 65 63 6f 6e |arrays f|or secon|
|00003fe0| 64 20 6c 69 6e 6b 0d 0a | 20 20 20 20 20 20 20 20 |d link..|        |
|00003ff0| 73 65 63 6f 6e 64 4b 65 | 79 41 72 5b 31 5d 20 3d |secondKe|yAr[1] =|
|00004000| 02 01 00 c3 0e 00 00 81 | 02 07 00 00 00 e2 0d 00 |........|........|
|00004010| 00 0a 00 11 00 00 00 03 | 00 08 00 00 00 02 00 0c |........|........|
|00004020| 00 00 00 04 00 08 00 00 | 00 06 00 6c 00 00 00 07 |........|...l....|
|00004030| 00 16 00 00 00 54 68 69 | 73 20 65 78 61 6d 70 6c |.....Thi|s exampl|
|00004040| 65 20 70 72 6f 63 65 73 | 73 65 73 20 61 20 77 69 |e proces|ses a wi|
|00004050| 74 68 64 72 61 77 61 6c | 20 6f 66 20 63 61 73 68 |thdrawal| of cash|
|00004060| 20 66 72 6f 6d 20 61 6e | 20 61 75 74 6f 6d 61 74 | from an| automat|
|00004070| 69 63 20 74 65 6c 6c 65 | 72 20 6d 61 63 68 69 6e |ic telle|r machin|
|00004080| 65 2e 20 54 68 65 20 63 | 61 6c 6c 20 74 6f 20 62 |e. The c|all to b|
|00004090| 65 67 69 6e 54 72 61 6e | 73 61 63 74 69 6f 6e 20 |eginTran|saction |
|000040a0| 73 74 61 72 74 73 20 61 | 20 74 72 61 6e 73 61 63 |starts a| transac|
|000040b0| 74 69 6f 6e 20 63 6f 6e | 73 69 73 74 69 6e 67 20 |tion con|sisting |
|000040c0| 6f 66 20 74 68 72 65 65 | 20 6f 70 65 72 61 74 69 |of three| operati|
|000040d0| 6f 6e 73 3a 20 64 65 62 | 69 74 69 6e 67 20 74 68 |ons: deb|iting th|
|000040e0| 65 20 63 75 73 74 6f 6d | 65 72 27 73 20 61 63 63 |e custom|er's acc|
|000040f0| 6f 75 6e 74 2c 20 64 65 | 62 69 74 69 6e 67 20 74 |ount, de|biting t|
|00004100| 68 65 20 63 61 73 68 20 | 6f 6e 20 68 61 6e 64 2c |he cash |on hand,|
|00004110| 20 61 6e 64 20 64 69 73 | 70 65 6e 73 69 6e 67 20 | and dis|pensing |
|00004120| 63 61 73 68 20 74 6f 20 | 74 68 65 20 63 75 73 74 |cash to |the cust|
|00004130| 6f 6d 65 72 2e 20 54 68 | 65 20 72 65 73 75 6c 74 |omer. Th|e result|
|00004140| 20 6f 66 20 65 61 63 68 | 20 6f 70 65 72 61 74 69 | of each| operati|
|00004150| 6f 6e 20 69 73 20 73 74 | 6f 72 65 64 20 69 6e 20 |on is st|ored in |
|00004160| 61 20 44 79 6e 41 72 72 | 61 79 2e 20 57 68 65 6e |a DynArr|ay. When|
|00004170| 20 61 6c 6c 20 74 68 65 | 20 6f 70 65 72 61 74 69 | all the| operati|
|00004180| 6f 6e 73 20 68 61 76 65 | 20 62 65 65 6e 20 63 6f |ons have| been co|
|00004190| 6d 70 6c 65 74 65 64 2c | 20 74 68 69 73 20 63 6f |mpleted,| this co|
|000041a0| 64 65 20 63 68 65 63 6b | 73 20 65 61 63 68 20 69 |de check|s each i|
|000041b0| 74 65 6d 20 69 6e 20 74 | 68 65 20 44 79 6e 41 72 |tem in t|he DynAr|
|000041c0| 72 61 79 20 61 6e 64 20 | 65 69 74 68 65 72 20 63 |ray and |either c|
|000041d0| 61 6c 6c 73 20 63 6f 6d | 6d 69 74 54 72 61 6e 73 |alls com|mitTrans|
|000041e0| 61 63 74 69 6f 6e 20 28 | 69 66 20 61 6c 6c 20 69 |action (|if all i|
|000041f0| 74 65 6d 73 20 61 72 65 | 20 54 72 75 65 29 20 6f |tems are| True) o|
|00004200| 72 20 72 6f 6c 6c 62 61 | 63 6b 54 72 61 6e 73 61 |r rollba|ckTransa|
|00004210| 63 74 69 6f 6e 20 28 69 | 66 20 61 6e 79 20 69 74 |ction (i|f any it|
|00004220| 65 6d 20 69 73 20 46 61 | 6c 73 65 29 2e 20 54 68 |em is Fa|lse). Th|
|00004230| 69 73 20 65 78 61 6d 70 | 6c 65 20 75 73 65 73 20 |is examp|le uses |
|00004240| 62 65 67 69 6e 54 72 61 | 6e 73 61 63 74 69 6f 6e |beginTra|nsaction|
|00004250| 2c 20 63 6f 6d 6d 69 74 | 54 72 61 6e 73 61 63 74 |, commit|Transact|
|00004260| 69 6f 6e 2c 20 72 6f 6c | 6c 62 61 63 6b 54 72 61 |ion, rol|lbackTra|
|00004270| 6e 73 61 63 74 69 6f 6e | 2c 20 74 72 61 6e 73 61 |nsaction|, transa|
|00004280| 63 74 69 6f 6e 41 63 74 | 69 76 65 2c 20 61 6e 64 |ctionAct|ive, and|
|00004290| 20 65 6e 75 6d 41 6c 69 | 61 73 4e 61 6d 65 73 2e | enumAli|asNames.|
|000042a0| 0d 0a 20 20 0d 0a 20 20 | 6d 65 74 68 6f 64 20 70 |..  ..  |method p|
|000042b0| 75 73 68 42 75 74 74 6f | 6e 28 76 61 72 20 65 76 |ushButto|n(var ev|
|000042c0| 65 6e 74 49 6e 66 6f 20 | 45 76 65 6e 74 29 0d 0a |entInfo |Event)..|
|000042d0| 20 20 0d 0a 20 20 20 20 | 20 76 61 72 0d 0a 20 20 |  ..    | var..  |
|000042e0| 20 20 20 20 20 20 6d 79 | 51 42 45 09 09 51 75 65 |      my|QBE..Que|
|000042f0| 72 79 0d 0a 20 20 20 20 | 20 20 20 20 64 62 09 09 |ry..    |    db..|
|00004300| 09 44 61 74 61 62 61 73 | 65 0d 0a 20 20 20 20 20 |.Databas|e..     |
|00004310| 20 20 20 6f 70 52 65 73 | 75 6c 74 09 09 44 79 6e |   opRes|ult..Dyn|
|00004320| 41 72 72 61 79 5b 20 5d | 20 4c 6f 67 69 63 61 6c |Array[ ]| Logical|
|00004330| 0d 0a 20 20 20 20 20 20 | 20 20 45 6c 65 6d 65 6e |..      |  Elemen|
|00004340| 74 09 09 41 6e 79 54 79 | 70 65 0d 0a 20 20 20 20 |t..AnyTy|pe..    |
|00004350| 20 20 20 20 41 6c 6c 5f | 4f 4b 09 09 4c 6f 67 69 |    All_|OK..Logi|
|00004360| 63 61 6c 0d 0a 20 20 20 | 20 20 20 20 20 73 65 72 |cal..   |     ser|
|00004370| 76 65 72 54 79 70 65 2c | 0d 0a 20 20 20 20 20 20 |verType,|..      |
|00004380| 20 20 6d 79 41 6c 69 61 | 73 2c 0d 0a 20 20 20 20 |  myAlia|s,..    |
|00004390| 20 20 20 20 63 75 73 74 | 49 44 09 09 53 74 72 69 |    cust|ID..Stri|
|000043a0| 6e 67 20 0d 0a 20 20 20 | 20 20 20 20 20 61 6c 69 |ng ..   |     ali|
|000043b0| 61 73 4e 61 6d 54 43 09 | 54 43 75 72 73 6f 72 0d |asNamTC.|TCursor.|
|000043c0| 0a 20 20 20 20 20 20 20 | 20 78 41 6d 6f 75 6e 74 |.       | xAmount|
|000043d0| 09 09 43 75 72 72 65 6e | 63 79 0d 0a 20 20 20 20 |..Curren|cy..    |
|000043e0| 20 20 20 20 78 44 61 74 | 65 09 09 44 61 74 65 0d |    xDat|e..Date.|
|000043f0| 0a 20 20 20 20 20 20 20 | 20 78 54 69 6d 65 09 09 |.       | xTime..|
|00004400| 54 69 6d 65 0d 0a 20 20 | 20 20 20 65 6e 64 76 61 |Time..  |   endva|
|00004410| 72 0d 0a 20 20 0d 0a 20 | 20 0d 0a 20 20 0d 0a 20 |r..  .. | ..  .. |
|00004420| 20 20 20 20 3b 20 49 6e | 69 74 69 61 6c 69 7a 65 |    ; In|itialize|
|00004430| 20 76 61 72 69 61 62 6c | 65 73 0d 0a 20 20 0d 0a | variabl|es..  ..|
|00004440| 20 20 20 20 20 6d 79 41 | 6c 69 61 73 20 3d 20 22 |     myA|lias = "|
|00004450| 49 54 43 48 59 22 0d 0a | 20 20 20 20 20 63 75 73 |ITCHY"..|     cus|
|00004460| 74 49 44 20 3d 20 22 52 | 48 41 4c 4c 30 30 31 22 |tID = "R|HALL001"|
|00004470| 0d 0a 20 20 20 20 20 78 | 41 6d 6f 75 6e 74 20 3d |..     x|Amount =|
|00004480| 20 43 75 72 72 65 6e 63 | 79 28 31 32 30 2e 30 30 | Currenc|y(120.00|
|00004490| 29 0d 0a 20 20 20 20 20 | 78 44 61 74 65 20 3d 20 |)..     |xDate = |
|000044a0| 74 6f 64 61 79 28 29 09 | 09 09 3b 20 52 65 74 75 |today().|..; Retu|
|000044b0| 72 6e 73 20 63 75 72 72 | 65 6e 74 20 64 61 74 65 |rns curr|ent date|
|000044c0| 0d 0a 20 20 20 20 20 78 | 54 69 6d 65 20 3d 20 74 |..     x|Time = t|
|000044d0| 69 6d 65 28 29 09 09 09 | 3b 20 52 65 74 75 72 6e |ime()...|; Return|
|000044e0| 73 20 63 75 72 72 65 6e | 74 20 74 69 6d 65 0d 0a |s curren|t time..|
|000044f0| 20 20 0d 0a 20 20 20 20 | 20 65 6e 75 6d 41 6c 69 |  ..    | enumAli|
|00004500| 61 73 4e 61 6d 65 73 28 | 22 61 6c 69 61 73 4e 61 |asNames(|"aliasNa|
|00004510| 6d 2e 64 62 22 29 09 3b | 20 4c 69 73 74 20 61 6c |m.db").;| List al|
|00004520| 69 61 73 65 73 20 6b 6e | 6f 77 6e 20 74 6f 20 74 |iases kn|own to t|
|00004530| 68 65 20 73 79 73 74 65 | 6d 0d 0a 20 20 0d 0a 20 |he syste|m..  .. |
|00004540| 20 20 20 20 61 6c 69 61 | 73 4e 61 6d 54 43 2e 6f |    alia|sNamTC.o|
|00004550| 70 65 6e 28 22 61 6c 69 | 61 73 4e 61 6d 2e 64 62 |pen("ali|asNam.db|
|00004560| 22 29 0d 0a 20 20 0d 0a | 20 20 20 20 20 69 66 20 |")..  ..|     if |
|00004570| 61 6c 69 61 73 4e 61 6d | 54 43 2e 6c 6f 63 61 74 |aliasNam|TC.locat|
|00004580| 65 28 22 44 42 4e 61 6d | 65 22 2c 20 6d 79 41 6c |e("DBNam|e", myAl|
|00004590| 69 61 73 29 20 74 68 65 | 6e 0d 0a 20 20 20 20 20 |ias) the|n..     |
|000045a0| 20 20 20 64 62 2e 6f 70 | 65 6e 28 6d 79 41 6c 69 |   db.op|en(myAli|
|000045b0| 61 73 29 09 09 3b 20 55 | 73 65 20 61 6c 69 61 73 |as)..; U|se alias|
|000045c0| 20 74 6f 20 67 65 74 20 | 68 61 6e 64 6c 65 20 74 | to get |handle t|
|000045d0| 6f 20 73 65 72 76 65 72 | 0d 0a 20 20 20 20 20 65 |o server|..     e|
|000045e0| 6c 73 65 0d 0a 20 20 20 | 20 20 20 20 20 6d 73 67 |lse..   |     msg|
|000045f0| 53 74 6f 70 28 22 50 72 | 6f 62 6c 65 6d 22 2c 20 |Stop("Pr|oblem", |
|00004600| 22 54 68 65 20 61 6c 69 | 61 73 20 22 20 2b 20 6d |"The ali|as " + m|
|00004610| 79 41 6c 69 61 73 20 2b | 20 22 20 68 61 73 20 6e |yAlias +| " has n|
|00004620| 6f 74 20 62 65 65 6e 20 | 64 65 66 69 6e 65 64 2e |ot been |defined.|
|00004630| 22 29 0d 0a 20 20 20 20 | 20 20 20 20 72 65 74 75 |")..    |    retu|
|00004640| 72 6e 09 09 09 09 3b 20 | 45 78 69 74 20 74 68 65 |rn....; |Exit the|
|00004650| 20 6d 65 74 68 6f 64 0d | 0a 20 20 20 20 20 65 6e | method.|.     en|
|00004660| 64 49 66 20 0d 0a 20 20 | 0d 0a 20 20 20 20 20 69 |dIf ..  |..     i|
|00004670| 66 20 64 62 2e 74 72 61 | 6e 73 61 63 74 69 6f 6e |f db.tra|nsaction|
|00004680| 41 63 74 69 76 65 28 29 | 20 74 68 65 6e 0d 0a 20 |Active()| then.. |
|00004690| 20 20 20 20 20 20 20 64 | 62 2e 63 6f 6d 6d 69 74 |       d|b.commit|
|000046a0| 54 72 61 6e 73 61 63 74 | 69 6f 6e 28 29 09 3b 20 |Transact|ion().; |
|000046b0| 43 6f 6d 6d 69 74 20 61 | 6e 79 20 70 72 65 76 69 |Commit a|ny previ|
|000046c0| 6f 75 73 20 74 72 61 6e | 73 61 63 74 69 6f 6e 0d |ous tran|saction.|
|000046d0| 0a 20 20 20 20 20 65 6e | 64 49 66 0d 0a 20 20 0d |.     en|dIf..  .|
|000046e0| 0a 20 20 20 20 20 64 62 | 2e 62 65 67 69 6e 54 72 |.     db|.beginTr|
|000046f0| 61 6e 73 61 63 74 69 6f | 6e 28 29 09 09 3b 20 42 |ansactio|n()..; B|
|00004700| 65 67 69 6e 20 61 20 54 | 72 61 6e 61 63 74 69 6f |egin a T|ranactio|
|00004710| 6e 0d 0a 20 20 0d 0a 20 | 20 20 20 20 3b 20 45 78 |n..  .. |    ; Ex|
|00004720| 65 63 75 74 65 20 74 68 | 65 20 6f 70 65 72 61 74 |ecute th|e operat|
|00004730| 69 6f 6e 73 20 66 6f 72 | 20 74 68 69 73 20 74 72 |ions for| this tr|
|00004740| 61 6e 73 61 63 74 69 6f | 6e 2e 0d 0a 20 20 20 20 |ansactio|n...    |
|00004750| 20 3b 20 64 65 62 69 74 | 41 63 63 6f 75 6e 74 2c | ; debit|Account,|
|00004760| 20 64 65 62 69 74 43 61 | 73 68 4f 6e 48 61 6e 64 | debitCa|shOnHand|
|00004770| 2c 20 61 6e 64 20 64 69 | 73 70 65 6e 73 65 43 61 |, and di|spenseCa|
|00004780| 73 68 20 0d 0a 20 20 20 | 20 20 3b 20 61 72 65 20 |sh ..   |  ; are |
|00004790| 63 75 73 74 6f 6d 20 70 | 72 6f 63 73 20 61 73 73 |custom p|rocs ass|
|000047a0| 75 6d 65 64 20 74 6f 20 | 62 65 20 64 65 66 69 6e |umed to |be defin|
|000047b0| 65 64 20 65 6c 73 65 77 | 68 65 72 65 2e 0d 0a 20 |ed elsew|here... |
|000047c0| 20 0d 0a 20 20 20 20 20 | 3b 20 41 66 74 65 72 20 | ..     |; After |
|000047d0| 63 61 6c 6c 69 6e 67 20 | 64 65 62 69 74 41 63 63 |calling |debitAcc|
|000047e0| 6f 75 6e 74 20 61 6e 64 | 20 64 65 62 69 74 43 61 |ount and| debitCa|
|000047f0| 73 68 4f 6e 48 61 6e 64 | 2c 20 74 68 65 20 63 6f |shOnHand|, the co|
|00004800| 64 65 0d 0a 20 20 20 20 | 20 3b 20 63 61 6c 6c 73 |de..    | ; calls|
|00004810| 20 74 72 61 6e 73 61 63 | 74 69 6f 6e 41 63 74 69 | transac|tionActi|
|00004820| 76 65 20 74 6f 20 63 68 | 65 63 6b 20 74 68 65 20 |ve to ch|eck the |
|00004830| 74 72 61 6e 73 61 63 74 | 69 6f 6e 20 73 74 61 74 |transact|ion stat|
|00004840| 75 73 0d 0a 20 20 20 20 | 20 3b 20 62 65 66 6f 72 |us..    | ; befor|
|00004850| 65 20 63 61 6c 6c 69 6e | 67 20 64 69 73 70 65 6e |e callin|g dispen|
|00004860| 73 65 43 61 73 68 2e 0d | 0a 20 20 0d 0a 20 20 20 |seCash..|.  ..   |
|00004870| 20 20 6f 70 52 65 73 75 | 6c 74 5b 22 44 65 62 69 |  opResu|lt["Debi|
|00004880| 74 20 63 75 73 74 6f 6d | 65 72 20 61 63 63 6f 75 |t custom|er accou|
|00004890| 6e 74 22 5d 20 3d 20 64 | 65 62 69 74 41 63 63 6f |nt"] = d|ebitAcco|
|000048a0| 75 6e 74 28 63 75 73 74 | 49 44 2c 20 78 41 6d 6f |unt(cust|ID, xAmo|
|000048b0| 75 6e 74 29 0d 0a 20 20 | 20 20 20 6f 70 52 65 73 |unt)..  |   opRes|
|000048c0| 75 6c 74 5b 22 44 65 62 | 69 74 20 63 61 73 68 20 |ult["Deb|it cash |
|000048d0| 6f 6e 20 68 61 6e 64 22 | 5d 20 3d 20 0d 0a 20 20 |on hand"|] = ..  |
|000048e0| 20 20 20 64 65 62 69 74 | 43 61 73 68 4f 6e 48 61 |   debit|CashOnHa|
|000048f0| 6e 64 28 78 41 6d 6f 75 | 6e 74 2c 20 78 44 61 74 |nd(xAmou|nt, xDat|
|00004900| 65 2c 20 78 54 69 6d 65 | 29 0d 0a 20 20 0d 0a 20 |e, xTime|)..  .. |
|00004910| 20 20 20 20 3b 20 54 68 | 65 20 66 6f 6c 6c 6f 77 |    ; Th|e follow|
|00004920| 69 6e 67 20 69 66 2e 2e | 2e 74 68 65 6e 2e 2e 2e |ing if..|.then...|
|00004930| 65 6c 73 65 20 62 6c 6f | 63 6b 20 69 73 20 6e 6f |else blo|ck is no|
|00004940| 74 20 72 65 71 75 69 72 | 65 64 2e 0d 0a 20 20 20 |t requir|ed...   |
|00004950| 20 20 3b 20 49 74 27 73 | 20 69 6e 63 6c 75 64 65 |  ; It's| include|
|00004960| 64 20 74 6f 20 73 68 6f | 77 20 6f 6e 65 20 77 61 |d to sho|w one wa|
|00004970| 79 20 74 6f 20 75 73 65 | 20 74 72 61 6e 73 61 63 |y to use| transac|
|00004980| 74 69 6f 6e 41 63 74 69 | 76 65 2e 0d 0a 20 20 0d |tionActi|ve...  .|
|00004990| 0a 20 20 20 20 20 69 66 | 20 64 62 2e 74 72 61 6e |.     if| db.tran|
|000049a0| 73 61 63 74 69 6f 6e 41 | 63 74 69 76 65 28 29 20 |sactionA|ctive() |
|000049b0| 74 68 65 6e 09 09 3b 20 | 4d 61 6b 65 20 73 75 72 |then..; |Make sur|
|000049c0| 65 20 65 76 65 72 79 74 | 68 69 6e 67 20 69 73 20 |e everyt|hing is |
|000049d0| 4f 4b 0d 0a 20 20 20 20 | 20 20 20 20 6d 73 67 49 |OK..    |    msgI|
|000049e0| 6e 66 6f 28 22 54 72 61 | 6e 73 61 63 74 69 6f 6e |nfo("Tra|nsaction|
|000049f0| 20 53 74 61 74 75 73 22 | 2c 20 22 49 6e 20 61 20 | Status"|, "In a |
|00004a00| 54 72 61 6e 73 61 63 74 | 69 6f 6e 22 29 0d 0a 20 |Transact|ion").. |
|00004a10| 20 20 20 20 65 6c 73 65 | 0d 0a 20 20 20 20 20 20 |    else|..      |
|00004a20| 20 20 65 72 72 6f 72 53 | 68 6f 77 28 22 4e 4f 54 |  errorS|how("NOT|
|00004a30| 20 69 6e 20 61 20 54 72 | 61 6e 73 61 63 74 69 6f | in a Tr|ansactio|
|00004a40| 6e 22 29 0d 0a 20 20 20 | 20 20 20 20 20 72 65 74 |n")..   |     ret|
|00004a50| 75 72 6e 20 0d 0a 20 20 | 20 20 20 65 6e 64 69 66 |urn ..  |   endif|
|00004a60| 0d 0a 20 20 0d 0a 20 20 | 20 20 20 6f 70 52 65 73 |..  ..  |   opRes|
|00004a70| 75 6c 74 5b 22 44 69 73 | 70 65 6e 73 65 20 63 61 |ult["Dis|pense ca|
|00004a80| 73 68 22 5d 20 3d 20 64 | 69 73 70 65 6e 73 65 43 |sh"] = d|ispenseC|
|00004a90| 61 73 68 28 78 41 6d 6f | 75 6e 74 29 20 0d 0a 20 |ash(xAmo|unt) .. |
|00004aa0| 20 20 20 20 41 6c 6c 5f | 4f 4b 20 3d 20 54 72 75 |    All_|OK = Tru|
|00004ab0| 65 09 09 09 09 3b 20 49 | 6e 69 74 69 61 6c 69 7a |e....; I|nitializ|
|00004ac0| 65 20 74 6f 20 54 72 75 | 65 0d 0a 20 20 0d 0a 20 |e to Tru|e..  .. |
|00004ad0| 20 20 20 20 66 6f 72 45 | 61 63 68 20 65 6c 65 6d |    forE|ach elem|
|00004ae0| 65 6e 74 20 69 6e 20 6f | 70 52 65 73 75 6c 74 09 |ent in o|pResult.|
|00004af0| 09 3b 20 43 68 65 63 6b | 20 6f 70 65 72 61 74 69 |.; Check| operati|
|00004b00| 6f 6e 20 72 65 73 75 6c | 74 73 0d 0a 20 20 20 20 |on resul|ts..    |
|00004b10| 20 20 20 20 69 66 20 6f | 70 52 65 73 75 6c 74 5b |    if o|pResult[|
|00004b20| 65 6c 65 6d 65 6e 74 5d | 20 3d 20 46 61 6c 73 65 |element]| = False|
|00004b30| 20 74 68 65 6e 20 0d 0a | 20 20 20 20 20 20 20 20 | then ..|        |
|00004b40| 20 20 20 41 6c 6c 5f 4f | 4b 20 3d 20 46 61 6c 73 |   All_O|K = Fals|
|00004b50| 65 0d 0a 20 20 20 20 20 | 20 20 20 20 20 20 71 75 |e..     |      qu|
|00004b60| 69 74 4c 6f 6f 70 20 0d | 0a 20 20 20 20 20 20 20 |itLoop .|.       |
|00004b70| 20 65 6e 64 49 66 0d 0a | 20 20 20 20 20 65 6e 64 | endIf..|     end|
|00004b80| 46 6f 72 45 61 63 68 0d | 0a 20 20 0d 0a 20 20 20 |ForEach.|.  ..   |
|00004b90| 20 20 3b 20 49 6e 66 6f | 72 6d 20 75 73 65 72 20 |  ; Info|rm user |
|00004ba0| 6f 66 20 74 72 61 6e 73 | 61 63 74 69 6f 6e 20 73 |of trans|action s|
|00004bb0| 74 61 74 75 73 0d 0a 20 | 20 0d 0a 20 20 20 20 20 |tatus.. | ..     |
|00004bc0| 69 66 20 41 6c 6c 5f 4f | 4b 20 74 68 65 6e 0d 0a |if All_O|K then..|
|00004bd0| 20 20 20 20 20 20 20 20 | 69 66 20 64 62 2e 63 6f |        |if db.co|
|00004be0| 6d 6d 69 74 54 72 61 6e | 73 61 63 74 69 6f 6e 28 |mmitTran|saction(|
|00004bf0| 29 20 74 68 65 6e 0d 0a | 20 20 20 20 20 20 20 20 |) then..|        |
|00004c00| 20 20 20 6d 73 67 49 6e | 66 6f 28 22 54 72 61 6e |   msgIn|fo("Tran|
|00004c10| 73 61 63 74 69 6f 6e 20 | 53 74 61 74 75 73 22 2c |saction |Status",|
|00004c20| 22 54 72 61 6e 73 61 63 | 74 69 6f 6e 20 63 6f 6d |"Transac|tion com|
|00004c30| 6d 69 74 74 65 64 2e 22 | 29 0d 0a 20 20 20 20 20 |mitted."|)..     |
|00004c40| 20 20 20 65 6c 73 65 0d | 0a 20 20 20 20 20 20 20 |   else.|.       |
|00004c50| 20 20 20 20 65 72 72 6f | 72 53 68 6f 77 28 22 54 |    erro|rShow("T|
|00004c60| 72 61 6e 73 61 63 74 69 | 6f 6e 20 4e 4f 54 20 63 |ransacti|on NOT c|
|00004c70| 6f 6d 6d 69 74 74 65 64 | 22 29 0d 0a 20 20 20 20 |ommitted|")..    |
|00004c80| 20 20 20 20 65 6e 64 49 | 66 0d 0a 20 20 20 20 20 |    endI|f..     |
|00004c90| 65 6c 73 65 0d 0a 20 20 | 20 20 20 20 20 20 20 69 |else..  |       i|
|00004ca0| 66 20 6d 73 67 51 75 65 | 73 74 69 6f 6e 28 22 54 |f msgQue|stion("T|
|00004cb0| 72 61 6e 73 61 63 74 69 | 6f 6e 20 66 61 69 6c 65 |ransacti|on faile|
|00004cc0| 64 22 2c 20 22 56 69 65 | 77 20 72 65 73 75 6c 74 |d", "Vie|w result|
|00004cd0| 73 3f 22 29 20 3d 20 22 | 59 65 73 22 20 74 68 65 |s?") = "|Yes" the|
|00004ce0| 6e 0d 0a 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |n..     |        |
|00004cf0| 20 6f 70 52 65 73 75 6c | 74 2e 76 69 65 77 28 22 | opResul|t.view("|
|00004d00| 4f 70 65 72 61 74 69 6f | 6e 20 72 65 73 75 6c 74 |Operatio|n result|
|00004d10| 73 22 29 0d 0a 20 20 20 | 20 20 20 20 20 20 65 6e |s")..   |      en|
|00004d20| 64 49 66 20 0d 0a 20 20 | 0d 0a 20 20 20 20 20 20 |dIf ..  |..      |
|00004d30| 20 20 20 69 66 20 64 62 | 2e 72 6f 6c 6c 62 61 63 |   if db|.rollbac|
|00004d40| 6b 54 72 61 6e 73 61 63 | 74 69 6f 6e 28 29 20 74 |kTransac|tion() t|
|00004d50| 68 65 6e 0d 0a 20 20 20 | 20 20 20 20 20 20 20 20 |hen..   |        |
|00004d60| 20 20 20 6d 73 67 49 6e | 66 6f 28 22 54 72 61 6e |   msgIn|fo("Tran|
|00004d70| 73 61 63 74 69 6f 6e 20 | 53 74 61 74 75 73 22 2c |saction |Status",|
|00004d80| 20 22 54 72 61 6e 73 61 | 63 74 69 6f 6e 20 72 6f | "Transa|ction ro|
|00004d90| 6c 6c 65 64 20 62 61 63 | 6b 2e 22 29 0d 0a 20 20 |lled bac|k.")..  |
|00004da0| 20 20 20 20 20 20 20 65 | 6c 73 65 0d 0a 20 20 20 |       e|lse..   |
|00004db0| 20 20 20 20 20 20 20 20 | 20 20 20 65 72 72 6f 72 |        |   error|
|00004dc0| 53 68 6f 77 28 22 54 72 | 61 6e 73 61 63 74 69 6f |Show("Tr|ansactio|
|00004dd0| 6e 20 4e 4f 54 20 72 6f | 6c 6c 65 64 20 62 61 63 |n NOT ro|lled bac|
|00004de0| 6b 2e 22 29 0d 0a 20 20 | 20 20 20 20 20 20 20 65 |k.")..  |       e|
|00004df0| 6e 64 49 66 0d 0a 20 20 | 20 20 20 65 6e 64 64 69 |ndIf..  |   enddi|
|00004e00| 66 0d 0a 20 20 0d 0a 20 | 20 65 6e 64 6d 65 74 68 |f..  .. | endmeth|
|00004e10| 6f 64 0d 0a 20 20 00 02 | 00 01 00 d8 36 24 00 00 |od..  ..|....6$..|
|00004e20| 02 00 02 00 01 00 01 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004e30| 00 00 00 00 01 80 71 02 | 00 00 02 80 00 00 00 00 |......q.|........|
|00004e40| 01 80 00 00 02 00 c8 00 | 00 00 00 00 90 01 00 00 |........|........|
|00004e50| 00 00 00 00 00 00 00 00 | 01 22 00 06 41 72 69 61 |........|."..Aria|
|00004e60| 6c 00 c7 37 40 02 1f 35 | 1b 00 05 00 c3 05 c7 37 |l..7@..5|.......7|
|00004e70| ee 37 1c 37 87 00 82 00 | f6 89 79 07 c8 00 00 00 |.7.7....|..y.....|
|00004e80| 00 00 90 01 00 00 00 00 | 00 00 00 00 00 00 01 31 |........|.......1|
|00004e90| 00 04 43 6f 75 72 69 65 | 72 20 4e 65 77 00 05 00 |..Courie|r New...|
|00004ea0| 05 00 c3 05 67 1b 06 14 | 54 24 19 00 14 00 c6 89 |....g...|T$......|
|00004eb0| 79 07 01 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |y.......|........|
|00004ec0| 98 0f 8f 09 d0 02 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004ed0| 00 00 00 00 01 22 00 06 | 41 72 69 61 6c 00 b7 1e |....."..|Arial...|
|00004ee0| 1e 52 df 2e a6 4e df 2e | 80 8a 00 00 b0 02 3e 69 |.R...N..|......>i|
|00004ef0| df 2e 00 00 dc 89 60 07 | 01 00 00 00 00 00 00 00 |......`.|........|
|00004f00| 00 00 00 00 00 00 98 0f | 8f 09 d0 02 00 00 00 00 |........|........|
|00004f10| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004f20| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004f30| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004f40| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004f50| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004f60| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004f70| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004f80| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004f90| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004fa0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004fb0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004fc0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004fd0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004fe0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004ff0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005000| 03 01 00 4c e5 33 68 dd | 59 8b 20 00 00 00 00 00 |...L.3h.|Y. .....|
|00005010| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005020| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005030| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005040| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005050| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005060| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005070| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005080| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005090| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000050a0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000050b0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000050c0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000050d0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000050e0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000050f0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005100| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005110| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005120| 0e 00 00 01 00 0e 00 00 | 01 00 0e 00 00 01 00 22 |........|......."|
|00005130| 00 00 08 00 1d 00 00 0e | 00 3d 00 00 0f 4b 45 3a |........|.=...KE:|
|00005140| 02 07 15 36 15 02 0e 90 | 4a 82 02 01 00 00 00 00 |...6....|J.......|
|00005150| 07 00 00 00 7d 02 00 00 | 0a 00 11 00 00 00 03 00 |....}...|........|
|00005160| 08 00 00 00 02 00 0c 00 | 00 00 04 00 08 00 00 00 |........|........|
|00005170| 06 00 6c 00 00 00 07 00 | 16 00 00 00 54 68 69 73 |..l.....|....This|
|00005180| 20 65 78 61 6d 70 6c 65 | 20 6c 6f 61 64 73 20 61 | example| loads a|
|00005190| 20 66 6f 72 6d 20 61 6e | 64 20 73 65 6c 65 63 74 | form an|d select|
|000051a0| 73 20 74 77 6f 20 6f 62 | 6a 65 63 74 73 2c 20 74 |s two ob|jects, t|
|000051b0| 68 65 6e 20 6c 6f 61 64 | 73 20 61 20 72 65 70 6f |hen load|s a repo|
|000051c0| 72 74 20 61 6e 64 20 73 | 65 6c 65 63 74 73 20 6f |rt and s|elects o|
|000051d0| 6e 65 20 6f 62 6a 65 63 | 74 2c 20 74 68 65 6e 20 |ne objec|t, then |
|000051e0| 63 6c 6f 73 65 73 20 74 | 68 65 20 66 6f 72 6d 20 |closes t|he form |
|000051f0| 61 6e 64 20 72 65 70 6f | 72 74 2e 20 44 69 61 6c |and repo|rt. Dial|
|00005200| 6f 67 20 62 6f 78 65 73 | 20 61 70 70 65 61 72 20 |og boxes| appear |
|00005210| 61 75 74 6f 6d 61 74 69 | 63 61 6c 6c 79 20 61 73 |automati|cally as|
|00005220| 6b 69 6e 67 20 69 66 20 | 79 6f 75 20 77 61 6e 74 |king if |you want|
|00005230| 20 74 6f 20 73 61 76 65 | 20 74 68 65 20 66 6f 72 | to save| the for|
|00005240| 6d 20 61 6e 64 20 72 65 | 70 6f 72 74 2e 0d 0a 0d |m and re|port....|
|00005250| 0a 20 20 6d 65 74 68 6f | 64 20 70 75 73 68 42 75 |.  metho|d pushBu|
|00005260| 74 74 6f 6e 28 76 61 72 | 20 65 76 65 6e 74 49 6e |tton(var| eventIn|
|00005270| 66 6f 20 45 76 65 6e 74 | 29 0d 0a 20 20 20 20 20 |fo Event|)..     |
|00005280| 76 61 72 0d 0a 20 20 20 | 20 20 20 20 20 66 09 46 |var..   |     f.F|
|00005290| 6f 72 6d 0d 0a 20 20 20 | 20 20 20 20 20 72 09 52 |orm..   |     r.R|
|000052a0| 65 70 6f 72 74 0d 0a 20 | 20 20 20 20 65 6e 64 56 |eport.. |    endV|
|000052b0| 61 72 0d 0a 0d 0a 20 20 | 20 20 20 66 2e 6c 6f 61 |ar....  |   f.loa|
|000052c0| 64 28 22 6f 72 64 65 72 | 73 22 29 0d 0a 20 20 20 |d("order|s")..   |
|000052d0| 20 20 66 2e 41 6d 6f 75 | 6e 74 5f 50 61 69 64 2e |  f.Amou|nt_Paid.|
|000052e0| 53 65 6c 65 63 74 20 3d | 20 54 72 75 65 0d 0a 20 |Select =| True.. |
|000052f0| 20 20 20 20 66 2e 54 65 | 72 6d 73 2e 53 65 6c 65 |    f.Te|rms.Sele|
|00005300| 63 74 20 3d 20 54 72 75 | 65 0d 0a 20 20 20 20 20 |ct = Tru|e..     |
|00005310| 73 6c 65 65 70 28 35 30 | 30 30 29 0d 0a 20 20 20 |sleep(50|00)..   |
|00005320| 20 20 66 2e 63 6c 6f 73 | 65 28 29 09 3b 20 61 20 |  f.clos|e().; a |
|00005330| 64 69 61 6c 6f 67 20 62 | 6f 78 20 61 73 6b 73 20 |dialog b|ox asks |
|00005340| 69 66 20 79 6f 75 20 77 | 61 6e 74 20 74 6f 20 73 |if you w|ant to s|
|00005350| 61 76 65 20 74 68 65 20 | 66 6f 72 6d 0d 0a 0d 0a |ave the |form....|
|00005360| 20 20 20 20 20 72 2e 6c | 6f 61 64 28 22 63 75 73 |     r.l|oad("cus|
|00005370| 74 6f 6d 65 72 22 29 0d | 0a 20 20 20 20 20 72 2e |tomer").|.     r.|
|00005380| 43 69 74 79 2e 53 65 6c | 65 63 74 20 3d 20 54 72 |City.Sel|ect = Tr|
|00005390| 75 65 0d 0a 20 20 20 20 | 20 73 6c 65 65 70 28 35 |ue..    | sleep(5|
|000053a0| 30 30 30 29 0d 0a 20 20 | 20 20 20 72 2e 63 6c 6f |000)..  |   r.clo|
|000053b0| 73 65 28 29 09 3b 20 61 | 20 64 69 61 6c 6f 67 20 |se().; a| dialog |
|000053c0| 62 6f 78 20 61 73 6b 73 | 20 69 66 20 79 6f 75 20 |box asks| if you |
|000053d0| 77 61 6e 74 20 74 6f 20 | 73 61 76 65 20 74 68 65 |want to |save the|
|000053e0| 20 72 65 70 6f 72 74 0d | 0a 0d 0a 20 20 65 6e 64 | report.|...  end|
|000053f0| 4d 65 74 68 6f 64 0d 0a | 00 02 00 01 00 d8 36 24 |Method..|......6$|
|00005400| 00 00 02 00 02 00 01 00 | 01 00 00 00 00 00 00 00 |........|........|
|00005410| 00 00 00 00 00 00 01 80 | d5 00 00 00 02 80 00 00 |........|........|
|00005420| 00 00 01 80 00 00 02 00 | c8 00 00 00 00 00 90 01 |........|........|
|00005430| 00 00 00 00 00 00 00 00 | 00 00 01 22 00 06 41 72 |........|..."..Ar|
|00005440| 69 61 6c 00 67 1b 40 02 | 67 2f 05 00 05 00 c3 05 |ial.g.@.|g/......|
|00005450| 67 1b 06 14 54 24 19 00 | 14 00 c6 89 79 07 c8 00 |g...T$..|....y...|
|00005460| 00 00 00 00 90 01 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005470| 01 31 00 04 43 6f 75 72 | 69 65 72 20 4e 65 77 00 |.1..Cour|ier New.|
|00005480| 05 00 05 00 c3 05 67 1b | 06 14 54 24 19 00 14 00 |......g.|..T$....|
|00005490| c6 89 79 07 01 00 00 00 | 00 00 00 00 00 00 00 00 |..y.....|........|
|000054a0| 00 00 98 0f bf 08 d0 02 | 00 00 00 00 00 00 00 00 |........|........|
|000054b0| 07 00 00 00 60 03 00 00 | 0a 00 11 00 00 00 03 00 |....`...|........|
|000054c0| 08 00 00 00 02 00 12 00 | 00 00 04 00 08 00 00 00 |........|........|
|000054d0| 06 00 6c 00 00 00 07 00 | 16 00 00 00 49 6e 76 6f |..l.....|....Invo|
|000054e0| 6b 65 73 20 74 68 65 20 | 46 69 78 65 64 20 4c 65 |kes the |Fixed Le|
|000054f0| 6e 67 74 68 20 41 53 43 | 49 49 20 49 6d 70 6f 72 |ngth ASC|II Impor|
|00005500| 74 20 64 69 61 6c 6f 67 | 20 62 6f 78 2c 20 6a 75 |t dialog| box, ju|
|00005510| 73 74 20 61 73 20 69 66 | 20 79 6f 75 20 68 61 64 |st as if| you had|
|00005520| 20 63 68 6f 73 65 6e 20 | 46 69 6c 65 7c 55 74 69 | chosen |File|Uti|
|00005530| 6c 69 74 69 65 73 7c 49 | 6d 70 6f 72 74 2c 20 73 |lities|I|mport, s|
|00005540| 70 65 63 69 66 69 65 64 | 20 46 69 78 65 64 20 4c |pecified| Fixed L|
|00005550| 65 6e 67 74 68 20 66 6f | 72 20 74 68 65 20 74 79 |ength fo|r the ty|
|00005560| 70 65 2c 20 61 6e 64 20 | 65 6e 74 65 72 65 64 20 |pe, and |entered |
|00005570| 61 20 66 69 6c 65 20 6e | 61 6d 65 2e 20 54 68 65 |a file n|ame. The|
|00005580| 20 66 69 6c 65 4e 61 6d | 65 20 61 72 67 75 6d 65 | fileNam|e argume|
|00005590| 6e 74 20 73 70 65 63 69 | 66 69 65 73 20 62 6f 74 |nt speci|fies bot|
|000055a0| 68 20 74 68 65 20 6e 61 | 6d 65 20 6f 66 20 74 68 |h the na|me of th|
|000055b0| 65 20 73 6f 75 72 63 65 | 20 66 69 6c 65 20 61 6e |e source| file an|
|000055c0| 64 20 74 68 65 20 6e 61 | 6d 65 20 6f 66 20 74 68 |d the na|me of th|
|000055d0| 65 20 64 65 73 74 69 6e | 61 74 69 6f 6e 20 74 61 |e destin|ation ta|
|000055e0| 62 6c 65 20 66 6f 72 20 | 74 68 65 20 69 6d 70 6f |ble for |the impo|
|000055f0| 72 74 65 64 20 64 61 74 | 61 2e 20 49 66 20 79 6f |rted dat|a. If yo|
|00005600| 75 20 73 70 65 63 69 66 | 79 20 61 20 66 69 6c 65 |u specif|y a file|
|00005610| 2d 6e 61 6d 65 20 65 78 | 74 65 6e 73 69 6f 6e 2c |-name ex|tension,|
|00005620| 20 50 61 72 61 64 6f 78 | 20 75 73 65 73 20 69 74 | Paradox| uses it|
|00005630| 20 74 6f 20 66 69 6e 64 | 20 74 68 65 20 73 6f 75 | to find| the sou|
|00005640| 72 63 65 20 66 69 6c 65 | 2c 20 62 75 74 20 74 68 |rce file|, but th|
|00005650| 65 20 66 69 6c 65 2d 6e | 61 6d 65 20 65 78 74 65 |e file-n|ame exte|
|00005660| 6e 73 69 6f 6e 20 6f 66 | 20 74 68 65 20 64 65 73 |nsion of| the des|
|00005670| 74 69 6e 61 74 69 6f 6e | 20 74 61 62 6c 65 20 64 |tination| table d|
|00005680| 65 70 65 6e 64 73 20 6f | 6e 20 74 68 65 20 74 61 |epends o|n the ta|
|00005690| 62 6c 65 20 74 79 70 65 | 2e 20 54 68 65 20 64 65 |ble type|. The de|
|000056a0| 66 61 75 6c 74 20 74 79 | 70 65 20 69 73 20 50 61 |fault ty|pe is Pa|
|000056b0| 72 61 64 6f 78 2c 20 73 | 6f 20 74 68 65 20 64 65 |radox, s|o the de|
|000056c0| 66 61 75 6c 74 20 66 69 | 6c 65 2d 6e 61 6d 65 20 |fault fi|le-name |
|000056d0| 65 78 74 65 6e 73 69 6f | 6e 20 69 73 20 2e 44 42 |extensio|n is .DB|
|000056e0| 20 28 66 6f 72 20 64 42 | 41 53 45 20 74 61 62 6c | (for dB|ASE tabl|
|000056f0| 65 73 20 69 74 27 73 20 | 2e 44 42 46 29 2e 20 52 |es it's |.DBF). R|
|00005700| 65 66 65 72 20 74 6f 20 | 74 68 65 20 55 73 65 72 |efer to |the User|
|00005710| 27 73 20 47 75 69 64 65 | 20 6f 72 20 74 68 65 20 |'s Guide| or the |
|00005720| 6f 6e 6c 69 6e 65 20 48 | 65 6c 70 20 66 6f 72 20 |online H|elp for |
|00005730| 6d 6f 72 65 20 69 6e 66 | 6f 72 6d 61 74 69 6f 6e |more inf|ormation|
|00005740| 20 61 62 6f 75 74 20 69 | 6d 70 6f 72 74 69 6e 67 | about i|mporting|
|00005750| 20 64 61 74 61 2e 0d 0a | 0d 0a 4f 62 6a 65 63 74 | data...|..Object|
|00005760| 50 41 4c 20 63 6f 64 65 | 20 73 75 73 70 65 6e 64 |PAL code| suspend|
|00005770| 73 20 65 78 65 63 75 74 | 69 6f 6e 20 75 6e 74 69 |s execut|ion unti|
|00005780| 6c 20 74 68 65 20 75 73 | 65 72 20 63 6c 6f 73 65 |l the us|er close|
|00005790| 73 20 74 68 69 73 20 64 | 69 61 6c 6f 67 20 62 6f |s this d|ialog bo|
|000057a0| 78 2e 20 4f 62 6a 65 63 | 74 50 41 4c 20 68 61 73 |x. Objec|tPAL has|
|000057b0| 20 6e 6f 20 63 6f 6e 74 | 72 6f 6c 20 6f 76 65 72 | no cont|rol over|
|000057c0| 20 74 68 69 73 20 64 69 | 61 6c 6f 67 20 62 6f 78 | this di|alog box|
|000057d0| 20 6f 6e 63 65 20 69 74 | 20 69 73 20 64 69 73 70 | once it| is disp|
|000057e0| 6c 61 79 65 64 3b 20 69 | 74 27 73 20 75 70 20 74 |layed; i|t's up t|
|000057f0| 6f 20 74 68 65 20 75 73 | 65 72 20 74 6f 20 66 69 |o the us|er to fi|
|00005800| 6c 6c 20 69 6e 20 61 6e | 79 20 6e 65 63 65 73 73 |ll in an|y necess|
|00005810| 61 72 79 20 69 6e 66 6f | 72 6d 61 74 69 6f 6e 20 |ary info|rmation |
|00005820| 61 6e 64 20 63 6c 6f 73 | 65 20 74 68 65 20 64 69 |and clos|e the di|
|00005830| 61 6c 6f 67 20 62 6f 78 | 2e 0d 0a 00 02 00 01 00 |alog box|........|
|00005840| d8 36 24 00 00 02 00 02 | 00 01 00 01 00 00 00 00 |.6$.....|........|
|00005850| 00 00 00 00 00 00 00 00 | 00 01 80 a5 00 00 00 02 |........|........|
|00005860| 80 ad 00 00 00 01 80 00 | 00 00 00 01 80 00 00 02 |........|........|
|00005870| 00 c8 00 00 00 00 00 90 | 01 00 00 00 00 00 00 00 |........|........|
|00005880| 00 00 00 01 22 00 06 41 | 72 69 61 6c 00 67 1b 40 |...."..A|rial.g.@|
|00005890| 02 67 2f 05 00 05 00 c3 | 05 67 1b 06 14 54 24 19 |.g/.....|.g...T$.|
|000058a0| 00 14 00 c6 89 79 07 c8 | 00 00 00 00 00 90 01 00 |.....y..|........|
|000058b0| 00 00 00 00 00 00 00 00 | 00 04 22 00 06 41 72 69 |........|.."..Ari|
|000058c0| 61 6c 00 7f 08 40 02 6f | 1a 2f 00 05 00 c3 05 7f |al...@.o|./......|
|000058d0| 08 66 1d 58 2a eb 00 e6 | 00 c6 89 79 07 01 00 00 |.f.X*...|...y....|
|000058e0| 00 00 00 00 00 00 00 00 | 00 00 00 98 0f bf 08 d0 |........|........|
|000058f0| 02 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005900| 07 00 00 00 92 03 00 00 | 0a 00 11 00 00 00 03 00 |........|........|
|00005910| 08 00 00 00 02 00 0c 00 | 00 00 04 00 10 00 00 00 |........|........|
|00005920| 06 00 6c 00 00 00 07 00 | 2c 00 00 00 54 68 65 20 |..l.....|,...The |
|00005930| 66 6f 6c 6c 6f 77 69 6e | 67 20 63 6f 64 65 20 63 |followin|g code c|
|00005940| 61 6c 6c 73 20 69 73 45 | 78 65 63 75 74 65 51 42 |alls isE|xecuteQB|
|00005950| 45 4c 6f 63 61 6c 20 74 | 6f 20 66 69 6e 64 20 6f |ELocal t|o find o|
|00005960| 75 74 20 77 68 65 72 65 | 20 61 20 51 42 45 20 71 |ut where| a QBE q|
|00005970| 75 65 72 79 20 77 69 6c | 6c 20 65 78 65 63 75 74 |uery wil|l execut|
|00005980| 65 2e 20 49 66 20 74 68 | 65 20 71 75 65 72 79 20 |e. If th|e query |
|00005990| 77 69 6c 6c 20 65 78 65 | 63 75 74 65 20 6f 6e 20 |will exe|cute on |
|000059a0| 74 68 65 20 73 65 72 76 | 65 72 2c 20 74 68 65 20 |the serv|er, the |
|000059b0| 63 6f 64 65 20 61 73 6b | 73 20 74 68 65 20 75 73 |code ask|s the us|
|000059c0| 65 72 20 77 68 65 74 68 | 65 72 20 6f 72 20 6e 6f |er wheth|er or no|
|000059d0| 74 20 74 6f 20 63 6f 6e | 74 69 6e 75 65 2e 0d 0a |t to con|tinue...|
|000059e0| 0d 0a 6d 65 74 68 6f 64 | 20 70 75 73 68 42 75 74 |..method| pushBut|
|000059f0| 74 6f 6e 20 28 76 61 72 | 20 65 76 65 6e 74 49 6e |ton (var| eventIn|
|00005a00| 66 6f 20 45 76 65 6e 74 | 29 0d 0a 20 20 20 76 61 |fo Event|)..   va|
|00005a10| 72 0d 0a 0d 0a 20 20 20 | 20 20 20 71 62 65 56 61 |r....   |   qbeVa|
|00005a20| 72 09 09 51 75 65 72 79 | 0d 0a 0d 0a 20 20 20 20 |r..Query|....    |
|00005a30| 20 20 64 6c 67 54 69 74 | 6c 65 54 65 78 74 2c 20 |  dlgTit|leText, |
|00005a40| 0d 0a 20 20 20 20 20 20 | 64 6c 67 42 6f 64 79 54 |..      |dlgBodyT|
|00005a50| 65 78 74 2c 0d 0a 20 20 | 20 20 20 20 64 6f 51 42 |ext,..  |    doQB|
|00005a60| 45 09 09 09 53 74 72 69 | 6e 67 0d 0a 0d 0a 20 20 |E...Stri|ng....  |
|00005a70| 20 65 6e 64 56 61 72 0d | 0a 0d 0a 20 20 20 64 6c | endVar.|...   dl|
|00005a80| 67 54 69 74 6c 65 54 65 | 78 74 20 3d 20 22 52 65 |gTitleTe|xt = "Re|
|00005a90| 6d 6f 74 65 20 71 75 65 | 72 79 22 0d 0a 20 20 20 |mote que|ry"..   |
|00005aa0| 64 6c 67 42 6f 64 79 54 | 65 78 74 20 20 3d 20 22 |dlgBodyT|ext  = "|
|00005ab0| 54 68 69 73 20 71 75 65 | 72 79 20 6d 61 79 20 74 |This que|ry may t|
|00005ac0| 61 6b 65 20 61 20 6c 6f | 6e 67 20 74 69 6d 65 2e |ake a lo|ng time.|
|00005ad0| 20 5c 6e 22 20 2b 0d 0a | 20 20 20 20 20 20 20 20 | \n" +..|        |
|00005ae0| 20 20 20 20 20 20 20 20 | 20 20 22 44 6f 20 79 6f |        |  "Do yo|
|00005af0| 75 20 77 61 6e 74 20 74 | 6f 20 63 6f 6e 74 69 6e |u want t|o contin|
|00005b00| 75 65 3f 22 0d 0a 0d 0a | 20 20 20 71 62 65 56 61 |ue?"....|   qbeVa|
|00005b10| 72 20 3d 09 51 75 65 72 | 79 0d 0a 20 20 20 20 20 |r =.Quer|y..     |
|00005b20| 20 20 20 20 20 20 09 09 | 3a 57 65 73 74 44 61 74 |      ..|:WestDat|
|00005b30| 61 3a 6f 72 64 65 72 73 | 2e 64 62 20 7c 43 75 73 |a:orders|.db |Cus|
|00005b40| 74 4e 61 6d 65 20 7c 20 | 51 74 79 20 20 20 20 20 |tName | |Qty     |
|00005b50| 20 20 20 7c 0d 0a 20 20 | 20 20 20 20 20 20 20 20 |   |..  |        |
|00005b60| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |        |        |
|00005b70| 20 20 20 20 20 20 20 20 | 20 20 20 20 7c 20 43 68 |        |    | Ch|
|00005b80| 65 63 6b 20 20 20 7c 20 | 43 68 65 63 6b 20 3e 20 |eck   | |Check > |
|00005b90| 31 30 20 7c 0d 0a 20 20 | 20 20 20 20 20 20 20 20 |10 |..  |        |
|00005ba0| 20 20 65 6e 64 51 75 65 | 72 79 0d 0a 0d 0a 20 20 |  endQue|ry....  |
|00005bb0| 20 69 66 20 69 73 45 78 | 65 63 75 74 65 51 42 45 | if isEx|ecuteQBE|
|00005bc0| 4c 6f 63 61 6c 28 71 62 | 65 56 61 72 29 20 74 68 |Local(qb|eVar) th|
|00005bd0| 65 6e 0d 0a 20 20 20 20 | 20 20 64 6f 51 42 45 20 |en..    |  doQBE |
|00005be0| 3d 20 6d 73 67 51 75 65 | 73 74 69 6f 6e 28 64 6c |= msgQue|stion(dl|
|00005bf0| 67 54 69 74 6c 65 54 65 | 78 74 2c 20 64 6c 67 42 |gTitleTe|xt, dlgB|
|00005c00| 6f 64 79 54 65 78 74 29 | 0d 0a 0d 0a 20 20 20 20 |odyText)|....    |
|00005c10| 20 20 69 66 20 64 6f 51 | 42 45 20 3d 20 22 59 65 |  if doQ|BE = "Ye|
|00005c20| 73 22 20 74 68 65 6e 0d | 0a 20 20 20 20 20 20 20 |s" then.|.       |
|00005c30| 20 20 65 78 65 63 75 74 | 65 51 42 45 28 71 62 65 |  execut|eQBE(qbe|
|00005c40| 56 61 72 29 0d 0a 20 20 | 20 20 20 20 65 6c 73 65 |Var)..  |    else|
|00005c50| 0d 0a 20 20 20 20 20 20 | 20 20 20 6d 73 67 49 6e |..      |   msgIn|
|00005c60| 66 6f 28 64 6c 67 54 69 | 74 6c 65 54 65 78 74 2c |fo(dlgTi|tleText,|
|00005c70| 20 22 51 75 65 72 79 20 | 63 61 6e 63 65 6c 65 64 | "Query |canceled|
|00005c80| 22 29 0d 0a 20 20 20 20 | 20 20 20 20 20 72 65 74 |")..    |     ret|
|00005c90| 75 72 6e 0d 0a 20 20 20 | 20 20 20 65 6e 64 49 66 |urn..   |   endIf|
|00005ca0| 0d 0a 0d 0a 20 20 20 65 | 6e 64 49 66 0d 0a 0d 0a |....   e|ndIf....|
|00005cb0| 65 6e 64 4d 65 74 68 6f | 64 0d 0a 20 20 00 02 00 |endMetho|d..  ...|
|00005cc0| 01 00 d8 36 24 00 00 02 | 00 02 00 01 00 01 00 00 |...6$...|........|
|00005cd0| 00 00 00 00 00 00 00 00 | 00 00 00 01 80 b6 00 00 |........|........|
|00005ce0| 00 02 80 00 00 00 00 01 | 80 00 00 8f 03 00 00 02 |........|........|
|00005cf0| 80 00 00 02 00 c8 00 00 | 00 00 00 90 01 00 00 00 |........|........|
|00005d00| 00 00 00 00 00 00 00 01 | 22 00 06 41 72 69 61 6c |........|"..Arial|
|00005d10| 00 c7 37 40 02 1f 35 1b | 00 05 00 c3 05 c7 37 ee |..7@..5.|......7.|
|00005d20| 37 1c 37 87 00 82 00 f6 | 89 79 07 c8 00 00 00 00 |7.7.....|.y......|
|00005d30| 00 90 01 00 00 00 00 00 | 00 00 00 00 00 01 31 00 |........|......1.|
|00005d40| 04 43 6f 75 72 69 65 72 | 20 4e 65 77 00 05 00 05 |.Courier| New....|
|00005d50| 00 c3 05 67 1b 06 14 54 | 24 19 00 14 00 c6 89 79 |...g...T|$......y|
|00005d60| 07 02 00 00 00 00 00 00 | 00 00 00 00 00 00 00 98 |........|........|
|00005d70| 0f bf 08 d0 02 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005d80| 00 00 00 00 00 98 0f 8f | 09 d0 02 00 00 00 00 00 |........|........|
|00005d90| 00 6c 65 20 74 79 70 65 | 2e 20 54 68 65 20 64 65 |.le type|. The de|
|00005da0| 66 61 75 6c 74 20 74 79 | 70 65 20 69 73 20 50 61 |fault ty|pe is Pa|
|00005db0| 72 61 64 6f 78 2c 20 73 | 6f 20 74 68 65 20 64 65 |radox, s|o the de|
|00005dc0| 66 61 75 6c 74 20 66 69 | 6c 65 2d 6e 61 6d 65 20 |fault fi|le-name |
|00005dd0| 65 78 74 65 6e 73 69 6f | 6e 20 69 73 20 2e 44 42 |extensio|n is .DB|
|00005de0| 20 28 66 6f 72 20 64 42 | 41 53 45 20 74 61 62 6c | (for dB|ASE tabl|
|00005df0| 65 73 20 69 74 27 73 20 | 2e 44 42 46 29 2e 20 52 |es it's |.DBF). R|
|00005e00| 65 66 65 72 20 74 6f 20 | 74 68 65 20 55 73 65 72 |efer to |the User|
|00005e10| 27 73 20 47 75 69 64 65 | 20 6f 72 20 74 68 65 20 |'s Guide| or the |
|00005e20| 6f 6e 6c 69 6e 65 20 48 | 65 6c 70 20 66 6f 72 20 |online H|elp for |
|00005e30| 6d 6f 72 65 20 69 6e 66 | 6f 72 6d 61 74 69 6f 6e |more inf|ormation|
|00005e40| 20 61 62 6f 75 74 20 69 | 6d 70 6f 72 74 69 6e 67 | about i|mporting|
|00005e50| 20 64 61 74 61 2e 0d 0a | 0d 0a 4f 62 6a 65 63 74 | data...|..Object|
|00005e60| 50 41 4c 20 63 6f 64 65 | 20 73 75 73 70 65 6e 64 |PAL code| suspend|
|00005e70| 73 20 65 78 65 63 75 74 | 69 6f 6e 20 75 6e 74 69 |s execut|ion unti|
|00005e80| 6c 20 74 68 65 20 75 73 | 65 72 20 63 6c 6f 73 65 |l the us|er close|
|00005e90| 73 20 74 68 69 73 20 64 | 69 61 6c 6f 67 20 62 6f |s this d|ialog bo|
|00005ea0| 78 2e 20 4f 62 6a 65 63 | 74 50 41 4c 20 68 61 73 |x. Objec|tPAL has|
|00005eb0| 20 6e 6f 20 63 6f 6e 74 | 72 6f 6c 20 6f 76 65 72 | no cont|rol over|
|00005ec0| 20 74 68 69 73 20 64 69 | 61 6c 6f 67 20 62 6f 78 | this di|alog box|
|00005ed0| 20 6f 6e 63 65 20 69 74 | 20 69 73 20 64 69 73 70 | once it| is disp|
|00005ee0| 6c 61 79 65 64 3b 20 69 | 74 27 73 20 75 70 20 74 |layed; i|t's up t|
|00005ef0| 6f 20 74 68 65 20 75 73 | 65 72 20 74 6f 20 66 69 |o the us|er to fi|
|00005f00| 6c 6c 20 69 6e 20 61 6e | 79 20 6e 65 63 65 73 73 |ll in an|y necess|
|00005f10| 61 72 79 20 69 6e 66 6f | 72 6d 61 74 69 6f 6e 20 |ary info|rmation |
|00005f20| 61 6e 64 20 63 6c 6f 73 | 65 20 74 68 65 20 64 69 |and clos|e the di|
|00005f30| 61 6c 6f 67 20 62 6f 78 | 2e 0d 0a 00 02 00 01 00 |alog box|........|
|00005f40| d8 36 24 00 00 02 00 02 | 00 01 00 01 00 00 00 00 |.6$.....|........|
|00005f50| 00 00 00 00 00 00 00 00 | 00 01 80 a5 00 00 00 02 |........|........|
|00005f60| 80 ad 00 00 00 01 80 00 | 00 00 00 01 80 00 00 02 |........|........|
|00005f70| 00 c8 00 00 00 00 00 90 | 01 00 00 00 00 00 00 00 |........|........|
|00005f80| 00 00 00 01 22 00 06 41 | 72 69 61 6c 00 67 1b 40 |...."..A|rial.g.@|
|00005f90| 02 67 2f 05 00 05 00 c3 | 05 67 1b 06 14 54 24 19 |.g/.....|.g...T$.|
|00005fa0| 00 14 00 c6 89 79 07 c8 | 00 00 00 00 00 90 01 00 |.....y..|........|
|00005fb0| 00 00 00 00 00 00 00 00 | 00 04 22 00 06 41 72 69 |........|.."..Ari|
|00005fc0| 61 6c 00 7f 08 40 02 6f | 1a 2f 00 05 00 c3 05 7f |al...@.o|./......|
|00005fd0| 08 66 1d 58 2a eb 00 e6 | 00 c6 89 79 07 01 00 00 |.f.X*...|...y....|
|00005fe0| 00 00 00 00 00 00 00 00 | 00 00 00 98 0f bf 08 d0 |........|........|
|00005ff0| 02 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00006000| 03 01 00 7a 6e 3c 1e cb | b2 4f f1 00 00 00 00 00 |...zn<..|.O......|
|00006010| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00006020| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00006030| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00006040| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00006050| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00006060| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00006070| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00006080| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00006090| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000060a0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000060b0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000060c0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000060d0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000060e0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000060f0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00006100| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00006110| 00 00 00 00 00 c5 23 97 | 02 02 e8 12 a1 02 06 43 |......#.|.......C|
|00006120| 17 18 02 0c 9a 12 6e 02 | 09 80 0d 60 02 0f 15 0d |......n.|...`....|
|00006130| f0 01 0f 22 21 0c 02 04 | 6c 14 4d 02 04 8d 0d 67 |..."!...|l.M....g|
|00006140| 02 08 5a 12 3d 02 05 ac | 19 89 02 03 00 00 00 00 |..Z.=...|........|
|00006150| 07 00 00 00 2a 00 00 00 | 0a 00 11 00 00 00 03 00 |....*...|........|
|00006160| 08 00 00 00 02 00 06 00 | 00 00 04 00 08 00 00 00 |........|........|
|00006170| 06 00 36 00 00 00 07 00 | 16 00 00 00 53 65 65 20 |..6.....|....See |
|00006180| 74 68 65 20 65 78 61 6d | 70 6c 65 20 66 6f 72 20 |the exam|ple for |
|00006190| 62 65 67 69 6e 54 72 61 | 6e 73 61 63 74 69 6f 6e |beginTra|nsaction|
|000061a0| 2e 0d 0a 20 20 00 02 00 | 01 00 d8 36 24 00 00 02 |...  ...|...6$...|
|000061b0| 00 02 00 01 00 01 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000061c0| 00 00 00 01 80 00 00 00 | 00 01 80 00 00 01 00 c8 |........|........|
|000061d0| 00 00 00 00 00 90 01 00 | 00 00 00 00 00 00 00 00 |........|........|
|000061e0| 00 01 22 00 06 41 72 69 | 61 6c 00 67 1b 40 02 67 |.."..Ari|al.g.@.g|
|000061f0| 2f 05 00 05 00 c3 05 67 | 1b 06 14 54 24 19 00 14 |/......g|...T$...|
|00006200| 00 c6 89 79 07 01 00 00 | 00 00 00 00 00 00 00 00 |...y....|........|
|00006210| 00 00 00 98 0f 8f 09 d0 | 02 00 00 00 00 00 00 01 |........|........|
|00006220| 07 00 00 00 23 01 00 00 | 0a 00 11 00 00 00 03 00 |....#...|........|
|00006230| 08 00 00 00 02 00 0c 00 | 00 00 04 00 08 00 00 00 |........|........|
|00006240| 06 00 6c 00 00 00 07 00 | 16 00 00 00 54 68 69 73 |..l.....|....This|
|00006250| 20 65 78 61 6d 70 6c 65 | 20 69 73 20 61 20 63 75 | example| is a cu|
|00006260| 73 74 6f 6d 20 6d 65 74 | 68 6f 64 20 74 68 61 74 |stom met|hod that|
|00006270| 20 63 61 6c 6c 73 20 69 | 73 4f 70 65 6e 4f 6e 55 | calls i|sOpenOnU|
|00006280| 6e 69 71 75 65 49 6e 64 | 65 78 20 62 65 66 6f 72 |niqueInd|ex befor|
|00006290| 65 20 70 75 74 74 69 6e | 67 20 74 68 65 20 54 43 |e puttin|g the TC|
|000062a0| 75 72 73 6f 72 20 69 6e | 74 6f 20 45 64 69 74 20 |ursor in|to Edit |
|000062b0| 6d 6f 64 65 2e 0d 0a 20 | 20 0d 0a 20 20 6d 65 74 |mode... | ..  met|
|000062c0| 68 6f 64 20 65 64 69 74 | 49 66 55 6e 69 71 75 65 |hod edit|IfUnique|
|000062d0| 49 6e 64 65 78 28 63 6f | 6e 73 74 20 74 63 20 54 |Index(co|nst tc T|
|000062e0| 43 75 72 73 6f 72 29 20 | 4c 6f 67 69 63 61 6c 0d |Cursor) |Logical.|
|000062f0| 0a 20 20 20 20 20 69 66 | 20 74 63 2e 69 73 4f 70 |.     if| tc.isOp|
|00006300| 65 6e 4f 6e 55 6e 69 71 | 75 65 49 6e 64 65 78 28 |enOnUniq|ueIndex(|
|00006310| 29 20 74 68 65 6e 0d 0a | 20 20 20 20 20 20 20 20 |) then..|        |
|00006320| 72 65 74 75 72 6e 20 74 | 63 2e 65 64 69 74 28 29 |return t|c.edit()|
|00006330| 0d 0a 20 20 20 20 20 65 | 6c 73 65 0d 0a 20 20 20 |..     e|lse..   |
|00006340| 20 20 20 20 20 72 65 74 | 75 72 6e 20 46 61 6c 73 |     ret|urn Fals|
|00006350| 65 0d 0a 20 20 20 20 20 | 65 6e 64 49 66 0d 0a 20 |e..     |endIf.. |
|00006360| 20 65 6e 64 6d 65 74 68 | 6f 64 0d 0a 20 20 00 02 | endmeth|od..  ..|
|00006370| 00 01 00 d8 36 24 00 00 | 02 00 02 00 01 00 01 00 |....6$..|........|
|00006380| 00 00 00 00 00 00 00 00 | 00 00 00 00 01 80 6f 00 |........|......o.|
|00006390| 00 00 02 80 00 00 00 00 | 01 80 00 00 02 00 c8 00 |........|........|
|000063a0| 00 00 00 00 90 01 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000063b0| 01 22 00 06 41 72 69 61 | 6c 00 67 1b 40 02 67 2f |."..Aria|l.g.@.g/|
|000063c0| 05 00 05 00 c3 05 67 1b | 06 14 54 24 19 00 14 00 |......g.|..T$....|
|000063d0| c6 89 79 07 c8 00 00 00 | 00 00 90 01 00 00 00 00 |..y.....|........|
|000063e0| 00 00 00 00 00 00 01 31 | 00 04 43 6f 75 72 69 65 |.......1|..Courie|
|000063f0| 72 20 4e 65 77 00 05 00 | 05 00 c3 05 67 1b 06 14 |r New...|....g...|
+--------+-------------------------+-------------------------+--------+--------+