>Can anyone tell me how to pass a FALSE to a stored procedure in SQL Server. At the moment I am trying the following syntax from the query window in SQL Server, when I get that to work I will run it trough an SQLEXEC:
>
>sp_NewCustomer (0)
>
>I keep getting the following error message:
>
>Msg 170, Level 15, State 1
>Line 1: Incorrect syntax near '0'.
>
>My stored procedure is expecting to recieve one parameter of type BIT. This may turn out to be something really basic, but I just can't figure it out.
From WIsql application, follow the next sintaxis
sp_NewCustomer 0
From VFP program try with:
lmyvar=.f.
=sqlexec(ncon,'sp_NewCustomer ?lmyvar')
I Hope this help you
Excuse me English
I learn slowly