Thanks very much Igor,
that explains it,
cheers,
Stef Mientki
Igor Tandetnik wrote:
Stef Mientki <[EMAIL PROTECTED]> wrote:
So I would expect that I now can always double quote the selection
fields, but unfortunately that doesn't seem to be true.
From a graphical design, I get for instance:
SELECT "Opnamen.PatNr", "Opnamen.Datum"
Opnamen, PatNr and Datum are three separate identifiers, and have to
be quoted separatedly (if at all), as in "Opnamen"."PatNr".
"Opnamen.PatNr" is a single identifier, distinct from Opnamen.PatNr
(which is two identifiers separated by period).
To illustrate, consider these valid SQL statements:
create table Opnamen (PatNr, "Opnamen.PatNr");
insert into Opnamen values (1, 2);
select
Opnamen.PatNr, "Opnamen"."PatNr",
"Opnamen.PatNr", Opnamen."Opnamen.PatNr"
from Opnamen;
The last query should return a single row with values (1, 1, 2, 2)
Igor Tandetnik
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
KvK: 41055629
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
