The compute.c sample program demonstrates processing compute results. It sends a canned query to the server using a language command. It processes the results using the standard ct_results while loop. It binds the column values to program variables. It then fetches and displays the rows in the standard ct_fetch while loop.
Following is the canned query:
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 compute rows. The compute rows are generated by the two compute clauses. The first compute clause, “compute sum(price) by type,” generates a compute row each time the value of type changes. The second compute clause “compute sum(price),” generates one compute row, which is the last to be returned.
For more information about this sample program, see the leading comments in the sample source file.
This sample requires the pubs2 database.
