CodeCharge Studio
search Register Login  

Web Reports

Visually create Web Reports in PHP, ASP, .NET, Java, Perl and ColdFusion.
CodeCharge.com

YesSoftware Forums -> CodeCharge Studio -> General/Other

 Dependant listboxes in Search Form AND editable Grid

Print topic Send  topic

Author Message
tfertil

Posts: 43
Posted: 01/09/2011, 6:19 AM

Hi everyone,

I need to add to groups of dependant listboxes to a page that contains a SEARCH record and an EDITABLE GRID.

I added the first group to the SEARCH record and works ok.

Then I added the second group to the EDITABLE GRID and also it work ok, but the first group on the search record stop working.

The strange thing is: if we establish some filter in the search record and press the SEARCH button, the EDITABLE GRID shows the data and the dependent listbox on the search record works again.

In other words: the dependent listbox on the search record does not work at the first time, only when there are data for the grid...

If I choose a search filter that returns no record, and ergo the editable grid is shown empty, then the dependent listbox on the search record doesn't work again..

any ideas? thanks...
View profile  Send private message
CodeChargeMVP

Posts: 473
Posted: 01/10/2011, 8:45 AM

Hi,

I´ve experience lots of strange behaviours with dependant listboxes in CCS, first I started learning how to set them paying attention to the examples from the site, you can check them
here http://examples.codecharge.com, but there still strange behaviours, nowdays I set them programmatically with AJAX.

I definitely think than some screenshots will be very handy by resolving this matters.

¿do you mean than sometimes only the first listbox shows the data and the dependat listbox doesn´t show anything? or ¿how do you mean?






Quote tfertil:
Hi everyone,

I need to add to groups of dependant listboxes to a page that contains a SEARCH record and an EDITABLE GRID.

I added the first group to the SEARCH record and works ok.

Then I added the second group to the EDITABLE GRID and also it work ok, but the first group on the search record stop working.

The strange thing is: if we establish some filter in the search record and press the SEARCH button, the EDITABLE GRID shows the data and the dependent listbox on the search record works again.

In other words: the dependent listbox on the search record does not work at the first time, only when there are data for the grid...

If I choose a search filter that returns no record, and ergo the editable grid is shown empty, then the dependent listbox on the search record doesn't work again..

any ideas? thanks...

_________________
Best Regards
Entrepeneur | NT Consultant
View profile  Send private message
tfertil

Posts: 43
Posted: 01/10/2011, 9:51 AM

Thank you for your reply, CodeChargeMVP.

What I mean is that:

I have a search record and an editable grid on the same page. Both of them contains dependent listbox, as show in this image:




When I added the FIRST dependend listboxes on the search record, they work well.

Then I added the SECOND GROUP of dependent listboxes in the grid. They also work ok.

BUT the first group now works ONLY if the grid is showing data. If the grid is EMPTY (that is, when the page is loaded or if I specified a filter condition for which there are no records), then changing the "Producer Code" item DOES NOT filter the "Exporter Code" listbox as expected (in the search record)...

When the grid shows data, then it works again...

NOTE that both dependent listbox groups are for the same fields, I don't know if this is related to the problem.

Thanks.
View profile  Send private message
datadoit
Posted: 01/10/2011, 9:57 AM

I suspect the issue is as you say, both record form and ed grid are
using the same field names.

Try altering the field names in one or the other, and build another
dependent listbox feature for it.

I recommend removing the dependent listbox feature or action from the
component before doing any renaming.
CodeChargeMVP

Posts: 473
Posted: 01/11/2011, 7:48 AM

Yes,I understand the issue,

Interesting task I´ve to say.

I´m gonna make some easy questions to indentify where the problem is.

¿when you choose the fk_producercode on the search grid is the fk_exportedcode filtered with his corresponding value?

We still haven´t pressed the search button.












_________________
Best Regards
Entrepeneur | NT Consultant
View profile  Send private message
tfertil

Posts: 43
Posted: 01/11/2011, 11:59 AM

In response to your question: No, when I select an fk_producercode, the list in the fk_exportercode doesn't change and is NOT filtered.

Thanks,
View profile  Send private message
CodeChargeMVP

Posts: 473
Posted: 01/12/2011, 7:22 AM

As I though you still haven´t made than the fk_producercode and the fk_exportercode being a dependant listbox, a dependant listbox means than there´s a master listbox and a slave listbox, when you choose the master listbox the data in the slave listbox is filtered automatically, but obviously, this is not magic,by adding one listbox and adding other listbox to a search grid or to a editable grid doesn´t mean than the dependant listboxes has been created, you´ve to write some code or do anything, don´t you?

¿or do you expect than CCS do everything for you?

I understand than you´ve high IT knowledges so please read it over the examples from the site http://examples.codecharge.com/



Quote tfertil:
In response to your question: No, when I select an fk_producercode, the list in the fk_exportercode doesn't change and is NOT filtered.

Thanks,

_________________
Best Regards
Entrepeneur | NT Consultant
View profile  Send private message
tfertil

Posts: 43
Posted: 01/12/2011, 7:45 AM

CodeChargeMVP: Thank for your time, but I don't understand your last message:

I don't want CSS to do all my work: but I expect CSS to do HIS work.

I'm using the Feature Builder to add two dependant listboxes to my page, one for the search record and one for the editable grid, both are based on the same fields.

If I add only ONE dependent listbox, it works, no matter where it is (the search record or the editable grid). So far, so good.

But when I added the SECOND dependent listbox, the one in the search record NO LONGER WORKS unless there is data in the grid, no matter the order in which this dependent listbox were created.

When I open the full page first time, the dependent listbox in the search record does not work: it is not filtered. If I select some filter and press SEARCH, and the grid shows at least one record, then the dependent listbox in the search record WORKS AGAIN.

If I modified the filter so there is no record in the grid, again the dependent list in the search record is not filtered.

So, to summarize:

Creating only a dependent listbox in the search record: WORKS OK.
Creating only a dependent listbox in the editable grid: WORKS OK.
Creating both dependent listboxes (one in the search grid, one in the editable grid): DOES NOT WORK for the search record unless there are records displayed in the grid.

Maybe it's related to the fact that both dependent lists are based on the same fields, I don't know. But there is no indication of such a restriction anywhere in the docs.
View profile  Send private message
CodeChargeMVP

Posts: 473
Posted: 01/14/2011, 4:49 AM

If you´re using the feature builder,please check out http://examples.codecharge.com

"two dependant listboxes" and "three dependant listboxes"

On the example there´re all steps very well explained.


_________________
Best Regards
Entrepeneur | NT Consultant
View profile  Send private message

Add new topic Subscribe to topic   


These are Community Forums for users to exchange information.
If you would like to obtain technical product help please visit http://support.yessoftware.com.

Internet Database

Visually create Web enabled database applications in minutes.
CodeCharge.com

Home   |    Search   |    Members   |    Register   |    Login


Powered by UltraApps Forum created with CodeCharge Studio
Copyright © 2003-2004 by UltraApps.com  and YesSoftware, Inc.