1. RE: EUGRid and EDB
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
>
>
2. RE: EUGRid and EDB
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
> >
> >
3. RE: EUGRid and EDB
Phil,
Glad to hear that you're still around!
If you're still looking for some enhancement ideas:
1. It would be nice to have a column with a "browse" button where when
clicked EuGrid calls a user written routine. That routine would return
back to EuGrid the value to place in the column. The reason for this
would be sometimes the valid values for a column are too numerous to
have in a drop down list or you would like to provide a lookup routine
for the user (i.e. entering a part number or customer number).
2. Date/time type columns with a popup calendar control (I had this in
my lame grid control and we discussed it at one point). Maybe automatic
date/time formatting and validation too.
Also, with the current EuGrid can a user supplied popup menu be shown
when the user right clicks in a grid?
Thanks again for a great control!
Jonas
Phil Russell wrote:
>
>
> 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!
>
>
4. RE: EUGRid and EDB
Hi Jonas,
As it happens, a browse button is *exactly* what I am working on at the
moment. You will be able to specify a button on a per column (or
individual cell) basis which will call a supplied routine id. If it
goes really well you will be able to specify a bitmap for the button.
The rest of the release will include:
1. Picture cells e.g. you can display bitmaps in cells (done).
2. Picture headers - you can display bitmaps in the header cell on a per
grid or per row basis (done).
3. Support for multiple row select via mouse and keyboard (done).
4. Retrofitting a number of changes that Matt Lewis made for his
EuSQL/EDB project (mostly done).
5. New custom message for right mouse clicks (not started).
I will release it as soon as the browse buttons are working. At the
moment they are painting OK but non-functional.
I am (painfully) aware that a date/time cell is needed. Once the above
is out of the way that will be my next job. I am hoping that I will be
able to get it to fit nicely into a cell in the same way as combo boxes
but this means getting up to speed on the MS common controls library. If
I have read the docs right (and I can get it to work) we should be able
to have a nicely formatted date edit cell with a dropdown calendar
control. In the meantime you will at least be able to use a pop-up
calendar control (like in your grid) via a browse button.
The other things on the top of my to-do list are:
1. Row resizing on a per grid or row basis (this is fairly major).
2. Single/Multi Column selection.
Thanks for all the positive feedback - it makes it much more fun if I
think that people are actually using the damn thing. Let me know if you
think of anything else.
BTW would you be interested in test-driving an advance copy of the
control before I release it?
Regards,
Phil
Jonas Temple wrote:
>
>
> Phil,
>
> Glad to hear that you're still around!
>
> If you're still looking for some enhancement ideas:
>
> 1. It would be nice to have a column with a "browse" button where when
> clicked EuGrid calls a user written routine. That routine would return
>
> back to EuGrid the value to place in the column. The reason for this
> would be sometimes the valid values for a column are too numerous to
> have in a drop down list or you would like to provide a lookup routine
> for the user (i.e. entering a part number or customer number).
> 2. Date/time type columns with a popup calendar control (I had this in
> my lame grid control and we discussed it at one point). Maybe automatic
>
> date/time formatting and validation too.
>
> Also, with the current EuGrid can a user supplied popup menu be shown
> when the user right clicks in a grid?
>
> Thanks again for a great control!
>
> Jonas
5. RE: EUGRid and EDB
Phil,
See replies below...
Phil Russell wrote:
>
>
> Hi Jonas,
>
> As it happens, a browse button is *exactly* what I am working on at the
> moment. You will be able to specify a button on a per column (or
> individual cell) basis which will call a supplied routine id. If it
> goes really well you will be able to specify a bitmap for the button.
Excellent!
>
> The rest of the release will include:
>
> 1. Picture cells e.g. you can display bitmaps in cells (done).
Very cool...
> 2. Picture headers - you can display bitmaps in the header cell on a per
>
> grid or per row basis (done).
> 3. Support for multiple row select via mouse and keyboard (done).
> 4. Retrofitting a number of changes that Matt Lewis made for his
> EuSQL/EDB project (mostly done).
> 5. New custom message for right mouse clicks (not started).
Wow, were you reading my mind?
>
> I will release it as soon as the browse buttons are working. At the
> moment they are painting OK but non-functional.
>
> I am (painfully) aware that a date/time cell is needed. Once the above
> is out of the way that will be my next job. I am hoping that I will be
> able to get it to fit nicely into a cell in the same way as combo boxes
> but this means getting up to speed on the MS common controls library. If
>
> I have read the docs right (and I can get it to work) we should be able
> to have a nicely formatted date edit cell with a dropdown calendar
> control. In the meantime you will at least be able to use a pop-up
> calendar control (like in your grid) via a browse button.
Sounds good!
>
> The other things on the top of my to-do list are:
>
> 1. Row resizing on a per grid or row basis (this is fairly major).
> 2. Single/Multi Column selection.
>
> Thanks for all the positive feedback - it makes it much more fun if I
> think that people are actually using the damn thing. Let me know if you
>
> think of anything else.
Oh, definitely using it! My F.R.O.G. for IBM iSeries database utility
uses EuGrid to allow the user to change their library list. F.R.O.G.
will be featured in an IBM magazine either in April or May.
>
> BTW would you be interested in test-driving an advance copy of the
> control before I release it?
BRING IT ON! :)
6. RE: EUGRid and EDB
Phil,
I did reply to this but it got sucked into the Topica abyss!
See replies below...
> As it happens, a browse button is *exactly* what I am working on at the
> moment. You will be able to specify a button on a per column (or
> individual cell) basis which will call a supplied routine id. If it
> goes really well you will be able to specify a bitmap for the button.
>
Sounds great!
> The rest of the release will include:
>
> 1. Picture cells e.g. you can display bitmaps in cells (done).
> 2. Picture headers - you can display bitmaps in the header cell on a per
>
> grid or per row basis (done).
> 3. Support for multiple row select via mouse and keyboard (done).
> 4. Retrofitting a number of changes that Matt Lewis made for his
> EuSQL/EDB project (mostly done).
> 5. New custom message for right mouse clicks (not started).
Excellent! I like the idea of being able to put pictures into the grid.
> Thanks for all the positive feedback - it makes it much more fun if I
> think that people are actually using the damn thing. Let me know if you
>
> think of anything else.
Oh, definitely using the control! As a matter of fact, my FROG database
utility for the iSeries will be featured in the IBM eServer magazine in
either the April or May issue. Your grid control is used in one of the
features!
>
> BTW would you be interested in test-driving an advance copy of the
> control before I release it?
>
Bring it on! :)
Jonas
7. RE: EUGRid and EDB
Jonas,
I would love to see a Euphoria app go 'mainstream'. Way to go!
Phil
PS Any chance of seeing a copy of the article when it appears? Vanity,
vanity...
Jonas Temple wrote:
> Oh, definitely using the control! As a matter of fact, my FROG database
>
> utility for the iSeries will be featured in the IBM eServer magazine in
> either the April or May issue. Your grid control is used in one of the
> features!
