>Craig,
>
>I see that you know much about SQL server. I am considering to start using SQL server (I downloaded the 220 Mb evaluation version, took me some while ...) but I was wondering if there isn't any info how to migrate from the VFP database to SQL server (still using VFP as front end).
>I don't have a problem to move the database to SQL server, nor to manage the SQL server database or connect to it in VFP, but it's rather a matter of habits, I give an example :
>I created a formclass to do basic input where the user can give in a some kind of search value and then the formclass looks up the record, extensivly using indexes and typical foxpro commands that aren't available when using SQL server (seek, set order etc ...). I was wondering if it is possible to have the same functionality on SQL server, by preference with code that can deal both situations (local database or client/server database) or do I have to make the difference in interface and/or development methods.
>
>I give another example : the main app I'm working on has a product file of 35.000 products. Mainly this file is used by product ID : the user keys in a product ID and the product appears : no selection in a list is made (what is more often done in a GUI interface). The code I now use is based on SEEK : how about client server ?
>
>
>Pascal Declercq
>8 years Foxpro DOS
>8 months Visual foxpro
>8 days visual foxpro/sql server
You'll need to use SQL commands with SQL Server. You can use remote views to make this easier. As for creating query screens, look at QBF Builder from
www.classycomponents.com.
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer