|
From: Pavol S. <st...@ra...> - 2002-11-18 00:13:34
|
Hi,
i solved problem... it was my stupidnes... charset have to be 1250 not
1252.
it is hard make program without IDE...
but i have new problem:
Unhandled Exception: FirebirdSql.Data.Firebird.FbException: invalid sqlind
value
: -1658821521
at FirebirdSql.Data.Firebird.FbResultset.Fetch()
at FirebirdSql.Data.Firebird.FbDataReader.Read()
where that value is varying...
thrown at first evaluating of expression
while (fbData.Read()) {
...
}
here is metadata:
CREATE TABLE "ARTICLES"
(
"ID" INTEGER NOT NULL,
"NADNADPIS" VARCHAR(512) CHARACTER SET WIN1250 COLLATE PXW_SLOV,
"NADPIS" VARCHAR(512) CHARACTER SET WIN1250 COLLATE PXW_SLOV,
"PEREX" VARCHAR(512) CHARACTER SET WIN1250 COLLATE PXW_SLOV,
"TEXT" VARCHAR(32000) CHARACTER SET WIN1250 COLLATE PXW_SLOV,
"VYDANIE" INTEGER,
"KATEGORIA" CHAR(5) CHARACTER SET WIN1250 COLLATE PXW_SLOV,
"DATUM" DATE
);
here is script:
select first x skip y ID, TEXT from ARTICLES order by ID
exception is thrown no depend ox x, y... problem is not in recor, because
in
select first 3 skip 1 ID, TEXT from ARTICLES order by ID is exception
present but
in
select first 2 skip 2 ID, TEXT from ARTICLES order by ID is not...
i tried lot of combinations and i see that there is problem if sum of
lengths of rows is higher then some value (highest working i found was
aprox
4298).
it dont read rwcords with size bigger then 4298 too...
sumary:
i think, tha there is some problem with geting record bigger than 4298 b or
set of rows with sum size greater then 4298b while fetching rows.
sorry if my questions and problems are stupid, but i like this assembly and
i want to use it, so by patient with me...
thanx
p.
|