Devart Forums

Posted: **Wed 13 Feb 2013 08:12**

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

Posted: **Wed 13 Feb 2013 14:16**

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.

Posted: **Wed 13 Feb 2013 14:42**

Hello,

thanks for reply. Vojslav.

Devart Forums

uniquery sql generator in uniquery editor

uniquery sql generator in uniquery editor

Re: uniquery sql generator in uniquery editor

Re: uniquery sql generator in uniquery editor