On Sat, Jun 27, 2009 at 5:15 AM, Jiri Cincura <disk...@cincura.net> wrote:
> On Fri, Jun 26, 2009 at 17:47, Sam Carleton<scarle...@gmail.com> wrote: > > Like I said before, when I go in and code up the FbCommand by hand and > > set the CommandText to "SELECT * FROM GET_TARGETTABLE_BY_ID_SP( ?, > > ?)", CommandType to Text, and set the parameters manually, it works > > fine. I am looking to do this via the IDE. > > The ? isn't param identifier in .NET. in .NET the @param is well known > "standard". FirebirdClient accepts also ? as it's a Firebird standard. > But you should avoid using it. > I thought I had another solution working, but that solution blow up today, so I am back:) I have tried making the command "Text" and setting the SQL to: SELECT * FROM UDA_GET_QUESTIONITEM_BY_ID_SP(@ID, @ACTUAL_VERSION) I am getting an error: Error Source: FirebirdSql.Data.firebirdClient Error Message: Must declare command parameters. Please see the attached screen shot, I did circle in red the DataAdapter command I am working on. Sam
<<attachment: Untitled.png>>
------------------------------------------------------------------------------
_______________________________________________ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
