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

>What following returns:
>

>result = ''
>NewObjectID  = 0
>cQuery = ;
>	[EXEC addObject] + ;
>	[ @objectname= '] + ALLTRIM(tmpProducts.prcode) + ['] + ;
>	[,@objecttype= 'P']
>* may be caused by Question marks in the cQuery!
>nResult = SQLExec(x.GETnHandle(), cQuery)
>IF nResult < 0
>  AERROR(laError)
>  MessageBox(laError[1,2])
>ENDIF
>

>