RE: [Firebird-net-provider] .NET Provider RC2

[Peter W. <Pe...@af...>]

Hi, Carlos -=20

I get the same problem using your code - the call to reader.Read() hangs the
app/never returns in the IDE.  It must be something specific to my computer,
and I will try on another machine.  Thanks for your time spent on this. =20

Regards,
Peter


-----Original Message-----
From: Carlos Guzman Alvarez [mailto:car...@te...]=20
Sent: 30 April 2003 18:41
To: Peter Wood
Cc: 'fir...@li...'
Subject: Re: [Firebird-net-provider] .NET Provider RC2


Hello:

> The users table has data, which is returned running the same query in=20
> isql. The same thing happens if there is no data in the table.  I am=20
> using Firebird 1.5 Beta 4 - is this OK?


I'm testing with this sample, and all goes OK:

FbConnection connection =3D new FbConnection(connectionString);

connection.Open();

FbTransaction transaction =3D connection.BeginTransaction();

string selectText =3D "SELECT * FROM users ";
				=09
FbCommand select =3D new FbCommand(selectText, connection, transaction);
					=09
FbDataReader reader =3D select.ExecuteReader();
								=09
while (reader.Read())
{
	Console.WriteLine("{0} {1} {2}",
	                 reader.GetValue(0),
	                 reader.GetValue(1),
	                 reader.GetValue(2));
}
		=09
reader.Close();
transaction.Commit();
connection.Close();


--=20
Best regards

Carlos Guzm=E1n =C1lvarez
Vigo-Spain

"No tengo dones especiales.S=F3lo soy apasionadamente curioso" Albert
Einstein, cient=EDfico.


**********************************************************************
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.

This footnote also confirms that this email message has been swept by
MIMEsweeper for the presence of computer viruses.

www.mimesweeper.com
**********************************************************************