Re: [Firebird-net-provider] Update parameter without SourceColumn

[VS-Polis]

Hello, is it possible that you don't call the sproc's parameters in the correct sequence? For instance: sproc expects the SessionID as first parameter; but via updateCommand.Parameters.Add() you set it as the last parameter - e.g. at position 2? Hope it helps. Greetings from Germany Juergen Mauricio I. Magni schrieb: 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. -- Jürgen Thomas Verlags-Software Samländische Str. 3 13189 Berlin Tel.     (030)      94 39 96 38 oder   (0700)    VS–POLIS d.h.     (0700)  87 07 65 47 Fax     (030)      94 39 96 40 http://www.vs-polis.de

-------------------------------------------------------------------------
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
_______________________________________________
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider