try update gdb error

Thread View: borland.public.interbase.opensource

4 messages

[T] Back to Threads [V] Tree View [G] Group Articles

4 total messages Started by Bit Mon, 13 Feb 2006 13:09

#234

Author: Bit
Date: Mon, 13 Feb 2006 13:09

18 lines
1686 bytes

hi people!
i'm try update database show error:
CREATE TABLE SRI_ANALISE_ITENS_DET(
                ID_ITENS_DET              DOMAIN_SEQUENCIAL_PK NOT NULL ,
                ID_REG_INVEST           DOMAIN_ID_SEQ_MAX NOT NULL ,
                ID_ORDEM                     DOMAIN_ID_SEQ_PEQ NOT NULL ,
                ID_F_PESSOAL              DOMAIN_ID_SEQ_MAX,
                ID_F_TRABALHO          DOMAIN_ID_SEQ_MAX,
                ID_DET_F_PESSOAL    DOMAIN_ID_SEQ_MAX,
                ID_DET_F_TRABALHO DOMAIN_ID_SEQ_MAX,
                DETALHES                     CAMPO_TEXTO_GRANDE
 );

error: new record size of 71548 bytes is too big

thx

Bit

Re: try update gdb error

#235

Author: Bill Todd
Date: Mon, 13 Feb 2006 13:02

25 lines
1743 bytes

Bit wrote:

> hi people!
> i'm try update database show error:
> CREATE TABLE SRI_ANALISE_ITENS_DET(
>                ID_ITENS_DET              DOMAIN_SEQUENCIAL_PK NOT
> NULL ,                ID_REG_INVEST           DOMAIN_ID_SEQ_MAX NOT
> NULL ,                ID_ORDEM                     DOMAIN_ID_SEQ_PEQ
> NOT NULL ,                ID_F_PESSOAL              DOMAIN_ID_SEQ_MAX,
>                ID_F_TRABALHO          DOMAIN_ID_SEQ_MAX,
>                ID_DET_F_PESSOAL    DOMAIN_ID_SEQ_MAX,
>                ID_DET_F_TRABALHO DOMAIN_ID_SEQ_MAX,
>                DETALHES                     CAMPO_TEXTO_GRANDE
> );
> 
> error: new record size of 71548 bytes is too big
> 
> thx
> 
> Bit

Do you have a question?

-- 
Bill Todd (TeamB)

Re: try update gdb error

#236

Author: Bit
Date: Mon, 13 Feb 2006 14:23

34 lines
2131 bytes

that error and this 'new record size of 71548 bytes is too big'

thx

Bit


"Bill Todd" <no@no.com> escreveu na mensagem 
news:43f09164$1@newsgroups.borland.com...
> Bit wrote:
>
>> hi people!
>> i'm try update database show error:
>> CREATE TABLE SRI_ANALISE_ITENS_DET(
>>                ID_ITENS_DET              DOMAIN_SEQUENCIAL_PK NOT
>> NULL ,                ID_REG_INVEST           DOMAIN_ID_SEQ_MAX NOT
>> NULL ,                ID_ORDEM                     DOMAIN_ID_SEQ_PEQ
>> NOT NULL ,                ID_F_PESSOAL              DOMAIN_ID_SEQ_MAX,
>>                ID_F_TRABALHO          DOMAIN_ID_SEQ_MAX,
>>                ID_DET_F_PESSOAL    DOMAIN_ID_SEQ_MAX,
>>                ID_DET_F_TRABALHO DOMAIN_ID_SEQ_MAX,
>>                DETALHES                     CAMPO_TEXTO_GRANDE
>> );
>>
>> error: new record size of 71548 bytes is too big
>>
>> thx
>>
>> Bit
>
> Do you have a question?
>
> -- 
> Bill Todd (TeamB)

Re: try update gdb error

#237

Author: Craig Stuntz TeamB
Date: Mon, 13 Feb 2006 15:42

16 lines
1727 bytes

Bit wrote:

> error: new record size of 71548 bytes is too big

	Is this the *exact* error message?

	IB won't allow indices on [VAR]CHAR columns greater than around 256
bytes. But since you don't give the full source for the table (e.g.,
DOMAINs, CONSTRAINTs, etc.) and the message looks like it isn't the
real message you're seeing, it's hard to tell.

-- 
Craig Stuntz [TeamB] � Vertex Systems Corp. � Columbus, OH
  Delphi/InterBase Weblog : http://blogs.teamb.com/craigstuntz
Borland newsgroup denizen Sergio Gonz�lez has a new CD of 
  Irish music out, and it's good: http://tinyurl.com/7hgfr

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads