ISTech Support Forum

ISTech Support Forum
http://www.istechforum.com/YaBB.pl
Crystal Reports, ODBC & Access >> Access General Issues >> data type mismatch error
http://www.istechforum.com/YaBB.pl?num=1254325770

Message started by cathyh on 09/30/09 at 08:49:30

Title: data type mismatch error
Post by cathyh on 09/30/09 at 08:49:30

I am trying to link a data field in two files BKCHKH and MKICLASS but the related fields are different types, one text and the other number. How can I get around this?

Title: Re: data type mismatch error
Post by Kelloggs on 10/01/09 at 10:42:23

select * from "BKCHKH"

[LNA][Pervasive][ODBC Engine Interface][Data Record Manager]No such table or object.

What's the name of the table??

Kelloggs

Title: Re: data type mismatch error
Post by cathyh on 10/01/09 at 11:04:41

sorry for the typo-- BKAPCHKH

Title: Re: data type mismatch error
Post by cathyh on 10/01/09 at 11:35:43

BKAPCHKH.BKAP_CHK_INVNUM and MKICLASS.MKECLASS_NUM, in order to get at the long invoice number in MKICLASS.MKECLASS.DESC.

Title: Re: data type mismatch error
Post by Kelloggs on 10/01/09 at 11:48:35

If you do it on ms access by downloading or linking the tables. It will not work.

But, if you create a pass-through query it will work:

SELECT
BKAPCHKH.BKAP_CHK_INVNUM,
MKICLASS.MKECLASS_DESC
FROM BKAPCHKH INNER JOIN MKICLASS ON BKAPCHKH.BKAP_CHK_INVNUM = MKICLASS.MKECLASS_NUM

Once you have your pass-through query with the proper "WHERE " (if you need one) then you can download the data for further analysis

Let me know how it goes.

:D

Kelloggs