Page 1 of 1

Multiple SQL queries for Tabular Report

Posted: Sun Apr 08, 2018 2:37 pm
by admin

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