Mark,

First of all, I want to thank you for that code. I learned a lot from it (anyway, a lot more than the help). At the end, I made a .NoDataOnLoad property, inspired by your CA Builder and now it works somehow.

The transaction problem, instead, is a _big_ issue, and I don't understand why I never seen threads on this. I am the first programmer using cursoradapters and transactions? Can't believe that.

About adding the CAs to the DE, I did exactly what you said, and have seen the problem i've complaining about. The fields are messed if the selectcmd is a join. And i have _a_lot_ of them. By 'messed' i understand the "Autoupdate" tab. The field's list lose the setting I made in the class. The CA class doesn't subclass correctly and I have to correct them over and over again. That's a bug, and I won't take any other explanation here.

You know, I am a Microsoft fan. I have a deep respect for BOL, for VFP's help, and believe me or not, for Access XP's help - imo, the best documentations I ever seen. One of the things I hate at Linux is documentation. I've seen a clone of excel having 3 mb help file, with a single page: "coming soon". I agree it's free, but this is not an excuse for documentations to be worse.

Unfortunatelly, the VFP8 help about cursor adapter is just a little better than that. I couldn't find any reference to almost anything - it just says how to set the properties. No example, no nothing. The SAMPLES show how to download the records. Not a single word about updating, managing transactions, unbinding controls to make a use for CA in dataenvironment with .ControlSource set at design time - I had to discover that myself.

WHY DO ONE NEED TO ASK QUESTIONS IN A FORUM FOR THAT? WHERE ARE THE DOCS? ANYONE AT MS HEARS?

I'm sorry, I had a very bad week, and all my troubles are CA related. What the h##$....

>I can not help with the transaction problem, but if you use CA created by my CABuilder PRG file, there are custom properties that the CA will use for options like NoDataOnLoad and UseCursorSchema parameters used by CursorFill method.
>
>To add a CA that is in a VCX to the DE of a form, right-click in the DE of the form and select Builder... option. Click on the second tab, "2. Cursors" and click the Add... button. Find the VCX you just created with this builder, then select the CA from the VCX you wish to add. Edit the Name and Alias properties in the builder if needed. Add other CAs as needed then close the builder.
>
>The builder will add some method code to the CAs added to the DE. It is perfectly OK to remove all this code as it is also in the same methods of the CAs in your VCX. It also is OK to just leave the code alone.
>
>This, along with setting the DataSource, etc., is also documented in the comments of my CABuilder PRG file.
>
>