Populate Repeating Section in an unbound UX

[gkpurcey]

I am trying to figure out how to do this:
I have an unbound UX control. It's unbound because I want to populate the data in a repeating section from two different sources, depending on the request the user makes.
So I actually have a different master-detail relationship I want to use depending on the choice of the user.
I've tried using the action javascript "Populate the controls in and UNBOUND UX component..." but can't seem to find a way to handle the repeating section.
Can this be used for a repeating container?
I hope this is not too vague a description of what I am trying to do... my apologies if that's the case!

[gkpurcey]

Re: Populate Repeating Section in an unbound UX

Just found video D57 relating to populating dialogs using Xbasic helper functions.
I believe this is what I will need to do.
Still digesting it, but looks promising...

[lilmofo812]

Re: Populate Repeating Section in an unbound UX

Did you have any luck with this? I have been just doing a test case before I try it on my dialog because I have a ton of controls to fill in and I don't want to do this unless it's actually worth my time and I can get it working on this smaller case. Thanks!

here is my code so far, running into an error at the a5DialogHelper_GetDataToPopulateDialog(sections), it says sections can't be found? Below is my code!

dim sections[2] as p
sections[1].alias = "test_parent"
sections[1].sql = "select * from test_parent"
sections[1].filter = "ID = 1"
sections[1].connectionString = "::name::eTruck"
sections[1].portalbeSQL = .t.
sections[1].argumentsXML = ""
sections[1].fieldToVariableMap = <<%txt%
ID = id
name = parent_name
%txt%
sections[1].displayFormatMap = ""

sections[2].alias = "test_child"
sections[2].repeatingSectionId = "CONTAINER_1"
sections[2].currentRow = 1
sections[2].sql = "select * from test_child"
sections[2].filter = ""
sections[2].order = "parent_id"
sections[2].connectionString = "::name::eTruck"
sections[2].portalbeSQL = .t.
sections[2].parentAlias = "test_parent"
sections[2].parentLinkFileds = "ID"
sections[2].childLinkFields = "parent_id"
sections[2].argumentsXML = ""
sections[2].fieldToVariableMap = <<%txt%
ID = id
parent_id = parent_id
name = child_name
%txt%
sections[2].displayFormatMap = ""
debug(1)


px = a5DialogHelper_GetDataToPopulateDialog(sections)

showvarscript(px)

if px.haserror = .f.
	dim p as p
	result = evaluate_template(px.xbasic)
	dim pJs as c
	pJs = a5DialogHelper_js_populate(p)
	showvar(pJs.setRepeatingSections + crlf(2) + px.javascriptSetActiveRow + crlf(2) + pJs.populateControls)
else
	ui_msg_box("","error")
	end if
	
e.javascript = js

[gkpurcey]

Re: Populate Repeating Section in an unbound UX

I wish I could be of help to you, but I abandoned my approach and went with a different approach, so I'm afraid I am of no help.
Sorry!

[lilmofo812]

Re: Populate Repeating Section in an unbound UX

Curious what approach you did use?