Mombu the Programming Forum

Go Back   Mombu the Programming Forum > Programming > Ingres Stored Procedure Visual Basic .net
User Name
Password
REGISTER NOW! Mark Forums Read




Reply
1 14th October 15:01
gareth williams
External User
 
Posts: 1
Default Ingres Stored Procedure Visual Basic .net



Sorry to bring up this old chestnut...

We use Visual Basic .net along with Ingres ODBC. It works great.

I want to use stored procedures to retrieve record sets and return value
(i.e. 0 success, 1 fail).

I've searched the net, but just can't find a good example, or best
practice to follow. All my attempts fail (it executes the stored
procedure but I just can't get the return value back, e.g. return
:errnum.

In vb I'm trying to use parameterdirection.returnvalue - but it always
returns 0 - because the execute procedure command worked - but I want to
get back a number that I choose.

Please help

Thanks

Gareth


Cymraeg:-
Mae'r neges hon yn gyfrinachol nad chi yw'r derbynnydd y bwriedid y neges ar ei gyfer, byddwch mor garedig â rhoi gwybod
i'r anfonydd yn ddi-oed. Dylid ystyried un rhywd datganiadau neu sylwadau a wneir uchod yn rhai personol,ac nid o angen rhaid yn rhai o
eiddo Ymddiriedolaeth GIG Bro Morgannwg, nac unrhyw ran gyfansoddol ohoni na chorff cysylltiedig.

Cofiwch fod yn ymwybodol ei bod yn bosibl y bydd disgwyl i Ymddiriedolaeth GIG Bro Morgannwg roi cyhoeddusrwydd i gynnwys unrhyw ebost neu
ohebiaeth a dderbynnir, yn unol ag amodau'r Ddeddf Rhyddid Gwybodaeth 2000. I gael mwy o wybodaeth am Ryddid Gwybodaeth, cofiwch gyfeirio
at wefan Ymddiriedolaeth GIG Bro Morgannwg ar www.bromor-tr.wales.nhs.uk

English:-
This message is confidential. If you are not the intended recipient of the message then please notify the sender immediately.
Any of the statements or comments made above should be regarded as personal and not necessarily those of Bro Morgannwg NHS Trust, any
constituent part or connected body.

Please be aware that, under the terms of the Freedom of Information Act 2000, Bro Morgannwg NHS Trust may be required to make public the
content of any emails or correspondence received. For further information on Freedom of Information, please refer to the Bro Morgannwg NHS
Trust website at www.bromor-tr.wales.nhs.uk.
  Reply With Quote


 


Reply


Thread Tools
Display Modes




666