Visual FoxPro tips for database developers
Database development in Visual FoxPro requires a range of skills. FoxPro
is a relational database so any effective solution must be based on a
sound database design and must make the best use of the features of the
FoxPro language. We hope that these tips will help you to get the most
from FoxPro and VFP.
Most of these tips apply to Visual FoxPro (VFP 3 to VFP 9) although some
can be applied to FoxPro 2.6 or earlier versions.
This is not a FoxPro tutorial, you will need to know something about the
language in order to get the most
benefit from these tips. All are provided for your guidance rather than
as solutions to particular problems. Refer to the Visual FoxPro Help system for
more detailed information about the syntax of the commands mentioned.
Hints and tips are listed here alphabetically under seven categories:
C# conversion |
Forms and controls|
Visual Basic conversion
Code and programming
Data and databases
to improve data security.
data storage in FoxPro.
data to delimited text files.
Approach data in Visual FoxPro.
data to html files.
data to html files - code sample
connection to a SQL Server database.
and process a FoxPro table.
to Microsoft SQL Server.
Forms and controls
a checkbox to a grid.
a command button to the Visual FoxPro desktop.
tool in FoxPro.
controls on the Form Design toolbar.
a form to make data entry easier.
messages in FoxPro applications.
way for the user to look up FoxPro data.
for data entry
in an executable flash on the screen and vanish.
the main FoxPro window.
driven by a SQL cursor.
in a VFP form.
Queries and SQL
VBA equivalents to FoxPro commands
If you need to know more about FoxPro and Visual FoxPro we run a series of
FoxPro training courses
to help you.