Visible browse records

[Larry Gordon]

I have a number of embedded Browses in various forms. Most of them list in date order, with the oldest at the top, meaning I have to scroll down to the latest entries as they are not initially in view. I have tried reversing the list order via the 'Child Table Order' in the Set design,but this has a 'lumpy' result when you add new records. Meanwhile, a few of my embedded browses, which appear to be constructed in the same manner as the above, i.e. oldest records at the top, immediately show the latest records at the bottom of the list, with the new record option showing, and the old records not in view. My problem is, I cannot find out what I have done to make these browses display differently. I would be grateful for some advice.
Many thanks
Larry Gordon

[Davidk]

Re: Visible browse records

Larry, could you post your database so we could have a look?

[enstorms]

Re: Visible browse records

Just a thought. Look at the form's properties -> filter/order tab.
Ernie

[Larry Gordon]

Re: Visible browse records

Thanks for the two rapid responses.

Re posting my database here, I think that would be fairly difficult for me as it is so large - it has 4 separate menu screens and you would need a handbook just to get into it!

Re the Form Properties Filter/Order tab, I hadn't looked there, but I can now confirm there are no filter or order statements there.

I omitted to say in my original post that there are 6 different embedded browses spread over 4 tabs on the one form. This is compounding my confusion as to how they are operating differently. All I can think of is that when I created them, I might have used the genie to embed some of the browses (as per the set) when I first created the form, and have since added further embedded browses myself.

[Davidk]

Re: Visible browse records

I'm still quite new to A5 but I've found it tough to get browses sorted the way I want, using XBasic. What I've done recently is to put a button on a form and change it's properties to make it look invisible. Hiding it makes it unavailable. On the On Init event of the form I push this buttom which runs a sort query on the table the browse is based on. This seems to work... I wish I could find another way.

[Peter.Greulich]

Re: Visible browse records

I'm still quite new to A5 but I've found it tough to get browses sorted the way I want, using XBasic. What I've done recently is to put a button on a form and change it's properties to make it look invisible. Hiding it makes it unavailable. On the On Init event of the form I push this buttom which runs a sort query on the table the browse is based on. This seems to work... I wish I could find another way.

You can run the query directly from the OnInit. You don't need a hidden button.

[Davidk]

Re: Visible browse records

I must be going about it the wrong way, Peter, 'cause I can't get it to work.

The action I run from the button push, when viewed in Xbasic is...

topparent.Run_Saved_Query("qrySortInventoryRecords")

But it has no effect on the browse - the records are still unsorted. I tried refreshing the browse as well, but nothing. Do I need to do something else?

[MikeC]

Re: Visible browse records

David and Larry,
The easiest way I can think of to start doing as you want is to use Action Script and create a custom query.....then even convert it to xbasic and further modify it if necessary.

There are also many samples and scripts that have been posted here on the messageboard that should be useful.

Or post a stripped down version of your database so that we can help directly with a specific solution.

Ordering a browse was I believe the very first question I posed to this board and was my first baptism into xbasic as that was the solution I was given....have had no regrets on pursuing the xbasic route since either.

The following was the answer to my question regarding sorting on various embedded browses on a tabbed form. This could very well be broken up into its components and used in various places. All depends upon what you want to do, how you want to do it, what your specific circumstances are, ..... There rarely is just ONE answer .

'OnTabChange  event


sheet = topparent:TABBED1.tab_get()
t=table.current()
if sheet=1 then 
    BROWSE1.QUICKSORTEXPLICIT("COMPANY")
elseif sheet=2 then 
    BROWSE2.QUICKSORTEXPLICIT("CITY")
elseif sheet=3 then   
    BROWSE4.QUICKSORTEXPLICIT("COUNTY")
end if
topparent.resynch()

[Davidk]

Re: Visible browse records

Hey Mike,

I had a look at the QuickSortExpicit orginally but it will only sort 1 column... and I need 4 columns sorted. I had origianlly created an Action to run the query off the button, but then veiwed the code for it and put this code into the OnInit event of the form, but it won't work. I've attached my database.

There are a couple of oddities about the database. It opens the main form - frmFitnessInventory - upon startup. There's a hotspot in the lower left corner of the form which displays the Control Panel - but the form is still open behind the control panel. Minimize the control panel to see the form open.

The button I used for a Push Event is behind the Number field of the Inventory Records... it reads 248 Inventory Records... so it's behind the 248. In design mode, you can click on this field and you'll find the button. I push this button in the OnInit event - but I commented out the code for now while I played with it.

Here's the weird thing (not so weird I guess). If I open the frmFitnessInventory form the main browse showing Location etc. is not sorted. Leave the form open and switch back to the Control Panel and run the form again. It's now sorted. I suppose because in the meantime the table get sorted.

Thanks for having a look.

[MikeC]

Re: Visible browse records

David,

A few issues I found. One was you were not closing the tables that are opened in the OnInit script. This was not the cause of this problem but can cause others. To prevent any timing issues I made the script into 2 functions....Query_Fitness() and OnInit_Fitness(). The main issue was the browse needed to have focus prior to running the query....you will see a topparent:browse2.activate() added to the function that has the query.

[Davidk]

Re: Visible browse records

Very cool... thanks Mike. Got to remember to close my tables. Funny how it can be so automatic when coding (in Access) yet can't remember to do it in A5. Makes sense on the focus... thanks so much.