It was so obvious I didn't see it... thanx!!!

<hans@...> wrote in message news:3BF2D88A.5201@......

> Maybe
>
> SELECT Ammount, Currency, ExRate FROM BIG.DB A INNER JOIN
> SMALL.DB B ON A.Currency=B.Currency and B:UserType = :UserType;
>
> or if based on individuals
>
> SELECT Ammount, Currency, ExRate FROM BIG.DB A INNER JOIN
> SMALL.DB B ON A.Currency=B.Currency and B:UserNo = :UserNo;
>
> :UserType or :UserNo = User Dependend Variables supplied at
> time of Query.
>
> or some combination
>
> ============================
>
> Jose Gomez wrote:
> >
> > Hi,
> >
> > I'm changing an app from BDE to IB6. I need to calculate an
> > accounts-recibable aging report, on 1-30, 31-60, etc. days... The trick
> > comes with the exchange rates, which each user can enter to make their
> > estimates.
> > Each account invoice can be in franks, dollars, pesos, etc. So the user
> > enters a list of estimated exchage rates, this can be different for each
> > user, sales gets some numbers, accounting others, and CEO others.
> > I used to have 2 databases one locally so each user entered his/her own

data

> > and then make a few queries joining both databases for each user to make
> > their own calculations.
> > Something like:
> >
> > SELECT Ammount, Currency, ExRate FROM S:\SERVER\BIG.DB A INNER JOIN
> > C:\LOCAL\SMALL.DB B ON A.Currency=B.Currency;
> >
> > How can I do this with IBO / IB?
> >
> > Thanx in advance.
> >
> >

___________________________________________________________________________

> > IB Objects - direct, complete, custom connectivity to Firebird or

InterBase

> > without the need for BDE, ODBC or any other layer.
> >

___________________________________________________________________________

> > http://www.ibobjects.com - your IBO community resource for Tech Info

papers,

> > keyword-searchable FAQ, community code contributions and more !
> >
> > Your use of Yahoo! Groups is subject to

http://docs.yahoo.com/info/terms/

>
>
>

___________________________________________________________________________

> IB Objects - direct, complete, custom connectivity to Firebird or

InterBase

> without the need for BDE, ODBC or any other layer.
>

___________________________________________________________________________

> http://www.ibobjects.com - your IBO community resource for Tech Info

papers,

> keyword-searchable FAQ, community code contributions and more !
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>