Re: [Firebird-net-provider] Delphi and stored Proc

[Carlos G. A. <car...@te...>]

Hello:


I'm making test with C# without here is my test case:


	FbTransaction	myTransaction;
	FbConnection	myConnection = new FbConnection(connectionString);

	myConnection.Open();

	myTransaction = myConnection.BeginTransaction();

	FbCommand myCommand = new FbCommand("EXECUTE PROCEDURE 
GETVARCHARFIELD(?)", myConnection, myTransaction);

	myCommand.CommandType = CommandType.StoredProcedure;

	myCommand.Parameters.Add("@INT_FIELD", FbType.Integer).Direction = 
ParameterDirection.Input;	
	myCommand.Parameters[0].Value = 1;

	myCommand.Parameters.Add("@VARCHAR_FIELD", FbType.VarChar).Direction = 
ParameterDirection.Output;

	myCommand.ExecuteNonQuery();

	Console.WriteLine(myCommand.Parameters[1].Value);

	myTransaction.Commit();

	myConnection.Close();

	Console.ReadLine();


And this is my test SP:

CREATE PROCEDURE GETVARCHARFIELD (
     ID INTEGER)
RETURNS (
     VARCHAR_FIELD VARCHAR(100))
AS
begin
     for select varchar_field from test_table_01 where int_field = :id 
into :varchar_field
     do
         suspend;
end



-- 
Best regards

Carlos Guzma'n A'lvarez
Vigo-Spain

"No tengo dones especiales.So'lo soy apasionadamente curioso"
Albert Einstein, cienti'fico.