Send me Stored Procedure Code, may be I can help you, and error number returned to VFP

>Thanks very much Claudio, I've got it working just fine from Sequel, I've just got to get it to work in an SQLEXEC() now. When I try the syntax that you suggested, I just get a -1 back from SQLEXEC(). This seems to be the same whether I use a variable with FALSE stored in it, or I try to directly send a 0 or a .F.. Never mind, I'll keep trying!
>
>BTW, the set of stored procedures that you passed on to be were extremely useful and gave me lots of good ideas.
>
>Thanks again for your help.
>
>
>>>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