Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Pass a FALSE to a SQL Server stored procedure
Message
De
05/03/1998 13:14:21
Claudio Abad
Compañía Financiera Argentina
Buenos Aires, Argentine
 
 
À
05/03/1998 12:33:18
Steve Camsell
Windmill Associates
Bath, Royaume Uni
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Divers
Thread ID:
00082731
Message ID:
00082747
Vues:
32
>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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform