PROBLEM USE AUTOCOMPLETE WITH BULKEDIT

QuestionsPROBLEM USE AUTOCOMPLETE WITH BULKEDIT
THALES FACO FILHO asked 2 months ago

Hi Abu!

We have a problem when I change some column using bulkedit.

I use –> “force_select”=>true,

And Bulk Edit give me a error: FIELD IS REQUIRED!

I have this field:

$col = array();
$col[“title”] = “PRODUTO”;
$col[“name”] = “ZW3_PRODUT”;

If ($idioma == ‘PT’){
$cCamDescrM = “B1_YESPEPT”;
$cCamDescr = “B1_IDIPORT”;
}ElseIf ($idioma == ‘EN’){
$cCamDescrM = “B1_YESPEIG”;
$cCamDescr = “B1_IDIINGL”;
}ElseIf ($idioma == ‘FR’){
$cCamDescrM = “B1_YESPEFR”;
$cCamDescr = “B1_IDIFRAN”;
}ELseIf ($idioma == ‘ES’){
$cCamDescrM = “B1_YESPEES”;
$cCamDescr = “B1_IDIESPA”;
}Else{ /*ITALIANO*/
$cCamDescrM = “B1_YESPEIT”;
$cCamDescr = “B1_IDIITAL”;
}

$col[“editable”] = true;
$col[“width”] = “280”;
$col[“formatter”] = “autocomplete”; // autocomplete

// callback function
$col[“formatoptions”] = array( “sql”=>”SELECT B1_COD AS V,B1_COD AS B1_COD,RTRIM(LTRIM(B1_DESC)) AS B1_DESC, B1_PRV1,”.$cCamDescrM.” AS DESCOMPT,
ISNULL(CONVERT(VARCHAR(2047), CONVERT(VARBINARY(2047), “.$cCamDescr.”)),”) AS DESDETPT FROM SB1010 WHERE D_E_L_E_T_ = ‘ ‘
AND B1_TIPO = ‘PA’ AND B1_MSBLQL NOT IN (‘1′) ORDER BY B1_COD,B1_DESC”,
“force_select”=>true,
“search_on”=>”B1_DESC+’-‘+B1_COD”,
“callback”=>”fill_form”);

$cols[] = $col;

 

 

5 Answers
Abu Ghufran Staff answered 2 months ago

Emailed you an update that should fix it

_________________________
Abu Ghufran - Dev Team
PHP Grid Framework
 
Thales answered 2 months ago

ABU,

The Edit its ok, but… The BULK EDIT keep the same problem.

Thales answered 2 months ago

HELLO ABU…

When I update the JQGRID_DIST.PHP, a lot of problems ocurr…

I can’t insert using autocomplete.

I can’t make a Bulk Edit like before

The bulk Edit workd just I use  “force_select”=>false

The error is a internal error 500.

I Needed rollback the include!

Abu Ghufran Staff answered 2 months ago

Please email back your grid code along with related database schema at [email protected]

It will help in checking and regenerating the issue fast.

_________________________
Abu Ghufran - Dev Team
PHP Grid Framework
 
Abu Ghufran Staff answered 1 month ago

Hello,

I’ve received no reply from you. I’m closing this ticket.

If your issue still exist, kindly send code + testdb schema so we can regenerate this issue.

_________________________
Abu Ghufran - Dev Team
PHP Grid Framework
 
Your Answer

3 + 15 =

Login with your Social Id:

OR, enter

Attach code here and paste link in question.
Attach screenshot here and paste link in question.



How useful was this discussion?

Click on a star to rate it!

Average rating 0 / 5. Vote count: 0

No votes so far! Be the first to rate it.

We are sorry that this post was not useful for you!

Let us improve this post!

Tell us how we can improve this post?