|
Why combine Visual
FoxPro with SQL Server?
|
|
If any of your tables are larger than 2 Gb or may exceed this limit in future, you have to use your
FoxPro application as a front end application to a database that doesn't have such limitation. We
recommend that you use SQL Server as
Microsoft
heavily promotes it now. Today opinions on your
application will greatly depend on its compatibility and ability to interact with SQL Server database.
Besides, SQL Server is famous for its reliability (for example, with indexes).
|
|
SQL Server syntax
(T-SQL) is different from FoxPro
implementation of SQL.
|
|
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
helps use FoxPro applications as front end for SQL Server
databases.
|
|
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. The
library has been successfully used in numerous Valley
of the Mind
and
Pinter
Consulting
projects since 2003.
|
|
EasySQL4Fox and its components.
|
|
The
typical shipment of EasySQL4Fox
includes the library
itself and EFOX_Data_Adapter class which is used to abstract application
data domain from database type.
Also, we provide a sample class which shows how both components work.
Download
a free trial version of EasySQL4Fox
and check
whether it is useful for you. If you like it, you may pay
for it and use it in your FoxPro + SQL Server applications. If
you don't like it, just keep on rewriting your code line by line.
|
|
The trial version
allows a limited number of function calls (300 calls) during one library
load session. You cannot use
its full functionality in your
applications. Still, the trial version shows you how EasySQL4Fox works
and helps you check whether it is useful for you.
|
|
EasySQL4Fox
sitemap |
How
to use EasySQL4Fox |
Full manual |
EasySQL4Fox
features |
