Database splitting?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Home - 22 Feb 2004 12:45 GMT

Hi,

i have years of experience with access. As i walk into its limitations i am
checking out visual foxpro witch is much more powerfull then access. As i
like to create a client / server application i do not understand how visual
foxpro manage this. In access i used to split the database and from the
client application i accessed the data directly or with a odbc. How do i do
this in vfp. With upsizing i can create a sql-server or oracle database, can
i also create a vfp database?

Thanks!

Rogier

Reply to this Message

Mike Gagnon - 22 Feb 2004 13:13 GMT

In VFP a database is a container that holds the different table.
So in order to access that "customer" table, you might use:
open database myDataBase.dbc shared
use customer.dbf shared again in 0 && For multiuser access
select customer
browse

> Hi,
>
[quoted text clipped - 9 lines]
>
> Rogier

Reply to this Message

Cindy Winegarden - 22 Feb 2004 16:28 GMT

> i have years of experience with access. As i walk into its
> limitations i am checking out visual foxpro witch is much more
> powerfull then access. As i like to create a client / server
> application i do not understand how visual foxpro manage this. In
> access i used to split the database and from the client application

In FoxPro the program code, forms, reports, class libraries, etc. are all
built into an executable. The tables and their indexes and memo files (DBF,
CDX, FPT) are separate files, and are stored on a file server. Like Access,
VFP can be used as a front-end to an ODBC database such as MS SQL Server, or
even an Access MDB. The maximum size for each file (each of DBF, CDX, FPT)
is 2GB.

> I accessed the data directly or with a odbc. How do i do this in vfp.

When using a VFP executable with VFP tables the tables are accessed natively
with the USE command (opens the table) and with xBase commands such as
REPLACE to change data. You can also use VFP's SQL engine to select data for
a report, etc.

> With upsizing i can create a sql-server or oracle database, can i
> also create a vfp database?

VFP has an Upsizing Wizard that will upsize a database and its stored
procedures to MS SQL Server. While there is no native wizard to migrate
Access tables to FoxPro tables, there's one written by someone in the user
community, available as a free download from www.universalthread.com, a
popular web-based forum for VFP and other technologies. To my knowledge
there is no tool that will migrate Access forms, reports, and program code
to VFP.

Signature

Cindy Winegarden MCSD, Microsoft Visual FoxPro MVP
cindy.winegarden@mvps.org www.cindywinegarden.com

Reply to this Message