Peter,

I can't think of any direct advantages of VFP9 for these two things, unless they've fixed some of the things that make ActiveX controls a PITA. I think there were only a couple "issues" with the Chado control. If you end up messing with it, let me know and I'll dig up the few work-arounds I ended up needing. Maybe some of the new reporting features for the RTF text might be relevant.

What you'd be doing here with SQL is pretty basic. There are certainly advantages with VFP9, but I can't think of any SQL changes that would matter for this scenario.

I think you'll find that this is far easier than you fear.


>Dan:
>
>Thanks for the suggestions. I will follow up and investiage the RTF control. I especially appreciate input related to your prior experience on this.
>
>BTW - I'm starting to read about VFP 9 and it's tighter connectivity with SQL Server. I'd be open to using VFP 9 for this project if there were advantages for this particular project.