uniquery sql generator in uniquery editor

[ketas]

Hi,

i have in version unidac 4.6.11 problem with sql generator. When i
used alias for column name , ist this alias not used in sql which ist generated
for insert, update etc.

e.g. update sql for query :

Code: Select all

SELECT ORGANISATION.ORG_ID,
       ORGANISATION.SPEZIFIKATION ORGANISATION,
       BRANSCHEN.BR_ID,
       BRANSCHEN.SPEZIFIKATION BRANCHE
  FROM  ORGANISATION,BRANSCHEN
      WHERE (ORGANISATION.BR_ID = BRANSCHEN.BR_ID)

is

Code: Select all

 UPDATE ORGANISATION SET 
   ORG_ID = :ORG_ID, BR_ID = :BR_ID, SPEZIFIKATION =  :SPEZIFIKATION, :MBDKEY_ACN, 
    WHERE   ORG_ID = :Old_ORG_ID

generated.
I think in earlier versions was SPEZIFIKATION = :ORGANISATION generated. Same situation is with odac 8.6.11 . Now when i update record, error message : "not found field corresponding parameter SPEZIFIKATION" appears.
Is this design or bug? Thanks. Vojslav

[AlexP]

Hello,

Thank you for the information, we have reproduced the problem and will try to fix it till the next version. For the time being, to solve the problem, you can temporarily stop using aliasesor edit generated queries by replacing parameter names with appropriate field aliases.

[ketas]

Hello,

thanks for reply. Vojslav.