I keep getting the "Object must implement IConvertible" error using any of the DAAB access methods. I'm using DAAB v.2.0. I'm guessing I'm doing something stupid, but after a lot of experimentation I'm not getting anywhere. Any help is appreciated.

// Inputs: keyFieldValue = "200"
// strTableName = "Table55"

public DataRow FindRow( string keyFieldValue, string strTableName)
{
SqlConnection conn = new SqlConnection();
conn.ConnectionString = ConnectionString;
conn.Open();

string procName = "Get" + strTableName;

SqlCommand cmd = new SqlCommand(procName, conn);
cmd.CommandType = CommandType.StoredProcedure;

SqlParameter [] arParms = new SqlParameter[2];

arParms[0] = new SqlParameter("@KeyFieldValue", SqlDbType.NVarChar, 20);
arParms[0].Value = keyFieldValue;

arParms[1] = new SqlParameter("@FirstRow", SqlDbType.Binary );
arParms[1].Value = 0;

object foundObj = SqlHelper.ExecuteScalar(ConnectionString, "Get" + strTableName,
arParms);

if (foundObj != null)
return (DataRow) foundObj;
else
return null;
}

PROCEDURE dbo.GetTable55
(
@KeyFieldValue nvarchar(20) = null,
@FirstRow bit = 0
)
AS
IF @FirstRow = 0
SELECT * FROM Table55 WHERE CCC_Plan_Sequence = CAST(@KeyFieldValue AS float)
ELSE
SELECT TOP 1 * FROM Table55
/* SET NOCOUNT ON */
RETURN

You are using a SqlParameter object array, but calling the overloaded method of ExecuteScalar that takes a generic object array.

You need to call the following method:

SqlHelper.ExecuteScalar(ConnectionString, CommandType.StoredProcedure, GetTable55, arParms)

-Weston

---

Weston Binford

Trason Consulting, Inc.

[email protected]

(yes, it is a real e-mail address)

Weston,

Thanks!! I knew it was something obvious. I just couldn't find it. I'll move onto the next stupid thing.

-- Jeff