Data Set Item appears Read Only

  • Thread starter Thread starter MikeTI
  • Start date Start date
M

MikeTI

October 15, 2009

Hi all

I am creating and filling a data set using the following query:

Select *, (Select CodeDesc From CodesTable Where CodesTable_Code =
TableB_Code) CodeDesc From TableB

The data set is being used in a Grid that shows all the columns including
"CodeDesc"

Now when I add a row I also add data to the "CodeDesc" which works fine.
However when I update a record, I try to add data to the "CodeDesc" field
and an error msg pops up "Column CodeDesc is Read Only".

What could be the issue.

Mike TI
 
October 15, 2009

Hi all

I am creating and filling a data set using the following query:

Select *, (Select CodeDesc From CodesTable Where CodesTable_Code =
TableB_Code) CodeDesc From TableB

The data set is being used in a Grid that shows all the columns including
"CodeDesc"

Now when I add a row I also add data to the "CodeDesc" which works fine.
However when I update a record, I try to add data to the "CodeDesc" field
and an error msg pops up "Column CodeDesc is Read Only".

What could be the issue.

Mike TI

I don't think it is reasonable to expect that VS can analyze the
sub-query and figure out how to update the value that it returns, if
that is even possible. In this case it is possible, and I think it
might work if you used JOIN rather than a sub-query:

Select TableB.*, CodesTable.CodeDesc
From TableB
Join CodesTable On CodesTable.Code = TableB.Code
 
Back
Top