Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Problem updating a view based on free tables.
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00743048
Message ID:
00744223
Views:
19
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?
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform