>>>>>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.
>
>Thanks Ed. Do you know if it's possible to use DBGETPROP to retrieve field comments from a server based table?
>
>- Don

Do you mean from SQL-Server table? I don't think so, but SQL-Server database should contain bunch of system tables (sorry, I don't have SQL-Server on hand now, so I cannot give exact names). You may run Select commands again any of these tables (providing that you have access rights) and retrieve all system information.