---
Write a VBScript to interface with SQL Server via ADO and write the necessary data to a text file to be imported into a FPW cursor. Not the most elegant approach, to be sure, but one that would work and even be called from the FPW menu
---
Yes, actually that works fine. A person can become intimate with CSCRIPT.EXE for the oddest reasons <g>.
Do think about expanding this approach to have your VBScript call a VFP mid-tier component, however, if you run into scaleability or perf issues, since a single call from the script into the VFP component will be faster than the ADO statements.
Good luck, George...
>L<
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement