[ic] Query problem with shared database

Jamie Neil interchange-users@icdevgroup.org
Tue Jun 3 13:33:01 2003


> -----Original Message-----
> From: interchange-users-admin@icdevgroup.org
> [mailto:interchange-users-admin@icdevgroup.org]On Behalf Of Jon Jensen
> Sent: 03 June 2003 18:09
> To: interchange-users@icdevgroup.org
> Subject: RE: [ic] Query problem with shared database
>
>
> On Tue, 3 Jun 2003, Jamie Neil wrote:
>
> > Out of interest, what happens if you do a query that uses two
> databases with
> > different DSNs?
>
> How would you do that? Think through what Interchange is doing. You tell
> it "table=merchandising", so it translates that to a certain DSN, then
> passes the query verbatim to that DSN. If your query makes no sense to
> that database, I'm sure it'll politely tell you, but that's between you
> and the database, and Interchange is just the messenger. :)
>
> Jon

Sorry - silly question. For some reason I was getting it into my head that
IC would be doing the join, but of course that's the database's job.

Jamie