Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Local views and deleted records
Message
 
 
À
15/07/1997 07:11:31
Jon Ziegler
Mannesmann Dematic Corp.
Solon, Ohio, États-Unis
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00039937
Message ID:
00039949
Vues:
41
>Is there a way to handle deleted records using local views? Whenever my local views create themselves, the deleted status of the record in the table that the view is based on does not seem to remain. I would like to be able to RECALL records from within the local view, as well. Is this possible?

When you create the views, is Deleted set to on or off? I just did a test, and if Deleted is set ON, the deleted records are not displayed. With Deleted set OFF, the records display but the delete marks are blank. What I did was to assure myself what records were deleted was to add an extra field in the Select:
CREATE SQL VIEW ViewName ;
   AS Select *, Deleted() as "Deleted" ;
   from MyTable order by blah, blah, blah ....
I do not know of anything you can do to actually show the delete mark. But the "Deleted" column will have a logical value based on the deleted status in the original table.

HTH.
Mark McCasland
Midlothian, TX USA
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform