If I give parameter by name it works. I can't use names because ExecuteSQL is for multiple sql statements with different param name. I can' control param name. It could be very usefull if in FBCommand sould have FbCommand.Parameters.Add(int position, FbParameter value); This way I could assign value without knowing param name, only his position sql statement!
Regards, Paul > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf > Of Intelrullz > Sent: Thursday, March 01, 2007 6:34 PM > To: Mercea Paul > Subject: [Firebird-net-provider] Îòã: Running parametrised query > > Have you tried : > fbc.Parameters.Add("@artnew",param1); //same for param2 :) > I believe you get your error because fbc.Parameters is not yet > initialized > ...i think the Add() is the correct way to include parameters ... > And btw ...don`t forget to .Clear the parameters before Adding the ones > for > the new query (i tend to clear and reAdd everything i need to ...) ... > Hope i helped :) . > > ________________________________________________ > Message > sent by <a href='http://mail.data.bg'>Data.BG WebMail</a> > > > ----------------------------------------------------------------------- > -- > Take Surveys. Earn Cash. Influence the Future of IT > Join SourceForge.net's Techsay panel and you'll get the chance to share > your > opinions on IT & business topics through brief surveys-and earn cash > http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVD > EV > _______________________________________________ > Firebird-net-provider mailing list > Firebird-net-provider@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/firebird-net-provider ------------------------------------------------------------------------- Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT & business topics through brief surveys-and earn cash http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV _______________________________________________ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
