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 Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider