Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Pass a FALSE to a SQL Server stored procedure
Message
From
05/03/1998 13:14:21
Claudio Abad
Compañía Financiera Argentina
Buenos Aires, Argentina
 
 
To
05/03/1998 12:33:18
Steve Camsell
Windmill Associates
Bath, United Kingdom
General information
Forum:
Visual FoxPro
Category:
Client/server
Miscellaneous
Thread ID:
00082731
Message ID:
00082747
Views:
27
>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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform