Zdar a silu Koci, dna 10.09.2001 si napisal(a):
> > ok, potom uz len jednu vec, ak je ten sql naozaj na 6 riadkov tak je
> hmmm
> > cesi tomu vravia _na povazenou_ ,slovaci zasa _chod s tym do prec_
> > :musi sa to dat napisat jednoduchsie.
> >
> Bohuzial, tlacim udaje do 50 stlpcov. Jednoduchsie to IMHO nejde. Vyzera
> to
> takto (nas server to asi zalomi, takze to moze vyzerat trochu cudne:):
>
> SQLCommand = "INSERT INTO blank_mc22 VALUES ('" + p1 + "', '" + p2 +
> "',
> '" + p3 + "', '" + _
> p4 + "', '" + p5 + "', '" + p6 + "', '" + p7 + "', '" + p8 + "', '"
> + p9
> + "', '" + p10 + _
> "', '" + p11 + "', '" + p12 + "', '" + p13 + "', '" + p14 + "', '" +
> p15
> + "', '" + p16 + "', '" + _
> p17 + "', '" + p18 + "', " + p19 + ", '" + p20 + "', '" + p21 + "',
> '" +
> p22 + "', '" + p23 + "', '" + _
> p24 + "', '" + p25 + "', '" + p26 + "', '" + p27 + "', " + p28 + ",
> '" +
> p29 + "', " + _
> p30 + ", '" + p31 + "', " + p32 + ", '" + p33 + "', '" + p34 + "',
> '" +
> p35 + "', '" + p36 + "', '" + p37 + _
> "', '" + p38 + "', '" + p39 + "', '" + p40 + "', '" + p41 + "', " +
> p42
> + ", '" + p43 + "', '" + p44 + "', '" + _
> p45 + "', '" + p46 + "', '" + p47 + "', '" + p48 + "', '" + p49 +
> "', '"
> + p50 + "')"
> Debug.Print SQLCommand
> DoCmd.RunSQL SQLCommand, False
>
>
> Mifko
>
>
to je presne to zverstvo.
kolko riadkov cca pridavas na jeden update?
ak je to viac ako 5 vytvaral by som si temp. txt
a ten importoval.
a ak je to menej (1 zaznam cca za hodinu) p1~p50
by som dal do pola(0 to 49) nadefinoval premennu retazec
a sluckou for i=0 to ubound(pola)
by som to vseto nacital
retazec=retazec &"," & pola(i)
next
no a potom by sql command vyzeral takto:
SQLCommand = "INSERT INTO blank_mc22 VALUES ("' & retazec & '")
ale takto by som to robil ja a nevravim ze takto je to najlepsie
len ten kod je potom prehladnejsi. ;-)
--
s pozdravom
AleXXX
This archive was generated by hypermail 2.1.2 : 11. 09. 2001, 08:43 CEST