I’m binding several fields to SQL statements, and in the interest of code re-use would like to be able to use the same statement even when a particular column does not exist in the database. The fallback field works well for null values in a column. But what about when the column doesn’t even exist? Is there a way to handle situations like this?
The best way would be to query the schema information and construct queries from there. But there is another, indirect way that works…
Here is an excerpt from a table:
Thank you, Jordan. I’m not completely sure I understand this yet, so I’m going to have to stare at it for a little longer, but it may work in my situation.
Yeah, doing sub-queries like this is not especially my forte. I just hit on this once upon a time and said “I ouhgta write that down”… It was one of those few times I actually wrote it down!