Lisa,
>---
> 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>.
Well, actually it would be WSCRIPT.EXE because I'd be calling it via ShellExecute. My friend, the late, great, Dr. Ed Rauh beat me over the head with the possibilties of the WSH so many times I picked up a copy of the Esposito book from Wrox. So much so that he and I wrote a series of articles for VFUG.
>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.
I would've gone with that but I was trying to avoid having to make an install. IOW, this was intended to be "quick and dirty".:-)
>Good luck, George...
Thanks Lisa,
George
Ubi caritas et amor, deus ibi est