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.


sqlite-users mailing list

Reply via email to