Returning a value to VB [message #371963] |
Wed, 27 December 2000 12:11 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
Bob Anderson
Messages: 1 Registered: December 2000
|
Junior Member |
|
|
I am calling a select statement from VB that returns a single value from a table and would like to only return that value, instead of returning a recordset. How could I do this?
|
|
|
|
Re: Returning a value to VB [message #372099 is a reply to message #371963] |
Wed, 10 January 2001 05:26 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
Sandeep Udupa
Messages: 9 Registered: January 2001
|
Junior Member |
|
|
If you dont want to use a recordset then I suggest write a PROCEDURE/FUNCTION which returns a parameter and then this can be caught in the COMMAND object in ADODB after you execute the COMMAND Object. Trap the Oracle return type in a variable in the front end.
|
|
|