Hello experts.
I am writing my first function using the SPI_ interface.
I don't know how to access data that I just selected.
here's the outline:
my question is in the block comments
thanks a ton!!!!
mike
int32 allocate_address(int32 networkID)
{
char[255] query;
if (SPI_connect() < 0) {
return 0;
}
sprintf(query,
"Select addressID FROM networkaddress WHERE networkid = %i",
networkID);
if (SPI_exec(query, 1) < 0) {
return 0;
}
/* ############################################################ */
/* how do I access the data that I just selected ? */
/* ie I want to find the value of the each row in the select
/* ############################################################ */
SPI_finish();
return 1;
}