Query generator problem

[bzwirs]

Using latest version IBDAC. Delphi XE2 (Update 4).

Have the following query in a TIBCQuery component

Code: Select all

select SCHEDID, MACHID, SITECODE, ARRIVETIME, DAYNUM, FILLERCODE, ROUTEORDER, TIMESPENT, WEEKNUM, DAYNAME,UNAME
from WEEKSCHED
where MACHID = :MACHID and
      SITECODE = :SITECODE

The key field is SCHEDID. When I use the SQL generator to create the update, insert, delete and refresh SQL's I get the following result.

For Insert:

Code: Select all

INSERT INTO WEEKSCHED
  (UNAME, SESSIONCODE, TIMESPENT, ARRIVETIME, ROUTEORDER, DAYNUM, DAYNAME, FILLERCODE, WEEKNUM, SITECODE, SCHEDID)
VALUES
  (:UNAME, :SESSIONCODE, :TIMESPENT, :ARRIVETIME, :ROUTEORDER, :DAYNUM, :DAYNAME, :FILLERCODE, :WEEKNUM, :SITECODE, :SCHEDID)

Update :

Code: Select all

UPDATE WEEKSCHED
SET
  UNAME = :UNAME, SESSIONCODE = :SESSIONCODE, TIMESPENT = :TIMESPENT, ARRIVETIME = :ARRIVETIME, ROUTEORDER = :ROUTEORDER, DAYNUM = :DAYNUM, DAYNAME = :DAYNAME, FILLERCODE = :FILLERCODE, WEEKNUM = :WEEKNUM, SITECODE = :SITECODE, SCHEDID = :SCHEDID
WHERE
  UNAME = :Old_UNAME

Delete :

Code: Select all

DELETE FROM WEEKSCHED
WHERE
  UNAME = :Old_UNAME

Refresh:

Code: Select all

SELECT UNAME, SESSIONCODE, TIMESPENT, ARRIVETIME, ROUTEORDER, DAYNUM, DAYNAME, FILLERCODE, WEEKNUM, SITECODE, SCHEDID FROM WEEKSCHED
WHERE
  UNAME = :Old_UNAME

As you can see the SQL generator has reversed the field names and then used the UNAME field as the key field instead of SCHEDID. I have tried the same query on my Delphi 2010 version which has an older version of IBDAC and SQL's are created correctly.

Am I doing something wrong this time or is this a bug in the latest version of IBDAC?

regards

Bill Zwirs

[AndreyZ]

Hello,

There is a problem with generating SQL queries using the SQL generator in design-time in all the latest DAC products. We will fix this problem in the next builds of all the DAC products.

[bzwirs]

Ok. Thanks.

regards

Bill Zwirs