search

FirebirdSQL / NETProvider

Firebird ADO.NET Data Provider
https://www.firebirdsql.org/en/net-provider/
Other
152 stars 63 forks source link

Column unknown error when calling a stored procedure [DNET67] #79

Closed firebird-automations closed 17 years ago

firebird-automations commented 17 years ago

Submitted by: Ervin Kleinschmidt (emagic)

Assigned to: @carlosga

Column unknown error when calling a stored procedure in microsoft visual studio 2005 using DDEX. In my dataset oject I have a datatable oject with a tableadapter object pointing to the stored procedure. It looked up input and out fields correctly other than field type when walking thru the wizard. I tried it with leaving field types as objects as well as changing them to what they should be. If I run object in DDEX as a preview it works perfect but when I try and use the object in code it fails. I have made a stored procedure that just return a couple fix fields just to rule out a code issue. I also noticed that the firebird client RC2 is installing as RC1. I installed noticing it mentioned issues with stored procedures.

Here is the simple Stored Procedure.

SET TERM ^^ ; CREATE PROCEDURE ERV_TEST ( POID Integer, PCUSTID Integer) returns ( ROID Integer, RCUSTID Integer) AS /* test */ begin roid = 1; rcustid = 2; SUSPEND;

end ^^ SET TERM ; ^^

Here is the call

Me.NewRecipientStoredProcedureTableAdapter.GetData(1,2)

firebird-automations commented 17 years ago

Commented by: Ervin Kleinschmidt (emagic)

I figured this out. The DDEX does not put an '@' in the input Parameters names it creates. I changed the names manualy and it works. I also notice integers go to size 4 and give errors if you enter something larger than 4 digets. If you change them to be larger on the input Parameters all works.

firebird-automations commented 17 years ago
Modified by: @carlosga status: Open \[ 1 \] =\> Closed \[ 6 \] resolution: Won't Fix \[ 2 \]