Hello all,

With VFP 8 and SQL Server 2005 CTP:

I need to pass a null value from VFP to call a SQL Server SP, but this parameter is declared as OUTPUT, and in fact, it must return a specific value.

Let's assume this VFP code:

lcVar = .NULL.
lnExec = SQLEXEC(lnH, 'Exec sp_test ?@lcVar')

When testing lnExec < 0, the error message is:
1526 Connectivity error Microsoft][ODBC SQL Server Driver] Invalid character value for cast specification

Is there any error in this logic? or any additional syntax required?

The argument is declared like this:
@cState char(7)=NULL OUTPUT


The stored procedured runs without errors from SQL Query analizer and it accepts the null value, but I keep receiving the error message when trying from VFP.

Thanks for any comment.

Juan C.