>Hello All,
>I am new to FoxPro, I am trying to add a Generat report to program that my company already have.
>My Question is:
>How can I connect to SQL tables that all ready there, with out update them, that I will be able to use the data to creat the reports.
>
>Thank you,
>
>Roy Finaly.


Do you mean MS SQL Server tables?
You can use SQL Pass-Through to do that.

You would use the SQLCONNECT( ) or the SQLSTRINGCONNECT( ) functions to connect to Sql Server and the SQLEXEC() function to get data into foxpro cursor.

BTW, there's topic 'Using SQL Pass-Through Technology' in VFP help.