Why SDAC adds extra field I don't ask for

Discussion of open issues, suggestions and bugs regarding SDAC (SQL Server Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
atlek

Why SDAC adds extra field I don't ask for

Post by atlek » Mon 03 Oct 2005 15:15

I'm trying to use SDAC (trial) with kbmMW and it works, but I can't use it as long as it is adding this extra field. As an example I have this Query:

SELECT A.ARTICLE, A.DESCR,C.CAMPAIGN_ID, C.ARTICLE_ID,C.REMARK,C.PRICE
FROM CAMPAIGN C
JOIN ARTICLE A ON A.ARTICLE_ID=C.ARTICLE_ID

This gives me the fields listed, but it also adds in the the field ARTICLE_ID_1 that is NOT listed. This breaks the rules and prevents me from using SDAC. Are there anything I can do to prevent that?

I have also checked your dbExpress driver as an option, but since this driver (as it should) uses TimeStamp field instead of DateTime I have other problems. Can this driver be configured to use DateTime instead of TimeStamp fields?

Regards

Atle Kåven

Ikar
Posts: 1693
Joined: Thu 28 Oct 2004 13:56

Post by Ikar » Tue 04 Oct 2005 09:25

> Are there anything I can do to prevent that?

Set TCustomMSDataSet.Options.UniqueRecords to False. Please read details in SDAC help

> DbxSda
> Can this driver be configured to use DateTime instead of TimeStamp fields?

No, it is impossible in dbExpress

atlek@arcticnet.no

Post by atlek@arcticnet.no » Tue 04 Oct 2005 19:28

Thanks!
I am glad to read that.

Post Reply