Data Set Item appears Read Only

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
 
J

Jack Jackson

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top