Hi:

I have this stored procedure in SQL7:

CREATE procedure spGetCases @caseid int
as
select * from cases where pk_cases = @caseid

I would like to pass a parameter to it from VFP.

This works:
= sqlexec(1, '{call spGetCases(86164)}')

I want to pass parameter as variable like:
x=86164
= sqlexec(1, '{call spGetCases(x)}')
- doesn't work

also tried, but doesn't work:
= sqlexec(1, '{call spGetCases(@x)}')
= sqlexec(1, '{call spGetCases(cases.pk_cases)}')

How do you do this?

Charlie