Mark,

This brings up another question. I have asked about whether its better to have
a single generic CA for an app, or one for every table. If you go with one for
every table, how do you deal with JOIN's?

Thanks


>>I have been posting threads on the CA lately. We are migrating from VFP to
>>SQL Server, and we're considering CA's.
>>
>>But is there any reason why we cannot simply convert without using CA'?
>>
>>What are the PRO's and CON's of using/not using CA's?
>>
>>Thanks
>
>By now, you have some good information. I have developed a CA Builder that will create a classlib of CAs for each table in a DBC, SQL Server or Oracle DB. The one I have for VFP9 is data driven so it can be extended to other SQL sources as well as any additional properties or methods you would like to add to your CAs. The buidler includes all source code, is free to use, and includes extensive comments on its use near the top of the builder PRG file. You can download it by clicking the FoxPro Tools link at http://www.mctweedle.com.