Help!
I'm attempting to create a view in a VFP 5.0a project, all tables forming the view (4) are in the dbc in the project. I use the View Designer instead of the wizard. Everything comes up roses when I run the SQL from the View Designer, giving exactly the results I expected. The problem occurs when I attempt to save my view.... I got an 1806 error. I then deleted all views in the project(and in the project directories) and started over. I rebuilt the project, and then built my first view again. Roses, until I attempt to save the view, then I get... SQL: Column 'IDENT' is not found. I look, I see the column, It's a primary index in one table (Mail), and a regular index in another (new_class) and a field in both. The SQL generated by the View Designer is:
SELECT DISTINCT New_class.*, Instructor.instid, Instructor.lname,;
Instructor.fname, Classcod.title;
FROM outdoor_woman!new_class INNER JOIN outdoor_woman!instructor;
INNER JOIN outdoor_woman!classcod;
INNER JOIN outdoor_woman!mail ;
ON Mail.ident = New_class.ident ;
ON New_class.class = Classcod.class ;
ON New_class.instid = Instructor.instid;
ORDER BY Instructor.lname, Instructor.fname
Humble and Confused:)
Ken
Ken Mears