Re: VFP 9/SQL Server Integration Question
- From: "Dan Freeman" <spam@xxxxxxxxxxxxx>
- Date: Tue, 27 Sep 2005 13:54:10 -0700
It's not endemic to VFP9. You can do it in VFP6 too! Take a look at the help
file entry on Remote Views.
Now, the whole "Zen" of application development changes when you move to a
back-end server. So this is a bit of an oversimplification but you can
switch a remote view for your DBF in a form's data environment and you're
there. A remote view (or local view) behaves exactly like a table. You can
USE it, SCAN it, LOCATE in it, REPLACE in it, etc.
Remember that Zen thing? The goal when you're dealing with SQL Server (or
any back end) is to only include in your views the data that's necessary for
the task at hand. That's where parameterized views come in. You only bring
the data across the wire that you need *right now*.
For a good book on this topic (written in the VFP6 timeframe even, I think)
go visit hentzenwerke.com and look for "Client-Server Applications" (or
something approximately like that) in their catalog.
Dan
Mike wrote:
> Hi. I have several VFP 6 applications which I want to keep in FoxPro
> but I want to move the databases to SQL Server. I've heard that VFP
> 9 allows you to interact with SQL tables using FoxPro database
> commands, allowing for a more seamless transition to SQL Server.
>
> For example-
> If I have a FoxPro DBF named TABLE1, and I currently issue the
> statement "USE TABLE1" to use the table, can I create a SQL table
> named "TABLE1" (with the same data structure, etc) and be able to
> interact with that table by still issuing the "USE TABLE1" command?
>
> Thanks.
.
- Follow-Ups:
- Re: VFP 9/SQL Server Integration Question
- From: Paul Pedersen
- Re: VFP 9/SQL Server Integration Question
- Prev by Date: Re: "File Must Be Opened Exclusively" Message
- Next by Date: French Calendar Control
- Previous by thread: Re: "File Must Be Opened Exclusively" Message
- Next by thread: Re: VFP 9/SQL Server Integration Question
- Index(es):
Relevant Pages
|
|
