Executing a variety of sql statements??
Posted on 1999-07-21
What I need to be able to do is execute a number of queries across a relational database ( held in sql server 7 ). I can create projects and dialogs for these projects that connect to a single table / view or use a stored procedure and get the results back. I have been modifying the ::GetDefaultSQL() method to attach say a stored procedure, but this is very limiting. Do I have to create new classes for each query/ table or stored procedure that I need data from?? or is there a neat way to specify from which source your data is required and return possibly just a Recordset/ResultSet?? I have read a number of books on databases using VC++ but all they contain is a number of basic examples and no indepth real-world examples.