Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
How to make my VFP7 or earlier coded SQL to work in VFP8?
SQL Syntax
In your Main.PRG along with other global SET commands, add the code..
SET ENGINEBEHAVIOR 70
to change the default behaviour of VFP8 in treating SQL syntax. The latest VFP8 SQL syntax are corrected to follow the SQL standard syntax at large and so differs in behaviour to the earlier versions. However to provide the earlier code compatibility, the above new
SET ENGINEBEHAVIOUR 70 | 80 has been added in VFP8.
Still you can expect surprises in the syntax...
"Using SET ENGINEBEHAVIOR set to 70 might lead to ambiguous results from SQL SELECT commands when the DISTINCT and UNION clauses are used with memos and the GROUP BY clause, the HAVING clause without a GROUP BY clause, and when using the LIKE clause."
The scope of SET ENGINEBEHAVIOR is global.
SET ENGINEBEHAVIOR 70
to change the default behaviour of VFP8 in treating SQL syntax. The latest VFP8 SQL syntax are corrected to follow the SQL standard syntax at large and so differs in behaviour to the earlier versions. However to provide the earlier code compatibility, the above new
SET ENGINEBEHAVIOUR 70 | 80 has been added in VFP8.
Still you can expect surprises in the syntax...
"Using SET ENGINEBEHAVIOR set to 70 might lead to ambiguous results from SQL SELECT commands when the DISTINCT and UNION clauses are used with memos and the GROUP BY clause, the HAVING clause without a GROUP BY clause, and when using the LIKE clause."
The scope of SET ENGINEBEHAVIOR is global.