I'm not sure if this point is off topic regarding this isue, but just to let all
know,
To get the SQLite Delphi components back on-line i had to define:
SQLite3_ExecSQL('PRAGMA full_column_names=off');
SQLite3_ExecSQL('PRAGMA short_column_names=off');
to get things going again.
Not using this, caused additional metadata retrieved from the query, i.e. the
rowid was reported differently. Perhaps this is a help for other wrapper
authors. I remember a similar post by Tim Anderson who is an author of a
'simple' wrapper of Delphi.
Albert Drent
aducom software
Quoting Cariotoglou Mike <[EMAIL PROTECTED]>:
> I have opened a ticket (#1147) for the full_column_names issue, which is back
> in 3.1.3. pls check it out.
>
> also, I noticed the following :
>
> when selecting from a view, and duplicate column names exist, there is an
> attempt to de-dupe them, by adding a sequence number, like this:
>
> ID ID:1 ID:2 etc
>
> this however does not happen with duplicate columns that are returned from a
> query. so,
>
> the statement:
>
> select * from master,detail where detail.masterID=master.ID
>
> and,
>
> create view v1 as select * from master,detail where
> detail.masterID=master.ID;
> select * from v1;
>
> do not have the same result wrt to column names.
>
> I feel this is inconsistent. you should either de-dupe all result sets (IMHO
> a bad idea), or leave all result sets alone, as far as names is concerned (my
> suggestion).
>
> I understand that this "column names" issue is becoming a pain for the sqlite
> authors, but OTOH, it is very important for wrapper authors...
>
>
>
>
