MY data changes based on many things. The entire use of our software is dynamic not static. So in some circumstances I must add check boxes and other not. This is why I must loop, can this be done?

Hi,
If you set a primaryKey to a column, that column should contain only unique values.
If you have primaryKey, calling of getCellText() should not be done with the index of the row, but with
the data key value(the values of the primary key column).
Thanks, Deyan

Deyan, here is the deal. We wrote a large piece of software with infragistics. Basically it displays lots of tables/grids. To update a cell we double clicked on it and the data changes. Now for what ever reason infragistics decided this primary thing had to be there when updating a cell. This basically busted all of our code. You can read some about that here.

http://es.infragistics.com/community/forums/p/80484/422424.aspx#422424

Now I had to find a way to satisfy this primary key thing so that we can continue working on our software. As you can see in that posting there were some suggestions  about hiding a column but what I found worked best was just to pick some random column and call it a primary key. This fixes our main issues and allowed is to continue to work. Now here and there I keep running into all of these quirks with the primary key stuff. There is no need for a primary key. That is just crazy talk. Worked fine without it so I dont see why it needs to be there. Though I'm sure that does not mean much to the infragistics team :) However as it stands I have no choice but to deal with this.

To fix the issue?

I either need to find a way to call a column a primary key and allow it to work like ever other column or I need the infragistics code fixed so that its consistent and i'll go back to hiding the primary key column. By inconsistent I mean the things noted in that link above. So I'm now in a catch 22 here. All of this because a primary key is now enforced. Just a lot of work for no reason as I see it.

So to make this as short and simple as possible I just want to be able to update a cell without the need of a primary key. Our software just sees this grid as a grid of data, not some link to a database that requires updates.

We love infragistics and it has worked so well for us. One of the best things about the software was how polymorphic it was. You could use it so many ways and it was so adaptable. We really felt the team understood how companies like to work with flexible code not rigid design. This entire primary key decision is undoing all of that. Not everyone will use the grid as a database, some just like to display data and manipulate it.

Please provide us with a solution so that we can continue to use this software.

this fix will work, thx again for the help.

We do have this implemented in our testing but our ID is never the same so to handle this we do the following.

var INSTANCE = this; //set at the class var declarations.

//gets a column from jason data.

for ( i in inData[0] )//this gets us a the first column it finds.
        {
            var priK = i;
        }
        this.priKey = priK;

This seems to be working ok. I'll close this issues as soon as I finish updating all the code to use the new method. Thx so much for your efforts.

Hello,

Thank you for the update. You should be able to achieve this by using a dummy primary key. You will want to have a dummy primary key and column with matching ID. I have attached a modified version of the sample that demonstrates this behavior.

Please let me know if you have any further questions concerning this matter.

Yes this option works fine for us in the issue related to changing the text in a grid. However the issue with start edit mode is still at large. I know info is scattered all over and difficult to understand all the problems this [primary key caused. Though this above fix will take care of most troubles found. We still need a way to enter edit mode without getting errors about pri key. I tried a dummy key like

primaryKey : "???"

but I still get

Error: In order to support update operations after a row was deleted, application should define "primaryKey" in options of igGrid.

on igGridUpdating.startEdit(...)

and when double clicking on a cell.