Is there a way to do a lookup into another table eg

SELECT _Name FROM Career JOIN Companies C ON C._ID = _fkCompanies

If so can you give me an example of the syntax.

Ta

Roy Lambert

Roy,

<< Is there a way to do a lookup into another table eg >>

Not currently, no.  I didn't want to introduce any unwieldly dependencies in
the computed columns initially until I had some time to think through the
ramifications.

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim


I can think of lots of ramifications a bit like RI but worse cos its "hidden". I also don't know what it would do to performance (that's what I was hoping to test)

Roy Lambert

Roy,

<< I can think of lots of ramifications a bit like RI but worse cos its
"hidden". I also don't know what it would do to performance (that's what I
was hoping to test) >>

Performance would actually be quite good.  However, the issue that I forgot
about was that sensitive result sets use computed columns for implementing
"live expressions", and the requirement is that the computed columns only
allow expressions that can be re-computed client-side with remote sessions
using the existing information in the same row.   Otherwise, any
modifications to other columns in the same row would require a round-trip to
the server (or more), thus resulting in fairly poor performance.

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim

> Performance would actually be quite good.  However, the issue that I forgot
> about was that sensitive result sets use computed columns for implementing
> "live expressions", and the requirement is that the computed columns only
> allow expressions that can be re-computed client-side with remote sessions

Is this issue also related with the sub-queries suggestion I posted 2
days ago, or are they completely different things?

--
Fernando Dias
Easygate, Lda

Fernando,

<< Is this issue also related with the sub-queries suggestion I posted 2
days ago, or are they completely different things? >>

Actually, that's 100% correct, and something that I really need to think
about further.  I think I can solve it by using generated columns instead
for the sub-query values.  That way they will stay static and stored in the
row on the client-side.

--
Tim Young
Elevate Software
www.elevatesoft.com