As Bret answered it's correct.
Remember that you can get only a maximum of 254 char lenght string from a stored procedure. I tried without success to get anything else so that i had to think about something different to overrun this.
If you can let me know :-)
>>Hi Bret.
>>
>>>So my question is what do I need to provide to the oCommand object to execute my Stored Procedure called GetKey (with the table name parameter) and get the key returned to me?
>>
>>Use code similar to the following:
oCommand.CommandType = 8
>>oCommand.CommandText = "GetKey()"
>>oRS = oCommand.Execute()
>>lnNewKey = oRS.Fields('Return_Value').Value
Doug
>
>Since my GetKey needs a parameter I would call:
>
>oCommand.CommandText = "GetKey('TableName')"
>
>Is this correct?