Winshuttle Support systems have migrated into Precisely systems. If you weren't automatically forwarded to the new system, please go to https://support.precisely.com to access Suppport.

How to right or Left align elements in Composer using CSS?
Form process launch plugin missing
How to display the web form in the process overview?
How to trigger email notification if the user is not added to Winshuttle foundation site?
How to add Form details on Subject line on notification emails?
How to add Users directories in the Winshuttle form for the requestor to search the user by 'NAME'?
Conversion Exit in Query does not work in Composer solution
Error: The submission request failed with the following error: Exception has been thrown by the target of an invocation.
How to use Rename Document Plugin?
performance issues on solutions or forms

Why is my SQL query not inserting data into my repeating or selectable table?

Shelby Murrell

February 18, 2019 21:49
Updated

Description

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?

Cause

This can happen when the column names in SQL are upper case, but the query text is all lowercase.

Solution

Make sure that your query text matches the case used in naming your SQL columns.

Comments

0 comments

Please sign in to leave a comment.

# Notification banner writer

Articles in this section

Description

Cause

Solution

Related articles