Hello Marek Thank you for this workaround. I'll try it with delete too. I've sent a test case to Carlos, maybe he can give us a more elegant solution.
Maurcio. ""marzena"" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Hi Mauricio, > > Few days ago I got similar exception of type ArgumentNullException. I have > found out this conclusion.. > > Unfortunately the Provider checks whether SourceColumn property is filled > with some string and if not it throws an exception. So my solution was > very > simple - I had mapped my "trouble-making-parameter" to some of my column > (the value of the parameter is changed on the RowUpdating event), in order > to satisfy the Provider and make it execute the command. > > Hope this will help you > > Btw. Maybe that Carlos will give us some better advice how to manage such > situation (Parameter with no SourceColumn)... > > Regards > > Marek Leitl > >> Date: Thu, 5 Oct 2006 15:48:58 -0300 >> From: "Mauricio I. Magni" <[EMAIL PROTECTED]> >> Subject: [Firebird-net-provider] Update parameter without SourceColumn >> To: [email protected] >> Message-ID: <[EMAIL PROTECTED]> >> >> Hello >> >> I'm using NetProvider 2.0.1 RC1 and Firebird 2.0 RC4. >> >> I'm trying to update a datatable with a store procedure, one >> sp's parameters >> is a SessionID, I want this parameter take a value from a >> SessionManager >> object instead of a table's column. >> >> When i build the command use >> param = _updateCommand.Parameters.Add("@Session_Id", >> FbDbType.Integer, 0); >> param.Value = SecurityDal.Instance.SessionId; >> >> The trouble raises when executing >> adapter.Update(table); >> >> This command throws an exception with the message >> "SourceColumn is required >> to be a non-emtpy string. Parameter name: sourceColumn." >> >> Could anybody point me in the right direction? >> >> Thanks in advance. >> Mauricio I. Magni. > > > > ------------------------------------------------------------------------- > 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 > [email protected] > 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 [email protected] https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
