Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Pass a web variable to a stored procedure
Message
 
 
À
27/10/2008 12:01:31
Information générale
Forum:
Visual FoxPro
Catégorie:
Applications Internet
Divers
Thread ID:
01257541
Message ID:
01357406
Vues:
23
>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
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform