Can you post the code that shows how you call SP and pass parameters?

>Hi all,
>
>I am trying to run a stored procedure on a Sql Server which takes takes several parameters and writes a new record to a table from the parameters supplied.
>
>Some of the Fields in the SQL table are of type "tinyint". When I try to run the stored procedure, I get an error message back from the ODBC driver "Error converting data type nvarchar to tinyint"
>
>The underlying problem, I know is that foxpro's INT datatype is 4 bytes and tinyint's are 1 byte. Does anyone know how to pass the parameters correctly.
>
>I think I may have to write a VB Com component to run the Stores procedures for me.. But I would prefer to do it in VFP if possible.
>
>Any help would be much appreciated
>
>Thank You
>
>Gerry McDermott