Autocomplete on lookup object

[massiws]

I read the wiki http://wiki.nubuilder.com/tiki-index.ph ... uilderDocs about lookup object and in the screenshot I see an Autocomplete field (just bottom the Read Only field).
It's visible and well explained also in the tutorial video http://www.youtube.com/watch?feature=pl ... v5-4G7CaIk.

Is this function disabled by default? How can I activate it?

Thank you.

[zazzium]

yes it's disabled by default and you activate it by setting it to 'yes'

but if u dont see the autocomplete option ..then what version of nuBuilder you have?
(the autocomplete option was added in version 11.11.03)

[massiws]

I have installed nuBuilder 2.6, but the Autocomplete field is missing...

Edit:
another feature present in the wiki (http://wiki.nubuilder.com/tiki-index.ph ... uilderDocs) I can not see it in my installation nubuiolder 2.6: the tab "help" in the form ...

[shane]

this should be fixed in a new release this week

[esstein]

I have installed nuBuilder 2.6, but the Autocomplete field is missing... :(

I have tested this amazing feature. What I did?

Insert object:

Code: Select all

INSERT INTO `zzsys_object` (`zzsys_object_id`, `sob_zzsys_form_id`, `sob_all_access_key`, `sob_all_admin_only`, `sob_all_class`, `sob_all_clone`, `sob_all_column_number`, `sob_all_display_condition`, `sob_all_name`, `sob_all_sql_run_before_display`, `sob_all_start_cursor`, `sob_all_on_blur`, `sob_all_on_change`, `sob_all_on_double_click`, `sob_all_on_focus`, `sob_all_on_key_press`, `sob_all_tool_tip`, `sob_all_order_number`, `sob_all_tab_number`, `sob_all_tab_title`, `sob_all_title`, `sob_all_type`, `sob_all_comment`, `sob_button_admin_only`, `sob_button_display_condition`, `sob_button_left`, `sob_button_length`, `sob_button_top`, `sob_button_skip_browse_record_id`, `sob_button_zzsys_form_id`, `sob_button_image_on_mouse_up`, `sob_button_image_on_mouse_down`, `sob_display_align`, `sob_button_browse_filter`, `sob_display_format`, `sob_display_length`, `sob_display_sql`, `sob_dropdown_default_value_sql`, `sob_dropdown_length`, `sob_dropdown_no_blanks`, `sob_dropdown_no_duplicates`, `sob_dropdown_read_only`, `sob_dropdown_sql`, `sob_graph_sql`, `sob_graph_zzsys_graph_id`, `sob_graph_query_string`, `sob_graph_code`, `sob_hidden_default_value`, `sob_html_code`, `sob_inarray_default_value_sql`, `sob_inarray_length`, `sob_inarray_no_blanks`, `sob_inarray_no_duplicates`, `sob_inarray_read_only`, `sob_inarray_sql`, `sob_listbox_height`, `sob_listbox_length`, `sob_listbox_button_style`, `sob_listbox_sql`, `sob_lookup_button_length`, `sob_lookup_code_class`, `sob_lookup_code_field`, `sob_lookup_code_length`, `sob_lookup_default_value_sql`, `sob_lookup_description_class`, `sob_lookup_description_field`, `sob_lookup_description_length`, `sob_lookup_sql`, `sob_lookup_load_zzsysform_id`, `sob_lookup_zzsysform_id`, `sob_lookup_id_field`, `sob_lookup_javascript`, `sob_lookup_no_blanks`, `sob_lookup_no_description`, `sob_lookup_no_duplicates`, `sob_lookup_read_only`, `sob_lookup_autocomplete`, `sob_password_length`, `sob_password_no_blanks`, `sob_subform_zzsysform_id`, `sob_subform_browse_filter`, `sob_subform_blank_rows`, `sob_subform_delete_box`, `sob_subform_foreign_key`, `sob_subform_height`, `sob_subform_left`, `sob_subform_primary_key`, `sob_subform_read_only`, `sob_subform_selected_row_color`, `sob_subform_sql`, `sob_subform_table`, `sob_subform_title_height`, `sob_subform_top`, `sob_subform_width`, `sob_subform_odd_background_color`, `sob_subform_even_background_color`, `sob_text_align`, `sob_text_date_button_length`, `sob_text_default_value_sql`, `sob_text_format`, `sob_text_length`, `sob_text_mask`, `sob_text_no_blanks`, `sob_text_no_duplicates`, `sob_text_password`, `sob_text_read_only`, `sob_text_total`, `sob_textarea_height`, `sob_textarea_default_value_sql`, `sob_textarea_length`, `sob_textarea_no_blanks`, `sob_textarea_read_only`, `sob_words_length`, `sys_setup`, `sys_added`, `sys_changed`, `sys_user_id`) VALUES('14fe6235e8bae7', 'object', '', '0', '', '1', 10, '', 'sob_lookup_autocomplete', '', '', '', '', '', '', '', NULL, 600, 100, 'Lookup', 'Auto Complete', 'dropdown', NULL, NULL, NULL, 0, 0.00, 0, '', '', NULL, NULL, '', '', NULL, 0.00, '', '', 5.00, '', '', '', 'SELECT sli_option, sli_description FROM zzsys_list WHERE sli_name = ''answer''', NULL, '', NULL, '', NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, 0, 0.00, NULL, '', NULL, NULL, '', 0.00, '', NULL, '', 0.00, NULL, '', '', '', '', '', '', '', '', NULL, NULL, NULL, '', '', 0, '', '', 0, 0, '', '', '', '', '', 0, 0, 0, '', '', '', NULL, '', '', 5.00, NULL, '', '', '', '', NULL, '', '', 0.00, '', '', 0.00, '1', '2012-06-24 05:43:18', '2012-06-24 05:43:18', 'globeadmin');

On productionnu2/autocomplete.php, find the text:

Code: Select all

        $SQL->setOrderBy(" ORDER BY code ASC, name ASC ");

and replace to:

Code: Select all

        $SQL->setOrderBy(" ORDER BY code ASC, id ASC ");

It have a small issue on presentation when the search string finish with space, like: "Steve ", but it is a minor problem.

Remember: it is unofficial, but it works for me.

Evandro

[massiws]

esstein,

that's ok! This fix the problem.
I only have to set to 1 in the sys_setup field in zzsys_object table.

Code: Select all

INSERT INTO `zzsys_object` (`zzsys_object_id`, `sob_zzsys_form_id`, `sob_all_access_key`, `sob_all_admin_only`, `sob_all_class`, `sob_all_clone`, `sob_all_column_number`, `sob_all_display_condition`, `sob_all_name`, `sob_all_sql_run_before_display`, `sob_all_start_cursor`, `sob_all_on_blur`, `sob_all_on_change`, `sob_all_on_double_click`, `sob_all_on_focus`, `sob_all_on_key_press`, `sob_all_tool_tip`, `sob_all_order_number`, `sob_all_tab_number`, `sob_all_tab_title`, `sob_all_title`, `sob_all_type`, `sob_all_comment`, `sob_button_admin_only`, `sob_button_display_condition`, `sob_button_left`, `sob_button_length`, `sob_button_top`, `sob_button_skip_browse_record_id`, `sob_button_zzsys_form_id`, `sob_button_image_on_mouse_up`, `sob_button_image_on_mouse_down`, `sob_display_align`, `sob_button_browse_filter`, `sob_display_format`, `sob_display_length`, `sob_display_sql`, `sob_dropdown_default_value_sql`, `sob_dropdown_length`, `sob_dropdown_no_blanks`, `sob_dropdown_no_duplicates`, `sob_dropdown_read_only`, `sob_dropdown_sql`, `sob_graph_sql`, `sob_graph_zzsys_graph_id`, `sob_graph_query_string`, `sob_graph_code`, `sob_hidden_default_value`, `sob_html_code`, `sob_inarray_default_value_sql`, `sob_inarray_length`, `sob_inarray_no_blanks`, `sob_inarray_no_duplicates`, `sob_inarray_read_only`, `sob_inarray_sql`, `sob_listbox_height`, `sob_listbox_length`, `sob_listbox_button_style`, `sob_listbox_sql`, `sob_lookup_button_length`, `sob_lookup_code_class`, `sob_lookup_code_field`, `sob_lookup_code_length`, `sob_lookup_default_value_sql`, `sob_lookup_description_class`, `sob_lookup_description_field`, `sob_lookup_description_length`, `sob_lookup_sql`, `sob_lookup_load_zzsysform_id`, `sob_lookup_zzsysform_id`, `sob_lookup_id_field`, `sob_lookup_javascript`, `sob_lookup_no_blanks`, `sob_lookup_no_description`, `sob_lookup_no_duplicates`, `sob_lookup_read_only`, `sob_lookup_autocomplete`, `sob_password_length`, `sob_password_no_blanks`, `sob_subform_zzsysform_id`, `sob_subform_browse_filter`, `sob_subform_blank_rows`, `sob_subform_delete_box`, `sob_subform_foreign_key`, `sob_subform_height`, `sob_subform_left`, `sob_subform_primary_key`, `sob_subform_read_only`, `sob_subform_selected_row_color`, `sob_subform_sql`, `sob_subform_table`, `sob_subform_title_height`, `sob_subform_top`, `sob_subform_width`, `sob_subform_odd_background_color`, `sob_subform_even_background_color`, `sob_text_align`, `sob_text_date_button_length`, `sob_text_default_value_sql`, `sob_text_format`, `sob_text_length`, `sob_text_mask`, `sob_text_no_blanks`, `sob_text_no_duplicates`, `sob_text_password`, `sob_text_read_only`, `sob_text_total`, `sob_textarea_height`, `sob_textarea_default_value_sql`, `sob_textarea_length`, `sob_textarea_no_blanks`, `sob_textarea_read_only`, `sob_words_length`, `sys_setup`, `sys_added`, `sys_changed`, `sys_user_id`) VALUES('14fe6235e8bae7', 'object', '', '0', '', '1', 10, '', 'sob_lookup_autocomplete', '', '', '', '', '', '', '', NULL, 600, 100, 'Lookup', 'Auto Complete', 'dropdown', NULL, NULL, NULL, 0, 0.00, 0, '', '', NULL, NULL, '', '', NULL, 0.00, '', '', 5.00, '', '', '', 'SELECT sli_option, sli_description FROM zzsys_list WHERE sli_name = ''answer''', NULL, '', NULL, '', NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, 0, 0.00, NULL, '', NULL, NULL, '', 0.00, '', NULL, '', 0.00, NULL, '', '', '', '', '', '', '', '', NULL, NULL, NULL, '', '', 0, '', '', 0, 0, '', '', '', '', '', 0, 0, 0, '', '', '', NULL, '', '', 5.00, NULL, '', '', '', '', NULL, '', '', 0.00, '', '', 0.00, '1', '2012-06-24 05:43:18', '2012-06-24 05:43:18', 'globeadmin');

Thank you!

[esstein]

esstein,

that's ok! This fix the problem.
...
Thank you!

Welcome!

Evandro

[admin]

.