I have a DBISAM table with 2 fields (1 String,10 and 1 Float) and I created a dataset for it. The DataColumns property show the two fields.

Sometime later, I added another 4 fields and modified the first field to String,50 and the second field to BCD,2.

Is there a way of having the DataColumns property of the dataset refreshed with the updated structure without having to do it manually?

--
Frederick

> Is there a way of having the DataColumns property of the dataset refreshed with the updated structure without having to do it manually?

From the docs:

The following are breaking changes in 2.06 Build 3:
....

The import of dataset columns in the dataset columns editor in the IDE now performs a reconciliation of the columns instead of an outright replacement of the columns. If any columns exist that don't exist in the imported columns, these columns will be moved to the end of the defined columns for the dataset where they can be manually removed, if necessary. If any of the imported columns reside in a different ordinal position in the dataset, the IDE will automatically correct the position of the affected column(s) during the import.

In addition, there is a new reset button that allows you to reconcile the columns using the existing columns in the dataset. The only restriction on performing a reset operation is that the dataset must be defined in the Database Manager. The IDE will always prompt you to select the database where the dataset is defined, but it will first attempt to scan the defined databases to find the proper database and, if it finds it, will automatically select it before prompting you to select the database.

Uli

Uli,

/*
In addition, there is a new reset button that allows you to reconcile the columns using the existing columns in the dataset. The only restriction on performing a reset operation is that the dataset must be defined in the Database Manager. The IDE will always prompt you to select the database where the dataset is defined, but it will first attempt to scan the defined databases to find the proper database and, if it finds it, will automatically select it before prompting you to select the database.
*/

This is the functionality I was looking for. I did see the button but the hint sounded so dire and the result possibly catastrophic that I hesitated to use it on my production dataset.

Maybe its name should be changed to "Refresh The Items".

--
Frederick

Frederick,

<< This is the functionality I was looking for. I did see the button but the hint sounded so dire and the result possibly catastrophic that I hesitated to use it on my production dataset.

Maybe its name should be changed to "Refresh The Items". >>

That's on purpose - it can result in columns being moved around and changed in ways that may break your application.

Tim Young
Elevate Software
www.elevatesoft.com

Tim,

/*
That's on purpose - it can result in columns being moved around and changed in ways that may break your application.
*/

I noticed that when the dataset is reset, fields that were present in the DBISAM table still remain in the data columns list.

For example, my table has fields Field1 and Field2. These two fields will be present in the data columns list initially. After I alter the table and remove Field1 and Field2 and add Field3 and Field4, Field1 and Field2 still remain in the data column list together with Field3 and Field4.

Is this intended behaviour?

--
Frederick

<<
I noticed that when the dataset is reset, fields that were present in the DBISAM table still remain in the data columns list.
>>

Just read the docs. Please.
It's all on there.

Uli

Uli,

/*
Just read the docs. Please.
It's all on there.
*/

I've searched the index for "Reset" and "Reset The Items" and that particular topic is not present.

Could you point me to the section that describes the process?

--
Frederick

On 2/28/2018 5:11 PM, Frederick Chin wrote:
> Uli,
>
> /*
> Just read the docs. Please.
> It's all on there.
> */
>
> I've searched the index for "Reset" and "Reset The Items" and that particular topic is not present.
>
> Could you point me to the section that describes the process?

Release notes is likely what you want

The import of dataset columns in the dataset columns editor in the IDE
now performs a reconciliation of the columns instead of an outright
replacement of the columns. If any columns exist that don't exist in the
imported columns, these columns will be moved to the end of the defined
columns for the dataset where they can be manually removed, if
necessary. If any of the imported columns reside in a different ordinal
position in the dataset, the IDE will automatically correct the position
of the affected column(s) during the import.

In addition, there is a new reset button that allows you to reconcile
the columns using the existing columns in the dataset. The only
restriction on performing a reset operation is that the dataset must be
defined in the Database Manager. The IDE will always prompt you to
select the database where the dataset is defined, but it will first
attempt to scan the defined databases to find the proper database and,
if it finds it, will automatically select it before prompting you to
select the database.

Raul

Raul wrote:

/*
Release notes is likely what you want

The import of dataset columns in the dataset columns editor in the IDE
now performs a reconciliation of the columns instead of an outright
replacement of the columns. If any columns exist that don't exist in the
imported columns, these columns will be moved to the end of the defined
columns for the dataset where they can be manually removed, if
necessary. If any of the imported columns reside in a different ordinal
position in the dataset, the IDE will automatically correct the position
of the affected column(s) during the import.
*/

Thanks. I think I will gather the release notes into a single file and perform a search there first.

No wonder Uli was frustrated with me for my post.

--
Frederick

Frederick,

<< Thanks. I think I will gather the release notes into a single file and perform a search there first. >>

The release notes are shipped as a self-contained HTML file with every release and linked to from the EWB program group under the Start menu in Windows (called "Release Information" there).

Tim Young
Elevate Software
www.elevatesoft.com