Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Deleted records in a view
Message
De
05/05/2006 06:35:48
Cetin Basoz
Engineerica Inc.
Izmir, Turquie
 
 
À
05/05/2006 06:09:35
Tom Van Buuren
Agis Automatisering
Harmelen, Pays-Bas
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Visual FoxPro:
VFP 8
OS:
Windows XP
Divers
Thread ID:
01119499
Message ID:
01119519
Vues:
15
>That doesn't work either. The select statement of the view is:
>
SELECT *, DELETED() as lDeleted FROM <table> etc.
>Deleted records appear in the view with .F. in the last column. When I run the same select in the command window, deleted records have .T. in the last column.
SET DELETED OFF     

lcSource = _samples+'Data\Customer'
DELETE FROM (m.lcSource) WHERE cust_id like 'A%'
CREATE DATABASE dummy
CREATE SQL VIEW myView as ;
SELECT cust_id, company, DELETED() as lDeleted ;
 FROM ;
     (m.lcSource)

USE dummy!myView
BROWSE

SELECT customer
RECALL all

CLOSE DATABASES all
ERASE dummy.dbc
ERASE dummy.dc*
Cetin
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform