I have created a Database application in Visual C++ 6.0 through the MFC application wizard. I have almost completed my application except for a few touch ups. So far i have been able to search only if i get an exact match by using m_strFilter which is a function of CRecordSet class (function made available for me through the mfc application wizard). I would like to be able to filter partial matches as well.
Application Interface: http://www.public.iastate.edu/~cshoun/DrinkRecipes.jpg
example: I will search the term "Summer" in the field called RecipeName
I will get records with the Recipe Name of Summer Breeze, Summer Baybreeze, Summer Dream and so on..
so all the records i would like filtered will at least contain "Summer" in the RecipeName field.
Question: How can I search my records and filter partial matches as well as exact matches?
App info: MFC SDI with database support
here is part of the code that calls my search button:
m_pSet->m_strFilter = "RecipeName = ?";
m_pSet->m_RecipeNameParam = m_Input;
m_pSet->m_strFilter = "RecipeName = RecipeName";
AfxMessageBox("Record not found!");
Additional info: Here is the web address to all of my files http://www.public.iastate.edu/~cshoun/DrinkRecipes/
Thanks for your help