Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Parameters in a stored procedure
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Divers
Thread ID:
01121840
Message ID:
01121852
Vues:
24
This message has been marked as the solution to the initial question of the thread.
Try:
Result= NULL
NewObjectID= NULL
cQuery = ;
	[EXEC addObject] + ;
	[ @objectname = '] + ALLTRIM(tmpProducts.prcode) + [',] + ;
	[ @objecttype = 'P',] + ;
	[ @Result = ?m.Result,] + ;
	[ @NewObjectID = ?m.NewObjectID]
>Borislav,
>
>Thanks! I didn't think about this. I tried your suggestion and it is returning:
>"Connectivity error: [Microsoft][ODBC SQL Server Driver][SQL Server]Must declare the variable '@Result'."
>
>I am changed my update to:
>
>Result= NULL
>NewObjectID= NULL
>cQuery = ;
>	[EXEC addObject] + ;
>	[ @objectname = '] + ALLTRIM(tmpProducts.prcode) + [',] + ;
>	[ @objecttype = 'P',] + ;
>	[ @Result,] + ;
>	[ @NewObjectID]
>
>
>
>But the result it still the same.
>Can you give me a hint on how to do this.
>
>Thanks in advance,
>Ron Brahma
>
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform