Embeded Browse does not index sort by default

[calexplorer]

I have two tables
Table 1:contracts
Table 2:service_type_locations

Table 1 contains the field
service_type_location

Table 2 contains only the field
servtypeloc

Table 2 only contains valid service type locations that is its only data item and I do have that field set as a character field and indexed.

Eventually while in Table 1 when entering or editing a record I want the user to be able to select from the valid Table 2 (servtypeloc) listed.

However first I need to create a form for Table 2 which allows for the adding of valid service locations.

I have created the table as described above and it is indexed.

I am now creating the form to allow viewing and eventually adding and editing of its contents.

I have embeded in the form from the toolbox a simple embeded browse object so the user can see all the current valid service locations. Then they can select from the browse one of displayed records which appears in the lower field editing area.
I know it's not complete yet, but I noticed this index sort problem which needed solving first.

I have attached images showing both the Form Design Mode and the Form View Mode (note that in the Form Design View it shows the data record items in the correct sorted order, A to Z by default.)


My problem is I can't seem to get the Form View Mode to automatically display the records in proper Ascending sorted order by default.

Since the only data field is indexed why does it not show the records by default in the proper ascending sort.

When in form design mode it shows the records in the correct sorted and indexed order but when in view mode it does not.

Thanks for any assistance.

[omagarc]

Re: Embeded Browse does not index sort by default

your gonna want to look at the release you are working with as a newer release may have resolved this issue.

[calexplorer]

Re: Embeded Browse does not index sort by default

I have discovered how to make the Embedded Browse work correctly.

Go into Design Mode of the form your working on.

While the form is on the screen from the Top Alpha 5 menu select
Form, then from the drop down menu select Form Properties .

This will open the Form Properties Dialog Window.
This window has 9 TABS on it and 3 button options.

Select the [ Filter / Order ] Tab.
You will now see a check box and 3 selection categories:
Table, Filter expression and Order Expression.

Select the Order expression category.

This will open the Order Builder - Order By Dialog Window, which also has 3 Sort By selection boxes and 3 sort direction toggle buttons.

Select the first Sort By selection option and choose the Field you want to sort by. In my case it was the Servtypeloc field. I also wanted to sort in ascending A..Z order so I chose the corresponding sort toggle button.

You can have two additional sorts if needed.

I only needed to sort one time so I then clicked on the OK button which closed the Order Builder window.

This returned me to the Form Properties dialog window where you can now see the Order Expression that was selected.

This was all I needed to do so I now clicked the OK button closing the Form Properties dialog window.

Finally to save your actions you need to Save your form by using the File / Save menu options from the top Alpha 5 menu.

You can then test your form in View Mode.

I have attached an animated GIF showing the process, it loops 3 times.

[Keith Hubert]

Re: Embeded Browse does not index sort by default

Hi Cole,

How did you make your attachment do that, and can you slow it down?

[calexplorer]

Re: Embeded Browse does not index sort by default

The attachment is simply a collection of GIF screen images combined into a single animated GIF. I am currently using Windows Vista and did not have an animation program that would work on it, therefore I had to use one of those free online GIF animation services. Unfortunately they only allow so many variables and the maximum I could slow the speed between images was about 3 seconds. Because their is no control for the user I had the animation loop 3 times figuring it would take that so as to understand what was occurring.

On my screen their is a little magnifying pointer option which makes the images bigger so you can see all the details. If you need to view it a second time just refresh the browse.

The other constraint was of course the fact that the Alpha 5 forum will only allow attachments of a certain size.

Originally, I tried to make an AVI video showing the steps but it was too large. Therefore, I settled on simple screen shots which I edited with the Paint.Net program then combined to make the animated GIF.

Their is probably an easier method with fancier tools, but my budget currently does not allow for such luxuries. Eventually, I would love to make better tutorials. I find that most of the tutorials on YouTube etc while nice are just not visibly clear to see the fields being discussed. I am hopefull that the program Snagit might solve this problem, but in earlier versions I did not find this to be the case. It's nice to be able to caputre screen video and movement, but what is the point if the end result is a fuzzy, blurry presentation. Pershaps someone more talented can point us to better tools.

Thanks for your comment and inquiry. Keep in touch.

[Keith Hubert]

Re: Embeded Browse does not index sort by default

Hi Cole,

One product that is used a lot by the guys at Alpha is from Jing and the best part not only is it very easy to use but it's Free.

[jkukuda]

Re: Embeded Browse does not index sort by default

Thanks you solved my problem

[martinwcole]

Re: Embeded Browse does not index sort by default

which is made by "Snagit" (aka Techsmith, who make Camtasia, Jing, Snagit, and provide a server to store it on!!)