How can we help you today?
VistaDBDataAdapter 5.2 -- "Missing SourceTable mapping"
1 Comment
We'll need more details from the exception (and its InnerException chain) that your app is getting to help analyze just where it's failing. This would be better as a support ticket, so please email the details to support@vistadb.com (or you can open a ticket through the portal if you prefer).
John Tamburo
I am using VistaDB 5.2.0.0 on .NET 4.5.2 winforms. I open a form and populate databound fields from a dataset using a SQL Select and filled with a VistaDBDataAdapter. Changes Made, press OK to update. so I open a new Command on the same connection to post the edits back to the database. The Code:
When I hit the update in this DataAdapter, I get this exception:
Missing SourceTable mapping: 'D_ANIMAL'
The query is "select {a list of columns] from D_ANIMAL where AN_ID = {integer key};" and is the same query used to fill the dataset _ds.
This code above is line for line identical to other code in the program that works. Why is the Data Adapter failing to generate the proper mappings? Exactly how do I remediate this? If I brute force the mappings, it claims that it is missing column mappings for columns that are absolutely in the query and the underlying data table.
This is blocking a major release. Please help ASAP.