>>Did you use the VFP view designer? It uses that syntax when creating remote views with the sql server driver.
>
>It's possible, but I don't think so. We started with a local DBC that we upsized, but that view was made after upsizing, when we didn't use the view designer anymore. Besides, the VD is unable to correctly make that query. As far as I can remember, I hand-typed that view manually - that's what bugs me the most! :)
>
>No other view, including those I'm sure were made in the VD has that - although all the views made with the VD were first made for the local DBC and later modified to work well with SQLServer.
>
>Thanks for the info!

Well, nothing will change a view, unless it is changed manually or in the VD.

do you maintain a GenDBC(x) program of your DBC so you can recover is a view is changed? You can also keep this in source control so it will track each change mode to the views, then you would have been able to find when this changed.

My best guess is still that someone opened the view in the VD, and it change the OUTER JOIN syntax to the ODBC oj {} syntax.

BOb