Tema: Re: SQL (firebird)
Autorius: Leon
Data: 2012-09-20 14:35:50
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.
>>
>
>