OpenEuphoria

RE: EUGRid and EDB

• Posted by Phil Russell <pg_russell at lineone.net> Mar 04, 2004
• 688 views

Hi Sixs,

Jonas is correct in how EuGrid behaves.  It helps to consider the grid 
data in two pieces:

1. The underlying dataset e.g. the database record in your example.
2. The grid columns.  These act like 'windows' onto the underlying 
dataset.  

You can use grid columns to display none, some or all of the items in 
the underlying dataset.  If you want you can have several columns all 
referring to the same underlying data item e.g. see the multiline tab in 
the styles.exw sample shipped with the grid.  In this case a text change 
in one cell affects all of the cells for that row, because they 
reference the same underlying data item.

This behaviour is deliberate - it is very common in database apps to 
need to store information e.g. key values which you do not want to 
display to the user.  It also allows you to move & change the grid 
columns at runtime without having to manipulate the underlying dataset.

HTH,

Phil

PS Jonas - I haven't given up. New version of EuGrid out soon!


Jonas Temple wrote:
> 
> 
> Sixs,
> 
> When you create an EuGrid column you define the index number of the grid 
> 
> control's data that is displayed in the column.  So if you had:
> 
> * Record Key = {1}
> * Record Data = {"Number One","First One"}
> 
> You could create a single sequence:
> 
> {1,"Number One","First One"}
> 
> and then the first column would point to element 2 of the sequence as 
> the data to display.  The 1 is in the control, just in a column that is 
> not displayed.  So when you unload the data, you would get
> 
> {1,"Number One","First One"}
> 
> I don't have EuGrid in front of me right now or I would have a real 
> example.  If you need, I might be able to come up with one tomorrow 
> (well, it might be tomorrow where you're at).
> 
> Jonas
> Sixs wrote:
> > 
> > 
> > Hi,
> > 
> > I am looking at the example of the grid and the database and am confused
> > about the key value. For example you have created a record and the 
> > record
> > key has been assigned a value automatically. When you read it into the 
> > grid
> > what do you do with the value. When you update or change the record what 
> > 
> > has
> > happened to the key if it is not stored in the grid along with the 
> > record
> > data?
> > 
> > jvandal
> > 
> >