>>>I need to append some data from SQL Server into a local table. This is my first attempt to become familiar with SQL Server and remote connections so I need a little help. I have successfully created a remote connection to the Server. This connection is named 'TRP_SQL' and is located in a database named 'newsurveys'. The data I want to append is located in a table named 'exported'.
>>>
>>>I have been able to create a view using the remote view designer and browse the data but I would prefer to create the view programmatically using CREATE SQL VIEW or some other suitable means. I can't seem to get the syntax right to do the job. Here is what I have:
>>>
>>>

>>>close tables all
>>>open database "\\tpdfiles\data\dfreeman\trp\data\surveys\newsurveys"
>>>create sql view tempview connection trp_sql as select * from ...
>>>select mytable
>>>append from tempview
>>>

>>>
>>>There seems to be a need for 2 connection parameters, how do you specify the table?
>>>Can someone help me finish this?
>>>
>>>Also, do I deal with the created view the same way as a temporary cursor? Could this be done with an ordinary SELECT instead of a view? etc?
>>>
>>>
>>>Thanks
>>
>>Don,
>>You don't need a dbc nor a view for this. You can use ODBC/OLEDB instead. ie:
>>
>>

>>* Local instance:.
>>* Trusted_connection=yes: Use windows authentication
>>lcConnectionString = "Driver=SQL server;server=.;Trusted_connection=yes"
>>lnHandle = SqlStringConnect(m.lcConnectionString)
>>SQLExec(m.lnHandle,"select * from myDatabase..myTable","resultCursor")
>>SQLDisconnect(m.lnHandle)
>>select resultCursor
>>browse
>>*select myVFPTable
>>*append from dbf('resultCursor')
>>

Cetin
>
>Thanks Cetin and Edward, you've both pointed me in the same direction which is simpler than where I was going.
>- Don

You may also keep views, that's the best way to quickly view/change data on SQL-server when you test/debug your program.
One more tip: if you call SQL-Server stored procedure through SQLEXEC() it will also return cursor(s), if it has some Select-SQL command(s) inside.