>>function CreateCSV() >> >>use c:\inetpub\wwwroot\aspxtest\app_data\library3 >>*set safety off >>*set talk off >>*set console off >>*set alternate to c:\inetpub\wwwroot\aspxtest\app_data\PAGLibrary.txt >>*set alternate on >>*scan >>*? library3.title >>*endscan >>*set alternate off >>*set alternate to >>*set safety on >>*set talk on >>*set console on >>use >>endfunc>>Which runs OK. But if I uncomment the print line it fails. My original code was
>>function CreateCSV() >> >>use c:\inetpub\wwwroot\aspxtest\app_data\library3 >>set safety off >>copy to c:\inetpub\wwwroot\aspxtest\app_data\tempfile type csv >>set safety on >>use >>endfuncWhich also failed. Error in both cases is "Feature not available". Note that I have used the full path to ensure that it is going to a folder with correct permissions and that the user (me) has no problems reading and writing to other files in this folder. Of additional interest is the fact that if I omit the TYPE clause from the COPY TO command it will work just fine. So apparently it is the TYPE clause that is causing the problem.
>>>> >>>>Dim oConnVFP As New Data.OleDb.OleDbConnection(ConfigurationManager.ConnectionStrings("VFPLibrary").ConnectionString) >>>>Dim objCommandCSV As New System.Data.OleDb.OleDbCommand("do createCSV", oConnVFP) >>>> >>>>objCommandCSV.CommandType = Data.CommandType.StoredProcedure >>>> >>>>oConnVFP.Open() >>>>objCommandCSV.ExecuteNonQuery() >>>>oConnVFP.Close() >>>>>>>>But this doesn't work. Thanks