Hi Dan,

Here's how it can be done.

cTablename = "Myatable"
cYear = ""
? Sqlexec(lnSQLHandle, [EXEC uspGetMaxYear ?cTablename, ?@cYear])

Notice, that the first parameter '?cTablename' is input parameter and the second '?@cYear' is output parameter.

>To All,
>
>I have a stored procedure in SQL 2000:
>uspGetMaxYear @strTable CHAR(20),@strYear CHAR(4) OUTPUT
>
>What is the proper syntax in VFP7 SQLPassthrough?
>SQLEXEC(lnSQLHandle,?)
>
>TIA,
>
>Dan Rhymes