>>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
SQLEXEC(c, [sp_NewCustomer 0])
should work also.
-Mike