>Howdy,
>
>I'm simply trying to create a View through the View designer which connects my main table to 2 other tables by way of outer joins.
>
>When I do it in the view designer, and save it - it will run correctly, but when I try to modidy the view - ir crashes.
>It seems that the view designer creates the SQL syntax incorrectly.
>
>1. This is what the View Designer gives me as the SQL syntax
>
>SELECT MAIN.ID, NAMES.FNAME, STATES.STATE ;
> FROM MAIN LEFT OUTER JOIN NAMES;
> LEFT OUTER JOIN STATES ;
> ON MAIN.name = STATES.name ;
> ON MAIN.id = NAMES.id
>
>2. Running it is O.K.
>
>3. When I save the view and try to modify it I get the Fox error:
>SQL: Column 'NAME' is not found.
>
>John F.
>Needs View help in NYC
Unfortunately, complicated views are better created by CREATE SQL VIEW and handled by CURSORSETPROP().
Edward Pikman
Independent Consultant