Assigning the Values to the dropdown list using Xbasic cde.

[Parveen]

Hi All,

Here I have two drop down lists.If I select one value from first drop down list then the corresponding value(which is from database) should assign to the second drop down list.

I am unable to assign values (those are getting from database) to the drop down list using xbasic coding .Can you please help me out.

Dropdown_Auto_Assigning.jpg

[Stan Mathews]

Re: Assigning the Values to the dropdown list using Xbasic cde.

Best to post in the forum for the version you are using 10 or 11 or 12? Also best to attach a sample of your database rather than a picture.

[TheSmitchell]

Re: Assigning the Values to the dropdown list using Xbasic cde.

Hi All,

Here I have two drop down lists.If I select one value from first drop down list then the corresponding value(which is from database) should assign to the second drop down list.

I am unable to assign values (those are getting from database) to the drop down list using xbasic coding .Can you please help me out.

[ATTACH=CONFIG]38234[/ATTACH]

What are you doing to populate the dropdowns? Are you using an action javascript? Or have you written your own xbasic? Please post what you have.

[Parveen]

Re: Assigning the Values to the dropdown list using Xbasic cde.

What are you doing to populate the dropdowns? Are you using an action javascript? Or have you written your own xbasic? Please post what you have.

Thank you for your reply.I am using v11 and I wrote own xbasic code in in dropdown list onselect event.

Here I am getting below three values from database.

DCN
Java
Android
How to assign these three values to the dropdown list using xbasic code.Please let me know..

[TheSmitchell]

Re: Assigning the Values to the dropdown list using Xbasic cde.

Well, to start with, I don't think there is an onSelect event for dropdown boxes. Not all fields have all events --- but Alpha's interface lists all of them, even when they're not applicable. Dropdowns do have an onChange event. And that sounds a little more like when you'd want to execute your script anyway - when the selected value for your list changes. So, start by moving your code from onSelect to the onChange event for your dropdown.

After that, if you're still having problems...........

If you're using cascading dropdowns - the value in the first dictates the value in the second - then you should look at using the Cascading Choices properties in the dropdown choices definition dialog:
cascadingChoices.png

You can also use {grid.object}.populateDropdownBox (or {dialog.object}.populateDropdownBox) to update dropdown boxes. These are javascript methods. You can return javascript to execute from any ajaxCallback and some of the server-side events (read the comments in each to figure out how to return the javascript--if it doesn't mention anything about returning javascript, then you can't do it in that particular event.)

'dim choices_arr as c =<<%s%
''Apple'
''Banana'
''Pear'
''Strawberry'
'%s%


'Format for storing a value seaprate from displayed value
'Note: you are building a JavaScript array for use in populateDropdownBox
'This is just an example of the format you need to create.
dim choices_arr as c=<<%s%
['Apple',1]
['Banana',2]
['Pear',3]
['Strawberry',4]
%s%

'replaces all the crlf() with commas. Results:
'For array with no stored value: 'Apple','Banana','Pear','Strawberry'
'For array with stored value: ['Apple',1],['Banana',2],['Pear',3],['Strawberry',4]
choices_arr = crlf_to_comma(choices_arr)

dim js as c = ""
' Need to enclose choices_arr inside "[" and "]" --- this makes it into a JavaScript array
*concat(js,"var choices = [" + choices_arr + "];" + crlf())
*concat(js,"var replaceExistingChoices = true;" + crlf())
*concat(js,"var rowNum = " + e._currentRow + ";" + crlf())
*concat(js,"{grid.object}.populateDropdownBox('G','MY_DROPDOWN',rowNum,choices,replaceExistingChoices);" + crlf())

To return the javascript, you'll just pass it into the function name. If you're using the xbasic code in the event, then you should see something like this:

serverside_370caba45542432993750ccb017321f6 = "//Replace this with the javascript to be returned by the function."

Replace the stuff after the = with js:

serverside_370caba45542432993750ccb017321f6 = js

Make sure your strings are properly escaped. If you can have things like apostrophes, quotes, backslashes "\", and other special characters in your string, use js_escape so the text is properly escaped to be included in your JavaScript array. Eg:

*concat(choices_arr, js_escape("Hors d'oeuvre") + crlf() )

All code above is wildly untested and probably contains errors. But you get the idea.
---
Sarah

[mixter]

Re: Assigning the Values to the dropdown list using Xbasic cde.

Not all fields have all events --- but Alpha's interface lists all of them, even when they're not applicable.

Whoa! That's kind of unsettling. Is there a way to double check if an event is actually applicable to the control, before writing code into a particular event and expecting it to run?

I suppose good old alert boxes are the first way to test if an event actually triggers or not...

[TheSmitchell]

Re: Assigning the Values to the dropdown list using Xbasic cde.

Whoa! That's kind of unsettling. Is there a way to double check if an event is actually applicable to the control, before writing code into a particular event and expecting it to run?

I suppose good old alert boxes are the first way to test if an event actually triggers or not...

You answered your own question. ;)

alert('Event!');

[TheSmitchell]

Re: Assigning the Values to the dropdown list using Xbasic cde.

Whoa! That's kind of unsettling. Is there a way to double check if an event is actually applicable to the control, before writing code into a particular event and expecting it to run?

I suppose good old alert boxes are the first way to test if an event actually triggers or not...

I don't really consider this that unsettling. The event in question, onSelect, is only triggered when some text is selected. It usually only applies to textareas and textboxes. Alpha's interface is consistently generic (with the exception of sliders and a few other things.) The help for the event states clearly that not all elements support the event:

onSelecthelp.png

And you can create your own custom events, listeners, and handlers that are called anything, really. EG, http://www.kaizou.org/2010/03/genera...script-events/

Yarp.

EDIT (More Thoughts):

I think maybe another issue here is that the event names can be misunderstood to mean something they don't. onSelect is easily misunderstood to mean "selecting the control", but that event is actually onFocus. Similarly, onSelect could be construed to mean "selecting an option", but that action can be defined or handled by any number of other events, including onChange (value was changed), onClick (mouse was clicked on control), onMouseUp (mouse button released over control), onMouseDown (mouse button depressed over contorl), and possibly onBlur (focus on the control has gone away) or onDoubleClick (double-clicked the mouse on the control).

But event names are dictated by web standards, not Alpha.

[GGandhi]

Re: Assigning the Values to the dropdown list using Xbasic cde.

I don't really consider this that unsettling.....The help for the event states clearly that not all elements support the event:

understandable when they say it out loud but.
say if you change a control from text box to dropdown, then the options change and new choice is added where you can declare how the dropdown will be populated.
same goes for radio buttons and checkbox controls. so they are programmatically changing the options available based on some selection, correct.
my feeling is the same as Michael's. why not list only those available for that control? instead of spending sometime to investigate if that function is available then clean the slate and start all over to write the real business function.