Aucomplete Oracle error : null

QuestionsAucomplete Oracle error : null
Samsun asked 6 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

3 Answers
varun answered 6 years ago

put that column code

Samsun answered 6 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 6 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.

Your Answer

19 + 3 =

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 / 5. Vote count:

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

Let us improve this post!