Zeoslib Portal

hi

Iam using Zeos Lib 6.5, and when i connect to Firebird 1.5 and the table have a Field blod or memo this work. But if field have 600 lines of text the component send this message:
SQL error Segment buffer length shorter than expected: Error Code 101. segment buffer length shorter than expected.

I see any other message with the same error on the version Zeos Lib 6.1.

Some body knows if this bug be fix and the version?

Please send me a mail if this be fix.
cesar_picazo@hotmail.com
or
cesar_picazo@mp-erp.com.mx

Hi

I post this message the last week, the bug 101 can be Fix?

If anybody have any answer please post a message.

I use Firebird 1.5 with Delphi 6 and if use a blod field with 500 lines and send the message error 101.

did you get latest version for CVS?
have you posted this as a bug?

Hi

No i don't know were post this bug.

hola desconosco en donde se tienen que publicar los bugs que se encuentren en el componente pero si me dices donde lo pongo.

Gracias.


Regards.

http://sourceforge.net/tracker/?group_i ... tid=415824

It is prefered to register to source forge, log in and the post your bug with a sample project.

are you using latest CVS version?

I could not post this bug on SourceForge. So I thought I might post it here.

Here is code to create table

CREATE TABLE "GLRP"
(
"GLRP_CO" VARCHAR(30),
"GLRP_DE" BLOB SUB_TYPE TEXT SEGMENT SIZE 80
);

CREATE UNIQUE INDEX "GLRP_KEY1" ON "GLRP"("GLRP_CO");

Add following record

INSERT INTO "GLRP" ("GLRP_CO") VALUES ('Profit And Loss');

Assign GLRP_DE following:

