>Well, if anyone is reading this thread. I've tried building the view step by step to determine when it become "unreadable" after it is saved.
>
>I've simplified it down to this and still have the problem:
>
>SELECT Lnai.Qty, Lnai.Cost;
> FROM ;
> {oj dbo.tblLNaiTransactionLog Lnai ;
> LEFT OUTER JOIN dbo.ItemMaster Im ;
> ON Lnai.KeyField = Im.KeyField};
> WHERE Lnai.DateRcvd BETWEEN '04/04/04' AND '05/01/04'
>
>If I try and re-load the view after saving it, I get an error and it refuses to let me into the designer but rather pops up the SQL page offering for me to make changes. I have now found that I can remove the two braces {} and the word 'obj' from the SQL statement and it will then allow me to renter the design screen. But, VPM will immediately put the {obj ....} back into the SQL statement, starting the problem over again.
>
>Can anyone tell my why selecting OUTER LEFT JOIN places the {obj ... } into the SQL statement and why it chokes on it after it is there?
>
>Thanks,
>Robert

Hi Robert,

I've just tried the following code and it works without problem in VFP8 and VFP8 SP1. I am able to make some changes in SQL window and go back to design window. Does it work for you? What am I missing?

CLOSE DATABASES all


CREATE DATABASE testViewDesigner

CREATE CONNECTION testconnection CONNSTRING "DRIVER={SQL SERVER};SERVER=(local)"

con=SQLCONNECT("testconnection")

TEXT TO cSQL NOSHOW 
	CREATE TABLE tblLNaiTransactionLog (KeyField int, Qty int, Cost money, DateRcvd smalldatetime)
	CREATE TABLE ItemMaster (KeyField int)
ENDTEXT 

?SQLEXEC(con,cSQL)

CREATE SQL VIEW testview REMOTE CONNECTION testconnection AS ;
	SELECT Lnai.Qty, Lnai.Cost;
	FROM ;
	{oj dbo.tblLNaiTransactionLog Lnai ;
	LEFT OUTER JOIN dbo.ItemMaster Im ;
	ON Lnai.KeyField = Im.KeyField};
	WHERE Lnai.DateRcvd BETWEEN '04/04/04' AND '05/01/04'

MODIFY VIEW testview NOWAIT 

return

Thanks,
Aleksey.