Re: [sqlite] Re: to quote or not ?

2007-03-15 Thread Stef Mientki

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



[sqlite] Re: to quote or not ?

2007-03-14 Thread Igor Tandetnik

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