Debug advise please

  • Thread starter Thread starter John
  • Start date Start date
J

John

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 said:
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.
Click to expand...

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#)
------------------------------------------------------------------------
 
Back
Top