Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
How to switch on NOFILTER for my 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
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement