Problem with Schemas
-
Hi, I have a schema which reflects a table in the database. I've just added a field to the schema table, called Watermark. I've built the library. But when I access it in my main project, the intellisense works:
reportSchema.Dataset.tblReport(recordnum).WatermarkBut at runtime, I get an error: Watermark is not a member of tblReportRow I've tried removing and readding it a few times. Its like the autogen code in vs2005 hasnt updated everything. Anyone seen this before? -
Hi, I have a schema which reflects a table in the database. I've just added a field to the schema table, called Watermark. I've built the library. But when I access it in my main project, the intellisense works:
reportSchema.Dataset.tblReport(recordnum).WatermarkBut at runtime, I get an error: Watermark is not a member of tblReportRow I've tried removing and readding it a few times. Its like the autogen code in vs2005 hasnt updated everything. Anyone seen this before?Mark06 wrote:
I've just added a field to the schema table, called Watermark.
Did you just add this field to the database only?? The designer will not know this happened and hence, won't regenerate the code you're talking about. You either have to scrap your existing dataset and drag the table to the desginer again, or you have to modify the designer generated code by hand to add this field and all the support for it.
A guide to posting questions on CodeProject[^]
Dave Kreskowiak Microsoft MVP Visual Developer - Visual Basic
2006, 2007