REVISION OF GRID/BROWSE

Creative ideas/suggestions for HMG

Moderator: Rathinagiri

User avatar
brain
Posts: 23
Joined: Tue Aug 02, 2011 5:01 pm

REVISION OF GRID/BROWSE

Post by brain » Thu Jul 02, 2015 8:37 am

I wish that can someone revise the GRID/BROWSE control into like DBEDIT function for less array and less memory to run the application. Tnx and more power HMG & Members!

User avatar
Pablo César
Posts: 4059
Joined: Wed Sep 08, 2010 1:18 pm
Location: Curitiba - Brasil
Has thanked: 100 times
Been thanked: 177 times

Post by Pablo César » Thu Jul 02, 2015 1:37 pm

What we have to understand is GRID and BROWSE are different controls.

When you said like dbEdit, must be cleared something: an control for exclusive use for DBFs, right ?

Because dbEdit only works with databases and also it's hard to work on to conciliate both: arrays and databases in GRIDs.

Otherwise Joselito (brain), why are you requesting this ?

BROWSE is deprecated (descontinued) in HMG and not implementations have been done over this control.

My suggestion is to work on the BROWSE or with other similar name for only and exclusive use for DBFs and working similar of TBrowseDB of old Clipper but in this time in GUI. I'm not sure if this is posible and also I do not know if it's worth it considering many users are migrating to SQL usage instead DBFs. :?
HMGing a better world
"Matter tells space how to curve, space tells matter how to move."
Albert Einstein

User avatar
Rathinagiri
Posts: 5181
Joined: Tue Jul 29, 2008 6:30 pm
DBs Used: MariaDB, SQLite, SQLCipher and MySQL
Location: Sivakasi, India
Has thanked: 141 times
Been thanked: 131 times
Contact:

Post by Rathinagiri » Thu Jul 02, 2015 1:59 pm

Showing DBF in a Grid/Browse control is very easy. But, keeping track of the changes (made if any by the user) and saving/rolling back the changes to the DBF is very hard in GUI controls, in which case, we have to maintain two sets of DBF in memory (which would double the memory usage).

As Pablo said, it is one of the reasons people migrate to SQL/record set based database systems.
East or West HMG is the Best.
South or North HMG is worth.
...the possibilities are endless.

User avatar
mol
Posts: 2874
Joined: Thu Sep 11, 2008 5:31 am
Location: Myszków, Poland
Has thanked: 133 times
Been thanked: 66 times
Contact:

Post by mol » Thu Jul 02, 2015 4:14 pm

I'm still using dbfs and browse control. I think it should always be updated.
I remember Roberto words, where he turned back from words this control is obsolete.
Great advantage of dbfs is this system is portable.
You can say that sqlite exists, but it hasn't still some types of fields.

User avatar
luisvasquezcl
Posts: 1039
Joined: Thu Jul 31, 2008 3:23 am
Location: Chile
Has thanked: 12 times
Been thanked: 14 times
Contact:

Post by luisvasquezcl » Thu Jul 02, 2015 5:45 pm

Estimado Rathinagiri,
el problema de uso de memoria se produce siempre en el grid, ya sea usando array o dbf.
Saludos cordiales
Luis Vasquez

Dear Rathinagiri,
the memory usage problem always occurs on the grid, either using array or dbf.
best regards
Luis Vasquez

User avatar
Pablo César
Posts: 4059
Joined: Wed Sep 08, 2010 1:18 pm
Location: Curitiba - Brasil
Has thanked: 100 times
Been thanked: 177 times

Post by Pablo César » Thu Jul 02, 2015 6:12 pm

Hola Luis,

Es posible disponibilizar un ejemplo con DBF y archivo con indices de la misma forma que utilizan ?

Los datos no precisan ser verdaderos, utilizá un replace secuencial para ejemplificar.

Seria bueno intentar entender lo que sucede y en la misma situacion que ustedes dicen.

Bueno tambien saber en que hardware y cual es el SO y version del HMG y modo (ANSI/UNICODE).
HMGing a better world
"Matter tells space how to curve, space tells matter how to move."
Albert Einstein

User avatar
luisvasquezcl
Posts: 1039
Joined: Thu Jul 31, 2008 3:23 am
Location: Chile
Has thanked: 12 times
Been thanked: 14 times
Contact:

Post by luisvasquezcl » Thu Jul 02, 2015 6:44 pm

Ok Pablo,
lo preparo y lo subo.
saludos cordiales,
Luis Vasquez

User avatar
Rathinagiri
Posts: 5181
Joined: Tue Jul 29, 2008 6:30 pm
DBs Used: MariaDB, SQLite, SQLCipher and MySQL
Location: Sivakasi, India
Has thanked: 141 times
Been thanked: 131 times
Contact:

Post by Rathinagiri » Thu Jul 02, 2015 6:58 pm

Luis Vasquez, the memory problem won't occur when we use virtual grid.
East or West HMG is the Best.
South or North HMG is worth.
...the possibilities are endless.

User avatar
Amarante
Posts: 182
Joined: Fri Apr 27, 2012 9:44 pm
Location: Araruama-RJ, Brazil

Post by Amarante » Thu Jul 02, 2015 9:35 pm

Rathinagiri wrote:Luis Vasquez, the memory problem won't occur when we use virtual grid.
+1

User avatar
brain
Posts: 23
Joined: Tue Aug 02, 2011 5:01 pm

Post by brain » Fri Jul 03, 2015 4:10 am

tnx guys. is there a way to manipulate the database in minimal usage of array when using the grid/browse control. its hard to explain. i mean, if i want to show 1M records for 20 records per browse page. my arrays should to 20 only not 1M arrays. it is always everytime u down, up, pageup or pagedown your records only the record pointer is moving not the array.

Post Reply