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

[amorosik]

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?

 

[amorosik]

.... I just cannot see it done using one simple query...

It may also be that it is not possible to do so

 

[Mahares]

It may also be that it is not possible to do so

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.

 

[amorosik]

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.

"..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

 

[LucaMs]

No, If you and I can't solve a problem, it doesn't mean that this problem is unsolvable

But there are countless cases where a single query just isn't enough.

 

[Andrew (Digitwell)]

"..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

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.