firebird-net-provider

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

[Firebird-net-provider] next problem

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

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 are stupid, but i like this assembly and i want to use
it, so be patient with me...
 thanx
 p.

Re: [Firebird-net-provider] next problem

[Pavol S. - P. <pa...@st...>]

Can you release a patch or something??? I have now time to play with this
assembly, so i can do lot of tests...

next thing is: do you plan make it System.EnterpriseServices allowed it is
important for performance... I plan to use your component on big ASP.NET
site (more than 20k hits a hour), but now it is unusable (pooling not
working as i have to do)...
My site was writen using COM+ objects in delphi. it was fast stable and
scalable, but developing take to log, becouse you need to take care about
com+ logic more than your aplication logic... Net brings easy way how to
develob COM+ compliant assemblies and it is cool.
I can rewrite your code to make it thread safe, but it will be hard for
me... very hard... without your help... And for now im not .NET guru, so my
code will be not very nice...

Next thing is, that documentation is greate (very complex), but somethimes
it is not good :-)  you done there lot of overloaded methods and
constructors and not all are working in any way of use... for example i
think, that most offen question will be that Object reference not set to an
instance of an object. I was able to solve this by my hand, becouse i know
how firebird work and i checked your code so i knew that transactions are
missing... but many peole is not so far... Some examples are obsolete (you
have there examples without transactions) and so... I want to help you with
this project. May be i can start with documentation but you have to say
exactly what to do, not only say that do something... i cannot swim, so you
cannot throw me in to a pool...

p.

p.



----- Original Message -----
From: "Carlos Guzmán Álvarez" <car...@te...>
To: "Pavol Starek" <pa...@st...>
Cc: <fir...@li...>
Sent: Monday, November 18, 2002 10:27 AM
Subject: Re: [Firebird-net-provider] next problem


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

Re: [Firebird-net-provider] next problem

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

Hello:

 > Can you release a patch or something??? I have now time to play with 
this assembly, so i can do lot of tests...

I´m thinking on release an Alpha 4 version.

 > next thing is: do you plan make it System.EnterpriseServices allowed 
it is
 > important for performance... I plan to use your component on big ASP.NET
 > site (more than 20k hits a hour), but now it is unusable (pooling not
 > working as i have to do)...
 > My site was writen using COM+ objects in delphi. it was fast stable and
 > scalable, but developing take to log, becouse you need to take care about
 > com+ logic more than your aplication logic... Net brings easy way how to
 > develob COM+ compliant assemblies and it is cool.
 > I can rewrite your code to make it thread safe, but it will be hard for
 > me... very hard... without your help... And for now im not .NET guru, 
so my
 > code will be not very nice...


I have no planned this, at this moment my intention is to have the 
pooling working well. Here is an example on how the pooling is working now :

     FbConnection myConnection1 = new FbConnection(GetConnectionString());
     FbConnection myConnection2 = new FbConnection(GetConnectionString());
     FbConnection myConnection3 = new FbConnection(GetConnectionString());

     // Open two connections.
     Console.WriteLine ("Open two connections.");
     myConnection1.Open();
     myConnection2.Open();

     // Now there are two connections in the pool that matches the 
connection string.
     // Return the both connections to the pool.
     Console.WriteLine ("Return both of the connections to the pool.");
     myConnection1.Close();
     myConnection2.Close();

     // Get a connection out of the pool.
     Console.WriteLine ("Open a connection from the pool.");
     myConnection1.Open();

     // Get a second connection out of the pool.
     Console.WriteLine ("Open a second connection from the pool.");
     myConnection2.Open();

     // Open a third connection.
     Console.WriteLine ("Open a third connection.");
     myConnection3.Open();

     // Return the all connections to the pool.
     Console.WriteLine ("Return all three connections to the pool.");
     myConnection1.Close();
     myConnection2.Close();
     myConnection3.Close();

What are the params of your connection string???

 > Next thing is, that documentation is greate (very complex), but 
somethimes
 > it is not good :-)  you done there lot of overloaded methods and
 > constructors and not all are working in any way of use...


