GRID versus BROWSE

General Help regarding HMG, Compilation, Linking, Samples

Moderator: Rathinagiri

Post Reply
CCH4CLIPPER
Posts: 140
Joined: Tue Mar 03, 2009 8:59 am

GRID versus BROWSE

Post by CCH4CLIPPER »

Hi All

From the help file :-
A Browse control is a general purpose database browser.
A control Grid is a container object that displays data in rows and columns, and is similar in appearance to a Browse window.

1. So, what are the differences
2. When to use BROWSE
3. When to use GRID


Please enlighten me

TIA


CCH
http://cch4clipper.blogspot.com
User avatar
Rathinagiri
Posts: 5471
Joined: Tue Jul 29, 2008 6:30 pm
DBs Used: MariaDB, SQLite, SQLCipher and MySQL
Location: Sivakasi, India
Contact:

Re: GRID versus BROWSE

Post by Rathinagiri »

Browse controls are always linked with one table (that too a .dbf table).

Grid controls are for used for other purposes where, you wish to represent data in row,col format. For example, it may show a two dimensional array!

All the browse controls are grid controls but not vice versa.
East or West HMG is the Best.
South or North HMG is worth.
...the possibilities are endless.
User avatar
sudip
Posts: 1454
Joined: Sat Mar 07, 2009 11:52 am
Location: Kolkata, WB, India

Re: GRID versus BROWSE

Post by sudip »

Hi,

For browse control (for data editing), do we need to use table "EXCLUSIVELY" ?

Regards.

Sudip
With best regards,
Sudip
User avatar
mol
Posts: 3720
Joined: Thu Sep 11, 2008 5:31 am
Location: Myszków, Poland
Contact:

Re: GRID versus BROWSE

Post by mol »

You need to open table in exclusive mode only when you want to add records or edit record via ALT-A, ALT-E.
If you open tale in shared mode, you must write your own function to add, edit or delete rows.

Marek
User avatar
sudip
Posts: 1454
Joined: Sat Mar 07, 2009 11:52 am
Location: Kolkata, WB, India

Re: GRID versus BROWSE

Post by sudip »

Helo MOL,

Thanks a lot!
I am also thinking in that way.

After reading samples an tips from this form I feel that GRID is more flexible, isn't it? :)

Regards.

Sudip
With best regards,
Sudip
User avatar
mol
Posts: 3720
Joined: Thu Sep 11, 2008 5:31 am
Location: Myszków, Poland
Contact:

Re: GRID versus BROWSE

Post by mol »

I think you will have problems with browsing huge tables (exhausting memory, etc) while using grid.
using Browse, I didn't found problems with database which has 100MB.
User avatar
sudip
Posts: 1454
Joined: Sat Mar 07, 2009 11:52 am
Location: Kolkata, WB, India

Re: GRID versus BROWSE

Post by sudip »

Hello MOL,

So, what should I use for example One to Many form and for Searching Records.?

Regards.

Sudip
With best regards,
Sudip
User avatar
mol
Posts: 3720
Joined: Thu Sep 11, 2008 5:31 am
Location: Myszków, Poland
Contact:

Re: GRID versus BROWSE

Post by mol »

Sorry, I can't find what are you looking for...
Post Reply