You need to pass a select statement to the Toolkit's SQLExecute function. It then returns a filled DataView. This function is not intended to pass an Update statement. This is being considered to be revised for a future update to the toolkit.

>Here is the code.
>
>********* Save Routine *****
> ' Set up connection and command
> Dim oconn As System.Data.OleDb.OleDbConnection
> Dim oCommand As New OleDbCommand()
>
> ' passing parameter to stored procedure
> ' I have tried both Char and VarChar for OLEdb
> Dim oparam1 As New OleDbParameter("@cssn", OleDb.OleDbType.VarChar)
>
> ' gcpuem is a memvar which contains the connectin string
> oconn = SqlConnect(gcPuem)
>
> oCommand.CommandType = CommandType.StoredProcedure
>
> ' _TestUpdate is the SP being called, code is below.
> oCommand.CommandText = "_TestUpdate"
>
> oCommand.Parameters.Clear()
> 'storing employee ssn, value is 000110000
> oparam1.Value = Me.txtcssn.ClipText
> oCommand.Parameters.Add(oparam1)
>
> ' Bug in ToolKit, should be fixed in future release but need this
> ' code for now.
> oCommand.Connection = oconn
>
> ' Tried both of the following lines with the same results.
> ' gvEmployee = SqlExecute(oconn, oCommand) ', "curEmployee")
> SqlExecute(oconn, oCommand)
>
> ' Close the connection
> SqlDisConnect(oconn)
>
>
>*** Stored Procedure Code ***
>
>CREATE PROCEDURE _TestUpdate
>' Test SP only!
>@cssn as char(9)
>
>AS
>
>update pclaim set cssn = @cssn where pid = 2
>GO