>>>>>>Hi,
>>>>>>
>>>>>>Sorry - missed this message. Don't use Update command. Here's an example that you should be able to adapt. VFP SPs:

PROCEDURE SetUserName
>>>>>>LPARAMETERS cUserName
>>>>>>PUBLIC UserName
>>>>>>UserName = cUserName
>>>>>>ENDPROC
>>>>>>
>>>>>>FUNCTION WhoIsCurrentUser
>>>>>>  RETURN UserName
>>>>>>ENDFUNC

>>>>>>
>>>>>>.NET test code:

       static void Main(string[] args)
>>>>>>        {
>>>>>>            //Set public variable when setting up the connection
>>>>>>            System.Data.OleDb.OleDbConnection myConn = ConnectionProvider.CreateConnectionForUser("Jim");
>>>>>>
>>>>>>            // Now see if the public variable is accessible by SP
>>>>>>            System.Data.OleDb.OleDbCommand test = new System.Data.OleDb.OleDbCommand();
>>>>>>            test.Connection = myConn;
>>>>>>            test.CommandText = "WhoIsCurrentUser()";
>>>>>>            string s = (string) test.ExecuteScalar();
>>>>>>        }
>>>>>>    }
>>>>>>
>>>>>>
>>>>>>    static class ConnectionProvider
>>>>>>    {
>>>>>>        static public System.Data.OleDb.OleDbConnection CreateConnectionForUser(string sUser)
>>>>>>        {
>>>>>>            string connection = "Provider=VFPOLEDB.1;Data Source=Data1.dbc";
>>>>>>            System.Data.OleDb.OleDbConnection oledb = new System.Data.OleDb.OleDbConnection(connection);
>>>>>>            oledb.Open();
>>>>>>
>>>>>>            System.Data.OleDb.OleDbCommand command = new System.Data.OleDb.OleDbCommand();
>>>>>>            command.Connection = oledb;
>>>>>>            command.CommandText = "SetUserName('" + sUser + "')";
>>>>>>            command.ExecuteNonQuery();
>>>>>>             return oledb;
>>>>>>        }
>>>>>>    }

>>>>>>
>>>>>>HTH,
>>>>>>Viv
>>>>>
>>>>>Hi Viv,
>>>>>
>>>>>I don't think this
>>>>>
>>>>>command.CommandText = "SetUserName('" + sUser + "')";
>>>>>
>>>>>is going to work.
>>>>
>>>>Hi,
>>>>Why not?
>>>
>>>May be I'm wrong, but I think in CommandText you can only specify the SP name and you have to pass your parameter through Parameters collection of the Command object.
>>
>>Worked for me :=}
>
>It was not supposed to :)
>
>http://forums.asp.net/t/1350800.aspx

Looks like that's SQLServer. This is VFP provider