Hi

I have a strongly typed dataset winform app. When I try to update a table
via;

daStaff.Update(ds.Staff)

I get an 'Expression too complex' exception but it does not tell me which
expression is too complex or which table field(s) is involved. What is the
way to proceed from here to debug this problem? MS Access is the backend
database.

Thanks

Regards

John wrote:
> Hi
>
> I have a strongly typed dataset winform app. When I try to update a table
> via;
>
> daStaff.Update(ds.Staff)
>
> I get an 'Expression too complex' exception but it does not tell me which
> expression is too complex or which table field(s) is involved. What is the
> way to proceed from here to debug this problem? MS Access is the backend
> database.

Do you have a stacktrace? The stacktrace will show you if this happened
inside ms access (or better: the oledb provider), or that it happened
inside the dataset for example.

You could try to switch off optimistic concurrency, so there's no long
WHERE clause in updates to see if that fixes it for you

FB

--
------------------------------------------------------------------------
Lead developer of LLBLGen Pro, the productive O/R mapper for .NET
LLBLGen Pro website: http://www.llblgen.com
My .NET blog: http://weblogs.asp.net/fbouma
Microsoft MVP (C#)
------------------------------------------------------------------------