On Sat, Jun 27, 2009 at 5:15 AM, Jiri Cincura <[email protected]> wrote:
> On Fri, Jun 26, 2009 at 17:47, Sam Carleton<[email protected]> 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 [email protected] https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
