Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Problem updating a view based on free tables.
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00743048
Message ID:
00744223
Vues:
21
That was one of the first things I tried ... opening the tables before modifying the view; however, even with the tables open, I get the same result.

Does it matter how I created the view? I did not use the view designer when I created the view, I simply did the following from the command line:
CREATE VIEW flzipmaid as sele a.* from missacct a,;
 family b, person c where a.zip = ?m.z_szip;
 AND a.fname = ?m.z_sfname;
 AND (a.lname = ?m.z_slname OR c.maidenname = ?m.z_slname);
 AND a.acctno = b.acctno;
 AND b.personno = c.personno;
 AND b.famid # 'C' group by a.acctno
I figured that either way you created the view (whether command line or view designer) it was added to the database and could therefore be modified via the view designer. Is this not the case?
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform