Re: [Firebird-net-provider] Params for stored procedure

2006-10-17 Thread Jiri Cincura
> read the datatype from the DB server anyway and do an automatic conversion. It should, but DDEX stuff isn't so easy to control :) -- Jiri {x2} Cincura http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com - Using Tomc

Re: [Firebird-net-provider] Params for stored procedure

2006-10-17 Thread Rick Roen
lf Of Jiri Cincura Sent: Tuesday, October 17, 2006 12:13 PM To: [EMAIL PROTECTED]; firebird-net-provider@lists.sourceforge.net Subject: Re: [Firebird-net-provider] Params for stored procedure Rick Roen wrote: > Then I right click on the TableAdapter and select preview, fill in the > params

Re: [Firebird-net-provider] Params for stored procedure

2006-10-17 Thread Jiri Cincura
Rick Roen wrote: Then I right click on the TableAdapter and select preview, fill in the params and get the error like below. Look at the att. You have to change the type of params to Int64 according to your definition in DB, not the Object as you have. How are you entering the “Select * fro

Re: [Firebird-net-provider] Params for stored procedure

2006-10-17 Thread Jiri Cincura
iders 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

Re: [Firebird-net-provider] Params for stored procedure

2006-10-17 Thread Rick Roen
al 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 co

Re: [Firebird-net-provider] Params for stored procedure

2006-10-17 Thread Jiri Cincura
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:

Re: [Firebird-net-provider] Params for stored procedure

2006-10-17 Thread Rick Roen
t-provider] Params for stored procedure Hello: > > Any ideas? > The sp returns any blob ?? > > - Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-inte

Re: [Firebird-net-provider] Params for stored procedure

2006-10-16 Thread Carlos Guzmán Álvarez
Hello: > > Any ideas? > The sp returns any blob ?? > > - 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

Re: [Firebird-net-provider] Params for stored procedure

2006-10-16 Thread Jiri Cincura
Charset definition? -- 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 techno

[Firebird-net-provider] Params for stored procedure

2006-10-16 Thread Rick Roen
VB.Net 2005 FB 1.5   I have created a table adapter in a project for a stored procedure in my database.   I used the connection xsd work space and right clicked + Add to create the DataTable and TableAdapter components.  The TableAdapter has a Fill and GetData method like   GetData(I