In Development
Last Updated: 08 May 2024 14:11 by ADMIN
Scheduled for 2024 Q2
Clint Singer
Created on: 15 Feb 2024 10:49
Type: Bug Report
Web Designer's SqlDataSource wizard Execute Query throws a PostgreSQL error when the query contains non-string parameters

My PostgreSQL query contains an Integer parameter. In the Standalone Designer, it executes successfully both in design and in preview.

In the Web Designer, the same report is also previewed successfully. When I try to configure the SqlDataSource though, if I run the Execute Query in the final step, the database returns an error stating '...operator does not exist: integer = text...'

If the parameter is String, the query runs fine in design time of the Web Designer as well.