>Hi all,
>i am new on vfp8 . i am using ODBC access for some reporting tools . i need best way for accesing to remote data via SPT or CA . would you like to give me a sample with SPT and CA for do this. TIA

If this is only for reporting, I would just use SPT. If the data is to be editied and posted back to the database, then I would use a CA. I do have a free CA VCX Builder that will create a ClassLib with a CA for every table in a VFP DBC, Oracle schema or SQL Server database. It is complete with source code and has extensive documention in the form of comments in the CABuilder PRG file. You can download it at http://www.mctweedle.com/downloads/CABuilder.zip

I am not sure what kind of meaningful example I could provide for SPT. You just use SQLEXEC() to submit your SQL command to the server and have it return a cursor with the results for your report.