BO and FOXPRO

[sduplan]

I am new with BO but have been using Visual FOXPRO for a while. All the tables that I want to use in Designer came from VFP.
However, some queries cannot run properly because the SQL statements generated are not VFP-compatible. For example the syntax for OUTER JOIN is different. I have to manually edit the SQL. Is there a way to make BO generate Foxpro-compatible SQL statements?

By the way, my connection to the tables has been defined as ODBC, using the available driver Visual Foxpro tables.

Thanks

 

[sduplan]

I found the solution. I had to edit the parameter file "ODBC10EN.PRM" and change the OUTERJOINS_GENERATION=ODBC line to OUTERJOINS_GENERATION=ANSI_92