Hello,

I'm creating the connection to MS SQL server via SQLSTRINGCONNECT command.
Can I create temporary remote view using that connection?

Here is my code:

lcConnString="Driver={SQL Server};Server=SERVER2\FBSQL;Database=TestDB;Uid=user;Pwd=password;"
lhConnection = SQLSTRINGCONNECT(lcConnString)

CREATE SQL VIEW vTest REMOTE CONNECTION lhConnection SHARE ;
  AS SELECT * FROM Table1

My task is to transfer a lot of data from DBF to SQL table. So, I will create remote view and... or (I just got idea) I can use CursorAdapter?