thnx!!!!! "Raimis" <somebody@nomail.com> wrote in message news:k3euur$t9b$1@trimpas.omnitel.net... > Gal skiriasi stulpeliu 'emailas' teksto ilgis? > > "Leon'" <xx@sxs.lt> wrote in message > news:k3etts$s3n$1@trimpas.omnitel.net... >> Sveiki, su SQL tenka draugauti ne taip jau ir daznai, tad nemuskit, jei >> klausimas kvailokas :) >> >> Tevine lentele "klientai", jos laukai >> id, pavadinimas, email'as >> >> dukterine lentele "kontaktai", jos laukai >> id, id_tevinis, email'as, .... >> >> >> Reikia select'u perkelti is lenteles "klientai" informacija i lenteles >> "kontaktai" >> >> rasau toki selecta, bet keikiasi, gal kas paprotins kur klystu, aciu >> >> update kontaktai >> set emailas = (select b.emailas from klientai b >> where kontaktai.id_tevinis = b.id ) >> >> >> >> klaida: >> Arithmetic exception, numeric overflow, or string truncation. >> String right truncation. >> > >