Asked a question about "Powerbuilder 7.0" and "SQL 2005" issues
-
Since we are the procedures companies use the original powerbuilder 7.0 development. powerbuilder 7.0 DataWindow for the use of multi-table connection, generated SQL statement, "*=" Equals "left join", "=*" equals "right join". But when I put the database to upgrade to SQL 2005, and compatible with the database-level adjustment to 9.0, the application error, suggesting that SQL 2005 does not support "*=" only support "left join" I can only adjust to the compatibility of 8.0 (which did not upgrade and What is the difference between) I should be how to solve it ?
-
Since we are the procedures companies use the original powerbuilder 7.0 development. powerbuilder 7.0 DataWindow for the use of multi-table connection, generated SQL statement, "*=" Equals "left join", "=*" equals "right join". But when I put the database to upgrade to SQL 2005, and compatible with the database-level adjustment to 9.0, the application error, suggesting that SQL 2005 does not support "*=" only support "left join" I can only adjust to the compatibility of 8.0 (which did not upgrade and What is the difference between) I should be how to solve it ?
"Powerbuilder 7.0"-generated statements, SELECT ctn_in_out.ctn_no, ctn_in_out.vessel_code, ctn_in_out.voyage, FROM ctn_in_out, goen_action WHERE ( ctn_in_out.vessel_code =* goen_action.vessel_code) SQL standard statements select * from ctn_in_out right join goen_action on ctn_in_out.vessel_code = goen_action.vessel_code