EdmiError edmiGetQueryResultColumnsBN (SdaiQueryResult  queryResult,
                                        SdaiInteger      rowNumber, 
                                        SdaiInteger      numberColumns,
                                        /* [SdaiString columnName,
                                        SdaiPrimitiveType valueType,
                                        void *value] */
                                         ...);

Reads an arbitrary number data elements contained in a single row of a table-formatted query result. The data elements must be identified by their common row number and their individual column names. This function is only applicable on the results from query functions that are invoked with the option RESULT_AS_TABLE.

Arguments

Type	Name	Comment
SdaiQueryResult	queryResult	The returned result of a query function. This parameter must be the result of a query that was called with the option RESULT_AS_TABLE. See edmiExecuteQueryBN.
SdaiInteger	rowNumber	The row number to read in the query result table. The number of rows in the table is stored in the rows element of the <qResult> data structure.
SdaiInteger	numberColumns	The number of columns to read from the row identified by <rowNumber>.
SdaiString	columnName	The name of a column for which to read a value.
SdaiPrimitiveType	valueType	The primitive type of the data element to be read.
void	value	Variable that will receive the value identified by its <rowNumber> and <columnName>.

Return Value

Error rendering macro 'excerpt-include' : User 'null' does not have permission to view the page 'US:_r_EDMInterface'.

Options

Example

 EdmiError rstat;
 int i;
 SdaiString name, phoneNo, prof;
 SdaiInteger age;
 SdaiQueryResult queryResult;
 SdaiModel modId;
 . . .
 /* Execute the query function */
 rstat = edmiExecuteQueryBN(modId, "FriendQuerySchema",
 "GetFriendBySexAndName",  
 2, RESULT_AS_TABLE, &queryResult,  
 sdaiSTRING, "*", 
 sdaiENUMERATION, "MALE"); 
 printf("My male friends are:");
 for (i=0;i<queryResult->rows;i++) {
 if (rstat = edmiGetQueryResultColumnsBN(queryResult, i, 4, 
 "NAME", sdaiSTRING, &name, 
 "AGE", sdaiINTEGER, &age, 
 "PHONE NUMBER", sdaiSTRING, &phoneNo, 
 "POFESSION", sdaiSTRING, &prof)) { 
 printf("\nError %d in edmiGetQueryResultColumnsBN: %s", rstat, 
 edmiGetErrorText(rstat)); 
 goto err; 
 } 
 printf("\n%s (%d), %s, <%s>", name, age, phoneNo, prof); 
 }
 edmiFreeQueryResult(queryResult);
 . . .

Arguments

Return Value

Options

Example

See also

Filter by label