---
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<
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only