B4J Question Query that returns only the column names that have never been evaluated

amorosik

Expert
Licensed User
I need a query that returns, given the name of a table in the db, all the names of the fields that have never been filled in any row of the data present
Basically the fields I could also delete because at the moment they don't contain any information
How to make a unique query that spits out the above?
 
Last edited:
Sort by date Sort by votes
M

Mahares

Expert
Licensed User
Longtime User
amorosik said:
It may also be that it is not possible to do so
Click to expand...
What difference does it make, two queries or one in this case. You are not going to gain any time. You seem to insist that you can only be satisfied if only one query does it. If there was a one query solution, someone would have given it to you after some 60 posts by now.
 
Upvote 0

amorosik

Expert
Licensed User

"..What difference does it make.."
The same difference as between solving a problem and not solving it

"..someone would have given it to you after some 60 posts by now.."
No, If you and I can't solve a problem, it doesn't mean that this problem is unsolvable
 
Upvote 0

Andrew (Digitwell)

Well-Known Member
Licensed User
Longtime User
amorosik said:
"..someone would have given it to you after some 60 posts by now.."
No, If you and I can't solve a problem, it doesn't mean that this problem is unsolvable
Click to expand...
This is true.
This is an SQL(lite) specific problem rather than a B4X specific problem so your best answer may be found on a SQL(lite) forum.

If you do find a solution, I'd love to hear what it is.
 
Upvote 0
You must log in or register to reply here.

Similar Threads

S
  • Question
B4J Question SD SQL
Replies
2
Views
186
spiroskaras
S
  • Solved
B4J Question [SOLVED] SQLite does not understand SQL syntax
Replies
5
Views
1K
Mahares
M
S
  • Question
B4J Question SOLVED - config.properties - Error in SQL sentence (INSTR function)
Replies
4
Views
1K
Serinter
S
  • Question
B4J Question [SOLVED]SQL question...
Replies
16
Views
899
rbghongade
R
  • Question
B4J Question Microsoft SQL Query
Replies
7
Views
2K
Ronald Berardinis
R
Menu
Log in
Register
Cookies are required to use this site. You must accept them to continue using the site. Learn more…