Hi Craig.
>Currently, I have just started working with SQL from VFP. I have created a connection via ODBC and created a database (say: mydatabase.dbc) in which I have added some remote views for specific SQL tables from the connection.
>
>Question! Is there another way to create remote views, or are there WIN2000 utilites that will allow me to do this so I can insert, edit and change SQL table from VFP?
>
>Other then ODBC what are my alternatives, if any, in updating SQL tables from VFP?
>
You are using the Cursor Adaptor, I hope. My experience may be different than yours becuase everything I have done between VFP in front and SQLServer in back is in direct Cursors doing database conversions. The CA handles everything very seemlessly. Even gives a lot of power for databse manipulation. As far as the ODBC goes, I've decided to keep using it, as opposed to vfp oledb driver. Seems to be faster for me.
Regards,
- Glen -
The impossible we do immediately.
The miraculous will take a little longer.