Active Query Builder support area

Delphi - how to change programmatically alias for table and fields

Avatar
  • updated
  • Answered

Hi,

I need to change programmatically with Delphi, aliases of tables and fields added with Active Builder. 


Does anyone give me an example in Delphi?


Thanks.


KR Marco Severini.

Avatar
Andrey Zavyalov, PM
  • Answered

Hello Marco,

Sorry for the late response. 

Please find the sample in the attachment.

SetFieldAliasesDemo.rar

Avatar
josep
Quote from Andrey Zavyalov, PM

Hello Marco,

Sorry for the late response. 

Please find the sample in the attachment.

SetFieldAliasesDemo.rar

Hi Andrey, 


I installed the trial version of delphi+vcl (we are evaluating your product to include it in our software) and I was looking at what is said here. 

I downloaded the project from the zip but it doesn't work for me, there is no way to put an alias on a field in the query. 

My problem is that I need the field name to be the result of the composition between the alias of your table (ex: FROM Customer T1) + the field name (ex: T1.description), the result should be T1.description AS T1_description, but the result is similar to T1.description AS wg1 (looking at the zip code I tried to assign my composition but it always ends up assigning a different alias than what I tell it). Could it be the problem with the trial version of Active Query Builder?