>Hi George,
>
>>With my suggestion, assuming that there was some delimeter to determine where a number began and ended, I'd use Words() and Wordnum() from Foxtools< g >.
>
>FoxTools is out. To meet current application development criteria I'd write a COM server that runs on MTS, uses a temporary database in MSDE to parse the string and returns the result set via MSMQ server as an ADO record set. < g >
>
Hi Christof,
Maybe in that scenario (I'm not sure of what all the implications are there) you might not be able to use foxtools. However, in tests, I've been able to successfully call an in-process OLE Automation server using Foxtools from Excel. Admittedly, I haven't tested this on a machine yet that doesn't have VFP loaded. One thing I did note, however. When I originally tested it in VFP, just to make sure that there wasn't anything funny going on, I issued SET LIBRARY TO to unload it. After I created the object reference in VFP, SET('LIBRARY') was empty, even though the object's Init sets the library.
Anyway, if the library can be utilized by a COM server, it might provide a means to reducing some code maintenance and overhead that might otherwise be required.
George
Ubi caritas et amor, deus ibi est