EasySQL4Fox - helps tie FoxPro and SQL Server together

   Full manual

FoxPro + SQL Server. EasySQL4Fox functions

Update Visual FoxPro syntax to SQL Server syntax

1.12. The function IIF will be replaced with CASE construction, for example: 

SELECT *,IIF(F1>F2,F3,F4) AS F5 FROM tbl
will be replaced with 
SELECT *,CASE WHEN F1>F2 THEN F3 ELSE F4 END AS F5 FROM TBL

back to features list