Re: [Firebird-net-provider] Parameterized Query

2007-04-19 Thread André Knappstein , Controlling
dré Knappstein, Controlling PD> Sent: Thursday, 19 April 2007 6:15 PM PD> To: [email protected] PD> Subject: Re: [Firebird-net-provider] Parameterized Query PD> Peter, PD> not an expert myself, but in your code I am missing a statement like: PD> daDuePack

Re: [Firebird-net-provider] Parameterized Query

2007-04-19 Thread Peter Dennis
07 6:15 PM To: [email protected] Subject: Re: [Firebird-net-provider] Parameterized Query Peter, not an expert myself, but in your code I am missing a statement like: daDuePacks.SelectCommand = FbCmdDuePacks; so far you are setting the parameter to the command-object,

Re: [Firebird-net-provider] Parameterized Query

2007-04-19 Thread André Knappstein , Controlling
Peter, not an expert myself, but in your code I am missing a statement like: daDuePacks.SelectCommand = FbCmdDuePacks; so far you are setting the parameter to the command-object, and to the adapter-object you are just "copying" the select command text. Don't know if that is the culprit in your

[Firebird-net-provider] Parameterized Query

2007-04-18 Thread Peter Dennis
Hi, I am trying to use a parameter in one of my queries but consistently get the following error: FbException was unhandled Must declare command parameters. With this statement highlighted: daDuePacks.Fill(m_dsDocoInfo, "DuePacks") When I load the following form: Private Sub frmSignUpPack_Load(