REVISION OF GRID/BROWSE
Moderator: Rathinagiri
REVISION OF GRID/BROWSE
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!
- Pablo César
- Posts: 4059
- Joined: Wed Sep 08, 2010 1:18 pm
- Location: Curitiba - Brasil
REVISION OF GRID/BROWSE
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.
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
"Matter tells space how to curve, space tells matter how to move."
Albert Einstein
- Rathinagiri
- Posts: 5471
- Joined: Tue Jul 29, 2008 6:30 pm
- DBs Used: MariaDB, SQLite, SQLCipher and MySQL
- Location: Sivakasi, India
- Contact:
Re: REVISION OF GRID/BROWSE
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.
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.
South or North HMG is worth.
...the possibilities are endless.
Re: REVISION OF GRID/BROWSE
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.
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.
- luisvasquezcl
- Posts: 1258
- Joined: Thu Jul 31, 2008 3:23 am
- Location: Chile
- Contact:
Re: REVISION OF GRID/BROWSE
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
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
- Pablo César
- Posts: 4059
- Joined: Wed Sep 08, 2010 1:18 pm
- Location: Curitiba - Brasil
Re: REVISION OF GRID/BROWSE
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).
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
"Matter tells space how to curve, space tells matter how to move."
Albert Einstein
- luisvasquezcl
- Posts: 1258
- Joined: Thu Jul 31, 2008 3:23 am
- Location: Chile
- Contact:
Re: REVISION OF GRID/BROWSE
Ok Pablo,
lo preparo y lo subo.
saludos cordiales,
Luis Vasquez
lo preparo y lo subo.
saludos cordiales,
Luis Vasquez
- Rathinagiri
- Posts: 5471
- Joined: Tue Jul 29, 2008 6:30 pm
- DBs Used: MariaDB, SQLite, SQLCipher and MySQL
- Location: Sivakasi, India
- Contact:
Re: REVISION OF GRID/BROWSE
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.
South or North HMG is worth.
...the possibilities are endless.
- Amarante
- Posts: 182
- Joined: Fri Apr 27, 2012 9:44 pm
- DBs Used: DBF, MySQL, MariaDB, SQLite, PostgreSQL
- Location: Araruama-RJ, Brazil
Re: REVISION OF GRID/BROWSE
+1Rathinagiri wrote:Luis Vasquez, the memory problem won't occur when we use virtual grid.
Re: REVISION OF GRID/BROWSE
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.