C++ to Oracle interface

I apologize if this is a repost. For some strange reason the file with the actual text to the posting never got appended to the post

I have a front-end application to an Oracle Workgroup Server for Windows NT written in MS Visual C++ with MFCs. The application is going to be used for resale to users that will never see the database. Instead, they use GUIs (as yet undecided) to forumlate the queries (dynamically). Now, the questions are:

1). How can the application written in Visual C++ and MFCs generate SQL

     Satements using only application-generated GUIs (no direct SQL Code)?
     i.e. The user from a Form presented to him/her will make selections
     which needs to be translated into an SQL query and sent to the Database.
     The permutations and combinations of the user's selections can be a large
     number so predefining procedures for all of them is not practical.
     How is this normally achieved? Is there some tool that translates user
      user queries into SQL code?


2).  After executing the query, how are the results of the query to be put 
     into Visual C++, MFC data structures?

Any help will be appreciated.

Thanks,

/Biju

-- 


*******************************************************************

Biju Nair				NAIRBIJ_at_IITVAX.IIT.EDU
Computer Science Dept.			thssbxn_at_iitmax.iit.edu
Illinois Institute of Technology	biju_at_iris.iit.edu
Chicago, Il 60616.			Tel:(312)567-6819 (Dept)


*******************************************************************