473,246 Members | 1,383 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,246 software developers and data experts.

How to return an array from a sub-routine.

Neo
Dear All,
I want to know how a subroutine should return an array of values to
the main program.
From the main program, I call a sub-routine 'get_sql' which then
fetches data from oracle db using oci8 routines. The output resides in
a structure defined within the sub-routine. Now I want this structure
to be returned to main program so that I can assing output data to
variables in main program and do some manipulation. Can any body guide
me about how to do it.

I am a newbie and have never played with structures or string arrays.

Thanks in advance.

Take care
Rizwan
Nov 13 '05 #1
6 6573
On 1 Dec 2003 03:52:40 -0800, in comp.lang.c ,
ri**********@hotmail.com (Neo) wrote:
Dear All,
I want to know how a subroutine should return an array of values to
the main program.


FYI C programmers don't use the word "subroutine", in C its called a
function.

To return an array or struct from a function, pass a pointer to the
object into the function
struct stype s;
char a[12];

void dosomethingtos( &s );
void dosomethingtoa( &a );

You can also di it by using a static or global variable, but this is a
highly dangerous technique and makes your code non-threadsafe and
non-reentrant. For work on modern OSes this is a Bad Idea.
--
Mark McIntyre
CLC FAQ <http://www.eskimo.com/~scs/C-faq/top.html>
CLC readme: <http://www.angelfire.com/ms3/bchambless0/welcome_to_clc.html>
----== Posted via Newsfeed.Com - Unlimited-Uncensored-Secure Usenet News==----
http://www.newsfeed.com The #1 Newsgroup Service in the World! >100,000 Newsgroups
---= 19 East/West-Coast Specialized Servers - Total Privacy via Encryption =---
Nov 13 '05 #2
Mark McIntyre <ma**********@spamcop.net> wrote in
news:o8********************************@4ax.com:
On 1 Dec 2003 03:52:40 -0800, in comp.lang.c ,
ri**********@hotmail.com (Neo) wrote:
Dear All,
I want to know how a subroutine should return an array of values to
the main program.


FYI C programmers don't use the word "subroutine", in C its called a
function.

To return an array or struct from a function, pass a pointer to the
object into the function
struct stype s;
char a[12];

void dosomethingtos( &s );
void dosomethingtoa( &a );

You can also di it by using a static or global variable, but this is a
highly dangerous technique and makes your code non-threadsafe and
non-reentrant. For work on modern OSes this is a Bad Idea.


Or just put it in a struct like we've mentioned countless times before.

struct WrapArr
{
int arr[1024];
};

struct WrapArr foo(struct WrapArr s)
{
memset(s.arr, 0, sizeof s.arr);

return s;
}

int main(void)
{
struct WrapArr arr;
struct WrapArr brr;

brr = foo(&arr);

return 0;
}

--
- Mark ->
--
Nov 13 '05 #3
> I want to know how a subroutine should return an array of values to
the main program.
From the main program, I call a sub-routine 'get_sql' which then
fetches data from oracle db using oci8 routines. The output resides in
a structure defined within the sub-routine. Now I want this structure
to be returned to main program so that I can assing output data to
variables in main program and do some manipulation. Can any body guide
me about how to do it.


What you want to do is have your subroutine return a pointer to an
array/structure. I don't know enough about your needs, but you may
want to consider creating an array of pointers to values or array of
pointers to structures if the size of the resulting value lengths from
your queries is not always the same (if you are pulling var char
fields for instance).

Here is a basic outline of the idea:

(Assumes function returns a pointer to a structure populated by
get_sql)

struct sql_result { int val1; char * val2; ...};

struct sql_result * sql_get ( your arguments);

int main (void) {
struct sql_result * sql_res_ptr; /* declare pointer to structure
*/
...
sql_res_ptr = sql_get ( your args);
value1 = sql_res_ptr->val1; /* Retrieve values, value 1 is int in
this example */
value2 = sql_res_ptr->val2; /* value2 is type char * here */
...
}

struct sql_result * sql_get ( your args ) {
...
static struct sql_result sql_res; /* Not thread safe */
/* Do struct populating here */
sql_res.val1 = query_db_for_val1(blah);
sql_res.val2 = query_db_for_val2(blah);
return (&sql_res);
...
}

The basic idea is to have your sql_get function set aside storage for
your information, populate with your query results and pass back a
pointer to the information. Note that in this example, I used a
static structure so the information your pointer points to will change
the next time this function is called. You could also have the
sql_function use malloc to dynamically allocate memory and then make
it the responsibility of the caller to free the memory when no longer
needed, or you could make the caller allocate the memory and pass the
location of the allocated memory to the function for it to use. If
you are dealing with variable length data, it might make the most
sense to have the function allocate the memory and the caller free it.

Hope this helps,

Rob Gamble
Nov 13 '05 #4
"Mark A. Odell" <no****@embeddedfw.com> wrote in message
news:Xn********************************@130.133.1. 4...
Mark McIntyre <ma**********@spamcop.net> wrote in
news:o8********************************@4ax.com:
On 1 Dec 2003 03:52:40 -0800, in comp.lang.c ,
ri**********@hotmail.com (Neo) wrote:
Dear All,
I want to know how a subroutine should return an array of values to
the main program.
FYI C programmers don't use the word "subroutine", in C its called a
function.

To return an array or struct from a function, pass a pointer to the
object into the function
struct stype s;
char a[12];

void dosomethingtos( &s );
void dosomethingtoa( &a );

You can also di it by using a static or global variable, but this is a
highly dangerous technique and makes your code non-threadsafe and
non-reentrant. For work on modern OSes this is a Bad Idea.


Or just put it in a struct like we've mentioned countless times before.

struct WrapArr
{
int arr[1024];
};

struct WrapArr foo(struct WrapArr s)
{
memset(s.arr, 0, sizeof s.arr);

return s;
}

int main(void)
{
struct WrapArr arr;
struct WrapArr brr;

brr = foo(&arr);

----------------^---
To be consistent with declaration, it should be
brr = foo(arr);
Though I prefer passing pointer(s) in this case
(as Mark McIntyre suggested), not structs themselves.
return 0;
}

--
- Mark ->
--

Nov 13 '05 #5
On 1 Dec 2003 03:52:40 -0800, ri**********@hotmail.com (Neo) wrote:
Dear All,
I want to know how a subroutine should return an array of values to
the main program.
From the main program, I call a sub-routine 'get_sql' which then
fetches data from oracle db using oci8 routines. The output resides in
a structure defined within the sub-routine. Now I want this structure
to be returned to main program so that I can assing output data to
variables in main program and do some manipulation. Can any body guide
me about how to do it.

Make up your mind. Do you want to return an array or a structure?

Returning a structure makes for simpler code (but not necessarily
efficient code). You return the structure with a return statement
like
return name_of_my_struct;
This will work even if the structure contains one or more arrays.

Returning an independent array can be more complicated. Among the
options are

Define the array in the function as static. This will insure the
contents of the array survive past the end of the function.

Allocate the array using malloc or one of its cousins. You can
then return the address of the array to the calling function which
will be responsible to free() the allocated memory when it is no
longer needed.

Define the array in the calling function and pass it to the called
function. The called function will then be able to update the array
directly and it does not need to be returned explicitly.

Define the array at file scope (a global array). The called
function will then be able to update the array directly and it does
not need to be returned explicitly.
<<Remove the del for email>>
Nov 13 '05 #6
"nobody" <no****@nowhere.non> wrote in
news:tE********************@twister01.bloor.is.net .cable.rogers.com:

int main(void)
{
struct WrapArr arr;
struct WrapArr brr;

brr = foo(&arr);

----------------^---
To be consistent with declaration, it should be
brr = foo(arr);
Though I prefer passing pointer(s) in this case
(as Mark McIntyre suggested), not structs themselves.


You are right! Sorry for the bad mistake.

--
- Mark ->
--
Nov 13 '05 #7

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

23
by: Nascimento | last post by:
Hello, How to I do to return a string as a result of a function. I wrote the following function: char prt_tralha(int num) { int i; char tralha;
7
by: nafri | last post by:
hello all, I want to create a function that returns the first element of the Array that is input to it. However, the Input Array can be an Array of points, double, or anyother type, which means...
1
by: moondaddy | last post by:
I need to return a nested string array from a function and am getting hung up on syntax. Here's a simple example of a function that returns the array and how I'm trying to call it. Private Sub...
5
by: Sam | last post by:
Hi All I have couple of question regarding property of a class and structures. **** ---- Here is my class and structure ---- ***** 1. Public Structure MyPoint 2. Dim p As Point 3. ...
8
by: solomon_13000 | last post by:
The code bellow functions well. However if I want to obtain a return value using the code bellow, how is it done? <% Sub RunQueryString (pSQL,parms) on error resume next Set conn =...
5
by: samoore33 | last post by:
I use the code below to search through a DataSet: Dim t As DataTable t = result.Tables("State") Dim strExpr As String strExpr = "id = '" & theState.ToString() & "'" Dim foundRows() As DataRow...
10
by: Raj | last post by:
I need a VB function to return array of collections like Private Type Employee empname as string address as string salary as integer deptno as integer End Type dim employees() as Employee
20
by: Andrew Morton | last post by:
Is it possible to have two function declarations which take the same parameters but return different types depending on how the function is used? function f(x) as string ' return a string end...
5
by: Detlev808 | last post by:
Hello, I am attempting to write an awesome perl script. Before it can do anything useful, it must first be able to read in a file, and write out a file (Note: I am NOT talking about text files)....
1
by: kirilogan22 | last post by:
Okay first of the variables that I have: they are all structures ex. ALL.vehicles.cars has some functions and and variables/arrays ex. ALL.vehicles.boats is the same structure as .cars ex....
2
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 7 Feb 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:30 (7.30PM). In this month's session, the creator of the excellent VBE...
0
by: stefan129 | last post by:
Hey forum members, I'm exploring options for SSL certificates for multiple domains. Has anyone had experience with multi-domain SSL certificates? Any recommendations on reliable providers or specific...
1
by: davi5007 | last post by:
Hi, Basically, I am trying to automate a field named TraceabilityNo into a web page from an access form. I've got the serial held in the variable strSearchString. How can I get this into the...
0
by: MeoLessi9 | last post by:
I have VirtualBox installed on Windows 11 and now I would like to install Kali on a virtual machine. However, on the official website, I see two options: "Installer images" and "Virtual machines"....
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: Aftab Ahmad | last post by:
So, I have written a code for a cmd called "Send WhatsApp Message" to open and send WhatsApp messaage. The code is given below. Dim IE As Object Set IE =...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: marcoviolo | last post by:
Dear all, I would like to implement on my worksheet an vlookup dynamic , that consider a change of pivot excel via win32com, from an external excel (without open it) and save the new file into a...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.