The People of Virginia VS Grabigial BanBerger | ARFCOM News

[ARCHIVED THREAD] - MS Access / Oracle JOIN Question

Posted: 1/20/2010 2:12:23 PM EDT

I'm trying to run a query where the tables have to be joined by fields of different data types; number and text. The tables do not belong to me and I cannot change the data types. I tried copying one table and changing the data type, but there is so much data thatI run out of memory.

The tables are both in an Oracle database, but MS Access is used as the interface. My questions are:

1. Is it possible to add a toChar function?
2. Is there a way to run the query in the server end instead of my machine?
3. Is there an even better way to go about this?

Thanks.

Posted: 1/20/2010 2:36:49 PM EDT

[#1]

yes, you could do it on the server as long as both servers have visibility to each other (or they're on the same server).

Posted: 1/20/2010 2:39:29 PM EDT

[#2]

cast not an option?

Posted: 1/20/2010 2:53:19 PM EDT

[#3]

Both are on the same server. I don't know what cast is.

Posted: 1/20/2010 4:12:49 PM EDT

[#4]

honestly, you should talk to an in-house Oracle developer for help.

Posted: 1/20/2010 4:18:35 PM EDT

[#5]

I thought I'd beat the developer to it.

I found the CStr function in Access and was able to bypass the "different datatypes" error message, but the query is not producing any data.

Thanks helping.

Posted: 1/21/2010 6:22:22 PM EDT

[#6]

The CStr function worked.

Posted: 1/21/2010 6:51:20 PM EDT

[#7]

Quoted:
Both are on the same server. I don't know what cast is.

CStr (..CLng, CInt... ) in access is (are) more or (actually) less what cast is in SQL - convert (or cast) from one type to another.

Posted: 1/21/2010 7:11:23 PM EDT

[#8]

Thanks for clarifying that.

[ARCHIVED THREAD] - MS Access / Oracle JOIN Question

Warning

Confirm Action

[ARCHIVED THREAD] - MS Access / Oracle JOIN Question

[ARCHIVED THREAD] - MS Access / Oracle JOIN Question