What is Dynaset Inconsistent?
What exactly does setting to dynaset inconsistent do? I think I remember reading something about having to use this on forms that are based on a query of multiple forms. Is that correct?
This is both a Form property (on the Form property sheet - Data tab) and also a Query property - set in query design view.
mx
mx
ASKER
Is it necessary for me to set this in both the queries and the forms seperately or just on the forms?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks! I have set both queries and forms to dynaset inconsistent.
While that is the affect of inconsistent updates, that really is not the definition of it as it applies to recordsets in general and not just in forms.
Consistent vs inconsistent updates only come into play when you have a recordset based on more then one table. Normally, JET allows changes only to the many side of a join. That's a consistent update. To allow for updates to both sides of the join, you need to use an inconsistent update. You really need to understand why you need to do that as doing so allows you violate relationships between the tables.
The only exception to that is if you've turned on Referential Integrity and cascading updates. In that case, consistent vs inconsistent doesn't matter because even if you change the key on the one side, the many side will get updated anyway.
JET is unique in this regard. Most OLEDB providers don't support inconsistent updates.
JimD.
Consistent vs inconsistent updates only come into play when you have a recordset based on more then one table. Normally, JET allows changes only to the many side of a join. That's a consistent update. To allow for updates to both sides of the join, you need to use an inconsistent update. You really need to understand why you need to do that as doing so allows you violate relationships between the tables.
The only exception to that is if you've turned on Referential Integrity and cascading updates. In that case, consistent vs inconsistent doesn't matter because even if you change the key on the one side, the many side will get updated anyway.
JET is unique in this regard. Most OLEDB providers don't support inconsistent updates.
JimD.
Yes, exactly.
From the Help File:
"Dynaset (Inconsistent Updates) 1 All tables and controls bound to their fields can be edited. "
mx