There are examples, but I can't say they are working examples. Also, how you decide to access SQL Server will change the code as all are different. Your options are:

- Remote Views (I don't recommend this. You can't use stored procedures)
- SQL Passthrough
- OLE DB/ADO
- Cursor Adapter (which will use either SQL Passthrough or OLE DB/ADO but hide some of the plumbing from you)

Personally, I'd use a Cursor Adapter and then use OLE DB/ADO to connect to the data.


>Craig
>
>Thanks for your help thus far. Ideally, it'd be useful to have examples of syntax, it's easier to understand when there are examples in plain English (read: VFP) in front of you. I appreciate I'm probably being very lazy as I would imagine there's a working example of this in the help files?
>
>Regards
>
>Derek