I might be mistaken but you should never expect row-0 for data.
What i meant is that the fieldnames are present when there is data.
And not when there is no data.
In either case, row-0 should never be threated as data row.
So one can not expect data in there.
The point is when there is data, SQLite returns the fieldnames from a
(joined) query.
For what reason it should not return the names when there was no data?
(And not having an error of course)
I'm pretty certain this is only a technical matter, not a logical one.
schema table?
I'm not familiar with that, i don't think it is realted to fields from
join-ed queries.
This question has not much to do with my earlier post, i know how to obtain
the fields properly.
----- Original Message -----
From: "Charlie Clark" <[EMAIL PROTECTED]>
To: <sqlite-users@sqlite.org>
Sent: Sunday, July 24, 2005 4:26 PM
Subject: Re: [sqlite] I still think it's a bug, 0 rows, no fieldnames
On 2005-07-24 at 16:11:26 [+0200], Edwin Knoppert <[EMAIL PROTECTED]>
wrote:
Why defending it?
It's prob. a simple issue.
Besides, why i want the names, why should a system need to parse a query?
You approach this way to 'static' imo (what you enter is your result).
You can easily say to also remove the fieldnames when we *have* data.
An 0-row containing the relational variables is a *special* case and
non-relational and causes problems for results which do not expect the
names of the values to be included in the result set.
.schema(table) gives you all you need.
Charlie