[Firebird-net-provider] next problem

[Pavol S. <st...@ra...>]

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.