If you try to use your existing FoxPro application with SQL Server database you will face lots of bugs - the database won’t understand the syntax of statements passed from your front end application. The only way to bind an existing FoxPro application to SQL server database was to rewrite existing code line by line. Now there are two ways: you may either spend weeks debugging your code and adjusting it to T-SQL rules, or have EasySQL4Fox do it for you at runtime in a single function call.
EasySQL4Fox ‘translates’ existing statements into syntax SQL Server understands. It is a .fll library which should be included to your project. EasySQL4Fox has its own set of methods which process FoxPro SQL statements and transform them as required by T-SQL standard. All you have to do is pass your existing SQL statement to the needed method of the library. EasySQL4Fox will analyze the text string of the query, make necessary replacements and pass the query to SQL Server database.
(Rate this!)
Loading ...
Loading ...