Why SDAC adds extra field I don't ask for
Posted: 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
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