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