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

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.

Avatar
Raoul W

Hi, any update on this?

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
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, 

 

Are you able to look at the comment above?


Thanks,

Avatar
Raoul W

Yes that works for the editor, I see it now. I do not see my own functions in the Code Complete of the editor. How can I control the output of the Alias field names? I would like this to be the Alt names for fields and tables. Also how can I generate links? I saw there was a tool to create links from field names for DBS that do not have RI Objects, and how to create those in code.

Avatar
Andrey Zavyalov, PM

Hello, Raoul.

Sorry for the incorrect answer. Use the static method 

EditMetadataContainer(acQueryBuilder1.MetadataContainer);

We will update references to Advantage in the standalone MC Editor in a couple of days.

Functions must be visible in the code completion of the TacSQLTextEditor control. Is that list incomplete or don't you see them at all?

Avatar
Raoul W

List of functions in the Table/List view? Or in code completion?

Avatar
Raoul W

Hi Sergej,

 

Thanks for your quick response.

 

- This metadata Editor asks for .NET Dataprovider 8.10 (Which is quite old)

- The MetaDataContainer.Edit method does not exist in my code....

 

 

Avatar
Andrey Zavyalov, PM

Where exactly you want to show a list of functions?