Brian,

>I have a Main BizObject that is throwing the following error
>
>Characters found after end of SQL statement.
>How do I get to the SQL Statment? and or where should I start tracking this down?

It looks like there's something about your SQL that ADO.NET doesn't like.

Unless you create a custom data access class, when you're saving data the ADO.NET Command Builder is used to create Insert, Update, and Delete commands based on your original SELECT statement. Alternately, you can set your business object's UpdateSelectCommand property to specify a different SELECT statement on which to build your updating logic. Even at that, sometimes the Command Builder just chokes, and you're forced to create a custom data access class. For details, check out the MM .NET Developer's Guide topic "Creating Custom Data Access Classes".

That said, based on the stack trace you posted, it looks like you're encountering an error before the call is ever made to the data access object which is where the real data access takes place.

Armed with this information, I recommend setting a breakpoint in your application and tracing through to see where the actual error occurs. Check out the MM .NET Dev Guide topic "Stepping through MM .NET Code in the Debugger" for information on stepping through Framework code.

Regards,