This is a migrated thread and some comments may be shown as answers.

exclude read only column from automatic insert/update logic

1 Answer 92 Views
Grid
This is a migrated thread and some comments may be shown as answers.
Matthew
Top achievements
Rank 1
Matthew asked on 01 Jul 2010, 06:34 PM
I have a radgrid row containing bound columns to my SQL Data source.

My SELECT procedure includes a number of derived values (such as math results or related info)

These columns in the grid are marked as "read only" which properly prevents them from being given edit boxes during insert procedures.

However... must I use some additional logic to prevent them from trying to be used in the automatic insert function?

That is... of the 8 columns in my grid, only 4 have "real" insertable values and the rest are just displayed for reference.
Thus my INSERT and UPDATE stored procedures only take 4 parameters.

upon insert/edit the app throws the following error:

Procedure or function <function name> has too many arguments specified.


So my immediate assumption is that the "automatic" insert/update option is trying to pass ALL the columns.... Am I incorrect here?
How should i be doing this?


Thanks

EDIT: Actually, the update logic is working properly. The Insert is the sole issue


1 Answer, 1 is accepted

Sort by
0
Matthew
Top achievements
Rank 1
answered on 01 Jul 2010, 06:58 PM
I have resolved the issue.

I had a bound column for one of my datakeys, but the automatic insert logic already derives the value without the bound column.
Tags
Grid
Asked by
Matthew
Top achievements
Rank 1
Answers by
Matthew
Top achievements
Rank 1
Share this question
or