Subject | Re: [IBO] Syntax of Links? |
---|---|
Author | Daniele Teti |
Post date | 2004-11-18T12:18:15Z |
Helen Borrie wrote:
[cut]
Thanx for your exaustive answer.
with some combolookup I'm not need KeyDescLinks?
[cut]
There is particular reason for this syntax
SELECT
ID
, TESTO
, DATA
, ID_AUTORE
, (SELECT DESCRIZIONE FROM AUTORI
WHERE ID=B.ID_AUTORE) AUTORE
FROM BARZE B
insted of (IMHO more cleaner )
SELECT
A.ID ID
, TESTO
, DATA
, ID_AUTORE
, DESCRIZIONE
FROM
BARZE B
join
AUTORI A
on B.ID_AUTORE=A.ID
I've seen this syntax in many examples...
There is a reason to use 1st instead of 2nd ?
thanx
-
Daniele Teti (tm)
Software Architect
http://dade2000.altervista.org
--
[Non-text portions of this message have been removed]
[cut]
Thanx for your exaustive answer.
>>Links in TIBO_Query.KeyDescLinks are used when... with this syntax...Only for grids? So, If I've a grid for select and a form for editing
>>
>>
>Not available to TIBOQuery. It's used as part of a linking for embedding
>TIB_LookupCombo into a TIB_Grid.
>
>
with some combolookup I'm not need KeyDescLinks?
[cut]
>See also the examples in the Samples directory of your IBO installation.Another question.
>
There is particular reason for this syntax
SELECT
ID
, TESTO
, DATA
, ID_AUTORE
, (SELECT DESCRIZIONE FROM AUTORI
WHERE ID=B.ID_AUTORE) AUTORE
FROM BARZE B
insted of (IMHO more cleaner )
SELECT
A.ID ID
, TESTO
, DATA
, ID_AUTORE
, DESCRIZIONE
FROM
BARZE B
join
AUTORI A
on B.ID_AUTORE=A.ID
I've seen this syntax in many examples...
There is a reason to use 1st instead of 2nd ?
thanx
-
Daniele Teti (tm)
Software Architect
http://dade2000.altervista.org
--
[Non-text portions of this message have been removed]