home *** CD-ROM | disk | FTP | other *** search
| Unknown | 1998-10-05 | 3.2 KB |
open in: 
MacOS 8.1
|
Win98
|
DOS
view JSON data
|
view as text
This file was not able to be converted.
This format is not currently supported by dexvert.
| Confidence | Program | Detection | Match Type | Support
|
|---|
| 100%
| file
| SIMH tape data
| default (weak)
| |
| 99%
| file
| data
| default
|
|
hex view+--------+-------------------------+-------------------------+--------+--------+
|00000000| 0e 00 00 00 46 65 74 63 | 68 44 62 52 65 63 6f 72 |....Fetc|hDbRecor|
|00000010| 64 73 0e 00 00 00 46 65 | 74 63 68 44 62 52 65 63 |ds....Fe|tchDbRec|
|00000020| 6f 72 64 73 08 00 00 00 | 4c 69 76 65 57 69 72 65 |ords....|LiveWire|
|00000030| 1a 00 00 00 46 65 74 63 | 68 20 72 65 63 6f 72 64 |....Fetc|h record|
|00000040| 73 20 66 72 6f 6d 20 61 | 20 74 61 62 6c 65 71 0c |s from a| tableq.|
|00000050| 00 00 2f 2a 3d 3d 3d 3d | 3d 3d 3d 3d 3d 3d 3d 3d |../*====|========|
|00000060| 3d 3d 3d 3d 3d 3d 3d 3d | 3d 3d 3d 3d 3d 3d 3d 3d |========|========|
|00000070| 3d 3d 3d 3d 3d 3d 3d 3d | 3d 3d 3d 3d 3d 3d 3d 3d |========|========|
|00000080| 3d 3d 3d 3d 3d 3d 3d 3d | 3d 3d 3d 3d 3d 3d 3d 3d |========|========|
|00000090| 3d 3d 3d 3d 3d 3d 3d 3d | 3d 3d 3d 3d 3d 3d 0d 0a |========|======..|
|000000a0| 46 55 4e 43 54 49 4f 4e | 3a 20 20 09 46 65 74 63 |FUNCTION|: .Fetc|
|000000b0| 68 44 62 52 65 63 6f 72 | 64 73 0d 0a 0d 0a 49 4e |hDbRecor|ds....IN|
|000000c0| 50 55 54 3a 20 09 09 63 | 6f 6e 6e 65 63 74 69 6f |PUT: ..c|onnectio|
|000000d0| 6e 20 28 6f 62 6a 65 63 | 74 29 09 09 09 09 20 3a |n (objec|t).... :|
|000000e0| 20 61 20 4c 69 76 65 57 | 69 72 65 20 63 6f 6e 6e | a LiveW|ire conn|
|000000f0| 65 63 74 69 6f 6e 20 6f | 72 20 64 61 74 61 62 61 |ection o|r databa|
|00000100| 73 65 20 6f 62 6a 65 63 | 74 0d 0a 09 09 09 09 64 |se objec|t......d|
|00000110| 62 54 61 62 6c 65 20 28 | 73 74 72 69 6e 67 29 09 |bTable (|string).|
|00000120| 09 09 09 09 20 3a 20 74 | 68 65 20 6e 61 6d 65 20 |.... : t|he name |
|00000130| 6f 66 20 74 68 65 20 74 | 61 62 6c 65 20 74 6f 20 |of the t|able to |
|00000140| 6f 70 65 72 61 74 65 20 | 6f 6e 0d 0a 09 09 09 09 |operate |on......|
|00000150| 64 62 46 69 65 6c 64 4e | 61 6d 65 20 28 73 74 72 |dbFieldN|ame (str|
|00000160| 69 6e 67 29 20 09 09 09 | 20 3a 20 74 68 65 20 66 |ing) ...| : the f|
|00000170| 69 65 6c 64 20 6e 61 6d | 65 20 66 6f 72 20 74 68 |ield nam|e for th|
|00000180| 65 20 77 68 65 72 65 20 | 63 6c 61 75 73 65 0d 0a |e where |clause..|
|00000190| 09 09 09 09 64 62 46 69 | 65 6c 64 56 61 6c 75 65 |....dbFi|eldValue|
|000001a0| 20 28 73 74 72 69 6e 67 | 20 6f 72 20 6e 75 6d 62 | (string| or numb|
|000001b0| 65 72 29 3a 20 74 68 65 | 20 76 61 6c 75 65 20 6f |er): the| value o|
|000001c0| 66 20 64 62 46 69 65 6c | 64 4e 61 6d 65 20 74 68 |f dbFiel|dName th|
|000001d0| 61 74 20 69 64 65 6e 74 | 69 66 69 65 73 20 74 68 |at ident|ifies th|
|000001e0| 65 20 72 65 63 6f 72 64 | 28 73 29 0d 0a 09 09 09 |e record|(s).....|
|000001f0| 09 64 62 46 69 65 6c 64 | 54 79 70 65 20 28 73 74 |.dbField|Type (st|
|00000200| 72 69 6e 67 29 09 09 09 | 09 20 3a 20 74 68 65 20 |ring)...|. : the |
|00000210| 64 61 74 61 20 74 79 70 | 65 20 6f 66 20 74 68 65 |data typ|e of the|
|00000220| 20 66 69 65 6c 64 20 69 | 6e 64 69 63 61 74 65 64 | field i|ndicated|
|00000230| 20 69 6e 20 64 62 46 69 | 65 6c 64 4e 61 6d 65 3b | in dbFi|eldName;|
|00000240| 20 20 0d 0a 09 09 09 09 | 09 09 09 09 09 09 09 09 | ......|........|
|00000250| 09 09 09 64 65 66 61 75 | 6c 74 73 20 74 6f 20 22 |...defau|lts to "|
|00000260| 73 74 72 69 6e 67 22 3b | 0d 0a 09 09 09 09 09 09 |string";|........|
|00000270| 09 09 09 09 09 09 09 09 | 20 20 09 76 61 6c 69 64 |........| .valid|
|00000280| 20 76 61 6c 75 65 73 3a | 20 20 22 73 74 72 69 6e | values:| "strin|
|00000290| 67 22 2c 20 22 6e 75 6d | 62 65 72 22 2c 20 22 62 |g", "num|ber", "b|
|000002a0| 6f 6f 6c 65 61 6e 22 2c | 20 22 64 61 74 65 22 3b |oolean",| "date";|
|000002b0| 0d 0a 0d 0a 52 45 54 55 | 52 4e 3a 09 09 72 65 74 |....RETU|RN:..ret|
|000002c0| 75 72 6e 73 20 6e 75 6c | 6c 20 69 66 20 69 6e 76 |urns nul|l if inv|
|000002d0| 61 6c 69 64 20 70 61 72 | 61 6d 65 74 65 72 20 76 |alid par|ameter v|
|000002e0| 61 6c 75 65 73 20 77 65 | 72 65 20 70 61 73 73 65 |alues we|re passe|
|000002f0| 64 3b 0d 0a 09 09 09 09 | 6f 74 68 65 72 77 69 73 |d;......|otherwis|
|00000300| 65 2c 20 72 65 74 75 72 | 6e 73 20 30 20 69 66 20 |e, retur|ns 0 if |
|00000310| 63 75 72 73 6f 72 20 77 | 61 73 20 63 72 65 61 74 |cursor w|as creat|
|00000320| 65 64 20 73 75 63 63 65 | 73 73 66 75 6c 6c 79 20 |ed succe|ssfully |
|00000330| 66 72 6f 6d 20 69 6e 70 | 75 74 20 70 61 72 61 6d |from inp|ut param|
|00000340| 65 74 65 72 73 0d 0a 20 | 0d 0a 44 45 53 43 3a 09 |eters.. |..DESC:.|
|00000350| 09 09 54 68 69 73 20 66 | 75 6e 63 74 69 6f 6e 20 |..This f|unction |
|00000360| 69 73 20 61 20 66 72 61 | 6d 65 77 6f 72 6b 20 66 |is a fra|mework f|
|00000370| 6f 72 20 63 6f 6e 64 75 | 63 74 69 6e 67 20 53 51 |or condu|cting SQ|
|00000380| 4c 20 53 45 4c 45 43 54 | 20 71 75 65 72 69 65 73 |L SELECT| queries|
|00000390| 20 61 6e 64 20 70 65 72 | 66 6f 72 6d 69 6e 67 0d | and per|forming.|
|000003a0| 0a 09 09 09 09 6f 70 65 | 72 61 74 69 6f 6e 73 20 |.....ope|rations |
|000003b0| 6f 6e 20 74 68 65 20 72 | 65 73 75 6c 74 73 2e 20 |on the r|esults. |
|000003c0| 20 59 6f 75 20 73 68 6f | 75 6c 64 20 61 64 64 20 | You sho|uld add |
|000003d0| 79 6f 75 72 20 6f 77 6e | 20 63 6f 64 65 20 62 65 |your own| code be|
|000003e0| 6c 6f 77 20 61 73 20 69 | 6e 64 69 63 61 74 65 64 |low as i|ndicated|
|000003f0| 0d 0a 09 09 09 09 66 6f | 72 20 6d 61 6e 69 70 75 |......fo|r manipu|
|00000400| 6c 61 74 69 6e 67 20 74 | 68 65 20 72 65 73 75 6c |lating t|he resul|
|00000410| 74 73 2e 20 20 45 6e 74 | 65 72 69 6e 67 20 6f 6e |ts. Ent|ering on|
|00000420| 6c 79 20 22 63 6f 6e 6e | 65 63 74 69 6f 6e 22 20 |ly "conn|ection" |
|00000430| 61 6e 64 20 22 64 62 54 | 61 62 6c 65 22 20 0d 0a |and "dbT|able" ..|
|00000440| 09 09 09 09 70 61 72 61 | 6d 65 74 65 72 73 20 77 |....para|meters w|
|00000450| 69 6c 6c 20 72 65 73 75 | 6c 74 20 69 6e 20 61 6c |ill resu|lt in al|
|00000460| 6c 20 72 65 63 6f 72 64 | 73 20 69 6e 20 64 62 54 |l record|s in dbT|
|00000470| 61 62 6c 65 20 62 65 69 | 6e 67 20 73 65 6c 65 63 |able bei|ng selec|
|00000480| 74 65 64 2e 0d 0a 20 20 | 09 09 09 09 0d 0a 50 4c |ted... |......PL|
|00000490| 41 54 46 4f 52 4d 53 3a | 09 4e 65 74 73 63 61 70 |ATFORMS:|.Netscap|
|000004a0| 65 20 45 6e 74 65 72 70 | 72 69 73 65 20 53 65 72 |e Enterp|rise Ser|
|000004b0| 76 65 72 20 33 2e 30 0d | 0a 3d 3d 3d 3d 3d 3d 3d |ver 3.0.|.=======|
|000004c0| 3d 3d 3d 3d 3d 3d 3d 3d | 3d 3d 3d 3d 3d 3d 3d 3d |========|========|
|000004d0| 3d 3d 3d 3d 3d 3d 3d 3d | 3d 3d 3d 3d 3d 3d 3d 3d |========|========|
|000004e0| 3d 3d 3d 3d 3d 3d 3d 3d | 3d 3d 3d 3d 3d 3d 3d 3d |========|========|
|000004f0| 3d 3d 3d 3d 3d 3d 3d 3d | 3d 3d 3d 3d 3d 3d 3d 3d |========|========|
|00000500| 3d 3d 2a 2f 0d 0a 66 75 | 6e 63 74 69 6f 6e 20 46 |==*/..fu|nction F|
|00000510| 65 74 63 68 44 62 52 65 | 63 6f 72 64 73 28 20 63 |etchDbRe|cords( c|
|00000520| 6f 6e 6e 65 63 74 69 6f | 6e 2c 20 64 62 54 61 62 |onnectio|n, dbTab|
|00000530| 6c 65 2c 20 64 62 46 69 | 65 6c 64 4e 61 6d 65 2c |le, dbFi|eldName,|
|00000540| 20 64 62 46 69 65 6c 64 | 56 61 6c 75 65 2c 20 64 | dbField|Value, d|
|00000550| 62 46 69 65 6c 64 54 79 | 70 65 20 29 20 7b 0d 0a |bFieldTy|pe ) {..|
|00000560| 09 76 61 72 20 64 62 44 | 65 6c 69 6d 20 3d 20 22 |.var dbD|elim = "|
|00000570| 22 3b 20 20 2f 2f 20 76 | 61 6c 75 65 20 64 65 6c |"; // v|alue del|
|00000580| 69 6d 69 74 65 72 73 20 | 75 73 65 64 20 69 6e 20 |imiters |used in |
|00000590| 53 51 4c 20 73 74 61 74 | 65 6d 65 6e 74 73 0d 0a |SQL stat|ements..|
|000005a0| 09 76 61 72 20 72 65 73 | 75 6c 74 20 3d 20 6e 75 |.var res|ult = nu|
|000005b0| 6c 6c 3b 0d 0a 09 76 61 | 72 20 73 65 6c 65 63 74 |ll;...va|r select|
|000005c0| 41 6c 6c 20 3d 20 66 61 | 6c 73 65 3b 0d 0a 09 0d |All = fa|lse;....|
|000005d0| 0a 09 2f 2f 20 56 61 6c | 69 64 61 74 65 20 70 61 |..// Val|idate pa|
|000005e0| 72 61 6d 65 74 65 72 73 | 20 76 61 6c 75 65 73 0d |rameters| values.|
|000005f0| 0a 09 69 66 20 28 74 79 | 70 65 6f 66 28 63 6f 6e |..if (ty|peof(con|
|00000600| 6e 65 63 74 69 6f 6e 29 | 20 3d 3d 20 74 79 70 65 |nection)| == type|
|00000610| 6f 66 28 76 6f 69 64 28 | 30 29 29 20 7c 7c 20 63 |of(void(|0)) || c|
|00000620| 6f 6e 6e 65 63 74 69 6f | 6e 20 3d 3d 20 6e 75 6c |onnectio|n == nul|
|00000630| 6c 29 0d 0a 09 09 72 65 | 74 75 72 6e 20 6e 75 6c |l)....re|turn nul|
|00000640| 6c 3b 0d 0a 09 69 66 20 | 28 74 79 70 65 6f 66 28 |l;...if |(typeof(|
|00000650| 64 62 54 61 62 6c 65 29 | 20 3d 3d 20 74 79 70 65 |dbTable)| == type|
|00000660| 6f 66 28 76 6f 69 64 28 | 30 29 29 20 7c 7c 20 64 |of(void(|0)) || d|
|00000670| 62 54 61 62 6c 65 20 3d | 3d 20 6e 75 6c 6c 29 0d |bTable =|= null).|
|00000680| 0a 09 09 72 65 74 75 72 | 6e 20 6e 75 6c 6c 3b 0d |...retur|n null;.|
|00000690| 0a 09 09 0d 0a 09 2f 2f | 20 49 66 20 74 68 65 20 |......//| If the |
|000006a0| 66 6f 6c 6c 6f 77 69 6e | 67 20 70 61 72 61 6d 65 |followin|g parame|
|000006b0| 74 65 73 20 61 72 65 20 | 6e 6f 74 20 70 72 6f 76 |tes are |not prov|
|000006c0| 69 64 65 64 2c 20 73 65 | 74 20 75 70 20 74 6f 20 |ided, se|t up to |
|000006d0| 70 65 72 66 6f 72 6d 20 | 61 20 73 65 6c 65 63 74 |perform |a select|
|000006e0| 20 6f 66 20 61 6c 6c 20 | 72 65 63 6f 72 64 73 0d | of all |records.|
|000006f0| 0a 09 69 66 20 28 74 79 | 70 65 6f 66 28 64 62 46 |..if (ty|peof(dbF|
|00000700| 69 65 6c 64 4e 61 6d 65 | 29 20 3d 3d 20 74 79 70 |ieldName|) == typ|
|00000710| 65 6f 66 28 76 6f 69 64 | 28 30 29 29 20 7c 7c 20 |eof(void|(0)) || |
|00000720| 64 62 46 69 65 6c 64 4e | 61 6d 65 20 3d 3d 20 6e |dbFieldN|ame == n|
|00000730| 75 6c 6c 29 20 0d 0a 09 | 09 73 65 6c 65 63 74 41 |ull) ...|.selectA|
|00000740| 6c 6c 20 3d 20 74 72 75 | 65 3b 0d 0a 09 69 66 20 |ll = tru|e;...if |
|00000750| 28 74 79 70 65 6f 66 28 | 64 62 46 69 65 6c 64 56 |(typeof(|dbFieldV|
|00000760| 61 6c 75 65 29 20 3d 3d | 20 74 79 70 65 6f 66 28 |alue) ==| typeof(|
|00000770| 76 6f 69 64 28 30 29 29 | 20 7c 7c 20 64 62 46 69 |void(0))| || dbFi|
|00000780| 65 6c 64 56 61 6c 75 65 | 20 3d 3d 20 6e 75 6c 6c |eldValue| == null|
|00000790| 29 0d 0a 09 09 73 65 6c | 65 63 74 41 6c 6c 20 3d |)....sel|ectAll =|
|000007a0| 20 74 72 75 65 3b 0d 0a | 09 69 66 20 28 74 79 70 | true;..|.if (typ|
|000007b0| 65 6f 66 28 64 62 46 69 | 65 6c 64 54 79 70 65 29 |eof(dbFi|eldType)|
|000007c0| 20 3d 3d 20 74 79 70 65 | 6f 66 28 76 6f 69 64 28 | == type|of(void(|
|000007d0| 30 29 29 20 7c 7c 20 64 | 62 46 69 65 6c 64 54 79 |0)) || d|bFieldTy|
|000007e0| 70 65 20 3d 3d 20 6e 75 | 6c 6c 29 0d 0a 09 09 64 |pe == nu|ll)....d|
|000007f0| 62 46 69 65 6c 64 54 79 | 70 65 20 3d 20 22 53 54 |bFieldTy|pe = "ST|
|00000800| 52 49 4e 47 22 3b 0d 0a | 09 65 6c 73 65 0d 0a 09 |RING";..|.else...|
|00000810| 09 64 62 46 69 65 6c 64 | 54 79 70 65 20 3d 20 28 |.dbField|Type = (|
|00000820| 64 62 46 69 65 6c 64 54 | 79 70 65 2b 22 22 29 2e |dbFieldT|ype+"").|
|00000830| 74 6f 55 70 70 65 72 43 | 61 73 65 28 29 3b 09 2f |toUpperC|ase();./|
|00000840| 2f 20 63 6f 6e 76 65 72 | 74 20 61 6c 6c 20 74 79 |/ conver|t all ty|
|00000850| 70 65 73 20 74 6f 20 75 | 70 70 65 72 63 61 73 65 |pes to u|ppercase|
|00000860| 20 66 6f 72 20 75 6e 69 | 66 6f 72 6d 20 63 6f 6d | for uni|form com|
|00000870| 70 61 72 69 73 6f 6e 73 | 0d 0a 0d 0a 09 2f 2f 20 |parisons|.....// |
|00000880| 2a 2a 2a 20 59 6f 75 20 | 6d 69 67 68 74 20 6e 65 |*** You |might ne|
|00000890| 65 64 20 74 6f 20 63 68 | 61 6e 67 65 20 73 6f 6d |ed to ch|ange som|
|000008a0| 65 20 6f 66 20 74 68 65 | 73 65 20 64 65 6c 69 6d |e of the|se delim|
|000008b0| 69 74 65 72 73 20 74 6f | 20 66 69 74 20 79 6f 75 |iters to| fit you|
|000008c0| 72 20 64 61 74 61 62 61 | 73 65 20 73 65 72 76 65 |r databa|se serve|
|000008d0| 72 27 73 20 72 65 71 75 | 69 72 65 6d 65 6e 74 73 |r's requ|irements|
|000008e0| 20 2a 2a 2a 0d 0a 09 69 | 66 20 28 64 62 46 69 65 | ***...i|f (dbFie|
|000008f0| 6c 64 54 79 70 65 20 3d | 3d 20 22 4e 55 4d 42 45 |ldType =|= "NUMBE|
|00000900| 52 22 29 0d 0a 09 09 64 | 62 44 65 6c 69 6d 20 3d |R")....d|bDelim =|
|00000910| 20 22 22 3b 0d 0a 09 65 | 6c 73 65 20 69 66 20 28 | "";...e|lse if (|
|00000920| 64 62 46 69 65 6c 64 54 | 79 70 65 20 3d 3d 20 22 |dbFieldT|ype == "|
|00000930| 44 41 54 45 22 29 0d 0a | 09 09 64 62 44 65 6c 69 |DATE")..|..dbDeli|
|00000940| 6d 20 3d 20 22 27 22 3b | 09 20 2f 2f 20 2a 2a 2a |m = "'";|. // ***|
|00000950| 20 44 61 74 65 20 64 65 | 6c 69 6d 69 74 65 72 73 | Date de|limiters|
|00000960| 20 69 6e 20 70 61 72 74 | 69 63 75 6c 61 72 20 76 | in part|icular v|
|00000970| 61 72 79 20 74 68 65 20 | 6d 6f 73 74 20 61 6d 6f |ary the |most amo|
|00000980| 6e 67 20 64 69 66 66 65 | 72 65 6e 74 20 64 61 74 |ng diffe|rent dat|
|00000990| 61 62 61 73 65 20 76 65 | 6e 64 6f 72 73 20 2a 2a |abase ve|ndors **|
|000009a0| 2a 0d 0a 09 65 6c 73 65 | 20 69 66 20 28 64 62 46 |*...else| if (dbF|
|000009b0| 69 65 6c 64 54 79 70 65 | 20 3d 3d 20 22 42 4f 4f |ieldType| == "BOO|
|000009c0| 4c 45 41 4e 22 29 0d 0a | 09 09 64 62 44 65 6c 69 |LEAN")..|..dbDeli|
|000009d0| 6d 20 3d 20 22 22 3b 0d | 0a 09 65 6c 73 65 0d 0a |m = "";.|..else..|
|000009e0| 09 09 64 62 44 65 6c 69 | 6d 20 3d 20 22 27 22 3b |..dbDeli|m = "'";|
|000009f0| 0d 0a 09 09 09 0d 0a 09 | 69 66 20 28 21 63 6f 6e |........|if (!con|
|00000a00| 6e 65 63 74 69 6f 6e 2e | 63 6f 6e 6e 65 63 74 65 |nection.|connecte|
|00000a10| 64 28 29 29 20 0d 0a 09 | 09 77 72 69 74 65 28 22 |d()) ...|.write("|
|00000a20| 45 72 72 6f 72 3a 20 4e | 6f 20 63 6f 6e 6e 65 63 |Error: N|o connec|
|00000a30| 74 69 6f 6e 20 74 6f 20 | 64 61 74 61 62 61 73 65 |tion to |database|
|00000a40| 2e 22 29 3b 20 0d 0a 09 | 65 6c 73 65 20 7b 09 0d |."); ...|else {..|
|00000a50| 0a 09 09 69 66 20 28 73 | 65 6c 65 63 74 41 6c 6c |...if (s|electAll|
|00000a60| 29 20 0d 0a 09 09 09 63 | 75 72 73 6f 72 20 3d 20 |) .....c|ursor = |
|00000a70| 64 61 74 61 62 61 73 65 | 2e 63 75 72 73 6f 72 28 |database|.cursor(|
|00000a80| 22 73 65 6c 65 63 74 20 | 2a 20 66 72 6f 6d 20 22 |"select |* from "|
|00000a90| 20 2b 20 64 62 54 61 62 | 6c 65 29 3b 0d 0a 09 09 | + dbTab|le);....|
|00000aa0| 65 6c 73 65 20 7b 0d 0a | 09 09 09 63 75 72 73 6f |else {..|...curso|
|00000ab0| 72 20 3d 20 64 61 74 61 | 62 61 73 65 2e 63 75 72 |r = data|base.cur|
|00000ac0| 73 6f 72 28 22 73 65 6c | 65 63 74 20 2a 20 66 72 |sor("sel|ect * fr|
|00000ad0| 6f 6d 20 22 20 2b 20 0d | 0a 09 09 09 09 09 09 09 |om " + .|........|
|00000ae0| 09 09 64 62 54 61 62 6c | 65 20 2b 20 22 20 77 68 |..dbTabl|e + " wh|
|00000af0| 65 72 65 20 22 20 2b 20 | 0d 0a 09 09 09 09 09 09 |ere " + |........|
|00000b00| 09 09 09 64 62 46 69 65 | 6c 64 4e 61 6d 65 20 2b |...dbFie|ldName +|
|00000b10| 20 22 20 3d 20 22 20 2b | 20 64 62 44 65 6c 69 6d | " = " +| dbDelim|
|00000b20| 20 2b 20 64 62 46 69 65 | 6c 64 56 61 6c 75 65 20 | + dbFie|ldValue |
|00000b30| 2b 20 64 62 44 65 6c 69 | 6d 29 3b 0d 0a 09 09 7d |+ dbDeli|m);....}|
|00000b40| 20 2f 2f 20 65 6e 64 20 | 65 6c 73 65 0d 0a 09 09 | // end |else....|
|00000b50| 0d 0a 09 09 2f 2f 20 49 | 66 20 74 68 65 20 63 75 |....// I|f the cu|
|00000b60| 72 73 6f 72 20 77 61 73 | 20 63 72 65 61 74 65 64 |rsor was| created|
|00000b70| 20 73 75 63 63 65 73 73 | 66 75 6c 6c 79 2c 20 77 | success|fully, w|
|00000b80| 6f 72 6b 20 77 69 74 68 | 20 74 68 65 20 72 65 73 |ork with| the res|
|00000b90| 75 6c 74 20 73 65 74 0d | 0a 09 09 69 66 20 28 63 |ult set.|...if (c|
|00000ba0| 75 72 73 6f 72 20 21 3d | 20 6e 75 6c 6c 29 20 7b |ursor !=| null) {|
|00000bb0| 0d 0a 09 09 09 72 65 73 | 75 6c 74 20 3d 20 30 3b |.....res|ult = 0;|
|00000bc0| 09 2f 2f 20 73 65 74 20 | 72 65 73 75 6c 74 20 74 |.// set |result t|
|00000bd0| 6f 20 73 75 63 63 65 73 | 73 66 75 6c 20 72 65 74 |o succes|sful ret|
|00000be0| 75 72 6e 20 76 61 6c 75 | 65 0d 0a 09 09 09 77 68 |urn valu|e.....wh|
|00000bf0| 69 6c 65 28 63 75 72 73 | 6f 72 2e 6e 65 78 74 28 |ile(curs|or.next(|
|00000c00| 29 29 20 7b 20 0d 0a 09 | 0d 0a 09 09 09 2f 2f 20 |)) { ...|.....// |
|00000c10| 2a 2a 2a 2a 2a 20 41 64 | 64 20 79 6f 75 72 20 63 |***** Ad|d your c|
|00000c20| 6f 64 65 20 68 65 72 65 | 20 74 6f 20 77 6f 72 6b |ode here| to work|
|00000c30| 20 77 69 74 68 20 72 65 | 73 75 6c 74 20 73 65 74 | with re|sult set|
|00000c40| 20 2a 2a 2a 2a 2a 0d 0a | 0d 0a 09 09 09 7d 20 2f | *****..|.....} /|
|00000c50| 2f 20 65 6e 64 20 77 68 | 69 6c 65 20 6c 6f 6f 70 |/ end wh|ile loop|
|00000c60| 0d 0a 09 09 09 63 75 72 | 73 6f 72 2e 63 6c 6f 73 |.....cur|sor.clos|
|00000c70| 65 28 29 3b 0d 0a 09 09 | 7d 20 2f 2f 20 65 6e 64 |e();....|} // end|
|00000c80| 20 69 66 09 0d 0a 09 7d | 20 2f 2f 20 65 6e 64 20 | if....}| // end |
|00000c90| 65 6c 73 65 0d 0a 09 0d | 0a 09 72 65 74 75 72 6e |else....|..return|
|00000ca0| 20 72 65 73 75 6c 74 3b | 0d 0a 7d 20 2f 2f 20 65 | result;|..} // e|
|00000cb0| 6e 64 20 46 65 74 63 68 | 44 62 52 65 63 6f 72 64 |nd Fetch|DbRecord|
|00000cc0| 73 0d 0a 0e 00 00 00 33 | 2e 30 20 61 6e 64 20 68 |s......3|.0 and h|
|00000cd0| 69 67 68 65 72 0e 00 00 | 00 33 2e 30 20 61 6e 64 |igher...|.3.0 and|
|00000ce0| 20 68 69 67 68 65 72 | | higher | |
+--------+-------------------------+-------------------------+--------+--------+
