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.