Re: ��������� ���� ����

Sun, 13 Aug 2006 14:06:48 -0700 

îÁÐÒÉÍÅÒ ÍÅÎÑ ibexpert ÄÁ×ÎÏ ÐÒÉÕÞÉÌ ÞÔÏ Ñ × Ó×ÏÉÈ ÓËÒÉÐÔÁÈ ÐÉÛÕ

update RDB$FIELDS set
RDB$FIELD_SUB_TYPE = 0,
RDB$CHARACTER_SET_ID = 52
where RDB$FIELD_NAME =
  (select RDB$FIELD_SOURCE
  from RDB$RELATION_FIELDS
  where (RDB$FIELD_NAME = 'NOTE') and (RDB$RELATION_NAME = 'FIRMS'));

é ×ÓÅ ÏÔÌÉÞÎÏ ÒÁÂÏÔÁÅÔ. îÁ alter table ÐÏÜÔÏÍÕ ÎÉËÏÇÄÁ ×ÎÉÍÁÎÉÑ ÎÅ ÏÂÒÁÝÁÌ, 
ÈÏÔÑ ÎÁÄÏ ÂÙ ÎÁÐÉÓÁÔØ Ï ÜÔÏÍ Á×ÔÏÒÕ ÉÂÜËÓÐÅÒÔÁ

"DmitryLe" <[EMAIL PROTECTED]> wrote in message 
news:[EMAIL PROTECTED]
>
> ðÒÉ×ÅÔ.
> ðÏÎÁÄÏÂÉÌÏÓØ ÒÁÓÛÉÒÉÔØ varchar Ó 40 ÄÏ 200
> ðÏÌÅÚ × ibexpert. ïÎ ×ÙÄÁÌ ÔÁËÏÊ ËÏÄ
> update rdb$fields set rdb$fileds_length=200
> ...
> where rdb$fileds_name='RDB$203'
> îÏ RDB$203 - ÜÔÏ ÎÁÚ×ÁÎÉÅ ÎÅ ÇÁÒÁÎÔÉÑ. ÷
> ÏÄÉÎÁËÏ×ÙÈ ÂÁÚÁÈ ÉÚ ÒÁÚÎÙÈ ÓËÒÉÐÔÏ×
> ÜÔÏ ÍÏÖÅÔ ÎÁÚÙ×ÁÔØÓÑ ÐÏ ÒÁÚÎÏÍÕ.
> ðÏÞÅÍÕ ÐÒÏÓÔÏ ÎÅ ÉÓÐÏÌØÚÏ×ÁÔØ
> alter table Mytable alter column text type varchar(200)?
> ÉÌÉ × ÄÁÎÎÏÍ ÓÌÕÞÁÅ ÜÔÏ ÜË×É×ÁÌÅÎÔÎÏ?
> ñ ÐÏÎÉÍÁÀ, ÞÔÏ ÂÙ×ÁÀÔ ÍÏÍÅÎÔÙ × ÖÉÚÎÉ,
> ËÏÇÄÁ ÂÅÚ ËÏ×ÙÒÑÎÉÑ ÓÉÓÔÅÍÎÙÈ ÔÁÂÌÉÃ
> ÎÉËÁË, ÎÏ × ÄÁÎÎÏÍ ÓÌÕÞÁÅ?
> ñ ÞÅÌÏ×ÅË ÌÅÎÉ×ÙÊ, ÄÕÍÁÀ ËÁË É
> ÂÏÌØÛÉÎÓÔ×Ï. ðÒÉ×ÙË ËÏÐÉÒÏ×ÁÔØ
> ÓËÒÉÐÔÙ. îÁËÏÐÉÒÏ×ÁÌ ÂÙ ÔÁËÏÇÏ...
> äÍÉÔÒÉÊ
>
>

Ответить