Thanks Larry
I am taking your advice.
>Mark,
>Yes. It's the same technique you are using now but where you are probably assigning the string each time. I just assign the variable from a constant. I have two constants I use depending on whether I'm using integer or character based keys.
>#DEFINE C_INTPK -99999
>#DEFINE C_CHRPK " "
>HTH.
>
>>Thanks Larry
>>
>>My underlying table is likely to become very large.
>>
>>Could you tell me some more about the PK approach. Is it some form of select using a hard coded non matchable PK.
>>
>>
>>>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
