You are here:

SetEmbeddedData()

This method allows a LowCode data source View to use data of a variable (array of records) handled / managed by your 4GL code instead of a database table.

It accepts the DYNAMIC ARRAY OF RECORD as the parameter:

CALL <settings_record>.views["<db_table_name>"].SetEmbeddedData(<array_name>)

The array members should have the same names as the form field Identifiers where the data will be displayed.

Example:

FUNCTION init_embedded_array_data()

LET _arr_rec_contact[1].cont_id = i

LET _arr_rec_contact[1].cont_fname = "Alex"

LET _arr_rec_contact[1].cont_lname = "Williams"

LET _arr_rec_contact[2].cont_id = i

LET _arr_rec_contact[2].cont_fname = "Angela"

LET _arr_rec_contact[2].cont_lname = "Hoelzl"

END FUNCTION

FUNCTION contact_activity_list(p_rec_settings InteractForm_Settings)

LET p_rec_settings.form_file = "../demo_contact_activity_embedded/contact_activity_list"

CALL init_embedded_array_data() #populate array record 'contact' with data

CALL p_rec_settings.views["contact"].SetEmbeddedData(_arr_rec_contact)

CALL InteractForm(p_rec_settings)

END FUNCTION

There are some specifics to this method's use:

The SetEmbeddedData() method only allows a DYNAMIC ARRAY OF RECORD. If you want to have a single INPUT there, you need to append one row to the local array and hide the events specific to an INPUT ARRAY such as Insert, Append, etc.;
The View with embedded data can not depend on another View, because Lycia LowCode can't make queries from the local array. But you can emulate it using a custom function for the event "BEFORE ROW" in the parent View and update the target View by calling the SetEmbeddedData method of the InteractForm object already populated with data, which is dependent on the selected row in the parent view;
The view with an embedded array always operates with the paged_mode: -1. It is done automatically by LowCode regardless of what is specified in the settings, because all the data is already available.