Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
How to switch on NOFILTER for my view
Message
De
13/09/2001 09:20:25
Mike Yearwood
Toronto, Ontario, Canada
 
 
À
13/09/2001 07:33:50
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00555848
Message ID:
00555874
Vues:
27
This message has been marked as the solution to the initial question of the thread.
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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform