I have a straightforward CPropertySheet with CPropertyPages. I need to reset the contents of page "A", depending on the settings on other pages, which means I need a way to catch when pages "open" and "close" I can catch when a page "opens" by overriding OnChildActivate but I can't catch when a Page "closes". Any suggestions on a sane way to trap these events? (Note, I know about OnInitDialog() for "open" or OnOk() for "close". Neither of these methods are guaranteed to be called when just bouncing back and forth between pages by clicking on tabs) Thanks in advance.

I'm using MAPi to email attachments (thanks to a couple articles here on CodeProject!), But I think the behavior I want is not available in MAPi. I want the application to open the default mail program (i.e. Outlook) with the attachment added then in Outlook the user can then add comments, select address etc. the problem is MAPi sends the email directly to the outbox bypassing Outlook. I've seen this behavior, opening Outlook and adding an attachment, in many programs and assumed it was part of MAPi. What am I missing?

I have a stored procedure that executes too slowly (as I mention in a previous posting) so I'm thinking of executing the query asynchronously and grabbing the results as they come back. it may give the impression that the query is faster than it really is. my question is... the stored procedure is sorting the results. So if I grab the first few items from the recordset doing something simple like "MoveNext" and then the queries inserts items new items before the cursor because of sorting, I've missed those items. I am just beginning to dig into asynchronous querys so this may be a really stupid question, in fact I'm sure it is, but I've yet to see how to deal with sorting. Any suggestions?

I'd looked at Full Text Search before, but maybe I missed something... Thanks. The LIKE statement is weird because Searching for "John Doe" is suppose to return matches like "John Jackson" and "Jane Doe". That's the only way I've found to get result.

In SQLServer 2000 I have a table with 25000 rows 7 columns. One of the columns is a nvarchar of 60. I need to do a substring search on that column and the performance is very poor, 3-10 seconds. The search is done by a stored procedure, for example a search for "John Doe" is implemented in SQL by a simple "LIKE %John% AND LIKE %Doe%". I need the functionality of this kind of query, but it's just too inefficient and slow. Any suggestions or references on improving text searching using SQL would be most appreciated. David