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?

The grid requires a primary key for updates as generally the updates will be pushed back to a server of some kind and there needs to be a mechanism to identify exactly which records need to be updated.  That said, if you really don't require the primary key but still want to do updates you can always add a dummy column.

Since you're using an array of JavaScript objects for your data collection you can easily add on a field to each record by looping through the collection and calling [object].[new field name] = value.  After that, add a hidden column to your grid and set it as the primary key, though just make sure the logic for adding the additional field comes before the instantiation of the grid or you may get an error stating that the field doesn't exist.

I've attached an HTML file that uses this approach.  Just remember that doing this makes the primary key essentially meaningless, but for the purposes you describe it should work.

Hi Jason, yes this was suggested before. Unfortunately it didn't work out well because not all methods take in to consideration the hidden columns in the same way. This was talked about here http://es.infragistics.com/community/forums/p/80484/422424.aspx#422424

Trying to massage the code and compensate for all the loops became futile at best. So we are asking for a feature rather then a work around at this point.  There was a bug in the code that allowed updates with no primary key during our year of development. We are asking for this bug to because a feature.

Hello,

Thank you for your patience. We have done some discussing with our development team. Since you don’t want to use a primary key the alternative to having a hidden column with the primary key would be to use the API to do the updating. If you use the API to do the updating of cells. You won’t need the updating and it can be replace by selecting a cell with jQuery to update the text directly then doing the same for the corresponding record in the data source. I am currently working on a sample to demonstrate this behavior. I will continue to work on this sample and will update you by tomorrow with my progress.

I think I follow you a bit here, but I want to make it clear that its not that I dont want to use the workaround. Its that it does not work, maybe in theory it does but there are inconsistencies in the way I outlined already.

So you're thinking of a direct text update of the displayed data? The question then is will it update the datasource JASON records. Assuming not, will there be another way to get all changed data in an array like format. Or, at most a way to get the changed text later with a row,col function of sorts so that I can write a function to get all the changed data.

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.