Peter, there are two things you need to learn about
- How does SQL Server work
- How do you work with SQL Server from VFP
IMO, the second part is easier. You can setup a remote view and then treat pretty much like a local view. That might actually be the easiest way to get started. Then look at CursorAdapter and/or SQL PassThrough (SPT).
For the first part, try
http://www.barnesandnoble.com/w/beginning-microsoft-sql-server-2008-programming-robert-vieira/1100321859?ean=9780470257012&itm=1&usri=sql+server+2008Here are some pointers:
- SQL Server doesn't use record numbers. Use an autoinc primary key on every table.
- Everything is done via SQL, which means there is no SCAN, LOCATE, SEEK, etc. (You can do something called a "table scan", which is just what it sounds like, but you have to do it inside a stored procedure and even then, it isn't recommended)
- DELETE is permanent, there is no mark for deletion.
>do you have any book recommendations to read
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer