Use a client side record set and you shouldn't have problems. The updating won't happen until you specify.


>
>Hi Craig,
>
>Ok, so I can just have the data layer get the ADO recordset, then have the business layer pass the recordset off to a CA? I just want to make sure that updating the data in the CA, and then the RS, doesn't automatically get passed to the database.
>
>I've been trying some searches here but there are so many results with cursoradapter and data layer, they bomb. I'll have to find some additional keywords. The examples Mark and Cetin (and others) posted are definitely helpful, not to mention Doug Hennig's FoxTalk articles.
>
>
>- Brian