On 2018/02/23 2:46 PM, M wrote:
sqlite has an integral problem, field names cannot be selected each
one inside a program, there is way to do it, but it is not straight
and complicates the software programs, and makes the program
complicated and not readble.
when you try to do something with the selected fields/columns, a lot
of code can be reduced, if only there where field names - the ability
to work with them directly.
Let me get this straight: Are you saying the query "SELECT Field1,
Field2, Field3 FROM myTable;" does not work for you, but "SELECT * FROM
myTable;" does?
or, are you saying that both queries work fine, but you have no way of
telling what the names (Field1, Field2, etc.) are once you receive the data?
Both of these are of course utterly possible in SQLite and required in
principle by any SQL RDBMS system - so if possible, could you perhaps
post some small bit of code that illustrates what happens for you and
say what it is that you expect to happen/be possible but that isn't
working (even perhaps code that works for MySQL/PostGres/etc.).
Anything to make more clear what you mean so we will be able to show how
it works in sqlite.
Kindly also mention your programming platform, OS and any other relevant
information you can think of. The more you say, the easier for us to help.
Cheers,
Ryan
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users