Hi All,

I have a grid connected to a dataset, when i enter a cell in grid i have
to doubleclick before i can change the value - is it normal?

Regards,
Hüseyin

And, what's the best way of saving changed value to dataset, because
it's not done automatically as i can see

Regards,
Hüseyin

On 01-07-2015 14:42, Hüseyin Aliz wrote:
> Hi All,
>
> I have a grid connected to a dataset, when i enter a cell in grid i
> have to doubleclick before i can change the value - is it normal?
>
> Regards,
> Hüseyin

Hüseyin,

> And, what's the best way of saving changed value to dataset, because
> it's not done automatically as i can see

You can always query a dataset's state in order to check if changes were
made. If so, just use a transaction and commit the changes.

I recommend to read the chapter "Using Datasets" in the EWB help. It's
all in there.

Uli

Hi Uli,

I am using a grid to display (and trying to update) the dataset, will
there be a difference here? I know i can save changes when using
standard edit,multiline etc, but i am not sure about the grid

Regards,
Hüseyin

Den 02-07-2015 kl. 10:55 skrev Uli Becker:
> Hüseyin,
>
>> And, what's the best way of saving changed value to dataset, because
>> it's not done automatically as i can see
>
> You can always query a dataset's state in order to check if changes
> were made. If so, just use a transaction and commit the changes.
>
> I recommend to read the chapter "Using Datasets" in the EWB help. It's
> all in there.
>
> Uli
>

Hüseyin,

> I am using a grid to display (and trying to update) the dataset, will
> there be a difference here? I know i can save changes when using
> standard edit,multiline etc, but i am not sure about the grid

It doesn't matter which control you use if this control is bound to a
dataset. Do you see something different?

Uli

Uli,

Probably i am doing something wrong but:

Dataset insert and loadrows from dataset works fine with the grid. When
i enter a cell (doubleclick actually -  just entering the cell does not
set focus)  in grid to change some value (like amount field), the
changes are not reflected back to dataset, even if i make a
dataset.update, dataset.save.. commit in a transaction.

Regards,
Hüseyin

Den 02-07-2015 kl. 14:25 skrev Uli Becker:
> Hüseyin,
>
>> I am using a grid to display (and trying to update) the dataset, will
>> there be a difference here? I know i can save changes when using
>> standard edit,multiline etc, but i am not sure about the grid
>
> It doesn't matter which control you use if this control is bound to a
> dataset. Do you see something different?
>
> Uli
>

Hüseyin,

> Dataset insert and loadrows from dataset works fine with the grid. When
> i enter a cell (doubleclick actually -  just entering the cell does not
> set focus)  in grid to change some value (like amount field), the
> changes are not reflected back to dataset, even if i make a
> dataset.update, dataset.save.. commit in a transaction.

First of all a correction: I spoke about the Dataset.State to check if
changes were made - actually I was talking about Dataset.Modified.

I just tried that and can confirm that the commit works, if you change a
value in a Grid's cell, press ENTER and then execute the Transaction code.
It does *not* work when you leave the record and execute the Transaction
code after that. In the latter case Dataset.Modified is false.

I can't say if that's a bug or by design, but would expect as well that
a commit saves all recent changes of the dataset.

So I can't help you with that.

Uli

Uli,

It does not work for me even if i press enter after change of value. Can
you please share the code where you change and save/post to dataset?
Thanks

Regards,
Hüseyin


On 02-07-2015 15:58, Uli Becker wrote:
> Hüseyin,
>
> > Dataset insert and loadrows from dataset works fine with the grid. When
>> i enter a cell (doubleclick actually - just entering the cell does not
>> set focus)  in grid to change some value (like amount field), the
>> changes are not reflected back to dataset, even if i make a
>> dataset.update, dataset.save.. commit in a transaction.
>
> First of all a correction: I spoke about the Dataset.State to check if
> changes were made - actually I was talking about Dataset.Modified.
>
> I just tried that and can confirm that the commit works, if you change
> a value in a Grid's cell, press ENTER and then execute the Transaction
> code.
> It does *not* work when you leave the record and execute the
> Transaction code after that. In the latter case Dataset.Modified is
> false.
>
> I can't say if that's a bug or by design, but would expect as well
> that a commit saves all recent changes of the dataset.
>
> So I can't help you with that.
>
> Uli

Hüseyin,

<< I have a grid connected to a dataset, when i enter a cell in grid i have
to doubleclick before i can change the value - is it normal? >>

Yes, you have to double-click or use the Enter key.

One of the outstanding enhancement requests is an AlwaysShowEditor type of
property for the grids.

Tim Young
Elevate Software
www.elevatesoft.com

Hüseyin,

<< Dataset insert and loadrows from dataset works fine with the grid. When i
enter a cell (doubleclick actually -  just entering the cell does not
set focus)  in grid to change some value (like amount field), the changes
are not reflected back to dataset, even if i make a dataset.update,
dataset.save.. commit in a transaction. >>

Please post the code that you’re using.  It matters where you start the
transaction/commit, because it has to be done *after* the row has been
updated.

Tim Young
Elevate Software
www.elevatesoft.com