Hilmar,

For SQL I believe it's SET ANSI OFF. Also this only works with a local view and won't work with a remote view. The only way I can think of if the data type is character is to change the WHERE clause to distrito.nome LIKE ?pv_filtro1 and then set pv_filtro1 to "%" to get all the records. This might not be the most efficient way though.


>>Hi to all,
>>
>>I created one Parameterized view (distrito.nome =?pv_filtro1), that I use to insert and to modify registers in a table base, the user indicates the register that he intends to modify, and is made requery. As I can make requery without use the filter to visualize all the existing registers in the table.
>>
>>
>>Thanks,
>
>Estimada Carla,
>
>First of all, allow me let me point out that "registro" translates to "record" in English.
>
>If your view parameter is of type character, you can leave it blank, and be sure to SET EXACT OFF. For integer or date types, you would have to: a) use two parameters, to indicate a range, b) specify a range that is wide enough (for instance, mydate >= {^1900-01-01} and mydate <= {2100-01-01}).
>
>HTH, Hilmar.