Variable from xdialog

[malsalcnc]

Hi

I have got a cascading list xdialog box that is working great except that I cannot see the result of my selection in the variable.

What could I be doing wrong or do I have the wrong expectation?

xdialog.JPG

then i use that variable to extract the contents of a field into another variable.

key.JPG

and use that variable to set the contents of a field

This is the error i get

error.JPG

If this is not enough information please indicate what you would like.

[Tom Cone Jr]

Re: Variable from xdialog

I don't have a lot of experience with cascading lists. However, if it were me I'd verify that the variable "selected" contains the text you are expecting. If the value you need is present in the variable, I'd then double check the external table. Is the "selected" field value actually present in a record there?

[Stan Mathews]

Re: Variable from xdialog

The variable represented by the cascading list has levels corresponding to the cascade level. Fo a two tier list

selected.level1 will contain the choice made at that level and selected.level2 will contain the final choice.

[johnkoh]

Re: Variable from xdialog

Malcolm,

Your variable - "show" in the main dialog Box will not show you the return value. You need one more script which will show the result after a main action script genie.

attached the detail.
ActionScript 1.jpgActionScript 2.jpg


The " Showvar() " function will show the result, like a msgbox() but will not transfer other code. If it show the result then you know there is an active variable( ItemKey_item_Key) as you designed.

[Tom Cone Jr]

Re: Variable from xdialog

Stan, thanks for that. I didn't see this in the helps.

-- tom

[Stan Mathews]

Re: Variable from xdialog

I didn't either. I just created a simple cascading list xdialog from an action script and looked at the xbasic. The two list boxes in the dialog, hilighted in red below, represent the two pointer "sub" variables created by the action script genie.

'Create an XDialog dialog box to prompt for parameters.
DIM SHARED Selected as C
DIM SHARED varC_result as C
DIM Selected as P
DIM Selected.level[2] as P
DIM Selected.level[1].type as C = "DBF"
DIM Selected.level[1].nullEntry as C
DIM Selected.level[1].DBFTable as C = "bordgde"
DIM Selected.level[1].DBFExpr as C = "alltrim(cmark)"
DIM Selected.level[1].DBFFilter as C
DIM Selected.level[1].DBFOrder as C = "alltrim(cmark)"
DIM Selected.level[1].SQLConnection as C
DIM Selected.level[1].SQLStatement as C
DIM Selected.level[2].type as C = "DBF"
DIM Selected.level[2].nullEntry as C
DIM Selected.level[2].DBFTable as C = "bordgde"
DIM Selected.level[2].DBFExpr as C = "alltrim(fscdesc)"
DIM Selected.level[2].DBFFilter as C = "alltrim(cmark)=:level1"
DIM Selected.level[2].DBFOrder as C = "alltrim(fscdesc)"
DIM Selected.level[2].SQLConnection as C
DIM Selected.level[2].SQLStatement as C
DIM Selected.level1 as c = ""
DIM Selected.level1List as c = ""
DIM Selected.level2 as c = ""
DIM Selected.level2List as c = ""
Selected.level1List = a5_xd_getQueryComboBox("",Selected)
ok_button_label = "&OK"
cancel_button_label = "&Cancel"
varC_result = ui_dlg_box("Alpha Five",<<%dlg%
{region}
Type prompt here:| {region}
{encoding=utf8}[.40[COLOR="#FF0000"]Selected.level1[/COLOR]^=Selected.level1List!Selected.level1?Selected.level1List<>""];
{encoding=utf8}[.40[COLOR="#FF0000"]Selected.level2[/COLOR]^=Selected.level2List!Selected.level2?Selected.level2List<>""];
{endregion};
{endregion};
{line=1,0};
{region}
<*15=ok_button_label!OK> <15=cancel_button_label!CANCEL>
{endregion};
%dlg%,<<%code%
if a_dlg_button = "Selected.level1" then
	a_dlg_button = ""
	if Selected.level1 <> "" then
		Selected.level2List = a5_xd_getQueryComboBox(Selected.level1,Selected)
		Selected.level2 = ""
	else
		Selected.level2List = ""
		Selected.level2 = ""
	end if
end if
if a_dlg_button = "Selected.level2" then
	a_dlg_button = ""
	if Selected.level2 <> "" then
	else
	end if
end if
%code%)

[Tom Cone Jr]

Re: Variable from xdialog

Good work, Stan!

Now, how about working up some new "text" that could be suggested to Alpha as a supplement to the existing help file discussion?

-- tom

[malsalcnc]

Re: Variable from xdialog

Thanks guys

your information as usual top notch.

So I now have the correct returned variable from my cascading list.

last nights thought was both that it had something to with the level and to look at the xbasic of the action script.

retrospective awareness is always correct. haha

now I just need it to get me the right information out of the table.

will post some clearer information after todays attempts if still not successful.
Much thanks

Malcolm

[malsalcnc]

Re: Variable from xdialog

I have my cascading list working well now and the selection process works.

there seem to be an interesting problem occur though. After several uses of the cascading list what happens is that error turns up in the second option and if i try and do thing like open an interactive window i get this error message

Maximum session open tables exceeded

It seems that the tables get opened but not closed again.

I will keep looking for a solution
but in the meantime any suggestions and what information would any one like to assist them?