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.
----- Original Message -----
From: "Puneet Kishor" <[EMAIL PROTECTED]>
To: <sqlite-users@sqlite.org>
Sent: Sunday, July 24, 2005 3:40 PM
Subject: Re: [sqlite] I still think it's a bug, 0 rows, no fieldnames
On Jul 24, 2005, at 6:52 AM, Edwin Knoppert wrote:
I would recommend the SQLite engine keeps returning the 0-row having
the fields from the result query (select)
It does not seem to do that when there was no data returned.
At the end my goal would be to enumerate the fieldnames + it's
tablename.
As far is i know, msaccess does this.
your question is very confusing, at least to me. It seems that you want
to get the names of the table and the columns even when no rows are
returned. But you already know the names of the table and the columns
otherwise you wouldn't have been able to make the query in the first
place!
MS-Access is a strange beast, and not the best of examples to use as a
benchmark for SQLite.
MS-Access is designed for desktop use by end-users, and as such, it
happily violates a fair number of standards all the while concentrating
on making things easy for the end-user (on which, the jury is mixed).
SQLite is a server. Its focus would be on sticking to the standards as
much as possible while delivering the results as fast as possible. Now,
it is up to the user (not the end-user) to create a program based on
SQLite that may or may not be as friendly as MS-Access to the end-user.
Would it be fair for me to say, "I still think it is a bug that
MS-Access doesn't run on my Mac!"?
--
Puneet Kishor