New call-to-action
Results 1 to 11 of 11

Thread: Tree control

  1. #1
    Sonia Sidhwaney
    Guest

    Default Tree control

    I am very new to alpha software. I want to create a form with tree control. According to users guide, I need to create tree control set. but when I click the picture to see how the set was create, I see 'Page Not Found'.
    then there ares messages about tree control on this message board . When I unzipped the file in one of the messages I see many dream weaver files. I am confused, why someone has used dreamweaver to create tree control.
    Any help is deeply appreciated.
    Thank you
    Sonia

  2. #2
    VAR davej's Avatar
    Real Name
    Dave Jampole
    Join Date
    Apr 2000
    Location
    Haughton, LA ( just east of Shreveport, Louisiana)
    Posts
    2,524

    Default RE: Tree control

    Sonia,

    In V6, we need to be careful and make sure we specify whether we are talking of a database form or a web-based form. The reference you give to Dreamweaver tells me that you are referencing a .A5W (web) form.

    Please indicate which type form you are concerned about. If you are wanting to create a database form with a tree control, there is one way to do it, if you are talking about a .A5W form with a tree control, it is quite a different issue.

    Dave

  3. #3
    Sonia Sidhwaney
    Guest

    Default RE: Tree control

    At present I want to create database form. But my undestanding is to develop database form then deploy to web. Am I right?
    Or I have to use entirely different process to create web based application. I come from client server technology and have not done development since long time.
    Pl. explain to me what route I should follow to dewvelop forms for the web.
    Thank you very much.
    Sonia

  4. #4
    VAR davej's Avatar
    Real Name
    Dave Jampole
    Join Date
    Apr 2000
    Location
    Haughton, LA ( just east of Shreveport, Louisiana)
    Posts
    2,524

    Default RE: Tree control

    Sonia,

    There are excellent tutorials on creating both database and web-based forms along with all other aspects of design in both mediums. Along with the printer material, you should look at the sample database and web design datgabases Alpha provides and use them as learning tools. The hands-on approach along with the tutorials should help you build comfort with both 'portions' of Alpha 5.

    You can create a database or web project independent of each other. However, if you objective is to create a database driven website, it would be logical to create the database first and then the web portion of the project.

    Dave

  5. #5
    Sonia Sidhwaney
    Guest

    Default RE: Tree control

    Dave,
    Can you pl. let me know how to create tree control in database form.
    Thank you
    SOnia

  6. #6
    VAR davej's Avatar
    Real Name
    Dave Jampole
    Join Date
    Apr 2000
    Location
    Haughton, LA ( just east of Shreveport, Louisiana)
    Posts
    2,524

    Default RE: Tree control

    Sonia,

    There are two tree control objects - one is called 'Tree-Control' and the other is 'Drop-down Tree Control'. The difference is the amount of screen space each takes; they work the same.

    Open Alphasports and navigate to the control panel. Open the Customer Information form in design mode and widen the design form so you have some space with which to work.

    If the Toolbar isn't open, click View and select Toolbox. Then, click on Tree Control and then set an area roughly 1 inch wide by 2 inches tall (size doesn't matter, it just gives us a work area). In the dialog that appears, select the Customer table in the left window and Company in the right window. Click OK. Then, select the Drop-down Tree Control object and place it below the larger area and make it maybe 1/2 inch tall. From the dialog, select the same table and same field as in the Tree Control we did previously.

    For each of the two tree control objects, RIGHT click and select 'Properties' and from the Field Properties selection, select the Choices tab. Click the downward pointing arrow and select 'Computer Automatically' and in the Source dialog that appears, select 'Values from a table/set'. In the 'Field/expression values to display' select Company. Follow the same procedures for the Drop-down Tree Control. Note that the choices for the tree control can be user defined or set using Xbasic.

    Click the Form View button (directly below File on the menu). You will see the company names in both the Tree Control and the Drop-down Tree Control. Click on a name and that record displays. Since we used the same field in both controls (Company) what you select in one of them is also selected in the other. Again, the only difference is the amount of screen real estate each control takes.

    Dave

  7. #7
    Sonia Sidhwaney
    Guest

    Default RE: Tree control

    Dave,
    Thank you so much for helping me out on this long weekend. Your directions are easy to follow. When I tried to go by users guide, i just got lost. I am going to try this very soon.
    Also I really want to thank you for helping me going in the wrong direction. Last night I installed and configured java run time and am able to use web projects. Went thru some tutorials. I like what I saw. I am ready to start my web forms. You don't know how much time you have saved me by telling two diffrent types of forms.
    Again have great weekend whatever is left.
    With regards
    Sonia

  8. #8
    VAR davej's Avatar
    Real Name
    Dave Jampole
    Join Date
    Apr 2000
    Location
    Haughton, LA ( just east of Shreveport, Louisiana)
    Posts
    2,524

    Default RE: Tree control

    Sonia,

    One of the things that makes this messageboard so great is users helping each other. Keep coming back and offer help when you can and we will all gain.

    Dave

  9. #9
    Sonia Sidhwaney
    Guest

    Default RE: Tree control

    Well, I created the tree control as per your instructions. I noticed two points. the drop down tree control did not display any data until I clicked and went down in the window.
    Another point is the data does not reflect the real tree data. company field is at one level only. therefore this is not meaningful tree. I guess next action item for me is to have data in the table correctly then this should work and makes sense too.
    My question is do I create one column to include all parent child ids or two separate columns as parent_id and child_id?
    Thank you

  10. #10
    VAR davej's Avatar
    Real Name
    Dave Jampole
    Join Date
    Apr 2000
    Location
    Haughton, LA ( just east of Shreveport, Louisiana)
    Posts
    2,524

    Default RE: Tree control

    Sonia,

    Sorry, I misunderstood what you were looking for.

    Go back to design mode and right click on the tree control. In the Field Properties, change the 'Choices for control are:' to User Defined. Leave Display as 'Text only'. In the large text type something like the following:

    Adams.Alan
    Adams.Bob
    Adams.John
    Adams.Mike
    Smith.Bob
    Smith.Charles.Ann
    Smith.Charles.Mary

    Then, click OK. Click 'Form View' button and in the Tree Control you will see Adams and Smith, each on a seperate line with a small plus sign to the left. Click on Adams and you will see Alan, Bob, John, Mike on the tree below the surname. On Smith, you will see Bob and Charles on seperate lines, but Charles will have a plus sign. Follow in on down and you can see how to set up the tree to meet your needs.

    Dave

  11. #11
    Member
    Real Name
    ken tjia
    Join Date
    Jan 2008
    Location
    Vancouver, BC Canada
    Posts
    560

    Default Re: Tree control

    Quote Originally Posted by davej View Post
    Sonia,

    Sorry, I misunderstood what you were looking for.

    Go back to design mode and right click on the tree control. In the Field Properties, change the 'Choices for control are:' to User Defined. Leave Display as 'Text only'. In the large text type something like the following:

    Adams.Alan
    Adams.Bob
    Adams.John
    Adams.Mike
    Smith.Bob
    Smith.Charles.Ann
    Smith.Charles.Mary

    Then, click OK. Click 'Form View' button and in the Tree Control you will see Adams and Smith, each on a seperate line with a small plus sign to the left. Click on Adams and you will see Alan, Bob, John, Mike on the tree below the surname. On Smith, you will see Bob and Charles on seperate lines, but Charles will have a plus sign. Follow in on down and you can see how to set up the tree to meet your needs.

    Dave
    what is the limit to the size of data inside a tree control?

Similar Threads

  1. Tree Control with Set
    By Kai Lange in forum Alpha Five Version 6
    Replies: 19
    Last Post: 09-05-2005, 05:48 AM
  2. Tree control
    By Sonia Sidhwaney in forum Alpha Five Version 6
    Replies: 2
    Last Post: 05-31-2005, 04:13 PM
  3. Tree Control
    By BRIAN GRAY in forum Alpha Five Version 5
    Replies: 2
    Last Post: 10-28-2004, 03:36 PM
  4. Tree Control
    By Kevin McDuff in forum Alpha Five Version 5
    Replies: 3
    Last Post: 11-01-2002, 05:24 AM
  5. Tree Control
    By Keith Hubert in forum Alpha Five Version 5
    Replies: 3
    Last Post: 09-08-2002, 12:41 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •