>I have a table with an existing paramatised view against it.
>
>I need to add a record into the table and want to do it via the view (in case app is upsized)
>
>As such I need to start off with the view empty ready for me to do the single insert into it I need.
>
>At present I just change the view parameters to something that I know will not return any data.
>
>ie clMyParam='zxx##xxz' or something.
>
>Does anyone know of a better way because this technique is not very elegant.
Use .. nodata
Cetin