ISTech Support Forum - data type mismatch error

Welcome, Guest. Please Login.

	04/18/24 at 21:39:54 News: \| IS Tech Support \| Evo~ERP \| Evo Wiki \| Forum \|

ISTech Support Forum › Crystal Reports, ODBC & Access › Access General Issues

‹ Previous topic | Next topic ›

Pages: 1

data type mismatch error (Read 2497 times)

cathyh Active Member I used to be indecisive; now I'm not so sure...... Posts: 1213 Gender:	data type mismatch error 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?
Back to top	Cathy Hamilton Wing Inflatables, Inc. EVO-ERP2008.1(20 users) w/IS Tech update 5/25/09 (as of 08/21/09) Windows 2008 Server/client Pervasive V10.1 IP Logged

Kelloggs Active Member Do crazy people know they are crazy? Posts: 785 Gender:	Re: data type mismatch error Reply #1 - 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
Back to top	Evo ERP - 35 Users Dumped MS Access like a hot potato (VB.Net rules!!!) IP Logged

cathyh Active Member I used to be indecisive; now I'm not so sure...... Posts: 1213 Gender:	Re: data type mismatch error Reply #2 - 10/01/09 at 11:04:41 sorry for the typo-- BKAPCHKH
Back to top	Cathy Hamilton Wing Inflatables, Inc. EVO-ERP2008.1(20 users) w/IS Tech update 5/25/09 (as of 08/21/09) Windows 2008 Server/client Pervasive V10.1 IP Logged

cathyh Active Member I used to be indecisive; now I'm not so sure...... Posts: 1213 Gender:	Re: data type mismatch error Reply #3 - 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.
Back to top	Cathy Hamilton Wing Inflatables, Inc. EVO-ERP2008.1(20 users) w/IS Tech update 5/25/09 (as of 08/21/09) Windows 2008 Server/client Pervasive V10.1 IP Logged

Kelloggs

Active Member

Do crazy people know
they are crazy?

Posts: 785
Gender: male

Re: data type mismatch error
Reply #4 - 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.

Cheesy

Kelloggs

Evo ERP - 35 Users
Dumped MS Access like a hot potato (VB.Net rules!!!)

IP Logged

Pages: 1

ISTech Support Forum › Crystal Reports, ODBC & Access › Access General Issues

‹ Previous topic | Next topic ›