Re: Data entry - newbie to VFP

shah wrote:
> Hello,
> 
> 
> In my company there is some talk about migrating to SQL server down
> the road. Currently we have to transition fast out of a an old FPW 2.6
> legacy application to VFP.
> 
> What is the best way to go about building a form for data entry? Is it
> a good practise to bind tables with the form?  I can see it can save a
> lot of developing time but I can see the flexibility to change the
> database from VFP to SQL server on a later date would be seriously
> hampered.
> 
> I just need some pointers at this stage so that we do not start on the
> wrong foot. Any advice or any good books on this subject or any
> examples would be great.
> 
> Thanks in advance,
> 
> Shah
> 
Actually, for speed of development binding to the data is fastest.  And 
if you know your going to use SQL Server later, use parameterized views 
for your data access now, and when you move the SQL you just exhange the 
local views for remote views (as a matter of fact, the upsizing wizard 
will move the data and recreate the views for you as well.)

-- 
Cy Welch
89 Camaro RS 5.0 TBI
03 Malibu