Active Query Builder support area

Advantage on Tokyo 10.2

Avatar
  • updated
  • Completed

Hello,

 

I'm installing the trial version for Tokyo 10.2. Advantage seems to be disabled. I know there is no official support for it, but there are ways to make it work. How can I make the installer work for Advantage on Tokyo?

Avatar
Andrey Zavyalov, PM

Sorry for the late response.

1. Sorry, but the current version of the component cannot detect the presence of user-defined functions. We will add this possibility in the next version. It will be released in the middle of February.

2. You can turn the TacQueryBuilder.SelectListOptions.CreateColumnAliasesFromAltNames property to true to generate aliases from alternate names automatically.

3. There are two ways to solve this problem. The first is to define foreign keys in the Metadata Container. You can do this using the Metadata Container Editor or by code (the code sample can be found in the LoadMetadata demo project, search for "TSQLMetadataRelation.Create" string).

Another way is to create joins in the query by code or automatically when the user adds a table to the query and another table, which should be linked to the newly added one, already exists in the query. I believe that the first approach is better as it lets show the linked objects button, so the user can look them up. But if you prefer the second way, let me know, I'll send you a code sample.

BTW, we've checked the downloadable standalone editor on our website and found that it's not suitable to work with AdvantgeDB now. We will update it as soon as possible. For now, please call the Metadata Container Editor from code. 

Let me know if you have any other questions or need more details on the above-mentioned questions.

Avatar
Raoul W

Hi,

 

2. When I use this option for example in the ALternateNames it does not give the desired result. For the Column with Alias Activity ID (ALTNO) I would expect the Alias for the column to be ActivityID and not a1. Am I missing something?

 

3. I dont see any option ion the metadata container editor? 

 

 

Thanks,

Avatar
Raoul W

Hi, any update on this?

Avatar
Andrey Zavyalov, PM

Hello Raoul.

Sorry for the late response.

Random aliases is the limitation of the trial version. You will get rid of them in the full version. Also, if you use alternate names for fields you'll be able to set aliases to alternate names automatically.