>>>>SELECT * FROM MYTABLE WHERE CNAME$CTITLE INTO CURSOR TEMP
>>>Thank you so much for your response. I tried it but it still gives me 0 records from the valid event, but works from a .prg...
>>
>>Have you checked the value of CTITLE before your SQL to make sure it really contains the value you want to search for. If you do SELECT * FROM MYTABLE INTO CURSOR TEMP, does it work?
>
>Yes, it does. I also tried WHERE conditions for the other fields in the table , works. Only using the wild card in the valid, returns 0. It worked when I put it in the activate event of the page!
I wonder if that's another one of those funny valid things...did you try it in the Lostfocus instead?
The Anonymous Bureaucrat,
and frankly, quite content not to be
a member of either major US political party.