Multiple SQL queries for Tabular Report

Usage of applications: tabular, summary, chart, dashboard.
admin
Site Admin
Posts: 38
Joined: Tue Oct 17, 2017 5:21 am

Multiple SQL queries for Tabular Report

Postby admin » Sun Apr 08, 2018 2:37 pm

Hi,

At the latest verison(since V7.6) DbFace supports multiple SQL queries for tabular reports.
You can use multiple SQL queries splitted by ;.

DbFace will use the last query to generate tabular report.

Code: Select all

SET @var = 1;
SET @var = 2;
SELECT * from TABLE where column = @var