I have a stored procedure like so in a VFP database.
When run from VFP the code will work fine and both files will be created. However when run from an ASP page the code fails with an error that says "feature not available". If I remove the "copy to " line it will work OK from ASP so I know the file permissions are OK. Any ideas what's happening here? btw- CREATE TABLE also works but my need is for the excel file.
Code:
function createexcel
filespec = (justpath(dbf())+ "../output/sampleout")
select * from sites into table (filespec)
use (filespec)
filespec = (justpath(dbf())+ "../output/sampleout2")
copy to (filespec) type xl5
return filespec
endfunc