>I am currently working on a project that will use an Oracle back-end and VFP front-end, however right now we are using VFP as the backend as well. I generated a remote view with outer joins through the forms designer and got an OBDC 1526 error. when I viewed the generated code there was a {oj } in the SQL statement, when i take these out and try it in the command window, it works like a champ. how can i have VFP NOT generated these characters ???
>
>
>Please help
>
>Thanks
If you are going to have an Oracle back end, you would probably be better served to create the SQL yourself and use *true* SQL syntax. If you have access to Oracle now, a little testing of some of your VFP SQL syntax can help trouble shoot future potential problems. See SQLConnect(), SQLExec(), etc., functions for passing SQL to Oracle. I also have an article in KB under Client/Server on *Connecting VFP to Oracle*. The MS site to download the most current ODBC drivers (32 bit only) takes a very convoluted path to get to the actual download page, but they are free (after filling out an on-line registration form).
The ODBC drivers that come with Oracle do not work well with MS products including VFP.
Mark McCasland
Midlothian, TX USA