Hi, i'd like to know how to do to make the grid update data when their are updated by user input. See my code for more details (index.lzx, other php part is enclosed too, free use). What I like so is this: each time data is updated by user input, update database too (using the dataset) I've made a method which do the job for add, update, delete & list but I don't know how to get the event : this data has been changed btw code is nifty but working =) any comment is welcome =)
snippet of index.lzx
<class name="aGridText" extends="gridtext">
<attribute name="c" type="string"/>
<handler name="ondata">
Debug.write('ondata');
</handler>
<handler name="onblur">
Debug.write(this.text);
</handler>
</class>
<dataset name="clientdata" src="http://localhost/comptes/client.php";
request="false" />
<grid name="grid_clients" width="100%" height="100%">
<datapath xpath="clientdata:/persons" />
<aGridText name="pk" editable="false"
datapath="@id" datatype="number" text="#" />
<aGridText name="nom" editable="true"
datapath="@nom" datatype="string" text="Nom" sortable="true"/>
<aGridText name="prenom" editable="true"
datapath="@prenom" datatype="string" text="Prenom"/>
<aGridText name="adresse" editable="true"
datapath="@adresse" datatype="string" text="Adresse"/>
<aGridText name="ville" editable="true"
datapath="@ville" datatype="string" text="Ville"/>
<aGridText name="cp" editable="true"
datapath="@cp" datatype="number" text="C.P."/>
<aGridText name="screename" editable="true"
datapath="@screename" datatype="string" text="Nom Utilisateur"/>
<aGridText name="password" editable="true"
datapath="@password" datatype="password" text="Mot de Passe"/>
</grid>
//arr:0:nom 1:prenom 2:adresse 3:ville 4:cp 5:screename 6:password
//pk omis, auto_increment oblige
<method name="addClient" args="arr">
var d=canvas.datasets.clientdata;
var p=new LzParam();
var i=0;
p.addValue('action', 'insert', true);
p.addValue("nom", arr[i++], true);
p.addValue("prenom", arr[i++], true);
p.addValue("adresse", arr[i++], true);
p.addValue("ville", arr[i++], true);
p.addValue("cp",arr[i++], true);
p.addValue("screename",arr[i++], true);
p.addValue("password",arr[i++], true);
d.setQueryString(p);
d.doRequest();
</method>
--
Best,
Stéphane ERARD
comptes.rar
Description: Binary data
