I have used the funciton FindFirst in order to locate the first matching method in my database and then update it with some data input by the user.
But I found that if the orginial data contain ' in the orginial data,
then no matching method can be found!!! Also, the return value of this function will not be equal to zero. It will udpate the first record of my database.
BOOL Find m_RsList->FindFirst([Telephone Number]='107' AND [First Name]='Win's' AND [Last Name]='Poon');
In the field "First Name", the content is Win's ....
How can I solve this problem?