Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Pass a web variable to a stored procedure
Message
 
 
To
27/10/2008 12:01:31
General information
Forum:
Visual FoxPro
Category:
Internet applications
Miscellaneous
Thread ID:
01257541
Message ID:
01357406
Views:
24
>Thanks Viv
>Here is my present code
>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 
>endfunc
Which 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.
>:)
>

See you can use any other methods such as strtofile and low-level file functions. Search for VFPOleDB supported and unsupported commands on the web.
If it's not broken, fix it until it is.


My Blog
Previous
Reply
Map
View

Click here to load this message in the networking platform