I wish to have FOOTER property just like HEADER property on a GRID/BROWSE control to put some TOTAL or REMARKS in it. Tnx and more power HMG!!!
i have a screenshot here with 138290 records. I used GRID as a footer to recalculate all the FIELDS on the BROWSE control. The problem is it will not move if i had to add another FIELD to my BROWSE table. I want my FOOTER will move LEFT to RIGHT as I move my KB Left to right. Hi to all!!!
sample.jpg (319.45 KiB) Viewed 4951 times
Last edited by brain on Tue Nov 18, 2014 11:21 am, edited 4 times in total.
What I do to get around this is to create a temporary table and append the fields or all fields from
the main table. I then append a blank record and give the first field the name total or what ever.
I can total columns to put the totals in the numbered records. This works good. I also set relation back to main table sometimes.
Not sure what your doing but works great for reports.
Regards Franco
Yes I am having that problem. Have table with 300,000 records.
I have it working on single field.
open from table. Index to temp on field I want. seek start point. copy while field = want.
5 seconds time.
I am having trouble with dates. with index on date. seek want1. copy while date <= want2.
Just doing this now.
my old foxpro sql select from only took 5 seconds to do what I want, but am having trouble
making sql select work in hmg. It says I am missing a dll file. Do not know how to get this file.
I forget the name right now.
Let you know how this works when finished
Franco
At first glance, it seems OK request, but when I think I did not see anything like that
What is proposed franco is OK although I think it is better to put the sum of the fields at the bottom of the screen, the lines of which shows the sum may be more than you can fit on the screen, on the other hand summation should be seen on the screen
On the other hand, it is probably that all data should be visible on the screen, so scrolling down-up makes more sense than scrolling right-left
you could put the total fields into variables, and put labels right below the grid.
this way you would have much control on what is there.
as merek suggested my way is slow for large tables.
if looking at the whole 300000 records I am down to 18 seconds (not Bad), but if I want
to add any more filters it becomes unusable
I would really like to learn how get data with sql as in my latest post.
select num1 from inv where num1 = 'P2' into table temp .... so easy once you know how.
Franco
What I do is put another Grid in a single row without headers to put there totals or averages depends on what you want, down the other and it looks like one !!!. And it's the same speed as working with grid or Browse !, although I admit I have not worked with large data bases. Maximum 10,000 as evidence.
