/ Chip Hitware 6 B / CHIP_HITWARE6_B.iso / biuro / AXIS / standalone / MSAIN800.DLL / 42 / 147

< prev

next >

view JSON data

view as text

open on a Mac

open on a PC

+--------+-------------------------+-------------------------+--------+--------+
|00000000| 01 00 00 9a 01 59 6f 75 | 20 63 61 6e 27 74 20 73 |.....You| can't s|
|00000010| 70 65 63 69 66 79 20 63 | 72 69 74 65 72 69 61 20 |pecify c|riteria |
|00000020| 6f 6e 20 74 68 65 20 73 | 61 6d 65 20 66 69 65 6c |on the s|ame fiel|
|00000030| 64 20 66 6f 72 20 77 68 | 69 63 68 20 79 6f 75 20 |d for wh|ich you |
|00000040| 65 6e 74 65 72 65 64 20 | 56 61 6c 75 65 20 69 6e |entered |Value in|
|00000050| 20 74 68 65 20 43 72 6f | 73 73 74 61 62 20 72 6f | the Cro|sstab ro|
|00000060| 77 2e 40 59 6f 75 20 74 | 72 69 65 64 20 74 6f 20 |w.@You t|ried to |
|00000070| 64 69 73 70 6c 61 79 20 | 61 20 63 72 6f 73 73 74 |display |a crosst|
|00000080| 61 62 20 71 75 65 72 79 | 20 61 66 74 65 72 20 65 |ab query| after e|
|00000090| 6e 74 65 72 69 6e 67 20 | 56 61 6c 75 65 20 69 6e |ntering |Value in|
|000000a0| 20 74 68 65 20 43 72 6f | 73 73 74 61 62 20 72 6f | the Cro|sstab ro|
|000000b0| 77 20 61 6e 64 20 63 72 | 69 74 65 72 69 61 20 69 |w and cr|iteria i|
|000000c0| 6e 20 74 68 65 20 43 72 | 69 74 65 72 69 61 20 72 |n the Cr|iteria r|
|000000d0| 6f 77 2e 40 49 66 20 79 | 6f 75 20 77 61 6e 74 20 |ow.@If y|ou want |
|000000e0| 74 68 69 73 20 66 69 65 | 6c 64 20 74 6f 20 73 75 |this fie|ld to su|
|000000f0| 70 70 6c 79 20 74 68 65 | 20 63 72 6f 73 73 2d 74 |pply the| cross-t|
|00000100| 61 62 75 6c 61 74 65 64 | 20 76 61 6c 75 65 73 20 |abulated| values |
|00000110| 69 6e 20 74 68 65 20 63 | 72 6f 73 73 74 61 62 20 |in the c|rosstab |
|00000120| 71 75 65 72 79 2c 20 64 | 65 6c 65 74 65 20 74 68 |query, d|elete th|
|00000130| 65 20 65 6e 74 72 79 20 | 69 6e 20 74 68 65 20 43 |e entry |in the C|
|00000140| 72 69 74 65 72 69 61 20 | 72 6f 77 2e 20 49 66 20 |riteria |row. If |
|00000150| 79 6f 75 20 77 61 6e 74 | 20 74 68 69 73 20 74 6f |you want| this to|
|00000160| 20 62 65 20 61 20 63 72 | 69 74 65 72 69 61 20 66 | be a cr|iteria f|
|00000170| 69 65 6c 64 2c 20 6c 65 | 61 76 65 20 74 68 65 20 |ield, le|ave the |
|00000180| 43 72 6f 73 73 74 61 62 | 20 72 6f 77 20 62 6c 61 |Crosstab| row bla|
|00000190| 6e 6b 2e 40 31 40 32 30 | 39 39 38 30 40 31 00 7f |nk.@1@20|9980@1..|
|000001a0| 00 7c 39 20 74 72 75 6e | 63 61 74 65 64 20 74 68 |.|9 trun|cated th|
|000001b0| 65 20 65 78 70 72 65 73 | 73 69 6f 6e 20 79 6f 75 |e expres|sion you|
|000001c0| 20 65 6e 74 65 72 65 64 | 2e 40 54 68 65 20 65 78 | entered|.@The ex|
|000001d0| 70 72 65 73 73 69 6f 6e | 20 27 7c 27 20 65 78 63 |pression| '|' exc|
|000001e0| 65 65 64 73 20 74 68 65 | 20 31 2c 30 32 34 2d 63 |eeds the| 1,024-c|
|000001f0| 68 61 72 61 63 74 65 72 | 20 6c 69 6d 69 74 20 66 |haracter| limit f|
|00000200| 6f 72 20 74 68 65 20 71 | 75 65 72 79 20 64 65 73 |or the q|uery des|
|00000210| 69 67 6e 20 67 72 69 64 | 2e 40 40 31 40 40 31 00 |ign grid|.@@1@@1.|
|00000220| d4 00 7c 39 20 63 61 6e | 27 74 20 63 72 65 61 74 |..|9 can|'t creat|
|00000230| 65 20 61 20 74 65 6d 70 | 6f 72 61 72 79 20 6c 69 |e a temp|orary li|
|00000240| 6e 6b 2e 40 59 6f 75 20 | 72 65 61 63 68 65 64 20 |nk.@You |reached |
|00000250| 74 68 65 20 6c 69 6d 69 | 74 20 66 6f 72 20 74 68 |the limi|t for th|
|00000260| 65 20 6e 75 6d 62 65 72 | 20 6f 66 20 6c 69 6e 6b |e number| of link|
|00000270| 73 20 69 6e 20 79 6f 75 | 72 20 64 61 74 61 62 61 |s in you|r databa|
|00000280| 73 65 2e 20 7c 39 20 6e | 65 65 64 73 20 74 6f 20 |se. |9 n|eeds to |
|00000290| 63 72 65 61 74 65 20 61 | 20 74 65 6d 70 6f 72 61 |create a| tempora|
|000002a0| 72 79 20 6c 69 6e 6b 20 | 69 6e 20 6f 72 64 65 72 |ry link |in order|
|000002b0| 20 74 6f 20 69 6d 70 6f | 72 74 20 79 6f 75 72 20 | to impo|rt your |
|000002c0| 4f 44 42 43 20 74 61 62 | 6c 65 2e 40 52 65 6d 6f |ODBC tab|le.@Remo|
|000002d0| 76 65 20 61 6c 6c 20 75 | 6e 6e 65 65 64 65 64 20 |ve all u|nneeded |
|000002e0| 6c 69 6e 6b 73 20 6f 72 | 20 74 61 62 6c 65 73 2e |links or| tables.|
|000002f0| 40 31 40 40 31 00 5f 00 | 54 68 65 20 65 78 70 72 |@1@@1._.|The expr|
|00000300| 65 73 73 69 6f 6e 20 79 | 6f 75 20 65 6e 74 65 72 |ession y|ou enter|
|00000310| 65 64 20 65 78 63 65 65 | 64 73 20 74 68 65 20 31 |ed excee|ds the 1|
|00000320| 2c 30 32 34 2d 63 68 61 | 72 61 63 74 65 72 20 6c |,024-cha|racter l|
|00000330| 69 6d 69 74 20 66 6f 72 | 20 74 68 65 20 71 75 65 |imit for| the que|
|00000340| 72 79 20 64 65 73 69 67 | 6e 20 67 72 69 64 2e 40 |ry desig|n grid.@|
|00000350| 40 40 31 40 40 31 00 01 | 00 00 e3 00 41 20 52 75 |@@1@@1..|....A Ru|
|00000360| 6e 53 51 4c 20 61 63 74 | 69 6f 6e 20 72 65 71 75 |nSQL act|ion requ|
|00000370| 69 72 65 73 20 61 6e 20 | 61 72 67 75 6d 65 6e 74 |ires an |argument|
|00000380| 20 63 6f 6e 73 69 73 74 | 69 6e 67 20 6f 66 20 61 | consist|ing of a|
|00000390| 6e 20 53 51 4c 20 73 74 | 61 74 65 6d 65 6e 74 2e |n SQL st|atement.|
|000003a0| 40 46 6f 72 20 65 78 61 | 6d 70 6c 65 2c 20 61 6e |@For exa|mple, an|
|000003b0| 20 61 63 74 69 6f 6e 20 | 71 75 65 72 79 20 74 68 | action |query th|
|000003c0| 61 74 20 61 70 70 65 6e | 64 73 20 72 65 63 6f 72 |at appen|ds recor|
|000003d0| 64 73 20 73 74 61 72 74 | 73 20 77 69 74 68 20 49 |ds start|s with I|
|000003e0| 4e 53 45 52 54 20 49 4e | 54 4f 2e 20 41 20 64 61 |NSERT IN|TO. A da|
|000003f0| 74 61 2d 64 65 66 69 6e | 69 74 69 6f 6e 20 71 75 |ta-defin|ition qu|
|00000400| 65 72 79 20 74 68 61 74 | 20 63 72 65 61 74 65 73 |ery that| creates|
|00000410| 20 61 20 74 61 62 6c 65 | 20 73 74 61 72 74 73 20 | a table| starts |
|00000420| 77 69 74 68 20 43 52 45 | 41 54 45 20 54 41 42 4c |with CRE|ATE TABL|
|00000430| 45 2e 40 40 31 40 36 30 | 33 36 39 38 40 31 00 54 |E.@@1@60|3698@1.T|
|00000440| 00 54 68 65 20 76 61 6c | 75 65 20 79 6f 75 20 65 |.The val|ue you e|
|00000450| 6e 74 65 72 65 64 20 65 | 78 63 65 65 64 73 20 74 |ntered e|xceeds t|
|00000460| 68 65 20 41 6c 69 61 73 | 20 70 72 6f 70 65 72 74 |he Alias| propert|
|00000470| 79 27 73 20 36 34 2d 63 | 68 61 72 61 63 74 65 72 |y's 64-c|haracter|
|00000480| 20 6c 69 6d 69 74 2e 40 | 40 40 31 40 36 30 36 31 | limit.@|@@1@6061|
|00000490| 34 36 40 31 00 6c 00 46 | 6f 72 20 74 68 65 20 54 |46@1.l.F|or the T|
|000004a0| 6f 70 56 61 6c 75 65 73 | 20 70 72 6f 70 65 72 74 |opValues| propert|
|000004b0| 79 20 69 6e 20 74 68 65 | 20 71 75 65 72 79 20 70 |y in the| query p|
|000004c0| 72 6f 70 65 72 74 79 20 | 73 68 65 65 74 2c 20 79 |roperty |sheet, y|
|000004d0| 6f 75 20 6d 75 73 74 20 | 65 6e 74 65 72 20 61 6e |ou must |enter an|
|000004e0| 20 69 6e 74 65 67 65 72 | 20 67 72 65 61 74 65 72 | integer| greater|
|000004f0| 20 74 68 61 6e 20 7a 65 | 72 6f 2e 40 40 40 31 40 | than ze|ro.@@@1@|
|00000500| 40 31 00 6f 00 46 6f 72 | 20 74 68 65 20 54 6f 70 |@1.o.For| the Top|
|00000510| 56 61 6c 75 65 73 20 70 | 72 6f 70 65 72 74 79 20 |Values p|roperty |
|00000520| 69 6e 20 74 68 65 20 71 | 75 65 72 79 20 70 72 6f |in the q|uery pro|
|00000530| 70 65 72 74 79 20 73 68 | 65 65 74 2c 20 79 6f 75 |perty sh|eet, you|
|00000540| 20 6d 75 73 74 20 65 6e | 74 65 72 20 61 20 70 65 | must en|ter a pe|
|00000550| 72 63 65 6e 74 61 67 65 | 20 66 72 6f 6d 20 31 20 |rcentage| from 1 |
|00000560| 74 68 72 6f 75 67 68 20 | 31 30 30 2e 40 40 40 31 |through |100.@@@1|
|00000570| 40 40 31 00 6a 00 46 6f | 72 20 74 68 65 20 54 6f |@@1.j.Fo|r the To|
|00000580| 70 56 61 6c 75 65 73 20 | 70 72 6f 70 65 72 74 79 |pValues |property|
|00000590| 20 69 6e 20 74 68 65 20 | 71 75 65 72 79 20 70 72 | in the |query pr|
|000005a0| 6f 70 65 72 74 79 20 73 | 68 65 65 74 2c 20 79 6f |operty s|heet, yo|
|000005b0| 75 20 6d 75 73 74 20 65 | 6e 74 65 72 20 61 20 6e |u must e|nter a n|
|000005c0| 75 6d 62 65 72 20 67 72 | 65 61 74 65 72 20 74 68 |umber gr|eater th|
|000005d0| 61 6e 20 7a 65 72 6f 2e | 40 40 40 31 40 40 31 00 |an zero.|@@@1@@1.|
|000005e0| d6 00 7c 39 20 63 61 6e | 27 74 20 66 69 6e 64 20 |..|9 can|'t find |
|000005f0| 74 68 65 20 66 69 6c 65 | 20 6e 61 6d 65 20 79 6f |the file| name yo|
|00000600| 75 20 65 6e 74 65 72 65 | 64 20 66 6f 72 20 74 68 |u entere|d for th|
|00000610| 65 20 44 65 73 74 69 6e | 61 74 69 6f 6e 44 42 20 |e Destin|ationDB |
|00000620| 70 72 6f 70 65 72 74 79 | 20 69 6e 20 61 6e 20 61 |property| in an a|
|00000630| 63 74 69 6f 6e 20 71 75 | 65 72 79 27 73 20 70 72 |ction qu|ery's pr|
|00000640| 6f 70 65 72 74 79 20 73 | 68 65 65 74 2e 40 59 6f |operty s|heet.@Yo|
|00000650| 75 20 6d 61 79 20 68 61 | 76 65 20 6d 69 73 73 70 |u may ha|ve missp|
|00000660| 65 6c 6c 65 64 20 74 68 | 65 20 64 61 74 61 62 61 |elled th|e databa|
|00000670| 73 65 20 66 69 6c 65 20 | 6e 61 6d 65 2c 20 6f 72 |se file |name, or|
|00000680| 20 74 68 65 20 66 69 6c | 65 20 6d 61 79 20 68 61 | the fil|e may ha|
|00000690| 76 65 20 62 65 65 6e 20 | 64 65 6c 65 74 65 64 20 |ve been |deleted |
|000006a0| 6f 72 20 72 65 6e 61 6d | 65 64 2e 40 40 31 40 36 |or renam|ed.@@1@6|
|000006b0| 30 36 31 38 33 40 31 00 | 37 00 59 6f 75 20 63 61 |06183@1.|7.You ca|
|000006c0| 6e 27 74 20 6c 65 61 76 | 65 20 74 68 65 20 41 6c |n't leav|e the Al|
|000006d0| 69 61 73 20 70 72 6f 70 | 65 72 74 79 20 62 6c 61 |ias prop|erty bla|
|000006e0| 6e 6b 2e 40 40 40 31 40 | 36 30 36 31 34 36 40 31 |nk.@@@1@|606146@1|
|000006f0| 00 73 00 46 6f 72 20 74 | 68 65 20 54 6f 70 56 61 |.s.For t|he TopVa|
|00000700| 6c 75 65 73 20 70 72 6f | 70 65 72 74 79 20 69 6e |lues pro|perty in|
|00000710| 20 74 68 65 20 71 75 65 | 72 79 20 70 72 6f 70 65 | the que|ry prope|
|00000720| 72 74 79 20 73 68 65 65 | 74 2c 20 79 6f 75 20 6d |rty shee|t, you m|
|00000730| 75 73 74 20 65 6e 74 65 | 72 20 61 20 6e 75 6d 62 |ust ente|r a numb|
|00000740| 65 72 20 73 6d 61 6c 6c | 65 72 20 74 68 61 6e 20 |er small|er than |
|00000750| 32 2c 31 34 37 2c 34 38 | 33 2c 36 34 37 2e 40 40 |2,147,48|3,647.@@|
|00000760| 40 31 40 40 31 00 5b 01 | 7c 39 20 63 61 6e 27 74 |@1@@1.[.||9 can't|
|00000770| 20 73 61 76 65 20 74 68 | 65 20 71 75 65 72 79 2e | save th|e query.|
|00000780| 40 2a 20 54 68 65 20 71 | 75 65 72 79 20 69 73 20 |@* The q|uery is |
|00000790| 61 20 70 61 73 73 2d 74 | 68 72 6f 75 67 68 20 71 |a pass-t|hrough q|
|000007a0| 75 65 72 79 20 61 6e 64 | 20 63 61 6e 27 74 20 62 |uery and| can't b|
|000007b0| 65 20 72 65 70 72 65 73 | 65 6e 74 65 64 20 61 73 |e repres|ented as|
|000007c0| 20 61 20 73 69 6d 70 6c | 65 20 53 51 4c 20 73 74 | a simpl|e SQL st|
|000007d0| 72 69 6e 67 2e 20 53 61 | 76 65 20 74 68 65 20 71 |ring. Sa|ve the q|
|000007e0| 75 65 72 79 20 61 73 20 | 61 20 6e 61 6d 65 64 20 |uery as |a named |
|000007f0| 71 75 65 72 79 20 66 72 | 6f 6d 20 74 68 65 20 51 |query fr|om the Q|
|00000800| 75 65 72 79 20 42 75 69 | 6c 64 65 72 2e 20 57 68 |uery Bui|lder. Wh|
|00000810| 65 6e 20 79 6f 75 20 63 | 6c 6f 73 65 20 74 68 65 |en you c|lose the|
|00000820| 20 51 75 65 72 79 20 42 | 75 69 6c 64 65 72 2c 20 | Query B|uilder, |
|00000830| 7c 39 20 77 69 6c 6c 20 | 66 69 6c 6c 20 74 68 65 ||9 will |fill the|
|00000840| 20 52 65 63 6f 72 64 53 | 6f 75 72 63 65 20 6f 72 | RecordS|ource or|
|00000850| 20 52 6f 77 53 6f 75 72 | 63 65 20 70 72 6f 70 65 | RowSour|ce prope|
|00000860| 72 74 79 20 77 69 74 68 | 20 74 68 65 20 73 61 76 |rty with| the sav|
|00000870| 65 64 20 71 75 65 72 79 | 20 6e 61 6d 65 2e 0a 2a |ed query| name..*|
|00000880| 20 4d 61 6b 65 20 73 75 | 72 65 20 74 68 65 20 71 | Make su|re the q|
|00000890| 75 65 72 79 20 64 6f 65 | 73 6e 27 74 20 68 61 76 |uery doe|sn't hav|
|000008a0| 65 20 61 6e 20 53 51 4c | 20 73 79 6e 74 61 78 20 |e an SQL| syntax |
|000008b0| 65 72 72 6f 72 2e 40 40 | 31 40 36 30 34 33 30 39 |error.@@|1@604309|
|000008c0| 40 31 00 64 00 7c 39 20 | 63 61 6e 27 74 20 72 65 |@1.d.|9 |can't re|
|000008d0| 70 72 65 73 65 6e 74 20 | 61 6e 20 69 6d 70 6c 69 |present |an impli|
|000008e0| 63 69 74 20 56 41 4c 55 | 45 53 20 63 6c 61 75 73 |cit VALU|ES claus|
|000008f0| 65 20 69 6e 20 74 68 65 | 20 71 75 65 72 79 20 64 |e in the| query d|
|00000900| 65 73 69 67 6e 20 67 72 | 69 64 2e 40 45 64 69 74 |esign gr|id.@Edit|
|00000910| 20 74 68 69 73 20 69 6e | 20 53 51 4c 20 76 69 65 | this in| SQL vie|
|00000920| 77 2e 40 40 31 40 40 31 | 00                      |w.@@1@@1|.       |
+--------+-------------------------+-------------------------+--------+--------+