Borislav,

having done some tuning I have noticed that something is still not functioning properly.
Your solution worked fine and the error is gone. The problem, however, is that the values that should be returned by SQL-server are not retrieved by VFP.
> [ @Result = ?m.Result,] + ;
> [ @NewObjectID = ?m.NewObjectID]
Both of them are empty. Checking with the profiler does show that SQL-server is setting them:
-- AddObject
set @NewObjectID = 200000
and
-- AddObject
set @Result = 'Object of type ' + @ObjectType + ' and name ' + @ObjectName + ' added to the database, key: ' + STR(@NewObjectID)

Do you have any suggestion on why this is happening?

Thanks for you help.

Regards,

Ron Brahma

>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
>>