"Adding a row" trouble

Suite and Optimus Suite 5
#1

I want to add a row in a grid.
I’ve used this code

var newId = (new Date()).valueOf();
this.Grid.addRow(newId,",b,c,d,e,f,g,h");

The problem is that the first col of the grid is the id. It’s possible to insert a value for all col except the first?

Initialization xml

<?xml version='1.0' encoding='iso-8859-15'?> <rows><head><beforeInit> <call command="attachHeader"><param>,#text_filter,#text_filter,#text_filter,#text_filter,#numeric_filter,#text_filter,#select_filter</param></call> </beforeInit><column width="100" type="ed" sort="str" id="id"></column><column width="100" type="ed" sort="str" id="articolo">articolo</column><column width="250" type="ed" sort="str" id="nome">nome</column><column width="150" type="ed" sort="str" id="pack">pack</column><column width="150" type="ed" sort="str" id="volume">volume</column><column width="50" type="ed" sort="int" id="ordine">ordine</column><column width="200" type="coro" sort="str" id="foto">foto<option value="01_g.jpg">01_g.jpg</option><option value="03_g.jpg">03_g.jpg</option><option value="04_g.jpg">04_g.jpg</option><option value="26_41_rossa_G.jpg">26_41_rossa_G.jpg</option><option value="26_g.jpg">26_g.jpg</option><option value="39_1_g.jpg">39_1_g.jpg</option><option value="39_g.jpg">39_g.jpg</option></column><column width="90" type="coro" sort="int" id="dimensione">dimensione<option value="1">1</option><option value="2">2</option><option value="3">3</option></column><afterInit><call command="setSkin"><param>dhx_skyblue</param></call><call command="methodName"><param>catalogo</param></call></afterInit></head></rows>

data xml

<?xml version='1.0' encoding='utf-8' ?><rows><row id='1'><cell><![CDATA[1]]></cell><cell><![CDATA[01]]></cell><cell><![CDATA[Broom EUROPEA Eco.]]></cell><cell><![CDATA[pack xxx]]></cell><cell><![CDATA[volume xxx]]></cell><cell><![CDATA[1]]></cell><cell><![CDATA[01_g.jpg]]></cell><cell><![CDATA[1]]></cell></row><row id='2'><cell><![CDATA[2]]></cell><cell><![CDATA[03]]></cell><cell><![CDATA[Broom EUROPEA Extra]]></cell><cell><![CDATA[pack xxx]]></cell><cell><![CDATA[volume xxx]]></cell><cell><![CDATA[2]]></cell><cell><![CDATA[03_g.jpg]]></cell><cell><![CDATA[1]]></cell></row><row id='3'><cell><![CDATA[3]]></cell><cell><![CDATA[04]]></cell><cell><![CDATA[Broom 3 MYLADY Red & Black]]></cell><cell><![CDATA[pack xxx]]></cell><cell><![CDATA[volume xxx]]></cell><cell><![CDATA[3]]></cell><cell><![CDATA[04_g.jpg]]></cell><cell><![CDATA[1]]></cell></row><row id='4'><cell><![CDATA[4]]></cell><cell><![CDATA[26]]></cell><cell><![CDATA[26.30 Push Broom cm 30-40-60 stiff fibre]]></cell><cell><![CDATA[pack xxx]]></cell><cell><![CDATA[volume xxx]]></cell><cell><![CDATA[4]]></cell><cell><![CDATA[26_g.jpg]]></cell><cell><![CDATA[2]]></cell></row><row id='5'><cell><![CDATA[5]]></cell><cell><![CDATA[26.41]]></cell><cell><![CDATA[Soft Push Broom cm 40]]></cell><cell><![CDATA[pack xxx]]></cell><cell><![CDATA[volume xxx]]></cell><cell><![CDATA[5]]></cell><cell><![CDATA[26_41_rossa_G.jpg]]></cell><cell><![CDATA[2]]></cell></row><row id='6'><cell><![CDATA[6]]></cell><cell><![CDATA[39]]></cell><cell><![CDATA[Folding Dustpan ARA]]></cell><cell><![CDATA[pack xxx]]></cell><cell><![CDATA[volume xxx]]></cell><cell><![CDATA[6]]></cell><cell><![CDATA[39_g.jpg]]></cell><cell><![CDATA[3]]></cell></row><row id='7'><cell><![CDATA[7]]></cell><cell><![CDATA[39.1]]></cell><cell><![CDATA[Folding Dustpan w/rubber]]></cell><cell><![CDATA[pack xxx]]></cell><cell><![CDATA[volume xxx]]></cell><cell><![CDATA[7]]></cell><cell><![CDATA[39_1_g.jpg]]></cell><cell><![CDATA[3]]></cell></row><row id='11'><cell><![CDATA[11]]></cell><cell><![CDATA[b]]></cell><cell><![CDATA[c]]></cell><cell><![CDATA[d]]></cell><cell><![CDATA[e]]></cell><cell><![CDATA[0]]></cell><cell><![CDATA[g]]></cell><cell><![CDATA[0]]></cell></row></rows>
#2

The code which you are using will set empty value for the first column, it will have the same effect as not setting column value at all, or do you desire some other effect?

In any case, you can use
this.Grid.cells(newid,0).setValue(any)
to alter id column after row adding

If you need to ignore id column on the server side - check
docs.dhtmlx.com/doku.php?id=dhtm … _connector

#3

I want to have the first column filled with the autogenerate id of the table.

#4

If you are using dataprocessor

dp.attachEvent("onAfterUpdate", function(sid, action, tid){ if (action == "inserted") grid.cells(tid, 0).setValue(tid); return true; })