home *** CD-ROM | disk | FTP | other *** search
| PowerBuilder Dynamic Library | 1993-09-14 | 44.0 KB |
open in: 
MacOS 8.1
|
Win98
|
DOS
view JSON data
|
view as text
This file was processed as: PowerBuilder Dynamic Library
(other/powerBuilderDynamicLibrary).
This format is not currently supported by dexvert.
| Confidence | Program | Detection | Match Type | Support
|
|---|
| 1%
| dexvert
| PowerBuilder Dynamic Library (other/powerBuilderDynamicLibrary)
| magic
| Unsupported |
| 100%
| file
| data
| default
| |
| 90%
| TrID
| PowerBuilder Library
| default
| |
| 9%
| TrID
| PowerBuilder Dynamic library
| default
| |
| 100%
| gt2
| Kopftext: 'HDR*PowerBuilder'
| default (weak)
|
|
hex view+--------+-------------------------+-------------------------+--------+--------+
|00000000| 48 44 52 2a 50 6f 77 65 | 72 42 75 69 6c 64 65 72 |HDR*Powe|rBuilder|
|00000010| 00 00 30 33 30 30 16 a0 | 8f 2c 00 00 46 75 6e 63 |..0300..|.,..Func|
|00000020| 74 69 6f 6e 20 4c 69 62 | 72 61 72 79 20 66 6f 72 |tion Lib|rary for|
|00000030| 20 50 6f 77 65 72 42 75 | 69 6c 64 65 72 20 33 2e | PowerBu|ilder 3.|
|00000040| 30 20 53 61 6d 70 6c 65 | 73 3a 20 43 6f 6e 74 61 |0 Sample|s: Conta|
|00000050| 69 6e 73 20 61 6c 6c 20 | 46 75 6e 63 74 69 6f 6e |ins all |Function|
|00000060| 73 20 77 72 69 74 74 65 | 6e 20 69 6e 20 74 68 65 |s writte|n in the|
|00000070| 20 46 75 6e 63 74 69 6f | 6e 20 50 61 69 6e 74 65 | Functio|n Painte|
|00000080| 72 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |r.......|........|
|00000090| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000000a0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000000b0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000000c0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000000d0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000000e0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000000f0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000100| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000110| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000120| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000130| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000140| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000150| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000160| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000170| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000180| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000190| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000001a0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000001b0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000001c0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000001d0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000001e0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000001f0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000200| 46 52 45 2a 00 00 00 00 | ff ff ff ff ff ff ff ff |FRE*....|........|
|00000210| ff ff ff 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| 4e 4f 44 2a 00 00 00 00 | 00 00 00 00 00 00 00 00 |NOD*....|........|
|00000410| 96 07 55 04 18 00 2b 04 | 00 00 00 00 00 00 00 00 |..U...+.|........|
|00000420| 45 4e 54 2a 30 33 30 30 | 00 68 00 00 ed 04 00 00 |ENT*0300|.h......|
|00000430| 80 73 87 2c 3e 00 0e 00 | 67 65 74 5f 74 6f 6b 65 |.s.,>...|get_toke|
|00000440| 6e 2e 73 72 66 00 45 4e | 54 2a 30 33 30 30 00 6e |n.srf.EN|T*0300.n|
|00000450| 00 00 56 06 00 00 e9 9d | 8b 2c 00 00 18 00 67 65 |..V.....|.,....ge|
|00000460| 74 5f 74 6f 6f 6c 62 61 | 72 5f 70 72 6f 66 69 6c |t_toolba|r_profil|
|00000470| 65 2e 66 75 6e 00 45 4e | 54 2a 30 33 30 30 00 64 |e.fun.EN|T*0300.d|
|00000480| 00 00 86 02 00 00 80 73 | 87 2c 00 00 0e 00 67 65 |.......s|.,....ge|
|00000490| 74 5f 74 6f 6b 65 6e 2e | 66 75 6e 00 45 4e 54 2a |t_token.|fun.ENT*|
|000004a0| 30 33 30 30 00 76 00 00 | e4 06 00 00 e9 9d 8b 2c |0300.v..|.......,|
|000004b0| 00 00 18 00 67 65 74 5f | 74 6f 6f 6c 62 61 72 5f |....get_|toolbar_|
|000004c0| 70 72 6f 66 69 6c 65 2e | 73 72 66 00 45 4e 54 2a |profile.|srf.ENT*|
|000004d0| 30 33 30 30 00 56 00 00 | e2 0b 00 00 80 73 87 2c |0300.V..|.....s.,|
|000004e0| 46 00 17 00 66 5f 73 65 | 74 5f 74 61 62 6c 65 5f |F...f_se|t_table_|
|000004f0| 73 65 6c 65 63 74 2e 73 | 72 66 00 45 4e 54 2a 30 |select.s|rf.ENT*0|
|00000500| 33 30 30 00 7e 00 00 b4 | 01 00 00 81 73 87 2c 00 |300.~...|....s.,.|
|00000510| 00 0f 00 69 73 69 74 6d | 6f 6e 64 61 79 2e 66 75 |...isitm|onday.fu|
|00000520| 6e 00 45 4e 54 2a 30 33 | 30 30 00 4c 00 00 82 09 |n.ENT*03|00.L....|
|00000530| 00 00 80 73 87 2c 00 00 | 17 00 66 5f 73 65 74 5f |...s.,..|..f_set_|
|00000540| 74 61 62 6c 65 5f 73 65 | 6c 65 63 74 2e 66 75 6e |table_se|lect.fun|
|00000550| 00 45 4e 54 2a 30 33 30 | 30 00 80 00 00 98 01 00 |.ENT*030|0.......|
|00000560| 00 81 73 87 2c 14 00 0f | 00 69 73 69 74 6d 6f 6e |..s.,...|.isitmon|
|00000570| 64 61 79 2e 73 72 66 00 | 45 4e 54 2a 30 33 30 30 |day.srf.|ENT*0300|
|00000580| 00 40 00 00 dc 09 00 00 | 7f 73 87 2c 52 00 18 00 |.@......|.s.,R...|
|00000590| 66 5f 73 65 74 5f 63 6f | 6c 75 6d 6e 5f 73 65 6c |f_set_co|lumn_sel|
|000005a0| 65 63 74 2e 73 72 66 00 | 45 4e 54 2a 30 33 30 30 |ect.srf.|ENT*0300|
|000005b0| 00 82 00 00 0e 06 00 00 | 8d 73 87 2c 00 00 1a 00 |........|.s.,....|
|000005c0| 70 6f 70 75 6c 61 74 65 | 5f 64 64 6c 62 5f 66 72 |populate|_ddlb_fr|
|000005d0| 6f 6d 5f 64 62 2e 66 75 | 6e 00 45 4e 54 2a 30 33 |om_db.fu|n.ENT*03|
|000005e0| 30 30 00 36 00 00 85 09 | 00 00 7f 73 87 2c 00 00 |00.6....|...s.,..|
|000005f0| 18 00 66 5f 73 65 74 5f | 63 6f 6c 75 6d 6e 5f 73 |..f_set_|column_s|
|00000600| 65 6c 65 63 74 2e 66 75 | 6e 00 45 4e 54 2a 30 33 |elect.fu|n.ENT*03|
|00000610| 30 30 00 8a 00 00 70 04 | 00 00 8d 73 87 2c 35 00 |00....p.|...s.,5.|
|00000620| 1a 00 70 6f 70 75 6c 61 | 74 65 5f 64 64 6c 62 5f |..popula|te_ddlb_|
|00000630| 66 72 6f 6d 5f 64 62 2e | 73 72 66 00 45 4e 54 2a |from_db.|srf.ENT*|
|00000640| 30 33 30 30 00 30 00 00 | bc 04 00 00 7f 73 87 2c |0300.0..|.....s.,|
|00000650| 21 00 17 00 66 5f 70 61 | 72 73 65 5f 6f 62 6a 5f |!...f_pa|rse_obj_|
|00000660| 73 74 72 69 6e 67 2e 73 | 72 66 00 45 4e 54 2a 30 |string.s|rf.ENT*0|
|00000670| 33 30 30 00 90 00 00 46 | 02 00 00 8d 73 87 2c 00 |300....F|....s.,.|
|00000680| 00 15 00 72 69 67 68 74 | 5f 61 64 6a 75 73 74 5f |...right|_adjust_|
|00000690| 64 65 63 2e 66 75 6e 00 | 45 4e 54 2a 30 33 30 30 |dec.fun.|ENT*0300|
|000006a0| 00 2a 00 00 76 05 00 00 | 7f 73 87 2c 00 00 17 00 |.*..v...|.s.,....|
|000006b0| 66 5f 70 61 72 73 65 5f | 6f 62 6a 5f 73 74 72 69 |f_parse_|obj_stri|
|000006c0| 6e 67 2e 66 75 6e 00 45 | 4e 54 2a 30 33 30 30 00 |ng.fun.E|NT*0300.|
|000006d0| 94 00 00 d1 02 00 00 8d | 73 87 2c 70 00 15 00 72 |........|s.,p...r|
|000006e0| 69 67 68 74 5f 61 64 6a | 75 73 74 5f 64 65 63 2e |ight_adj|ust_dec.|
|000006f0| 73 72 66 00 45 4e 54 2a | 30 33 30 30 00 22 00 00 |srf.ENT*|0300."..|
|00000700| 4a 07 00 00 7e 73 87 2c | 31 00 1b 00 66 5f 6d 61 |J...~s.,|1...f_ma|
|00000710| 69 6c 5f 65 72 72 6f 72 | 5f 74 6f 5f 73 74 72 69 |il_error|_to_stri|
|00000720| 6e 67 2e 73 72 66 00 45 | 4e 54 2a 30 33 30 30 00 |ng.srf.E|NT*0300.|
|00000730| 98 00 00 26 06 00 00 5c | 9e 8b 2c 00 00 19 00 73 |...&...\|..,....s|
|00000740| 61 76 65 5f 74 6f 6f 6c | 62 61 72 5f 70 72 6f 66 |ave_tool|bar_prof|
|00000750| 69 6c 65 2e 66 75 6e 00 | 45 4e 54 2a 30 33 30 30 |ile.fun.|ENT*0300|
|00000760| 00 1a 00 00 c7 06 00 00 | 7e 73 87 2c 00 00 1b 00 |........|~s.,....|
|00000770| 66 5f 6d 61 69 6c 5f 65 | 72 72 6f 72 5f 74 6f 5f |f_mail_e|rror_to_|
|00000780| 73 74 72 69 6e 67 2e 66 | 75 6e 00 45 4e 54 2a 30 |string.f|un.ENT*0|
|00000790| 33 30 30 00 a0 00 00 d9 | 06 00 00 5c 9e 8b 2c 00 |300.....|...\..,.|
|000007a0| 00 19 00 73 61 76 65 5f | 74 6f 6f 6c 62 61 72 5f |...save_|toolbar_|
|000007b0| 70 72 6f 66 69 6c 65 2e | 73 72 66 00 45 4e 54 2a |profile.|srf.ENT*|
|000007c0| 30 33 30 30 00 14 00 00 | f8 04 00 00 7e 73 87 2c |0300....|....~s.,|
|000007d0| 2b 00 12 00 66 5f 64 65 | 70 74 5f 6c 6f 6f 6b 75 |+...f_de|pt_looku|
|000007e0| 70 2e 73 72 66 00 45 4e | 54 2a 30 33 30 30 00 a8 |p.srf.EN|T*0300..|
|000007f0| 00 00 d2 03 00 00 8e 73 | 87 2c 00 00 15 00 73 65 |.......s|.,....se|
|00000800| 6c 65 63 74 5f 66 69 72 | 73 74 5f 72 6f 77 2e 66 |lect_fir|st_row.f|
|00000810| 75 6e 00 45 4e 54 2a 30 | 33 30 30 00 10 00 00 8a |un.ENT*0|300.....|
|00000820| 03 00 00 7e 73 87 2c 00 | 00 12 00 66 5f 64 65 70 |...~s.,.|...f_dep|
|00000830| 74 5f 6c 6f 6f 6b 75 70 | 2e 66 75 6e 00 45 4e 54 |t_lookup|.fun.ENT|
|00000840| 2a 30 33 30 30 00 ac 00 | 00 65 02 00 00 8e 73 87 |*0300...|.e....s.|
|00000850| 2c 2b 00 15 00 73 65 6c | 65 63 74 5f 66 69 72 73 |,+...sel|ect_firs|
|00000860| 74 5f 72 6f 77 2e 73 72 | 66 00 00 00 00 00 00 00 |t_row.sr|f.......|
|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| 44 41 54 2a 00 12 00 00 | f6 01 11 00 02 00 00 00 |DAT*....|........|
|00001010| 00 00 00 00 27 94 72 2c | 7c 73 87 2c 08 00 05 00 |....'.r,||s.,....|
|00001020| 0e 00 00 00 38 40 38 40 | 01 74 1e 00 c1 00 38 40 |....8@8@|.t....8@|
|00001030| 01 80 e9 71 2c 00 74 79 | 01 80 00 00 6a 79 3a 00 |...q,.ty|....jy:.|
|00001040| 00 00 3f 40 3f 40 01 61 | 46 00 63 61 02 80 00 00 |..?@?@.a|F.ca....|
|00001050| 00 00 4c 00 00 00 66 5f | 64 65 70 74 5f 6c 6f 6f |..L...f_|dept_loo|
|00001060| 6b 75 70 00 66 75 6e 63 | 74 69 6f 6e 5f 6f 62 6a |kup.func|tion_obj|
|00001070| 65 63 74 00 66 5f 64 65 | 70 74 5f 6c 6f 6f 6b 75 |ect.f_de|pt_looku|
|00001080| 70 00 66 5f 64 65 70 74 | 5f 6c 6f 6f 6b 75 70 00 |p.f_dept|_lookup.|
|00001090| 74 72 61 6e 73 61 63 74 | 69 6f 6e 00 73 71 6c 63 |transact|ion.sqlc|
|000010a0| 61 00 10 00 32 00 08 00 | 00 00 00 00 00 00 00 00 |a...2...|........|
|000010b0| 01 00 01 00 2c 00 00 00 | 61 5f 64 65 70 74 5f 6e |....,...|a_dept_n|
|000010c0| 75 6d 00 66 5f 64 65 70 | 74 5f 6c 6f 6f 6b 75 70 |um.f_dep|t_lookup|
|000010d0| 00 01 00 06 00 ff ff 00 | 00 61 5f 64 65 70 74 5f |........|.a_dept_|
|000010e0| 6e 75 6d 00 0a 00 78 00 | 11 00 2a 00 00 00 66 75 |num...x.|..*...fu|
|000010f0| 6e 63 74 69 6f 6e 5f 6f | 62 6a 65 63 74 00 66 5f |nction_o|bject.f_|
|00001100| 64 65 70 74 5f 6c 6f 6f | 6b 75 70 00 74 72 61 6e |dept_loo|kup.tran|
|00001110| 73 61 63 74 69 6f 6e 00 | 1e 00 00 00 a0 14 00 00 |saction.|........|
|00001120| 00 00 74 2e 10 00 80 14 | 00 00 00 00 31 29 1e 00 |..t.....|....1)..|
|00001130| a0 14 00 00 03 00 30 39 | 14 00 f0 00 11 00 00 00 |......09|........|
|00001140| 00 00 00 00 c1 6c 01 80 | 69 72 73 74 00 80 00 c0 |.....l..|irst....|
|00001150| 00 00 01 00 00 00 00 00 | 00 00 01 00 02 00 01 00 |........|........|
|00001160| 01 00 01 00 00 00 8c 00 | 09 00 1c 00 00 00 28 00 |........|......(.|
|00001170| 56 00 01 00 03 00 2e 00 | 39 00 00 00 39 00 0e 00 |V.......|9...9...|
|00001180| 3b 00 02 00 1c 40 28 00 | 7c 00 03 00 14 00 3a 00 |;....@(.||.....:.|
|00001190| 00 00 01 00 01 00 00 00 | 1c 00 02 00 1c 00 00 00 |........|........|
|000011a0| 28 00 54 00 01 00 7e 00 | 10 00 b4 00 00 00 2d 00 |(.T...~.|......-.|
|000011b0| 03 00 1e 00 d0 00 25 00 | 32 00 00 00 00 00 d2 00 |......%.|2.......|
|000011c0| 2d 00 03 00 1e 00 d4 00 | 25 00 32 00 64 00 00 00 |-.......|%.2.d...|
|000011d0| a6 00 23 00 03 00 7c 00 | 3a 00 00 00 01 00 01 00 |..#...|.|:.......|
|000011e0| 00 00 04 00 86 00 3a 00 | 01 00 01 00 01 00 00 00 |......:.|........|
|000011f0| 01 00 00 00 01 00 12 00 | 00 00 13 00 0e 00 14 00 |........|........|
|00001200| 44 41 54 2a 00 00 00 00 | 94 01 24 00 17 00 2e 00 |DAT*....|..$.....|
|00001210| 1c 00 3e 00 1f 00 44 00 | 21 00 6e 00 22 00 78 00 |..>...D.|!.n.".x.|
|00001220| 23 00 7c 00 10 00 64 00 | 08 00 26 00 00 00 61 5f |#.|...d.|..&...a_|
|00001230| 64 65 70 74 5f 6e 75 6d | 00 69 5f 64 65 70 74 5f |dept_num|.i_dept_|
|00001240| 69 64 00 69 5f 64 65 70 | 74 5f 6e 75 6d 00 73 71 |id.i_dep|t_num.sq|
|00001250| 6c 63 61 00 28 00 00 00 | 80 0c 06 00 00 00 00 00 |lca.(...|........|
|00001260| 0b 00 80 04 01 00 00 00 | 1f 22 15 00 80 04 01 00 |........|."......|
|00001270| 00 00 1f 22 20 00 20 16 | 02 80 04 00 03 00 d8 00 |..." . .|........|
|00001280| 00 00 66 5f 64 65 70 74 | 5f 6c 6f 6f 6b 75 70 00 |..f_dept|_lookup.|
|00001290| 4e 55 4c 4c 20 61 72 67 | 75 6d 65 6e 74 20 72 65 |NULL arg|ument re|
|000012a0| 63 65 69 76 65 64 00 04 | 00 01 00 1c 00 01 00 04 |ceived..|........|
|000012b0| 00 01 00 1c 00 02 00 04 | 00 01 00 2d 00 03 00 53 |........|...-...S|
|000012c0| 45 4c 45 43 54 20 64 65 | 70 61 72 74 6d 65 6e 74 |ELECT de|partment|
|000012d0| 2e 64 65 70 74 5f 69 64 | 20 46 52 4f 4d 20 64 65 |.dept_id| FROM de|
|000012e0| 70 61 72 74 6d 65 6e 74 | 20 57 48 45 52 45 20 64 |partment| WHERE d|
|000012f0| 65 70 61 72 74 6d 65 6e | 74 2e 64 65 70 74 5f 69 |epartmen|t.dept_i|
|00001300| 64 20 3d 30 20 00 2d 00 | ff ff 00 00 00 00 44 00 |d =0 .-.|......D.|
|00001310| 45 00 01 00 84 00 ff ff | ff ff ff ff ff ff 8c 00 |E.......|........|
|00001320| ff ff 3d 00 35 00 ff ff | 00 00 01 00 00 00 25 00 |..=.5...|......%.|
|00001330| ff ff 00 00 00 00 00 00 | ff ff ac 00 90 00 ff ff |........|........|
|00001340| ff ff ff ff ff ff ff ff | ff ff ff ff 01 00 00 00 |........|........|
|00001350| 01 00 07 00 ff ff 07 00 | ff ff 00 00 00 00 01 00 |........|........|
|00001360| 00 00 10 00 32 00 0b 00 | 0e 00 00 00 66 5f 64 65 |....2...|....f_de|
|00001370| 70 74 5f 6c 6f 6f 6b 75 | 70 00 0a 00 00 00 80 14 |pt_looku|p.......|
|00001380| 07 00 00 00 00 01 10 00 | 32 00 0b 00 00 00 00 00 |........|2.......|
|00001390| 00 00 0b 00 00 00 07 00 | 19 00 01 80 1a 00 00 00 |........|........|
|000013a0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000013b0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000013c0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000013d0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000013e0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000013f0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001400| 44 41 54 2a 00 16 00 00 | f6 01 43 68 65 63 6b 20 |DAT*....|..Check |
|00001410| 69 66 20 64 65 70 74 5f | 69 64 20 65 78 69 73 74 |if dept_|id exist|
|00001420| 73 20 69 6e 20 64 65 70 | 61 72 74 6d 65 6e 74 20 |s in dep|artment |
|00001430| 74 61 62 6c 65 67 6c 6f | 62 61 6c 20 74 79 70 65 |tableglo|bal type|
|00001440| 20 66 5f 64 65 70 74 5f | 6c 6f 6f 6b 75 70 20 66 | f_dept_|lookup f|
|00001450| 72 6f 6d 20 66 75 6e 63 | 74 69 6f 6e 5f 6f 62 6a |rom func|tion_obj|
|00001460| 65 63 74 0d 0a 65 6e 64 | 20 74 79 70 65 0d 0a 0d |ect..end| type...|
|00001470| 0a 66 6f 72 77 61 72 64 | 20 70 72 6f 74 6f 74 79 |.forward| prototy|
|00001480| 70 65 73 0d 0a 67 6c 6f | 62 61 6c 20 66 75 6e 63 |pes..glo|bal func|
|00001490| 74 69 6f 6e 20 62 6f 6f | 6c 65 61 6e 20 66 5f 64 |tion boo|lean f_d|
|000014a0| 65 70 74 5f 6c 6f 6f 6b | 75 70 20 28 73 74 72 69 |ept_look|up (stri|
|000014b0| 6e 67 20 61 5f 64 65 70 | 74 5f 6e 75 6d 29 0d 0a |ng a_dep|t_num)..|
|000014c0| 65 6e 64 20 70 72 6f 74 | 6f 74 79 70 65 73 0d 0a |end prot|otypes..|
|000014d0| 0d 0a 67 6c 6f 62 61 6c | 20 66 75 6e 63 74 69 6f |..global| functio|
|000014e0| 6e 20 62 6f 6f 6c 65 61 | 6e 20 66 5f 64 65 70 74 |n boolea|n f_dept|
|000014f0| 5f 6c 6f 6f 6b 75 70 20 | 28 73 74 72 69 6e 67 20 |_lookup |(string |
|00001500| 61 5f 64 65 70 74 5f 6e | 75 6d 29 3b 2f 2f 2a 2a |a_dept_n|um);//**|
|00001510| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00001520| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00001530| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00001540| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00001550| 2a 2a 2a 2a 0d 0a 2f 2f | 20 47 6c 6f 62 61 6c 20 |****..//| Global |
|00001560| 42 6f 6f 6c 65 61 6e 20 | 46 75 6e 63 74 69 6f 6e |Boolean |Function|
|00001570| 20 66 5f 64 65 70 74 5f | 6c 6f 6f 6b 75 70 20 28 | f_dept_|lookup (|
|00001580| 73 74 72 69 6e 67 20 61 | 5f 64 65 70 74 5f 6e 75 |string a|_dept_nu|
|00001590| 6d 20 29 0d 0a 2f 2f 0d | 0a 2f 2f 20 43 68 65 63 |m )..//.|.// Chec|
|000015a0| 6b 73 20 69 66 20 61 5f | 64 65 70 74 5f 6e 75 6d |ks if a_|dept_num|
|000015b0| 20 65 78 69 73 74 73 20 | 61 73 20 61 20 64 65 70 | exists |as a dep|
|000015c0| 74 5f 69 64 20 69 6e 20 | 74 68 65 20 64 65 70 61 |t_id in |the depa|
|000015d0| 72 74 6d 65 6e 74 20 74 | 61 62 6c 65 0d 0a 2f 2f |rtment t|able..//|
|000015e0| 20 62 79 20 69 73 73 75 | 69 6e 67 20 61 6e 20 53 | by issu|ing an S|
|000015f0| 51 4c 20 53 45 4c 45 43 | 54 20 73 74 61 74 65 6d |QL SELEC|T statem|
|00001600| 44 41 54 2a 00 18 00 00 | f6 01 65 6e 74 0d 0a 2f |DAT*....|..ent../|
|00001610| 2f 0d 0a 2f 2f 20 52 65 | 74 75 72 6e 73 20 54 52 |/..// Re|turns TR|
|00001620| 55 45 20 69 66 20 61 5f | 64 65 70 74 5f 6e 75 6d |UE if a_|dept_num|
|00001630| 20 69 73 20 66 6f 75 6e | 64 3b 20 6f 74 68 65 72 | is foun|d; other|
|00001640| 77 69 73 65 2c 20 72 65 | 74 75 72 6e 73 20 46 41 |wise, re|turns FA|
|00001650| 4c 53 45 0d 0a 2f 2f 0d | 0a 2f 2f 20 41 73 73 75 |LSE..//.|.// Assu|
|00001660| 6d 65 73 20 74 68 61 74 | 20 73 71 6c 63 61 20 68 |mes that| sqlca h|
|00001670| 61 73 20 62 65 65 6e 20 | 69 6e 69 74 69 61 6c 69 |as been |initiali|
|00001680| 7a 65 64 20 61 6e 64 20 | 63 6f 6e 6e 65 63 74 65 |zed and |connecte|
|00001690| 64 0d 0a 2f 2f 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |d..//***|********|
|000016a0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|000016b0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|000016c0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|000016d0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 0d 0a 0d 0a 69 |********|***....i|
|000016e0| 6e 74 09 09 69 5f 64 65 | 70 74 5f 69 64 2c 20 69 |nt..i_de|pt_id, i|
|000016f0| 5f 64 65 70 74 5f 6e 75 | 6d 0d 0a 0d 0a 2f 2f 42 |_dept_nu|m....//B|
|00001700| 65 65 70 28 32 29 0d 0a | 0d 0a 2f 2f 4d 65 73 73 |eep(2)..|..//Mess|
|00001710| 61 67 65 42 6f 78 20 28 | 22 66 5f 64 65 70 74 5f |ageBox (|"f_dept_|
|00001720| 6c 6f 6f 6b 75 70 22 2c | 20 61 5f 64 65 70 74 5f |lookup",| a_dept_|
|00001730| 6e 75 6d 29 0d 0a 0d 0a | 69 66 20 49 73 4e 75 6c |num)....|if IsNul|
|00001740| 6c 20 28 61 5f 64 65 70 | 74 5f 6e 75 6d 29 20 74 |l (a_dep|t_num) t|
|00001750| 68 65 6e 0d 0a 09 4d 65 | 73 73 61 67 65 42 6f 78 |hen...Me|ssageBox|
|00001760| 20 28 22 66 5f 64 65 70 | 74 5f 6c 6f 6f 6b 75 70 | ("f_dep|t_lookup|
|00001770| 22 2c 20 22 4e 55 4c 4c | 20 61 72 67 75 6d 65 6e |", "NULL| argumen|
|00001780| 74 20 72 65 63 65 69 76 | 65 64 22 2c 20 45 78 63 |t receiv|ed", Exc|
|00001790| 6c 61 6d 61 74 69 6f 6e | 21 29 0d 0a 09 72 65 74 |lamation|!)...ret|
|000017a0| 75 72 6e 20 46 41 4c 53 | 45 0d 0a 65 6e 64 20 69 |urn FALS|E..end i|
|000017b0| 66 0d 0a 0d 0a 69 5f 64 | 65 70 74 5f 6e 75 6d 20 |f....i_d|ept_num |
|000017c0| 3d 20 49 6e 74 65 67 65 | 72 20 28 61 5f 64 65 70 |= Intege|r (a_dep|
|000017d0| 74 5f 6e 75 6d 29 0d 0a | 0d 0a 20 20 53 45 4c 45 |t_num)..|.. SELE|
|000017e0| 43 54 20 64 65 70 61 72 | 74 6d 65 6e 74 2e 64 65 |CT depar|tment.de|
|000017f0| 70 74 5f 69 64 20 20 0d | 0a 20 20 20 20 49 4e 54 |pt_id .|. INT|
|00001800| 44 41 54 2a 00 00 00 00 | 0c 01 4f 20 3a 69 5f 64 |DAT*....|..O :i_d|
|00001810| 65 70 74 5f 69 64 20 20 | 0d 0a 20 20 20 20 46 52 |ept_id |.. FR|
|00001820| 4f 4d 20 64 65 70 61 72 | 74 6d 65 6e 74 20 20 0d |OM depar|tment .|
|00001830| 0a 20 20 20 57 48 45 52 | 45 20 64 65 70 61 72 74 |. WHER|E depart|
|00001840| 6d 65 6e 74 2e 64 65 70 | 74 5f 69 64 20 3d 20 3a |ment.dep|t_id = :|
|00001850| 69 5f 64 65 70 74 5f 6e | 75 6d 20 20 20 3b 0d 0a |i_dept_n|um ;..|
|00001860| 0d 0a 0d 0a 69 66 20 73 | 71 6c 63 61 2e 73 71 6c |....if s|qlca.sql|
|00001870| 63 6f 64 65 20 3c 20 30 | 20 6f 72 20 73 71 6c 63 |code < 0| or sqlc|
|00001880| 61 2e 73 71 6c 63 6f 64 | 65 20 3d 20 31 30 30 20 |a.sqlcod|e = 100 |
|00001890| 74 68 65 6e 0d 0a 2f 2f | 09 4d 65 73 73 61 67 65 |then..//|.Message|
|000018a0| 42 6f 78 20 28 22 66 5f | 64 65 70 74 5f 6c 6f 6f |Box ("f_|dept_loo|
|000018b0| 6b 75 70 22 2c 20 22 73 | 71 6c 20 65 72 72 6f 72 |kup", "s|ql error|
|000018c0| 3a 20 22 20 2b 20 73 71 | 6c 63 61 2e 73 71 6c 65 |: " + sq|lca.sqle|
|000018d0| 72 72 74 65 78 74 29 0d | 0a 09 72 65 74 75 72 6e |rrtext).|..return|
|000018e0| 20 46 41 4c 53 45 0d 0a | 65 6c 73 65 0d 0a 09 72 | FALSE..|else...r|
|000018f0| 65 74 75 72 6e 20 54 52 | 55 45 0d 0a 65 6e 64 20 |eturn TR|UE..end |
|00001900| 69 66 0d 0a 0d 0a 65 6e | 64 20 66 75 6e 63 74 69 |if....en|d functi|
|00001910| 6f 6e 0d 0a 0d 0a 00 00 | 00 00 00 00 00 00 00 00 |on......|........|
|00001920| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001930| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001940| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001950| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001960| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001970| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001980| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001990| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000019a0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000019b0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000019c0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000019d0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000019e0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000019f0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001a00| 44 41 54 2a 00 1c 00 00 | f6 01 11 00 02 00 00 00 |DAT*....|........|
|00001a10| 00 00 00 00 28 94 72 2c | 7e 73 87 2c 08 00 04 00 |....(.r,|~s.,....|
|00001a20| 17 00 00 00 38 40 38 40 | 01 c4 27 00 89 00 38 40 |....8@8@|..'...8@|
|00001a30| 01 80 c9 81 3e 00 26 89 | 01 80 00 00 ea 26 55 00 |....>.&.|.....&U.|
|00001a40| 00 00 26 40 26 40 01 c1 | 64 00 00 00 66 5f 6d 61 |..&@&@..|d...f_ma|
|00001a50| 69 6c 5f 65 72 72 6f 72 | 5f 74 6f 5f 73 74 72 69 |il_error|_to_stri|
|00001a60| 6e 67 00 66 75 6e 63 74 | 69 6f 6e 5f 6f 62 6a 65 |ng.funct|ion_obje|
|00001a70| 63 74 00 66 5f 6d 61 69 | 6c 5f 65 72 72 6f 72 5f |ct.f_mai|l_error_|
|00001a80| 74 6f 5f 73 74 72 69 6e | 67 00 66 5f 6d 61 69 6c |to_strin|g.f_mail|
|00001a90| 5f 65 72 72 6f 72 5f 74 | 6f 5f 73 74 72 69 6e 67 |_error_t|o_string|
|00001aa0| 00 6d 61 69 6c 72 65 74 | 75 72 6e 63 6f 64 65 00 |.mailret|urncode.|
|00001ab0| 10 00 32 00 08 00 00 00 | 00 00 00 00 00 00 01 00 |..2.....|........|
|00001ac0| 01 00 79 00 00 00 61 5f | 6d 61 69 6c 72 65 74 75 |..y...a_|mailretu|
|00001ad0| 72 6e 63 6f 64 65 00 61 | 5f 6d 65 73 73 61 67 65 |rncode.a|_message|
|00001ae0| 00 61 5f 64 69 73 70 6c | 61 79 00 66 5f 6d 61 69 |.a_displ|ay.f_mai|
|00001af0| 6c 5f 65 72 72 6f 72 5f | 74 6f 5f 73 74 72 69 6e |l_error_|to_strin|
|00001b00| 67 00 01 00 02 80 ff ff | 00 00 01 00 06 00 ff ff |g.......|........|
|00001b10| 11 00 01 00 07 00 ff ff | 1b 00 61 5f 6d 61 69 6c |........|..a_mail|
|00001b20| 72 65 74 75 72 6e 63 6f | 64 65 00 61 5f 6d 65 73 |returnco|de.a_mes|
|00001b30| 73 61 67 65 00 61 5f 64 | 69 73 70 6c 61 79 00 0a |sage.a_d|isplay..|
|00001b40| 00 78 00 11 00 36 00 00 | 00 66 75 6e 63 74 69 6f |.x...6..|.functio|
|00001b50| 6e 5f 6f 62 6a 65 63 74 | 00 66 5f 6d 61 69 6c 5f |n_object|.f_mail_|
|00001b60| 65 72 72 6f 72 5f 74 6f | 5f 73 74 72 69 6e 67 00 |error_to|_string.|
|00001b70| 6d 61 69 6c 72 65 74 75 | 72 6e 63 6f 64 65 00 1e |mailretu|rncode..|
|00001b80| 00 00 00 a0 14 00 00 00 | 00 89 46 10 00 80 14 00 |........|..F.....|
|00001b90| 00 00 00 89 35 27 00 a0 | 14 00 00 03 00 8a 07 14 |....5'..|........|
|00001ba0| 00 f0 00 11 00 00 00 00 | 00 00 00 c1 2c 01 80 6f |........|....,..o|
|00001bb0| 6f 6c 62 00 80 00 c0 00 | 00 01 00 00 00 00 00 00 |olb.....|........|
|00001bc0| 00 01 00 02 00 01 00 01 | 00 01 00 00 00 6a 02 29 |........|.....j.)|
|00001bd0| 00 1c 00 04 00 1c 00 00 | 00 8a 00 3b 00 06 00 26 |........|...;...&|
|00001be0| 40 1c 00 04 00 b3 00 03 | 00 28 00 1c 00 03 00 39 |@.......|.(.....9|
|00001bf0| 00 00 00 86 00 04 00 30 | 02 3b 00 0a 00 26 40 1c |.......0|.;...&@.|
|00001c00| 44 41 54 2a 00 1e 00 00 | f6 01 00 04 00 b3 00 03 |DAT*....|........|
|00001c10| 00 46 00 1c 00 03 00 39 | 00 0e 00 86 00 04 00 30 |.F.....9|.......0|
|00001c20| 02 3b 00 0b 00 26 40 1c | 00 04 00 b3 00 03 00 64 |.;...&@.|.......d|
|00001c30| 00 1c 00 03 00 39 00 23 | 00 86 00 04 00 30 02 3b |.....9.#|.....0.;|
|00001c40| 00 0c 00 26 40 1c 00 04 | 00 b3 00 03 00 82 00 1c |...&@...|........|
|00001c50| 00 03 00 39 00 3b 00 86 | 00 04 00 30 02 3b 00 04 |...9.;..|...0.;..|
|00001c60| 00 26 40 1c 00 04 00 b3 | 00 03 00 a0 00 1c 00 03 |.&@.....|........|
|00001c70| 00 39 00 54 00 86 00 04 | 00 30 02 3b 00 01 00 26 |.9.T....|.0.;...&|
|00001c80| 40 1c 00 04 00 b3 00 03 | 00 be 00 1c 00 03 00 39 |@.......|.......9|
|00001c90| 00 5e 00 86 00 04 00 30 | 02 3b 00 05 00 26 40 1c |.^.....0|.;...&@.|
|00001ca0| 00 04 00 b3 00 03 00 dc | 00 1c 00 03 00 39 00 66 |........|.....9.f|
|00001cb0| 00 86 00 04 00 30 02 3b | 00 0e 00 26 40 1c 00 04 |.....0.;|...&@...|
|00001cc0| 00 b3 00 03 00 fa 00 1c | 00 03 00 39 00 7a 00 86 |........|...9.z..|
|00001cd0| 00 04 00 30 02 3b 00 03 | 00 26 40 1c 00 04 00 b3 |...0.;..|.&@.....|
|00001ce0| 00 03 00 18 01 1c 00 03 | 00 39 00 8a 00 86 00 04 |........|.9......|
|00001cf0| 00 30 02 3b 00 10 00 26 | 40 1c 00 04 00 b3 00 03 |.0.;...&|@.......|
|00001d00| 00 36 01 1c 00 03 00 39 | 00 98 00 86 00 04 00 30 |.6.....9|.......0|
|00001d10| 02 3b 00 11 00 26 40 1c | 00 04 00 b3 00 03 00 54 |.;...&@.|.......T|
|00001d20| 01 1c 00 03 00 39 00 a7 | 00 86 00 04 00 30 02 3b |.....9..|.....0.;|
|00001d30| 00 00 00 26 40 1c 00 04 | 00 b3 00 03 00 72 01 1c |...&@...|.....r..|
|00001d40| 00 03 00 39 00 b3 00 86 | 00 04 00 30 02 3b 00 0f |...9....|...0.;..|
|00001d50| 00 26 40 1c 00 04 00 b3 | 00 03 00 90 01 1c 00 03 |.&@.....|........|
|00001d60| 00 39 00 bb 00 86 00 04 | 00 30 02 3b 00 08 00 26 |.9......|.0.;...&|
|00001d70| 40 1c 00 04 00 b3 00 03 | 00 ae 01 1c 00 03 00 39 |@.......|.......9|
|00001d80| 00 ca 00 86 00 04 00 30 | 02 3b 00 09 00 26 40 1c |.......0|.;...&@.|
|00001d90| 00 04 00 b3 00 03 00 cc | 01 1c 00 03 00 39 00 d9 |........|.....9..|
|00001da0| 00 86 00 04 00 30 02 3b | 00 07 00 26 40 1c 00 04 |.....0.;|...&@...|
|00001db0| 00 b3 00 03 00 ea 01 1c | 00 03 00 39 00 ed 00 86 |........|...9....|
|00001dc0| 00 04 00 30 02 3b 00 0d | 00 26 40 1c 00 04 00 b3 |...0.;..|.&@.....|
|00001dd0| 00 03 00 08 02 1c 00 03 | 00 39 00 ff 00 86 00 04 |........|.9......|
|00001de0| 00 30 02 3b 00 02 00 26 | 40 1c 00 04 00 b3 00 03 |.0.;...&|@.......|
|00001df0| 00 26 02 1c 00 03 00 39 | 00 11 01 86 00 04 00 30 |.&.....9|.......0|
|00001e00| 44 41 54 2a 00 20 00 00 | f6 01 02 1c 00 03 00 39 |DAT*. ..|.......9|
|00001e10| 00 1c 01 86 00 1c 00 02 | 00 03 00 5a 02 39 00 22 |........|...Z.9."|
|00001e20| 01 1c 00 01 00 39 00 33 | 01 7b 00 1c 00 03 00 7b |.....9.3|.{.....{|
|00001e30| 00 3b 00 02 00 1c 40 28 | 00 7c 00 03 00 14 00 1c |.;....@(|.|......|
|00001e40| 00 03 00 01 00 01 00 00 | 00 01 00 00 00 01 00 08 |........|........|
|00001e50| 00 00 00 09 00 0a 00 0a | 00 1a 00 0b 00 24 00 0c |........|.....$..|
|00001e60| 00 38 00 0d 00 42 00 0e | 00 56 00 0f 00 60 00 10 |.8...B..|.V...`..|
|00001e70| 00 74 00 11 00 7e 00 12 | 00 92 00 13 00 9c 00 14 |.t...~..|........|
|00001e80| 00 b0 00 15 00 ba 00 16 | 00 ce 00 17 00 d8 00 18 |........|........|
|00001e90| 00 ec 00 19 00 f6 00 1a | 00 0a 01 1b 00 14 01 1c |........|........|
|00001ea0| 00 28 01 1d 00 32 01 1e | 00 46 01 1f 00 50 01 20 |.(...2..|.F...P. |
|00001eb0| 00 64 01 21 00 6e 01 22 | 00 82 01 23 00 8c 01 24 |.d.!.n."|...#...$|
|00001ec0| 00 a0 01 25 00 aa 01 26 | 00 be 01 27 00 c8 01 28 |...%...&|...'...(|
|00001ed0| 00 dc 01 29 00 e6 01 2a | 00 fa 01 2b 00 04 02 2c |...)...*|...+...,|
|00001ee0| 00 18 02 2e 00 22 02 2f | 00 26 02 32 00 30 02 34 |....."./|.&.2.0.4|
|00001ef0| 00 5a 02 10 00 64 00 08 | 00 2e 00 00 00 61 5f 6d |.Z...d..|.....a_m|
|00001f00| 61 69 6c 72 65 74 75 72 | 6e 63 6f 64 65 00 61 5f |ailretur|ncode.a_|
|00001f10| 6d 65 73 73 61 67 65 00 | 61 5f 64 69 73 70 6c 61 |message.|a_displa|
|00001f20| 79 00 73 00 01 63 61 73 | 65 38 00 32 00 00 00 81 |y.s..cas|e8.2....|
|00001f30| 04 02 80 00 00 1f 22 11 | 00 80 0c 06 00 00 00 00 |......".|........|
|00001f40| 00 1b 00 80 04 07 00 00 | 00 1f 22 25 00 80 0c 06 |........|.."%....|
|00001f50| 00 00 00 00 00 27 00 9f | 04 02 80 00 00 1f 22 35 |.....'..|......"5|
|00001f60| 01 00 00 41 63 63 65 73 | 73 20 44 65 6e 69 65 64 |...Acces|s Denied|
|00001f70| 00 41 74 74 61 63 68 6d | 65 6e 74 20 4e 6f 74 20 |.Attachm|ent Not |
|00001f80| 46 6f 75 6e 64 00 41 74 | 74 61 63 68 6d 65 6e 74 |Found.At|tachment|
|00001f90| 20 4f 70 65 6e 20 46 61 | 69 6c 75 72 65 00 41 74 | Open Fa|ilure.At|
|00001fa0| 74 61 63 68 6d 65 6e 74 | 20 57 72 69 74 65 20 46 |tachment| Write F|
|00001fb0| 61 69 6c 75 72 65 00 44 | 69 73 6b 20 46 75 6c 6c |ailure.D|isk Full|
|00001fc0| 00 46 61 69 6c 75 72 65 | 00 49 6e 73 75 66 66 69 |.Failure|.Insuffi|
|00001fd0| 63 69 65 6e 74 20 4d 65 | 6d 6f 72 79 00 49 6e 76 |cient Me|mory.Inv|
|00001fe0| 61 6c 69 64 20 4d 65 73 | 73 61 67 65 00 4c 6f 67 |alid Mes|sage.Log|
|00001ff0| 69 6e 20 46 61 69 6c 75 | 72 65 00 4d 65 73 73 61 |in Failu|re.Messa|
|00002000| 44 41 54 2a 00 00 00 00 | e5 00 67 65 20 49 6e 20 |DAT*....|..ge In |
|00002010| 55 73 65 00 4e 6f 20 4d | 65 73 73 61 67 65 73 00 |Use.No M|essages.|
|00002020| 53 75 63 63 65 73 73 00 | 54 65 78 74 20 54 6f 6f |Success.|Text Too|
|00002030| 20 4c 61 72 67 65 00 54 | 6f 6f 20 4d 61 6e 79 20 | Large.T|oo Many |
|00002040| 46 69 6c 65 73 00 54 6f | 6f 20 4d 61 6e 79 20 52 |Files.To|o Many R|
|00002050| 65 63 69 70 69 65 6e 74 | 73 00 54 6f 6f 20 4d 61 |ecipient|s.Too Ma|
|00002060| 6e 79 20 53 65 73 73 69 | 6f 6e 73 00 55 6e 6b 6e |ny Sessi|ons.Unkn|
|00002070| 6f 77 6e 20 52 65 63 69 | 70 69 65 6e 74 00 55 73 |own Reci|pient.Us|
|00002080| 65 72 20 41 62 6f 72 74 | 00 4f 74 68 65 72 00 4d |er Abort|.Other.M|
|00002090| 61 69 6c 20 52 65 74 75 | 72 6e 20 43 6f 64 65 00 |ail Retu|rn Code.|
|000020a0| 20 00 00 00 00 00 01 00 | 00 00 10 00 32 00 0b 00 | .......|....2...|
|000020b0| 17 00 00 00 66 5f 6d 61 | 69 6c 5f 65 72 72 6f 72 |....f_ma|il_error|
|000020c0| 5f 74 6f 5f 73 74 72 69 | 6e 67 00 0a 00 00 00 80 |_to_stri|ng......|
|000020d0| 14 06 00 00 00 00 00 10 | 00 32 00 0b 00 00 00 00 |........|.2......|
|000020e0| 00 00 00 25 00 00 00 06 | 00 3c 00 03 80 1a 00 00 |...%....|.<......|
|000020f0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002100| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002110| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002120| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002130| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002140| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002150| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002160| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002170| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002180| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002190| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000021a0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000021b0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000021c0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000021d0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000021e0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000021f0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002200| 44 41 54 2a 00 24 00 00 | f6 01 43 6f 6e 76 65 72 |DAT*.$..|..Conver|
|00002210| 74 20 4d 61 69 6c 20 52 | 65 74 75 72 6e 20 43 6f |t Mail R|eturn Co|
|00002220| 64 65 20 28 65 6e 75 6d | 65 72 61 74 65 64 29 20 |de (enum|erated) |
|00002230| 74 6f 20 61 20 73 74 72 | 69 6e 67 67 6c 6f 62 61 |to a str|inggloba|
|00002240| 6c 20 74 79 70 65 20 66 | 5f 6d 61 69 6c 5f 65 72 |l type f|_mail_er|
|00002250| 72 6f 72 5f 74 6f 5f 73 | 74 72 69 6e 67 20 66 72 |ror_to_s|tring fr|
|00002260| 6f 6d 20 66 75 6e 63 74 | 69 6f 6e 5f 6f 62 6a 65 |om funct|ion_obje|
|00002270| 63 74 0d 0a 65 6e 64 20 | 74 79 70 65 0d 0a 0d 0a |ct..end |type....|
|00002280| 66 6f 72 77 61 72 64 20 | 70 72 6f 74 6f 74 79 70 |forward |prototyp|
|00002290| 65 73 0d 0a 67 6c 6f 62 | 61 6c 20 66 75 6e 63 74 |es..glob|al funct|
|000022a0| 69 6f 6e 20 73 74 72 69 | 6e 67 20 66 5f 6d 61 69 |ion stri|ng f_mai|
|000022b0| 6c 5f 65 72 72 6f 72 5f | 74 6f 5f 73 74 72 69 6e |l_error_|to_strin|
|000022c0| 67 20 28 6d 61 69 6c 72 | 65 74 75 72 6e 63 6f 64 |g (mailr|eturncod|
|000022d0| 65 20 61 5f 6d 61 69 6c | 72 65 74 75 72 6e 63 6f |e a_mail|returnco|
|000022e0| 64 65 2c 20 73 74 72 69 | 6e 67 20 61 5f 6d 65 73 |de, stri|ng a_mes|
|000022f0| 73 61 67 65 2c 20 62 6f | 6f 6c 65 61 6e 20 61 5f |sage, bo|olean a_|
|00002300| 64 69 73 70 6c 61 79 29 | 0d 0a 65 6e 64 20 70 72 |display)|..end pr|
|00002310| 6f 74 6f 74 79 70 65 73 | 0d 0a 0d 0a 67 6c 6f 62 |ototypes|....glob|
|00002320| 61 6c 20 66 75 6e 63 74 | 69 6f 6e 20 73 74 72 69 |al funct|ion stri|
|00002330| 6e 67 20 66 5f 6d 61 69 | 6c 5f 65 72 72 6f 72 5f |ng f_mai|l_error_|
|00002340| 74 6f 5f 73 74 72 69 6e | 67 20 28 6d 61 69 6c 72 |to_strin|g (mailr|
|00002350| 65 74 75 72 6e 63 6f 64 | 65 20 61 5f 6d 61 69 6c |eturncod|e a_mail|
|00002360| 72 65 74 75 72 6e 63 6f | 64 65 2c 20 73 74 72 69 |returnco|de, stri|
|00002370| 6e 67 20 61 5f 6d 65 73 | 73 61 67 65 2c 20 62 6f |ng a_mes|sage, bo|
|00002380| 6f 6c 65 61 6e 20 61 5f | 64 69 73 70 6c 61 79 29 |olean a_|display)|
|00002390| 3b 2f 2f 20 46 75 6e 63 | 74 69 6f 6e 20 20 66 5f |;// Func|tion f_|
|000023a0| 6d 61 69 6c 5f 65 72 72 | 6f 72 5f 74 6f 5f 73 74 |mail_err|or_to_st|
|000023b0| 72 69 6e 67 20 28 20 61 | 5f 4d 61 69 6c 52 65 74 |ring ( a|_MailRet|
|000023c0| 75 72 6e 43 6f 64 65 2c | 20 61 5f 44 69 73 70 6c |urnCode,| a_Displ|
|000023d0| 61 79 29 0d 0a 2f 2f 20 | 77 68 65 72 65 3a 09 61 |ay)..// |where:.a|
|000023e0| 5f 4d 61 69 6c 52 65 74 | 75 72 6e 43 6f 64 65 09 |_MailRet|urnCode.|
|000023f0| 4d 61 69 6c 52 65 74 75 | 72 6e 43 6f 64 65 20 76 |MailRetu|rnCode v|
|00002400| 44 41 54 2a 00 26 00 00 | f6 01 61 6c 75 65 0d 0a |DAT*.&..|..alue..|
|00002410| 2f 2f 09 09 09 61 5f 4d | 65 73 73 61 67 65 09 09 |//...a_M|essage..|
|00002420| 09 45 72 72 6f 72 20 6d | 65 73 73 61 67 65 20 74 |.Error m|essage t|
|00002430| 6f 20 70 72 65 70 65 6e | 64 20 74 6f 20 72 65 74 |o prepen|d to ret|
|00002440| 75 72 6e 20 73 74 72 69 | 6e 67 0d 0a 2f 2f 09 09 |urn stri|ng..//..|
|00002450| 09 61 5f 44 69 73 70 6c | 61 79 09 09 09 42 6f 6f |.a_Displ|ay...Boo|
|00002460| 6c 65 61 6e 20 28 54 52 | 55 45 3d 64 69 73 70 6c |lean (TR|UE=displ|
|00002470| 61 79 20 65 72 72 6f 72 | 20 6d 65 73 73 61 67 65 |ay error| message|
|00002480| 62 6f 78 29 0d 0a 0d 0a | 73 74 72 69 6e 67 09 73 |box)....|string.s|
|00002490| 0d 0a 0d 0a 63 68 6f 6f | 73 65 20 63 61 73 65 20 |....choo|se case |
|000024a0| 61 5f 4d 61 69 6c 52 65 | 74 75 72 6e 43 6f 64 65 |a_MailRe|turnCode|
|000024b0| 0d 0a 09 63 61 73 65 20 | 6d 61 69 6c 52 65 74 75 |...case |mailRetu|
|000024c0| 72 6e 41 63 63 65 73 73 | 44 65 6e 69 65 64 21 0d |rnAccess|Denied!.|
|000024d0| 0a 09 09 73 20 3d 20 27 | 41 63 63 65 73 73 20 44 |...s = '|Access D|
|000024e0| 65 6e 69 65 64 27 0d 0a | 09 63 61 73 65 20 6d 61 |enied'..|.case ma|
|000024f0| 69 6c 52 65 74 75 72 6e | 41 74 74 61 63 68 6d 65 |ilReturn|Attachme|
|00002500| 6e 74 4e 6f 74 46 6f 75 | 6e 64 21 0d 0a 09 09 73 |ntNotFou|nd!....s|
|00002510| 20 3d 20 27 41 74 74 61 | 63 68 6d 65 6e 74 20 4e | = 'Atta|chment N|
|00002520| 6f 74 20 46 6f 75 6e 64 | 27 0d 0a 09 63 61 73 65 |ot Found|'...case|
|00002530| 20 6d 61 69 6c 52 65 74 | 75 72 6e 41 74 74 61 63 | mailRet|urnAttac|
|00002540| 68 6d 65 6e 74 4f 70 65 | 6e 46 61 69 6c 75 72 65 |hmentOpe|nFailure|
|00002550| 21 0d 0a 09 09 73 20 3d | 20 27 41 74 74 61 63 68 |!....s =| 'Attach|
|00002560| 6d 65 6e 74 20 4f 70 65 | 6e 20 46 61 69 6c 75 72 |ment Ope|n Failur|
|00002570| 65 27 0d 0a 09 63 61 73 | 65 20 6d 61 69 6c 52 65 |e'...cas|e mailRe|
|00002580| 74 75 72 6e 41 74 74 61 | 63 68 6d 65 6e 74 57 72 |turnAtta|chmentWr|
|00002590| 69 74 65 46 61 69 6c 75 | 72 65 21 0d 0a 09 09 73 |iteFailu|re!....s|
|000025a0| 20 3d 20 27 41 74 74 61 | 63 68 6d 65 6e 74 20 57 | = 'Atta|chment W|
|000025b0| 72 69 74 65 20 46 61 69 | 6c 75 72 65 27 0d 0a 09 |rite Fai|lure'...|
|000025c0| 63 61 73 65 20 6d 61 69 | 6c 52 65 74 75 72 6e 44 |case mai|lReturnD|
|000025d0| 69 73 6b 46 75 6c 6c 21 | 0d 0a 09 09 73 20 3d 20 |iskFull!|....s = |
|000025e0| 27 44 69 73 6b 20 46 75 | 6c 6c 27 0d 0a 09 63 61 |'Disk Fu|ll'...ca|
|000025f0| 73 65 20 6d 61 69 6c 52 | 65 74 75 72 6e 46 61 69 |se mailR|eturnFai|
|00002600| 44 41 54 2a 00 28 00 00 | f6 01 6c 75 72 65 21 0d |DAT*.(..|..lure!.|
|00002610| 0a 09 09 73 20 3d 20 27 | 46 61 69 6c 75 72 65 27 |...s = '|Failure'|
|00002620| 0d 0a 09 63 61 73 65 20 | 6d 61 69 6c 52 65 74 75 |...case |mailRetu|
|00002630| 72 6e 49 6e 73 75 66 66 | 69 63 69 65 6e 74 4d 65 |rnInsuff|icientMe|
|00002640| 6d 6f 72 79 21 0d 0a 09 | 09 73 20 3d 20 27 49 6e |mory!...|.s = 'In|
|00002650| 73 75 66 66 69 63 69 65 | 6e 74 20 4d 65 6d 6f 72 |sufficie|nt Memor|
|00002660| 79 27 0d 0a 09 63 61 73 | 65 20 6d 61 69 6c 52 65 |y'...cas|e mailRe|
|00002670| 74 75 72 6e 49 6e 76 61 | 6c 69 64 4d 65 73 73 61 |turnInva|lidMessa|
|00002680| 67 65 21 0d 0a 09 09 73 | 20 3d 20 27 49 6e 76 61 |ge!....s| = 'Inva|
|00002690| 6c 69 64 20 4d 65 73 73 | 61 67 65 27 0d 0a 09 63 |lid Mess|age'...c|
|000026a0| 61 73 65 20 6d 61 69 6c | 52 65 74 75 72 6e 4c 6f |ase mail|ReturnLo|
|000026b0| 67 69 6e 46 61 69 6c 75 | 72 65 21 0d 0a 09 09 73 |ginFailu|re!....s|
|000026c0| 20 3d 20 27 4c 6f 67 69 | 6e 20 46 61 69 6c 75 72 | = 'Logi|n Failur|
|000026d0| 65 27 0d 0a 09 63 61 73 | 65 20 6d 61 69 6c 52 65 |e'...cas|e mailRe|
|000026e0| 74 75 72 6e 4d 65 73 73 | 61 67 65 49 6e 55 73 65 |turnMess|ageInUse|
|000026f0| 21 0d 0a 09 09 73 20 3d | 20 27 4d 65 73 73 61 67 |!....s =| 'Messag|
|00002700| 65 20 49 6e 20 55 73 65 | 27 0d 0a 09 63 61 73 65 |e In Use|'...case|
|00002710| 20 6d 61 69 6c 52 65 74 | 75 72 6e 4e 6f 4d 65 73 | mailRet|urnNoMes|
|00002720| 73 61 67 65 73 21 0d 0a | 09 09 73 20 3d 20 27 4e |sages!..|..s = 'N|
|00002730| 6f 20 4d 65 73 73 61 67 | 65 73 27 0d 0a 09 63 61 |o Messag|es'...ca|
|00002740| 73 65 20 6d 61 69 6c 52 | 65 74 75 72 6e 53 75 63 |se mailR|eturnSuc|
|00002750| 63 65 73 73 21 0d 0a 09 | 09 73 20 3d 20 27 53 75 |cess!...|.s = 'Su|
|00002760| 63 63 65 73 73 27 0d 0a | 09 63 61 73 65 20 6d 61 |ccess'..|.case ma|
|00002770| 69 6c 52 65 74 75 72 6e | 54 65 78 74 54 6f 6f 4c |ilReturn|TextTooL|
|00002780| 61 72 67 65 21 0d 0a 09 | 09 73 20 3d 20 27 54 65 |arge!...|.s = 'Te|
|00002790| 78 74 20 54 6f 6f 20 4c | 61 72 67 65 27 0d 0a 09 |xt Too L|arge'...|
|000027a0| 63 61 73 65 20 6d 61 69 | 6c 52 65 74 75 72 6e 54 |case mai|lReturnT|
|000027b0| 6f 6f 4d 61 6e 79 46 69 | 6c 65 73 21 0d 0a 09 09 |ooManyFi|les!....|
|000027c0| 73 20 3d 20 27 54 6f 6f | 20 4d 61 6e 79 20 46 69 |s = 'Too| Many Fi|
|000027d0| 6c 65 73 27 0d 0a 09 63 | 61 73 65 20 6d 61 69 6c |les'...c|ase mail|
|000027e0| 52 65 74 75 72 6e 54 6f | 6f 4d 61 6e 79 52 65 63 |ReturnTo|oManyRec|
|000027f0| 69 70 69 65 6e 74 73 21 | 0d 0a 09 09 73 20 3d 20 |ipients!|....s = |
|00002800| 44 41 54 2a 00 00 00 00 | 68 01 27 54 6f 6f 20 4d |DAT*....|h.'Too M|
|00002810| 61 6e 79 20 52 65 63 69 | 70 69 65 6e 74 73 27 0d |any Reci|pients'.|
|00002820| 0a 09 63 61 73 65 20 6d | 61 69 6c 52 65 74 75 72 |..case m|ailRetur|
|00002830| 6e 54 6f 6f 4d 61 6e 79 | 53 65 73 73 69 6f 6e 73 |nTooMany|Sessions|
|00002840| 21 0d 0a 09 09 73 20 3d | 20 27 54 6f 6f 20 4d 61 |!....s =| 'Too Ma|
|00002850| 6e 79 20 53 65 73 73 69 | 6f 6e 73 27 0d 0a 09 63 |ny Sessi|ons'...c|
|00002860| 61 73 65 20 6d 61 69 6c | 52 65 74 75 72 6e 55 6e |ase mail|ReturnUn|
|00002870| 6b 6e 6f 77 6e 52 65 63 | 69 70 69 65 6e 74 21 0d |knownRec|ipient!.|
|00002880| 0a 09 09 73 20 3d 20 27 | 55 6e 6b 6e 6f 77 6e 20 |...s = '|Unknown |
|00002890| 52 65 63 69 70 69 65 6e | 74 27 0d 0a 09 63 61 73 |Recipien|t'...cas|
|000028a0| 65 20 6d 61 69 6c 52 65 | 74 75 72 6e 55 73 65 72 |e mailRe|turnUser|
|000028b0| 41 62 6f 72 74 21 0d 0a | 09 09 73 20 3d 20 27 55 |Abort!..|..s = 'U|
|000028c0| 73 65 72 20 41 62 6f 72 | 74 27 0d 0a 0d 0a 09 63 |ser Abor|t'.....c|
|000028d0| 61 73 65 20 65 6c 73 65 | 0d 0a 09 09 73 20 3d 20 |ase else|....s = |
|000028e0| 27 4f 74 68 65 72 27 0d | 0a 65 6e 64 20 63 68 6f |'Other'.|.end cho|
|000028f0| 6f 73 65 0d 0a 0d 0a 69 | 66 20 61 5f 44 69 73 70 |ose....i|f a_Disp|
|00002900| 6c 61 79 20 74 68 65 6e | 20 4d 65 73 73 61 67 65 |lay then| Message|
|00002910| 42 6f 78 20 28 20 27 4d | 61 69 6c 20 52 65 74 75 |Box ( 'M|ail Retu|
|00002920| 72 6e 20 43 6f 64 65 27 | 2c 20 61 5f 4d 65 73 73 |rn Code'|, a_Mess|
|00002930| 61 67 65 20 2b 20 27 20 | 27 20 2b 20 73 2c 20 45 |age + ' |' + s, E|
|00002940| 78 63 6c 61 6d 61 74 69 | 6f 6e 21 29 0d 0a 0d 0a |xclamati|on!)....|
|00002950| 72 65 74 75 72 6e 20 73 | 0d 0a 0d 0a 0d 0a 0d 0a |return s|........|
|00002960| 0d 0a 65 6e 64 20 66 75 | 6e 63 74 69 6f 6e 0d 0a |..end fu|nction..|
|00002970| 0d 0a 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002980| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002990| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000029a0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000029b0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000029c0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000029d0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000029e0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000029f0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002a00| 44 41 54 2a 00 2c 00 00 | f6 01 11 00 02 00 00 00 |DAT*.,..|........|
|00002a10| 00 00 00 00 28 94 72 2c | 7f 73 87 2c 08 00 04 00 |....(.r,|.s.,....|
|00002a20| 13 00 00 00 38 40 38 40 | 01 64 23 00 ad 00 38 40 |....8@8@|.d#...8@|
|00002a30| 01 80 e9 71 36 00 5f 6f | 01 80 00 00 6a 72 49 00 |...q6._o|....jrI.|
|00002a40| 00 00 51 40 51 40 01 71 | 54 00 00 00 66 5f 70 61 |..Q@Q@.q|T...f_pa|
|00002a50| 72 73 65 5f 6f 62 6a 5f | 73 74 72 69 6e 67 00 66 |rse_obj_|string.f|
|00002a60| 75 6e 63 74 69 6f 6e 5f | 6f 62 6a 65 63 74 00 66 |unction_|object.f|
|00002a70| 5f 70 61 72 73 65 5f 6f | 62 6a 5f 73 74 72 69 6e |_parse_o|bj_strin|
|00002a80| 67 00 66 5f 70 61 72 73 | 65 5f 6f 62 6a 5f 73 74 |g.f_pars|e_obj_st|
|00002a90| 72 69 6e 67 00 64 61 74 | 61 77 69 6e 64 6f 77 00 |ring.dat|awindow.|
|00002aa0| 10 00 32 00 08 00 00 00 | 00 00 00 00 00 00 01 00 |..2.....|........|
|00002ab0| 01 00 7b 00 00 00 64 77 | 5f 61 72 67 00 01 00 00 |..{...dw|_arg....|
|00002ac0| 00 00 00 6f 62 6a 5f 6c | 69 73 74 00 6f 62 6a 5f |...obj_l|ist.obj_|
|00002ad0| 74 79 70 65 00 62 61 6e | 64 00 66 5f 70 61 72 73 |type.ban|d.f_pars|
|00002ae0| 65 5f 6f 62 6a 5f 73 74 | 72 69 6e 67 00 01 00 02 |e_obj_st|ring....|
|00002af0| 80 ff ff 00 00 08 00 06 | 00 07 00 0d 00 01 00 06 |........|........|
|00002b00| 00 ff ff 16 00 01 00 06 | 00 ff ff 1f 00 64 77 5f |........|.....dw_|
|00002b10| 61 72 67 00 01 00 00 00 | 00 00 6f 62 6a 5f 6c 69 |arg.....|..obj_li|
|00002b20| 73 74 00 6f 62 6a 5f 74 | 79 70 65 00 62 61 6e 64 |st.obj_t|ype.band|
|00002b30| 00 0a 00 78 00 11 00 2e | 00 00 00 66 75 6e 63 74 |...x....|...funct|
|00002b40| 69 6f 6e 5f 6f 62 6a 65 | 63 74 00 66 5f 70 61 72 |ion_obje|ct.f_par|
|00002b50| 73 65 5f 6f 62 6a 5f 73 | 74 72 69 6e 67 00 64 61 |se_obj_s|tring.da|
|00002b60| 74 61 77 69 6e 64 6f 77 | 00 1e 00 00 00 a0 14 00 |tawindow|........|
|00002b70| 00 00 00 00 a0 10 00 80 | 14 00 00 00 00 00 f0 23 |........|.......#|
|00002b80| 00 a0 14 00 00 03 00 00 | c1 14 00 f0 00 11 00 00 |........|........|
|00002b90| 00 00 00 00 00 c1 00 01 | 80 00 00 00 00 00 80 00 |........|........|
|00002ba0| c0 00 00 01 00 00 00 00 | 00 00 00 01 00 02 00 01 |........|........|
|00002bb0| 00 01 00 01 00 00 00 ce | 01 11 00 1c 00 04 00 1c |........|........|
|00002bc0| 00 00 00 39 00 00 00 2a | 00 1e 00 01 00 86 00 1c |...9...*|........|
|00002bd0| 00 08 00 1c 00 04 00 39 | 00 24 00 1c 00 07 00 28 |.......9|.$.....(|
|00002be0| 00 b3 00 03 00 8c 00 01 | 00 7e 00 1c 00 08 00 32 |........|.~.....2|
|00002bf0| 00 00 00 00 00 3d 00 02 | 00 c6 00 03 00 22 01 1c |.....=..|....."..|
|00002c00| 44 41 54 2a 00 2e 00 00 | f6 01 00 05 00 1c 00 04 |DAT*....|........|
|00002c10| 00 1c 00 07 00 1c 00 08 | 00 1c 00 07 00 3d 00 01 |........|.....=..|
|00002c20| 00 3d 00 02 00 5a 00 28 | 00 80 00 03 00 86 00 1c |.=...Z.(|........|
|00002c30| 00 00 00 1c 00 05 00 39 | 00 26 00 7b 00 2a 00 37 |.......9|.&.{.*.7|
|00002c40| 00 01 00 1c 00 02 00 ab | 00 1c 00 02 00 39 00 3d |........|.....9.=|
|00002c50| 00 ab 00 23 00 1c 00 00 | 00 1c 00 05 00 39 00 3f |...#....|.....9.?|
|00002c60| 00 7b 00 2a 00 50 00 01 | 00 1c 00 03 00 ab 00 1c |.{.*.P..|........|
|00002c70| 00 03 00 39 00 56 00 ab | 00 23 00 22 00 03 00 e8 |...9.V..|.#."....|
|00002c80| 00 1c 00 09 00 1c 00 09 | 00 32 00 01 00 00 00 3d |........|.2.....=|
|00002c90| 00 02 00 53 00 8c 00 01 | 00 7e 00 1c 00 01 00 1c |...S....|.~......|
|00002ca0| 00 09 00 26 00 01 00 1c | 00 05 00 86 00 1c 00 07 |...&....|........|
|00002cb0| 00 1c 00 08 00 32 00 01 | 00 00 00 3d 00 02 00 53 |.....2..|...=...S|
|00002cc0| 00 8c 00 01 00 7e 00 1c | 00 08 00 1c 00 04 00 39 |.....~..|.......9|
|00002cd0| 00 58 00 1c 00 07 00 28 | 00 b3 00 03 00 8c 00 01 |.X.....(|........|
|00002ce0| 00 7e 00 04 00 30 00 1c | 00 05 00 1c 00 04 00 1c |.~...0..|........|
|00002cf0| 00 07 00 1c 00 04 00 28 | 00 5f 00 01 00 28 00 80 |.......(|._...(..|
|00002d00| 00 03 00 86 00 1c 00 00 | 00 1c 00 05 00 39 00 5a |........|.....9.Z|
|00002d10| 00 7b 00 2a 00 6b 00 01 | 00 1c 00 02 00 ab 00 1c |.{.*.k..|........|
|00002d20| 00 02 00 39 00 71 00 ab | 00 23 00 1c 00 00 00 1c |...9.q..|.#......|
|00002d30| 00 05 00 39 00 73 00 7b | 00 2a 00 84 00 01 00 1c |...9.s.{|.*......|
|00002d40| 00 03 00 ab 00 1c 00 03 | 00 39 00 8a 00 ab 00 23 |........|.9.....#|
|00002d50| 00 22 00 03 00 be 01 1c | 00 09 00 1c 00 09 00 32 |."......|.......2|
|00002d60| 00 01 00 00 00 3d 00 02 | 00 53 00 8c 00 01 00 7e |.....=..|.S.....~|
|00002d70| 00 1c 00 01 00 1c 00 09 | 00 26 00 01 00 1c 00 05 |........|.&......|
|00002d80| 00 86 00 1c 00 09 00 01 | 00 01 00 00 00 01 00 00 |........|........|
|00002d90| 00 01 00 04 00 00 00 06 | 00 14 00 07 00 30 00 08 |........|.....0..|
|00002da0| 00 44 00 09 00 6a 00 0a | 00 90 00 0b 00 bc 00 0c |.D...j..|........|
|00002db0| 00 d6 00 0e 00 e8 00 0f | 00 02 01 10 00 1e 01 11 |........|........|
|00002dc0| 00 22 01 12 00 40 01 13 | 00 66 01 14 00 92 01 15 |."...@..|.f......|
|00002dd0| 00 ac 01 18 00 be 01 10 | 00 64 00 08 00 56 00 00 |........|.d...V..|
|00002de0| 00 64 77 5f 61 72 67 00 | 6f 62 6a 5f 6c 69 73 74 |.dw_arg.|obj_list|
|00002df0| 00 6f 62 6a 5f 74 79 70 | 65 00 62 61 6e 64 00 6f |.obj_typ|e.band.o|
|00002e00| 44 41 54 2a 00 00 00 00 | 8a 01 62 6a 5f 73 74 72 |DAT*....|..bj_str|
|00002e10| 69 6e 67 00 6f 62 6a 5f | 68 6f 6c 64 65 72 00 6f |ing.obj_|holder.o|
|00002e20| 62 6a 5f 63 6f 75 6e 74 | 00 73 74 61 72 74 5f 70 |bj_count|.start_p|
|00002e30| 6f 73 00 74 61 62 5f 70 | 6f 73 00 63 6f 75 6e 74 |os.tab_p|os.count|
|00002e40| 00 64 00 00 00 80 18 02 | 80 ff ff ff ff 07 00 e0 |.d......|........|
|00002e50| 38 06 00 ff ff 00 00 10 | 00 80 0c 06 00 00 00 00 |8.......|........|
|00002e60| 00 19 00 80 0c 06 00 00 | 00 00 00 1e 00 80 0c 06 |........|........|
|00002e70| 00 00 00 00 00 29 00 80 | 0c 06 00 00 00 00 00 34 |.....)..|.......4|
|00002e80| 00 80 04 01 00 00 00 1f | 22 3e 00 80 04 01 00 01 |........|">......|
|00002e90| 00 00 00 48 00 80 04 01 | 00 00 00 1f 22 50 00 80 |...H....|...."P..|
|00002ea0| 04 01 00 00 00 00 00 8c | 00 00 00 64 61 74 61 77 |........|...dataw|
|00002eb0| 69 6e 64 6f 77 2e 6f 62 | 6a 65 63 74 73 00 64 77 |indow.ob|jects.dw|
|00002ec0| 64 65 73 63 72 69 62 65 | 00 4a 00 00 c0 13 00 09 |describe|.J......|
|00002ed0| 00 2e 74 79 70 65 00 64 | 77 64 65 73 63 72 69 62 |..type.d|wdescrib|
|00002ee0| 65 00 4a 00 00 c0 2c 00 | 2a 00 2e 62 61 6e 64 00 |e.J...,.|*..band.|
|00002ef0| 64 77 64 65 73 63 72 69 | 62 65 00 4a 00 00 c0 45 |dwdescri|be.J...E|
|00002f00| 00 2a 00 09 00 2e 74 79 | 70 65 00 64 77 64 65 73 |.*....ty|pe.dwdes|
|00002f10| 63 72 69 62 65 00 4a 00 | 00 c0 60 00 2a 00 2e 62 |cribe.J.|..`.*..b|
|00002f20| 61 6e 64 00 64 77 64 65 | 73 63 72 69 62 65 00 4a |and.dwde|scribe.J|
|00002f30| 00 00 c0 79 00 2a 00 01 | 00 03 0d 01 00 00 00 00 |...y.*..|........|
|00002f40| 00 80 0c 06 00 00 00 00 | 00 e0 0c ff ff 00 00 01 |........|........|
|00002f50| 00 00 00 10 00 32 00 0b | 00 13 00 00 00 66 5f 70 |.....2..|.....f_p|
|00002f60| 61 72 73 65 5f 6f 62 6a | 5f 73 74 72 69 6e 67 00 |arse_obj|_string.|
|00002f70| 0a 00 00 00 80 14 01 00 | 00 00 6c 6c 10 00 32 00 |........|..ll..2.|
|00002f80| 0b 00 00 00 00 00 00 00 | 24 00 00 00 01 00 37 00 |........|$.....7.|
|00002f90| 04 80 1a 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| 44 41 54 2a 00 32 00 00 | f6 01 55 73 65 64 20 62 |DAT*.2..|..Used b|
|00003010| 79 20 74 68 65 20 51 75 | 69 63 6b 20 53 65 6c 65 |y the Qu|ick Sele|
|00003020| 63 74 20 45 78 61 6d 70 | 6c 65 2e 67 6c 6f 62 61 |ct Examp|le.globa|
|00003030| 6c 20 74 79 70 65 20 66 | 5f 70 61 72 73 65 5f 6f |l type f|_parse_o|
|00003040| 62 6a 5f 73 74 72 69 6e | 67 20 66 72 6f 6d 20 66 |bj_strin|g from f|
|00003050| 75 6e 63 74 69 6f 6e 5f | 6f 62 6a 65 63 74 0d 0a |unction_|object..|
|00003060| 65 6e 64 20 74 79 70 65 | 0d 0a 0d 0a 66 6f 72 77 |end type|....forw|
|00003070| 61 72 64 20 70 72 6f 74 | 6f 74 79 70 65 73 0d 0a |ard prot|otypes..|
|00003080| 67 6c 6f 62 61 6c 20 66 | 75 6e 63 74 69 6f 6e 20 |global f|unction |
|00003090| 69 6e 74 20 66 5f 70 61 | 72 73 65 5f 6f 62 6a 5f |int f_pa|rse_obj_|
|000030a0| 73 74 72 69 6e 67 20 28 | 64 61 74 61 77 69 6e 64 |string (|datawind|
|000030b0| 6f 77 20 64 77 5f 61 72 | 67 2c 20 72 65 66 20 73 |ow dw_ar|g, ref s|
|000030c0| 74 72 69 6e 67 20 6f 62 | 6a 5f 6c 69 73 74 5b 5d |tring ob|j_list[]|
|000030d0| 2c 20 73 74 72 69 6e 67 | 20 6f 62 6a 5f 74 79 70 |, string| obj_typ|
|000030e0| 65 2c 20 73 74 72 69 6e | 67 20 62 61 6e 64 29 0d |e, strin|g band).|
|000030f0| 0a 65 6e 64 20 70 72 6f | 74 6f 74 79 70 65 73 0d |.end pro|totypes.|
|00003100| 0a 0d 0a 67 6c 6f 62 61 | 6c 20 66 75 6e 63 74 69 |...globa|l functi|
|00003110| 6f 6e 20 69 6e 74 20 66 | 5f 70 61 72 73 65 5f 6f |on int f|_parse_o|
|00003120| 62 6a 5f 73 74 72 69 6e | 67 20 28 64 61 74 61 77 |bj_strin|g (dataw|
|00003130| 69 6e 64 6f 77 20 64 77 | 5f 61 72 67 2c 20 72 65 |indow dw|_arg, re|
|00003140| 66 20 73 74 72 69 6e 67 | 20 6f 62 6a 5f 6c 69 73 |f string| obj_lis|
|00003150| 74 5b 5d 2c 20 73 74 72 | 69 6e 67 20 6f 62 6a 5f |t[], str|ing obj_|
|00003160| 74 79 70 65 2c 20 73 74 | 72 69 6e 67 20 62 61 6e |type, st|ring ban|
|00003170| 64 29 3b 73 74 72 69 6e | 67 20 6f 62 6a 5f 73 74 |d);strin|g obj_st|
|00003180| 72 69 6e 67 2c 20 6f 62 | 6a 5f 68 6f 6c 64 65 72 |ring, ob|j_holder|
|00003190| 0d 0a 69 6e 74 20 6f 62 | 6a 5f 63 6f 75 6e 74 2c |..int ob|j_count,|
|000031a0| 20 73 74 61 72 74 5f 70 | 6f 73 3d 31 2c 20 74 61 | start_p|os=1, ta|
|000031b0| 62 5f 70 6f 73 2c 20 63 | 6f 75 6e 74 20 3d 20 30 |b_pos, c|ount = 0|
|000031c0| 0d 0a 0d 0a 6f 62 6a 5f | 73 74 72 69 6e 67 20 3d |....obj_|string =|
|000031d0| 20 64 77 44 65 73 63 72 | 69 62 65 28 64 77 5f 61 | dwDescr|ibe(dw_a|
|000031e0| 72 67 2c 22 64 61 74 61 | 77 69 6e 64 6f 77 2e 6f |rg,"data|window.o|
|000031f0| 62 6a 65 63 74 73 22 29 | 0d 0a 0d 0a 74 61 62 5f |bjects")|....tab_|
|00003200| 44 41 54 2a 00 34 00 00 | f6 01 70 6f 73 20 3d 20 |DAT*.4..|..pos = |
|00003210| 20 50 6f 73 28 6f 62 6a | 5f 73 74 72 69 6e 67 2c | Pos(obj|_string,|
|00003220| 22 7e 74 22 2c 73 74 61 | 72 74 5f 70 6f 73 29 0d |"~t",sta|rt_pos).|
|00003230| 0a 44 4f 20 57 48 49 4c | 45 20 74 61 62 5f 70 6f |.DO WHIL|E tab_po|
|00003240| 73 20 3e 20 30 0d 0a 09 | 6f 62 6a 5f 68 6f 6c 64 |s > 0...|obj_hold|
|00003250| 65 72 20 3d 20 4d 69 64 | 28 6f 62 6a 5f 73 74 72 |er = Mid|(obj_str|
|00003260| 69 6e 67 2c 73 74 61 72 | 74 5f 70 6f 73 2c 28 74 |ing,star|t_pos,(t|
|00003270| 61 62 5f 70 6f 73 20 2d | 20 73 74 61 72 74 5f 70 |ab_pos -| start_p|
|00003280| 6f 73 29 29 0d 0a 09 49 | 46 20 28 64 77 44 65 73 |os))...I|F (dwDes|
|00003290| 63 72 69 62 65 28 64 77 | 5f 61 72 67 2c 6f 62 6a |cribe(dw|_arg,obj|
|000032a0| 5f 68 6f 6c 64 65 72 2b | 22 2e 74 79 70 65 22 29 |_holder+|".type")|
|000032b0| 20 3d 20 6f 62 6a 5f 74 | 79 70 65 20 6f 72 20 6f | = obj_t|ype or o|
|000032c0| 62 6a 5f 74 79 70 65 20 | 3d 20 22 2a 22 29 20 41 |bj_type |= "*") A|
|000032d0| 4e 44 20 26 0d 0a 09 09 | 20 28 64 77 44 65 73 63 |ND &....| (dwDesc|
|000032e0| 72 69 62 65 28 64 77 5f | 61 72 67 2c 6f 62 6a 5f |ribe(dw_|arg,obj_|
|000032f0| 68 6f 6c 64 65 72 2b 22 | 2e 62 61 6e 64 22 29 20 |holder+"|.band") |
|00003300| 3d 20 62 61 6e 64 20 6f | 72 20 62 61 6e 64 20 3d |= band o|r band =|
|00003310| 20 22 2a 22 29 20 54 48 | 45 4e 0d 0a 09 09 09 63 | "*") TH|EN.....c|
|00003320| 6f 75 6e 74 20 3d 20 63 | 6f 75 6e 74 20 2b 20 31 |ount = c|ount + 1|
|00003330| 0d 0a 09 09 09 6f 62 6a | 5f 6c 69 73 74 5b 63 6f |.....obj|_list[co|
|00003340| 75 6e 74 5d 20 3d 20 6f | 62 6a 5f 68 6f 6c 64 65 |unt] = o|bj_holde|
|00003350| 72 0d 0a 09 45 4e 44 20 | 49 46 0d 0a 73 74 61 72 |r...END |IF..star|
|00003360| 74 5f 70 6f 73 20 3d 20 | 74 61 62 5f 70 6f 73 20 |t_pos = |tab_pos |
|00003370| 2b 20 31 0d 0a 74 61 62 | 5f 70 6f 73 20 3d 20 20 |+ 1..tab|_pos = |
|00003380| 50 6f 73 28 6f 62 6a 5f | 73 74 72 69 6e 67 2c 22 |Pos(obj_|string,"|
|00003390| 7e 74 22 2c 73 74 61 72 | 74 5f 70 6f 73 29 09 0d |~t",star|t_pos)..|
|000033a0| 0a 4c 4f 4f 50 20 0d 0a | 6f 62 6a 5f 68 6f 6c 64 |.LOOP ..|obj_hold|
|000033b0| 65 72 20 3d 20 4d 69 64 | 28 6f 62 6a 5f 73 74 72 |er = Mid|(obj_str|
|000033c0| 69 6e 67 2c 73 74 61 72 | 74 5f 70 6f 73 2c 4c 65 |ing,star|t_pos,Le|
|000033d0| 6e 28 6f 62 6a 5f 73 74 | 72 69 6e 67 29 29 0d 0a |n(obj_st|ring))..|
|000033e0| 49 46 20 28 64 77 44 65 | 73 63 72 69 62 65 28 64 |IF (dwDe|scribe(d|
|000033f0| 77 5f 61 72 67 2c 6f 62 | 6a 5f 68 6f 6c 64 65 72 |w_arg,ob|j_holder|
|00003400| 44 41 54 2a 00 00 00 00 | d0 00 2b 22 2e 74 79 70 |DAT*....|..+".typ|
|00003410| 65 22 29 20 3d 20 6f 62 | 6a 5f 74 79 70 65 20 6f |e") = ob|j_type o|
|00003420| 72 20 6f 62 6a 5f 74 79 | 70 65 20 3d 20 22 2a 22 |r obj_ty|pe = "*"|
|00003430| 29 20 41 4e 44 20 26 0d | 0a 09 09 20 28 64 77 44 |) AND &.|... (dwD|
|00003440| 65 73 63 72 69 62 65 28 | 64 77 5f 61 72 67 2c 6f |escribe(|dw_arg,o|
|00003450| 62 6a 5f 68 6f 6c 64 65 | 72 2b 22 2e 62 61 6e 64 |bj_holde|r+".band|
|00003460| 22 29 20 3d 20 62 61 6e | 64 20 6f 72 20 62 61 6e |") = ban|d or ban|
|00003470| 64 20 3d 20 22 2a 22 29 | 20 54 48 45 4e 0d 0a 09 |d = "*")| THEN...|
|00003480| 63 6f 75 6e 74 20 3d 20 | 63 6f 75 6e 74 20 2b 20 |count = |count + |
|00003490| 31 0d 0a 09 6f 62 6a 5f | 6c 69 73 74 5b 63 6f 75 |1...obj_|list[cou|
|000034a0| 6e 74 5d 20 3d 20 6f 62 | 6a 5f 68 6f 6c 64 65 72 |nt] = ob|j_holder|
|000034b0| 0d 0a 45 4e 44 20 49 46 | 0d 0a 0d 0a 52 65 74 75 |..END IF|....Retu|
|000034c0| 72 6e 20 63 6f 75 6e 74 | 0d 0a 65 6e 64 20 66 75 |rn count|..end fu|
|000034d0| 6e 63 74 69 6f 6e 0d 0a | 0d 0a 00 00 00 00 00 00 |nction..|........|
|000034e0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000034f0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003500| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003510| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003520| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003530| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003540| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003550| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003560| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003570| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003580| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003590| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000035a0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000035b0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000035c0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000035d0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000035e0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000035f0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003600| 44 41 54 2a 00 38 00 00 | f6 01 11 00 02 00 00 00 |DAT*.8..|........|
|00003610| 00 00 00 00 27 94 72 2c | 7f 73 87 2c 08 00 06 00 |....'.r,|.s.,....|
|00003620| 14 00 00 00 38 40 38 40 | 01 64 24 00 4a 00 38 40 |....8@8@|.d$.J.8@|
|00003630| 01 80 e9 61 38 00 65 2e | 01 80 00 00 6a 6f 4c 00 |...a8.e.|....joL.|
|00003640| 00 00 51 40 51 40 01 61 | 57 00 00 00 3f 40 3f 40 |..Q@Q@.a|W...?@?@|
|00003650| 01 01 63 00 32 00 03 80 | 00 00 00 00 69 00 00 00 |..c.2...|....i...|
|00003660| 66 5f 73 65 74 5f 63 6f | 6c 75 6d 6e 5f 73 65 6c |f_set_co|lumn_sel|
|00003670| 65 63 74 00 66 75 6e 63 | 74 69 6f 6e 5f 6f 62 6a |ect.func|tion_obj|
|00003680| 65 63 74 00 66 5f 73 65 | 74 5f 63 6f 6c 75 6d 6e |ect.f_se|t_column|
|00003690| 5f 73 65 6c 65 63 74 00 | 66 5f 73 65 74 5f 63 6f |_select.|f_set_co|
|000036a0| 6c 75 6d 6e 5f 73 65 6c | 65 63 74 00 64 61 74 61 |lumn_sel|ect.data|
|000036b0| 77 69 6e 64 6f 77 00 74 | 72 61 6e 73 61 63 74 69 |window.t|ransacti|
|000036c0| 6f 6e 00 73 71 6c 63 61 | 00 10 00 32 00 08 00 00 |on.sqlca|...2....|
|000036d0| 00 00 00 00 00 00 00 01 | 00 01 00 4e 00 00 00 64 |........|...N...d|
|000036e0| 77 5f 61 72 67 00 74 61 | 62 6c 65 6e 61 6d 65 5f |w_arg.ta|blename_|
|000036f0| 61 72 67 00 66 5f 73 65 | 74 5f 63 6f 6c 75 6d 6e |arg.f_se|t_column|
|00003700| 5f 73 65 6c 65 63 74 00 | 01 00 02 80 ff ff 00 00 |_select.|........|
|00003710| 01 00 06 00 ff ff 07 00 | 64 77 5f 61 72 67 00 74 |........|dw_arg.t|
|00003720| 61 62 6c 65 6e 61 6d 65 | 5f 61 72 67 00 0a 00 78 |ablename|_arg...x|
|00003730| 00 11 00 3b 00 00 00 66 | 75 6e 63 74 69 6f 6e 5f |...;...f|unction_|
|00003740| 6f 62 6a 65 63 74 00 66 | 5f 73 65 74 5f 63 6f 6c |object.f|_set_col|
|00003750| 75 6d 6e 5f 73 65 6c 65 | 63 74 00 64 61 74 61 77 |umn_sele|ct.dataw|
|00003760| 69 6e 64 6f 77 00 74 72 | 61 6e 73 61 63 74 69 6f |indow.tr|ansactio|
|00003770| 6e 00 28 00 00 00 a0 14 | 00 00 00 00 63 74 10 00 |n.(.....|....ct..|
|00003780| 80 14 00 00 00 00 70 65 | 24 00 a0 14 00 00 03 00 |......pe|$.......|
|00003790| 61 72 2f 00 a0 14 00 00 | 04 00 79 70 14 00 f0 00 |ar/.....|..yp....|
|000037a0| 11 00 00 00 00 00 00 00 | c1 50 01 80 67 50 a4 00 |........|.P..gP..|
|000037b0| 00 80 00 c0 00 00 01 00 | 00 00 00 00 00 00 01 00 |........|........|
|000037c0| 02 00 01 00 01 00 01 00 | 00 00 a4 02 30 00 1c 00 |........|....0...|
|000037d0| 05 00 2d 00 04 00 1e 00 | 00 00 25 00 32 00 03 00 |..-.....|..%.2...|
|000037e0| 00 00 28 00 5c 00 02 00 | 28 00 12 01 01 00 86 00 |..(.\...|(.......|
|000037f0| 39 00 04 00 1c 00 05 00 | ab 00 03 00 62 00 1c 00 |9.......|....b...|
|00003800| 44 41 54 2a 00 3a 00 00 | f6 01 02 00 39 00 08 00 |DAT*.:..|....9...|
|00003810| 1c 00 01 00 7b 00 39 00 | 28 00 7b 00 39 00 55 00 |....{.9.|(.{.9.U.|
|00003820| 7b 00 39 00 68 00 7b 00 | 1c 00 01 00 7b 00 39 00 |{.9.h.{.|....{.9.|
|00003830| 7f 00 7b 00 86 00 04 00 | 56 02 39 00 a8 00 1c 00 |..{.....|V.9.....|
|00003840| 05 00 ab 00 03 00 b4 00 | 1c 00 02 00 39 00 ac 00 |........|....9...|
|00003850| 39 00 d1 00 7b 00 39 00 | e7 00 7b 00 1c 00 01 00 |9...{.9.|..{.....|
|00003860| 28 00 12 01 01 00 7b 00 | 39 00 fa 00 7b 00 2d 00 |(.....{.|9...{.-.|
|00003870| 04 00 1e 00 0d 01 25 00 | 28 00 12 01 01 00 7b 00 |......%.|(.....{.|
|00003880| 39 00 11 01 7b 00 86 00 | 04 00 56 02 39 00 22 01 |9...{...|..V.9.".|
|00003890| 1c 00 05 00 ab 00 03 00 | 06 01 1c 00 02 00 39 00 |........|......9.|
|000038a0| 26 01 39 00 4b 01 7b 00 | 39 00 5a 01 7b 00 1c 00 |&.9.K.{.|9.Z.{...|
|000038b0| 01 00 28 00 12 01 01 00 | 7b 00 39 00 6d 01 7b 00 |..(.....|{.9.m.{.|
|000038c0| 2d 00 04 00 1e 00 80 01 | 25 00 28 00 12 01 01 00 |-.......|%.(.....|
|000038d0| 7b 00 39 00 84 01 7b 00 | 86 00 04 00 56 02 39 00 |{.9...{.|....V.9.|
|000038e0| 95 01 1c 00 05 00 ab 00 | 03 00 58 01 1c 00 02 00 |........|..X.....|
|000038f0| 39 00 99 01 39 00 be 01 | 7b 00 39 00 cd 01 7b 00 |9...9...|{.9...{.|
|00003900| 1c 00 01 00 28 00 12 01 | 01 00 7b 00 39 00 e0 01 |....(...|..{.9...|
|00003910| 7b 00 2d 00 04 00 1e 00 | f3 01 25 00 28 00 12 01 |{.-.....|..%.(...|
|00003920| 01 00 7b 00 39 00 f7 01 | 7b 00 86 00 04 00 56 02 |..{.9...|{.....V.|
|00003930| 39 00 08 02 1c 00 05 00 | ab 00 39 00 0c 02 1c 00 |9.......|..9.....|
|00003940| 05 00 ab 00 23 00 39 00 | 10 02 1c 00 05 00 ab 00 |....#.9.|........|
|00003950| 23 00 03 00 c2 01 1c 00 | 02 00 39 00 14 02 39 00 |#.......|..9...9.|
|00003960| 39 02 7b 00 39 00 4f 02 | 7b 00 1c 00 01 00 28 00 |9.{.9.O.|{.....(.|
|00003970| 12 01 01 00 7b 00 39 00 | 62 02 7b 00 2d 00 04 00 |....{.9.|b.{.-...|
|00003980| 1e 00 75 02 25 00 28 00 | 12 01 01 00 7b 00 39 00 |..u.%.(.|....{.9.|
|00003990| 79 02 7b 00 86 00 04 00 | 56 02 39 00 8a 02 1c 00 |y.{.....|V.9.....|
|000039a0| 05 00 ab 00 03 00 14 02 | 1c 00 02 00 39 00 8e 02 |........|....9...|
|000039b0| 39 00 b3 02 7b 00 39 00 | c9 02 7b 00 1c 00 01 00 |9...{.9.|..{.....|
|000039c0| 28 00 12 01 01 00 7b 00 | 39 00 dc 02 7b 00 2d 00 |(.....{.|9...{.-.|
|000039d0| 04 00 1e 00 ef 02 25 00 | 28 00 12 01 01 00 7b 00 |......%.|(.....{.|
|000039e0| 39 00 f3 02 7b 00 86 00 | 04 00 56 02 39 00 04 03 |9...{...|..V.9...|
|000039f0| 1c 00 05 00 ab 00 03 00 | 56 02 1c 00 02 00 39 00 |........|V.....9.|
|00003a00| 44 41 54 2a 00 3c 00 00 | f6 01 08 03 39 00 2d 03 |DAT*.<..|....9.-.|
|00003a10| 7b 00 39 00 47 03 7b 00 | 1c 00 01 00 7b 00 39 00 |{.9.G.{.|....{.9.|
|00003a20| 5a 03 7b 00 2d 00 04 00 | 1e 00 6d 03 25 00 7b 00 |Z.{.-...|..m.%.{.|
|00003a30| 39 00 71 03 7b 00 86 00 | 1c 00 02 00 28 00 5f 00 |9.q.{...|....(._.|
|00003a40| 01 00 32 00 00 00 00 00 | c6 00 03 00 8e 02 1c 00 |..2.....|........|
|00003a50| 03 00 1c 00 00 00 1c 00 | 02 00 2a 00 8f 03 01 00 |........|..*.....|
|00003a60| 7e 00 1c 00 03 00 01 00 | 01 00 00 00 04 00 9e 02 |~.......|........|
|00003a70| 32 00 ff ff ff ff 8c 00 | 01 00 01 00 01 00 00 00 |2.......|........|
|00003a80| 01 00 00 00 01 00 09 00 | 00 00 0b 00 22 00 0c 00 |........|...."...|
|00003a90| 30 00 0d 00 3e 00 0e 00 | 42 00 0f 00 48 00 10 00 |0...>...|B...H...|
|00003aa0| 50 00 12 00 5e 00 13 00 | 70 00 14 00 78 00 15 00 |P...^...|p...x...|
|00003ab0| 7c 00 16 00 8e 00 17 00 | a6 00 19 00 b0 00 1a 00 ||.......|........|
|00003ac0| c2 00 1b 00 ca 00 1c 00 | ce 00 1d 00 e0 00 1e 00 |........|........|
|00003ad0| f8 00 20 00 02 01 21 00 | 14 01 22 00 1c 01 23 00 |.. ...!.|.."...#.|
|00003ae0| 20 01 24 00 32 01 25 00 | 4a 01 27 00 54 01 28 00 | .$.2.%.|J.'.T.(.|
|00003af0| 7e 01 29 00 86 01 2a 00 | 8a 01 2b 00 9c 01 2c 00 |~.)...*.|..+...,.|
|00003b00| b4 01 2e 00 be 01 2f 00 | d0 01 30 00 d8 01 31 00 |....../.|..0...1.|
|00003b10| dc 01 32 00 ee 01 33 00 | 06 02 35 00 10 02 36 00 |..2...3.|..5...6.|
|00003b20| 22 02 37 00 2a 02 38 00 | 2e 02 39 00 36 02 3a 00 |".7.*.8.|..9.6.:.|
|00003b30| 46 02 3e 00 56 02 3f 00 | 6c 02 40 00 80 02 42 00 |F.>.V.?.|l.@...B.|
|00003b40| 8a 02 43 00 8e 02 10 00 | 64 00 08 00 32 00 00 00 |..C.....|d...2...|
|00003b50| 64 77 5f 61 72 67 00 74 | 61 62 6c 65 6e 61 6d 65 |dw_arg.t|ablename|
|00003b60| 5f 61 72 67 00 73 71 6c | 00 6c 72 65 74 75 72 6e |_arg.sql|.lreturn|
|00003b70| 63 6f 64 65 00 73 71 6c | 63 61 00 01 63 61 73 65 |code.sql|ca..case|
|00003b80| 39 00 3c 00 00 00 80 18 | 02 80 ff ff ff ff 07 00 |9.<.....|........|
|00003b90| 80 0c 06 00 00 00 00 00 | 15 00 80 0c 06 00 00 00 |........|........|
|00003ba0| 00 00 19 00 80 04 01 00 | 00 00 1f 22 25 00 20 16 |........|..."%. .|
|00003bb0| 03 80 05 00 04 00 2b 00 | 9f 0c 06 00 00 00 00 00 |......+.|........|
|00003bc0| 95 03 00 00 00 00 ff ff | 53 59 42 00 53 65 6c 65 |........|SYB.Sele|
|00003bd0| 63 74 20 63 6f 6c 5f 6e | 61 6d 65 28 6f 62 6a 65 |ct col_n|ame(obje|
|00003be0| 63 74 5f 69 64 28 22 64 | 62 6f 2e 00 22 29 2c 20 |ct_id("d|bo.."), |
|00003bf0| 09 09 09 09 2b 20 70 62 | 63 5f 63 6f 6c 75 6d 6e |....+ pb|c_column|
|00003c00| 44 41 54 2a 00 3e 00 00 | f6 01 69 64 29 2c 20 50 |DAT*.>..|..id), P|
|00003c10| 42 43 5f 4c 41 42 4c 2c | 20 50 42 43 5f 43 4d 4e |BC_LABL,| PBC_CMN|
|00003c20| 54 20 00 66 72 6f 6d 20 | 64 62 6f 2e 50 42 43 41 |T .from |dbo.PBCA|
|00003c30| 54 43 4f 4c 20 00 77 68 | 65 72 65 20 28 6f 62 6a |TCOL .wh|ere (obj|
|00003c40| 65 63 74 5f 69 64 28 22 | 64 62 6f 2e 00 22 29 20 |ect_id("|dbo..") |
|00003c50| 3d 20 70 62 63 5f 74 61 | 62 6c 65 69 64 29 20 6f |= pbc_ta|bleid) o|
|00003c60| 72 64 65 72 20 62 79 20 | 70 62 63 5f 6c 61 62 65 |rder by |pbc_labe|
|00003c70| 6c 20 41 53 43 00 47 55 | 50 00 53 65 6c 65 63 74 |l ASC.GU|P.Select|
|00003c80| 20 50 42 43 5f 43 4e 41 | 4d 2c 20 50 42 43 5f 4c | PBC_CNA|M, PBC_L|
|00003c90| 41 42 4c 2c 20 50 42 43 | 5f 43 4d 4e 54 20 00 66 |ABL, PBC|_CMNT .f|
|00003ca0| 72 6f 6d 20 73 79 73 61 | 64 6d 2e 50 42 43 41 54 |rom sysa|dm.PBCAT|
|00003cb0| 43 4f 4c 20 00 77 68 65 | 72 65 20 50 42 43 5f 54 |COL .whe|re PBC_T|
|00003cc0| 4e 41 4d 20 3d 20 27 00 | 27 20 61 6e 64 20 50 42 |NAM = '.|' and PB|
|00003cd0| 43 5f 4f 57 4e 52 20 3d | 20 27 00 02 00 ff ff 27 |C_OWNR =| '.....'|
|00003ce0| 20 6f 72 64 65 72 20 62 | 79 20 32 20 41 53 43 00 | order b|y 2 ASC.|
|00003cf0| 4f 44 42 00 53 65 6c 65 | 63 74 20 50 42 43 5f 43 |ODB.Sele|ct PBC_C|
|00003d00| 4e 41 4d 2c 20 50 42 43 | 5f 4c 41 42 4c 2c 20 50 |NAM, PBC|_LABL, P|
|00003d10| 42 43 5f 43 4d 4e 54 20 | 00 66 72 6f 6d 20 50 42 |BC_CMNT |.from PB|
|00003d20| 43 41 54 43 4f 4c 20 00 | 77 68 65 72 65 20 50 42 |CATCOL .|where PB|
|00003d30| 43 5f 54 4e 41 4d 20 3d | 20 27 00 27 20 61 6e 64 |C_TNAM =| '.' and|
|00003d40| 20 50 42 43 5f 4f 57 4e | 52 20 3d 20 27 00 02 00 | PBC_OWN|R = '...|
|00003d50| ff ff 27 20 6f 72 64 65 | 72 20 62 79 20 32 20 41 |..' orde|r by 2 A|
|00003d60| 53 43 00 58 44 42 00 53 | 65 6c 65 63 74 20 50 42 |SC.XDB.S|elect PB|
|00003d70| 43 5f 43 4e 41 4d 2c 20 | 50 42 43 5f 4c 41 42 4c |C_CNAM, |PBC_LABL|
|00003d80| 2c 20 50 42 43 5f 43 4d | 4e 54 20 00 66 72 6f 6d |, PBC_CM|NT .from|
|00003d90| 20 50 42 43 41 54 43 4f | 4c 20 00 77 68 65 72 65 | PBCATCO|L .where|
|00003da0| 20 50 42 43 5f 54 4e 41 | 4d 20 3d 20 27 00 27 20 | PBC_TNA|M = '.' |
|00003db0| 61 6e 64 20 50 42 43 5f | 4f 57 4e 52 20 3d 20 27 |and PBC_|OWNR = '|
|00003dc0| 00 02 00 ff ff 27 20 6f | 72 64 65 72 20 62 79 20 |.....' o|rder by |
|00003dd0| 32 20 41 53 43 00 4f 52 | 41 00 4f 52 36 00 4f 52 |2 ASC.OR|A.OR6.OR|
|00003de0| 37 00 53 65 6c 65 63 74 | 20 50 42 43 5f 43 4e 41 |7.Select| PBC_CNA|
|00003df0| 4d 2c 20 50 42 43 5f 4c | 41 42 4c 2c 20 50 42 43 |M, PBC_L|ABL, PBC|
|00003e00| 44 41 54 2a 00 00 00 00 | ad 01 5f 43 4d 4e 54 20 |DAT*....|.._CMNT |
|00003e10| 00 66 72 6f 6d 20 73 79 | 73 74 65 6d 2e 50 42 43 |.from sy|stem.PBC|
|00003e20| 41 54 43 4f 4c 20 00 77 | 68 65 72 65 20 50 42 43 |ATCOL .w|here PBC|
|00003e30| 5f 54 4e 41 4d 20 3d 20 | 27 00 27 20 61 6e 64 20 |_TNAM = |'.' and |
|00003e40| 50 42 43 5f 4f 57 4e 52 | 20 3d 20 27 00 04 00 ff |PBC_OWNR| = '....|
|00003e50| ff 27 20 6f 72 64 65 72 | 20 62 79 20 32 20 41 53 |.' order| by 2 AS|
|00003e60| 43 00 48 50 41 00 53 65 | 6c 65 63 74 20 50 42 43 |C.HPA.Se|lect PBC|
|00003e70| 5f 43 4e 41 4d 2c 20 50 | 42 43 5f 4c 41 42 4c 2c |_CNAM, P|BC_LABL,|
|00003e80| 20 50 42 43 5f 43 4d 4e | 54 20 00 66 72 6f 6d 20 | PBC_CMN|T .from |
|00003e90| 73 79 73 73 71 6c 2e 50 | 42 43 41 54 43 4f 4c 20 |syssql.P|BCATCOL |
|00003ea0| 00 77 68 65 72 65 20 50 | 42 43 5f 54 4e 41 4d 20 |.where P|BC_TNAM |
|00003eb0| 3d 20 27 00 27 20 61 6e | 64 20 50 42 43 5f 4f 57 |= '.' an|d PBC_OW|
|00003ec0| 4e 52 20 3d 20 27 00 02 | 00 ff ff 27 20 6f 72 64 |NR = '..|...' ord|
|00003ed0| 65 72 20 62 79 20 32 20 | 41 53 43 00 49 4e 46 00 |er by 2 |ASC.INF.|
|00003ee0| 53 65 6c 65 63 74 20 50 | 42 43 5f 43 4e 41 4d 2c |Select P|BC_CNAM,|
|00003ef0| 20 50 42 43 5f 4c 41 42 | 4c 2c 20 50 42 43 5f 43 | PBC_LAB|L, PBC_C|
|00003f00| 4d 4e 54 20 00 66 72 6f | 6d 20 27 69 6e 66 6f 72 |MNT .fro|m 'infor|
|00003f10| 6d 69 78 27 2e 50 42 43 | 41 54 43 4f 4c 20 00 77 |mix'.PBC|ATCOL .w|
|00003f20| 68 65 72 65 20 50 42 43 | 5f 54 4e 41 4d 20 3d 20 |here PBC|_TNAM = |
|00003f30| 27 00 27 20 61 6e 64 20 | 50 42 43 5f 4f 57 4e 52 |'.' and |PBC_OWNR|
|00003f40| 20 3d 20 27 00 04 00 ff | ff 27 20 6f 72 64 65 72 | = '....|.' order|
|00003f50| 20 62 79 20 32 20 41 53 | 43 00 73 65 74 73 71 6c | by 2 AS|C.setsql|
|00003f60| 73 65 6c 65 63 74 00 bd | 00 00 c0 82 03 00 00 00 |select..|........|
|00003f70| 00 01 00 00 00 10 00 32 | 00 0b 00 14 00 00 00 66 |.......2|.......f|
|00003f80| 5f 73 65 74 5f 63 6f 6c | 75 6d 6e 5f 73 65 6c 65 |_set_col|umn_sele|
|00003f90| 63 74 00 0a 00 00 00 80 | 14 01 00 00 00 e0 8b 10 |ct......|........|
|00003fa0| 00 32 00 0b 00 00 00 00 | 00 00 00 15 00 00 00 01 |.2......|........|
|00003fb0| 00 29 00 02 80 1a 00 00 | 00 00 00 00 00 00 00 00 |.)......|........|
|00003fc0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003fd0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003fe0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003ff0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004000| 44 41 54 2a 00 42 00 00 | f6 01 52 65 74 75 72 6e |DAT*.B..|..Return|
|00004010| 20 53 45 4c 45 43 54 20 | 73 74 61 74 65 6d 65 6e | SELECT |statemen|
|00004020| 74 20 66 6f 72 20 72 65 | 74 72 69 65 76 69 6e 67 |t for re|trieving|
|00004030| 20 63 6f 6c 75 6d 6e 20 | 6e 61 6d 65 73 20 26 20 | column |names & |
|00004040| 6c 61 62 65 6c 73 20 66 | 6f 72 20 61 20 73 70 65 |labels f|or a spe|
|00004050| 63 69 66 69 65 64 20 74 | 61 62 6c 65 67 6c 6f 62 |cified t|ableglob|
|00004060| 61 6c 20 74 79 70 65 20 | 66 5f 73 65 74 5f 63 6f |al type |f_set_co|
|00004070| 6c 75 6d 6e 5f 73 65 6c | 65 63 74 20 66 72 6f 6d |lumn_sel|ect from|
|00004080| 20 66 75 6e 63 74 69 6f | 6e 5f 6f 62 6a 65 63 74 | functio|n_object|
|00004090| 0d 0a 65 6e 64 20 74 79 | 70 65 0d 0a 0d 0a 66 6f |..end ty|pe....fo|
|000040a0| 72 77 61 72 64 20 70 72 | 6f 74 6f 74 79 70 65 73 |rward pr|ototypes|
|000040b0| 0d 0a 67 6c 6f 62 61 6c | 20 66 75 6e 63 74 69 6f |..global| functio|
|000040c0| 6e 20 69 6e 74 20 66 5f | 73 65 74 5f 63 6f 6c 75 |n int f_|set_colu|
|000040d0| 6d 6e 5f 73 65 6c 65 63 | 74 20 28 64 61 74 61 77 |mn_selec|t (dataw|
|000040e0| 69 6e 64 6f 77 20 64 77 | 5f 61 72 67 2c 20 73 74 |indow dw|_arg, st|
|000040f0| 72 69 6e 67 20 74 61 62 | 6c 65 6e 61 6d 65 5f 61 |ring tab|lename_a|
|00004100| 72 67 29 0d 0a 65 6e 64 | 20 70 72 6f 74 6f 74 79 |rg)..end| prototy|
|00004110| 70 65 73 0d 0a 0d 0a 67 | 6c 6f 62 61 6c 20 66 75 |pes....g|lobal fu|
|00004120| 6e 63 74 69 6f 6e 20 69 | 6e 74 20 66 5f 73 65 74 |nction i|nt f_set|
|00004130| 5f 63 6f 6c 75 6d 6e 5f | 73 65 6c 65 63 74 20 28 |_column_|select (|
|00004140| 64 61 74 61 77 69 6e 64 | 6f 77 20 64 77 5f 61 72 |datawind|ow dw_ar|
|00004150| 67 2c 20 73 74 72 69 6e | 67 20 74 61 62 6c 65 6e |g, strin|g tablen|
|00004160| 61 6d 65 5f 61 72 67 29 | 3b 2f 2f 20 49 6e 74 65 |ame_arg)|;// Inte|
|00004170| 67 65 72 20 46 75 6e 63 | 74 69 6f 6e 20 46 5f 53 |ger Func|tion F_S|
|00004180| 45 54 5f 43 4f 4c 55 4d | 4e 5f 53 45 4c 45 43 54 |ET_COLUM|N_SELECT|
|00004190| 20 28 64 77 5f 61 72 67 | 2c 20 74 61 62 6c 65 6e | (dw_arg|, tablen|
|000041a0| 61 6d 65 5f 61 72 67 29 | 0d 0a 0d 0a 2f 2f 20 49 |ame_arg)|....// I|
|000041b0| 6e 20 64 77 5f 61 72 67 | 2c 20 73 65 74 73 20 61 |n dw_arg|, sets a|
|000041c0| 70 70 72 6f 70 72 69 61 | 74 65 20 53 51 4c 20 53 |ppropria|te SQL S|
|000041d0| 65 6c 65 63 74 20 73 74 | 61 74 65 6d 65 6e 74 20 |elect st|atement |
|000041e0| 66 6f 72 20 73 65 6c 65 | 63 74 69 6e 67 20 0d 0a |for sele|cting ..|
|000041f0| 2f 2f 20 63 6f 6c 75 6d | 6e 20 6e 61 6d 65 73 20 |// colum|n names |
|00004200| 44 41 54 2a 00 44 00 00 | f6 01 61 6e 64 20 6c 61 |DAT*.D..|..and la|
|00004210| 62 65 6c 73 20 66 6f 72 | 20 61 20 73 70 65 63 69 |bels for| a speci|
|00004220| 66 69 65 64 20 74 61 62 | 6c 65 20 66 72 6f 6d 20 |fied tab|le from |
|00004230| 73 79 73 74 65 6d 20 63 | 61 74 61 6c 6f 67 0d 0a |system c|atalog..|
|00004240| 0d 0a 73 74 72 69 6e 67 | 09 73 71 6c 0d 0a 69 6e |..string|.sql..in|
|00004250| 74 65 67 65 72 09 6c 52 | 65 74 75 72 6e 43 6f 64 |teger.lR|eturnCod|
|00004260| 65 0d 0a 0d 0a 63 68 6f | 6f 73 65 20 63 61 73 65 |e....cho|ose case|
|00004270| 20 55 70 70 65 72 28 4c | 65 66 74 28 73 71 6c 63 | Upper(L|eft(sqlc|
|00004280| 61 2e 64 62 6d 73 2c 33 | 29 20 29 0d 0a 0d 0a 20 |a.dbms,3|) ).... |
|00004290| 20 20 63 61 73 65 20 22 | 53 59 42 22 09 09 2f 2f | case "|SYB"..//|
|000042a0| 20 53 51 4c 20 53 65 72 | 76 65 72 0d 0a 09 09 73 | SQL Ser|ver....s|
|000042b0| 71 6c 20 3d 20 22 53 65 | 6c 65 63 74 20 63 6f 6c |ql = "Se|lect col|
|000042c0| 5f 6e 61 6d 65 28 6f 62 | 6a 65 63 74 5f 69 64 28 |_name(ob|ject_id(|
|000042d0| 7e 22 64 62 6f 2e 22 20 | 2b 20 74 61 62 6c 65 6e |~"dbo." |+ tablen|
|000042e0| 61 6d 65 5f 61 72 67 20 | 2b 20 22 7e 22 29 2c 20 |ame_arg |+ "~"), |
|000042f0| 26 0d 0a 09 09 09 09 2b | 20 70 62 63 5f 63 6f 6c |&......+| pbc_col|
|00004300| 75 6d 6e 69 64 29 2c 20 | 50 42 43 5f 4c 41 42 4c |umnid), |PBC_LABL|
|00004310| 2c 20 50 42 43 5f 43 4d | 4e 54 20 22 20 26 0d 0a |, PBC_CM|NT " &..|
|00004320| 09 09 09 09 2b 20 22 66 | 72 6f 6d 20 64 62 6f 2e |....+ "f|rom dbo.|
|00004330| 50 42 43 41 54 43 4f 4c | 20 22 20 26 0d 0a 09 09 |PBCATCOL| " &....|
|00004340| 09 09 2b 20 22 77 68 65 | 72 65 20 28 6f 62 6a 65 |..+ "whe|re (obje|
|00004350| 63 74 5f 69 64 28 7e 22 | 64 62 6f 2e 22 20 2b 20 |ct_id(~"|dbo." + |
|00004360| 74 61 62 6c 65 6e 61 6d | 65 5f 61 72 67 20 26 0d |tablenam|e_arg &.|
|00004370| 0a 09 09 09 09 2b 20 22 | 7e 22 29 20 3d 20 70 62 |.....+ "|~") = pb|
|00004380| 63 5f 74 61 62 6c 65 69 | 64 29 20 6f 72 64 65 72 |c_tablei|d) order|
|00004390| 20 62 79 20 70 62 63 5f | 6c 61 62 65 6c 20 41 53 | by pbc_|label AS|
|000043a0| 43 22 0d 0a 0d 0a 09 63 | 61 73 65 20 22 47 55 50 |C".....c|ase "GUP|
|000043b0| 22 09 09 2f 2f 20 53 51 | 4c 42 61 73 65 0d 0a 09 |"..// SQ|LBase...|
|000043c0| 09 73 71 6c 20 3d 20 22 | 53 65 6c 65 63 74 20 50 |.sql = "|Select P|
|000043d0| 42 43 5f 43 4e 41 4d 2c | 20 50 42 43 5f 4c 41 42 |BC_CNAM,| PBC_LAB|
|000043e0| 4c 2c 20 50 42 43 5f 43 | 4d 4e 54 20 22 20 26 0d |L, PBC_C|MNT " &.|
|000043f0| 0a 09 09 09 09 2b 20 22 | 66 72 6f 6d 20 73 79 73 |.....+ "|from sys|
|00004400| 44 41 54 2a 00 46 00 00 | f6 01 61 64 6d 2e 50 42 |DAT*.F..|..adm.PB|
|00004410| 43 41 54 43 4f 4c 20 22 | 20 26 0d 0a 09 09 09 09 |CATCOL "| &......|
|00004420| 2b 20 22 77 68 65 72 65 | 20 50 42 43 5f 54 4e 41 |+ "where| PBC_TNA|
|00004430| 4d 20 3d 20 27 22 20 2b | 20 55 70 70 65 72 28 74 |M = '" +| Upper(t|
|00004440| 61 62 6c 65 6e 61 6d 65 | 5f 61 72 67 29 20 26 0d |ablename|_arg) &.|
|00004450| 0a 09 09 09 09 2b 20 22 | 27 20 61 6e 64 20 50 42 |.....+ "|' and PB|
|00004460| 43 5f 4f 57 4e 52 20 3d | 20 27 22 20 2b 20 55 70 |C_OWNR =| '" + Up|
|00004470| 70 65 72 28 73 71 6c 63 | 61 2e 75 73 65 72 69 64 |per(sqlc|a.userid|
|00004480| 29 20 26 0d 0a 09 09 09 | 09 2b 20 22 27 20 6f 72 |) &.....|.+ "' or|
|00004490| 64 65 72 20 62 79 20 32 | 20 41 53 43 22 0d 0a 0d |der by 2| ASC"...|
|000044a0| 0a 09 63 61 73 65 20 22 | 4f 44 42 22 09 09 2f 2f |..case "|ODB"..//|
|000044b0| 20 4f 44 42 43 0d 0a 09 | 09 73 71 6c 20 3d 20 22 | ODBC...|.sql = "|
|000044c0| 53 65 6c 65 63 74 20 50 | 42 43 5f 43 4e 41 4d 2c |Select P|BC_CNAM,|
|000044d0| 20 50 42 43 5f 4c 41 42 | 4c 2c 20 50 42 43 5f 43 | PBC_LAB|L, PBC_C|
|000044e0| 4d 4e 54 20 22 20 26 0d | 0a 09 09 09 09 2b 20 22 |MNT " &.|.....+ "|
|000044f0| 66 72 6f 6d 20 50 42 43 | 41 54 43 4f 4c 20 22 20 |from PBC|ATCOL " |
|00004500| 26 0d 0a 09 09 09 09 2b | 20 22 77 68 65 72 65 20 |&......+| "where |
|00004510| 50 42 43 5f 54 4e 41 4d | 20 3d 20 27 22 20 2b 20 |PBC_TNAM| = '" + |
|00004520| 55 70 70 65 72 28 74 61 | 62 6c 65 6e 61 6d 65 5f |Upper(ta|blename_|
|00004530| 61 72 67 29 20 26 0d 0a | 09 09 09 09 2b 20 22 27 |arg) &..|....+ "'|
|00004540| 20 61 6e 64 20 50 42 43 | 5f 4f 57 4e 52 20 3d 20 | and PBC|_OWNR = |
|00004550| 27 22 20 2b 20 55 70 70 | 65 72 28 73 71 6c 63 61 |'" + Upp|er(sqlca|
|00004560| 2e 75 73 65 72 69 64 29 | 20 26 0d 0a 09 09 09 09 |.userid)| &......|
|00004570| 2b 20 22 27 20 6f 72 64 | 65 72 20 62 79 20 32 20 |+ "' ord|er by 2 |
|00004580| 41 53 43 22 0d 0a 0d 0a | 09 63 61 73 65 20 22 58 |ASC"....|.case "X|
|00004590| 44 42 22 09 09 2f 2f 20 | 58 44 42 0d 0a 09 09 73 |DB"..// |XDB....s|
|000045a0| 71 6c 20 3d 20 22 53 65 | 6c 65 63 74 20 50 42 43 |ql = "Se|lect PBC|
|000045b0| 5f 43 4e 41 4d 2c 20 50 | 42 43 5f 4c 41 42 4c 2c |_CNAM, P|BC_LABL,|
|000045c0| 20 50 42 43 5f 43 4d 4e | 54 20 22 20 26 0d 0a 09 | PBC_CMN|T " &...|
|000045d0| 09 09 09 2b 20 22 66 72 | 6f 6d 20 50 42 43 41 54 |...+ "fr|om PBCAT|
|000045e0| 43 4f 4c 20 22 20 26 0d | 0a 09 09 09 09 2b 20 22 |COL " &.|.....+ "|
|000045f0| 77 68 65 72 65 20 50 42 | 43 5f 54 4e 41 4d 20 3d |where PB|C_TNAM =|
|00004600| 44 41 54 2a 00 48 00 00 | f6 01 20 27 22 20 2b 20 |DAT*.H..|.. '" + |
|00004610| 55 70 70 65 72 28 74 61 | 62 6c 65 6e 61 6d 65 5f |Upper(ta|blename_|
|00004620| 61 72 67 29 20 26 0d 0a | 09 09 09 09 2b 20 22 27 |arg) &..|....+ "'|
|00004630| 20 61 6e 64 20 50 42 43 | 5f 4f 57 4e 52 20 3d 20 | and PBC|_OWNR = |
|00004640| 27 22 20 2b 20 55 70 70 | 65 72 28 73 71 6c 63 61 |'" + Upp|er(sqlca|
|00004650| 2e 75 73 65 72 69 64 29 | 20 26 0d 0a 09 09 09 09 |.userid)| &......|
|00004660| 2b 20 22 27 20 6f 72 64 | 65 72 20 62 79 20 32 20 |+ "' ord|er by 2 |
|00004670| 41 53 43 22 0d 0a 0d 0a | 09 63 61 73 65 20 22 4f |ASC"....|.case "O|
|00004680| 52 41 22 2c 20 22 4f 52 | 36 22 2c 20 22 4f 52 37 |RA", "OR|6", "OR7|
|00004690| 22 09 2f 2f 20 4f 52 41 | 43 4c 45 0d 0a 09 09 73 |".// ORA|CLE....s|
|000046a0| 71 6c 20 3d 20 22 53 65 | 6c 65 63 74 20 50 42 43 |ql = "Se|lect PBC|
|000046b0| 5f 43 4e 41 4d 2c 20 50 | 42 43 5f 4c 41 42 4c 2c |_CNAM, P|BC_LABL,|
|000046c0| 20 50 42 43 5f 43 4d 4e | 54 20 22 20 26 0d 0a 09 | PBC_CMN|T " &...|
|000046d0| 09 09 09 2b 20 22 66 72 | 6f 6d 20 73 79 73 74 65 |...+ "fr|om syste|
|000046e0| 6d 2e 50 42 43 41 54 43 | 4f 4c 20 22 20 26 0d 0a |m.PBCATC|OL " &..|
|000046f0| 09 09 09 09 2b 20 22 77 | 68 65 72 65 20 50 42 43 |....+ "w|here PBC|
|00004700| 5f 54 4e 41 4d 20 3d 20 | 27 22 20 2b 20 55 70 70 |_TNAM = |'" + Upp|
|00004710| 65 72 28 74 61 62 6c 65 | 6e 61 6d 65 5f 61 72 67 |er(table|name_arg|
|00004720| 29 20 26 0d 0a 09 09 09 | 09 2b 20 22 27 20 61 6e |) &.....|.+ "' an|
|00004730| 64 20 50 42 43 5f 4f 57 | 4e 52 20 3d 20 27 22 20 |d PBC_OW|NR = '" |
|00004740| 2b 20 55 70 70 65 72 28 | 73 71 6c 63 61 2e 6c 6f |+ Upper(|sqlca.lo|
|00004750| 67 69 64 29 20 26 0d 0a | 09 09 09 09 2b 20 22 27 |gid) &..|....+ "'|
|00004760| 20 6f 72 64 65 72 20 62 | 79 20 32 20 41 53 43 22 | order b|y 2 ASC"|
|00004770| 0d 0a 0d 0a 09 63 61 73 | 65 20 22 48 50 41 22 09 |.....cas|e "HPA".|
|00004780| 09 2f 2f 20 41 4c 4c 42 | 41 53 45 2f 53 51 4c 0d |.// ALLB|ASE/SQL.|
|00004790| 0a 09 09 73 71 6c 20 3d | 20 22 53 65 6c 65 63 74 |...sql =| "Select|
|000047a0| 20 50 42 43 5f 43 4e 41 | 4d 2c 20 50 42 43 5f 4c | PBC_CNA|M, PBC_L|
|000047b0| 41 42 4c 2c 20 50 42 43 | 5f 43 4d 4e 54 20 22 20 |ABL, PBC|_CMNT " |
|000047c0| 26 0d 0a 09 09 09 09 2b | 20 22 66 72 6f 6d 20 73 |&......+| "from s|
|000047d0| 79 73 73 71 6c 2e 50 42 | 43 41 54 43 4f 4c 20 22 |yssql.PB|CATCOL "|
|000047e0| 20 26 0d 0a 09 09 09 09 | 2b 20 22 77 68 65 72 65 | &......|+ "where|
|000047f0| 20 50 42 43 5f 54 4e 41 | 4d 20 3d 20 27 22 20 2b | PBC_TNA|M = '" +|
|00004800| 44 41 54 2a 00 4a 00 00 | f6 01 20 55 70 70 65 72 |DAT*.J..|.. Upper|
|00004810| 28 74 61 62 6c 65 6e 61 | 6d 65 5f 61 72 67 29 20 |(tablena|me_arg) |
|00004820| 26 0d 0a 09 09 09 09 2b | 20 22 27 20 61 6e 64 20 |&......+| "' and |
|00004830| 50 42 43 5f 4f 57 4e 52 | 20 3d 20 27 22 20 2b 20 |PBC_OWNR| = '" + |
|00004840| 55 70 70 65 72 28 73 71 | 6c 63 61 2e 75 73 65 72 |Upper(sq|lca.user|
|00004850| 69 64 29 20 26 0d 0a 09 | 09 09 09 2b 20 22 27 20 |id) &...|...+ "' |
|00004860| 6f 72 64 65 72 20 62 79 | 20 32 20 41 53 43 22 0d |order by| 2 ASC".|
|00004870| 0a 0d 0a 09 63 61 73 65 | 20 22 49 4e 46 22 09 09 |....case| "INF"..|
|00004880| 2f 2f 20 49 4e 46 4f 52 | 4d 49 58 0d 0a 09 09 73 |// INFOR|MIX....s|
|00004890| 71 6c 20 3d 20 22 53 65 | 6c 65 63 74 20 50 42 43 |ql = "Se|lect PBC|
|000048a0| 5f 43 4e 41 4d 2c 20 50 | 42 43 5f 4c 41 42 4c 2c |_CNAM, P|BC_LABL,|
|000048b0| 20 50 42 43 5f 43 4d 4e | 54 20 22 20 26 0d 0a 09 | PBC_CMN|T " &...|
|000048c0| 09 09 09 2b 20 22 66 72 | 6f 6d 20 27 69 6e 66 6f |...+ "fr|om 'info|
|000048d0| 72 6d 69 78 27 2e 50 42 | 43 41 54 43 4f 4c 20 22 |rmix'.PB|CATCOL "|
|000048e0| 20 26 0d 0a 09 09 09 09 | 2b 20 22 77 68 65 72 65 | &......|+ "where|
|000048f0| 20 50 42 43 5f 54 4e 41 | 4d 20 3d 20 27 22 20 2b | PBC_TNA|M = '" +|
|00004900| 20 74 61 62 6c 65 6e 61 | 6d 65 5f 61 72 67 20 26 | tablena|me_arg &|
|00004910| 0d 0a 09 09 09 09 2b 20 | 22 27 20 61 6e 64 20 50 |......+ |"' and P|
|00004920| 42 43 5f 4f 57 4e 52 20 | 3d 20 27 22 20 2b 20 73 |BC_OWNR |= '" + s|
|00004930| 71 6c 63 61 2e 6c 6f 67 | 69 64 20 26 0d 0a 09 09 |qlca.log|id &....|
|00004940| 09 09 2b 20 22 27 20 6f | 72 64 65 72 20 62 79 20 |..+ "' o|rder by |
|00004950| 32 20 41 53 43 22 0d 0a | 0d 0a 65 6e 64 20 63 68 |2 ASC"..|..end ch|
|00004960| 6f 6f 73 65 0d 0a 0d 0a | 69 66 20 4c 65 6e 28 73 |oose....|if Len(s|
|00004970| 71 6c 29 20 3e 20 30 20 | 74 68 65 6e 0d 0a 09 6c |ql) > 0 |then...l|
|00004980| 52 65 74 75 72 6e 43 6f | 64 65 20 3d 20 64 77 5f |ReturnCo|de = dw_|
|00004990| 61 72 67 2e 53 65 74 53 | 51 4c 53 65 6c 65 63 74 |arg.SetS|QLSelect|
|000049a0| 28 73 71 6c 29 0d 0a 09 | 72 65 74 75 72 6e 20 6c |(sql)...|return l|
|000049b0| 52 65 74 75 72 6e 43 6f | 64 65 0d 0a 2f 2f 09 72 |ReturnCo|de..//.r|
|000049c0| 65 74 75 72 6e 20 64 77 | 5f 61 72 67 2e 53 65 74 |eturn dw|_arg.Set|
|000049d0| 53 51 4c 53 65 6c 65 63 | 74 28 73 71 6c 29 0d 0a |SQLSelec|t(sql)..|
|000049e0| 65 6c 73 65 0d 0a 09 72 | 65 74 75 72 6e 20 2d 31 |else...r|eturn -1|
|000049f0| 0d 0a 65 6e 64 20 69 66 | 0d 0a 0d 0a 0d 0a 65 6e |..end if|......en|
|00004a00| 44 41 54 2a 00 00 00 00 | 0e 00 64 20 66 75 6e 63 |DAT*....|..d func|
|00004a10| 74 69 6f 6e 0d 0a 0d 0a | 00 00 00 00 00 00 00 00 |tion....|........|
|00004a20| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004a30| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004a40| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004a50| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004a60| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004a70| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004a80| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004a90| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004aa0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004ab0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004ac0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004ad0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004ae0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004af0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004b00| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004b10| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004b20| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004b30| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004b40| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004b50| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004b60| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004b70| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004b80| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004b90| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004ba0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004bb0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004bc0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004bd0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004be0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004bf0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004c00| 44 41 54 2a 00 4e 00 00 | f6 01 11 00 02 00 00 00 |DAT*.N..|........|
|00004c10| 00 00 00 00 26 94 72 2c | 80 73 87 2c 08 00 06 00 |....&.r,|.s.,....|
|00004c20| 13 00 00 00 38 40 38 40 | 01 54 23 00 49 00 38 40 |....8@8@|.T#.I.8@|
|00004c30| 01 80 c9 51 36 00 43 4f | 01 80 00 00 4a 08 49 00 |...Q6.CO|....J.I.|
|00004c40| 00 00 51 40 51 40 01 51 | 54 00 00 00 3f 40 3f 40 |..Q@Q@.Q|T...?@?@|
|00004c50| 01 01 60 00 03 f8 03 80 | 00 00 00 9c 66 00 00 00 |..`.....|....f...|
|00004c60| 66 5f 73 65 74 5f 74 61 | 62 6c 65 5f 73 65 6c 65 |f_set_ta|ble_sele|
|00004c70| 63 74 00 66 75 6e 63 74 | 69 6f 6e 5f 6f 62 6a 65 |ct.funct|ion_obje|
|00004c80| 63 74 00 66 5f 73 65 74 | 5f 74 61 62 6c 65 5f 73 |ct.f_set|_table_s|
|00004c90| 65 6c 65 63 74 00 66 5f | 73 65 74 5f 74 61 62 6c |elect.f_|set_tabl|
|00004ca0| 65 5f 73 65 6c 65 63 74 | 00 64 61 74 61 77 69 6e |e_select|.datawin|
|00004cb0| 64 6f 77 00 74 72 61 6e | 73 61 63 74 69 6f 6e 00 |dow.tran|saction.|
|00004cc0| 73 71 6c 63 61 00 10 00 | 32 00 08 00 00 00 00 00 |sqlca...|2.......|
|00004cd0| 00 00 00 00 01 00 01 00 | 29 00 00 00 64 77 5f 61 |........|)...dw_a|
|00004ce0| 72 67 00 66 5f 73 65 74 | 5f 74 61 62 6c 65 5f 73 |rg.f_set|_table_s|
|00004cf0| 65 6c 65 63 74 00 00 00 | 02 80 ff ff 00 00 64 77 |elect...|......dw|
|00004d00| 5f 61 72 67 00 0a 00 78 | 00 11 00 3a 00 00 00 66 |_arg...x|...:...f|
|00004d10| 75 6e 63 74 69 6f 6e 5f | 6f 62 6a 65 63 74 00 66 |unction_|object.f|
|00004d20| 5f 73 65 74 5f 74 61 62 | 6c 65 5f 73 65 6c 65 63 |_set_tab|le_selec|
|00004d30| 74 00 64 61 74 61 77 69 | 6e 64 6f 77 00 74 72 61 |t.datawi|ndow.tra|
|00004d40| 6e 73 61 63 74 69 6f 6e | 00 28 00 00 00 a0 14 00 |nsaction|.(......|
|00004d50| 00 00 00 6f 6d 10 00 80 | 14 00 00 00 00 74 00 23 |...om...|.....t.#|
|00004d60| 00 a0 14 00 00 03 00 74 | 00 2e 00 a0 14 00 00 04 |.......t|........|
|00004d70| 00 1e 00 14 00 f0 00 11 | 00 00 00 00 00 00 00 c1 |........|........|
|00004d80| 75 01 80 65 20 3d 20 00 | 80 00 c0 00 00 01 00 00 |u..e = .|........|
|00004d90| 00 00 00 00 00 01 00 02 | 00 01 00 01 00 01 00 00 |........|........|
|00004da0| 00 e6 02 2c 00 1c 00 06 | 00 2d 00 05 00 1e 00 00 |...,....|.-......|
|00004db0| 00 25 00 32 00 03 00 00 | 00 28 00 5c 00 02 00 28 |.%.2....|.(.\...(|
|00004dc0| 00 12 01 01 00 86 00 39 | 00 04 00 1c 00 06 00 ab |.......9|........|
|00004dd0| 00 03 00 62 00 1c 00 01 | 00 39 00 08 00 39 00 32 |...b....|.9...9.2|
|00004de0| 00 7b 00 39 00 49 00 7b | 00 2d 00 05 00 1e 00 6d |.{.9.I.{|.-.....m|
|00004df0| 00 25 00 28 00 12 01 01 | 00 7b 00 39 00 71 00 7b |.%.(....|.{.9.q.{|
|00004e00| 44 41 54 2a 00 50 00 00 | f6 01 00 86 00 04 00 a2 |DAT*.P..|........|
|00004e10| 02 39 00 82 00 1c 00 06 | 00 ab 00 03 00 64 01 2d |.9......|.....d.-|
|00004e20| 00 05 00 1e 00 86 00 25 | 00 39 00 8a 00 ab 00 03 |.......%|.9......|
|00004e30| 00 32 01 1c 00 02 00 2d | 00 05 00 1e 00 8b 00 25 |.2.....-|.......%|
|00004e40| 00 39 00 8f 00 32 00 01 | 00 00 00 28 00 b3 00 03 |.9...2..|...(....|
|00004e50| 00 8c 00 01 00 7e 00 1c | 00 03 00 2d 00 05 00 1e |.....~..|...-....|
|00004e60| 00 93 00 25 00 39 00 97 | 00 1c 00 02 00 28 00 b3 |...%.9..|.....(..|
|00004e70| 00 03 00 8c 00 01 00 7e | 00 1c 00 04 00 2d 00 05 |.......~|.....-..|
|00004e80| 00 1e 00 99 00 25 00 39 | 00 9d 00 1c 00 03 00 28 |.....%.9|.......(|
|00004e90| 00 b3 00 03 00 8c 00 01 | 00 7e 00 2d 00 05 00 1e |........|.~.-....|
|00004ea0| 00 9f 00 25 00 2d 00 05 | 00 1e 00 a3 00 25 00 1c |...%.-..|.....%..|
|00004eb0| 00 03 00 32 00 01 00 00 | 00 3d 00 02 00 53 00 1c |...2....|.=...S..|
|00004ec0| 00 04 00 1c 00 03 00 32 | 00 01 00 00 00 3d 00 02 |.......2|.....=..|
|00004ed0| 00 53 00 3d 00 02 00 5a | 00 28 00 80 00 03 00 86 |.S.=...Z|.(......|
|00004ee0| 00 1c 00 01 00 39 00 a7 | 00 39 00 d4 00 7b 00 39 |.....9..|.9...{.9|
|00004ef0| 00 ec 00 7b 00 2d 00 05 | 00 1e 00 13 01 25 00 28 |...{.-..|.....%.(|
|00004f00| 00 12 01 01 00 7b 00 39 | 00 17 01 7b 00 86 00 04 |.....{.9|...{....|
|00004f10| 00 a2 02 39 00 28 01 1c | 00 06 00 ab 00 03 00 9e |...9.(..|........|
|00004f20| 01 1c 00 01 00 39 00 2c | 01 39 00 4f 01 7b 00 2d |.....9.,|.9.O.{.-|
|00004f30| 00 05 00 1e 00 71 01 25 | 00 28 00 12 01 01 00 7b |.....q.%|.(.....{|
|00004f40| 00 39 00 75 01 7b 00 86 | 00 04 00 a2 02 39 00 86 |.9.u.{..|.....9..|
|00004f50| 01 1c 00 06 00 ab 00 03 | 00 c0 01 1c 00 01 00 39 |........|.......9|
|00004f60| 00 8a 01 39 00 b1 01 7b | 00 86 00 04 00 a2 02 39 |...9...{|.......9|
|00004f70| 00 d3 01 1c 00 06 00 ab | 00 39 00 d7 01 1c 00 06 |........|.9......|
|00004f80| 00 ab 00 23 00 39 00 db | 01 1c 00 06 00 ab 00 23 |...#.9..|.......#|
|00004f90| 00 03 00 18 02 1c 00 01 | 00 39 00 df 01 39 00 09 |........|.9...9..|
|00004fa0| 02 7b 00 39 00 20 02 7b | 00 2d 00 05 00 1e 00 44 |.{.9. .{|.-.....D|
|00004fb0| 02 25 00 28 00 12 01 01 | 00 7b 00 39 00 48 02 7b |.%.(....|.{.9.H.{|
|00004fc0| 00 86 00 04 00 a2 02 39 | 00 59 02 1c 00 06 00 ab |.......9|.Y......|
|00004fd0| 00 03 00 58 02 1c 00 01 | 00 39 00 5d 02 39 00 87 |...X....|.9.].9..|
|00004fe0| 02 7b 00 39 00 9e 02 7b | 00 2d 00 05 00 1e 00 c2 |.{.9...{|.-......|
|00004ff0| 02 25 00 28 00 12 01 01 | 00 7b 00 39 00 c6 02 7b |.%.(....|.{.9...{|
|00005000| 44 41 54 2a 00 52 00 00 | f6 01 00 86 00 04 00 a2 |DAT*.R..|........|
|00005010| 02 39 00 d7 02 1c 00 06 | 00 ab 00 03 00 92 02 1c |.9......|........|
|00005020| 00 01 00 39 00 db 02 39 | 00 f5 02 7b 00 39 00 0f |...9...9|...{.9..|
|00005030| 03 7b 00 2d 00 05 00 1e | 00 22 03 25 00 7b 00 39 |.{.-....|.".%.{.9|
|00005040| 00 26 03 7b 00 86 00 04 | 00 a2 02 39 00 37 03 39 |.&.{....|...9.7.9|
|00005050| 00 3e 03 28 00 7b 00 02 | 00 14 00 1c 00 01 00 28 |.>.(.{..|.......(|
|00005060| 00 5f 00 01 00 32 00 00 | 00 00 00 c6 00 03 00 d0 |._...2..|........|
|00005070| 02 2e 00 00 00 1c 00 01 | 00 2a 00 62 03 01 00 01 |........|.*.b....|
|00005080| 00 01 00 00 00 04 00 e0 | 02 32 00 ff ff ff ff 8c |........|.2......|
|00005090| 00 01 00 01 00 01 00 00 | 00 01 00 00 00 01 00 0e |........|........|
|000050a0| 00 00 00 10 00 22 00 11 | 00 30 00 12 00 38 00 13 |....."..|.0...8..|
|000050b0| 00 3c 00 14 00 42 00 16 | 00 5e 00 1d 00 70 00 1e |.<...B..|.^...p..|
|000050c0| 00 84 00 1f 00 a8 00 20 | 00 ca 00 21 00 ec 00 24 |....... |...!...$|
|000050d0| 00 32 01 25 00 3a 01 26 | 00 3e 01 27 00 44 01 29 |.2.%.:.&|.>.'.D.)|
|000050e0| 00 60 01 2a 00 72 01 2b | 00 7a 01 2c 00 7e 01 2e |.`.*.r.+|.z.,.~..|
|000050f0| 00 9a 01 2f 00 ac 01 30 | 00 b4 01 32 00 bc 01 33 |.../...0|...2...3|
|00005100| 00 e6 01 34 00 ee 01 35 | 00 f2 01 36 00 f8 01 38 |...4...5|...6...8|
|00005110| 00 14 02 39 00 26 02 3a | 00 2e 02 3b 00 32 02 3c |...9.&.:|...;.2.<|
|00005120| 00 38 02 3e 00 54 02 3f | 00 66 02 40 00 6e 02 41 |.8.>.T.?|.f.@.n.A|
|00005130| 00 72 02 42 00 7e 02 44 | 00 8e 02 45 00 92 02 49 |.r.B.~.D|...E...I|
|00005140| 00 a2 02 4a 00 b8 02 4b | 00 cc 02 4c 00 d0 02 10 |...J...K|...L....|
|00005150| 00 64 00 08 00 36 00 00 | 00 64 77 5f 61 72 67 00 |.d...6..|.dw_arg.|
|00005160| 73 71 6c 00 70 6f 73 75 | 69 64 00 70 6f 73 65 71 |sql.posu|id.poseq|
|00005170| 75 61 6c 00 70 6f 73 73 | 65 6d 69 63 6f 6c 6f 6e |ual.poss|emicolon|
|00005180| 00 73 71 6c 63 61 00 01 | 63 61 73 65 31 34 00 46 |.sqlca..|case14.F|
|00005190| 00 00 00 c0 18 02 80 ff | ff 00 00 07 00 80 0c 06 |........|........|
|000051a0| 00 00 00 00 00 0b 00 80 | 04 01 00 00 00 1f 22 12 |........|......".|
|000051b0| 00 80 04 01 00 00 00 1f | 22 1b 00 80 04 01 00 00 |........|".......|
|000051c0| 00 1f 22 28 00 20 16 03 | 80 05 00 05 00 2e 00 9f |.."(. ..|........|
|000051d0| 0c 06 00 00 00 00 00 68 | 03 00 00 00 00 ff ff 47 |.......h|.......G|
|000051e0| 55 50 00 53 45 4c 45 43 | 54 20 44 49 53 54 49 4e |UP.SELEC|T DISTIN|
|000051f0| 43 54 20 53 59 53 41 44 | 4d 2e 50 42 43 41 54 54 |CT SYSAD|M.PBCATT|
|00005200| 44 41 54 2a 00 54 00 00 | f6 01 42 4c 2e 50 42 54 |DAT*.T..|..BL.PBT|
|00005210| 5f 54 4e 41 4d 20 00 20 | 46 52 4f 4d 20 53 59 53 |_TNAM . |FROM SYS|
|00005220| 41 44 4d 2e 50 42 43 41 | 54 54 42 4c 20 00 20 57 |ADM.PBCA|TTBL . W|
|00005230| 48 45 52 45 20 53 59 53 | 41 44 4d 2e 50 42 43 41 |HERE SYS|ADM.PBCA|
|00005240| 54 54 42 4c 2e 50 42 54 | 5f 4f 57 4e 52 20 3d 20 |TTBL.PBT|_OWNR = |
|00005250| 27 00 02 00 ff ff 27 20 | 6f 72 64 65 72 20 62 79 |'.....' |order by|
|00005260| 20 31 20 41 53 43 00 4f | 44 42 00 02 00 ff ff 00 | 1 ASC.O|DB......|
|00005270| 0d 00 ff ff 55 49 44 00 | 0d 00 ff ff 3d 00 0d 00 |....UID.|....=...|
|00005280| ff ff 3b 00 02 00 ff ff | 0d 00 ff ff 53 45 4c 45 |..;.....|....SELE|
|00005290| 43 54 20 44 49 53 54 49 | 4e 43 54 20 22 44 42 41 |CT DISTI|NCT "DBA|
|000052a0| 22 2e 22 50 42 43 41 54 | 54 42 4c 22 2e 22 50 42 |"."PBCAT|TBL"."PB|
|000052b0| 54 5f 54 4e 41 4d 22 20 | 00 20 46 52 4f 4d 20 22 |T_TNAM" |. FROM "|
|000052c0| 44 42 41 22 2e 22 50 42 | 43 41 54 54 42 4c 22 20 |DBA"."PB|CATTBL" |
|000052d0| 00 20 57 48 45 52 45 20 | 22 44 42 41 22 2e 22 50 |. WHERE |"DBA"."P|
|000052e0| 42 43 41 54 54 42 4c 22 | 2e 22 50 42 54 5f 4f 57 |BCATTBL"|."PBT_OW|
|000052f0| 4e 52 22 20 3d 20 27 00 | 02 00 ff ff 27 20 6f 72 |NR" = '.|....' or|
|00005300| 64 65 72 20 62 79 20 31 | 20 41 53 43 00 58 44 42 |der by 1| ASC.XDB|
|00005310| 00 53 65 6c 65 63 74 20 | 44 49 53 54 49 4e 43 54 |.Select |DISTINCT|
|00005320| 20 50 42 43 41 54 54 42 | 4c 2e 50 42 54 5f 54 4e | PBCATTB|L.PBT_TN|
|00005330| 41 4d 20 00 20 66 72 6f | 6d 20 50 42 43 41 54 54 |AM . fro|m PBCATT|
|00005340| 42 4c 20 77 68 65 72 65 | 20 50 42 54 5f 4f 57 4e |BL where| PBT_OWN|
|00005350| 52 20 3d 20 27 00 02 00 | ff ff 27 20 6f 72 64 65 |R = '...|..' orde|
|00005360| 72 20 62 79 20 31 20 41 | 53 43 00 53 59 42 00 53 |r by 1 A|SC.SYB.S|
|00005370| 45 4c 45 43 54 20 44 49 | 53 54 49 4e 43 54 20 64 |ELECT DI|STINCT d|
|00005380| 62 6f 2e 50 42 43 41 54 | 54 42 4c 2e 50 42 54 5f |bo.PBCAT|TBL.PBT_|
|00005390| 54 4e 41 4d 29 00 20 46 | 52 4f 4d 20 64 62 6f 2e |TNAM). F|ROM dbo.|
|000053a0| 50 42 43 41 54 54 42 4c | 20 6f 72 64 65 72 20 62 |PBCATTBL| order b|
|000053b0| 79 20 31 20 41 53 43 00 | 4f 52 41 00 4f 52 36 00 |y 1 ASC.|ORA.OR6.|
|000053c0| 4f 52 37 00 53 45 4c 45 | 43 54 20 44 49 53 54 49 |OR7.SELE|CT DISTI|
|000053d0| 4e 43 54 20 53 59 53 54 | 45 4d 2e 50 42 43 41 54 |NCT SYST|EM.PBCAT|
|000053e0| 54 42 4c 2e 50 42 54 5f | 54 4e 41 4d 20 00 20 46 |TBL.PBT_|TNAM . F|
|000053f0| 52 4f 4d 20 53 59 53 54 | 45 4d 2e 50 42 43 41 54 |ROM SYST|EM.PBCAT|
|00005400| 44 41 54 2a 00 00 00 00 | aa 01 54 42 4c 20 00 20 |DAT*....|..TBL . |
|00005410| 57 48 45 52 45 20 73 79 | 73 74 65 6d 2e 50 42 43 |WHERE sy|stem.PBC|
|00005420| 41 54 54 42 4c 2e 50 42 | 54 5f 4f 57 4e 52 20 3d |ATTBL.PB|T_OWNR =|
|00005430| 20 27 00 04 00 ff ff 27 | 20 6f 72 64 65 72 20 62 | '.....'| order b|
|00005440| 79 20 31 20 41 53 43 00 | 48 50 41 00 53 45 4c 45 |y 1 ASC.|HPA.SELE|
|00005450| 43 54 20 44 49 53 54 49 | 4e 43 54 20 53 59 53 53 |CT DISTI|NCT SYSS|
|00005460| 51 4c 2e 50 42 43 41 54 | 54 42 4c 2e 50 42 54 5f |QL.PBCAT|TBL.PBT_|
|00005470| 54 4e 41 4d 20 00 20 46 | 52 4f 4d 20 53 59 53 53 |TNAM . F|ROM SYSS|
|00005480| 51 4c 2e 50 42 43 41 54 | 54 42 4c 20 00 20 57 48 |QL.PBCAT|TBL . WH|
|00005490| 45 52 45 20 73 79 73 73 | 71 6c 2e 50 42 43 41 54 |ERE syss|ql.PBCAT|
|000054a0| 54 42 4c 2e 50 42 54 5f | 4f 57 4e 52 20 3d 20 27 |TBL.PBT_|OWNR = '|
|000054b0| 00 02 00 ff ff 27 20 6f | 72 64 65 72 20 62 79 20 |.....' o|rder by |
|000054c0| 31 20 41 53 43 00 49 4e | 46 00 53 65 6c 65 63 74 |1 ASC.IN|F.Select|
|000054d0| 20 44 49 53 54 49 4e 43 | 54 20 50 42 54 5f 54 4e | DISTINC|T PBT_TN|
|000054e0| 41 4d 20 00 66 72 6f 6d | 20 27 69 6e 66 6f 72 6d |AM .from| 'inform|
|000054f0| 69 78 27 2e 50 42 43 41 | 54 54 42 4c 20 00 77 68 |ix'.PBCA|TTBL .wh|
|00005500| 65 72 65 20 50 42 54 5f | 4f 57 4e 52 20 3d 20 27 |ere PBT_|OWNR = '|
|00005510| 00 04 00 ff ff 27 20 6f | 72 64 65 72 20 62 79 20 |.....' o|rder by |
|00005520| 31 20 41 53 43 00 45 72 | 72 6f 72 21 00 55 6e 6b |1 ASC.Er|ror!.Unk|
|00005530| 6e 6f 77 6e 20 44 61 74 | 61 62 61 73 65 20 4e 61 |nown Dat|abase Na|
|00005540| 6d 65 21 00 73 65 74 73 | 71 6c 73 65 6c 65 63 74 |me!.sets|qlselect|
|00005550| 00 bd 00 00 c0 55 03 01 | 00 ef 4c 00 ff ff ff ff |.....U..|..L.....|
|00005560| 07 00 00 00 00 00 00 00 | 07 00 ff ff 44 00 00 01 |........|....D...|
|00005570| 00 00 00 10 00 32 00 0b | 00 13 00 00 00 66 5f 73 |.....2..|.....f_s|
|00005580| 65 74 5f 74 61 62 6c 65 | 5f 73 65 6c 65 63 74 00 |et_table|_select.|
|00005590| 0a 00 00 00 80 14 01 00 | 00 00 0d 0a 10 00 32 00 |........|......2.|
|000055a0| 0b 00 00 00 00 00 00 00 | 07 00 00 00 01 00 1a 00 |........|........|
|000055b0| 01 80 1a 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000055c0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000055d0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000055e0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000055f0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005600| 44 41 54 2a 00 58 00 00 | f6 01 52 65 74 75 72 6e |DAT*.X..|..Return|
|00005610| 20 53 45 4c 45 43 54 20 | 73 74 61 74 65 6d 65 6e | SELECT |statemen|
|00005620| 74 20 66 6f 72 20 72 65 | 74 72 69 65 76 69 6e 67 |t for re|trieving|
|00005630| 20 74 61 62 6c 65 20 6e | 61 6d 65 73 20 66 72 6f | table n|ames fro|
|00005640| 6d 20 73 79 73 74 65 6d | 20 63 61 74 61 6c 6f 67 |m system| catalog|
|00005650| 67 6c 6f 62 61 6c 20 74 | 79 70 65 20 66 5f 73 65 |global t|ype f_se|
|00005660| 74 5f 74 61 62 6c 65 5f | 73 65 6c 65 63 74 20 66 |t_table_|select f|
|00005670| 72 6f 6d 20 66 75 6e 63 | 74 69 6f 6e 5f 6f 62 6a |rom func|tion_obj|
|00005680| 65 63 74 0d 0a 65 6e 64 | 20 74 79 70 65 0d 0a 0d |ect..end| type...|
|00005690| 0a 66 6f 72 77 61 72 64 | 20 70 72 6f 74 6f 74 79 |.forward| prototy|
|000056a0| 70 65 73 0d 0a 67 6c 6f | 62 61 6c 20 66 75 6e 63 |pes..glo|bal func|
|000056b0| 74 69 6f 6e 20 69 6e 74 | 20 66 5f 73 65 74 5f 74 |tion int| f_set_t|
|000056c0| 61 62 6c 65 5f 73 65 6c | 65 63 74 20 28 72 65 66 |able_sel|ect (ref|
|000056d0| 20 64 61 74 61 77 69 6e | 64 6f 77 20 64 77 5f 61 | datawin|dow dw_a|
|000056e0| 72 67 29 0d 0a 65 6e 64 | 20 70 72 6f 74 6f 74 79 |rg)..end| prototy|
|000056f0| 70 65 73 0d 0a 0d 0a 67 | 6c 6f 62 61 6c 20 66 75 |pes....g|lobal fu|
|00005700| 6e 63 74 69 6f 6e 20 69 | 6e 74 20 66 5f 73 65 74 |nction i|nt f_set|
|00005710| 5f 74 61 62 6c 65 5f 73 | 65 6c 65 63 74 20 28 72 |_table_s|elect (r|
|00005720| 65 66 20 64 61 74 61 77 | 69 6e 64 6f 77 20 64 77 |ef dataw|indow dw|
|00005730| 5f 61 72 67 29 3b 2f 2f | 2a 2a 2a 2a 2a 2a 2a 2a |_arg);//|********|
|00005740| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00005750| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00005760| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00005770| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 0d 0a |********|******..|
|00005780| 2f 2f 09 09 46 75 6e 63 | 74 69 6f 6e 20 44 65 63 |//..Func|tion Dec|
|00005790| 6c 61 72 61 74 69 6f 6e | 0d 0a 2f 2f 20 49 6e 74 |laration|..// Int|
|000057a0| 65 67 65 72 20 46 55 4e | 43 54 49 4f 4e 20 66 5f |eger FUN|CTION f_|
|000057b0| 73 65 74 5f 74 61 62 6c | 65 5f 73 65 6c 65 63 74 |set_tabl|e_select|
|000057c0| 20 28 52 45 46 20 64 77 | 5f 61 72 67 29 0d 0a 2f | (REF dw|_arg)../|
|000057d0| 2f 0d 0a 2f 2f 09 09 50 | 61 73 73 69 6e 67 20 64 |/..//..P|assing d|
|000057e0| 77 5f 61 72 67 20 62 79 | 20 72 65 66 65 72 65 6e |w_arg by| referen|
|000057f0| 63 65 20 69 73 20 6e 65 | 63 65 73 73 61 72 79 20 |ce is ne|cessary |
|00005800| 44 41 54 2a 00 5a 00 00 | f6 01 62 65 63 61 75 73 |DAT*.Z..|..becaus|
|00005810| 65 20 69 74 27 73 20 73 | 71 6c 20 73 74 61 74 65 |e it's s|ql state|
|00005820| 6d 65 6e 74 0d 0a 2f 2f | 09 09 69 73 20 67 6f 69 |ment..//|..is goi|
|00005830| 6e 67 20 74 6f 20 62 65 | 20 63 68 61 6e 67 65 64 |ng to be| changed|
|00005840| 0d 0a 2f 2f 20 64 77 5f | 61 72 67 2c 20 73 65 74 |..// dw_|arg, set|
|00005850| 73 20 61 70 70 72 6f 70 | 72 69 61 74 65 20 53 51 |s approp|riate SQ|
|00005860| 4c 20 53 65 6c 65 63 74 | 20 73 74 61 74 65 6d 65 |L Select| stateme|
|00005870| 6e 74 20 66 6f 72 20 73 | 65 6c 65 63 74 69 6e 67 |nt for s|electing|
|00005880| 20 0d 0a 2f 2f 20 74 61 | 62 6c 65 6e 61 6d 65 73 | ..// ta|blenames|
|00005890| 20 66 72 6f 6d 20 73 79 | 73 74 65 6d 20 63 61 74 | from sy|stem cat|
|000058a0| 61 6c 6f 67 0d 0a 2f 2f | 2a 2a 2a 2a 2a 2a 2a 2a |alog..//|********|
|000058b0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|000058c0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|000058d0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|000058e0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 0d |********|*******.|
|000058f0| 0a 0d 0a 73 74 72 69 6e | 67 09 73 71 6c 0d 0a 69 |...strin|g.sql..i|
|00005900| 6e 74 65 67 65 72 09 50 | 6f 73 55 69 64 2c 20 50 |nteger.P|osUid, P|
|00005910| 6f 73 45 71 75 61 6c 2c | 20 50 6f 73 53 65 6d 69 |osEqual,| PosSemi|
|00005920| 43 6f 6c 6f 6e 0d 0a 0d | 0a 63 68 6f 6f 73 65 20 |Colon...|.choose |
|00005930| 63 61 73 65 20 55 70 70 | 65 72 28 4c 65 66 74 28 |case Upp|er(Left(|
|00005940| 73 71 6c 63 61 2e 64 62 | 6d 73 2c 33 29 20 29 0d |sqlca.db|ms,3) ).|
|00005950| 0a 0d 0a 09 63 61 73 65 | 20 22 47 55 50 22 09 09 |....case| "GUP"..|
|00005960| 2f 2f 20 47 75 70 74 61 | 20 53 51 4c 42 61 73 65 |// Gupta| SQLBase|
|00005970| 0d 0a 09 09 73 71 6c 20 | 3d 20 22 53 45 4c 45 43 |....sql |= "SELEC|
|00005980| 54 20 44 49 53 54 49 4e | 43 54 20 53 59 53 41 44 |T DISTIN|CT SYSAD|
|00005990| 4d 2e 50 42 43 41 54 54 | 42 4c 2e 50 42 54 5f 54 |M.PBCATT|BL.PBT_T|
|000059a0| 4e 41 4d 20 22 20 26 20 | 20 0d 0a 09 09 09 20 20 |NAM " & | ..... |
|000059b0| 20 2b 20 22 20 46 52 4f | 4d 20 53 59 53 41 44 4d | + " FRO|M SYSADM|
|000059c0| 2e 50 42 43 41 54 54 42 | 4c 20 22 20 26 20 20 0d |.PBCATTB|L " & .|
|000059d0| 0a 09 09 09 20 20 20 2b | 20 22 20 57 48 45 52 45 |.... +| " WHERE|
|000059e0| 20 53 59 53 41 44 4d 2e | 50 42 43 41 54 54 42 4c | SYSADM.|PBCATTBL|
|000059f0| 2e 50 42 54 5f 4f 57 4e | 52 20 3d 20 27 22 20 26 |.PBT_OWN|R = '" &|
|00005a00| 44 41 54 2a 00 5c 00 00 | f6 01 0d 0a 09 09 09 09 |DAT*.\..|........|
|00005a10| 2b 20 55 70 70 65 72 28 | 73 71 6c 63 61 2e 75 73 |+ Upper(|sqlca.us|
|00005a20| 65 72 69 64 29 20 2b 20 | 22 27 20 6f 72 64 65 72 |erid) + |"' order|
|00005a30| 20 62 79 20 31 20 41 53 | 43 22 20 20 20 3b 0d 0a | by 1 AS|C" ;..|
|00005a40| 09 0d 0a 09 63 61 73 65 | 20 22 4f 44 42 22 09 09 |....case| "ODB"..|
|00005a50| 2f 2f 20 4f 44 42 43 0d | 0a 09 09 2f 2f 2a 2a 2a |// ODBC.|...//***|
|00005a60| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00005a70| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00005a80| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00005a90| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 0d |********|*******.|
|00005aa0| 0a 09 09 2f 2f 09 73 69 | 6e 63 65 20 55 73 65 72 |...//.si|nce User|
|00005ab0| 49 64 20 63 61 6e 20 62 | 65 20 62 6c 61 6e 6b 20 |Id can b|e blank |
|00005ac0| 66 6f 72 20 4f 44 42 43 | 2c 20 77 65 20 77 69 6c |for ODBC|, we wil|
|00005ad0| 6c 20 68 61 76 65 20 74 | 6f 20 0d 0a 09 09 2f 2f |l have t|o ....//|
|00005ae0| 20 4c 6f 6f 6b 20 61 74 | 20 74 68 65 20 44 42 50 | Look at| the DBP|
|00005af0| 41 52 4d 20 76 61 6c 75 | 65 73 20 20 54 68 69 73 |ARM valu|es This|
|00005b00| 20 63 6f 64 65 20 6d 61 | 79 20 62 65 20 73 70 65 | code ma|y be spe|
|00005b10| 63 69 66 69 63 20 74 6f | 20 0d 0a 09 09 2f 2f 20 |cific to| ....// |
|00005b20| 74 68 65 20 76 61 6c 75 | 65 73 20 74 68 61 74 20 |the valu|es that |
|00005b30| 77 61 74 63 6f 6d 20 75 | 73 65 73 20 69 6e 20 74 |watcom u|ses in t|
|00005b40| 68 65 20 44 42 50 41 52 | 41 4d 20 61 6e 64 20 6d |he DBPAR|AM and m|
|00005b50| 61 79 20 6e 65 65 64 20 | 74 6f 20 62 65 0d 0a 09 |ay need |to be...|
|00005b60| 09 2f 2f 20 55 70 64 61 | 74 65 64 20 66 6f 72 20 |.// Upda|ted for |
|00005b70| 6f 74 68 65 72 20 4f 44 | 42 43 20 69 6e 74 65 72 |other OD|BC inter|
|00005b80| 66 61 63 65 73 0d 0a 09 | 09 2f 2f 2a 2a 2a 2a 2a |faces...|.//*****|
|00005b90| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00005ba0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00005bb0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00005bc0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 0d 0a 09 |********|*****...|
|00005bd0| 09 69 66 20 73 71 6c 63 | 61 2e 75 73 65 72 69 64 |.if sqlc|a.userid|
|00005be0| 20 3d 20 22 22 20 74 68 | 65 6e 0d 0a 09 09 09 50 | = "" th|en.....P|
|00005bf0| 6f 73 55 69 64 20 3d 20 | 50 6f 73 28 73 71 6c 63 |osUid = |Pos(sqlc|
|00005c00| 44 41 54 2a 00 5e 00 00 | f6 01 61 2e 64 62 70 61 |DAT*.^..|..a.dbpa|
|00005c10| 72 6d 2c 20 22 55 49 44 | 22 2c 20 31 29 0d 0a 09 |rm, "UID|", 1)...|
|00005c20| 09 09 70 6f 73 45 71 75 | 61 6c 20 3d 20 50 6f 73 |..posEqu|al = Pos|
|00005c30| 28 73 71 6c 63 61 2e 64 | 62 70 61 72 6d 2c 20 22 |(sqlca.d|bparm, "|
|00005c40| 3d 22 2c 20 50 6f 73 55 | 69 64 29 0d 0a 09 09 09 |=", PosU|id).....|
|00005c50| 50 6f 73 53 65 6d 69 43 | 6f 6c 6f 6e 20 3d 20 50 |PosSemiC|olon = P|
|00005c60| 6f 73 28 73 71 6c 63 61 | 2e 64 62 70 61 72 6d 2c |os(sqlca|.dbparm,|
|00005c70| 20 22 3b 22 2c 20 50 6f | 73 45 71 75 61 6c 29 0d | ";", Po|sEqual).|
|00005c80| 0a 09 09 09 73 71 6c 63 | 61 2e 75 73 65 72 69 64 |....sqlc|a.userid|
|00005c90| 20 3d 20 4d 69 64 28 73 | 71 6c 63 61 2e 64 62 70 | = Mid(s|qlca.dbp|
|00005ca0| 61 72 6d 2c 20 50 6f 73 | 45 71 75 61 6c 20 2b 20 |arm, Pos|Equal + |
|00005cb0| 31 2c 20 50 6f 73 53 65 | 6d 69 43 6f 6c 6f 6e 20 |1, PosSe|miColon |
|00005cc0| 2d 20 28 50 6f 73 45 71 | 75 61 6c 20 2b 31 20 29 |- (PosEq|ual +1 )|
|00005cd0| 29 0d 0a 09 09 65 6e 64 | 20 69 66 0d 0a 0d 0a 09 |)....end| if.....|
|00005ce0| 09 73 71 6c 20 3d 20 27 | 53 45 4c 45 43 54 20 44 |.sql = '|SELECT D|
|00005cf0| 49 53 54 49 4e 43 54 20 | 22 44 42 41 22 2e 22 50 |ISTINCT |"DBA"."P|
|00005d00| 42 43 41 54 54 42 4c 22 | 2e 22 50 42 54 5f 54 4e |BCATTBL"|."PBT_TN|
|00005d10| 41 4d 22 20 27 20 26 20 | 20 0d 0a 09 09 09 20 20 |AM" ' & | ..... |
|00005d20| 20 2b 20 27 20 46 52 4f | 4d 20 22 44 42 41 22 2e | + ' FRO|M "DBA".|
|00005d30| 22 50 42 43 41 54 54 42 | 4c 22 20 27 20 26 20 20 |"PBCATTB|L" ' & |
|00005d40| 0d 0a 09 09 09 20 20 20 | 2b 20 27 20 57 48 45 52 |..... |+ ' WHER|
|00005d50| 45 20 22 44 42 41 22 2e | 22 50 42 43 41 54 54 42 |E "DBA".|"PBCATTB|
|00005d60| 4c 22 2e 22 50 42 54 5f | 4f 57 4e 52 22 20 3d 20 |L"."PBT_|OWNR" = |
|00005d70| 7e 27 27 20 26 0d 0a 09 | 09 09 09 2b 20 55 70 70 |~'' &...|...+ Upp|
|00005d80| 65 72 28 73 71 6c 63 61 | 2e 75 73 65 72 69 64 29 |er(sqlca|.userid)|
|00005d90| 20 2b 20 27 7e 27 20 6f | 72 64 65 72 20 62 79 20 | + '~' o|rder by |
|00005da0| 31 20 41 53 43 27 20 20 | 20 3b 0d 0a 0d 0a 09 63 |1 ASC' | ;.....c|
|00005db0| 61 73 65 20 22 58 44 42 | 22 09 09 2f 2f 20 58 44 |ase "XDB|"..// XD|
|00005dc0| 42 0d 0a 09 09 73 71 6c | 20 3d 20 22 53 65 6c 65 |B....sql| = "Sele|
|00005dd0| 63 74 20 44 49 53 54 49 | 4e 43 54 20 50 42 43 41 |ct DISTI|NCT PBCA|
|00005de0| 54 54 42 4c 2e 50 42 54 | 5f 54 4e 41 4d 20 22 20 |TTBL.PBT|_TNAM " |
|00005df0| 26 0d 0a 09 09 09 09 2b | 20 22 20 66 72 6f 6d 20 |&......+| " from |
|00005e00| 44 41 54 2a 00 60 00 00 | f6 01 50 42 43 41 54 54 |DAT*.`..|..PBCATT|
|00005e10| 42 4c 20 77 68 65 72 65 | 20 50 42 54 5f 4f 57 4e |BL where| PBT_OWN|
|00005e20| 52 20 3d 20 27 22 20 26 | 20 0d 0a 09 09 09 09 2b |R = '" &| ......+|
|00005e30| 20 55 70 70 65 72 28 73 | 71 6c 63 61 2e 75 73 65 | Upper(s|qlca.use|
|00005e40| 72 69 64 29 20 2b 20 22 | 27 20 6f 72 64 65 72 20 |rid) + "|' order |
|00005e50| 62 79 20 31 20 41 53 43 | 22 0d 0a 0d 0a 09 63 61 |by 1 ASC|".....ca|
|00005e60| 73 65 20 22 53 59 42 22 | 09 09 2f 2f 20 53 51 4c |se "SYB"|..// SQL|
|00005e70| 20 53 65 72 76 65 72 0d | 0a 09 20 20 20 73 71 6c | Server.|.. sql|
|00005e80| 20 3d 20 22 53 45 4c 45 | 43 54 20 44 49 53 54 49 | = "SELE|CT DISTI|
|00005e90| 4e 43 54 20 64 62 6f 2e | 50 42 43 41 54 54 42 4c |NCT dbo.|PBCATTBL|
|00005ea0| 2e 50 42 54 5f 54 4e 41 | 4d 29 22 20 26 20 20 0d |.PBT_TNA|M)" & .|
|00005eb0| 0a 09 20 20 20 20 20 20 | 20 20 20 2b 20 22 20 46 |.. | + " F|
|00005ec0| 52 4f 4d 20 64 62 6f 2e | 50 42 43 41 54 54 42 4c |ROM dbo.|PBCATTBL|
|00005ed0| 20 6f 72 64 65 72 20 62 | 79 20 31 20 41 53 43 22 | order b|y 1 ASC"|
|00005ee0| 0d 0a 0d 0a 09 63 61 73 | 65 20 22 4f 52 41 22 2c |.....cas|e "ORA",|
|00005ef0| 20 22 4f 52 36 22 2c 20 | 22 4f 52 37 22 09 2f 2f | "OR6", |"OR7".//|
|00005f00| 20 4f 52 41 43 4c 45 0d | 0a 09 09 73 71 6c 20 3d | ORACLE.|...sql =|
|00005f10| 20 22 53 45 4c 45 43 54 | 20 44 49 53 54 49 4e 43 | "SELECT| DISTINC|
|00005f20| 54 20 53 59 53 54 45 4d | 2e 50 42 43 41 54 54 42 |T SYSTEM|.PBCATTB|
|00005f30| 4c 2e 50 42 54 5f 54 4e | 41 4d 20 22 20 26 20 20 |L.PBT_TN|AM " & |
|00005f40| 0d 0a 09 09 09 20 20 20 | 2b 20 22 20 46 52 4f 4d |..... |+ " FROM|
|00005f50| 20 53 59 53 54 45 4d 2e | 50 42 43 41 54 54 42 4c | SYSTEM.|PBCATTBL|
|00005f60| 20 22 20 26 20 20 0d 0a | 09 09 09 20 20 20 2b 20 | " & ..|... + |
|00005f70| 22 20 57 48 45 52 45 20 | 73 79 73 74 65 6d 2e 50 |" WHERE |system.P|
|00005f80| 42 43 41 54 54 42 4c 2e | 50 42 54 5f 4f 57 4e 52 |BCATTBL.|PBT_OWNR|
|00005f90| 20 3d 20 27 22 20 26 0d | 0a 09 09 09 09 2b 20 55 | = '" &.|.....+ U|
|00005fa0| 70 70 65 72 28 73 71 6c | 63 61 2e 6c 6f 67 69 64 |pper(sql|ca.logid|
|00005fb0| 29 20 2b 20 22 27 20 6f | 72 64 65 72 20 62 79 20 |) + "' o|rder by |
|00005fc0| 31 20 41 53 43 22 20 20 | 20 3b 0d 0a 0d 0a 09 63 |1 ASC" | ;.....c|
|00005fd0| 61 73 65 20 22 48 50 41 | 22 09 09 2f 2f 20 41 4c |ase "HPA|"..// AL|
|00005fe0| 4c 42 41 53 45 2f 53 51 | 4c 0d 0a 09 09 73 71 6c |LBASE/SQ|L....sql|
|00005ff0| 20 3d 20 22 53 45 4c 45 | 43 54 20 44 49 53 54 49 | = "SELE|CT DISTI|
|00006000| 44 41 54 2a 00 62 00 00 | f6 01 4e 43 54 20 53 59 |DAT*.b..|..NCT SY|
|00006010| 53 53 51 4c 2e 50 42 43 | 41 54 54 42 4c 2e 50 42 |SSQL.PBC|ATTBL.PB|
|00006020| 54 5f 54 4e 41 4d 20 22 | 20 26 20 20 0d 0a 09 09 |T_TNAM "| & ....|
|00006030| 09 20 20 20 2b 20 22 20 | 46 52 4f 4d 20 53 59 53 |. + " |FROM SYS|
|00006040| 53 51 4c 2e 50 42 43 41 | 54 54 42 4c 20 22 20 26 |SQL.PBCA|TTBL " &|
|00006050| 20 20 0d 0a 09 09 09 20 | 20 20 2b 20 22 20 57 48 | ..... | + " WH|
|00006060| 45 52 45 20 73 79 73 73 | 71 6c 2e 50 42 43 41 54 |ERE syss|ql.PBCAT|
|00006070| 54 42 4c 2e 50 42 54 5f | 4f 57 4e 52 20 3d 20 27 |TBL.PBT_|OWNR = '|
|00006080| 22 20 26 0d 0a 09 09 09 | 09 2b 20 55 70 70 65 72 |" &.....|.+ Upper|
|00006090| 28 73 71 6c 63 61 2e 75 | 73 65 72 69 64 29 20 2b |(sqlca.u|serid) +|
|000060a0| 20 22 27 20 6f 72 64 65 | 72 20 62 79 20 31 20 41 | "' orde|r by 1 A|
|000060b0| 53 43 22 20 20 20 3b 0d | 0a 0d 0a 09 63 61 73 65 |SC" ;.|....case|
|000060c0| 20 22 49 4e 46 22 09 09 | 2f 2f 20 49 4e 46 4f 52 | "INF"..|// INFOR|
|000060d0| 4d 49 58 0d 0a 09 09 73 | 71 6c 20 3d 20 22 53 65 |MIX....s|ql = "Se|
|000060e0| 6c 65 63 74 20 44 49 53 | 54 49 4e 43 54 20 50 42 |lect DIS|TINCT PB|
|000060f0| 54 5f 54 4e 41 4d 20 22 | 20 26 0d 0a 09 09 09 09 |T_TNAM "| &......|
|00006100| 2b 20 22 66 72 6f 6d 20 | 27 69 6e 66 6f 72 6d 69 |+ "from |'informi|
|00006110| 78 27 2e 50 42 43 41 54 | 54 42 4c 20 22 20 26 0d |x'.PBCAT|TBL " &.|
|00006120| 0a 09 09 09 09 2b 20 22 | 77 68 65 72 65 20 50 42 |.....+ "|where PB|
|00006130| 54 5f 4f 57 4e 52 20 3d | 20 27 22 20 2b 20 73 71 |T_OWNR =| '" + sq|
|00006140| 6c 63 61 2e 6c 6f 67 69 | 64 20 26 0d 0a 09 09 09 |lca.logi|d &.....|
|00006150| 09 2b 20 22 27 20 6f 72 | 64 65 72 20 62 79 20 31 |.+ "' or|der by 1|
|00006160| 20 41 53 43 22 0d 0a 0d | 0a 09 63 61 73 65 20 45 | ASC"...|..case E|
|00006170| 4c 53 45 0d 0a 09 09 4d | 65 73 73 61 67 65 42 6f |LSE....M|essageBo|
|00006180| 78 20 28 22 45 72 72 6f | 72 21 22 2c 20 22 55 6e |x ("Erro|r!", "Un|
|00006190| 6b 6e 6f 77 6e 20 44 61 | 74 61 62 61 73 65 20 4e |known Da|tabase N|
|000061a0| 61 6d 65 21 22 29 0d 0a | 0d 0a 65 6e 64 20 63 68 |ame!")..|..end ch|
|000061b0| 6f 6f 73 65 0d 0a 0d 0a | 69 66 20 4c 65 6e 28 73 |oose....|if Len(s|
|000061c0| 71 6c 29 20 3e 20 30 20 | 74 68 65 6e 0d 0a 09 52 |ql) > 0 |then...R|
|000061d0| 65 74 75 72 6e 20 64 77 | 5f 61 72 67 2e 53 65 74 |eturn dw|_arg.Set|
|000061e0| 53 51 4c 53 65 6c 65 63 | 74 28 73 71 6c 29 0d 0a |SQLSelec|t(sql)..|
|000061f0| 65 6c 73 65 0d 0a 09 72 | 65 74 75 72 6e 20 2d 31 |else...r|eturn -1|
|00006200| 44 41 54 2a 00 00 00 00 | 1e 00 0d 0a 65 6e 64 20 |DAT*....|....end |
|00006210| 69 66 0d 0a 0d 0a 0d 0a | 65 6e 64 20 66 75 6e 63 |if......|end func|
|00006220| 74 69 6f 6e 0d 0a 0d 0a | 00 00 00 00 00 00 00 00 |tion....|........|
|00006230| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00006240| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00006250| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00006260| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00006270| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00006280| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00006290| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000062a0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000062b0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000062c0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000062d0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000062e0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000062f0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00006300| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00006310| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00006320| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00006330| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00006340| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00006350| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00006360| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00006370| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00006380| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00006390| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000063a0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000063b0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000063c0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000063d0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000063e0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000063f0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
+--------+-------------------------+-------------------------+--------+--------+
Only 25.0 KB of data is shown above.
