>can I use Microsoft SQL as back end and Visual foxpro without having to create table or database inside visual foxpro
>any help
>
>thank you
You can use several different ways to connect to SQL server: you could use ODBC connection or you can instance an ADO ActiveX control.
ADO in newer technology, but it does not make cursor, and you should use data RecordSet. Personally I prefer to use DOBC connection, because the result of my queries is FoxPro cursor and I can handle it using all FoxPro features and in addition to that I can write select statements to join these cursors as native FoxPro tables.
You can use SQLCONNECT or SQLSTRINGCONNECT to connect to your server. SQLEXEC function allows you to execute SELECT, INSERT, UPDATE and DELETE statements and all other SQL Server commands.
At the end of your program you should use SQLDISCONNECT to disconnect from the server.
HTH
Venelina Jordanova
Outsourcing IT Services Ltd.