Home
>
WinDev Forum
>
Topic
(WB 12 Eng) How to get syncronized two combos?
Posted by Jaime Fernandez
|
Jaime Fernandez
(WB 12 Eng) How to get syncronized two combos? January 10, 2009 11:36AM |
Hi,
Do you know which is the best way to get sincronized two combos(not editable & embedded query?
Is it possible to use indirections in the parameters, values or anything in the description of the query conditions?
What event do you use to perform the 2nd query?
Combo 1
Description (registry key K1 as stored value)
Combo 2
Description (select * from file where K2 = Combo1)
Thank you
Do you know which is the best way to get sincronized two combos(not editable & embedded query?
Is it possible to use indirections in the parameters, values or anything in the description of the query conditions?
What event do you use to perform the 2nd query?
Combo 1
Description (registry key K1 as stored value)
Combo 2
Description (select * from file where K2 = Combo1)
Thank you
|
Piet van Zanten
Re: (WB 12 Eng) How to get syncronized two combos? January 10, 2009 01:04PM |
Hi Friedman,
If I understand your question correctly you are talking about a master-slave relationship between two combos.
In the master combo you can use the Row Selection section of the combo code to refresh the slave combo.
Best regards,
Piet
If I understand your question correctly you are talking about a master-slave relationship between two combos.
In the master combo you can use the Row Selection section of the combo code to refresh the slave combo.
ListDisplay(cmb_Combo2,taInit)In the slave combo you can use the Initalization code to set the query parameter and (re)execute the query.
MySource.Param_K2=cmb_Combo1 ListDisplay(cmb_Combo2l,taReExecuteQuery)
Best regards,
Piet
|
Jaime Fernandez
Re: (WB 12 Eng) How to get syncronized two combos? January 10, 2009 04:55PM |
First of all, thank you Piet! You have understood rigth, but this is not a solution:
1. There is no Row Selection section on Combo code(and neither can add it, does not exist).
2. cmb_Combo1 is equal to "" in Initialization code of cmb_combo2.
3. With a Combo it is impossible to use position (tainit, tareexecutequery) because error "No syntax of ListDisplay is compatible"
4. And here is a conceptual question: If I assign cmb_Combo1(stored value) on Initialization code of Combo2, only executes one time, Am I right?. The cmb_Combo1 value must be assigned on the equivalent to "row selection" event, so How to access to embedded query to assign the param value?
Regards and thank you
1. There is no Row Selection section on Combo code(and neither can add it, does not exist).
2. cmb_Combo1 is equal to "" in Initialization code of cmb_combo2.
3. With a Combo it is impossible to use position (tainit, tareexecutequery) because error "No syntax of ListDisplay is compatible"
4. And here is a conceptual question: If I assign cmb_Combo1(stored value) on Initialization code of Combo2, only executes one time, Am I right?. The cmb_Combo1 value must be assigned on the equivalent to "row selection" event, so How to access to embedded query to assign the param value?
Regards and thank you
|
Fabrice Harari
Re: (WB 12 Eng) How to get syncronized two combos? January 10, 2009 05:45PM |
|
Piet van Zanten
Re: (WB 12 Eng) How to get syncronized two combos? January 10, 2009 08:06PM |
|
Jaime Fernandez
Re: (WB 12 Eng) How to get syncronized two combos? January 12, 2009 09:57AM |
|
Piet van Zanten
Re: (WB 12 Eng) How to get syncronized two combos? January 12, 2009 10:53AM |
Hi Friedman,
I used Webdev 9 and 10 only for php/mysql, but encountered too many problems, that took me too much time. Perhaps it's better in version 12, but I'm not willing to take the plunge again. I've found a great php editor with a fantastic debugger in NuSpere's PhpED.
Regards, Piet
I used Webdev 9 and 10 only for php/mysql, but encountered too many problems, that took me too much time. Perhaps it's better in version 12, but I'm not willing to take the plunge again. I've found a great php editor with a fantastic debugger in NuSpere's PhpED.
Regards, Piet
|
Jaime Fernandez
Re: (WB 12 Eng) How to get syncronized two combos? January 12, 2009 11:00AM |
Hi Fabrice,
Whenever modified event it's not fired first time the combo load the content, it's fired when change the selected row so its equivalent to Piet's Row Selection, thank you.
But, I have figured out how to assign the parameter of the embedded query of combo2 in "whenever modified" of Combo1, but for the first time the page loads doesn't works because "whenever modified" is not fired, so Which event can I use for first time?
Regards
Whenever modified event it's not fired first time the combo load the content, it's fired when change the selected row so its equivalent to Piet's Row Selection, thank you.
But, I have figured out how to assign the parameter of the embedded query of combo2 in "whenever modified" of Combo1, but for the first time the page loads doesn't works because "whenever modified" is not fired, so Which event can I use for first time?
Regards
|
Fabrice Harari
Re: (WB 12 Eng) How to get syncronized two combos? January 12, 2009 12:16PM |
|
Jaime Fernandez
Re: (WB 12 Eng) How to get syncronized two combos? January 12, 2009 01:40PM |
Hi Fabrice,
After the my previous post I have tried to do that on all Initialization code (page, combo1,combo2) but the problem is that the combo1's query is not executed, so combo1 is empty. I have tried to execute the embedded query , but it is not executed: info(combo1) on Intialization Code of Page displays nothing.
Regards
After the my previous post I have tried to do that on all Initialization code (page, combo1,combo2) but the problem is that the combo1's query is not executed, so combo1 is empty. I have tried to execute the embedded query , but it is not executed: info(combo1) on Intialization Code of Page displays nothing.
Regards
|
Fabrice Harari
Re: (WB 12 Eng) How to get syncronized two combos? January 12, 2009 02:23PM |
|
Jaime Fernandez
Re: (WB 12 Eng) How to get syncronized two combos? January 12, 2009 05:21PM |
As you say, it should be easy... but I can't figured out, Combo1(stored value) returns "" in all cases, all events.
Only Page Load returns something, the selected record, but when I try via ajax to fill combo2, combo1 is "" again.
PD: I have had a Concat in the embedded sql of combo1, because I need to use stored procedures I have changed to HF C/S, then the Initialization of the combo1 crash, GPF, I'm going crazy, I waiting to develop 10 times faster
.
When I have two elements in combo1 and change the selection, combo2 works ok.
Regards
Only Page Load returns something, the selected record, but when I try via ajax to fill combo2, combo1 is "" again.
PD: I have had a Concat in the embedded sql of combo1, because I need to use stored procedures I have changed to HF C/S, then the Initialization of the combo1 crash, GPF, I'm going crazy, I waiting to develop 10 times faster
.
When I have two elements in combo1 and change the selection, combo2 works ok.
Regards
|
Fabrice Harari
Re: (WB 12 Eng) How to get syncronized two combos? January 12, 2009 07:34PM |
|
Jaime Fernandez
Re: (WB 12 Eng) How to get syncronized two combos? January 13, 2009 12:07AM |
|
Jaime Fernandez
Re: (WB 12 Eng) How to get syncronized two combos? January 13, 2009 11:19AM |
I have figured out, :cheers: , the crux of the matter is that Combo1 is always "" in the initialization, only when page is displayed returns something (stored value) but the embedded query is not empty after the end of initialization of Combo1, so assinging the parameter value must be done at the end of initialization of Combo2.
I hope this helps someone to save time!!
Thank you Fabrice.
Regards
I hope this helps someone to save time!!
Thank you Fabrice.
Regards
|
Fabrice Harari
Re: (WB 12 Eng) How to get syncronized two combos? January 13, 2009 11:55AM |
Hi Friedman...
the fact that the combo returns ''" means that no line has been selected yet, which means that you can do the following:
in the page init code (the last one)
//SELECT the first line of the combo BEFORE the page would do so
ListSelect(Combo1, 1)
//Get the return value from combo1
//Reinit combo 2 with appropriate values
And to speed up the process and avoid the original init of combo2, you can also do the following:
//Block the init of combo 2 in the GLOBAL declaration of the page with:
combo2..BrowsedFile=""
//in the init of the page, in the reinit combo2 part, start with:
combo2..browsedFile="RealFileNameBetweenQUOTES"
Best regards
the fact that the combo returns ''" means that no line has been selected yet, which means that you can do the following:
in the page init code (the last one)
//SELECT the first line of the combo BEFORE the page would do so
ListSelect(Combo1, 1)
//Get the return value from combo1
//Reinit combo 2 with appropriate values
And to speed up the process and avoid the original init of combo2, you can also do the following:
//Block the init of combo 2 in the GLOBAL declaration of the page with:
combo2..BrowsedFile=""
//in the init of the page, in the reinit combo2 part, start with:
combo2..browsedFile="RealFileNameBetweenQUOTES"
Best regards
|
Jaime Fernandez
Re: (WB 12 Eng) How to get syncronized two combos? January 13, 2009 01:01PM |
|
Fabrice Harari
Re: (WB 12 Eng) How to get syncronized two combos? January 13, 2009 02:02PM |
|
Jaime Fernandez
Re: (WB 12 Eng) How to get syncronized two combos? January 13, 2009 09:04PM |
Jeje, thread reopen!
Yes, that's right, for all:
Simple Solution:
Combo1_End_of_Initialization
ListSelectPlus(combo1,1)
Combo2_End_of_Initialization
Mysource.paramname = Combo1
ListDisplay(Combo2)
This is the simplest solution, but Combo2's embedded query executes 2 times, one with blank param and second with Combo1, Is this right?, please confirm (about this, Has HF C/S anything like Oracle's shared pool to see the executed queries?)
To avoid the double-execution you suggest to clear BrowseFile (all code must be moved and fixed to Page Initialization code). I have tried this, but I can't reassing the embedded query:
Error at line 8 of Initialization of PAGE_Test (server) process.
Unable to initialize 'COMBO_2' control. Hyper File Error:
=============================
Query with parameters (PAGE_Test_2$Query) not run automatically. No parameter defined for this query. To automatically run the query with parameters associated with a table control, define a parameter value.
=============================
Query with parameters (PAGE_Test_2$Query) not run automatically. No parameter defined for this query. To automatically run the query with parameters associated with a table control, define a parameter value.
Line 8 = COMBO_2..BrowsedFile = "PAGE_Test_2$Query"
How can I assign a query parameter if can't assign the query?
Regards
Yes, that's right, for all:
Simple Solution:
Combo1_End_of_Initialization
ListSelectPlus(combo1,1)
Combo2_End_of_Initialization
Mysource.paramname = Combo1
ListDisplay(Combo2)
This is the simplest solution, but Combo2's embedded query executes 2 times, one with blank param and second with Combo1, Is this right?, please confirm (about this, Has HF C/S anything like Oracle's shared pool to see the executed queries?)
To avoid the double-execution you suggest to clear BrowseFile (all code must be moved and fixed to Page Initialization code). I have tried this, but I can't reassing the embedded query:
Error at line 8 of Initialization of PAGE_Test (server) process.
Unable to initialize 'COMBO_2' control. Hyper File Error:
=============================
Query with parameters (PAGE_Test_2$Query) not run automatically. No parameter defined for this query. To automatically run the query with parameters associated with a table control, define a parameter value.
=============================
Query with parameters (PAGE_Test_2$Query) not run automatically. No parameter defined for this query. To automatically run the query with parameters associated with a table control, define a parameter value.
Line 8 = COMBO_2..BrowsedFile = "PAGE_Test_2$Query"
How can I assign a query parameter if can't assign the query?
Regards
|
Fabrice Harari
Re: (WB 12 Eng) How to get syncronized two combos? January 13, 2009 10:03PM |
|
Jaime Fernandez
Re: (WB 12 Eng) How to get syncronized two combos? January 14, 2009 09:11AM |
|
Jaime Fernandez
Re: (WB 12 Eng) How to get syncronized two combos? January 21, 2009 11:07AM |