Samsun asked 11 years ago
Hello,
I have problem when i try use autocomplete feature with Oracle, the field display field with null.
How i solve the problem?
Regards,
Samsun
varunSamsun answered 11 years ago
$col = array();
$col["title"] = "Jenis Pensiun";
$col["name"] = "KD_JENISPENSIUN";
$col["width"] = "40";
$col["editable"] = true;
$col["align"] = "center";
$col["edittype"] = "select"; // render as select
$str = $g->get_dropdown_values("select KD_JENISPENSIUN as k, NM_JENISPENSIUN as v from REF_JENISPENSIUN");
$col["editoptions"] = array("value"=>$str);
$col["search"] = false; // this column is not searchable
$cols[] = $col;
Abu Ghufran answered 11 years ago
For autocomplete, you need to define
$col["formatter"] = "autocomplete";
$col["formatoptions"] = array( "sql"=>"…",
"search_on"=>"…",
"update_field" => "…");
Email me code at [email protected], i'll suggest the possible fixes.
