Your statement should look like this:
sqlexec(gn_handle,
'EXECUTE byroyalty @percentage='+ALLTRIM(STR(nPercentage))
,'my_return')
>How do you pass to a stored procedure a param?
>
>I can sqlexec( gn_handle, 'execute my_stored_proc','my_return')
>
>But when my_proc has an param I cant send it.
>
>I've tried the SQLPREPARE() as the help file shows but that won't work and return data period.
>
>I am working with the pubs database and the byroyalty stored procedure as a test. My data is similar so this is an easy attempt.
>
>I want to pass 100 to byroyalty and get the list back from it.
>
>Any takers out there?
>
>__Stephen Russell
Eric Shaneson
Cutting Edge Consulting