/ Liren Large Software Subsidy 5 / 05.iso / a / a025 / 10.ddi / VBSQLGEN.BAS

< prev

next >

MacOS 8.1

Win98

DOS

view JSON data

view as text

+--------+-------------------------+-------------------------+--------+--------+
|00000000| fc 01 02 00 0e 00 1e 01 | 1e 01 08 00 01 02 03 04 |........|........|
|00000010| 06 05 08 0a 00 11 d4 05 | 8b 09 00 00 1a 00 ae 00 |........|........|
|00000020| 8d 00 c9 00 f8 01 1f 01 | ef 00 f7 00 5a 01 51 02 |........|....Z.Q.|
|00000030| 6b 01 d9 00 0c 01 9d 00 | bb 00 08 02 99 07 c5 06 |k.......|........|
|00000040| 41 01 30 01 35 03 1f 06 | 39 02 ef 02 87 01 b6 01 |A.0.5...|9.......|
|00000050| fb 02 f6 03 5a 00 e5 05 | 70 05 ff 04 6f 00 00 00 |....Z...|p...o...|
|00000060| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000070| 8b 09 00 00 99 05 80 11 | 50 72 6f 63 65 73 73 5f |........|Process_|
|00000080| 53 51 4c 5f 71 75 65 72 | 79 7d 00 80 0a 63 6f 6c |SQL_quer|y}...col|
|00000090| 6c 65 6e 67 74 68 73 e6 | 03 80 0c 63 6f 6c 70 6f |lengths.|...colpo|
|000000a0| 73 69 74 69 6f 6e 73 14 | 01 80 0c 41 6c 74 43 6f |sitions.|...AltCo|
|000000b0| 6c 44 65 74 61 69 6c cf | 00 00 0d 41 6c 74 43 6f |lDetail.|...AltCo|
|000000c0| 6c 75 6d 6e 44 61 74 61 | e0 00 80 09 43 6f 6c 44 |lumnData|....ColD|
|000000d0| 65 74 61 69 6c 18 04 00 | 0a 43 6f 6c 75 6d 6e 44 |etail...|.ColumnD|
|000000e0| 61 74 61 5d 03 80 02 4e | 4c 01 01 80 06 54 41 42 |ata]...N|L....TAB|
|000000f0| 4b 45 59 83 02 80 03 63 | 6d 64 47 02 00 0b 51 55 |KEY....c|mdG...QU|
|00000100| 45 52 59 5f 46 49 45 4c | 44 68 03 00 04 54 65 78 |ERY_FIEL|Dh...Tex|
|00000110| 74 74 02 00 06 53 71 6c | 43 6d 64 d4 01 80 07 53 |tt...Sql|Cmd....S|
|00000120| 71 6c 43 6f 6e 6e 4f 01 | 80 04 46 41 49 4c 6a 02 |qlConnO.|..FAILj.|
|00000130| 00 07 53 71 6c 45 78 65 | 63 39 09 80 0d 52 65 73 |..SqlExe|c9...Res|
|00000140| 75 6c 74 50 72 6f 63 65 | 73 73 16 02 80 0d 4e 4f |ultProce|ss....NO|
|00000150| 4d 4f 52 45 52 45 53 55 | 4c 54 53 77 01 00 0a 53 |MORERESU|LTSw...S|
|00000160| 71 6c 52 65 73 75 6c 74 | 73 00 00 80 07 6e 75 6d |qlResult|s....num|
|00000170| 63 6f 6d 70 c6 01 00 0d | 53 71 6c 4e 75 6d 43 6f |comp....|SqlNumCo|
|00000180| 6d 70 75 74 65 9f 01 80 | 08 6e 75 6d 6f 72 64 65 |mpute...|.numorde|
|00000190| 72 91 01 00 0c 53 71 6c | 4e 75 6d 4f 72 64 65 72 |r....Sql|NumOrder|
|000001a0| 73 e1 01 80 06 6e 75 6d | 63 6f 6c 5c 02 00 0a 53 |s....num|col\...S|
|000001b0| 71 6c 4e 75 6d 43 6f 6c | 73 aa 01 80 07 63 6f 6c |qlNumCol|s....col|
|000001c0| 6c 69 6e 65 bb 01 80 08 | 63 6f 6c 75 6c 69 6e 65 |line....|coluline|
|000001d0| ab 04 80 01 78 c1 02 80 | 07 63 6f 6c 6e 61 6d 65 |....x...|.colname|
|000001e0| 90 02 00 0a 53 71 6c 43 | 6f 6c 4e 61 6d 65 eb 01 |....SqlC|olName..|
|000001f0| 00 09 53 71 6c 43 6f 6c | 4c 65 6e 24 02 80 06 74 |..SqlCol|Len$...t|
|00000200| 6d 70 6c 65 6e d8 02 80 | 09 61 63 74 75 61 6c 6c |mplen...|.actuall|
|00000210| 65 6e 2f 02 00 0c 52 45 | 53 55 4c 54 53 5f 6c 69 |en/...RE|SULTS_li|
|00000220| 73 74 0c 03 80 0a 52 6f | 77 50 72 6f 63 65 73 73 |st....Ro|wProcess|
|00000230| 9d 02 80 0a 4e 4f 4d 4f | 52 45 52 4f 57 53 bd 06 |....NOMO|REROWS..|
|00000240| 80 07 44 61 74 61 53 74 | 72 b5 02 80 06 52 65 73 |..DataSt|r....Res|
|00000250| 75 6c 74 86 03 00 0a 53 | 71 6c 4e 65 78 74 52 6f |ult....S|qlNextRo|
|00000260| 77 c7 03 80 06 52 45 47 | 52 4f 57 a9 02 80 07 6e |w....REG|ROW....n|
|00000270| 75 6d 61 6c 74 73 00 03 | 00 0a 53 71 6c 4e 75 6d |umalts..|..SqlNum|
|00000280| 41 6c 74 73 26 05 80 06 | 61 6c 74 63 6f 6c 47 05 |Alts&...|altcolG.|
|00000290| 00 0b 53 71 6c 41 6c 74 | 43 6f 6c 49 64 0e 06 80 |..SqlAlt|ColId...|
|000002a0| 09 61 6c 74 73 74 72 69 | 6e 67 1b 03 00 09 53 51 |.altstri|ng....SQ|
|000002b0| 4c 50 52 54 59 50 45 3b | 05 00 08 53 71 6c 41 6c |LPRTYPE;|...SqlAl|
|000002c0| 74 4f 70 64 04 80 08 61 | 6c 74 76 61 6c 75 65 cd |tOpd...a|ltvalue.|
|000002d0| 02 00 08 53 71 6c 41 44 | 61 74 61 e5 02 80 08 43 |...SqlAD|ata....C|
|000002e0| 6f 6c 56 61 6c 75 65 8b | 07 00 07 53 71 6c 44 61 |olValue.|...SqlDa|
|000002f0| 74 61 97 03 00 09 53 71 | 6c 44 61 74 4c 65 6e 0e |ta....Sq|lDatLen.|
|00000300| 04 80 06 72 6f 77 63 6e | 74 27 03 00 08 53 71 6c |...rowcn|t'...Sql|
|00000310| 43 6f 75 6e 74 48 03 80 | 01 79 e0 04 80 08 6f 72 |CountH..|.y....or|
|00000320| 64 65 72 63 6f 6c a7 05 | 00 0b 53 71 6c 4f 72 64 |dercol..|..SqlOrd|
|00000330| 65 72 43 6f 6c a2 03 00 | 08 53 71 6c 43 6c 6f 73 |erCol...|.SqlClos|
|00000340| 65 87 04 00 0a 53 71 6c | 57 69 6e 45 78 69 74 b8 |e....Sql|WinExit.|
|00000350| 03 40 0f 45 78 69 74 41 | 70 70 6c 69 63 61 74 69 |.@.ExitA|pplicati|
|00000360| 6f 6e 80 04 80 11 45 78 | 65 63 75 74 65 53 51 4c |on....Ex|ecuteSQL|
|00000370| 43 6f 6d 6d 61 6e 64 cf | 04 80 07 53 55 43 43 45 |Command.|...SUCCE|
|00000380| 45 44 02 04 40 1a 43 68 | 61 6e 67 65 50 72 69 6d |ED..@.Ch|angePrim|
|00000390| 61 72 79 57 69 6e 64 6f | 77 43 61 70 74 69 6f 6e |aryWindo|wCaption|
|000003a0| 7c 08 80 0d 50 72 69 6d | 61 72 79 57 69 6e 64 6f ||...Prim|aryWindo|
|000003b0| 77 10 05 00 07 43 61 70 | 74 69 6f 6e bb 04 80 12 |w....Cap|tion....|
|000003c0| 50 72 69 6d 61 72 79 57 | 69 6e 64 6f 77 54 69 74 |PrimaryW|indowTit|
|000003d0| 6c 65 d8 03 00 0b 53 65 | 72 76 65 72 5f 6e 61 6d |le....Se|rver_nam|
|000003e0| 65 1a 05 00 0d 44 61 74 | 61 62 61 73 65 5f 6e 61 |e....Dat|abase_na|
|000003f0| 6d 65 c6 04 80 0a 53 65 | 72 76 65 72 6e 61 6d 65 |me....Se|rvername|
|00000400| 23 04 00 0c 44 69 73 70 | 6c 61 79 45 72 72 6f 72 |#...Disp|layError|
|00000410| 00 00 00 08 45 72 72 6f | 72 4e 75 6d 92 04 00 08 |....Erro|rNum....|
|00000420| 45 72 72 6f 72 53 74 72 | 4b 04 80 06 4e 75 6d 62 |ErrorStr|K...Numb|
|00000430| 65 72 26 08 80 07 4d 65 | 73 73 61 67 65 36 04 40 |er&...Me|ssage6.@|
|00000440| 0f 44 69 73 70 6c 61 79 | 53 51 4c 45 72 72 6f 72 |.Display|SQLError|
|00000450| 24 07 40 11 44 69 73 70 | 6c 61 79 44 42 4c 49 42 |$.@.Disp|layDBLIB|
|00000460| 45 72 72 6f 72 ca 05 40 | 15 49 6e 69 74 69 61 6c |Error..@|.Initial|
|00000470| 69 7a 65 41 70 70 6c 69 | 63 61 74 69 6f 6e d4 05 |izeAppli|cation..|
|00000480| 00 18 53 75 62 49 6e 69 | 74 69 61 6c 69 7a 65 41 |..SubIni|tializeA|
|00000490| 70 70 6c 69 63 61 74 69 | 6f 6e cd 06 00 03 4d 73 |pplicati|on....Ms|
|000004a0| 67 7f 06 00 07 53 71 6c | 49 6e 69 74 51 05 80 15 |g....Sql|InitQ...|
|000004b0| 43 68 65 63 6b 53 65 72 | 76 65 72 43 6f 6e 6e 65 |CheckSer|verConne|
|000004c0| 63 74 69 6f 6e 2a 06 80 | 0c 4d 61 6b 65 52 75 6c |ction*..|.MakeRul|
|000004d0| 65 4c 69 73 74 19 06 80 | 07 52 61 77 74 65 78 74 |eList...|.Rawtext|
|000004e0| ed 04 80 05 73 74 61 72 | 74 08 05 00 0d 52 75 6c |....star|t....Rul|
|000004f0| 65 53 74 72 75 63 74 75 | 72 65 49 07 80 09 53 51 |eStructu|reI...SQ|
|00000500| 4c 53 74 61 74 75 73 81 | 05 80 0e 57 61 72 6e 69 |LStatus.|...Warni|
|00000510| 6e 67 4d 65 73 73 61 67 | 65 b0 06 80 05 49 44 59 |ngMessag|e....IDY|
|00000520| 45 53 50 06 80 04 49 44 | 4e 4f 7e 07 80 06 4d 73 |ESP...ID|NO~...Ms|
|00000530| 67 53 74 72 f9 05 80 08 | 4d 42 5f 59 45 53 4e 4f |gStr....|MB_YESNO|
|00000540| 5a 05 80 11 4d 42 5f 49 | 43 4f 4e 45 58 4c 41 4d |Z...MB_I|CONEXLAM|
|00000550| 41 54 49 4f 4e 00 00 80 | 08 52 65 73 70 6f 6e 73 |ATION...|.Respons|
|00000560| 65 d5 06 00 06 4d 73 62 | 42 6f 78 8f 05 80 05 44 |e....Msb|Box....D|
|00000570| 67 44 65 66 0c 07 80 12 | 4d 42 5f 49 43 4f 4e 45 |gDef....|MB_ICONE|
|00000580| 58 43 4c 41 4d 41 54 49 | 4f 4e f7 08 80 0d 4d 42 |XCLAMATI|ON....MB|
|00000590| 5f 44 45 46 42 55 54 54 | 4f 4e 32 01 06 80 0a 44 |_DEFBUTT|ON2....D|
|000005a0| 45 46 42 55 54 54 4f 4e | 32 00 00 40 06 4c 6f 67 |EFBUTTON|2..@.Log|
|000005b0| 6f 66 66 00 00 80 0a 4f | 75 74 70 75 74 44 61 74 |off....O|utputDat|
|000005c0| 61 ba 05 00 0f 4f 75 74 | 70 75 74 52 6f 77 53 74 |a....Out|putRowSt|
|000005d0| 72 75 63 74 15 07 80 0c | 6f 75 74 70 75 74 72 6f |ruct....|outputro|
|000005e0| 77 63 6e 74 f4 05 00 06 | 63 6f 6c 69 6e 65 57 07 |wcnt....|colineW.|
|000005f0| 80 0d 44 42 4c 49 42 5f | 56 45 52 53 49 4f 4e 8a |..DBLIB_|VERSION.|
|00000600| 06 00 0b 45 78 70 65 6e | 73 65 44 61 74 61 ee 07 |...Expen|seData..|
|00000610| 80 01 69 6f 06 00 04 44 | 61 74 65 d4 08 00 09 53 |..io...D|ate....S|
|00000620| 65 74 75 70 52 75 6c 65 | aa 06 00 07 52 75 6c 65 |etupRule|....Rule|
|00000630| 4e 75 6d 5c 06 80 02 69 | 6e 43 06 00 07 50 61 79 |Num\...i|nC...Pay|
|00000640| 72 75 6c 65 39 06 00 0b | 4d 41 58 52 55 4c 45 4c |rule9...|MAXRULEL|
|00000650| 49 53 54 df 06 80 06 65 | 6e 64 70 6f 73 1a 08 40 |IST....e|ndpos..@|
|00000660| 09 50 61 72 73 65 52 75 | 6c 65 a2 08 80 08 52 75 |.ParseRu|le....Ru|
|00000670| 6c 65 6e 61 6d 65 30 07 | 00 0f 47 65 74 44 61 74 |lename0.|..GetDat|
|00000680| 61 62 61 73 65 4e 61 6d | 65 9e 06 80 0c 44 61 74 |abaseNam|e....Dat|
|00000690| 61 62 61 73 65 4e 61 6d | 65 04 07 00 07 53 71 6c |abaseNam|e....Sql|
|000006a0| 45 78 69 74 f1 08 40 10 | 46 69 78 54 65 78 74 4c |Exit..@.|FixTextL|
|000006b0| 69 6e 65 46 65 65 64 73 | cb 08 80 08 49 6e 53 74 |ineFeeds|....InSt|
|000006c0| 72 69 6e 67 00 00 80 02 | 4c 46 00 00 80 09 54 6d |ring....|LF....Tm|
|000006d0| 70 53 74 72 69 6e 67 4c | 08 80 04 43 52 4c 46 d3 |pStringL|...CRLF.|
|000006e0| 07 00 04 4d 69 64 34 fd | 06 00 04 43 68 61 72 00 |...Mid4.|...Char.|
|000006f0| 00 80 06 6d 79 63 68 61 | 72 ef 06 40 0c 44 6f 75 |...mycha|r..@.Dou|
|00000700| 62 6c 65 51 75 6f 74 65 | 73 00 00 00 0a 63 68 61 |bleQuote|s....cha|
|00000710| 72 61 63 74 65 72 73 00 | 00 00 03 74 68 65 3e 07 |racters.|...the>.|
|00000720| 00 04 77 69 74 68 00 00 | 00 05 51 55 4f 54 45 00 |..with..|..QUOTE.|
|00000730| 00 80 0b 44 4f 55 42 4c | 45 51 55 4f 54 45 62 09 |...DOUBL|EQUOTEb.|
|00000740| 80 08 43 6f 6c 74 79 70 | 65 73 62 07 00 0a 53 71 |..Coltyp|esb...Sq|
|00000750| 6c 43 6f 6c 54 79 70 65 | aa 07 80 07 53 51 4c 54 |lColType|....SQLT|
|00000760| 45 58 54 c3 07 00 0a 53 | 51 4c 4e 75 6d 52 65 74 |EXT....S|QLNumRet|
|00000770| 73 00 00 80 07 6e 75 6d | 72 65 74 73 70 07 00 0a |s....num|retsp...|
|00000780| 53 51 4c 52 65 74 4e 61 | 6d 65 39 08 00 0a 53 51 |SQLRetNa|me9...SQ|
|00000790| 4c 52 65 74 54 79 70 65 | 5c 08 00 09 53 51 4c 52 |LRetType|\...SQLR|
|000007a0| 65 74 4c 65 6e bb 07 00 | 0a 53 51 4c 52 65 74 44 |etLen...|.SQLRetD|
|000007b0| 61 74 61 00 00 00 0d 6f | 75 74 70 75 74 72 6f 77 |ata....o|utputrow|
|000007c0| 63 6e 74 35 00 00 00 0d | 53 51 4c 48 61 73 52 65 |cnt5....|SQLHasRe|
|000007d0| 74 53 74 61 74 00 00 80 | 04 54 52 55 45 de 07 00 |tStat...|.TRUE...|
|000007e0| 0c 53 51 4c 52 65 74 53 | 74 61 74 75 73 bb 08 80 |.SQLRetS|tatus...|
|000007f0| 07 53 51 4c 43 48 41 52 | fe 07 80 0c 47 65 74 44 |.SQLCHAR|....GetD|
|00000800| 61 74 61 62 61 73 65 73 | 06 08 00 0c 44 42 4e 41 |atabases|....DBNA|
|00000810| 4d 45 5f 43 4f 4d 42 4f | 09 09 00 04 4c 69 73 74 |ME_COMBO|....List|
|00000820| 00 00 80 10 44 61 74 61 | 62 61 73 65 5f 43 6f 6e |....Data|base_Con|
|00000830| 74 72 6f 6c 2f 08 00 08 | 43 6f 6d 62 6f 42 6f 78 |trol/...|ComboBox|
|00000840| 00 00 00 05 4c 6f 67 69 | 6e 4e 09 80 06 53 74 61 |....Logi|nN...Sta|
|00000850| 74 75 73 71 08 00 0f 53 | 71 6c 53 65 74 4c 6f 67 |tusq...S|qlSetLog|
|00000860| 69 6e 54 69 6d 65 44 09 | 80 0c 4c 6f 67 69 6e 54 |inTimeD.|..LoginT|
|00000870| 69 6d 65 6f 75 74 00 00 | 00 11 53 71 6c 4f 70 65 |imeout..|..SqlOpe|
|00000880| 6e 43 6f 6e 6e 65 63 74 | 69 6f 6e 88 08 80 07 4c |nConnect|ion....L|
|00000890| 6f 67 69 6e 49 44 80 09 | 80 08 50 61 73 73 77 6f |oginID..|..Passwo|
|000008a0| 72 64 97 08 80 0b 50 72 | 6f 67 72 61 6d 4e 61 6d |rd....Pr|ogramNam|
|000008b0| 65 ad 08 00 07 53 71 6c | 4e 61 6d 65 db 08 00 07 |e....Sql|Name....|
|000008c0| 52 65 73 75 6c 74 35 00 | 00 00 0a 53 71 6c 53 65 |Result5.|...SqlSe|
|000008d0| 74 54 69 6d 65 00 00 80 | 0c 51 75 65 72 79 54 69 |tTime...|.QueryTi|
|000008e0| 6d 65 6f 75 74 e9 08 00 | 05 43 68 65 63 6b 1a 09 |meout...|.Check..|
|000008f0| 00 03 73 65 65 00 00 00 | 0a 63 6f 6e 6e 65 63 74 |..see...|.connect|
|00000900| 69 6f 6e 00 00 00 04 6c | 69 76 65 fd 08 00 02 73 |ion....l|ive....s|
|00000910| 6f 00 00 00 02 69 74 00 | 00 00 08 52 65 6d 43 68 |o....it.|...RemCh|
|00000920| 65 63 6b 00 00 80 0d 4c | 6f 67 69 6e 54 6f 53 65 |eck....L|oginToSe|
|00000930| 72 76 65 72 2c 09 00 0e | 52 65 70 6f 72 74 53 74 |rver,...|ReportSt|
|00000940| 61 6e 64 61 72 64 00 00 | 00 09 44 65 66 53 65 72 |andard..|..DefSer|
|00000950| 76 65 72 58 09 00 07 72 | 65 6d 6f 76 65 73 00 00 |verX...r|emoves..|
|00000960| 00 06 71 75 6f 74 65 73 | 00 00 00 06 73 74 6f 72 |..quotes|....stor|
|00000970| 65 73 00 00 00 06 76 61 | 6c 75 65 73 71 09 80 0b |es....va|luesq...|
|00000980| 53 49 4e 47 4c 45 51 55 | 49 54 45 00 00 80 0b 53 |SINGLEQU|ITE....S|
|00000990| 49 4e 47 4c 45 51 55 4f | 54 45 00 00 80 07 44 65 |INGLEQUO|TE....De|
|000009a0| 66 61 75 6c 74 0c 00 00 | 00 18 00 00 00 00 00 09 |fault...|........|
|000009b0| 00 08 00 ff ff ff ff ff | ff ff ff 02 00 00 00 03 |........|........|
|000009c0| 01 00 11 00 50 72 6f 63 | 65 73 73 5f 53 51 4c 5f |....Proc|ess_SQL_|
|000009d0| 71 75 65 72 79 02 0a 30 | 7e 10 38 11 18 00 00 00 |query..0|~.8.....|
|000009e0| 40 00 16 00 5a 00 c2 02 | 02 00 d9 00 00 80 06 00 |@...Z...|........|
|000009f0| 00 00 99 05 00 c0 06 00 | 00 00 00 00 00 00 98 00 |........|........|
|00000a00| 00 00 00 00 98 00 41 00 | 20 54 68 69 73 20 72 6f |......A.| This ro|
|00000a10| 75 74 69 6e 65 20 77 69 | 6c 6c 20 70 72 6f 63 65 |utine wi|ll proce|
|00000a20| 73 73 20 71 75 65 72 79 | 20 72 6f 77 73 20 61 6e |ss query| rows an|
|00000a30| 64 20 6f 75 74 70 75 74 | 20 74 68 65 20 74 6f 74 |d output| the tot|
|00000a40| 61 6c 20 6e 75 6d 62 65 | 72 75 00 00 98 00 40 00 |al numbe|ru....@.|
|00000a50| 20 6f 66 20 72 6f 77 73 | 20 77 68 69 63 68 20 72 | of rows| which r|
|00000a60| 65 66 6c 65 63 74 73 20 | 74 68 65 20 6e 75 6d 62 |eflects |the numb|
|00000a70| 65 72 20 6f 66 20 69 74 | 65 6d 73 20 69 6e 20 74 |er of it|ems in t|
|00000a80| 68 65 20 6f 75 74 70 75 | 74 20 61 72 72 61 79 2e |he outpu|t array.|
|00000a90| 00 00 98 00 00 00 00 00 | 98 00 44 00 20 44 65 66 |........|..D. Def|
|00000aa0| 69 6e 65 20 61 72 72 61 | 79 20 66 6f 72 20 63 6f |ine arra|y for co|
|00000ab0| 6c 75 6d 6e 20 6c 65 6e | 67 74 68 73 2c 20 63 6f |lumn len|gths, co|
|00000ac0| 6c 75 6d 6e 20 70 6f 73 | 69 74 69 6f 6e 73 2c 20 |lumn pos|itions, |
|00000ad0| 61 6e 64 20 63 6f 6c 75 | 6d 6e 20 74 79 70 65 73 |and colu|mn types|
|00000ae0| 00 00 98 00 49 00 20 44 | 65 66 69 6e 65 20 73 74 |....I. D|efine st|
|00000af0| 72 75 63 74 75 72 65 73 | 20 66 6f 72 20 67 65 74 |ructures| for get|
|00000b00| 74 69 6e 67 20 61 20 63 | 6f 6d 70 75 74 65 20 63 |ting a c|ompute c|
|00000b10| 6f 6c 75 6d 6e 27 73 20 | 69 6e 66 6f 72 6d 61 74 |olumn's |informat|
|00000b20| 69 6f 6e 20 61 6e 64 20 | 67 65 74 74 69 6e 67 6f |ion and |gettingo|
|00000b30| 00 00 98 00 1f 00 20 61 | 20 72 65 67 75 6c 61 72 |...... a| regular|
|00000b40| 20 63 6f 6c 75 6d 6e 27 | 73 20 69 6e 66 6f 72 6d | column'|s inform|
|00000b50| 61 74 69 6f 6e 61 00 00 | 98 00 00 00 00 00 00 00 |ationa..|........|
|00000b60| 18 01 8e 01 0d 18 c1 02 | 00 00 18 01 a6 01 17 00 |........|........|
|00000b70| e5 00 ff 00 16 00 02 00 | 17 00 10 00 02 00 6f 00 |........|......o.|
|00000b80| 00 00 18 01 be 01 17 00 | e5 00 ff 00 16 00 01 00 |........|........|
|00000b90| 19 00 10 00 02 00 7d 00 | 00 00 18 01 d6 01 17 00 |......}.|........|
|00000ba0| e5 00 32 00 16 00 01 00 | 14 00 10 00 02 00 24 07 |..2.....|......$.|
|00000bb0| 00 00 fc 00 e6 01 15 00 | 9d 00 11 00 0d 00 8d 00 |........|........|
|00000bc0| 00 00 fc 00 f6 01 15 00 | bb 00 0e 00 0d 00 ae 00 |........|........|
|00000bd0| 00 00 e4 00 0c 00 5a 00 | 00 00 00 00 98 00 00 00 |......Z.|........|
|00000be0| 00 00 98 00 2e 00 20 44 | 65 66 69 6e 65 20 74 68 |...... D|efine th|
|00000bf0| 65 20 6e 65 77 20 6c 69 | 6e 65 20 63 68 61 72 61 |e new li|ne chara|
|00000c00| 63 74 65 72 20 61 6e 64 | 20 74 68 65 20 74 61 62 |cter and| the tab|
|00000c10| 20 6b 65 79 00 00 98 00 | 26 00 20 47 65 74 20 74 | key....|&. Get t|
|00000c20| 68 65 20 63 6f 6d 6d 61 | 6e 64 20 66 72 6f 6d 20 |he comma|nd from |
|00000c30| 74 68 65 20 51 55 45 52 | 59 5f 46 49 45 4c 44 2e |the QUER|Y_FIELD.|
|00000c40| 00 00 98 00 3c 00 20 46 | 69 6c 6c 20 74 68 65 20 |....<. F|ill the |
|00000c50| 63 6f 6d 6d 61 6e 64 20 | 62 75 66 66 65 72 2e 20 |command |buffer. |
|00000c60| 49 66 20 66 61 69 6c 2c | 20 74 68 65 6e 20 65 78 |If fail,| then ex|
|00000c70| 69 74 20 74 68 65 20 73 | 75 62 72 6f 75 74 69 6e |it the s|ubroutin|
|00000c80| 65 2e 00 00 98 00 14 00 | 20 45 78 65 63 75 74 65 |e.......| Execute|
|00000c90| 20 74 68 65 20 63 6f 6d | 6d 61 6e 64 00 00 98 00 | the com|mand....|
|00000ca0| 00 00 00 00 00 00 e5 00 | 0d 00 ac 00 e4 28 ac 00 |........|.....(..|
|00000cb0| a3 00 0c 18 c9 00 00 00 | e4 24 ac 00 0c 18 cf 00 |........|.$......|
|00000cc0| 00 00 00 00 0b 18 d9 00 | ed 00 04 00 f6 02 00 00 |........|........|
|00000cd0| f1 00 49 00 1e 03 00 10 | 0b 18 d9 00 0e 00 01 00 |..I.....|........|
|00000ce0| 48 03 0b 04 0c 01 a6 00 | 45 00 1a 03 3d 00 38 11 |H.......|E...=.8.|
|00000cf0| 00 00 38 00 00 00 00 00 | e4 00 0c 04 ba 05 00 00 |..8.....|........|
|00000d00| 00 00 98 00 00 00 00 00 | 98 00 18 00 20 47 65 74 |........|.... Get|
|00000d10| 20 65 61 63 68 20 73 65 | 74 20 6f 66 20 72 65 73 | each se|t of res|
|00000d20| 75 6c 74 73 00 00 98 00 | 48 00 20 47 65 74 20 74 |ults....|H. Get t|
|00000d30| 68 65 20 6e 75 6d 62 65 | 72 20 6f 66 20 63 6f 6d |he numbe|r of com|
|00000d40| 70 75 74 65 20 63 6f 6c | 75 6d 6e 73 2c 20 6f 72 |pute col|umns, or|
|00000d50| 64 65 72 20 62 79 20 63 | 6f 6c 75 6d 6e 73 2c 20 |der by c|olumns, |
|00000d60| 61 6e 64 20 73 65 6c 65 | 63 74 20 63 6f 6c 75 6d |and sele|ct colum|
|00000d70| 6e 73 00 00 98 00 46 00 | 20 47 65 74 20 74 68 65 |ns....F.| Get the|
|00000d80| 20 65 78 61 63 74 20 70 | 6f 73 69 74 69 6f 6e 20 | exact p|osition |
|00000d90| 6f 66 20 65 61 63 68 20 | 63 6f 6c 75 6d 6e 20 28 |of each |column (|
|00000da0| 66 6f 72 20 6c 69 6e 69 | 6e 67 20 75 70 20 63 6f |for lini|ng up co|
|00000db0| 6d 70 75 74 65 20 63 6f | 6c 75 6d 6e 73 29 00 00 |mpute co|lumns)..|
|00000dc0| 98 00 00 00 00 00 00 00 | 0b 04 1f 01 0b 04 30 01 |........|......0.|
|00000dd0| a6 00 30 00 b2 0e 00 10 | 0b 04 01 01 0e 00 01 00 |..0.....|........|
|00000de0| 41 01 0c 04 1f 01 00 10 | 0b 04 1f 01 0b 04 30 01 |A.......|......0.|
|00000df0| a6 00 0b 04 1f 01 0b 00 | 0c 01 a6 00 f5 00 45 00 |........|......E.|
|00000e00| 36 04 3b 00 b2 0e 00 00 | 00 10 0b 04 01 01 0e 04 |6.;.....|........|
|00000e10| 01 00 5a 01 0c 04 4f 01 | 00 10 0b 04 01 01 0e 04 |..Z...O.|........|
|00000e20| 01 00 77 01 0c 04 6b 01 | 00 10 0b 04 01 01 0e 04 |..w...k.|........|
|00000e30| 01 00 91 01 0c 04 87 01 | 00 10 ed 00 04 00 82 04 |........|........|
|00000e40| 00 00 0c 18 9f 01 00 10 | ed 00 04 00 90 04 00 00 |........|........|
|00000e50| 0c 18 aa 01 00 00 00 00 | 98 00 00 00 00 00 98 00 |........|........|
|00000e60| 2f 00 20 47 65 74 20 74 | 68 65 20 63 6f 6c 75 6d |/. Get t|he colum|
|00000e70| 6e 20 6e 61 6d 65 20 61 | 6e 64 20 6c 65 6e 67 74 |n name a|nd lengt|
|00000e80| 68 20 66 6f 72 20 65 61 | 63 68 20 63 6f 6c 75 6d |h for ea|ch colum|
|00000e90| 6e 69 00 00 98 00 3c 00 | 20 46 6f 72 6d 61 74 20 |ni....<.| Format |
|00000ea0| 61 6e 64 20 6f 75 74 70 | 75 74 20 74 68 65 20 63 |and outp|ut the c|
|00000eb0| 6f 6c 75 6d 6e 20 68 65 | 61 64 69 6e 67 73 20 28 |olumn he|adings (|
|00000ec0| 6d 61 78 20 32 35 36 20 | 63 68 61 72 73 20 77 69 |max 256 |chars wi|
|00000ed0| 64 65 29 2e 00 00 98 00 | 00 00 00 00 00 10 0b 04 |de).....|........|
|00000ee0| b6 01 e4 04 0b 04 87 01 | 3e 00 ff ff dc 06 00 20 |........|>...... |
|00000ef0| 0b 04 01 01 0b 04 b6 01 | 0e 00 02 00 c6 01 0c 18 |........|........|
|00000f00| bb 01 00 20 0b 04 01 01 | 0b 04 b6 01 0e 00 02 00 |... ....|........|
|00000f10| 30 07 0b 04 b6 01 0f 00 | 01 00 24 07 00 20 0b 04 |0.......|..$.. ..|
|00000f20| 01 01 0b 04 b6 01 0e 00 | 02 00 d4 01 0b 04 b6 01 |........|........|
|00000f30| 0f 00 01 00 6f 00 00 20 | 0b 04 b6 01 0e 00 01 00 |....o.. |........|
|00000f40| 6f 00 0c 04 e1 01 00 20 | 0b 04 e1 01 e5 00 00 01 |o...... |........|
|00000f50| df 00 45 00 b6 05 e5 00 | 00 01 0c 04 e1 01 00 00 |..E.....|........|
|00000f60| 00 20 0b 18 bb 01 c2 00 | 06 05 0c 08 eb 01 00 20 |. ......|....... |
|00000f70| 0b 04 b6 01 e4 04 a6 00 | 49 00 e8 05 00 2c e4 04 |........|I....,..|
|00000f80| 0b 04 b6 01 0f 00 01 00 | 7d 00 00 20 32 00 0c 06 |........|}.. 2...|
|00000f90| 00 2c 0b 18 9f 01 c2 00 | 06 05 0b 18 cf 00 c2 00 |.,......|........|
|00000fa0| 06 05 a3 00 0b 04 b6 01 | 0f 00 01 00 7d 00 00 20 |........|....}.. |
|00000fb0| 38 00 00 24 00 20 0b 08 | eb 01 0b 04 e1 01 e3 00 |8..$. ..|........|
|00000fc0| 49 00 92 06 00 34 0b 18 | 9f 01 0b 18 bb 01 a3 00 |I....4..|........|
|00000fd0| 0b 04 e1 01 0b 08 eb 01 | f7 00 ee 00 e4 04 a3 00 |........|........|
|00000fe0| d3 00 a3 00 0b 18 cf 00 | a3 00 0c 18 9f 01 00 34 |........|.......4|
|00000ff0| 0b 18 aa 01 0b 18 bb 01 | c2 00 06 05 ed 00 05 00 |........|........|
|00001000| 62 06 01 00 5f 22 d6 00 | a3 00 0b 04 e1 01 0b 08 |b..._"..|........|
|00001010| eb 01 f7 00 ee 00 e4 04 | a3 00 d3 00 a3 00 0b 18 |........|........|
|00001020| cf 00 a3 00 0c 18 aa 01 | 00 20 32 00 d2 06 00 34 |........|. 2....4|
|00001030| 0b 18 9f 01 0b 18 bb 01 | a3 00 0b 18 cf 00 a3 00 |........|........|
|00001040| 0c 18 9f 01 00 34 0b 18 | aa 01 0b 18 bb 01 c2 00 |.....4..|........|
|00001050| 06 05 ed 00 05 00 bc 06 | 01 00 5f 22 d6 00 a3 00 |........|.._"....|
|00001060| 0b 18 cf 00 a3 00 0c 18 | aa 01 00 20 38 00 00 10 |........|... 8...|
|00001070| 0b 04 b6 01 4e 00 ff ff | 01 00 00 00 00 10 0b 18 |....N...|........|
|00001080| 9f 01 0b 04 ba 05 0f 00 | 01 00 99 05 00 10 0b 04 |........|........|
|00001090| ba 05 e4 04 a3 00 0c 04 | ba 05 00 10 0b 18 aa 01 |........|........|
|000010a0| 0b 04 ba 05 0f 00 01 00 | 99 05 00 10 0b 04 ba 05 |........|........|
|000010b0| e4 04 a3 00 0c 04 ba 05 | 00 10 ed 00 05 00 24 07 |........|......$.|
|000010c0| 01 00 20 22 0b 04 ba 05 | 0f 00 01 00 99 05 00 10 |.. "....|........|
|000010d0| 0b 04 ba 05 e4 04 a3 00 | 0c 04 ba 05 00 00 00 00 |........|........|
|000010e0| 98 00 00 00 00 00 98 00 | 3b 00 20 47 65 74 20 65 |........|;. Get e|
|000010f0| 61 63 68 20 72 6f 77 20 | 6f 66 20 64 61 74 61 2c |ach row |of data,|
|00001100| 20 61 6e 64 20 70 72 6f | 63 65 73 73 20 61 63 63 | and pro|cess acc|
|00001110| 6f 72 64 69 6e 67 20 74 | 6f 20 74 79 70 65 20 6f |ording t|o type o|
|00001120| 66 20 72 6f 77 2e 00 00 | 98 00 22 00 20 4f 75 74 |f row...|..". Out|
|00001130| 70 75 74 20 65 61 63 68 | 20 72 6f 77 20 69 6e 74 |put each| row int|
|00001140| 6f 20 74 68 65 20 6c 69 | 73 74 20 62 6f 78 00 00 |o the li|st box..|
|00001150| 98 00 00 00 00 00 00 10 | e5 00 63 00 0c 04 08 02 |........|..c.....|
|00001160| 00 10 0b 04 08 02 0b 04 | 16 02 a6 00 30 00 d6 0c |........|....0...|
|00001170| 00 20 ed 00 04 00 dc 07 | 00 00 0c 18 24 02 00 20 |. ......|....$.. |
|00001180| 0b 04 01 01 0e 00 01 00 | 39 02 0c 04 2f 02 00 20 |........|9.../.. |
|00001190| 0b 04 2f 02 0b 04 16 02 | a6 00 0b 04 2f 02 0b 00 |../.....|..../...|
|000011a0| 0c 01 a6 00 f5 00 45 00 | 18 08 3b 00 d6 0c 00 00 |......E.|..;.....|
|000011b0| 00 00 98 00 00 00 00 00 | 98 00 16 00 20 50 72 6f |........|.... Pro|
|000011c0| 63 65 73 73 20 61 20 43 | 4f 4d 50 55 54 45 20 52 |cess a C|OMPUTE R|
|000011d0| 6f 77 00 00 98 00 2e 00 | 20 47 65 74 20 74 68 65 |ow......| Get the|
|000011e0| 20 6e 75 6d 62 65 72 20 | 6f 66 20 63 6f 6c 75 6d | number |of colum|
|000011f0| 6e 73 20 69 6e 20 74 68 | 65 20 63 6f 6d 70 75 74 |ns in th|e comput|
|00001200| 65 20 72 6f 77 2e 00 00 | 98 00 32 00 20 44 65 74 |e row...|..2. Det|
|00001210| 65 72 6d 69 6e 65 20 77 | 68 61 74 20 74 79 70 65 |ermine w|hat type|
|00001220| 20 6f 66 20 61 67 67 72 | 65 67 61 74 65 20 65 61 | of aggr|egate ea|
|00001230| 63 68 20 63 6f 6c 75 6d | 6e 20 75 73 65 73 00 00 |ch colum|n uses..|
|00001240| 98 00 2b 00 20 4c 69 6e | 65 20 75 70 20 74 68 65 |..+. Lin|e up the|
|00001250| 20 63 6f 6c 75 6d 6e 20 | 69 6e 20 74 68 65 20 63 | column |in the c|
|00001260| 6f 72 72 65 63 74 20 70 | 6f 73 69 74 69 6f 6e 6d |orrect p|ositionm|
|00001270| 00 00 98 00 10 00 20 4f | 75 74 70 75 74 20 74 68 |...... O|utput th|
|00001280| 65 20 72 6f 77 2e 00 00 | 98 00 00 00 00 00 00 20 |e row...|....... |
|00001290| 0b 04 2f 02 0b 00 47 02 | f1 00 49 00 58 0a 00 30 |../...G.|..I.X..0|
|000012a0| 0b 04 01 01 0b 04 2f 02 | 0e 04 02 00 5c 02 0c 04 |....../.|....\...|
|000012b0| 51 02 00 30 0b 04 b6 01 | e4 04 0b 04 51 02 3e 00 |Q..0....|....Q.>.|
|000012c0| ff ff 50 0a 00 40 0b 04 | 01 01 0b 04 2f 02 0b 04 |..P..@..|..../...|
|000012d0| b6 01 0e 04 03 00 74 02 | 0c 04 6a 02 00 40 0b 04 |......t.|..j..@..|
|000012e0| 01 01 0b 04 2f 02 0b 04 | b6 01 0e 00 03 00 9d 02 |..../...|........|
|000012f0| 0e 00 01 00 90 02 0c 18 | 83 02 00 40 0b 04 01 01 |........|...@....|
|00001300| 0b 04 2f 02 0b 04 b6 01 | 0e 18 03 00 b5 02 dd 00 |../.....|........|
|00001310| 0c 00 a9 02 00 00 00 40 | 0b 04 6a 02 0e 00 01 00 |.......@|..j.....|
|00001320| 7d 00 d3 00 0b 18 83 02 | a3 00 0c 18 24 02 00 40 |}.......|....$..@|
|00001330| 0b 18 24 02 0b 04 ba 05 | 0f 00 01 00 99 05 00 40 |..$.....|.......@|
|00001340| 0b 04 6a 02 0e 00 01 00 | 7d 00 d3 00 0b 18 83 02 |..j.....|}.......|
|00001350| c2 00 06 05 ed 00 05 00 | 01 00 01 00 2d 22 d6 00 |........|....-"..|
|00001360| a3 00 0c 18 24 02 00 40 | 0b 18 24 02 0b 04 ba 05 |....$..@|..$.....|
|00001370| 0f 00 01 00 99 05 00 40 | 0b 04 6a 02 0e 00 01 00 |.......@|..j.....|
|00001380| 7d 00 d3 00 0b 00 a9 02 | d5 00 c0 00 a3 00 0c 18 |}.......|........|
|00001390| 24 02 00 40 0b 18 24 02 | 0b 04 ba 05 0f 00 01 00 |$..@..$.|........|
|000013a0| 99 05 00 40 ed 00 05 00 | 01 00 01 00 20 22 0b 04 |...@....|.... "..|
|000013b0| ba 05 0f 00 01 00 99 05 | 00 30 0b 04 b6 01 4e 00 |........|.0....N.|
|000013c0| ff ff 01 00 00 20 32 00 | c0 0c 00 00 00 00 98 00 |..... 2.|........|
|000013d0| 00 00 00 00 98 00 17 00 | 20 50 72 6f 63 65 73 73 |........| Process|
|000013e0| 20 61 20 72 65 67 75 6c | 61 72 20 72 6f 77 2e 00 | a regul|ar row..|
|000013f0| 00 00 98 00 21 00 20 47 | 65 74 20 74 68 65 20 63 |....!. G|et the c|
|00001400| 6f 6c 75 6d 6e 20 76 61 | 6c 75 65 20 61 6e 64 20 |olumn va|lue and |
|00001410| 6c 65 6e 67 74 68 2e 02 | 00 00 98 00 42 00 20 49 |length..|....B. I|
|00001420| 66 20 69 74 20 69 73 20 | 61 20 54 65 78 74 20 63 |f it is |a Text c|
|00001430| 6f 6c 75 6d 6e 2c 20 74 | 68 65 6e 20 63 68 61 6e |olumn, t|hen chan|
|00001440| 67 65 20 74 68 65 20 4c | 46 20 74 6f 20 43 52 4c |ge the L|F to CRL|
|00001450| 46 20 69 66 20 74 68 65 | 79 20 65 78 69 73 74 20 |F if the|y exist |
|00001460| 00 00 98 00 2a 00 20 54 | 72 79 20 74 6f 20 74 61 |....*. T|ry to ta|
|00001470| 62 20 65 76 65 6e 20 77 | 69 74 68 20 74 68 65 20 |b even w|ith the |
|00001480| 63 6f 6c 75 6d 6e 20 68 | 65 61 64 69 6e 67 73 2e |column h|eadings.|
|00001490| 00 00 98 00 00 00 00 00 | 00 30 0b 04 b6 01 e4 04 |........|.0......|
|000014a0| 0b 04 87 01 3e 00 ff ff | aa 0c 00 40 0b 04 01 01 |....>...|...@....|
|000014b0| 0b 04 b6 01 0e 00 02 00 | cd 02 0c 18 c1 02 00 40 |........|.......@|
|000014c0| 0b 18 c1 02 c2 00 06 05 | 0c 08 eb 01 00 40 0b 04 |........|.....@..|
|000014d0| b6 01 0e 00 01 00 6f 00 | 0c 04 e1 01 00 40 0b 04 |......o.|.....@..|
|000014e0| e1 01 e5 00 00 01 df 00 | 45 00 8a 0b e5 00 00 01 |........|E.......|
|000014f0| 0c 04 e1 01 00 40 00 40 | 0b 04 b6 01 0e 00 01 00 |.....@.@|........|
|00001500| 24 07 0b 04 3e 07 a6 00 | 0b 04 b6 01 0e 00 01 00 |$...>...|........|
|00001510| 24 07 0b 00 d3 07 a6 00 | f5 00 49 00 c4 0b 00 4c |$.......|..I....L|
|00001520| 0b 18 c1 02 24 00 01 00 | 8a 06 00 40 38 00 00 00 |....$...|...@8...|
|00001530| 00 40 0b 08 eb 01 0b 04 | e1 01 e3 00 49 00 4e 0c |.@......|....I.N.|
|00001540| 00 50 0b 04 b6 01 0b 04 | 87 01 f1 00 49 00 1c 0c |.P......|....I...|
|00001550| 00 60 0b 18 24 02 0b 18 | c1 02 a3 00 0b 04 e1 01 |.`..$...|........|
|00001560| 0b 08 eb 01 f7 00 ee 00 | e4 04 a3 00 d3 00 a3 00 |........|........|
|00001570| 0b 18 cf 00 a3 00 0c 18 | 24 02 00 50 32 00 48 0c |........|$..P2.H.|
|00001580| 00 60 0b 18 24 02 0b 18 | c1 02 a3 00 0b 04 e1 01 |.`..$...|........|
|00001590| 0b 08 eb 01 f7 00 ee 00 | e4 04 a3 00 d3 00 a3 00 |........|........|
|000015a0| 0c 18 24 02 00 50 38 00 | 00 40 32 00 92 0c 00 50 |..$..P8.|.@2....P|
|000015b0| 0b 04 b6 01 0b 04 87 01 | f1 00 49 00 7a 0c 00 60 |........|..I.z..`|
|000015c0| 0b 18 24 02 0b 18 c1 02 | a3 00 0b 18 cf 00 a3 00 |..$.....|........|
|000015d0| 0c 18 24 02 00 50 32 00 | 8e 0c 00 60 0b 18 24 02 |..$..P2.|...`..$.|
|000015e0| 0b 18 c1 02 a3 00 0c 18 | 24 02 00 50 38 00 00 40 |........|$..P8..@|
|000015f0| 38 00 00 40 ed 00 04 00 | ca 0c 00 00 0c 18 c1 02 |8..@....|........|
|00001600| 00 30 0b 04 b6 01 4e 00 | ff ff 01 00 00 30 0b 18 |.0....N.|.....0..|
|00001610| 24 02 0b 04 ba 05 0f 00 | 01 00 99 05 00 20 38 00 |$.......|..... 8.|
|00001620| 00 20 0b 04 ba 05 e4 04 | a3 00 0c 04 ba 05 00 00 |. ......|........|
|00001630| 00 10 4a 00 c6 07 76 00 | 11 00 10 00 45 6e 64 20 |..J...v.|....End |
|00001640| 6f 66 20 72 6f 77 20 6c | 6f 6f 70 6f 00 00 00 00 |of row l|oopo....|
|00001650| 98 00 00 00 00 00 98 00 | 31 00 20 4f 75 74 70 75 |........|1. Outpu|
|00001660| 74 20 74 68 65 20 6e 75 | 6d 62 65 72 20 6f 66 20 |t the nu|mber of |
|00001670| 72 6f 77 73 20 61 66 66 | 65 63 74 65 64 20 62 79 |rows aff|ected by|
|00001680| 20 74 68 65 20 71 75 65 | 72 79 2e 73 00 00 98 00 | the que|ry.s....|
|00001690| 26 00 20 4f 75 74 70 75 | 74 20 74 68 65 20 73 6f |&. Outpu|t the so|
|000016a0| 72 74 20 6f 72 64 65 72 | 20 28 69 66 20 61 70 70 |rt order| (if app|
|000016b0| 6c 69 63 61 62 6c 65 29 | 00 00 98 00 00 00 00 00 |licable)|........|
|000016c0| 00 10 0b 04 01 01 0e 00 | 01 00 ef 02 0c 08 e5 02 |........|........|
|000016d0| 00 10 ed 00 05 00 ae 0d | 01 00 28 22 0b 08 e5 02 |........|..("....|
|000016e0| d5 00 a3 00 ed 00 13 00 | c0 0d 0f 00 20 72 6f 77 |........|.... row|
|000016f0| 73 20 61 66 66 65 63 74 | 65 64 29 22 a3 00 0c 18 |s affect|ed)"....|
|00001700| 24 02 00 10 ed 00 05 00 | e0 0d 01 00 20 22 0b 04 |$.......|.... "..|
|00001710| ba 05 0f 00 01 00 99 05 | 00 10 0b 18 24 02 0b 04 |........|....$...|
|00001720| ba 05 e4 04 a3 00 0f 00 | 01 00 99 05 00 10 0b 04 |........|........|
|00001730| ba 05 e4 08 a3 00 0c 04 | ba 05 00 00 00 10 0b 04 |........|........|
|00001740| 6b 01 e4 00 df 00 49 00 | aa 0e 00 20 ed 00 05 00 |k.....I.|... ....|
|00001750| 3a 0d 01 00 20 22 0b 04 | ba 05 0f 00 01 00 99 05 |:... "..|........|
|00001760| 00 20 ed 00 10 00 50 0d | 0c 00 53 6f 72 74 20 4f |. ....P.|..Sort O|
|00001770| 72 64 65 72 3a 20 0c 18 | 24 02 00 20 0b 04 fb 02 |rder: ..|$.. ....|
|00001780| e4 04 0b 04 6b 01 3e 00 | ff ff 82 0e 00 30 0b 04 |....k.>.|.....0..|
|00001790| 01 01 0b 04 01 01 0b 04 | fb 02 0e 00 02 00 0c 03 |........|........|
|000017a0| 0e 00 02 00 c6 01 0c 18 | 00 03 00 30 0b 18 24 02 |........|...0..$.|
|000017b0| ed 00 05 00 aa 0d 01 00 | 20 22 a3 00 0b 18 00 03 |........| "......|
|000017c0| a3 00 0c 18 24 02 00 20 | 0b 04 fb 02 4e 00 ff ff |....$.. |....N...|
|000017d0| 01 00 00 20 0b 18 24 02 | 0b 04 ba 05 e4 04 a3 00 |... ..$.|........|
|000017e0| 0f 00 01 00 99 05 00 20 | 0b 04 ba 05 e4 08 a3 00 |....... |........|
|000017f0| 0c 04 ba 05 00 10 38 00 | 00 00 00 00 4a 00 f2 03 |......8.|....J...|
|00001800| 76 00 14 00 0c 00 45 6e | 64 20 6f 66 20 72 65 73 |v.....En|d of res|
|00001810| 75 6c 74 20 6c 6f 6f 70 | 00 00 00 00 98 00 00 00 |ult loop|........|
|00001820| 00 00 98 00 3f 00 20 53 | 65 65 20 69 66 20 74 68 |....?. S|ee if th|
|00001830| 65 72 65 20 61 72 65 20 | 61 6e 79 20 72 65 74 75 |ere are |any retu|
|00001840| 72 6e 20 70 61 72 61 6d | 65 74 65 72 73 20 66 72 |rn param|eters fr|
|00001850| 6f 6d 20 61 20 73 74 6f | 72 65 64 20 70 72 6f 63 |om a sto|red proc|
|00001860| 65 64 75 72 65 58 00 00 | 98 00 25 00 20 54 68 65 |edureX..|..%. The|
|00001870| 6e 20 53 65 65 20 69 66 | 20 74 68 65 72 65 20 69 |n See if| there i|
|00001880| 73 20 61 20 72 65 74 75 | 72 6e 20 73 74 61 74 75 |s a retu|rn statu|
|00001890| 73 72 00 00 98 00 00 00 | 00 00 00 10 0b 04 01 01 |sr......|........|
|000018a0| 0e 00 01 00 49 07 0c 04 | 57 07 00 10 0b 04 57 07 |....I...|W.....W.|
|000018b0| e4 00 f1 00 49 00 a6 10 | 00 20 ed 00 05 00 d4 0e |....I...|. ......|
|000018c0| 01 00 20 22 0b 04 ba 05 | 0f 00 01 00 99 05 00 20 |.. "....|....... |
|000018d0| 0b 04 ba 05 e4 04 a3 00 | 0c 04 ba 05 00 20 0b 04 |........|..... ..|
|000018e0| f4 05 e4 04 0b 04 57 07 | 3e 00 ff ff a0 10 00 30 |......W.|>......0|
|000018f0| ed 00 0a 00 0a 0f 06 00 | 4e 41 4d 45 3a 20 0b 04 |........|NAME: ..|
|00001900| 01 01 0b 04 f4 05 0e 00 | 02 00 62 07 a3 00 0c 18 |........|..b.....|
|00001910| 24 02 00 30 0b 18 24 02 | ed 00 0c 00 38 0f 08 00 |$..0..$.|....8...|
|00001920| 20 20 54 59 50 45 3a 20 | a3 00 0b 04 01 01 0b 04 |  TYPE: |........|
|00001930| f4 05 0e 00 02 00 70 07 | 0e 00 01 00 90 02 a3 00 |......p.|........|
|00001940| 0c 18 24 02 00 30 0b 18 | 24 02 ed 00 0e 00 76 0f |..$..0..|$.....v.|
|00001950| 0a 00 20 20 4c 45 4e 47 | 54 48 3a 20 a3 00 0b 04 |..  LENG|TH: ....|
|00001960| 01 01 0b 04 f4 05 0e 00 | 02 00 7e 07 d5 00 a3 00 |........|..~.....|
|00001970| 0c 18 24 02 00 30 0b 18 | 24 02 ed 00 0d 00 ac 0f |..$..0..|$.......|
|00001980| 09 00 20 20 56 41 4c 55 | 45 3a 20 22 a3 00 0b 04 |..  VALU|E: "....|
|00001990| 01 01 0b 04 f4 05 0e 00 | 02 00 8b 07 a3 00 0c 18 |........|........|
|000019a0| 24 02 00 30 0b 18 24 02 | 0b 04 ba 05 0f 00 01 00 |$..0..$.|........|
|000019b0| 99 05 00 30 0b 04 ba 05 | e4 04 a3 00 0c 04 ba 05 |...0....|........|
|000019c0| 00 20 0b 04 f4 05 4e 00 | ff ff 01 00 00 10 38 00 |. ....N.|......8.|
|000019d0| 00 00 00 10 0b 04 01 01 | 0e 00 01 00 aa 07 0b 00 |........|........|
|000019e0| bb 07 a6 00 ee 00 49 00 | 28 11 00 20 ed 00 05 00 |......I.|(.. ....|
|000019f0| 00 11 01 00 20 22 0b 04 | ba 05 0f 00 01 00 99 05 |.... "..|........|
|00001a00| 00 20 0b 04 ba 05 e4 04 | a3 00 0c 04 ba 05 00 20 |. ......|....... |
|00001a10| ed 00 13 00 24 11 0f 00 | 52 45 54 55 52 4e 20 53 |....$...|RETURN S|
|00001a20| 54 41 54 55 53 3a 20 22 | 0b 04 01 01 0e 00 01 00 |TATUS: "|........|
|00001a30| c3 07 d5 00 a3 00 0b 04 | ba 05 0f 00 01 00 99 05 |........|........|
|00001a40| 00 10 38 00 00 10 0b 04 | ba 05 0c 00 5a 00 00 00 |..8.....|....Z...|
|00001a50| 00 00 39 00 09 00 08 00 | ff ff ff ff ff ff ff ff |..9.....|........|
|00001a60| d3 00 00 00 03 00 00 0f | 00 45 78 69 74 41 70 70 |........|.ExitApp|
|00001a70| 6c 69 63 61 74 69 6f 6e | 01 08 30 6a 00 6c 00 18 |lication|..0j.l..|
|00001a80| 00 00 00 58 00 06 00 35 | 03 00 01 00 00 00 00 00 |...X...5|........|
|00001a90| 00 98 00 00 00 00 00 98 | 00 25 00 20 45 78 69 74 |........|.%. Exit|
|00001aa0| 20 53 51 4c 2c 20 74 68 | 65 6e 20 65 78 69 74 20 | SQL, th|en exit |
|00001ab0| 74 68 65 20 61 70 70 6c | 69 63 61 74 69 6f 6e 2e |the appl|ication.|
|00001ac0| 20 00 00 98 00 00 00 00 | 00 00 0c 24 00 00 00 7f | .......|...$....|
|00001ad0| 06 00 0c 24 00 00 00 27 | 03 00 0c 37 00 00 00 00 |...$...'|...7....|
|00001ae0| 00 39 00 09 00 08 00 ff | ff ff ff ff ff ff ff 0b |.9......|........|
|00001af0| 00 00 00 03 00 00 11 00 | 45 78 65 63 75 74 65 53 |........|ExecuteS|
|00001b00| 51 4c 43 6f 6d 6d 61 6e | 64 02 09 30 0a 01 10 01 |QLComman|d..0....|
|00001b10| 18 00 00 00 40 00 0e 00 | 48 03 c1 02 01 00 d9 00 |....@...|H.......|
|00001b20| 00 80 06 00 00 00 00 00 | 00 00 98 00 00 00 00 00 |........|........|
|00001b30| 98 00 3b 00 20 54 68 69 | 73 20 72 6f 75 74 69 6e |..;. Thi|s routin|
|00001b40| 65 20 65 78 65 63 75 74 | 65 73 20 61 20 63 6f 6d |e execut|es a com|
|00001b50| 6d 61 6e 64 28 73 29 20 | 61 6e 64 20 72 65 74 75 |mand(s) |and retu|
|00001b60| 72 6e 73 20 77 68 65 74 | 68 65 72 20 74 68 65 72 |rns whet|her ther|
|00001b70| 00 00 98 00 1d 00 20 65 | 78 65 63 75 74 65 20 73 |...... e|xecute s|
|00001b80| 75 63 63 65 65 64 65 64 | 20 6f 72 20 66 61 69 6c |ucceeded| or fail|
|00001b90| 65 64 2e 69 00 00 98 00 | 00 00 00 00 00 00 0b 00 |ed.i....|........|
|00001ba0| 5d 03 0c 04 e0 04 00 00 | 0b 00 5d 03 0c 00 48 03 |].......|..]...H.|
|00001bb0| 00 00 0b 04 01 01 0b 18 | d9 00 0e 00 02 00 f7 00 |........|........|
|00001bc0| 0b 04 0c 01 a6 00 49 00 | da 00 00 10 0b 00 0c 01 |......I.|........|
|00001bd0| 0c 04 e0 04 00 10 0b 00 | 0c 01 0c 00 48 03 00 00 |........|....H...|
|00001be0| 38 00 00 00 0b 04 01 01 | 0e 00 01 00 14 01 0b 04 |8.......|........|
|00001bf0| 0c 01 a6 00 49 00 0e 01 | 00 10 0b 00 0c 01 0c 04 |....I...|........|
|00001c00| e0 04 00 10 0b 00 0c 01 | 0c 00 48 03 00 00 38 00 |........|..H...8.|
|00001c10| 00 00 39 00 09 00 08 00 | ff ff ff ff ff ff ff ff |..9.....|........|
|00001c20| 12 00 00 00 03 00 00 1a | 00 43 68 61 6e 67 65 50 |........|.ChangeP|
|00001c30| 72 69 6d 61 72 79 57 69 | 6e 64 6f 77 43 61 70 74 |rimaryWi|ndowCapt|
|00001c40| 69 6f 6e 01 08 30 4c 00 | 48 00 18 00 00 00 58 00 |ion..0L.|H.....X.|
|00001c50| 06 00 68 03 00 01 00 00 | 00 20 0b 00 a2 03 ed 00 |..h.....|. ......|
|00001c60| 07 00 1c 00 03 00 20 2d | 20 22 a3 00 0b 18 d8 03 |...... -| "......|
|00001c70| a3 00 ed 00 05 00 30 00 | 01 00 2f 22 a3 00 0b 18 |......0.|../"....|
|00001c80| 6f 06 a3 00 0b 00 86 03 | 12 00 97 03 00 00 39 00 |o.......|......9.|
|00001c90| 09 00 08 00 ff ff ff ff | ff ff ff ff 03 00 00 00 |........|........|
|00001ca0| 03 00 00 0f 00 44 69 73 | 70 6c 61 79 53 51 4c 45 |.....Dis|playSQLE|
|00001cb0| 72 72 6f 72 01 08 30 ec | 00 ee 00 18 00 00 00 58 |rror..0.|.......X|
|00001cc0| 00 16 00 23 04 00 01 02 | 00 0e 04 00 80 02 00 00 |...#....|........|
|00001cd0| 00 18 04 00 80 06 00 00 | 00 00 00 00 00 98 00 00 |........|........|
|00001ce0| 00 00 00 98 00 50 00 20 | 4f 6e 6c 79 20 64 69 73 |.....P. |Only dis|
|00001cf0| 70 6c 61 79 20 74 68 65 | 20 6d 65 73 73 61 67 65 |play the| message|
|00001d00| 20 69 66 20 69 74 27 73 | 20 6e 6f 74 20 61 20 67 | if it's| not a g|
|00001d10| 65 6e 65 72 61 6c 20 6d | 73 67 20 6f 72 20 61 20 |eneral m|sg or a |
|00001d20| 63 68 61 6e 67 65 20 6c | 61 6e 67 75 61 67 65 20 |change l|anguage |
|00001d30| 6d 65 73 73 61 67 65 00 | 00 98 00 00 00 00 00 00 |message.|........|
|00001d40| 10 0b 00 0e 04 e5 00 45 | 16 f1 00 0b 00 0e 04 e5 |.......E|........|
|00001d50| 00 47 16 f1 00 a4 00 49 | 00 ec 00 00 20 ed 00 16 |.G.....I|.... ...|
|00001d60| 00 b2 00 12 00 53 51 4c | 20 53 65 72 76 65 72 20 |.....SQL| Server |
|00001d70| 45 72 72 6f 72 3a 20 0b | 00 0e 04 d5 00 a3 00 ed |Error: .|........|
|00001d80| 00 05 00 d4 00 01 00 20 | 22 a3 00 0b 00 18 04 a3 |....... |".......|
|00001d90| 00 1b 01 01 00 06 00 78 | 00 00 10 38 00 00 00 39 |.......x|...8...9|
|00001da0| 00 09 00 08 00 ff ff ff | ff ff ff ff ff 0a 00 00 |........|........|
|00001db0| 00 03 00 00 11 00 44 69 | 73 70 6c 61 79 44 42 4c |......Di|splayDBL|
|00001dc0| 49 42 45 72 72 6f 72 01 | 08 30 de 00 dc 00 18 00 |IBError.|.0......|
|00001dd0| 00 00 58 00 16 00 36 04 | 00 01 02 00 0e 04 00 80 |..X...6.|........|
|00001de0| 01 00 00 00 18 04 00 80 | 06 00 00 00 00 10 00 00 |........|........|
|00001df0| 98 00 00 00 00 00 98 00 | 4c 00 20 4f 6e 6c 79 20 |........|L. Only |
|00001e00| 64 69 73 70 6c 61 79 20 | 6d 65 73 73 61 67 65 20 |display |message |
|00001e10| 69 66 20 69 74 27 73 20 | 6e 6f 74 20 61 20 6e 6f |if it's |not a no|
|00001e20| 74 69 66 69 63 61 74 69 | 6f 6e 20 74 68 61 74 20 |tificati|on that |
|00001e30| 74 68 65 72 65 27 73 20 | 61 20 73 65 72 76 65 72 |there's |a server|
|00001e40| 20 65 72 72 6f 72 00 00 | 98 00 00 00 00 00 00 10 | error..|........|
|00001e50| 0b 00 0e 04 e5 00 17 27 | f1 00 49 00 d8 00 00 20 |.......'|..I.... |
|00001e60| ed 00 15 00 9e 00 11 00 | 44 42 4c 69 62 72 61 72 |........|DBLibrar|
|00001e70| 79 20 45 72 72 6f 72 3a | 20 22 0b 00 0e 04 d5 00 |y Error:| "......|
|00001e80| a3 00 ed 00 05 00 c0 00 | 01 00 20 22 a3 00 0b 00 |........|.. "....|
|00001e90| 18 04 a3 00 1b 01 01 00 | 06 00 78 00 00 10 38 00 |........|..x...8.|
|00001ea0| 00 00 00 00 39 00 09 00 | 08 00 ff ff ff ff ff ff |....9...|........|
|00001eb0| ff ff 0b 00 00 00 03 00 | 00 15 00 49 6e 69 74 69 |........|...Initi|
|00001ec0| 61 6c 69 7a 65 41 70 70 | 6c 69 63 61 74 69 6f 6e |alizeApp|lication|
|00001ed0| 01 08 30 68 00 68 00 18 | 00 00 00 58 00 06 00 4b |..0h.h..|...X...K|
|00001ee0| 04 00 01 00 00 00 00 00 | 00 98 00 00 00 00 00 98 |........|........|
|00001ef0| 00 28 00 20 49 6e 69 74 | 69 61 6c 69 7a 65 20 74 |.(. Init|ialize t|
|00001f00| 68 65 20 63 6f 6e 6e 65 | 63 74 69 6f 6e 20 74 6f |he conne|ction to|
|00001f10| 20 53 51 4c 20 53 65 72 | 76 65 72 00 00 98 00 00 | SQL Ser|ver.....|
|00001f20| 00 00 10 e4 00 0c 04 01 | 01 00 10 0e 18 00 00 87 |........|........|
|00001f30| 04 0c 18 d4 05 00 00 39 | 00 09 00 08 00 ff ff ff |.......9|........|
|00001f40| ff ff ff ff ff 08 00 00 | 00 03 00 00 15 00 43 68 |........|......Ch|
|00001f50| 65 63 6b 53 65 72 76 65 | 72 43 6f 6e 6e 65 63 74 |eckServe|rConnect|
|00001f60| 69 6f 6e 02 09 30 48 00 | 42 00 18 00 00 00 40 00 |ion..0H.|B.....@.|
|00001f70| 0e 00 92 04 c1 02 01 00 | 01 01 00 80 01 00 00 00 |........|........|
|00001f80| 00 10 0b 04 01 01 e4 00 | f1 00 49 00 34 00 00 20 |........|..I.4.. |
|00001f90| e4 04 0c 00 92 04 00 10 | 32 00 40 00 00 20 e4 00 |........|2.@.. ..|
|00001fa0| 0c 00 92 04 00 10 38 00 | 00 00 39 00 09 00 08 00 |......8.|..9.....|
|00001fb0| ff ff ff ff ff ff ff ff | 07 00 00 00 03 00 00 0c |........|........|
|00001fc0| 00 4d 61 6b 65 52 75 6c | 65 4c 69 73 74 02 0e 30 |.MakeRul|eList..0|
|00001fd0| ea 00 ec 00 18 00 00 00 | 40 00 0e 00 ab 04 c6 02 |........|@.......|
|00001fe0| 01 00 bb 04 00 80 06 00 | 00 00 00 00 00 00 98 00 |........|........|
|00001ff0| 00 00 00 00 98 00 49 00 | 20 54 68 69 73 20 66 75 |......I.| This fu|
|00002000| 6e 63 74 69 6f 6e 73 20 | 74 61 6b 65 73 20 61 20 |nctions |takes a |
|00002010| 72 75 6c 65 20 6f 66 20 | 74 79 70 65 20 22 49 4e |rule of |type "IN|
|00002020| 22 20 66 72 6f 6d 20 73 | 70 5f 68 65 6c 70 74 65 |" from s|p_helpte|
|00002030| 78 74 20 61 6e 64 20 6d | 61 6b 65 73 20 69 74 20 |xt and m|akes it |
|00002040| 61 20 00 00 98 00 30 00 | 20 63 6f 6d 6d 61 20 64 |a ....0.| comma d|
|00002050| 65 6c 69 6d 69 74 65 64 | 20 6c 69 73 74 20 66 6f |elimited| list fo|
|00002060| 72 20 65 61 73 79 20 75 | 73 65 20 69 6e 20 6c 69 |r easy u|se in li|
|00002070| 73 74 20 62 6f 78 65 73 | 00 00 98 00 00 00 00 00 |st boxes|........|
|00002080| 00 00 e4 04 0b 18 bb 04 | ed 00 05 00 be 00 01 00 |........|........|
|00002090| 27 22 bb 00 0c 04 c6 04 | 00 00 0b 18 bb 04 0b 04 |'"......|........|
|000020a0| c6 04 0b 18 bb 04 c2 00 | 06 05 e4 08 f7 00 c7 00 |........|........|
|000020b0| 0c 00 ab 04 00 00 39 00 | 09 00 08 00 ff ff ff ff |......9.|........|
|000020c0| ff ff ff ff 0a 00 00 00 | 03 00 00 0e 00 57 61 72 |........|.....War|
|000020d0| 6e 69 6e 67 4d 65 73 73 | 61 67 65 02 0b 30 38 01 |ningMess|age..08.|
|000020e0| 3a 01 18 00 00 00 40 00 | 0e 00 ed 04 03 02 01 00 |:.....@.|........|
|000020f0| 10 05 00 80 06 00 00 00 | 00 00 00 00 98 00 00 00 |........|........|
|00002100| 00 00 98 00 41 00 20 54 | 68 69 73 20 72 6f 75 74 |....A. T|his rout|
|00002110| 69 6e 65 20 64 69 73 70 | 6c 61 79 73 20 61 20 77 |ine disp|lays a w|
|00002120| 61 72 6e 69 6e 67 20 6d | 65 73 73 61 67 65 20 77 |arning m|essage w|
|00002130| 69 74 68 20 61 20 59 45 | 53 20 61 6e 64 20 4e 4f |ith a YE|S and NO|
|00002140| 20 62 75 74 74 6f 6e 75 | 00 00 98 00 18 00 20 61 | buttonu|...... a|
|00002150| 6e 64 20 72 65 74 75 72 | 6e 73 20 74 68 65 20 72 |nd retur|ns the r|
|00002160| 65 73 75 6c 74 2e 00 00 | 98 00 00 00 00 00 00 00 |esult...|........|
|00002170| 1d 00 e4 10 0c 00 1a 05 | 00 00 1d 00 e5 00 30 00 |........|......0.|
|00002180| 0c 00 26 05 00 00 1d 00 | e4 18 0c 00 ff 04 00 00 |..&.....|........|
|00002190| 1d 00 e4 1c 0c 00 08 05 | 00 00 1d 00 e5 00 00 01 |........|........|
|000021a0| 0c 00 81 05 00 00 00 00 | 0b 00 1a 05 0b 00 5a 05 |........|......Z.|
|000021b0| a3 00 0b 00 70 05 a3 00 | 0c 04 51 05 00 00 0b 18 |....p...|..Q.....|
|000021c0| 10 05 0b 04 51 05 ed 00 | 12 00 f4 00 0e 00 53 79 |....Q...|......Sy|
|000021d0| 73 74 65 6d 20 57 61 72 | 6e 69 6e 67 1b 01 03 00 |stem War|ning....|
|000021e0| 05 c0 0c 04 3b 05 00 00 | 0b 04 3b 05 0b 00 08 05 |....;...|..;.....|
|000021f0| a6 00 49 00 2c 01 00 10 | e4 00 0c 00 ed 04 00 00 |..I.,...|........|
|00002200| 32 00 38 01 00 10 e4 04 | 0c 00 ed 04 00 00 38 00 |2.8.....|......8.|
|00002210| 00 00 39 00 09 00 08 00 | ff ff ff ff ff ff ff ff |..9.....|........|
|00002220| 15 00 00 00 03 00 00 06 | 00 4c 6f 67 6f 66 66 01 |........|.Logoff.|
|00002230| 08 30 76 00 74 00 18 00 | 00 00 58 00 06 00 8f 05 |.0v.t...|..X.....|
|00002240| 00 01 00 00 00 10 0b 04 | 01 01 e4 00 f1 00 49 00 |........|......I.|
|00002250| 72 00 00 20 0b 04 01 01 | ee 00 24 00 01 00 1b 03 |r.. ....|..$.....|
|00002260| 00 20 ed 00 0f 00 38 00 | 0b 00 5b 4e 6f 20 73 65 |. ....8.|..[No se|
|00002270| 72 76 65 72 5d 22 0c 18 | d8 03 00 20 ed 00 11 00 |rver]"..|... ....|
|00002280| 0d 00 0d 00 5b 6e 6f 20 | 64 61 74 61 62 61 73 65 |....[no |database|
|00002290| 5d 22 0c 18 6f 06 00 20 | 24 00 00 00 68 03 00 10 |]"..o.. |$...h...|
|000022a0| 38 00 00 00 39 00 09 00 | 08 00 ff ff ff ff ff ff |8...9...|........|
|000022b0| ff ff 08 00 00 00 03 00 | 00 09 00 50 61 72 73 65 |........|...Parse|
|000022c0| 52 75 6c 65 01 08 30 bc | 01 b8 01 18 00 00 00 58 |Rule..0.|.......X|
|000022d0| 00 0e 00 43 06 00 01 01 | 00 50 06 00 c0 06 00 00 |...C....|.P......|
|000022e0| 00 00 00 00 00 98 00 00 | 00 00 00 98 00 41 00 20 |........|.....A. |
|000022f0| 54 68 69 73 20 72 6f 75 | 74 69 6e 65 20 74 61 6b |This rou|tine tak|
|00002300| 65 73 20 74 68 65 20 63 | 6f 6d 6d 61 20 64 65 6c |es the c|omma del|
|00002310| 69 6d 65 74 65 64 20 72 | 75 6c 65 73 2c 77 68 69 |imeted r|ules,whi|
|00002320| 63 68 20 63 61 6d 65 20 | 66 72 6f 6d 20 74 68 65 |ch came |from the|
|00002330| 6d 00 00 98 00 41 00 20 | 4d 61 6b 65 52 75 6c 65 |m....A. |MakeRule|
|00002340| 4c 69 73 74 20 70 72 6f | 63 65 64 75 72 65 2c 20 |List pro|cedure, |
|00002350| 72 65 6d 6f 76 65 73 20 | 74 68 65 20 71 75 6f 74 |removes |the quot|
|00002360| 65 73 20 61 6e 64 20 73 | 74 6f 72 65 73 20 74 68 |es and s|tores th|
|00002370| 65 20 76 61 6c 75 65 73 | 6d 00 00 98 00 3c 00 20 |e values|m....<. |
|00002380| 69 6e 20 61 6e 20 61 72 | 72 61 79 2e 20 20 54 68 |in an ar|ray.  Th|
|00002390| 69 73 20 69 73 20 67 6f | 6f 64 20 66 6f 72 20 75 |is is go|od for u|
|000023a0| 73 65 20 69 6e 20 63 6f | 6d 62 6f 20 61 6e 64 20 |se in co|mbo and |
|000023b0| 6c 69 73 74 20 62 6f 78 | 65 73 2e 00 00 98 00 00 |list box|es......|
|000023c0| 00 00 00 00 00 e4 00 0e | 18 01 00 50 06 0c 18 19 |........|...P....|
|000023d0| 06 00 00 00 00 e4 04 0c | 04 c6 04 00 00 0b 04 f4 |........|........|
|000023e0| 05 e4 00 e5 00 64 00 3e | 00 ff ff b2 01 00 10 0b |.....d.>|........|
|000023f0| 04 c6 04 e4 04 a3 00 0b | 18 19 06 ed 00 05 00 3a |........|.......:|
|00002400| 01 01 00 27 22 bb 00 0c | 04 39 06 00 10 0b 18 19 |...'"...|.9......|
|00002410| 06 0b 04 c6 04 e4 04 a3 | 00 0b 04 39 06 0b 04 c6 |........|...9....|
|00002420| 04 f7 00 ee 00 e4 04 f7 | 00 c7 00 0b 04 f4 05 0f |........|........|
|00002430| 00 01 00 50 06 00 10 0b | 04 39 06 e4 04 a3 00 0b |...P....|.9......|
|00002440| 18 19 06 ed 00 05 00 8a | 01 01 00 27 22 bb 00 0c |........|...'"...|
|00002450| 04 c6 04 00 10 0b 04 c6 | 04 e4 00 a6 00 45 00 a8 |........|.....E..|
|00002460| 01 3c 00 b4 01 00 00 0b | 04 f4 05 4e 00 ff ff 01 |.<......|...N....|
|00002470| 00 00 00 00 00 39 00 00 | 00 00 00 00 00 00 00 00 |.....9..|........|
|00002480| 00 09 00 08 00 ff ff ff | ff ff ff ff ff 18 00 00 |........|........|
|00002490| 00 03 00 00 10 00 46 69 | 78 54 65 78 74 4c 69 6e |......Fi|xTextLin|
|000024a0| 65 46 65 65 64 73 01 08 | 30 f2 01 fe 01 18 00 00 |eFeeds..|0.......|
|000024b0| 00 58 00 0e 00 8a 06 00 | 01 01 00 9e 06 00 80 06 |.X......|........|
|000024c0| 00 00 00 00 00 00 00 98 | 00 00 00 00 00 98 00 3e |........|.......>|
|000024d0| 00 20 54 68 69 73 20 77 | 69 6c 6c 20 72 65 70 6c |. This w|ill repl|
|000024e0| 61 63 65 20 61 6c 6c 20 | 4c 46 20 63 68 61 72 61 |ace all |LF chara|
|000024f0| 63 74 65 72 73 20 69 6e | 20 74 68 65 20 49 6e 53 |cters in| the InS|
|00002500| 74 72 69 6e 67 20 77 69 | 74 68 20 43 52 4c 46 00 |tring wi|th CRLF.|
|00002510| 00 98 00 00 00 00 00 00 | 00 e5 00 0d 00 ac 00 e4 |........|........|
|00002520| 28 ac 00 a3 00 0c 18 bd | 06 00 00 e4 28 ac 00 0c |(.......|....(...|
|00002530| 18 aa 06 00 00 00 00 98 | 00 00 00 00 00 98 00 27 |........|.......'|
|00002540| 00 20 47 65 74 20 74 68 | 65 20 6c 65 6e 67 74 68 |. Get th|e length|
|00002550| 20 6f 66 20 74 68 65 20 | 73 74 72 69 6e 67 20 63 | of the |string c|
|00002560| 6f 6d 69 6e 67 20 69 6e | 6e 00 00 98 00 4a 00 20 |oming in|n....J. |
|00002570| 53 65 74 20 74 68 65 20 | 6c 65 6e 67 74 68 20 6f |Set the |length o|
|00002580| 66 20 54 6d 70 53 74 72 | 69 6e 67 20 74 6f 20 6c |f TmpStr|ing to l|
|00002590| 65 6e 67 74 68 20 6f 66 | 20 73 74 72 69 6e 67 20 |ength of| string |
|000025a0| 63 6f 6d 69 6e 67 20 69 | 6e 20 2b 20 31 30 30 20 |coming i|n + 100 |
|000025b0| 6e 65 77 20 63 68 61 72 | 73 00 00 98 00 00 00 00 |new char|s.......|
|000025c0| 00 00 00 0b 00 9e 06 c2 | 00 06 05 0c 04 fb 02 00 |........|........|
|000025d0| 00 0b 04 fb 02 e5 00 64 | 00 a3 00 d3 00 0c 18 b0 |.......d|........|
|000025e0| 06 00 00 e4 04 0c 04 f4 | 05 00 00 00 00 0b 04 b6 |........|........|
|000025f0| 01 e4 04 0b 04 fb 02 3e | 00 ff ff ec 01 00 00 00 |.......>|........|
|00002600| 10 0b 00 9e 06 0b 04 b6 | 01 e4 04 c7 00 0c 18 d5 |........|........|
|00002610| 06 00 10 0b 18 d5 06 0b | 18 aa 06 a6 00 49 00 a8 |........|.....I..|
|00002620| 01 00 20 0b 04 f4 05 e4 | 04 0b 18 bd 06 0b 18 b0 |.. .....|........|
|00002630| 06 8b 00 00 20 0b 04 f4 | 05 e4 04 a3 00 0c 04 f4 |.... ...|........|
|00002640| 05 00 10 32 00 d4 01 00 | 20 0b 00 9e 06 0b 04 b6 |...2....| .......|
|00002650| 01 e4 04 c7 00 0c 18 d5 | 06 00 20 0b 04 f4 05 0b |........|.. .....|
|00002660| 18 d5 06 0b 18 b0 06 8a | 00 00 10 38 00 00 10 0b |........|...8....|
|00002670| 04 f4 05 e4 04 a3 00 0c | 04 f4 05 00 00 0b 04 b6 |........|........|
|00002680| 01 4e 00 ff ff 01 00 00 | 00 00 00 0b 18 b0 06 cf |.N......|........|
|00002690| 00 0c 18 9e 06 00 00 39 | 00 09 00 08 00 ff ff ff |.......9|........|
|000026a0| ff ff ff ff ff 21 00 00 | 00 03 00 00 0c 00 44 6f |.....!..|......Do|
|000026b0| 75 62 6c 65 51 75 6f 74 | 65 73 01 08 30 66 02 62 |ubleQuot|es..0f.b|
|000026c0| 02 18 00 00 00 58 00 0e | 00 df 06 00 01 01 00 9e |.....X..|........|
|000026d0| 06 00 80 06 00 00 00 00 | 00 00 00 98 00 00 00 00 |........|........|
|000026e0| 00 98 00 2c 00 20 54 68 | 69 73 20 77 69 6c 6c 20 |...,. Th|is will |
|000026f0| 72 65 70 6c 61 63 65 20 | 61 6c 6c 20 64 6f 75 62 |replace |all doub|
|00002700| 6c 65 20 71 75 6f 74 65 | 73 20 77 69 74 68 20 22 |le quote|s with "|
|00002710| 22 00 00 98 00 1e 00 20 | 61 6e 64 20 61 6c 6c 20 |"...... |and all |
|00002720| 73 69 6e 67 6c 65 20 71 | 75 6f 74 65 73 20 77 69 |single q|uotes wi|
|00002730| 74 68 20 27 27 00 00 98 | 00 00 00 00 00 00 00 e5 |th ''...|........|
|00002740| 00 22 00 ac 00 e5 00 22 | 00 ac 00 a3 00 0c 18 15 |."....."|........|
|00002750| 07 00 00 e5 00 27 00 ac | 00 e5 00 27 00 ac 00 a3 |.....'..|...'....|
|00002760| 00 0c 18 71 09 00 00 18 | 01 a8 00 fb 00 07 00 01 |...q....|........|
|00002770| 00 0e 00 0d 00 d5 06 00 | 00 00 00 98 00 00 00 00 |........|........|
|00002780| 00 98 00 27 00 20 47 65 | 74 20 74 68 65 20 6c 65 |...'. Ge|t the le|
|00002790| 6e 67 74 68 20 6f 66 20 | 74 68 65 20 73 74 72 69 |ngth of |the stri|
|000027a0| 6e 67 20 63 6f 6d 69 6e | 67 20 69 6e 74 00 00 98 |ng comin|g int...|
|000027b0| 00 4a 00 20 53 65 74 20 | 74 68 65 20 6c 65 6e 67 |.J. Set |the leng|
|000027c0| 74 68 20 6f 66 20 54 6d | 70 53 74 72 69 6e 67 20 |th of Tm|pString |
|000027d0| 74 6f 20 6c 65 6e 67 74 | 68 20 6f 66 20 73 74 72 |to lengt|h of str|
|000027e0| 69 6e 67 20 63 6f 6d 69 | 6e 67 20 69 6e 20 2b 20 |ing comi|ng in + |
|000027f0| 31 30 30 20 6e 65 77 20 | 63 68 61 72 73 00 00 98 |100 new |chars...|
|00002800| 00 00 00 00 00 00 00 0b | 00 9e 06 c2 00 06 05 0c |........|........|
|00002810| 04 fb 02 00 00 0b 04 fb | 02 e5 00 64 00 a3 00 d3 |........|...d....|
|00002820| 00 0c 18 b0 06 00 00 e4 | 04 0c 04 f4 05 00 00 00 |........|........|
|00002830| 00 1f 00 0b 04 b6 01 e4 | 04 0b 04 fb 02 3e 00 ff |........|.....>..|
|00002840| ff 4c 02 00 00 00 10 0b | 00 9e 06 0b 04 b6 01 e4 |.L......|........|
|00002850| 04 c7 00 0c 18 d5 06 00 | 10 0b 18 d5 06 e5 00 22 |........|......."|
|00002860| 00 ac 00 a6 00 49 00 00 | 00 00 20 0b 04 f4 05 e4 |.....I..|.. .....|
|00002870| 08 0b 18 15 07 0b 18 b0 | 06 8b 00 00 20 0b 04 f4 |........|.... ...|
|00002880| 05 e4 04 a3 00 0c 04 f4 | 05 00 10 32 00 34 02 00 |........|...2.4..|
|00002890| 20 0b 18 d5 06 e5 00 27 | 00 ac 00 a6 00 49 00 00 | ......'|.....I..|
|000028a0| 00 00 30 0b 04 f4 05 e4 | 08 0b 18 71 09 0b 18 b0 |..0.....|...q....|
|000028b0| 06 8b 00 00 30 0b 04 f4 | 05 e4 04 a3 00 0c 04 f4 |....0...|........|
|000028c0| 05 00 20 32 00 30 02 00 | 30 0b 00 9e 06 0b 04 b6 |.. 2.0..|0.......|
|000028d0| 01 e4 04 c7 00 0c 18 d5 | 06 00 30 0b 04 f4 05 0b |........|..0.....|
|000028e0| 18 d5 06 0b 18 b0 06 8a | 00 00 20 38 00 00 10 38 |........|.. 8...8|
|000028f0| 00 00 10 0b 04 f4 05 e4 | 04 a3 00 0c 04 f4 05 00 |........|........|
|00002900| 00 0b 04 b6 01 4e 00 ff | ff 01 00 00 00 00 00 1f |.....N..|........|
|00002910| 00 0b 18 b0 06 cf 00 0c | 18 9e 06 00 00 00 00 39 |........|.......9|
|00002920| 00 09 00 08 00 ff ff ff | ff ff ff ff ff 29 00 00 |........|.....)..|
|00002930| 00 03 40 00 0c 00 47 65 | 74 44 61 74 61 62 61 73 |..@...Ge|tDatabas|
|00002940| 65 73 02 09 30 68 02 7e | 02 18 00 00 00 40 00 0e |es..0h.~|.....@..|
|00002950| 00 de 07 c1 02 01 00 06 | 08 00 80 08 00 02 00 00 |........|........|
|00002960| 00 00 00 98 00 00 00 00 | 00 98 00 43 00 20 54 68 |........|...C. Th|
|00002970| 69 73 20 72 6f 75 74 69 | 6e 65 20 67 65 74 73 20 |is routi|ne gets |
|00002980| 74 68 65 20 6e 61 6d 65 | 20 6f 66 20 61 6c 6c 20 |the name| of all |
|00002990| 74 68 65 20 64 61 74 61 | 62 61 73 65 73 20 6f 6e |the data|bases on|
|000029a0| 20 74 68 65 20 53 51 4c | 20 53 65 72 76 65 72 2e | the SQL| Server.|
|000029b0| 2e 00 00 98 00 52 00 20 | 46 69 6c 6c 20 65 61 63 |.....R. |Fill eac|
|000029c0| 68 20 65 6c 65 6d 65 6e | 74 20 69 6e 20 74 68 65 |h elemen|t in the|
|000029d0| 20 63 6f 6d 62 6f 62 6f | 78 20 6f 72 20 6c 69 73 | combobo|x or lis|
|000029e0| 74 20 62 6f 78 20 77 68 | 69 63 68 20 69 73 20 70 |t box wh|ich is p|
|000029f0| 61 73 73 65 64 20 69 6e | 74 6f 20 74 68 69 73 20 |assed in|to this |
|00002a00| 70 72 6f 63 65 64 75 72 | 65 00 00 98 00 44 00 20 |procedur|e....D. |
|00002a10| 65 78 65 63 75 74 65 20 | 74 68 65 20 63 6f 6d 6d |execute |the comm|
|00002a20| 61 6e 64 2e 20 20 47 65 | 74 20 65 61 63 68 20 64 |and.  Ge|t each d|
|00002a30| 61 74 61 62 61 73 65 20 | 6e 61 6d 65 20 61 6e 64 |atabase |name and|
|00002a40| 20 66 69 6c 6c 20 74 68 | 65 20 63 6f 6d 62 6f 62 | fill th|e combob|
|00002a50| 6f 78 2e 00 00 98 00 00 | 00 00 00 00 10 ed 00 29 |ox......|.......)|
|00002a60| 00 4e 01 25 00 53 65 6c | 65 63 74 20 6e 61 6d 65 |.N.%.Sel|ect name|
|00002a70| 20 66 72 6f 6d 20 6d 61 | 73 74 65 72 2e 2e 73 79 | from ma|ster..sy|
|00002a80| 73 64 61 74 61 62 61 73 | 65 73 22 0e 00 01 00 48 |sdatabas|es"....H|
|00002a90| 03 0b 04 0c 01 a6 00 49 | 00 74 01 00 20 0b 00 0c |.......I|.t.. ...|
|00002aa0| 01 0c 00 de 07 00 20 3d | 00 7e 02 00 10 32 00 de |...... =|.~...2..|
|00002ab0| 01 00 20 0b 04 01 01 0e | 00 01 00 41 01 0b 04 0c |.. .....|...A....|
|00002ac0| 01 a6 00 45 00 94 01 3d | 00 7e 02 00 20 0b 04 01 |...E...=|.~.. ...|
|00002ad0| 01 0e 00 01 00 39 02 0b | 04 16 02 f1 00 5a 00 da |.....9..|.....Z..|
|00002ae0| 01 00 30 0b 00 06 08 65 | 00 0b 04 01 01 e4 04 0e |..0....e|........|
|00002af0| 00 02 00 cd 02 f2 00 1c | 01 02 00 04 00 78 00 00 |........|.....x..|
|00002b00| 20 59 00 96 01 00 10 38 | 00 00 00 00 00 98 00 60 | Y.....8|.......`|
|00002b10| 00 20 49 66 20 74 68 69 | 73 20 69 73 20 61 20 63 |. If thi|s is a c|
|00002b20| 6f 6d 62 6f 62 6f 78 20 | 77 65 20 61 72 65 20 66 |ombobox |we are f|
|00002b30| 69 6c 6c 69 6e 67 2c 20 | 74 68 65 6e 20 64 69 73 |illing, |then dis|
|00002b40| 70 6c 61 79 20 74 68 65 | 20 66 69 72 73 74 20 64 |play the| first d|
|00002b50| 61 74 61 62 61 73 65 20 | 69 6e 20 74 68 65 20 6c |atabase |in the l|
|00002b60| 69 73 74 20 74 6f 20 73 | 74 61 72 74 20 77 69 74 |ist to s|tart wit|
|00002b70| 68 00 00 00 10 0b 00 06 | 08 f8 00 1a 08 49 00 70 |h.......|.....I.p|
|00002b80| 02 00 20 e4 00 0b 00 06 | 08 13 00 01 00 fe 07 0b |.. .....|........|
|00002b90| 00 06 08 12 00 ef 00 00 | 10 38 00 00 00 00 10 0b |........|.8......|
|00002ba0| 00 5d 03 0c 00 de 07 00 | 00 39 00 09 00 08 00 ff |.]......|.9......|
|00002bb0| ff ff ff ff ff ff ff 1a | 00 00 00 03 00 00 0d 00 |........|........|
|00002bc0| 4c 6f 67 69 6e 54 6f 53 | 65 72 76 65 72 02 09 30 |LoginToS|erver..0|
|00002bd0| 0c 02 22 02 18 00 00 00 | 40 00 06 00 09 09 c1 02 |..".....|@.......|
|00002be0| 00 00 00 00 00 00 0b 00 | 5d 03 0c 00 09 09 00 00 |........|].......|
|00002bf0| 00 00 98 00 00 00 00 00 | 98 00 3d 00 20 43 68 65 |........|..=. Che|
|00002c00| 63 6b 20 74 6f 20 73 65 | 65 20 69 66 20 74 68 65 |ck to se|e if the|
|00002c10| 20 63 6f 6e 6e 65 63 74 | 69 6f 6e 20 69 73 20 6c | connect|ion is l|
|00002c20| 69 76 65 2c 20 69 66 20 | 73 6f 2c 20 74 68 65 6e |ive, if |so, then|
|00002c30| 20 63 6c 6f 73 65 20 69 | 74 65 00 00 98 00 28 00 | close i|te....(.|
|00002c40| 20 53 65 74 20 74 68 65 | 20 6d 61 78 20 74 69 6d | Set the| max tim|
|00002c50| 65 20 74 6f 20 6c 6f 67 | 69 6e 20 74 6f 20 33 30 |e to log|in to 30|
|00002c60| 20 73 65 63 6f 6e 64 73 | 00 00 98 00 18 00 20 4f | seconds|...... O|
|00002c70| 70 65 6e 20 74 68 65 20 | 6e 65 77 20 63 6f 6e 6e |pen the |new conn|
|00002c80| 65 63 74 69 6f 6e 00 00 | 98 00 52 00 20 43 68 61 |ection..|..R. Cha|
|00002c90| 6e 67 65 20 74 68 65 20 | 63 61 70 74 69 6f 6e 20 |nge the |caption |
|00002ca0| 6f 66 20 74 68 65 20 61 | 70 70 6c 69 63 61 74 69 |of the a|pplicati|
|00002cb0| 6f 6e 20 74 6f 20 72 65 | 66 6c 65 63 74 20 74 68 |on to re|flect th|
|00002cc0| 65 20 73 65 72 76 65 72 | 20 6e 61 6d 65 20 61 6e |e server| name an|
|00002cd0| 64 20 74 68 65 20 64 61 | 74 61 62 61 73 65 00 00 |d the da|tabase..|
|00002ce0| 98 00 38 00 20 53 65 74 | 20 74 68 65 20 6d 61 78 |..8. Set| the max|
|00002cf0| 20 74 69 6d 65 20 77 65 | 20 77 69 6c 6c 20 77 61 | time we| will wa|
|00002d00| 69 74 20 66 6f 72 20 61 | 20 53 51 4c 20 53 65 72 |it for a| SQL Ser|
|00002d10| 76 65 72 20 72 65 73 70 | 6f 6e 73 65 00 00 98 00 |ver resp|onse....|
|00002d20| 00 00 00 00 00 00 0b 04 | 01 01 e4 00 f1 00 45 00 |........|......E.|
|00002d30| 70 01 0b 04 01 01 ee 00 | 24 00 01 00 1b 03 00 00 |p.......|$.......|
|00002d40| 0b 04 4c 08 0e 04 01 00 | 39 08 0c 04 2f 08 00 00 |..L.....|9.../...|
|00002d50| 0b 18 d8 03 0b 18 71 08 | 0b 18 7c 08 0b 18 88 08 |......q.|..|.....|
|00002d60| 0b 18 88 08 0e 00 05 00 | 5c 08 0c 04 01 01 00 00 |........|\.......|
|00002d70| 0b 04 01 01 e4 00 f1 00 | 49 00 f4 01 00 10 0b 04 |........|I.......|
|00002d80| 01 01 0e 00 01 00 97 08 | 0c 18 6f 06 00 10 24 00 |........|..o...$.|
|00002d90| 00 00 68 03 00 10 0b 04 | bb 08 0e 04 01 00 ad 08 |..h.....|........|
|00002da0| 0c 04 2f 02 00 00 32 00 | 1e 02 00 10 ed 00 04 00 |../...2.|........|
|00002db0| f6 01 00 00 0c 18 6f 06 | 00 10 ed 00 04 00 04 02 |......o.|........|
|00002dc0| 00 00 0c 18 d8 03 00 10 | 0b 00 0c 01 0c 00 09 09 |........|........|
|00002dd0| 00 00 38 00 00 00 00 00 | 39 00 09 00 08 00 ff ff |..8.....|9.......|
|00002de0| ff ff ff ff ff ff 1a 00 | 00 00 03 00 fd          |........|.....   |
+--------+-------------------------+-------------------------+--------+--------+