fetching data at run time

[harish_kolar]

My application constructs SQL statements at run time.
How can i fetch the data,since SQLBindCol has to be called before fetching data (using SQLFetch function). Can i use SQLGetData. But as i know for we should use SQLGetData only when when getting long data and it does't support joins. Please help me on how to get data from the database by constructing sql statements at run time.

thanks in advance