Mark,
This may cause performance problems if you underlying tables are very large. Even when you use NODATA, VFP still attempts to download parts of the index to optimize the view so constantly closing and re-opening the view is not the way to go (IMO).

Use the PK approach. FWIW, I do. I actually set up a constant for it and use it throughout my application.

>Thanks Cetin
>
>I forgot about that property
>
>
>>>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