jQuery Grid Plugin - jqGrid - Topic: Adding datas http://www.trirand.com/blog/?page_id=393/help/adding-datas Simple:Press Version 5.7.5.3 tony on Adding datas http://www.trirand.com/blog/?page_id=393/help/adding-datas#p15274 Help http://www.trirand.com/blog/?page_id=393/help/adding-datas#p15274 Hello,

IMHO this is not jqGrid problem. We have a wide range of events to do what you want,  but we do not have a solutions on how you will check if the record exists in the database.

Instead maybe you will use ajax in mycheck function to determine if the record exists in the DB. The more important part here is that you need to use ajax with async option set to false.

Best Regards

Tony

]]> Mon, 01 Mar 2010 21:13:11 +0200 JiheL on Adding datas http://www.trirand.com/blog/?page_id=393/help/adding-datas#p15177 Help http://www.trirand.com/blog/?page_id=393/help/adding-datas#p15177

Hello Tony,

First of all, thanks for your help about CSS trouble with modal dialog box, I hope you can solve it soon.

Now I'm going further and try to add some datas in my database with add modal box.

I saved my datas and that's fine.

My question is about how to validate datas before updating db :

[Image Can Not Be Found]

I would like to test if the 'code client' filled '44a' already exists in the db, in this case, adding datas cannot be performed and user have to be informed, otherwise I would like to populate 'raison sociale','site' in the row with extracted datas from db, and put 'code client' value in uppercase.

Here is my code for this field :

{name:'code',index:'code', width:30, sortable:true,
  editable:true,
  edittype:"text",
  editoptions:{
    readonly:false,size:5,maxlength:5
  },
  formoptions:{
    label:"Code client", elmprefix:"<font color='red'>&nbsp;*&nbsp;</font>"
  },
  editrules:{required:true,custom:true,custom_func:mycheck}
}

and the test function :

function mycheck(value,colname) {
  switch(colname){
    case "Code client":
      if(value > "") {
        $("#code").val()=value.toUpperCase();
        return [true,"OK",""];
      }
      break;
    default:
        return [false,"Code CLIENT erroné",""];
  }
}

I think that I have to put some code in this function for accessing db and extract fields values, but I don't know how to address row cols with these values.

And the last point, how to avoid to have added row when 'code clt' already exists in database ?

I have read many chapters in wiki without finding any way to progress. Sorry to disturb you in your great job.

I hope you will give me some way to continue.

Have a nice day and a good we.

Best regards

Jihel

]]> Fri, 26 Feb 2010 12:53:48 +0200