GRID versus BROWSE

General Help regarding HMG, Compilation, Linking, Samples

Moderator: Rathinagiri

Post Reply
CCH4CLIPPER
Posts: 130
Joined: Tue Mar 03, 2009 8:59 am
Been thanked: 1 time

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: 5324
Joined: Tue Jul 29, 2008 6:30 pm
DBs Used: MariaDB, SQLite, SQLCipher and MySQL
Location: Sivakasi, India
Has thanked: 200 times
Been thanked: 210 times
Contact:

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: 1446
Joined: Sat Mar 07, 2009 11:52 am
Location: Kolkata, WB, India
Has thanked: 5 times
Been thanked: 2 times

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: 3409
Joined: Thu Sep 11, 2008 5:31 am
Location: Myszków, Poland
Has thanked: 268 times
Been thanked: 173 times
Contact:

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: 1446
Joined: Sat Mar 07, 2009 11:52 am
Location: Kolkata, WB, India
Has thanked: 5 times
Been thanked: 2 times

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: 3409
Joined: Thu Sep 11, 2008 5:31 am
Location: Myszków, Poland
Has thanked: 268 times
Been thanked: 173 times
Contact:

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: 1446
Joined: Sat Mar 07, 2009 11:52 am
Location: Kolkata, WB, India
Has thanked: 5 times
Been thanked: 2 times

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: 3409
Joined: Thu Sep 11, 2008 5:31 am
Location: Myszków, Poland
Has thanked: 268 times
Been thanked: 173 times
Contact:

Post by mol »

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

Post Reply