>Sergey,
>Thank you for the Link...already I am getting confussed as they start getting into SBT, and pass through. I have never done any real SQL language before.....and yes from the other night I undrstand you cant use VFP commands that you can use in an SQL select statment in VFP ie, there is no logic field in SQL tables , which was brought up the other night.
It's not SBT but SPT - SQL Path-Through.
There's a link to Robert Green article 'Integrating SQL Server with Visual FoxPro'
http://msdn.microsoft.com/archive/default.asp?url=/ARCHIVE/en-us/dnarfoxgen/html/msdn_bko02.asp. It should help you started.
>
>what I am looking for is how can I move a copy of SQL tables from an SQL 7 server to my home PC with out having to install (and get another licence) to my pc, and start to gather data from the tables using VFP.
>
You cannot just copy Sql Server from one PC to another. It has to be installed. The data can be copied. I think If you owe VS you can download MSDE 7 for free. Let me know if you are interested and I'll try to find the link.
--sb--