>>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?