Home » RDBMS Server » Server Administration » Returning a value to VB
Returning a value to VB [message #371963] Wed, 27 December 2000 12:11 Go to next message
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 #371964 is a reply to message #371963] Wed, 27 December 2000 15:17 Go to previous messageGo to next message
Lee
Messages: 56
Registered: May 1999
Member
You could probably writ a function and call it from VB.
Re: Returning a value to VB [message #372099 is a reply to message #371963] Wed, 10 January 2001 05:26 Go to previous message
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.
Previous Topic: Query Tunning
Next Topic: select statement ...
Goto Forum:
  


Current Time: Sat May 18 00:59:05 CDT 2024