I can't get this to post with the attachments since they are over the 40K limit.
I can send the gifs to anyone who wants to see them. Rick -----Original Message----- From: Rick Roen [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 17, 2006 11:51 AM To: 'For users and developers of the Firebird .NET providers' Subject: RE: [Firebird-net-provider] Params for stored procedure (Jiri, sorry, I didn't mean to reply to you directly, I just pressed the reply and did not check the destination) Jiri, Sorry I'm completely new to .net and don't have any C# experience. Here is how I get to the error: In the dataset tab *.xsd, I right click and select Add - Table Adapter The Table Adapter configuration wizard comes up I select the connection Next, Next I check the "Use existing stored procedures" radio button Next In the combobox for "Select" I select "P_MOD" Next, Next, Finish Now I have a DataTable and TableAdapter like below. Then I right click on the TableAdapter and select preview, fill in the params and get the error like below. How are you entering the "Select * from P_MOD(10,2)"? If I try to enter this SQL after creating a new TableAdapter, I get the third error below. Rick -----Original Message----- From: Jiri Cincura [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 17, 2006 10:49 AM To: [EMAIL PROTECTED]; For users and developers of the Firebird .NET providers Subject: Re: [Firebird-net-provider] Params for stored procedure Rick Roen wrote: > Then in VB.NET 2005 Pro I add a new table adapter in the Select using this > sp. Then when I right click for Preview and fill in the data, InNum1=10 and > InNum2=2 I get the error message. Can you be more specific, i.e. the select what you use? As you can see in att. I've no problem with this - select * from p_mod(10,2); Cause I'm not able to get the error working for me. BTW If you can, create some C# example and send it to me. > The connection string to the DB is > > character set=ISO8859_1;data source=localhost;initial > catalog=C:\CompanyData\Firebird\CORNUCOPIA.FDB;user > id=SYSDBA;password=masterkey;role=FULL_ACCESS;returnrecordsaffected=True;ser > vertype=Default > I am using Firebird 1.5.3 super server. > > I can make a new FB db with just this sp if that would be more helpful. > > If I use the same connection and create a new table adapter for a select > statement against a table I have no problem previewing the data. > > Let me know if you need anything else. > > Rick > > > -----Original Message----- > From: Jiri Cincura [mailto:[EMAIL PROTECTED] > Sent: Tuesday, October 17, 2006 5:36 AM > To: [EMAIL PROTECTED]; For users and developers of the Firebird .NET > providers > Subject: Re: [Firebird-net-provider] Params for stored procedure > > Rick Roen wrote: >> But I don't think that could be the problem anyway since I get the same >> error when I call an sp that has only two input params - both integers > with >> an integer return value. >> > > Can you provide some test for us, to be able to test it on our builds? > -- Jiri {x2} Cincura http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com ------------------------------------------------------------------------- Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642 _______________________________________________ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
