Logo SQLinForm

 

Re: Indent subselect in Brackets grayed out

Indent subselect in Brackets grayed out
December 06, 2016 10:17PM
Hello,

I notice in the WITH | Sub-SELECT section of formatting options that "Indent subselect in Brackets" is grayed out/disabled unless the "After (" option is checked. Is there a reason why this behavior would be tied to the "After (" checkbox? I currently have the "Before (" and and "After )" boxes checked. I would like to be able to display

SELECT tblBDSTEPS_Category.CategoryID,
tblBDSTEPS_Category.Category,
(SELECT DISTINCT COUNT([Subjects.StudyID]) AS Expr1
FROM Subjects
INNER JOIN (Diagnoses
INNER JOIN tblBDSTEPS_CategoryCode AS CC
ON Diagnoses.Code = CC.Code)
ON Subjects.StudyID = Diagnoses.StudyID
WHERE CC.CategoryID= tblBDSTEPS_Category.CategoryID AND
Subjects.DateEntered BETWEEN #9/1/2014# AND #8/31/2015#)

AS P1,
(SELECT DISTINCT COUNT([Subjects.StudyID]) AS Expr1
FROM Subjects
INNER JOIN (Diagnoses
INNER JOIN tblBDSTEPS_CategoryCode AS CC
ON Diagnoses.Code = CC.Code)
ON Subjects.StudyID = Diagnoses.StudyID
WHERE CC.CategoryID= tblBDSTEPS_Category.CategoryID AND
Subjects.DateEntered BETWEEN #9/1/2015# AND #8/31/2016#)

AS P2,

with the selections in green indented. Is this possible? Thanks!

-Bruce
Re: Indent subselect in Brackets grayed out
December 13, 2016 12:19AM
Hi Bruce,
thanks for your feedback. I will investigate this tomorrow.

Regards
Guido
Re: Indent subselect in Brackets grayed out
December 14, 2016 08:08PM
Hi Bruce,
please have a look to the new release 5.1.17.

Hope this helps
Guido
Author:

Your Email (Optional):


Subject:


Spam prevention:
Please, solve the mathematical question and enter the answer in the input field below. This is for blocking bots that try to post this form automatically.
Question: how much is 17 plus 21?
Message: