Hello all,

I am developing a system using the ASP.NET Mere Mortals framework for an existing FoxPro database system. I am currently getting the following error...

[OleDbException (0x80004005): SQL: Column 'Q19P1' is not found.]
System.Data.Common.DbDataAdapter.UpdatedRowStatusErrors(RowUpdatedEventArgs rowUpdatedEvent, BatchCommandInfo[] batchCommands, Int32 commandCount) +1381980
System.Data.Common.DbDataAdapter.UpdatedRowStatus(RowUpdatedEventArgs rowUpdatedEvent, BatchCommandInfo[] batchCommands, Int32 commandCount) +46
System.Data.Common.DbDataAdapter.Update(DataRow[] dataRows, DataTableMapping tableMapping) +1747
System.Data.Common.DbDataAdapter.UpdateFromDataTable(DataTable dataTable, DataTableMapping tableMapping) +40
System.Data.Common.DbDataAdapter.Update(DataSet dataSet, String srcTable) +183
OakLeaf.MM.Main.Data.mmDataAccessOleDb.SaveDataSet(DataSet ds, String tableName, String primaryKeyName, Boolean retrieveAutoIncrementPK, IDbDataAdapter dbAdapter) +1280
OakLeaf.MM.Main.Business.mmBusinessObject.SaveDataSet(DataSet ds, String tableName, String databaseKey, IDbDataAdapter dbAdapter) +1112
OakLeaf.MM.Main.Business.mmBusinessObject.SaveDataSet(DataSet ds, String tableName, String databaseKey) +46
OakLeaf.MM.Main.Business.mmBusinessObject.SaveDataSet(DataSet ds, String tableName) +75
OakLeaf.MM.Main.Business.mmBusinessObject.SaveDataSet(DataSet ds) +63
OakLeaf.MM.Main.Web.UI.mmBusinessWebPage.Save(mmBusinessObject bizObj, DataSet ds, String tableName) +108

I have approached Mere Mortals directly and was told to recreate the table I am using as the system works with other tables in the FoxPro database. I have done this using COPY STRUCTURE and I am still getting the problem. I have also checked the update statement being used, and traversed through the objects in debugging to make sure that the column (Q19P1) is not listed anywhere. The column name changes each time I run the code.

Has anyone else received this problem, and if so, what was the resolution?

Thanks in advance.