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]
-----------------------------------------------------------------------------