Why?? All overloaded constructors are needed, if you see documentation 
of SqlClient, OleDb or ODBC .Net data providers you will see probably 
the same.

 > Some examples are obsolete (you have there examples without 
transactions) and so... I want to help you with
 > this project. May be i can start with documentation but you have to say
 > exactly what to do, not only say that do something... i cannot swim, 
so you
 > cannot throw me in to a pool...



I have reviewed thew examples of:

- FbConnection
- FbDataReader
- FbDataAdapter
- FbCommandBuilder
- FbCommand

and i vahe it commited to the CVS.


Best regards
Carlos Guzmán Álvarez
Vigo-Spain

Re: [Firebird-net-provider] next problem

[Pavol S. - P. <pa...@st...>]

hi,

when you plan to release patch??? any way, are you often commiting changes
to CVS??? Is there bug fix for that record size problem???

what are CVS parameters??? On source forge i found only Firebird.NET (a .net
data provider): CVS but it looks strange... I think that it is not correct
project... So send me please server path and module name...


Your pooling is nice, but it works only while assembly is in use... when one
project ends and garbage collector decide to trash your net provider, pool
is flushed and destroyed... So if i want to create ASP.NET page i have to
link assembly to global.asax and in this situation i can use only
STAThreading... As i wrote, i have more than 20k hits to database in hour it
is more than 5 in sec... but sometimes it is more then 15hits/s... simple i
cannot use STAThreading... if i link assembly to each page, it is released
each time processing of page is done... again useless for me...
Im not forcing you to that... My be there is space for me...

i know that you are making your assembly System.Data compatible and therefor
there are that overloads. I know that they are needed, but documentation is
not clear in this way... again may be space for me...

thanx
p.

----- Original Message -----
From: "Carlos Guzmán Álvarez" <car...@te...>
To: "Pavol Starek - PSZ" <pa...@st...>; "Firebird .Net Provider"
<fir...@li...>
Sent: Monday, November 18, 2002 11:39 AM
Subject: Re: [Firebird-net-provider] next problem


> Hello:
>
>  > Can you release a patch or something??? I have now time to play with
> this assembly, so i can do lot of tests...
>
> I´m thinking on release an Alpha 4 version.
>
>  > next thing is: do you plan make it System.EnterpriseServices allowed
> it is
>  > important for performance... I plan to use your component on big
ASP.NET
>  > site (more than 20k hits a hour), but now it is unusable (pooling not
>  > working as i have to do)...
>  > My site was writen using COM+ objects in delphi. it was fast stable and
>  > scalable, but developing take to log, becouse you need to take care
about
>  > com+ logic more than your aplication logic... Net brings easy way how
to
>  > develob COM+ compliant assemblies and it is cool.
>  > I can rewrite your code to make it thread safe, but it will be hard for
>  > me... very hard... without your help... And for now im not .NET guru,
> so my
>  > code will be not very nice...
>
>
> I have no planned this, at this moment my intention is to have the
> pooling working well. Here is an example on how the pooling is working now
:
>
>      FbConnection myConnection1 = new FbConnection(GetConnectionString());
>      FbConnection myConnection2 = new FbConnection(GetConnectionString());
>      FbConnection myConnection3 = new FbConnection(GetConnectionString());
>
>      // Open two connections.
>      Console.WriteLine ("Open two connections.");
>      myConnection1.Open();
>      myConnection2.Open();
>
>      // Now there are two connections in the pool that matches the
> connection string.
>      // Return the both connections to the pool.
>      Console.WriteLine ("Return both of the connections to the pool.");
>      myConnection1.Close();
>      myConnection2.Close();
>
>      // Get a connection out of the pool.
>      Console.WriteLine ("Open a connection from the pool.");
>      myConnection1.Open();
>
>      // Get a second connection out of the pool.
>      Console.WriteLine ("Open a second connection from the pool.");
>      myConnection2.Open();
>
>      // Open a third connection.
>      Console.WriteLine ("Open a third connection.");
>      myConnection3.Open();
>
>      // Return the all connections to the pool.
>      Console.WriteLine ("Return all three connections to the pool.");
>      myConnection1.Close();
>      myConnection2.Close();
>      myConnection3.Close();
>
> What are the params of your connection string???
>
>  > Next thing is, that documentation is greate (very complex), but
> somethimes
>  > it is not good :-)  you done there lot of overloaded methods and
>  > constructors and not all are working in any way of use...
>
>
> Why?? All overloaded constructors are needed, if you see documentation
> of SqlClient, OleDb or ODBC .Net data providers you will see probably
> the same.
>
>  > Some examples are obsolete (you have there examples without
> transactions) and so... I want to help you with
>  > this project. May be i can start with documentation but you have to say
>  > exactly what to do, not only say that do something... i cannot swim,
> so you
>  > cannot throw me in to a pool...
>
>
>
> I have reviewed thew examples of:
>
> - FbConnection
> - FbDataReader
> - FbDataAdapter
> - FbCommandBuilder
> - FbCommand
>
> and i vahe it commited to the CVS.
>
>
> Best regards
> Carlos Guzmán Álvarez
> Vigo-Spain
>