<PAGE
Period Style=Fixed
Page Orientation=Portrait
Top Margin=1.00
Bottom Margin=1.00
Left Margin=1.00
Right Margin=1.00
>
<BAND
BandLetter=A
Name=Page Header 1
Band Style=Page Header
Print=Yes
Blank Lines Before=0
Blank Lines After=0
Height (CM)=0.60
>
<OBJ
ObjectType=otText
Name=AT1
Value={Date, dd mmmm yyyy}
Print=Yes
Truncate=No
Position (CM)=0.00
Width (CM)=1.40
Font=Ms Sans Serif, 8, Black
Alignment=Left Justify
>
<OBJ
ObjectType=otText
Name=AT2
Value={Company Name}
Print=Yes
Truncate=No
Position (CM)=7.95
Width (CM)=3.20
Font=Ms Sans Serif, 8, Black
Alignment=Centre
>
<OBJ
ObjectType=otText
Name=AT3
Value=Page {Page}
Print=Yes
Truncate=No
Position (CM)=17.62
Width (CM)=1.40
Font=Ms Sans Serif, 8, Black
Alignment=Right Justify
>
</BAND>
<BAND
BandLetter=B
Name=Page Header 2
Band Style=Page Header
Print=Yes
Blank Lines Before=0
Blank Lines After=1
Height (CM)=0.60
>
<OBJ
ObjectType=otText
Name=BT1
Value=BALANCE SHEET AS AT {Period, 0, -1, dd/mm/yyyy}
Print=Yes
Truncate=No
Position (CM)=6.05
Width (CM)=7.00
Font=Ms Sans Serif, 8, Black
Alignment=Centre
>
</BAND>
<BAND
BandLetter=F
Name=Column Header
Band Style=Page Header
Print=Yes
Blank Lines Before=0
Blank Lines After=0
Height (CM)=0.60
>
<OBJ
ObjectType=otText
Name=FT1
Value={Period, 0, -1, mmmm yyyy}
Print=Yes
Truncate=No
Position (CM)=7.98
Width (CM)=1.40
Font=Ms Sans Serif, 8, Black
Alignment=Right Justify
>
<OBJ
ObjectType=otText
Name=FT2
Value={Period, -1, -1, mmmm yyyy}
Print=Yes
Truncate=No
Position (CM)=13.05
Width (CM)=1.40
Font=Ms Sans Serif, 8, Black
Alignment=Right Justify
>
</BAND>
<BAND
BandLetter=C
Name=Capital & Reserves Header
Band Style=Header
Header Of=Capital & Reserves Data
Print=Yes
Start New Page=No
Blank Lines Before=0
Blank Lines After=0
Height (CM)=0.60
>
<OBJ
ObjectType=otText
Name=CT1
Value=CAPITAL & RESERVES
Print=Yes
Truncate=No
Position (CM)=0.00
Width (CM)=3.24
Font=Ms Sans Serif, 8, Black
Alignment=Left Justify
>
</BAND>
<BAND
BandLetter=D
Name=Capital & Reserves Data
Band Style=Data
Account From=9100
Account To=9130
Data Source=Actual
Normal Sign=Credit
Print=Yes
Start New Page=No
Blank Lines Before=0
Blank Lines After=0
Height (CM)=0.60
>
<OBJ
ObjectType=otNumber
Name=DN1
Value=0, 0, -1, Yes
Print=Yes
Data Source=Actual
Decimals=2
Percentage Of=
Position (CM)=7.98
Width (CM)=1.40
Font=Ms Sans Serif, 8, Black
Alignment=Right Justify
>
<OBJ
ObjectType=otText
Name=DT1
Value={Account Description}
Print=Yes
Truncate=No
Position (CM)=0.49
Width (CM)=2.00
Font=Ms Sans Serif, 8, Black
Alignment=Left Justify
>
<OBJ
ObjectType=otNumber
Name=DN2
Value=-1, 0, -1, Yes
Print=Yes
Data Source=Actual
Decimals=2
Percentage Of=
Position (CM)=13.05
Width (CM)=1.40
Font=Ms Sans Serif, 8, Black
Alignment=Right Justify
>
</BAND>
<BAND
BandLetter=E
Name=Capital & Reserves Total
Band Style=Total
Data Source=Actual
Normal Sign=Credit
Print=Yes
Start New Page=No
Blank Lines Before=1
Blank Lines After=0
Height (CM)=0.60
>
<OBJ
ObjectType=otNumber
Name=EN1
Value=DN1
Print=Yes
Data Source=Actual
Decimals=2
Percentage Of=
Position (CM)=7.98
Width (CM)=1.40
Font=MS Sans Serif, 8, Black, Underline
Alignment=Right Justify
>
<OBJ
ObjectType=otNumber
Name=EN2
Value=DN2
Print=Yes
Data Source=Actual
Decimals=2
Percentage Of=
Position (CM)=13.05
Width (CM)=1.40
Font=MS Sans Serif, 8, Black, Underline
Alignment=Right Justify
>
<OBJ
ObjectType=otText
Name=ET1
Value=TOTAL CAPITAL & RESERVES
Print=Yes
Truncate=No
Position (CM)=0.49
Width (CM)=2.00
Font=Ms Sans Serif, 8, Black
Alignment=Left Justify
>
</BAND>
<BAND
BandLetter=G
Name=Represented By Header
Band Style=Text
Print=Yes
Start New Page=No
Blank Lines Before=1
Blank Lines After=1
Height (CM)=0.60
>
<OBJ
ObjectType=otText
Name=GT1
Value=REPRESENTED BY:
Print=Yes
Truncate=No
Position (CM)=0.00
Width (CM)=3.62
Font=Ms Sans Serif, 8, Black
Alignment=Left Justify
>
</BAND>
<BAND
BandLetter=H
Name=Current Assets Header
Band Style=Header
Header Of=Current Assets Data
Print=Yes
Start New Page=No
Blank Lines Before=0
Blank Lines After=0
Height (CM)=0.60
>
<OBJ
ObjectType=otText
Name=HT1
Value=CURRENT ASSETS
Print=Yes
Truncate=No
Position (CM)=0.00
Width (CM)=2.00
Font=Ms Sans Serif, 8, Black
Alignment=Left Justify
>
</BAND>
<BAND
BandLetter=I
Name=Current Assets Data
Band Style=Data
Account From=9200
Account To=9599
Data Source=Actual
Normal Sign=Debit
Print=Yes
Start New Page=No
Blank Lines Before=0
Blank Lines After=0
Height (CM)=0.60
>
<OBJ
ObjectType=otNumber
Name=IN1
Value=0, 0, -1, Yes
Print=Yes
Data Source=Actual
Decimals=2
Percentage Of=
Position (CM)=7.98
Width (CM)=1.40
Font=Ms Sans Serif, 8, Black
Alignment=Right Justify
>
<OBJ
ObjectType=otNumber
Name=IN2
Value=-1, 0, -1, Yes
Print=Yes
Data Source=Actual
Decimals=2
Percentage Of=
Position (CM)=13.05
Width (CM)=1.40
Font=Ms Sans Serif, 8, Black
Alignment=Right Justify
>
<OBJ
ObjectType=otText
Name=IT1
Value={Account Description}
Print=Yes
Truncate=No
Position (CM)=0.49
Width (CM)=2.00
Font=Ms Sans Serif, 8, Black
Alignment=Left Justify
>
</BAND>
<BAND
BandLetter=J
Name=Current Assets Total
Band Style=Total
Data Source=Actual
Normal Sign=Debit
Print=Yes
Start New Page=No
Blank Lines Before=1
Blank Lines After=0
Height (CM)=0.60
>
<OBJ
ObjectType=otNumber
Name=JN1
Value=IN1
Print=Yes
Data Source=Actual
Decimals=2
Percentage Of=
Position (CM)=7.98
Width (CM)=1.40
Font=MS Sans Serif, 8, Black, Underline
Alignment=Right Justify
>
<OBJ
ObjectType=otNumber
Name=JN2
Value=IN2
Print=Yes
Data Source=Actual
Decimals=2
Percentage Of=
Position (CM)=13.05
Width (CM)=1.40
Font=MS Sans Serif, 8, Black, Underline
Alignment=Right Justify
>
<OBJ
ObjectType=otText
Name=JT1
Value=TOTAL CURRENT ASSETS
Print=Yes
Truncate=No
Position (CM)=0.00
Width (CM)=2.00
Font=Ms Sans Serif, 8, Black
Alignment=Left Justify
>
</BAND>
<BAND
BandLetter=K
Name=Current Liabilities Header
Band Style=Header
Header Of=Current Liabilities Data
Print=Yes
Start New Page=No
Blank Lines Before=1
Blank Lines After=0
Height (CM)=0.60
>
<OBJ
ObjectType=otText
Name=KT1
Value=CURRENT LIABILITIES
Print=Yes
Truncate=No
Position (CM)=0.00
Width (CM)=2.00
Font=Ms Sans Serif, 8, Black
Alignment=Left Justify
>
</BAND>
<BAND
BandLetter=L
Name=Current Liabilities Data
Band Style=Data
Account From=9600
Account To=9790
Data Source=Actual
Normal Sign=Credit
Print=Yes
Start New Page=No
Blank Lines Before=0
Blank Lines After=0
Height (CM)=0.60
>
<OBJ
ObjectType=otNumber
Name=LN1
Value=0, 0, -1, Yes
Print=Yes
Data Source=Actual
Decimals=2
Percentage Of=
Position (CM)=7.98
Width (CM)=1.40
Font=Ms Sans Serif, 8, Black
Alignment=Right Justify
>
<OBJ
ObjectType=otNumber
Name=LN2
Value=-1, 0, -1, Yes
Print=Yes
Data Source=Actual
Decimals=2
Percentage Of=
Position (CM)=13.05
Width (CM)=1.40
Font=Ms Sans Serif, 8, Black
Alignment=Right Justify
>
<OBJ
ObjectType=otText
Name=LT1
Value={Account Description}
Print=Yes
Truncate=No
Position (CM)=0.49
Width (CM)=2.00
Font=Ms Sans Serif, 8, Black
Alignment=Left Justify
>
</BAND>
<BAND
BandLetter=M
Name=Current Liabilities Total
Band Style=Total
Data Source=Actual
Normal Sign=Credit
Print=Yes
Start New Page=No
Blank Lines Before=1
Blank Lines After=0
Height (CM)=0.60
>
<OBJ
ObjectType=otNumber
Name=MN1
Value=LN1
Print=Yes
Data Source=Actual
Decimals=2
Percentage Of=
Position (CM)=7.98
Width (CM)=1.40
Font=MS Sans Serif, 8, Black, Underline
Alignment=Right Justify
>
<OBJ
ObjectType=otNumber
Name=MN2
Value=LN2
Print=Yes
Data Source=Actual
Decimals=2
Percentage Of=
Position (CM)=13.05
Width (CM)=1.40
Font=MS Sans Serif, 8, Black, Underline
Alignment=Right Justify
>
<OBJ
ObjectType=otText
Name=MT1
Value=TOTAL CURRENT LIABILITIES
Print=Yes
Truncate=No
Position (CM)=0.00
Width (CM)=2.00
Font=Ms Sans Serif, 8, Black
Alignment=Left Justify
>
</BAND>
<BAND
BandLetter=N
Name=Working Capital Total
Band Style=Total
Data Source=Actual
Normal Sign=Debit
Print=Yes
Start New Page=No
Blank Lines Before=1
Blank Lines After=0
Height (CM)=0.60
>
<OBJ
ObjectType=otText
Name=NT1
Value=WORKING CAPITAL
Print=Yes
Truncate=No
Position (CM)=0.00
Width (CM)=2.00
Font=Ms Sans Serif, 8, Black
Alignment=Left Justify
>
<OBJ
ObjectType=otNumber
Name=NN1
Value=JN1, LN1
Print=Yes
Data Source=Actual
Decimals=2
Percentage Of=
Position (CM)=7.98
Width (CM)=1.40
Font=MS Sans Serif, 8, Black, Underline
Alignment=Right Justify
>
<OBJ
ObjectType=otNumber
Name=NN2
Value=JN2, LN2
Print=Yes
Data Source=Actual
Decimals=2
Percentage Of=
Position (CM)=13.05
Width (CM)=1.40
Font=MS Sans Serif, 8, Black, Underline
Alignment=Right Justify
>
</BAND>
<BAND
BandLetter=U
Name=Fixed Assets Header
Band Style=Header
Header Of=Fixed Assets Data
Print=Yes
Start New Page=No
Blank Lines Before=1
Blank Lines After=0
Height (CM)=0.60
>
<OBJ
ObjectType=otText
Name=UT1
Value=FIXED ASSETS
Print=Yes
Truncate=No
Position (CM)=0.00
Width (CM)=2.00
Font=Ms Sans Serif, 8, Black
Alignment=Left Justify
>
</BAND>
<BAND
BandLetter=V
Name=Fixed Assets Data
Band Style=Data
Account From=9801
Account To=9899
Data Source=Actual
Normal Sign=Debit
Print=Yes
Start New Page=No
Blank Lines Before=0
Blank Lines After=0
Height (CM)=0.60
>
<OBJ
ObjectType=otNumber
Name=VN1
Value=0, 0, -1, Yes
Print=Yes
Data Source=Actual
Decimals=2
Percentage Of=
Position (CM)=7.98
Width (CM)=1.40
Font=Ms Sans Serif, 8, Black
Alignment=Right Justify
>
<OBJ
ObjectType=otNumber
Name=VN2
Value=-1, 0, -1, Yes
Print=Yes
Data Source=Actual
Decimals=2
Percentage Of=
Position (CM)=13.05
Width (CM)=1.40
Font=Ms Sans Serif, 8, Black
Alignment=Right Justify
>
<OBJ
ObjectType=otText
Name=VT1
Value={Account Description}
Print=Yes
Truncate=No
Position (CM)=0.49
Width (CM)=2.00
Font=Ms Sans Serif, 8, Black
Alignment=Left Justify
>
</BAND>
<BAND
BandLetter=W
Name=Fixed Assets Total
Band Style=Total
Data Source=Actual
Normal Sign=Debit
Print=Yes
Start New Page=No
Blank Lines Before=1
Blank Lines After=0
Height (CM)=0.60
>
<OBJ
ObjectType=otNumber
Name=WN1
Value=VN1
Print=Yes
Data Source=Actual
Decimals=2
Percentage Of=
Position (CM)=7.98
Width (CM)=1.40
Font=MS Sans Serif, 8, Black, Underline
Alignment=Right Justify
>
<OBJ
ObjectType=otNumber
Name=WN2
Value=VN2
Print=Yes
Data Source=Actual
Decimals=2
Percentage Of=
Position (CM)=13.05
Width (CM)=1.40
Font=MS Sans Serif, 8, Black, Underline
Alignment=Right Justify
>
<OBJ
ObjectType=otText
Name=WT1
Value=TOTAL FIXED ASSETS
Print=Yes
Truncate=No
Position (CM)=0.49
Width (CM)=2.00
Font=Ms Sans Serif, 8, Black
Alignment=Left Justify
>
</BAND>
<BAND
BandLetter=X
Name=Net Assets Total
Band Style=Total
Data Source=Actual
Normal Sign=Debit
Print=Yes
Start New Page=No
Blank Lines Before=1
Blank Lines After=0
Height (CM)=0.60
>
<OBJ
ObjectType=otNumber
Name=XN1
Value=NN1, WN1
Print=Yes
Data Source=Actual
Decimals=2
Percentage Of=
Position (CM)=7.98
Width (CM)=1.40
Font=MS Sans Serif, 8, Black, Underline
Alignment=Right Justify
>
<OBJ
ObjectType=otNumber
Name=XN2
Value=NN2, WN2
Print=Yes
Data Source=Actual
Decimals=2
Percentage Of=
Position (CM)=13.05
Width (CM)=1.40
Font=MS Sans Serif, 8, Black, Underline
Alignment=Right Justify
>
<OBJ
ObjectType=otText
Name=XT1
Value=NET ASSETS
Print=Yes
Truncate=No
Position (CM)=0.49
Width (CM)=2.00
Font=Ms Sans Serif, 8, Black
Alignment=Left Justify
>
</BAND>
</PAGE>




Copy upto last line.

Try opening the table now using protocol firebird-1.5 and you get the error

SQL error Segment buffer length shorter than expected: Error Code 101. segment buffer length shorter than expected.

Regards

Sandeep

I haven't had a reply for this for a long time so I thought I might check to see if anyone is around. I know there are quite a few people working on this, but it would be great if a list of developers, along with their responsibilities can be published.

Regards

Sandeep