Hey Mark,

I know about your builder. Looking at your code is where I learned to do some of the stuff I needed to do create my little cocamime thingy. I started it a while ago and wanted to clean it up before bringing it to your attention, but alas, no time. So I guess I'll send you what I have. It uses SQL DMO to access the SQL information. I'll also send you the CursorAdapter class I've been using as base classes. I've included some simple methods like .GetBlank() that will give an empty structure blah blah blah... I'll email it to you.

Aloha,

James

>I would like to see it. You may or may not know, but I have a CABuilder posted on UT Downloads that will create a ClassLib with a CA class for every table in a DBC, SQL Server Db or Oracle schema. However, it does not account for tables with associated SPs. Perhaps we could put out a collaborative builder or at least 2 builders that complement each other.
>
>You can also download my builder from http://www.mctweedle.com then clicking the FoxPro Tools link. All source code provided, and extensive comments to document the builder and how the Class Lib can be used can be found near the top of the CABuilder PRG file.
>
>>Hi Martin,
>>
>>I've built a rather simple builder to create cursoradapters that mirror SQL tables where stored procedures exist. I haven't tested it in all scenarios, it's got a crude UI and it's put together rather "at-the-momentish" but I'd be willing to send it to you so you can review and/or modify to fit your needs. I just put something together to satisfy my immediate needs and haven't had time to get it all pretty yet. Let me know if you are interested.
>>
>>Aloha,
>>
>>James