>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
>>>I have just moved to VB from VFP as well. Hopefully not forever. <g> This >>>may seem a crazy idea but why don't you define a class in VFP, create a >>>method that accepts the string you want to convert and the chr's to replace >>>and return the result. Then compile it as a DLL. I think you would have to >>>define the class as Ole Public.
>>>Then you would have to register the foxpro DLL and you could call it from >>>your VB app?
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
Hey Scott. I think that's overkill in this case, but you definitely are thinking about things the right way.... but, keep in mind for future endeavors that loading a VFP DLL is kind of slow, and marshalling between components can also be a bit slow. For instance, in this case, if I were to do this I wouldn't create a method that accepts a string and does the replace (which would require calling this method over and over and over and over) but rather I would accept an entire ADO recordset, take care of it, and send it back.
But again, for this case, I think it is overkill.
The whole problem with the world is that fools and fanatics are always so certain of themselves, but wiser people so full of doubts. - Bertrand Russell