>At this moment of time! I'm trying to refine my program, I'll try to replace SET FILTER command by SQL, my question is:
>
>Is it possible that the result of my SQL command be the parent table then put it in a grid. We usually view the fitered data on a grid then individually update each record...

Hello, Ismael.

Of course you can put the resulting cursor on a grid. If you need to edit and update it, however, maybe a view is better than a plain SELECT.

A view is basically a SQL SELECT but with a mechanism to requery it (based on parameters) to get a different set, and update it.

To optimize the update process, be sure about having a clearly defined primary key that the view can use to access again each record you changed.

Tell me if you need more help.

Good luck.