Thank you André!!!! Works perfectly!
I don't really understand your explanation. I suppose I really don't understand why it is possible to retrieve data from the database when the query has no parameters without the addition of your below suggestion. And why I need the extra line when the query uses parameters. If possible could you give me some more information to improve my understanding of this? Thanks for your time, Peter. -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of André Knappstein, Controlling Sent: Thursday, 19 April 2007 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, and to the adapter-object you are just "copying" the select command text. Don't know if that is the culprit in your case, but does it get better, if you add the above command line?? ciao, André > Hi, > > I am trying to use a parameter in one of my queries but consistently get the > following error: > 'Prepare adapter to retrieve information from db. > Dim daDuePacks As New FbDataAdapter(sDuePackSelect, conn) > 'Add table to the Module based dataset. > daDuePacks.Fill(m_dsDocoInfo, "DuePacks") > Can someone please tell me what I'm doing wrong? ------------------------------------------------------------------------- This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/ _______________________________________________ Firebird-net-provider mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/firebird-net-provider ------------------------------------------------------------------------- This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/ _______________________________________________ Firebird-net-provider mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
