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
>