On Friday 06 August 2010, Chandrakant Solanki wrote:
I have developed one custom function in module, and
also create one custom
structure to store database recordset.
What I would like to do is...
1] I have structure say struct record and it has variable
struct record {
int id;
char name;
db_res_t *res;
};
2] Execute one query and store result into "db_res" variable of db_res_t
datatype; 3] Now I would like to preserve 'n in future i will use this
recordset.. so how can i store this "db_res" variable into structure
variable.
I have tried using below syntax...
struct record rec[2];
db_res = get_record( "pass_any_query" );
rec[0].res = db_res;
But when I used this rec[0].res in future it gives garbage value.
Any Idea...???
Hi Chandrakant,
i'm not 100% sure what you want to achive. You want to execute one query, and
then execute another query on the existing result set to fill it with more
values? This is somewhat already available with the "fetch result"
functionality.
But if you want to store just some arbitrary results from an result set in an
own structure i'd suggest that you not hold any pointer to the internal result
set for this purposes. They will be freed after the query, for example if you
call free_result on it. Better would be to copy the data that you need from
the result set to an own structure which you can then control.
Cheers,
Henning