What's the error?
>The following procedure when called from an asp page will create the DBF but fails on the copy to xl5. Is there a reason why the copy command won't work and is there a fix?
>Thanks
>
>
>*** Stored procedure
>function createexcel
> lparameters lcSQL
> *execscript(lcSQL)
> 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
>
_______________________________________________________________
Testing displays the presence, not the absence of bugs.
If a software application has to be designed, it has to be designed correctly!
_______________________________________________________________
Vladimir Zografski
Systems Analyst