I am using a data connection to my SQL database and I want to query the database and insert the results into a selectable or repeating table, but I notice that when I run the query, nothing comes back, but I see that the data has been read in the logs. Why?
This can happen when the column names in SQL are upper case, but the query text is all lowercase.
Make sure that your query text matches the case used in naming your SQL columns.
Please sign in to leave a comment.