Re: [Firebird-net-provider] next problem

[<car...@te...>]

Hello:

 >  i solved problem... it was my stupidnes... charset have to be 1250 not
 > 1252.
 >  it is hard make program without IDE...



:)), yo can get an IDE for Windows here:

http://www.icsharpcode.net/OpenSource/SD/default.asp

If you are using Linux you can see:

http://www.jext.org/home.html
http://www.jedit.org/
http://csde.sourceforge.net/

 >  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...

Ok, thanks, i have it solved now, there is a problem with sockets reading.

 >  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...


No problem :)



Best regards
Carlos Guzmán Álvarez
Vigo-Spain