Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL passthrough when error is a unique key violation.
Message
From
18/06/2001 16:13:05
 
 
To
18/06/2001 15:37:10
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00512889
Message ID:
00520755
Views:
11
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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform