gpdeering
Posts: 57
|
| Posted: 04/18/2006, 4:24 PM |
|
Thanks for the input anyway.
The Sixto solution is still worth pursuing when I have more time to play with it.
Yes, I've already begun incorporating the dependent listbox example from the Example Pack 2. It looks like that's my route for this application (at least for now.)
Thanks again.
|
 |
 |
WKempees
|
| Posted: 04/18/2006, 5:03 PM |
|
U'r welcome.
"gpdeering" <gpdeering@forum.codecharge> schreef in bericht
news:54445751610b7b@news.codecharge.com...
> Thanks for the input anyway.
>
> The Sixto solution is still worth pursuing when I have more time to play
> with
> it.
>
> Yes, I've already begun incorporating the dependent listbox example from
> the
> Example Pack 2. It looks like that's my route for this application (at
> least
> for now.)
>
> Thanks again.
> ---------------------------------------
> Sent from YesSoftware forum
> http://forums.codecharge.com/
>
|
|
|
|
Sam
|
| Posted: 05/17/2006, 6:57 PM |
|
This is really great.
Can we have this in ASP please. please. please
Thanks,
Sam
|
|
|
|
Habib
|
| Posted: 05/18/2006, 3:00 AM |
|
Hi Walter
I tried to use dependant list boxes and I succeed when the id of the master table exists in the slave table; but when the id of the master table is retrieved from a join between two tables , it does not work !!!
Any idea please
Thanks
|
|
|
|
WKempees
|
| Posted: 05/19/2006, 1:24 AM |
|
Post the SQL here please and I'll have a look Habib, or PM me.
As for ASP, (Trektalk: ) I haven't got the power Sirrr.
I have no time at the moment to setup and built/test ASP version, sorry.
Walter
"Habib" <Habib@forum.codecharge> schreef in bericht
news:5446c45a40b37d@news.codecharge.com...
> Hi Walter
> I tried to use dependant list boxes and I succeed when the id of the
> master
> table exists in the slave table; but when the id of the master table is
> retrieved from a join between two tables , it does not work !!!
> Any idea please
> Thanks
> ---------------------------------------
> Sent from YesSoftware forum
> http://forums.codecharge.com/
>
|
|
|
|
gabriel
|
| Posted: 05/23/2006, 7:41 PM |
|
this should be the standard way to do this kind of things.
Please, develop a 3 listbox example 
|
|
|
|
Yony
|
| Posted: 07/07/2006, 3:41 PM |
|
I agree, twith gabriel. Where can I find Ad ins like this, theres a community of programmers doing this? does yessoftware release this plugins?
Im new here, and it seems that the forum is really active, but the yessoft site is out of date....? no news, no releases, no plugins, etc, etc, etc
|
|
|
|
Yony
|
| Posted: 07/07/2006, 3:43 PM |
|
Please, a good idea culd be to develop a "unlimited or set how much you want" list option
|
|
|
|
wkempees
Posts: 1679
|
| Posted: 07/07/2006, 4:17 PM |
|
Yoni,
You can find Add Ins like these, the are called CustomActions.
Unfortunately I don't know where, but there are some post floating around in the forum.
Try Search (Top menu of this forum) using "action custom" as a search term.
Yes,afaik, does not release them nor support them.
The do use their own actions, or better, you use their actions.
Walter
_________________
Origin: NL, T:GMT+1 (Forumtime +9)
CCS3/4.01.006 PhP, MySQL .Net/InMotion(Vista/XP, XAMPP)
if you liked this info PAYPAL me: http://donate.consultair.eu
|
|
|
|
wkempees
Posts: 1679
|
| Posted: 07/07/2006, 4:18 PM |
|
PS does anybody know where Sixto went, or how he's doing?
_________________
Origin: NL, T:GMT+1 (Forumtime +9)
CCS3/4.01.006 PhP, MySQL .Net/InMotion(Vista/XP, XAMPP)
if you liked this info PAYPAL me: http://donate.consultair.eu
|
|
|
|
Odin
Posts: 17
|
| Posted: 08/16/2006, 8:19 AM |
|
Hi all,
@1st - thx for this add-in. It works great.
@2nd - How can I disable this functionality for updating a record?
I need this only for insert a new record. After this, the Master-Slave entries should be readonly. Can anybody help?
|
|
|
|
wkempees
Posts: 1679
|
| Posted: 08/16/2006, 11:47 AM |
|
This is in fact a new topic, but:
In BeforeShow you can test for EditMode
if ($Component->EditMode)
Put panels around your listboxes.
Add Textboxes, read-only or Labels to display the values
Put Panels around those as well
Set the Textbox/Label Panel to Visible NO, the Listboxes Panels to Visible YES.
In your Before Show, after the test set the one to visible NO and the other to Yes.
Walter
_________________
Origin: NL, T:GMT+1 (Forumtime +9)
CCS3/4.01.006 PhP, MySQL .Net/InMotion(Vista/XP, XAMPP)
if you liked this info PAYPAL me: http://donate.consultair.eu
|
|
|
|
Odin
Posts: 17
|
| Posted: 08/16/2006, 11:46 PM |
|
Quote wkempees:
This is in fact a new topic, but:
In BeforeShow you can test for EditMode
if ($Component->EditMode)
Put panels around your listboxes.
Add Textboxes, read-only or Labels to display the values
Put Panels around those as well
Set the Textbox/Label Panel to Visible NO, the Listboxes Panels to Visible YES.
In your Before Show, after the test set the one to visible NO and the other to Yes.
Walter
Hi Walter,
thanks a lot. Can I distinguish between "add" and "edit"-Mode, e.g. by using $form->ds->num_rows()?
I will try this out and give a statement after this.
THX
|
|
|
|
Odin
Posts: 17
|
| Posted: 08/17/2006, 11:30 PM |
|
@Walter
everthing's okay. It works great. Thx.
|
|
|
|
manolo
|
| Posted: 08/21/2006, 9:35 AM |
|
Where's Sixto....???? Im not a programmer, so ideas like this one are great for me... this plugin is a litle old by now... Why nobody tryed to do a 3 listbox version, or better a "choos how much you need" version.
it's so hard to write this things... why Yes dont implement they samples this way???
If they did, it will be a major PLUS.... may be in version 4.. 
|
|
|
|
Dorin
Posts: 50
|
| Posted: 10/17/2006, 9:40 AM |
|
Strange behaviour....
I tested Sixto's Dependant Listbox. The record form works OK on inserting mode but in edit mode I saw a strange behaviour: if the master id = 1 the bound column of the slave list box is incremented with 1. Anyone noticed this?
Dorin
|
|
|
|
wkempees
Posts: 1679
|
| Posted: 10/17/2006, 10:36 AM |
|
Dorin,
I am not aware of this problem.
What version of ccs? Where did you obtain the Sixto Listbox Action from?
Willing to investigate.
Walter
_________________
Origin: NL, T:GMT+1 (Forumtime +9)
CCS3/4.01.006 PhP, MySQL .Net/InMotion(Vista/XP, XAMPP)
if you liked this info PAYPAL me: http://donate.consultair.eu
|
|
|
|
Dorin
Posts: 50
|
| Posted: 10/17/2006, 10:51 AM |
|
Hello Walter,
I have CCS v3.0.1.6 and I downloaded the Sixto Action from a link posted above: http://www.consultair.nl/newsite/go.php?m=rbk&t=shw&rbk_id=43.
Thanks for your reply,
Dorin
|
|
|
|
wkempees
Posts: 1679
|
| Posted: 10/18/2006, 3:45 AM |
|
Dorin,
The link is ok, my site.
CCS Version is 3+, although not most recent, should be ok.
Please describe your problem in detail, or PM me a project containing the problem.
Describe means, details about the two interlinked tables such as lay-out.
Walter
_________________
Origin: NL, T:GMT+1 (Forumtime +9)
CCS3/4.01.006 PhP, MySQL .Net/InMotion(Vista/XP, XAMPP)
if you liked this info PAYPAL me: http://donate.consultair.eu
|
|
|
|
jbanos
Posts: 3
|
| Posted: 10/18/2006, 11:33 AM |
|
I am having a problem using this version, when in insert mode everything works ok, but in a form in edit mode the master listbox gets selected with the database info, the slave reads the options ok but it displays a blank, I need to reselect the option everytime I mdify something on the form.
Has anyone experience this? is there a workarround?
Thank You
|
|
|
|
wkempees
Posts: 1679
|
| Posted: 10/18/2006, 11:36 AM |
|
jbanos\
In editmode, your second listbox seems not bound to a data value.
It should select based on a db-field value.
Walter
_________________
Origin: NL, T:GMT+1 (Forumtime +9)
CCS3/4.01.006 PhP, MySQL .Net/InMotion(Vista/XP, XAMPP)
if you liked this info PAYPAL me: http://donate.consultair.eu
|
|
|
|
jbanos
Posts: 3
|
| Posted: 10/19/2006, 6:23 AM |
|
Thank you Walter
I had in the bound column the control_sync field instead of the field I required, I had misunderstood the instructions.
|
|
|
|
wkempees
Posts: 1679
|
| Posted: 10/19/2006, 7:11 AM |
|
So I wasn;t clear enough, I will go and punish myself.
Good job!
Walter
_________________
Origin: NL, T:GMT+1 (Forumtime +9)
CCS3/4.01.006 PhP, MySQL .Net/InMotion(Vista/XP, XAMPP)
if you liked this info PAYPAL me: http://donate.consultair.eu
|
|
|
|
gustavo
|
| Posted: 10/19/2006, 3:05 PM |
|
I've seen a lot of asking foe a 3 list version, where's Sixto..............? It'd so hard to do????????????
|
|
|
|
Damian Hupfeld
|
| Posted: 10/19/2006, 6:33 PM |
|
Gustavo - maybe you could give a 3 list version a go?
:)
"gustavo" <gustavo@forum.codecharge> wrote in message
news:54537f6c1c12c6@news.codecharge.com...
> I've seen a lot of asking foe a 3 list version, where's
> Sixto..............?
> It'd so hard to do????????????
> ---------------------------------------
> Sent from YesSoftware forum
> http://forums.codecharge.com/
>
|
|
|
|
Dorin
Posts: 50
|
| Posted: 10/20/2006, 2:42 AM |
|
Walter,
These are the tables I work with:
projects: idProject, projectName
projecttasks: idTask, taskName
projectdetails: idDetail, idProject, idTask
For my record form:
Master listbox is based on project table with idProject - bound column and projectName - text column).
Slave listbox is based on projectdetails table with taskName - text(I made a join). If I select idProject (wich has the alias: slave_sync) for the bound column, inserting works fine but in edit mode slave listbox shows all the records but no one selected. If I put the idTask as bound column, inserting works ok, editing too, the only problem I have is for idproject=1. For this one, the idtask shown in edit mode is incremented with 1. I don't know why.
Did I miss something?
Thanks for your patience
Dorin
|
|
|
|
wkempees
Posts: 1679
|
| Posted: 10/20/2006, 3:05 AM |
|
Dorin,
Patience, I have a lot of, No Problem.
projects: idProject, projectName ->MasterListbox
projectdetails: idDetail, idProject, idTask -> SlaveListBox
projecttasks: idTask, taskName -> The table linked to projectdetails to have the name of the task
What is the Table and structure of that table (minimal) the Form is using as a DataSource?
It is that table that is in EditMode, with the two listboxes on the form, I assume?
It all depends on your table design, does it contain only the IdDetail amongst other fields?
In other words how normalized is your DB.
Describe the table here please.
Walter
_________________
Origin: NL, T:GMT+1 (Forumtime +9)
CCS3/4.01.006 PhP, MySQL .Net/InMotion(Vista/XP, XAMPP)
if you liked this info PAYPAL me: http://donate.consultair.eu
|
|
|
|
Dorin
Posts: 50
|
| Posted: 10/20/2006, 3:32 AM |
|
The table used by the form:
receivedinvoicedetails: idInvoiceDetail, idProject, idTask, quantity, description, unitPrice.
I do not have a column that points to idDetail from the projectdetails table.
Yeap...I can put an idDetail here...and there will be no need for dependent listboxes...instead of them I'll have only a concatenated field (projectName and taskName).
I think that that is the sollution.
Thanks again
|
|
|
|
wkempees
Posts: 1679
|
| Posted: 10/20/2006, 4:05 PM |
|
Yes Normalization at your rescue!
Glad you realized your escape route and went for better DB design, cheers!
Also where dit your Cameltype rules come from?
IdTableName would be Cameltype yours is a dromedary, single-humped camel
Walter
_________________
Origin: NL, T:GMT+1 (Forumtime +9)
CCS3/4.01.006 PhP, MySQL .Net/InMotion(Vista/XP, XAMPP)
if you liked this info PAYPAL me: http://donate.consultair.eu
|
|
|
|
wkempees
Posts: 1679
|
| Posted: 10/20/2006, 4:07 PM |
|
Still the original problem could have been solved, you needed to adjust the DataSource for the Slave to include a Where on idProject
Current option is the better though (3-4NF)
Walter
_________________
Origin: NL, T:GMT+1 (Forumtime +9)
CCS3/4.01.006 PhP, MySQL .Net/InMotion(Vista/XP, XAMPP)
if you liked this info PAYPAL me: http://donate.consultair.eu
|
|
|
|
|
