The compute.c sample program demonstrates how computed results are processed:
Sends a query to the server using a language command.
Processes the results using the standard ct_results while loop.
Binds the column values to program variables.
Fetches and displays the rows in the standard ct_fetch while loop.
This sample requires the pubs2 database.
This is the query that is sent to the server:
select type, price from titles where type like "%cook" order by type, price compute sum(price) by type compute sum(price)
This query returns both regular rows and computed rows. The computed rows are generated by the two compute clauses.
The first compute clause generates a compute row each time the value of type changes:
compute sum(price) by type
The second compute clause generates one compute row, which is the last to be returned:
compute sum(price)