I cannot answer you. I do not have sufficient information about your dilemma ;).


>Wow Mike that worked
>
>Although since this happens in a calculation that happens a lot I wonder if I will get a slight performance hit. Probably not since the Tableupdate will not even attempt to fire with this property set to false.
>
>I have already put something in my code that uses
>COPY TO ARRAY followed by APPEND FROM ARRAY
>
>This seems to work alright from views and gets the desired info into a table
>Now I have to decide which method to use.
>
>The amount of data transferred is only about 5 records but this happens as part of the calculation process which will be getting fired constantly so I have to keep it quick.
>
>Which technique would you use
>
>Mark
>
>
>>Hi Mark
>>
>>After writing to this view, why not set it to SendUpdates = .F. and do a tableupdate. I think that would make the new records visible to the subsequent select / view.
>>
>>>I have a view called V_Tickitm I created with the view designer and it is stored in my DBC.
>>>
>>>I need to run a select against this view but all Selects return an empty cursor.
>>>I imagine that this is because the view does not have a disk presence.
>>>
>>>Somehow I need to switch on the NOFILTER option of the view (If this is possible) and I can not do this from the view designer.
>>>
>>>I have tried modifying the view in the view designer, adding a new field which stores a value such as .T. to try and force a disk presence but this did not work.
>>>
>>>After opening my view with the NODATA clause I execute the following
>>>CursorSetProp("Buffering",5,'v_tickitm')
>>>
>>>I then let my users modify the view in preparation for writing it to the underlying table
>>>
>>>I do not want to have to write the contents of this view back to the underlying table to make my select work in case my user wants to cancel the changes they have made.
>>>
>>>
>>>All help gratefully received