compute.c sample program

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)