Thanks for the reply.
This is an option I have thought about but it would involve a change to every store
procedure and
every corresponding dataobject. My question was more why this would have to be done as
it was not an issue in ND 3 ?
I'm sure somebody has come across this one before.
Thanks,
Pat.
"Mathew, Aby" <[EMAIL PROTECTED]> wrote:
>How is the return parameter different from any other output parameter? Why>can't you
>just make it a parameter of type output?
>
>Aby
>
>> -----Original Message-----
>> From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
>> Sent: Tuesday, April 20, 1999 11:44 AM
>> To: [EMAIL PROTECTED]
>> Subject: [ND] Return codes with Sybase Store Procedure
>>
>> I am currently migrating an ND3 project to ND4.
>> In ND3 my dataobjects that executed my Sybase store procedures all had
>> return parameters.
>> However, when I try to execute them in ND4 then I got an error telling me
>> that
>> 'there is a mismatch between the parameter schema and the actual output
>> schema'
>>
>> When I removed the return code parameter I no longer got the above error.
>> However, this removed parameter was referenced in code to see if there was
>> any problems
>> with the execution of the procedure. Does anyone know a way of checking
>> the return code value.
>>
>> For example.
>> The Parameters in the data object had four parameters defined.
>> Two input, one output and one of return type and the store procedure was
>> defined as follows (see attached for store procedure)
>>
>> CREATE PROC proc_nextnumber(@tblName varchar(30),
>> @fldName varchar(30),
>> @nextNum int output).
>>
>>
>> Any help would be appreciated,
>> Pat.
>>
>>
>> Any help would be appreciated,
>> _________________________________________________________________________
>>
>> For help in using, subscribing, and unsubscribing to the discussion
>> forums, please go to: http://www.netdynamics.com/support/visitdevfor.html
>>
>> For dire need help, email: [EMAIL PROTECTED]
_________________________________________________________________________
For help in using, subscribing, and unsubscribing to the discussion
forums, please go to: http://www.netdynamics.com/support/visitdevfor.html
For dire need help, email: [EMAIL PROTECTED]
