William,
Try:
lcFind = SPACE(8)
The output parameter you send to the sproc needs to be of the same type and length.
HTH
>Daniel, a while ago you gave me this information on passing output parameters to SQL 7.
> I have a stored procedure that I have created and I want it to return to me a number when it is found.
>
>Here is the test call I created:
>
>lcSSfno = '8726273'
>lcFind = " "
>lnExec = SQLEXEC(lnConn,"Exec sp_seek_ssfno ?lcssfNo,?@lcFind")
>
>Here is the stored procedure:
>
>CREATE PROCEDURE sp_seek_ssfno
>
>@ssfno CHAR(10),
>@lnFound CHAR(10) OUTPUT
>
> AS
>
>
>SELECT @lnFound = (SELECT ssfno FROM tranhdr WHERE ssfno = @ssfno)
>The problem is I am only getting one character returned.
>
>Ex: The number captured into lnFound = '8726273'
>The return value I get is '8'. What am I doing wrong, not to get the entire number?
Daniel