While I can't recommend any books - the help file is pretty good at getting
you
going once you understnad basic sql ishness.
it depends on what sql server you have too -- as to what books are
helpful.
If you use a database & remote views, you can almost use all your existing
code
'as is' with the exception of tables that don't have primary keys already
defined -- otherwise, you need to use sql commands to update.
once you get the concept of not having all the data "locally" for you to
scan or
seek etc. on -- working with sql server will be easy.
So --- what sql server are you using? Will you be using remote views or
access
directly? if so, how wil you connect? com, dsn, etc?
More information and we may be able to get you some better ideas on where
to
look.
On Fri, 17 Aug 2007 09:30:36 -0700, Mike <mikm524@[EMAIL PROTECTED]
> wrote:
>Hi,
>
>My boss is asking me to research integrating VFP with a SQL server
>database. I have never worked with SQL server and have no idea on
>what would the best way be to proceed with this.
>
>Can anyone recommend some good books? Also any potential pitfalls or
>problemes in VFP + SQL server?
>
>Thanks in advance.
>
>Mike
|