Re: [Firebird-net-provider] next problem

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

Hello:

> hi,
>
> when you plan to release patch??? any way, are you often commiting changes
> to CVS??? Is there bug fix for that record size problem???


It´s updated in the CVS.

>
>
> what are CVS parameters??? On source forge i found only Firebird.NET 
> (a .net
> data provider): CVS but it looks strange... I think that it is not correct
> project... So send me please server path and module name...


http://sourceforge.net/cvs/?group_id=9028

Module Net-Provider.

> Your pooling is nice, but it works only while assembly is in use... 
> when one
> project ends and garbage collector decide to trash your net provider, pool
> is flushed and destroyed... So if i want to create ASP.NET page i have to
> link assembly to global.asax and in this situation i can use only
> STAThreading... As i wrote, i have more than 20k hits to database in 
> hour it
> is more than 5 in sec... but sometimes it is more then 15hits/s... 
> simple i
> cannot use STAThreading... if i link assembly to each page, it is released
> each time processing of page is done... again useless for me...
> Im not forcing you to that... My be there is space for me...


Can help to this if i use MarshalByRefObject on the the pool??

> i know that you are making your assembly System.Data compatible and 
> therefor
> there are that overloads. I know that they are needed, but 
> documentation is
> not clear in this way... again may be space for me...


Why is not clear?? (i want to make it the mos clearly as possible), i 
think CHM is very nice.



Best regards
Carlos Guzmán Álvarez
Vigo-Spain

Re: [Firebird-net-provider] next problem

[Christoph D. <cd...@ar...>]

The firebrd.net project is mine.  It works by linking against the firebird c
libaries in a dll that is a mix of managed and unmanaged c++.  That dll is
then called by the provider which is written in vb.net.

It works and it was the best way I could think of to do it at the time but
it isn't the cleanest implemenation.


Christoph

----- Original Message -----
From: "Pavol Starek - PSZ" <pa...@st...>
To: <fir...@li...>
Cc: "Carlos Guzmán Álvarez" <car...@te...>
Sent: Monday, November 18, 2002 9:13 PM
Subject: Re: [Firebird-net-provider] next problem


> hi,
>
> when you plan to release patch??? any way, are you often commiting changes
> to CVS??? Is there bug fix for that record size problem???
>
> what are CVS parameters??? On source forge i found only Firebird.NET (a
.net
> data provider): CVS but it looks strange... I think that it is not correct
> project... So send me please server path and module name...
>
>
> Your pooling is nice, but it works only while assembly is in use... when
one
> project ends and garbage collector decide to trash your net provider, pool
> is flushed and destroyed... So if i want to create ASP.NET page i have to
> link assembly to global.asax and in this situation i can use only
> STAThreading... As i wrote, i have more than 20k hits to database in hour
it
> is more than 5 in sec... but sometimes it is more then 15hits/s... simple
i
> cannot use STAThreading... if i link assembly to each page, it is released
> each time processing of page is done... again useless for me...
> Im not forcing you to that... My be there is space for me...
>
> i know that you are making your assembly System.Data compatible and
therefor
> there are that overloads. I know that they are needed, but documentation
is
> not clear in this way... again may be space for me...
>
> thanx
> p.
>
> ----- Original Message -----
> From: "Carlos Guzmán Álvarez" <car...@te...>
> To: "Pavol Starek - PSZ" <pa...@st...>; "Firebird .Net Provider"
> <fir...@li...>
> Sent: Monday, November 18, 2002 11:39 AM
> Subject: Re: [Firebird-net-provider] next problem
>
>
> > Hello:
> >
> >  > Can you release a patch or something??? I have now time to play with
> > this assembly, so i can do lot of tests...
> >
> > I´m thinking on release an Alpha 4 version.
> >
> >  > next thing is: do you plan make it System.EnterpriseServices allowed
> > it is
> >  > important for performance... I plan to use your component on big
> ASP.NET
> >  > site (more than 20k hits a hour), but now it is unusable (pooling not
> >  > working as i have to do)...
> >  > My site was writen using COM+ objects in delphi. it was fast stable
and
> >  > scalable, but developing take to log, becouse you need to take care
> about
> >  > com+ logic more than your aplication logic... Net brings easy way how
> to
> >  > develob COM+ compliant assemblies and it is cool.
> >  > I can rewrite your code to make it thread safe, but it will be hard
for
> >  > me... very hard... without your help... And for now im not .NET guru,
> > so my
> >  > code will be not very nice...
> >
> >
> > I have no planned this, at this moment my intention is to have the
> > pooling working well. Here is an example on how the pooling is working
now
> :
> >
> >      FbConnection myConnection1 = new
FbConnection(GetConnectionString());
> >      FbConnection myConnection2 = new
FbConnection(GetConnectionString());
> >      FbConnection myConnection3 = new
FbConnection(GetConnectionString());
> >
> >      // Open two connections.
> >      Console.WriteLine ("Open two connections.");
> >      myConnection1.Open();
> >      myConnection2.Open();
> >
> >      // Now there are two connections in the pool that matches the
> > connection string.
> >      // Return the both connections to the pool.
> >      Console.WriteLine ("Return both of the connections to the pool.");
> >      myConnection1.Close();
> >      myConnection2.Close();
> >
> >      // Get a connection out of the pool.
> >      Console.WriteLine ("Open a connection from the pool.");
> >      myConnection1.Open();
> >
> >      // Get a second connection out of the pool.
> >      Console.WriteLine ("Open a second connection from the pool.");
> >      myConnection2.Open();
> >
> >      // Open a third connection.
> >      Console.WriteLine ("Open a third connection.");
> >      myConnection3.Open();
> >
> >      // Return the all connections to the pool.
> >      Console.WriteLine ("Return all three connections to the pool.");
> >      myConnection1.Close();
> >      myConnection2.Close();
> >      myConnection3.Close();
> >
> > What are the params of your connection string???
> >
> >  > Next thing is, that documentation is greate (very complex), but
> > somethimes
> >  > it is not good :-)  you done there lot of overloaded methods and
> >  > constructors and not all are working in any way of use...
> >
> >
> > Why?? All overloaded constructors are needed, if you see documentation
> > of SqlClient, OleDb or ODBC .Net data providers you will see probably
> > the same.
> >
> >  > Some examples are obsolete (you have there examples without
> > transactions) and so... I want to help you with
> >  > this project. May be i can start with documentation but you have to
say
> >  > exactly what to do, not only say that do something... i cannot swim,
> > so you
> >  > cannot throw me in to a pool...
> >
> >
> >
> > I have reviewed thew examples of:
> >
> > - FbConnection
> > - FbDataReader
> > - FbDataAdapter
> > - FbCommandBuilder
> > - FbCommand
> >
> > and i vahe it commited to the CVS.
> >
> >
> > Best regards
> > Carlos Guzmán Álvarez
> > Vigo-Spain
> >
>
>
>
>
> -------------------------------------------------------
> This sf.net email is sponsored by: To learn the basics of securing
> your web site with SSL, click here to get a FREE TRIAL of a Thawte
> Server Certificate: http://www.gothawte.com/rd524.html
> _______________________________________________
> Firebird-net-provider mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

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