General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
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?
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only