>I heard advices on this forum thats is not wise using set filter
>
>How could I replace the line below with set relation command ?
>I am using it in a form with cursors in its dataenvironment
>
>Regards
>
>Moses
>
>SET FILTER TO ALLTRIM(UPPER(FATHER_TABLE.type)) = ALLTRIM(UPPER(child_TABLE.type))
It depends for what you need this filer.
You may use Local View or CursorAdapter if you need to modify the result set and send the modifications back to the table or you may use a simple Cursor created with SQL SELECT if you need it only for presentation.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.