/ PC World Komputer 1999 March / PCWK3A99.iso / Polskie / Kaps9902 / Compnet / MSAIN800.DL_ / MSAIN800.DL / 42 / 147

< prev

next >

MacOS 8.1

Win98

DOS

view JSON data

view as text

+--------+-------------------------+-------------------------+--------+--------+
|00000000| 01 00 00 91 01 4e 69 65 | 20 6d 6f bf 6e 61 20 6f |.....Nie| mo.na o|
|00000010| 6b 72 65 9c 6c 69 e6 20 | 6b 72 79 74 65 72 69 f3 |kre.li. |kryteri.|
|00000020| 77 20 64 6c 61 20 74 65 | 67 6f 20 73 61 6d 65 67 |w dla te|go sameg|
|00000030| 6f 20 70 6f 6c 61 2c 20 | 64 6c 61 20 6b 74 f3 72 |o pola, |dla kt.r|
|00000040| 65 67 6f 20 77 70 72 6f | 77 61 64 7a 6f 6e 6f 20 |ego wpro|wadzono |
|00000050| 57 61 72 74 6f 9c e6 20 | 77 20 77 69 65 72 73 7a |Warto.. |w wiersz|
|00000060| 75 20 4b 72 7a 79 bf 6f | 77 65 2e 40 50 72 f3 62 |u Krzy.o|we.@Pr.b|
|00000070| 6f 77 61 6e 6f 20 75 72 | 75 63 68 6f 6d 69 e6 20 |owano ur|uchomi. |
|00000080| 6b 77 65 72 65 6e 64 ea | 20 6b 72 7a 79 bf 6f 77 |kwerend.| krzy.ow|
|00000090| b9 20 70 6f 20 77 70 72 | 6f 77 61 64 7a 65 6e 69 |. po wpr|owadzeni|
|000000a0| 75 20 57 61 72 74 6f 9c | 63 69 20 77 20 77 69 65 |u Warto.|ci w wie|
|000000b0| 72 73 7a 75 20 4b 72 7a | 79 bf 6f 77 65 20 69 20 |rszu Krz|y.owe i |
|000000c0| 6b 72 79 74 65 72 69 f3 | 77 20 77 20 77 69 65 72 |kryteri.|w w wier|
|000000d0| 73 7a 75 20 4b 72 79 74 | 65 72 69 61 2e 40 4a 65 |szu Kryt|eria.@Je|
|000000e0| 9c 6c 69 20 63 68 63 65 | 73 7a 2c 20 61 62 79 20 |.li chce|sz, aby |
|000000f0| 74 6f 20 70 6f 6c 65 20 | 6f 62 73 b3 75 67 69 77 |to pole |obs.ugiw|
|00000100| 61 b3 6f 20 77 61 72 74 | 6f 9c 63 69 20 77 20 6b |a.o wart|o.ci w k|
|00000110| 77 65 72 65 6e 64 7a 69 | 65 20 6b 72 7a 79 bf 6f |werendzi|e krzy.o|
|00000120| 77 65 6a 2c 20 75 73 75 | f1 20 77 70 69 73 20 77 |wej, usu|. wpis w|
|00000130| 20 77 69 65 72 73 7a 75 | 20 4b 72 79 74 65 72 69 | wierszu| Kryteri|
|00000140| 61 2e 20 4a 65 9c 6c 69 | 20 63 68 63 65 73 7a 2c |a. Je.li| chcesz,|
|00000150| 20 61 62 79 20 74 6f 20 | 62 79 b3 6f 20 70 6f 6c | aby to |by.o pol|
|00000160| 65 20 6b 72 79 74 65 72 | 69 f3 77 2c 20 7a 6f 73 |e kryter|i.w, zos|
|00000170| 74 61 77 20 70 75 73 74 | 79 20 77 69 65 72 73 7a |taw pust|y wiersz|
|00000180| 20 4b 72 7a 79 bf 6f 77 | 65 2e 40 31 40 32 30 39 | Krzy.ow|e.@1@209|
|00000190| 39 38 30 40 31 00 70 00 | 7c 39 20 6f 62 63 69 b9 |980@1.p.||9 obci.|
|000001a0| b3 20 77 70 69 73 61 6e | 65 20 77 79 72 61 bf 65 |. wpisan|e wyra.e|
|000001b0| 6e 69 65 2e 40 57 79 72 | 61 bf 65 6e 69 65 20 27 |nie.@Wyr|a.enie '|
|000001c0| 7c 27 20 70 72 7a 65 6b | 72 61 63 7a 61 20 6f 62 ||' przek|racza ob|
|000001d0| 6f 77 69 b9 7a 75 6a b9 | 63 79 20 64 6c 61 20 73 |owi.zuj.|cy dla s|
|000001e0| 69 61 74 6b 69 20 70 72 | 6f 6a 65 6b 74 75 20 6c |iatki pr|ojektu l|
|000001f0| 69 6d 69 74 20 31 30 32 | 34 20 7a 6e 61 6b f3 77 |imit 102|4 znak.w|
|00000200| 2e 40 40 31 40 40 31 00 | f1 00 7c 39 20 6e 69 65 |.@@1@@1.|..|9 nie|
|00000210| 20 6d 6f bf 65 20 75 74 | 77 6f 72 7a 79 e6 20 63 | mo.e ut|worzy. c|
|00000220| 68 77 69 6c 6f 77 65 67 | 6f 20 b3 b9 63 7a 61 2e |hwiloweg|o ..cza.|
|00000230| 40 4f 73 69 b9 67 6e 69 | ea 74 79 20 7a 6f 73 74 |@Osi.gni|.ty zost|
|00000240| 61 b3 20 6c 69 6d 69 74 | 20 6c 69 63 7a 62 79 20 |a. limit| liczby |
|00000250| b3 b9 63 7a 79 20 77 20 | 54 77 6f 6a 65 6a 20 62 |..czy w |Twojej b|
|00000260| 61 7a 69 65 20 64 61 6e | 79 63 68 2e 20 7c 39 20 |azie dan|ych. |9 |
|00000270| 70 6f 74 72 7a 65 62 75 | 6a 65 20 75 74 77 6f 72 |potrzebu|je utwor|
|00000280| 7a 79 e6 20 63 68 77 69 | 6c 6f 77 65 20 b3 b9 63 |zy. chwi|lowe ..c|
|00000290| 7a 65 20 77 20 63 65 6c | 75 20 69 6d 70 6f 72 74 |ze w cel|u import|
|000002a0| 6f 77 61 6e 69 61 20 54 | 77 6f 6a 65 6a 20 74 61 |owania T|wojej ta|
|000002b0| 62 65 6c 69 20 4f 44 42 | 43 2e 40 55 73 75 f1 20 |beli ODB|C.@Usu. |
|000002c0| 77 73 7a 79 73 74 6b 69 | 65 20 63 68 77 69 6c 6f |wszystki|e chwilo|
|000002d0| 77 65 20 6c 75 62 20 6e | 69 65 70 6f 74 72 7a 65 |we lub n|iepotrze|
|000002e0| 62 6e 65 20 b3 b9 63 7a | 61 20 6c 75 62 20 74 61 |bne ..cz|a lub ta|
|000002f0| 62 65 6c 65 2e 40 31 40 | 40 31 00 65 00 57 70 72 |bele.@1@|@1.e.Wpr|
|00000300| 6f 77 61 64 7a 6f 6e 65 | 20 77 79 72 61 bf 65 6e |owadzone| wyra.en|
|00000310| 69 65 20 70 72 7a 65 6b | 72 61 63 7a 61 20 6f 62 |ie przek|racza ob|
|00000320| 6f 77 69 b9 7a 75 6a b9 | 63 79 20 64 6c 61 20 73 |owi.zuj.|cy dla s|
|00000330| 69 61 74 6b 69 20 70 72 | 6f 6a 65 6b 74 75 20 6b |iatki pr|ojektu k|
|00000340| 77 65 72 65 6e 64 79 20 | 6c 69 6d 69 74 20 31 30 |werendy |limit 10|
|00000350| 32 34 20 7a 6e 61 6b f3 | 77 2e 40 40 40 31 40 40 |24 znak.|w.@@@1@@|
|00000360| 31 00 01 00 00 0d 01 41 | 6b 63 6a 61 20 55 72 75 |1......A|kcja Uru|
|00000370| 63 68 6f 6d 53 51 4c 20 | 77 79 6d 61 67 61 20 61 |chomSQL |wymaga a|
|00000380| 72 67 75 6d 65 6e 74 75 | 20 73 6b b3 61 64 61 6a |rgumentu| sk.adaj|
|00000390| b9 63 65 67 6f 20 73 69 | ea 20 7a 20 77 79 72 61 |.cego si|. z wyra|
|000003a0| bf 65 6e 69 61 20 53 51 | 4c 2e 40 4e 61 20 70 72 |.enia SQ|L.@Na pr|
|000003b0| 7a 79 6b b3 61 64 20 6b | 77 65 72 65 6e 64 61 20 |zyk.ad k|werenda |
|000003c0| 66 75 6e 6b 63 6a 6f 6e | 61 6c 6e 61 2c 20 6b 74 |funkcjon|alna, kt|
|000003d0| f3 72 61 20 64 6f b3 b9 | 63 7a 61 20 72 65 6b 6f |.ra do..|cza reko|
|000003e0| 72 64 79 2c 20 72 6f 7a | 70 6f 63 7a 79 6e 61 20 |rdy, roz|poczyna |
|000003f0| 73 69 ea 20 6f 64 20 70 | 6f 6c 65 63 65 6e 69 61 |si. od p|olecenia|
|00000400| 20 49 4e 53 45 52 54 20 | 49 4e 54 4f 2e 20 4b 77 | INSERT |INTO. Kw|
|00000410| 65 72 65 6e 64 61 20 64 | 65 66 69 6e 69 75 6a b9 |erenda d|efiniuj.|
|00000420| 63 61 20 64 61 6e 65 2c | 20 6b 74 f3 72 61 20 74 |ca dane,| kt.ra t|
|00000430| 77 6f 72 7a 79 20 74 61 | 62 65 6c ea 2c 20 72 6f |worzy ta|bel., ro|
|00000440| 7a 70 6f 63 7a 79 6e 61 | 20 73 69 ea 20 6f 64 20 |zpoczyna| si. od |
|00000450| 70 6f 6c 65 63 65 6e 69 | 61 20 43 52 45 41 54 45 |poleceni|a CREATE|
|00000460| 20 54 41 42 4c 45 2e 40 | 40 31 40 36 30 33 36 39 | TABLE.@|@1@60369|
|00000470| 38 40 31 00 6d 00 57 70 | 72 6f 77 61 64 7a 6f 6e |8@1.m.Wp|rowadzon|
|00000480| 61 20 77 61 72 74 6f 9c | e6 20 70 72 7a 65 6b 72 |a warto.|. przekr|
|00000490| 61 63 7a 61 20 64 6f 70 | 75 73 7a 63 7a 61 6c 6e |acza dop|uszczaln|
|000004a0| 79 20 6c 69 6d 69 74 2c | 20 6b 74 f3 72 79 20 64 |y limit,| kt.ry d|
|000004b0| 6c 61 20 77 b3 61 9c 63 | 69 77 6f 9c 63 69 20 41 |la w.a.c|iwo.ci A|
|000004c0| 6c 69 61 73 20 77 79 6e | 6f 73 69 20 36 34 20 7a |lias wyn|osi 64 z|
|000004d0| 6e 61 6b 69 2e 40 40 40 | 31 40 36 30 36 31 34 36 |naki.@@@|1@606146|
|000004e0| 40 31 00 88 00 44 6c 61 | 20 77 b3 61 9c 63 69 77 |@1...Dla| w.a.ciw|
|000004f0| 6f 9c 63 69 20 54 6f 70 | 56 61 6c 75 65 73 20 28 |o.ci Top|Values (|
|00000500| 4e 61 6a 77 79 bf 73 7a | 65 57 61 72 74 6f 9c 63 |Najwy.sz|eWarto.c|
|00000510| 69 29 20 77 20 61 72 6b | 75 73 7a 75 20 77 b3 61 |i) w ark|uszu w.a|
|00000520| 9c 63 69 77 6f 9c 63 69 | 20 6b 77 65 72 65 6e 64 |.ciwo.ci| kwerend|
|00000530| 79 20 6e 61 6c 65 bf 79 | 20 77 70 72 6f 77 61 64 |y nale.y| wprowad|
|00000540| 7a 69 e6 20 6c 69 63 7a | 62 ea 20 63 61 b3 6b 6f |zi. licz|b. ca.ko|
|00000550| 77 69 74 b9 20 77 69 ea | 6b 73 7a b9 20 6f 64 20 |wit. wi.|ksz. od |
|00000560| 7a 65 72 61 2e 40 40 40 | 31 40 40 31 00 97 00 44 |zera.@@@|1@@1...D|
|00000570| 6c 61 20 77 b3 61 9c 63 | 69 77 6f 9c 63 69 20 54 |la w.a.c|iwo.ci T|
|00000580| 6f 70 56 61 6c 75 65 73 | 20 28 4e 61 6a 77 69 ea |opValues| (Najwi.|
|00000590| 6b 73 7a 65 57 61 72 74 | 6f 9c 63 69 29 20 77 20 |kszeWart|o.ci) w |
|000005a0| 61 72 6b 75 73 7a 75 20 | 77 b3 61 9c 63 69 77 6f |arkuszu |w.a.ciwo|
|000005b0| 9c 63 69 20 6b 77 65 72 | 65 6e 64 79 20 6e 61 6c |.ci kwer|endy nal|
|000005c0| 65 bf 79 20 77 70 72 6f | 77 61 64 7a 69 e6 20 70 |e.y wpro|wadzi. p|
|000005d0| 72 6f 63 65 6e 74 20 62 | ea 64 b9 63 79 20 6c 69 |rocent b|.d.cy li|
|000005e0| 63 7a 62 b9 20 7a 20 70 | 72 7a 65 64 7a 69 61 b3 |czb. z p|rzedzia.|
|000005f0| 75 20 6f 64 20 31 20 64 | 6f 20 31 30 30 2e 40 40 |u od 1 d|o 100.@@|
|00000600| 40 31 40 40 31 00 7e 00 | 44 6c 61 20 77 b3 61 9c |@1@@1.~.|Dla w.a.|
|00000610| 63 69 77 6f 9c 63 69 20 | 54 6f 70 56 61 6c 75 65 |ciwo.ci |TopValue|
|00000620| 73 20 28 4e 61 6a 77 79 | bf 73 7a 65 57 61 72 74 |s (Najwy|.szeWart|
|00000630| 6f 9c 63 69 29 20 77 20 | 61 72 6b 75 73 7a 75 20 |o.ci) w |arkuszu |
|00000640| 77 b3 61 9c 63 69 77 6f | 9c 63 69 20 6b 77 65 72 |w.a.ciwo|.ci kwer|
|00000650| 65 6e 64 79 20 6e 61 6c | 65 bf 79 20 77 70 72 6f |endy nal|e.y wpro|
|00000660| 77 61 64 7a 69 e6 20 6c | 69 63 7a 62 ea 20 77 69 |wadzi. l|iczb. wi|
|00000670| ea 6b 73 7a b9 20 6f 64 | 20 7a 65 72 61 2e 40 40 |.ksz. od| zera.@@|
|00000680| 40 31 40 40 31 00 e6 00 | 7c 39 20 6e 69 65 20 6d |@1@@1...||9 nie m|
|00000690| 6f bf 65 20 7a 6e 61 6c | 65 9f e6 20 6e 61 7a 77 |o.e znal|e.. nazw|
|000006a0| 79 20 70 6c 69 6b 75 20 | 77 70 72 6f 77 61 64 7a |y pliku |wprowadz|
|000006b0| 6f 6e 65 6a 20 77 65 20 | 77 b3 61 9c 63 69 77 6f |onej we |w.a.ciwo|
|000006c0| 9c 63 69 20 44 65 73 74 | 69 6e 61 74 69 6f 6e 44 |.ci Dest|inationD|
|000006d0| 42 20 28 44 6f 63 65 6c | 6f 77 61 42 61 7a 61 44 |B (Docel|owaBazaD|
|000006e0| 61 6e 79 63 68 29 20 77 | 20 61 72 6b 75 73 7a 75 |anych) w| arkuszu|
|000006f0| 20 77 b3 61 9c 63 69 77 | 6f 9c 63 69 20 61 6b 63 | w.a.ciw|o.ci akc|
|00000700| 6a 69 20 6b 77 65 72 65 | 6e 64 79 2e 40 4e 61 7a |ji kwere|ndy.@Naz|
|00000710| 77 61 20 62 61 7a 79 20 | 64 61 6e 79 63 68 20 7a |wa bazy |danych z|
|00000720| 6f 73 74 61 b3 61 20 9f | 6c 65 20 6e 61 70 69 73 |osta.a .|le napis|
|00000730| 61 6e 61 2c 20 70 6c 69 | 6b 20 7a 6f 73 74 61 b3 |ana, pli|k zosta.|
|00000740| 20 75 73 75 6e 69 ea 74 | 79 20 6c 75 62 20 7a 6d | usuni.t|y lub zm|
|00000750| 69 65 6e 69 6f 6e 6f 20 | 6d 75 20 6e 61 7a 77 ea |ieniono |mu nazw.|
|00000760| 2e 40 40 31 40 36 30 36 | 31 38 33 40 31 00 32 00 |.@@1@606|183@1.2.|
|00000770| 57 b3 61 9c 63 69 77 6f | 9c e6 20 41 6c 69 61 73 |W.a.ciwo|.. Alias|
|00000780| 20 6e 69 65 20 6d 6f bf | 65 20 62 79 e6 20 70 75 | nie mo.|e by. pu|
|00000790| 73 74 61 2e 40 40 40 31 | 40 36 30 36 31 34 36 40 |sta.@@@1|@606146@|
|000007a0| 31 00 7b 00 57 b3 61 9c | 63 69 77 6f 9c e6 20 54 |1.{.W.a.|ciwo.. T|
|000007b0| 6f 70 56 61 6c 75 65 73 | 20 28 4e 61 6a 77 79 bf |opValues| (Najwy.|
|000007c0| 73 7a 65 57 61 72 74 6f | 9c 63 69 29 20 77 20 61 |szeWarto|.ci) w a|
|000007d0| 72 6b 75 73 7a 75 20 77 | b3 61 9c 63 69 77 6f 9c |rkuszu w|.a.ciwo.|
|000007e0| 63 69 20 6b 77 65 72 65 | 6e 64 79 20 6d 75 73 69 |ci kwere|ndy musi|
|000007f0| 20 62 79 e6 20 6c 69 63 | 7a 62 b9 20 6d 6e 69 65 | by. lic|zb. mnie|
|00000800| 6a 73 7a b9 20 6e 69 bf | 20 32 20 31 34 37 20 34 |jsz. ni.| 2 147 4|
|00000810| 38 33 20 36 34 37 2e 40 | 40 40 31 40 40 31 00 9f |83 647.@|@@1@@1..|
|00000820| 01 7c 39 20 6e 69 65 20 | 6d 6f bf 65 20 7a 61 70 |.|9 nie |mo.e zap|
|00000830| 69 73 61 e6 20 6b 77 65 | 72 65 6e 64 79 2e 40 2a |isa. kwe|rendy.@*|
|00000840| 20 20 4b 77 65 72 65 6e | 64 61 20 6a 65 73 74 20 |  Kweren|da jest |
|00000850| 6b 77 65 72 65 6e 64 b9 | 20 70 72 7a 65 6b 61 7a |kwerend.| przekaz|
|00000860| 75 6a b9 63 b9 20 69 20 | 6e 69 65 20 6d 6f bf 65 |uj.c. i |nie mo.e|
|00000870| 20 62 79 e6 20 72 65 70 | 72 65 7a 65 6e 74 6f 77 | by. rep|rezentow|
|00000880| 61 6e 61 20 70 72 7a 65 | 7a 20 70 72 6f 73 74 79 |ana prze|z prosty|
|00000890| 20 63 69 b9 67 20 7a 6e | 61 6b f3 77 20 53 51 4c | ci.g zn|ak.w SQL|
|000008a0| 2e 20 5a 61 70 69 73 7a | 20 6b 77 65 72 65 6e 64 |. Zapisz| kwerend|
|000008b0| ea 20 6a 61 6b 6f 20 6e | 61 7a 77 61 6e b9 20 6b |. jako n|azwan. k|
|000008c0| 77 65 72 65 6e 64 ea 20 | 77 20 4b 6f 6e 73 74 72 |werend. |w Konstr|
|000008d0| 75 6b 74 6f 72 7a 65 20 | 6b 77 65 72 65 6e 64 2e |uktorze |kwerend.|
|000008e0| 20 50 72 7a 79 20 7a 61 | 6d 6b 6e 69 ea 63 69 75 | Przy za|mkni.ciu|
|000008f0| 20 4b 6f 6e 73 74 72 75 | 6b 74 6f 72 61 20 6b 77 | Konstru|ktora kw|
|00000900| 65 72 65 6e 64 20 7c 39 | 20 75 6d 69 65 9c 63 69 |erend |9| umie.ci|
|00000910| 20 77 65 20 77 b3 61 9c | 63 69 77 6f 9c 63 69 61 | we w.a.|ciwo.cia|
|00000920| 63 68 20 52 65 63 6f 72 | 64 53 6f 75 72 63 65 20 |ch Recor|dSource |
|00000930| 28 8f 72 f3 64 b3 6f 52 | 65 6b 6f 72 64 f3 77 29 |(.r.d.oR|ekord.w)|
|00000940| 20 6c 75 62 20 52 6f 77 | 53 6f 75 72 63 65 20 28 | lub Row|Source (|
|00000950| 8f 72 f3 64 b3 6f 57 69 | 65 72 73 7a 79 29 20 7a |.r.d.oWi|erszy) z|
|00000960| 61 70 69 73 61 6e b9 20 | 6e 61 7a 77 ea 20 6b 77 |apisan. |nazw. kw|
|00000970| 65 72 65 6e 64 79 2e 0a | 2a 20 20 53 70 72 61 77 |erendy..|*  Spraw|
|00000980| 64 9f 2c 20 63 7a 79 20 | 77 20 6b 77 65 72 65 6e |d., czy |w kweren|
|00000990| 64 7a 69 65 20 6e 69 65 | 20 77 79 73 74 b9 70 69 |dzie nie| wyst.pi|
|000009a0| b3 20 62 b3 b9 64 20 73 | 6b b3 61 64 6e 69 20 53 |. b..d s|k.adni S|
|000009b0| 51 4c 2e 40 40 31 40 36 | 30 34 33 30 39 40 31 00 |QL.@@1@6|04309@1.|
|000009c0| 7b 00 52 65 70 72 65 7a | 65 6e 74 61 63 6a 61 20 |{.Reprez|entacja |
|000009d0| 70 72 7a 65 7a 20 7c 39 | 20 6b 6c 61 75 7a 75 6c |przez |9| klauzul|
|000009e0| 69 20 56 41 4c 55 45 53 | 20 77 20 73 69 61 74 63 |i VALUES| w siatc|
|000009f0| 65 20 70 72 6f 6a 65 6b | 74 75 20 6b 77 65 72 65 |e projek|tu kwere|
|00000a00| 6e 64 79 20 6e 69 65 20 | 6a 65 73 74 20 6d 6f bf |ndy nie |jest mo.|
|00000a10| 6c 69 77 61 2e 40 44 6f | 6b 6f 6e 61 6a 20 6a 65 |liwa.@Do|konaj je|
|00000a20| 6a 20 65 64 79 63 6a 69 | 20 77 20 77 69 64 6f 6b |j edycji| w widok|
|00000a30| 75 20 53 51 4c 2e 40 40 | 31 40 40 31 00          |u SQL.@@|1@@1.   |
+--------+-------------------------+-------------------------+--------+--------+