Me again Mel.
>I will post the question again a little differently, and perhaps someone can tell me if CodeMine can do this in the native Find Dialog or not.
I have a feeling you will have to subclass it.
I've used the Find Dialog for basic forms, I mean, simple data entry forms and it's extremely easy to work with it.
But some months ago I had to build a Find with compound indexes, and wrote to Dave about it. He told me I should subclass the framework dialog or build one myself.
But if you are not in a hurry, I think Steve Tysinger is working in a powerfull Find Dialog, which looks like salvation for our cases.
>If I have an index on two fields like either of the two following:
INDEX ON UPPER(LAST)+" "+UPPER(FIRST) TAG LASTFIRST
I see you have Last and First separate fields, have you tried the cmNameParser::ParseName Method instead ? You would be able to have the complete name in one field, and parse them when needed. Think it would solve your Find problem too. But never mind, I just think too much.
INDEX ON TRIM(UPPER(LAST))+" "+TRIM(UPPER(FIRST))TAG LASTFIRST
Isn't there an index length problem here ?
See ya.
Ivan