DBX TSQLQuery results missing fields that are defined to always return null
Posted on 2013-05-10
I have defined a query to return 15 columns. This is one of several where I have designed the queries to return like data from different tables. In some tables there is a field for full name. In others there are fields for First Name, Middle Initial, and Last Name. I have the routine that uses these fields set to see if the name parts are defined. If they are not then it reads the Full Name field and breaks out the name.
All of this has been working well. As I added a new query to the list I found I did not have all of the fields defined. I added the new fields to the query as:
Now when I run the query, all of the fields that will always return null are missing (not in the fields list)!
I am looking for a way to make this TSQLQuery.Open statement return all of the fields.