Hi,

I'm having a problem with the Refresh Data Dictionary function in the SDK.  Here is the situation:

I have a database in the SDK which references a DBC file on my hard drive.  I have gone through and entered all kinds of captions and headings for all of the existing fields and generally prettied up the metadata just how I like it.  I've now added a few fields to a couple of the tables in the DBC, and I want to bring that information into the SDK and update the meta data for the new fields.

The plan was to refresh the data dictionary and then turn on filtering so that all of the new fields would appear in bold and would be easy to find.  The problem I am having is that not only is the SDK adding the new fields from the DBC to its metadata, but it is also changing a lot of my Headings on existing fields.  I think it might have something to do with partial string matching, and I hate speculating on possible programming issues in other people's code, so here's a before and after example to show why I think that might be the case:

Before:

Caption: Box Flag

Heading: Box

After:

Caption: Box Flag

Heading: Box Flag

Every other example where the heading is changed is the same scenario - the heading used to be a substring of the caption and was changed to match the caption.  I would love to be able to update the SDK's meta data from my DBC without having to go back through and change all these headings back every time.

Any help would be much appreciated!

-Adam

Hi Adam,

It only took me a few minutes to be able to reproduce what you are seeing. If you have custom captions/headings entered, they shouldn't be changed during a refresh as far as I know.

It appears to me that it only happens if the heading text is the same as the underlying field name. Can you confirm that this is what you are seeing as well?

In any case, I will let the lead developer know about the issue and notify you when a fix is available.

Trevor

Trevor,

You're exactly right.  I took a closer look at the fields in the meta data and saw that there were some that fit my previous description that had not been changed.  Here is what I am seeing:

Field Name: Box

Field Caption: Box Flag

Field Heading: Box

The above will have its heading changed to "Box Flag"

Field Name: Box1

Field Caption: Box Flag

Field Heading: Box

The SDK will not change this heading during the refresh.  I also noticed one other case:

Field Name: Box

Field Caption: A Box Flag

Field Heading: Box

A field like this will not have its heading changed to "A Box Flag" (the heading remains just "Box"), but the meta data for this field still gets marked as having been changed, causing it to appear in bold when I filter the meta data.

If there's anything else I can do to help you pinpoint the issue further, just let me know and I'd be happy to help.

Thanks!

-Adam

Hi Adam.

I put an updated build in http://www.stonefieldquery.com/Downloads/SDK/Interim/sfqeditor.exe that fixes this issue. Thanks for your help tracking it down.

Doug

Hi Trevor and Doug,

I finally got a chance to try the new exe, and I just wanted to confirm that the issue is no longer occurring.

Thanks for your help and your fast response!

-Adam