Report Table Select as Parameter in Report

Ignition
1

Hii all

I want to select Report Table from Viewer and than Report Show.

Here is Simple script:-

SELECT * FROM ?
where t_stamp between ? and ?
order by t_stamp asc

Its Given Error for Syntax please guide me for this.

2

Question-mark substitution (secure substitution by the JDBC driver) cannot work on SQL structure, just values. So the first question mark in your query is not allowed. You may be able to use curly-brace substitution for that part, but be aware that this is a security hole in your application.

2 Likes
3

hii

I am try to used curly-brace but same error through.

4

Please show the “full” error report.