Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Error 5073: The given record length was invalid.

3 posts in Trigger Last posting was on 2008-11-13 23:38:58.0Z
Fco.Soft Posted on 2008-11-13 20:32:43.0Z
From: "Fco.Soft" <laleche3@gmail.com>
Newsgroups: Advantage.Trigger
Subject: Error 5073: The given record length was invalid.
Date: Thu, 13 Nov 2008 21:32:43 +0100
Lines: 21
MIME-Version: 1.0
Content-Type: text/plain; format=flowed; charset="iso-8859-1"; reply-type=original
Content-Transfer-Encoding: 7bit
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Windows Mail 6.0.6001.18000
X-MimeOLE: Produced By Microsoft MimeOLE V6.0.6001.18049
NNTP-Posting-Host: 213.97.166.29
Message-ID: <491c8d6b@solutions.advantagedatabase.com>
X-Trace: 13 Nov 2008 13:26:19 -0700, 213.97.166.29
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!213.97.166.29
Xref: solutions.advantagedatabase.com Advantage.Trigger:417
Article PK: 1136480

this is a simple trigger after delete

delete from sub where codsub=(select subapu from __old);

but when delete record and trigger activate then I have this error 5073: The
given record length was invalid


If the trigger is this

declare old cursor as select * from __old;
fetch old;
delete form sub where codsub=old.subapu;
close old;

Them again the error occurs

What is wrong? What does the error code?

Thanks


Alex Wong (ADS) Posted on 2008-11-13 23:15:52.0Z
From: "Alex Wong \(ADS\)" <nobody@sybase.com>
Newsgroups: Advantage.Trigger
References: <491c8d6b@solutions.advantagedatabase.com>
Subject: Re: Error 5073: The given record length was invalid.
Date: Thu, 13 Nov 2008 16:15:52 -0700
Lines: 32
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5512
X-RFC2646: Format=Flowed; Response
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.5579
NNTP-Posting-Host: 10.24.38.144
Message-ID: <491cb3a8@solutions.advantagedatabase.com>
X-Trace: 13 Nov 2008 16:09:28 -0700, 10.24.38.144
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!10.24.38.144
Xref: solutions.advantagedatabase.com Advantage.Trigger:418
Article PK: 1136478

I found an entry in our bug database that says this error may be caused by
using VFP table type on DBF table that has the 10 byte memo field. The work
around is to use ADS_CDX table type. Does this apply to your case?

--
Alex

"Fco.Soft" <laleche3@gmail.com> wrote in message
news:491c8d6b@solutions.advantagedatabase.com...
> this is a simple trigger after delete
>
> delete from sub where codsub=(select subapu from __old);
>
> but when delete record and trigger activate then I have this error 5073:
> The given record length was invalid
>
>
> If the trigger is this
>
> declare old cursor as select * from __old;
> fetch old;
> delete form sub where codsub=old.subapu;
> close old;
>
> Them again the error occurs
>
> What is wrong? What does the error code?
>
> Thanks


Fco.Soft Posted on 2008-11-13 23:38:58.0Z
From: "Fco.Soft" <laleche3@gmail.com>
Newsgroups: Advantage.Trigger
References: <491c8d6b@solutions.advantagedatabase.com> <491cb3a8@solutions.advantagedatabase.com>
In-Reply-To: <491cb3a8@solutions.advantagedatabase.com>
Subject: Re: Error 5073: The given record length was invalid.
Date: Fri, 14 Nov 2008 00:38:58 +0100
Lines: 44
MIME-Version: 1.0
Content-Type: text/plain; format=flowed; charset="iso-8859-1"; reply-type=response
Content-Transfer-Encoding: 8bit
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Windows Mail 6.0.6001.18000
X-MimeOLE: Produced By Microsoft MimeOLE V6.0.6001.18049
NNTP-Posting-Host: 213.97.166.29
Message-ID: <491cb914@solutions.advantagedatabase.com>
X-Trace: 13 Nov 2008 16:32:36 -0700, 213.97.166.29
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!213.97.166.29
Xref: solutions.advantagedatabase.com Advantage.Trigger:419
Article PK: 1136479

YES !!!!... thanks!!!!!!!!!!!
to switch to ADS_CDX it all works perfectly ... although the DBF table had
no memo field


Thanks!!!



"Alex Wong (ADS)" <nobody@sybase.com> escribi? en el mensaje de noticias
news:491cb3a8@solutions.advantagedatabase.com...

>I found an entry in our bug database that says this error may be caused by
>using VFP table type on DBF table that has the 10 byte memo field. The work
>around is to use ADS_CDX table type. Does this apply to your case?
>
> --
> Alex
>
>
> "Fco.Soft" <laleche3@gmail.com> wrote in message
> news:491c8d6b@solutions.advantagedatabase.com...
>> this is a simple trigger after delete
>>
>> delete from sub where codsub=(select subapu from __old);
>>
>> but when delete record and trigger activate then I have this error 5073:
>> The given record length was invalid
>>
>>
>> If the trigger is this
>>
>> declare old cursor as select * from __old;
>> fetch old;
>> delete form sub where codsub=old.subapu;
>> close old;
>>
>> Them again the error occurs
>>
>> What is wrong? What does the error code?
>>
>> Thanks
>
>