Datagrid help

[bsouthuk]

Hi

I am trying to update all cells within a column in my datagrid but I cant work out how. I currently have the following code:

Code: Select all

put field "ID6" into theDataA["DealerContactID"]

put 2 into theLineNo

repeat with i = 1 to theLineNo
 dispatch "AddData" to group "MobileNumbersDataGrid" with theDataA, theLineNo
end repeat

However, this actually ADDS 2 new rows but I only want to EDIT the cells within the column of the existing rows. I have the put 2 into theLineNo code but also want it so that it updates ALL the cells within the column not just 2.

Can anyone help with this?

Thanks

Daniel

[Klaus]

Hi Daniel,

as the name suggests and as clearly described in the DataGrid docs, "AddData" will indeed ADD a new line to your datagrid.
Doing so in a repeat loop "with 1 to 2" will result in TWO NEW lines


I am still not sure what exactly you want to do?
And please post the rest of your script, if there is any.


Best

Klaus

[bsouthuk]

If for instance there are 20 rows of data in my datagrid, I want to be able to click a button and for the date to appear in each row of a particular column.

Thanks for your help

[Klaus]

Hi Daniel,

I think you need to loop through the complete datagrid array and change the value of your "DealerContactID" field if I understand you correctly.

Something like this (out of my head, NOT tested!)

Code: Select all

...
## Get the complete data
put the DGData of grp "MobileNumbersDataGrid" into tArray
put field "ID6" into tDealerContactID

## Now update every entry of DealerContactID
repeat for each key tKey in tArray
  put tDealerContactID into tArray[tKey]["DealerContactID"]
end repeat

## Set the data of the datagrid back to the now modified array
set the DGData of grp "MobileNumbersDataGrid" to tArray
...

Best

Klaus

[bsouthuk]

Works perfectly - thank you Klaus!

[Klaus]

Grrrrrreat!