EasySQL4Fox - helps tie FoxPro and SQL Server together

   Full manual

FoxPro + SQL Server. EasySQL4Fox functions

Update Visual FoxPro syntax to SQL Server syntax

 

EasySQL4Fox features - page 2

 

1.6. If a GROUP BY phrase exists, a SELECT phrase cannot include columns which are not included in the GROUP BY expression, or are not aggregated using the AVG,MIN,MAX,SUM,COUNT functions.

Read more

1.7. The GROUP BY clause can not refer to calculated columns via aliases (.. AS alias). 

Read more

1.8. A HAVING clause cannot refer to columns using the alias in an AS clause. 

Read more

1.9. If the key words AND, OR and NULL are bracketed with periods, the periods will be removed. 

Read more

1.10. ALLTRIM will be replaced with LTRIM(RTRIM()). 

Read more

 

page 1 - page 2 - page 3 - page 4 - page 5

 

 HotLog

Download EasySQL4Fox for your consideration or order a copy of EasySQL4Fox.