Thread View: borland.public.cppbuilder.database.ado
4 messages
4 total messages
Started by sylvain cochepain
Wed, 10 Jan 2001 16:41
Retrieve Output parameters from TADOStoredProc
Author: sylvain cochepain
Date: Wed, 10 Jan 2001 16:41
Date: Wed, 10 Jan 2001 16:41
8 lines
1036 bytes
1036 bytes
Hi, I can't retrieve the value of output parameter in my TADOStoredProc (I get 0 for a simple int parameter). Is it a known bug or do I miss something? Thanks for your help. -- Sylvain
Re: Retrieve Output parameters from TADOStoredProc
Author: Eko Subagio
Date: Thu, 11 Jan 2001 17:49
Date: Thu, 11 Jan 2001 17:49
33 lines
1667 bytes
1667 bytes
No way, it should run properly. Did you set parameters output properly ? Check in Parameters Property Editor and invoke parameter editor, set the formal and actual parameter as output. Or Check your SQL statement after retrieving value, there two method to returning value from MSSQL Server , first with SELECT @parOutput = value or you can using Set @parOutput = value Regards Eko Subagio www.delphi-jedi.org www.geocities.com/ekosbg "sylvain cochepain" <s.cochepain@silog.fr> wrote in message news:3a5c90ae_1@dnews... > Hi, > > I can't retrieve the value of output parameter in my TADOStoredProc (I get 0 > for a simple int parameter). Is it a known bug or do I miss something? > Thanks for your help. > > -- > Sylvain > >
Re: Retrieve Output parameters from TADOStoredProc
Author: bbbruns
Date: Wed, 17 Jan 2001 23:00
Date: Wed, 17 Jan 2001 23:00
23 lines
1362 bytes
1362 bytes
Sylvain- Also, the stored proc must be closed before output & return values become valid. bbbruns -- bbbruns Vision Quest Integrated Technologies, Inc. "sylvain cochepain" <s.cochepain@silog.fr> wrote in message news:3a5c90ae_1@dnews... > Hi, > > I can't retrieve the value of output parameter in my TADOStoredProc (I get 0 > for a simple int parameter). Is it a known bug or do I miss something? > Thanks for your help. > > -- > Sylvain > >
Re: Retrieve Output parameters from TADOStoredProc
Author: bbbruns
Date: Wed, 17 Jan 2001 23:12
Date: Wed, 17 Jan 2001 23:12
25 lines
1516 bytes
1516 bytes
Just to clarify: When I wrote "the stored proc must be closed", I meant the stored proc object must be closed, for example: TADOStoredProc sp; ..... sp.Close(); // or sp.Active = false; -- bbbruns Vision Quest Integrated Technologies, Inc. "sylvain cochepain" <s.cochepain@silog.fr> wrote in message news:3a5c90ae_1@dnews... > Hi, > > I can't retrieve the value of output parameter in my TADOStoredProc (I get 0 > for a simple int parameter). Is it a known bug or do I miss something? > Thanks for your help. > > -- > Sylvain > >
Thread Navigation
This is a paginated view of messages in the thread with full content displayed inline.
Messages are displayed in chronological order, with the original post highlighted in green.
Use pagination controls to navigate through all messages in large threads.
Back to All Threads